{"action":"created","issue":{"url":"https://api.github.com/repos/piwik/piwik/issues/10125","repository_url":"https://api.github.com/repos/piwik/piwik","labels_url":"https://api.github.com/repos/piwik/piwik/issues/10125/labels{/name}","comments_url":"https://api.github.com/repos/piwik/piwik/issues/10125/comments","events_url":"https://api.github.com/repos/piwik/piwik/issues/10125/events","html_url":"https://github.com/piwik/piwik/issues/10125","id":153183910,"number":10125,"title":" General error: 1205 Lock wait timeout exceeded","user":{"login":"arvindsarangi14","id":16887541,"avatar_url":"https://avatars.githubusercontent.com/u/16887541?v=3","gravatar_id":"","url":"https://api.github.com/users/arvindsarangi14","html_url":"https://github.com/arvindsarangi14","followers_url":"https://api.github.com/users/arvindsarangi14/followers","following_url":"https://api.github.com/users/arvindsarangi14/following{/other_user}","gists_url":"https://api.github.com/users/arvindsarangi14/gists{/gist_id}","starred_url":"https://api.github.com/users/arvindsarangi14/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/arvindsarangi14/subscriptions","organizations_url":"https://api.github.com/users/arvindsarangi14/orgs","repos_url":"https://api.github.com/users/arvindsarangi14/repos","events_url":"https://api.github.com/users/arvindsarangi14/events{/privacy}","received_events_url":"https://api.github.com/users/arvindsarangi14/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":10,"created_at":"2016-05-05T07:38:20Z","updated_at":"2016-05-23T05:41:47Z","closed_at":null,"body":"Hi team,\r\n\r\nWe are getting the below mentioned error on regular basis :\r\n\r\n **[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:**\r\n\r\nWhen 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.\r\n\r\nWe 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.\r\n\r\nCould 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.\r\n"},"comment":{"url":"https://api.github.com/repos/piwik/piwik/issues/comments/220891585","html_url":"https://github.com/piwik/piwik/issues/10125#issuecomment-220891585","issue_url":"https://api.github.com/repos/piwik/piwik/issues/10125","id":220891585,"user":{"login":"mattab","id":466765,"avatar_url":"https://avatars.githubusercontent.com/u/466765?v=3","gravatar_id":"","url":"https://api.github.com/users/mattab","html_url":"https://github.com/mattab","followers_url":"https://api.github.com/users/mattab/followers","following_url":"https://api.github.com/users/mattab/following{/other_user}","gists_url":"https://api.github.com/users/mattab/gists{/gist_id}","starred_url":"https://api.github.com/users/mattab/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mattab/subscriptions","organizations_url":"https://api.github.com/users/mattab/orgs","repos_url":"https://api.github.com/users/mattab/repos","events_url":"https://api.github.com/users/mattab/events{/privacy}","received_events_url":"https://api.github.com/users/mattab/received_events","type":"User","site_admin":false},"created_at":"2016-05-23T05:41:47Z","updated_at":"2016-05-23T05:41:47Z","body":"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/3https://forum.piwik.org/t/parsing-logs-very-slow-when-using-multithread-import-script/19182/3"}}
{"actor":{"display_login":"mattab"}}