Jump to content
sona1990

Maintenance script not running

Recommended Posts

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
 

 

Share this post


Link to post
Share on other sites

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?

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.




×
×
  • Create New...