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

General error: 1205 Lock wait timeout exceeded -> system check diagnostic for innodb_lock_wait_timeout #10125

Closed
arvindsarangi14 opened this issue May 5, 2016 · 11 comments
Closed

General error: 1205 Lock wait timeout exceeded -> system check diagnostic for innodb_lock_wait_timeout #10125

arvindsarangi14 opened this issue May 5, 2016 · 11 comments
Labels
answered For when a question was asked and we referred to forum or answered it. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Milestone
Backlog (Help wan...

Comments

@arvindsarangi14
Copy link

Hi team,

We are getting the below mentioned error on regular basis :

[error] [client 172.28.14.138] Error in Piwik (tracker): Error query: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction In query:

When this happens, it impacts the application which the Piwik is monitoring and business of our clients gets affected. Our application fails to loads as Piwik continuously tries to throw this error. We have to restart Piwik and our applications to get it back up.

We are using piwik 2.16.0 version. Our application send around 25,000 requests to Piwik on a daily basis and we have around 200gb of space alloted to Piwik Database.

Could you please suggest why this issue occurs and if this known issue with piwik could you let me know the version in which this would be fixed.
@tsteur
Copy link
Member

tsteur commented May 5, 2016

Can you show us the output of SHOW FULL PROCESSLIST when this happens?

What's the value of your innodb_lock_wait_timeout setting?

There's a similar issue here #8010 but it was not tackled.

@arvindsarangi14
Copy link
Author

innodb_lock_wait_timeout =50
Currently I don't have the output of SHOW FULL PROCESSLIST.
But when this issue had happened there were around 300-400 entries.

@tsteur
Copy link
Member

tsteur commented May 8, 2016

It will be interesting to see the output of processlist. Feel free to email us to hello at piwik.org in case it is a problem to paste it here. Just leave a comment here so we can check the spam folder if needed. Are you using regular JavaScript tracking method? Which MySQL version are you using?

@arvindsarangi14
Copy link
Author

My MYSQL version is 5.5.19 and yes i am using the regular JavaScript tracking method.

@tsteur
Copy link
Member

tsteur commented May 9, 2016

Thx for letting us know. The output of process list would be really helpful to investigate further.

@arvindsarangi14
Copy link
Author

arvindsarangi14 commented May 10, 2016 •
edited

ShowProcess.txt
This the process list output when the issue had occurred.

@tsteur
Copy link
Member

tsteur commented May 10, 2016

Thx for this! Can you check whether the table is using InnoDB engine?

@arvindsarangi14
Copy link
Author

SHOWTableStatus.xlsx
Show Table Status output excel.

@tsteur
Copy link
Member

tsteur commented May 12, 2016

Thank you, that looks all good.

I would recommend you have eg a read here http://stackoverflow.com/questions/13234290/lots-of-query-end-states-in-mysql-all-connections-used-in-a-matter-of-minutes This seems more like a server issue to me than an issue in Piwik. I would maybe also recommend to try asking the same in our forums https://forum.piwik.org/ as some more people will see it there and they maybe had similar problems.

@mattab
Copy link
Member

mattab commented May 23, 2016 •
edited

If you get this error while importing server logs, reducing the --max-payload parameter value may help. See forum post: https://forum.piwik.org/t/parsing-logs-very-slow-when-using-multithread-import-script/19182/3

@mattab mattab changed the title General error: 1205 Lock wait timeout exceeded General error: 1205 Lock wait timeout exceeded -> system check diagnostic for innodb_lock_wait_timeout Jul 14, 2016
@mattab mattab added the Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc. label Jul 14, 2016
@mattab mattab added this to the Long term milestone Jul 14, 2016
@mattab mattab modified the milestones: Mid term, Long term Dec 5, 2016
@mattab mattab mentioned this issue Oct 19, 2017
Closed
@mattab
Copy link
Member

mattab commented Dec 11, 2017

Should not be a Piwik issue

@mattab mattab closed this as completed Dec 11, 2017
@mattab mattab added the answered For when a question was asked and we referred to forum or answered it. label Dec 11, 2017
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. Enhancement For new feature suggestions that enhance Matomo's capabilities or add a new report, new API etc.
Projects
None yet
Milestone
Backlog (Help wanted)
Development

No branches or pull requests
3 participants
@tsteur @mattab @arvindsarangi14