Why am I getting the RemoveVideoArchiveWorker failed exception?
If the Maintenance service crashes and you see the following exception:
2020-06-17 01:30:32,535 [53] ERROR - GLOBAL Handled exception. message: RemoveVideoArchiveWorker(173282) failed!, Failure count: 4, Retry at: Never. Exception type: BriefCam.DBDotNet.DBException. Exception message: Exception while accessing DB. rethrowing....
Or if you can identify that the last thing it logged before crashing was:
2020-06-17 01:30:08,284 [38] INFO - GLOBAL RemoveVideoArchiveWorker(173285) Started, Triggered by: RemoveVideoArchiveScheduler, 100 items detected
Carry out the following steps:
Create an index on the bc fetching tasks as follows:
create index if not exists bc_fetching_tasks_cam_idx on bc_fetching_tasks(cameraid, starttime, endtime);Shutdown the VSService and IIS.
Run vacuum on all the databases using the following syntax (this may take a while to complete):
vacuum full verbose;