PicNic Posted March 19, 2019 Report Share Posted March 19, 2019 (edited) Hi there, I have a problem with new campains not showing. I enabled debugLog and it says: Mar 19 11:45:08 +0000 OX-maintenance-5c90d64468913 [ info] Running Maintenance Priority Engine on line 59 of "/html/openx/lib/OA/Maintenance/Priority.php" on line 34 of "/html/openx/www/admin/run-mpe.php" Mar 19 11:45:09 +0000 OX-maintenance-5c90d64468913 [ error] Unable to obtain database-level lock, not running MPE on line 79 of "/html/openx/lib/OA/Maintenance/Priority.php" on line 34 of "/html/openx/www/admin/run-mpe.php" Running Revive 4.1.4 with PHP 7.0 is more information needed? Can anyone help? Thx PicNic Edited March 19, 2019 by PicNic Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted March 20, 2019 Report Share Posted March 20, 2019 What database? Quote Link to comment Share on other sites More sharing options...
PicNic Posted March 20, 2019 Author Report Share Posted March 20, 2019 Unfortunately it is not mentioned. I guess, it is one of the tables that is needed maintening the priority engine ... I just have the log from the first post ... or ist there a different place where I can gather more information? Quote Link to comment Share on other sites More sharing options...
PicNic Posted March 21, 2019 Author Report Share Posted March 21, 2019 So ... now, I can describe a bit more the circumstances I have this campaign: fw Inside this campaign there are two banners. Linked to the zone, are these two banners and one banner from a different, remnant campaign: One banner is without delivery rule, and one has a rule that is valid: So ... both banners should be displayed, but they dont ... and in debug-log I have this error every time maintenance is running: Mar 21 09:02:08 +0000 OX-maintenance-5c93530fdb149 [ error] Unable to obtain database-level lock, not running MPE on line 79 of "/html/openx/lib/OA/Maintenance/Priority.php" on line 233 of "/html/openx/lib/OX/Maintenance.php" on line 116 of "/html/openx/lib/OX/Maintenance.php" on line 50 of "/html/openx/scripts/maintenance/maintenance.php" on line 22 of "/html/openx/maintenance/maintenance.php" or: Mar 21 08:50:26 +0000 OX-maintenance-5c9350512fde1 [ error] OA_Maintenance_Auto::run: Unable to obtain database-level lock, not running MPE on line 79 of "/html/openx/lib/OA/Maintenance/Priority.php" on line 233 of "/html/openx/lib/OX/Maintenance.php" on line 116 of "/html/openx/lib/OX/Maintenance.php" on line 63 of "/html/openx/lib/OA/Maintenance/Auto.php" on line 3298 of "/html/openx/www/delivery/lg.php" Maybe this helps you to help me ? Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted March 22, 2019 Report Share Posted March 22, 2019 Same question still - what is the database that you are using to run Revive Adserver on please? MySQL, MariDB or PostgreSQL? Quote Link to comment Share on other sites More sharing options...
PicNic Posted March 22, 2019 Author Report Share Posted March 22, 2019 Oh ... sorry ... it is MySQL ... Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted March 24, 2019 Report Share Posted March 24, 2019 Okay! MyISAM or InnoDB tables? Quote Link to comment Share on other sites More sharing options...
PicNic Posted March 24, 2019 Author Report Share Posted March 24, 2019 It is MyISAM ... Quote Link to comment Share on other sites More sharing options...
PicNic Posted March 27, 2019 Author Report Share Posted March 27, 2019 Any ideas someone? Quote Link to comment Share on other sites More sharing options...
PicNic Posted April 1, 2019 Author Report Share Posted April 1, 2019 ... still hoping that there is someone who can help me ... Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted April 3, 2019 Report Share Posted April 3, 2019 My suggestion would be to try and restart MySQL. I do remember having seen once or twice such lock being stuck and not released. Quote Link to comment Share on other sites More sharing options...
PicNic Posted April 3, 2019 Author Report Share Posted April 3, 2019 Thank you for answering. I allready did a restart and I also copied the whole account and imported the database, but behaviour is the same ... Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted April 3, 2019 Report Share Posted April 3, 2019 If you have messages stating that maintenance is complete, there is nothing you should be worrying about. You're using automatic maintenance and concurrent requests will try to trigger it: one will succeed and the others will rigthfully fail. I'd suggest disabling auto-maintenance and setting up scheduled maintenance via cron. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted April 4, 2019 Report Share Posted April 4, 2019 Ah, thanks @Matteo Beccati! I had this on my follow up list, but I can see you have answered. I was thinking about looking into the code re: the database level lock, but I completely missed the fact that this is auto maintenance! @PicNic, if you use auto maintenance, this is expected behaviour, as multiple banner deliveries are likely to trigger maintenance in parallel - but only one maintenance process is allowed to run at a time. If you move to scheduled maintenance, you should get a much clearer view that maintenance is running correctly, without the other information cluttering the logs. Quote Link to comment Share on other sites More sharing options...
PicNic Posted April 4, 2019 Author Report Share Posted April 4, 2019 Thank you all for answering. Maintenance is running via cron only: ... and unfortunately scheduled banners with delivery options are not delivered as expected ... Quote Link to comment Share on other sites More sharing options...
Matteo Beccati Posted April 4, 2019 Report Share Posted April 4, 2019 Did you just change that? Your logs where explicitly mentioning OA_Maintenance_Auto. Also 5 minutes operation interval is an extremely bad idea. Try setting it back to 60 minutes and schedule 1 cron job at minute 0. PS @andrewatfornax I really think we should remove the option. Quote Link to comment Share on other sites More sharing options...
andrewatfornax Posted April 4, 2019 Report Share Posted April 4, 2019 Agreed, we should remove the option for anything other than 60 minutes. Also, @PicNic, chances are maintenance is not finishing within 5 minutes, which may be another reason you have lock messages, as maintenance is still running when the next one tries to start. 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.