To configure system maintenance:
We recommend leaving all system maintenance tasks enabled, but some of the tasks can be disabled if absolutely necessary. By default, all enabled tasks run on a daily schedule at the time of day selected. You can also run system maintenance tasks manually, if needed. Use the Run all tasks link or click on an individual link to run just that task.
Available tasks may vary by implementation but could include the following. Some tasks listed here may not be available on your server, depending on the version and features enabled, and other tasks may be available.
To disable a maintenance task, uncheck the box and click Save. Some tasks, such as purging of expired API keys, cannot be disabled and are shown grayed out and permanently checked.
System maintenance runs as a pipeline job and logs progress, information, warnings, and errors to the pipeline log. To view previously run system maintenance pipeline jobs:
Note: Specifics of the date, transition hour and the amount of time the clock moves forward or back varies by locale. Learn more here:
System maintenance triggering is potentially subject to some oddities twice a year when clock time is changed. In some locales, if system maintenance is scheduled near the transition hour, such as at 2:15AM:If the user running the maintenance tasks does not have sufficient permissions, an exception will be raised. It might be similar to this:
java.sql.SQLException: User does not have permission to perform this action.
The full text of the error may include "EXEC sp_updatestats;" as well.
To resolve this, confirm the database account that LabKey Server is using to connect is a sysadmin or the dbo user. Check the application.properties file for the username/password, and use this credential to access the database directly to confirm.
As a workaround, you can set up an outside process or external tools to regularly perform the necessary database maintenance, then disable having the server perform these tasks using the System Maintenance option in the admin console.
| previousnext |
| expand allcollapse all |
