Stats Not Updating

[DanM2]

Hello!  My employer has been using Revive Adserver for a long time (well before I started early in the year), where over the past couple of months I have been able to successfully migrate it to a new server and perform an upgrade to the latest version with no issues (at least, no issues with the software).  A few weeks ago, we came across an issue where stats hadn't migrated for a couple of weeks, which was quickly fixed by running maintenance manually and adjusting its settings.

 

Things were running with no issues until this past Thursday, where it looks like the server it resides on was rebooted in the evening (which I am trying to see why this had happened).  Since that reboot, the ox_data_bkt_m table has been recording values as expected, however maintenance runs following that have not migrated data.  The debug.log shows "Automatic Maintenance Task not run: could not acquire lock" around that time, which makes sense if that was being run before MySQL was fully running.  

 

Here is a set of the debug.log outputs following the reboot:

 

Nov 26 21:05:00 -0500 OX-547686ccc9a95 [     info]  Running Automatic Maintenance Task

 

 

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Running Maintenance Engine

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Running Maintenance Statistics Engine

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  - Maintenance statistics will be run

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  - The intermediate table statistics will be updated

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  - The final table statistics will be updated

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]      - The ox_data_bkt_a table is a raw data table. Data logged in real-time, not operation intervals.

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]      - Accordingly, pruning of the ox_data_bkt_a table will be performed based on data that has a logged date between

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]        2014-11-27 01:00:00 UTC and 2014-11-27 01:59:59 UTC

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]      - The ox_data_bkt_a_var table is a raw data table. Data logged in real-time, not operation intervals.

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]      - Accordingly, pruning of the ox_data_bkt_a_var table will be performed based on data that has a logged date between

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]        2014-11-27 01:00:00 UTC and 2014-11-27 01:59:59 UTC

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [    error]     ERROR: Could not migrate aggregate bucket data from the 'ox_data_bkt_c', 'ox_data_bkt_m', 'ox_data_bkt_r' bucket table(s)

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [    error]     Error message was: MDB2 Error: Array

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageConversions

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageConversions

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_SummariseFinal

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_SummariseFinal

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_LogCompletion

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_LogCompletion

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns

Nov 26 21:05:01 -0500 OX-maintenance-547686ccc9a95 [     info]  - Managing (activating/deactivating) campaigns

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Maintenance Statistics Engine Completed (Started at 2014-11-27 02:05:01 UTC)

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Running Maintenance Priority Engine

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions

Nov 26 21:05:18 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting Zones forecasts for all managers for OI from 2014-11-27 02:00:00 to 2014-11-27 02:59:59

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Inserted 10362 rows in the table tmp_ad_zone_impression

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting Zones forecasts for all managers for OI from 2014-11-27 02:00:00 to 2014-11-27 02:59:59

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  - Selecting All Managers

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '9' for manager 4

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '8' for manager 4

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '7' for manager 4

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '6' for manager 4

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '9' for manager 3

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '8' for manager 3

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '7' for manager 3

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '6' for manager 3

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '9' for manager 6

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '8' for manager 6

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '7' for manager 6

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '6' for manager 6

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '9' for manager 7

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '8' for manager 7

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '7' for manager 7

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]    - Selecting active campaigns with priority = '6' for manager 7

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  - Selecting Managers with ECPM priority campaigns running

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Maintenance Priority Engine Completed (Started at 2014-11-27 02:05:01 UTC)

Nov 26 21:05:23 -0500 OX-maintenance-547686ccc9a95 [     info]  Maintenance Engine Completed (Started at 2014-11-27 02:05:01 UTC, taking 00:00:22)

Nov 26 21:05:23 -0500 OX-547686ccc9a95 [     info]  Automatic Maintenance Task Completed

 

 

With anything I've looked up, I haven't been able to find any further information past running maintenance manually, which has not helped.  Any assistance or direction would be greatly appreciated.  Thank you!

[DanM2]

In an update to this situation, I ran a check and auto-repair on the database itself in case of any issues, where a few row counts were altered slightly.  Manual maintenance didn't seem to help much after, but it appears that I had success with the republish.php script which I saw referenced in another thread, used as follows:

 

php /home/xxxxxxx/live/scripts/maintenance/tools/republish.php hostname '2014-11-26 00:00:00' '2014-12-02 23:59:59'

 

For a period of time, yesterday's stats weren't coming up nor were today's save for what appears to have been an hour's worth.  But as I ran scripts one more time before posting, they all came as well.  This appears like it can be chalked up to a database table issue that likely occurred after the reboot.  I just wanted to update this with what happened in case anyone comes across this in the future, as well as bring the above script to light since save the post I came across randomly from a few years ago on a Google search, there doesn't appear to be any information on it outside of that post.