Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Deathlock in core:archive #9620

Closed
SR-mkuhn opened this issue Jan 22, 2016 · 2 comments
Closed

Deathlock in core:archive #9620

SR-mkuhn opened this issue Jan 22, 2016 · 2 comments
Labels
answered For when a question was asked and we referred to forum or answered it.

Comments

@SR-mkuhn
Copy link

Hiho,

we're experiencing database problems with Piwik 2.15.0 at the moment.

ERROR [2016-01-21 23:26:55] Got invalid response from API request: ?module=API&method=API.get&idSite=876&period=week&date=last2&format=php&segment=entryPageUrl%3D&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:111:"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction";}' ERROR [2016-01-22 00:00:11] 1 total errors during this script execution, please investigate and try and fix these errors.

[Exception]
1 total errors during this script execution, please investigate and try and fix these errors.

ERROR [2016-01-17 23:25:11] Got invalid response from API request: ?module=API&method=API.get&idSite=874&period=year&date=last2&format=php&segment=entryPageUrl%3D%40&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:111:"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction";}'
ERROR [2016-01-18 00:10:31] 1 total errors during this script execution, please investigate and try and fix these errors.

[Exception]
1 total errors during this script execution, please investigate and try and fix these errors.

ERROR [2016-01-15 23:47:02] Got invalid response from API request: ?module=API&method=API.get&idSite=1044&period=month&date=last2&format=php&segment=entryPageUrl%3D%40&trigger=archivephp. Response was 'a:2:{s:6:"result";s:5:"error";s:7:"message";s:111:"SQLSTATE[40001]: Serialization failure: 1213 Deadlock found when trying to get lock; try restarting transaction";}'
ERROR [2016-01-16 00:10:58] 1 total errors during this script execution, please investigate and try and fix these errors.

[Exception]
1 total errors during this script execution, please investigate and try and fix these errors.
@tsteur
Copy link
Member

tsteur commented Jan 26, 2016

Which MySQL version are you using? can you reproduce this every time the core archiver is running?

@mattab mattab closed this as completed Mar 31, 2016
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Mar 31, 2016
@mattab
Copy link
Member

mattab commented Mar 31, 2016

See also similar issue in: #6398

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees
No one assigned
Labels
answered For when a question was asked and we referred to forum or answered it.
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
3 participants
@tsteur @mattab @SR-mkuhn