Hi, I got some problem with the archive.php cron so I updated my cron task to use the console core:archive. was working fine for couple hours and then I got similar problem.
Mostly the error is “Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction”
This is happening since I updated to the latest version (2.10.0)
Here is the Log from the cron:
ERROR CoreConsole[2015-01-16 01:21:39] Got invalid response from API request: http://####/index.php?module=API&method=API.get&idSite=14&period=day&date=last52&format=php&token_auth=####&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:87:“Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction”;}'
ERROR CoreConsole[2015-01-16 01:21:39] Empty or invalid response ‘’ for website id 14, Time elapsed: 53.571s, skipping
ERROR CoreConsole[2015-01-16 01:22:33] Got invalid response from API request: http://####/index.php?module=API&method=API.get&idSite=17&period=day&date=last52&format=php&token_auth=####&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:87:“Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction”;}'
ERROR CoreConsole[2015-01-16 01:22:33] Empty or invalid response ‘’ for website id 17, Time elapsed: 53.885s, skipping
ERROR CoreConsole[2015-01-16 01:24:28] Got invalid response from API request: http://####/index.php?module=API&method=API.get&idSite=19&period=day&date=last52&format=php&token_auth=####&trigger=archivephp. Response was 'a:2:{s:6:“result”;s:5:“error”;s:7:“message”;s:87:“Mysqli statement execute error : Lock wait timeout exceeded; try restarting transaction”;}'
ERROR CoreConsole[2015-01-16 01:24:28] Empty or invalid response ‘’ for website id 19, Time elapsed: 54.016s, skipping
ERROR CoreConsole[2015-01-16 01:46:07] 6 total errors during this script execution, please investigate and try and fix these errors.
ERROR CoreConsole[2015-01-16 01:46:07] 6 total errors during this script execution, please investigate and try and fix these errors.
Thanks