Maintenance script not running

[sona1990]

Hi, 

I m using revive adserver 3.0.5 on ubuntu 20.04 with php 5.6 and mysql 5.7 with table type MYISAM, I m facing issue where my impressions and clicks stats are not getting updated, I have scheduled my cronjob for maintenance to run run every hour but in debug.log i can see its not running properly

 

^{May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  Running Maintenance Engine
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  Running Maintenance Statistics Engine
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  - Maintenance statistics will be run
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  - The intermediate table statistics will be updated
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  - The final table statistics will be updated
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements
May 30 14:13:53 +0530 OX-maintenance-5ed21cc986c67 [     info]  Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData}

^{May 30 14:14:02 +0530 OX-maintenance-5ed21cd2c3d46 [     info]  Maintenance Engine not run: could not acquire lock}

^{May 30 14:14:09 +0530 OX-maintenance-5ed21cd92d6b1 [     info]  Maintenance Engine not run: could not acquire lock}
 

 

[andrewatfornax]

Yes, the maintenance script is reporting that it cannot lock the table so that it can make changes.

This because MyISAM tables only support table-level locking, so if you have these tables being accessed for delivery at the same time as maintenance is running, maintenance cannot lock the tables.

Maybe consider InnoDB?