{"action":"closed","issue":{"url":"https://api.github.com/repos/matomo-org/matomo/issues/13717","repository_url":"https://api.github.com/repos/matomo-org/matomo","labels_url":"https://api.github.com/repos/matomo-org/matomo/issues/13717/labels{/name}","comments_url":"https://api.github.com/repos/matomo-org/matomo/issues/13717/comments","events_url":"https://api.github.com/repos/matomo-org/matomo/issues/13717/events","html_url":"https://github.com/matomo-org/matomo/issues/13717","id":381052804,"node_id":"MDU6SXNzdWUzODEwNTI4MDQ=","number":13717,"title":"Archive Cron - MySQL server has gone away","user":{"login":"futureweb","id":1698881,"node_id":"MDQ6VXNlcjE2OTg4ODE=","avatar_url":"https://avatars0.githubusercontent.com/u/1698881?v=4","gravatar_id":"","url":"https://api.github.com/users/futureweb","html_url":"https://github.com/futureweb","followers_url":"https://api.github.com/users/futureweb/followers","following_url":"https://api.github.com/users/futureweb/following{/other_user}","gists_url":"https://api.github.com/users/futureweb/gists{/gist_id}","starred_url":"https://api.github.com/users/futureweb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/futureweb/subscriptions","organizations_url":"https://api.github.com/users/futureweb/orgs","repos_url":"https://api.github.com/users/futureweb/repos","events_url":"https://api.github.com/users/futureweb/events{/privacy}","received_events_url":"https://api.github.com/users/futureweb/received_events","type":"User","site_admin":false},"labels":[{"id":112370560,"node_id":"MDU6TGFiZWwxMTIzNzA1NjA=","url":"https://api.github.com/repos/matomo-org/matomo/labels/Enhancement","name":"Enhancement","color":"bfd4f2","default":false},{"id":112370562,"node_id":"MDU6TGFiZWwxMTIzNzA1NjI=","url":"https://api.github.com/repos/matomo-org/matomo/labels/c:%20Performance","name":"c: Performance","color":"ededed","default":false}],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":{"url":"https://api.github.com/repos/matomo-org/matomo/milestones/119","html_url":"https://github.com/matomo-org/matomo/milestone/119","labels_url":"https://api.github.com/repos/matomo-org/matomo/milestones/119/labels","id":3622773,"node_id":"MDk6TWlsZXN0b25lMzYyMjc3Mw==","number":119,"title":"3.9.0","description":"","creator":{"login":"mattab","id":466765,"node_id":"MDQ6VXNlcjQ2Njc2NQ==","avatar_url":"https://avatars3.githubusercontent.com/u/466765?v=4","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},"open_issues":52,"closed_issues":2,"state":"open","created_at":"2018-09-05T00:21:58Z","updated_at":"2018-11-22T19:33:57Z","due_on":null,"closed_at":null},"comments":4,"created_at":"2018-11-15T08:36:18Z","updated_at":"2018-11-22T19:33:57Z","closed_at":"2018-11-22T19:33:57Z","author_association":"CONTRIBUTOR","body":"Hey there,\r\nsince a few weeks (not 100% sure if it started when we updated to 3.6.1 but it seems like?!) my \"core:archive\" Cronjob is giving me a nightly\"  [Zend_Db_Statement_Mysqli_Exception] Mysqli prepare error: MySQL server has gone away\" ... \r\n- Cron is set to run hourly.\r\n- MariaDB isn't restarted or something (and no Errors)\r\n- no problems with Stats logging\r\n\r\nFrom what I saw - it seems like sometimes the Cron is running into another long running \"core:archive\" Job which is causing troubles.\r\n\r\nWhen this happens I see 2 long running SQL Threads doing:\r\nOPTIMIZE TABLE piwik_archive_numeric_2012_01,piwik_archive_numeric_2012_02,piwik_archive_num...\r\n\r\nBoth waiting for \"getting table lock\" ... guess they stand out against each other ...\r\nFor now I try to extend Cron Times to 1.5 Hours and see if it helps ...\r\n\r\nBut woud it be possible to implement an \"Archive Job already running\" LOCK or something like that? Guess this should also help with such problems?\r\n\r\nthx, bye from Austria\r\nAndreas Schnederle-Wagner"}}
{"actor":{"display_login":"tsteur"}}