eberswine Posted December 31, 2013 Report Share Posted December 31, 2013 I am not getting any stats at all. It has been two weeks since the upgrade? Please help! Quote Link to comment Share on other sites More sharing options...
eberswine Posted December 31, 2013 Author Report Share Posted December 31, 2013 I go to the database and see that impressions are being recorded? I am using 3.0.0 Quote Link to comment Share on other sites More sharing options...
Guest Posted January 1, 2014 Report Share Posted January 1, 2014 Hi eberswine , I go to the database and see that impressions are being recorded.. ? Have you run your Maintenance Task? Or else Try to run , see error log. By default stats are updated hourly once Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted January 5, 2014 Report Share Posted January 5, 2014 Yep, sounds to me like maintenance is not running, if the stats are in the database, but not in the UI. Quote Link to comment Share on other sites More sharing options...
alpha1 Posted January 22, 2014 Report Share Posted January 22, 2014 Where in the database can i find the stats exactly, im having a similar problem and would like to see if they're even being recorded. Quote Link to comment Share on other sites More sharing options...
alpha1 Posted January 22, 2014 Report Share Posted January 22, 2014 Probably related, i see this error in var/debug.log Jan 22 14:05:22 -0500 OX-52e0167224e38 [ info] Automatic Maintenance Task not run: could not acquire lock Jan 22 14:05:22 -0500 OX-52e0167228773 [ info] Automatic Maintenance Task not run: could not acquire lock Jan 22 14:05:22 -0500 OX-52e016722893e [ info] Automatic Maintenance Task not run: could not acquire lock Jan 22 14:05:22 -0500 OX-52e016722912b [ info] Automatic Maintenance Task not run: could not acquire lock Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted January 22, 2014 Report Share Posted January 22, 2014 You need to ensure that the MySQL users has 'all privileges' (except grant) on all tables in the database. Quote Link to comment Share on other sites More sharing options...
Erik Geurts Posted January 23, 2014 Report Share Posted January 23, 2014 There is no difference between daily stats and accumulating monthly stats, everything you see in the reports comes from the same database table. Quote Link to comment Share on other sites More sharing options...
alpha1 Posted January 23, 2014 Report Share Posted January 23, 2014 I open my stats and i see "There are currently no statistics available for the period 23-01-2014 to 23-01-2014" Every day since the update. I reinstalled all plugin yestarday and there should be several thousands hits since i upgraded. Where do i look to see if they're in the database at all but maybe not displayed? I upgraded the mysql user to full global privs, but it already had full database privs, except grant. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted January 25, 2014 Report Share Posted January 25, 2014 Have a look in the "data_bkt_m" table (with appropriate table name prefix, if present). This is where Revive Adserver stores the counts of impressions as they are recorded during delivery, before the maintenance engine summarises everything up. Quote Link to comment Share on other sites More sharing options...
alpha1 Posted January 28, 2014 Report Share Posted January 28, 2014 I solved my problem with no stats. You can see more in this thread: forum.revive-adserver.com/topic/215-no-stats-since-upgrade/ but basically in the upgrade, several tables did not get copied/renamed/created correctly. Quote Link to comment Share on other sites More sharing options...
Playa Posted March 15, 2014 Report Share Posted March 15, 2014 Hello everyone. I have spent many hours searching for solution on the internet and on this forums but no luck. I am having the same problem described above but none of the suggestions are applicable. Maintenance is running. The rv_data_bkt_m has the impressions counted, prefixes are all correct, it was a clean install, not an upgrade. Banners are running fine on the websites. Version number 3.0.3 The debug log shows nothing wrong: Mar 14 21:39:00 -0500 OX-5323bd4427713 [ info] Running Automatic Maintenance Task Mar 14 21:39:39 -0500 OX-5323bd6bd8915 [ info] Running Automatic Maintenance Task Mar 14 21:40:44 -0500 OX-5323bdac850e3 [ info] Running Automatic Maintenance Task Mar 14 21:41:22 -0500 OX-5323bdd20c5d4 [ info] Running Automatic Maintenance Task Mar 14 21:41:33 -0500 OX-5323bddd7d781 [ info] Running Automatic Maintenance Task Mar 14 21:41:49 -0500 OX-5323bdedbbb78 [ info] Running Automatic Maintenance Task Mar 14 21:42:25 -0500 OX-5323be11434c4 [ info] Running Automatic Maintenance Task Mar 14 21:47:14 -0500 OX-5323bf3200dce [ info] Running Automatic Maintenance Task Mar 14 21:47:25 -0500 OX-5323bf3dbde2d [ info] Running Automatic Maintenance Task Mar 14 21:47:33 -0500 OX-5323bf45427c5 [ info] Running Automatic Maintenance Task Mar 14 21:50:33 -0500 OX-5323bff9c679b [ info] Running Automatic Maintenance Task Mar 14 21:51:50 -0500 OX-5323c046beb4f [ info] Running Automatic Maintenance Task Mar 14 21:51:54 -0500 OX-5323c04a68f62 [ info] Running Automatic Maintenance Task Mar 14 21:55:10 -0500 OX-5323c10e50b79 [ info] Running Automatic Maintenance Task Mar 14 21:55:24 -0500 OX-5323c11cc2fd3 [ info] Running Automatic Maintenance Task Mar 14 21:56:57 -0500 OX-5323c179d8c2c [ info] Running Automatic Maintenance Task PLease help me out before my head explodes. Any suggestions that has not yet been posted? Thanks a bunch! Quote Link to comment Share on other sites More sharing options...
iko Posted March 16, 2014 Report Share Posted March 16, 2014 my debug log: Mar 16 22:24:49 +0100 OX-532616a1b9425 [ info] Running Automatic Maintenance Task Mar 16 22:25:05 +0100 OX-532616b1b6915 [ info] Running Automatic Maintenance Task Mar 16 22:25:05 +0100 OX-532616b1e067b [ info] Running Automatic Maintenance Task Mar 16 22:25:06 +0100 OX-532616b213a71 [ info] Running Automatic Maintenance Task Mar 16 22:25:06 +0100 OX-532616b24925a [ info] Running Automatic Maintenance Task Mar 16 22:25:21 +0100 OX-532616c139eb3 [ info] Running Automatic Maintenance Task Mar 16 22:25:21 +0100 OX-532616c151f50 [ info] Automatic Maintenance Task not run: could not acquire lock Mar 16 22:25:21 +0100 OX-532616c16522e [ info] Running Automatic Maintenance Task Mar 16 22:25:21 +0100 OX-532616c183593 [ info] Running Automatic Maintenance Task Mar 16 22:25:21 +0100 OX-532616c19475d [ info] Automatic Maintenance Task not run: could not acquire lock Mar 16 22:26:13 +0100 OX-532616f4eab24 [ info] Running Automatic Maintenance Task Mar 16 22:26:13 +0100 OX-532616f5719de [ info] Running Automatic Maintenance Task Mar 16 22:26:13 +0100 OX-532616f59f932 [ info] Running Automatic Maintenance Task Mar 16 22:26:13 +0100 OX-532616f5c6a49 [ info] Running Automatic Maintenance Task Mar 16 22:26:14 +0100 OX-532616f666f97 [ info] Running Automatic Maintenance Task Quote Link to comment Share on other sites More sharing options...
Dave Brain Posted March 20, 2014 Report Share Posted March 20, 2014 This issue was raised probably some time name constant not working some pages. You can see this link : http://www.adserveropenx.com/revive-adserver-stats-page-not-working/ This link should fix your issue. Check and put your comment here if you need any help. Quote Link to comment Share on other sites More sharing options...
adus Posted March 21, 2014 Report Share Posted March 21, 2014 Has this been fixed/reported to github yet? Quote Link to comment Share on other sites More sharing options...
Crazy-Achmet Posted March 21, 2014 Report Share Posted March 21, 2014 Does anyone else have the problem, that the debug file is full of "Running Automatic Maintenance Task" lines? Mine is around 25MB, end it get's bigger every second. I've disabled the maintenance task cause of this. Again, i don't get it why there's no statemant of a developer so far. It seems they don't care about people in this forum. From time to time they post how great everything is and how many instances Revive has now, but i haven't seen some participating over here. Quote Link to comment Share on other sites More sharing options...
benwinton Posted March 23, 2014 Report Share Posted March 23, 2014 Still having a problem. Followed all the suggestions listed, so far, in this thread, to no avail. Quote Link to comment Share on other sites More sharing options...
benwinton Posted March 23, 2014 Report Share Posted March 23, 2014 I found a solution. In the /lib file, there is a new file named RV.php that does not seemed to have existed before version 3.0.3 of Revive. The path to PEAR.php file on line 13 is coded up incorrectly. You have to put the fully qualified server path to PEAR.php in that file, eg, "require_once '/homepages/16/e34564563465/htdocs/ads/revive/lib/pear/PEAR.php'; (This is a fictional path above, for security reasons, but illustrates what the line should look like when fixed. I did not try using a fully qualified domain URL, eg, http://somedomain.com/revive/lib/pear/PEAR.php, but that might also be worth a shot to see if it works. I doubt that it will.) The only other thing I did was chmod the maintenance scripts from 755 to 777. I dont like doing that, and might try lowering them back to 755 to see if stats and automatic maintenance continues to run. Hoping this gets fixed over at GitHub, where there is a bug reported on this item, as well. Quote Link to comment Share on other sites More sharing options...
dirservgh Posted March 24, 2014 Report Share Posted March 24, 2014 Without changing rights my upate to 3.0.3 failed . No errror-message but no Plugins were installed! I changed the rights to 777( I dont know why it has to be open for everyone). Now the plugins were installed, but no new statistics and also maintance is not running! I tried to change the path in rv.php but I got a white page ERROR 500! I went back to revive 3.0.2, this is working for me without any problems! Quote Link to comment Share on other sites More sharing options...
Crazy-Achmet Posted March 25, 2014 Report Share Posted March 25, 2014 Could someone of the stuff please explain why bugs like this are getting closed on Github? https://github.com/revive-adserver/revive-adserver/issues/297 https://github.com/revive-adserver/revive-adserver/issues/294 Oh, i forgot, since the staff wasn't online for a couple of days, it seems they don't care what's going over here and what we say, think and post. Instead they are closing Github Issues and say we should post in the forum. Ridiculous! Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted April 22, 2014 Report Share Posted April 22, 2014 Does anyone else have the problem, that the debug file is full of "Running Automatic Maintenance Task" lines? Mine is around 25MB, end it get's bigger every second. I've disabled the maintenance task cause of this. Again, i don't get it why there's no statemant of a developer so far. It seems they don't care about people in this forum. From time to time they post how great everything is and how many instances Revive has now, but i haven't seen some participating over here. Hello! If you disable maintenance, Revive Adserver won't work. Maintenance needs to be run to ensure that statistics are summed up, and banner delivery priorities are re-calculated. Please see: http://documentation.revive-adserver.com/display/DOCS/Running+Maintenance As for us helping out in the forum - we provide the forum (for free) for the software we develop (for free), and we help out when we can (for free). I also have a day job that takes up 45+ hours a week. So, I do my best to make Revive Adserver as good as it can be, and to help out and answer what questions I can, when I have time. I also hope that the project grows, and more people help out and provide good answers. However, as this topic started out as an issue about missing stats in Revive Adserver 3.0.0, which was resolved by the user, but has now morphed into a discussion about the issue in 3.0.3, it's not always easy to see what's going on or be immediately responsive. Until someone offers to pay me to do this full time, I'm afraid support from the development team will have to be on a good will basis! Hoping this gets fixed over at GitHub, where there is a bug reported on this item, as well. It has been, and is fixed in Revive Adserver 3.0.4. Thanks to all who helped locate the cause and gave us the information needed to fix the issue. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted April 22, 2014 Report Share Posted April 22, 2014 Could someone of the stuff please explain why bugs like this are getting closed on Github? https://github.com/revive-adserver/revive-adserver/issues/297 https://github.com/revive-adserver/revive-adserver/issues/294 Oh, i forgot, since the staff wasn't online for a couple of days, it seems they don't care what's going over here and what we say, think and post. Instead they are closing Github Issues and say we should post in the forum. Ridiculous! See above re: my comments about the development team "not caring". Of course we care - we would not do what we do (for free) if we didn't care. (Either that, or we're all mad!). However, we do get a lot of new bug reports on GitHub, and sometimes, they just sound like requests for support. We could do support through GitHub, but if that's the case, then we're paying a lot of money (at our own expense, for free, for no reward other than personal satisfaction) for this forum! So, we'd rather close a few cases and ask people to come here first if it's not a clear cut, definitely a bug type of report. If you're able to make sure bug reports are clear cut, and include all the detail required to prove it's a bug (and even better, send a pull request with it), then this will hugely improve the Revive Adserver community for everyone, as well as making the development team more able to correctly and swiftly respond to bugs. In the mean time, when we get it wrong, and close something that actually is a bug because we think it's a support case - please accept our apologies. We're not perfect - just a few guys who love Revive Adserver, and want to do the best we can in our spare time to make it better. Cheers, Andrew Quote Link to comment Share on other sites More sharing options...
JeffOYB Posted April 28, 2014 Report Share Posted April 28, 2014 Hi! I had my OpenX upgraded to Revive a few weeks ago. I just checked my Stats and there is nothing but that notice. I am not a coder and I have low skills but I can check files for this'n'that. I already tried changing the RV.php file in relation to that bit about PEAR. It's been a couple hours, no effect. I checked my Maintenance settings and it says it's correctly set up. I'm not so hot with logs but I can try to take a look. I'm much worse with databases. But, again, I could go thru the motions to look for things. I've never fooled around with permissions, but, again, I've seen those settings from time to time, tho I couldn't tell you right now where they are. Any tips for easiest, simplest ways that a beginner could use to remedy this situation? Quote Link to comment Share on other sites More sharing options...
JeffOYB Posted April 28, 2014 Report Share Posted April 28, 2014 Here is what is in my var/debug.php log. It's neat stuff! I wish I knew what it meant. OK, for the weeks after my new install I got a lot of the same entries, which I've copied at the start. Then today I changed that line in RV.php about PEAR at about 8am. You can see where the entries suddenly change. I don't know what it means. Sorry for copying in so much, but maybe it'll give someone a sense of what is happening and what I need to do to get my Stats working again. THANKS! -- JP Apr 28 07:26:05 -0600 OX-535e56ed78d52 [ info] Running Automatic Maintenance Task Apr 28 07:28:30 -0600 OX-535e577e337a4 [ info] Running Automatic Maintenance Task Apr 28 07:29:56 -0600 OX-535e57d48b5f5 [ info] Running Automatic Maintenance Task Apr 28 07:29:56 -0600 OX-535e57d4adc9c [ info] Running Automatic Maintenance Task Apr 28 07:29:56 -0600 OX-535e57d4a9c85 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:29:57 -0600 OX-535e57d4cbfe2 [ info] Running Automatic Maintenance Task Apr 28 07:29:57 -0600 OX-535e57d5268ce [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:29:57 -0600 OX-535e57d50962f [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:30:32 -0600 OX-535e57f837b1f [ info] Running Automatic Maintenance Task Apr 28 07:35:53 -0600 OX-535e5939c2d51 [ info] Running Automatic Maintenance Task Apr 28 07:41:25 -0600 OX-535e5a8550a49 [ info] Running Automatic Maintenance Task Apr 28 07:43:02 -0600 OX-535e5ae63f1c1 [ info] Running Automatic Maintenance Task Apr 28 07:43:44 -0600 OX-535e5b10e1ac3 [ info] Running Automatic Maintenance Task Apr 28 07:44:01 -0600 OX-535e5b212f392 [ info] Running Automatic Maintenance Task Apr 28 07:52:12 -0600 OX-535e5d0ca0472 [ info] Running Automatic Maintenance Task Apr 28 07:52:12 -0600 OX-535e5d0cb5d7b [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:12 -0600 OX-535e5d0ca72f7 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:12 -0600 OX-535e5d0cb4067 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:12 -0600 OX-535e5d0cb01f1 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Running Maintenance Engine Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Running Maintenance Statistics Engine Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - Maintenance statistics will be run Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - The intermediate table statistics will be updated Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - The final table statistics will be updated Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] - Managing (activating/deactivating) campaigns Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 07:52:13 -0600 OX-maintenance-535e5d0ca0472 [ info] Maintenance Statistics Engine Completed (Started at 2014-04-28 13:52:13 UTC) Apr 28 07:52:13 -0600 OX-535e5d0ca0472 [ info] Running Midnight Maintenance Tasks Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Begin pruning old records from data_summary_ad_zone_assoc Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Finished pruning old records from data_summary_ad_zone_assoc: 0 records deleted Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Begin pruning records for expired inactive campaigns from data_summary_ad_zone_assoc Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Finished pruning expired inactive campaigns from data_summary_ad_zone_assoc: 0 records deleted Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Begin pruning records for completed inactive campaigns from data_summary_ad_zone_assoc Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Table ox_data_summary_ad_zone_assoc overhead (number of allocated but unused bytes) = 0 Apr 28 07:52:14 -0600 OX-535e5d0ca0472 [ info] Delaying Revive Adserver sync process by 13 seconds. Apr 28 07:52:27 -0600 OX-535e5d0ca0472 [ info] Sync: updates found! Apr 28 07:52:27 -0600 OX-535e5d0ca0472 [ info] Finished Revive Adserver Sync process. Apr 28 07:52:27 -0600 OX-535e5d0ca0472 [ info] Midnight Maintenance Tasks Completed Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Running Maintenance Priority Engine Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 07:52:27 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 13:00:00 to 2014-04-28 13:59:59 Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] Inserted 74 rows in the table tmp_ad_zone_impression Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 07:52:30 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 13:00:00 to 2014-04-28 13:59:59 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting All Managers Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '9' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '8' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '7' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting active campaigns with priority = '6' for manager 1 Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] - Selecting Managers with ECPM priority campaigns running Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Maintenance Priority Engine Completed (Started at 2014-04-28 13:52:13 UTC) Apr 28 07:52:33 -0600 OX-maintenance-535e5d0ca0472 [ info] Maintenance Engine Completed (Started at 2014-04-28 13:52:13 UTC, taking 00:00:20) Apr 28 07:52:33 -0600 OX-535e5d0ca0472 [ info] Automatic Maintenance Task Completed Apr 28 08:06:22 -0600 OX-535e605ece1d1 [ info] Running Automatic Maintenance Task Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Running Maintenance Engine Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Running Maintenance Statistics Engine Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Maintenance statistics will be run Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - The intermediate table statistics will be updated Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - The final table statistics will be updated Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_SetUpdateRequirements Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_MigrateBucketData Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_DeDuplicateConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageConversions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_SummariseFinal Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_LogCompletion Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Managing (activating/deactivating) campaigns Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OX_Maintenance_Statistics_Task_ManageCampaigns Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Maintenance Statistics Engine Completed (Started at 2014-04-28 14:06:23 UTC) Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Running Maintenance Priority Engine Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsLifetime Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_GetRequiredAdImpressionsDaily Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 14:00:00 to 2014-04-28 14:59:59 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Inserted 74 rows in the table tmp_ad_zone_impression Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_AllocateZoneImpressions Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting Zones forecasts for all managers for OI from 2014-04-28 14:00:00 to 2014-04-28 14:59:59 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_PriorityCompensation Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting All Managers Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '9' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '8' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '7' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting active campaigns with priority = '6' for manager 1 Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforContract Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task begin: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] - Selecting Managers with ECPM priority campaigns running Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Task complete: OA_Maintenance_Priority_AdServer_Task_ECPMforRemnant Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Maintenance Priority Engine Completed (Started at 2014-04-28 14:06:23 UTC) Apr 28 08:06:23 -0600 OX-maintenance-535e605ece1d1 [ info] Maintenance Engine Completed (Started at 2014-04-28 14:06:23 UTC, taking 00:00:00) Apr 28 08:06:23 -0600 OX-535e605ece1d1 [ info] Automatic Maintenance Task Completed Apr 28 09:08:21 -0600 OX-535e6ee4d4e89 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 09:08:21 -0600 OX-535e6ee4d55dd [ info] Running Automatic Maintenance Task Apr 28 09:08:21 -0600 OX-535e6ee50c7b0 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 09:08:21 -0600 OX-535e6ee4d9fb4 [ info] Automatic Maintenance Task not run: could not acquire lock Apr 28 09:08:21 -0600 OX-535e6ee526778 [ info] Automatic Maintenance Task not run: could not acquire lock Apr Quote Link to comment Share on other sites More sharing options...
Eliza0406 Posted April 29, 2014 Report Share Posted April 29, 2014 Hi, Restart your MYSQL , hope it is unable to manage the traffic load of your MYSQL server. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
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.