Hi guys,
I'm running Revive 3.0.2.
We're having an issue we need resolved urgently. Our stats haven't been updating, though maintenance appears to be running.
The data appears to all be in 'rv_data_bkt_m' table, but isn't getting processed/moved. Looking in our debug.log, we're getting an error and I can't seem to find out how to fix it. Here's the log info:
Sep 29 14:07:06 +1100 OX-5428ccda99317 [ info] Running Automatic Maintenance Task
Sep 29 14:07:06 +1100 OX-5428ccdab48b7 [ info] Automatic Maintenance Task not run: could not acquire lock
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Running Maintenance Engine
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Running Maintenance Statistics Engine
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - Maintenance statistics will be run
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - The intermediate table statistics will be updated
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - The final table statistics will be updated
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - The rv_data_bkt_a table is a raw data table. Data logged in real-time, not operation intervals.
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - Accordingly, pruning of the rv_data_bkt_a table will be performed based on data that has a logged date between
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] 2014-09-29 02:00:00 UTC and 2014-09-29 02:59:59 UTC
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - The rv_data_bkt_a_var table is a raw data table. Data logged in real-time, not operation intervals.
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] - Accordingly, pruning of the rv_data_bkt_a_var table will be performed based on data that has a logged date between
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] 2014-09-29 02:00:00 UTC and 2014-09-29 02:59:59 UTC
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ error] ERROR: Could not migrate aggregate bucket data from the 'rv_data_bkt_c', 'rv_data_bkt_m', 'rv_data_bkt_r' bucket table(s)
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ error] Error message was: MDB2 Error: constraint violation
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData
Sep 29 14:07:06 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns
Sep 29 14:07:07 +1100 OX-maintenance-5428ccda99317 [ info] - Managing (activating/deactivating) campaigns
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Maintenance Statistics Engine Completed (Started at 2014-09-29 03:07:06 UTC)
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Running Maintenance Priority Engine
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions
Sep 29 14:08:03 +1100 OX-maintenance-5428ccda99317 [ info] - Selecting Zones forecasts for all managers for OI from 2014-09-29 03:00:00 to 2014-09-29 03:59:59
As you can see we're getting a "constraint violation" error. We're also getting "Automatic Maintenance Task not run: could not acquire lock" and I'm not sure if that's related too. I can't figure out why this is happening. I've tried all solutions I could find on the internet and these forums, but nothing worked for me.
If anyone has any ideas on how to solve this, it would be greatly appreciated.
Thanks in advance,
Jay.