Nightly DB Maintenance still running despite being turned off

LabKey Support Forum (Inactive)
Nightly DB Maintenance still running despite being turned off Ben Bimber  2010-08-16 11:25
Status: Closed
 
We're running a big data upload for the EHR. I have turned off daily maintenance in the admin console during this process (the import runs periodic analyze). However, the nightly maintenance is still running. Do I need to turn it off somewhere else? Do I need to bounce tomcat for that to take effect? Can I query something in postgres to verify whether maintenance is actually turned off or not?

Thanks.
 
 
adam responded:  2010-08-16 14:15
This query should show you the system maintenance status and time properties:

   SELECT * FROM prop.propertyentries WHERE category = 'SiteConfig' AND name ilike 'systemMaintenance%';

I suspect the values in the database are correct. It looks like the code that saves the system maintenance settings does not correctly detect changes to the interval properties and, therefore, doesn't reset the timer after interval changes. I'll fix this for 10.3, but in the mean time you can either 1) restart your server or 2) change the system maintenance time property to force a timer reset.

Sorry for the inconvenience...

Adam
 
Ben Bimber responded:  2010-08-16 14:18
ok, thanks. i just did option 2.
 
adam responded:  2010-08-16 14:37
Sorry, I should have tested before posting... turns out the time property has the same problem. I'm afraid the only way to stop the timer is to restart your server.

As a check, from the admin console you can select [running threads] and look for the "SystemMaintenance" thread. If present, system maintenance will run at the appointed time; if not, it won't.

Adam
 
Ben Bimber responded:  2010-08-16 15:30
ok. not sure that i'll be able to restart tomcat soon. we'll have to live with it for now.