zmfilter error

[tommisgr]

For some days now I keep getting the following errors on my syslog

zmfilter_7[8494]: ERR [Failure to load Object record for 158303: Reason: Lock wait timeout exceeded; try restarting transaction]

zmfilter_5[8470]: ERR [Src path /var/cache/zoneminder/events/20/2021-11-05/158298 does not exist.]

I have filter setup to clean my installation disk (SSD) by moving older events (5 days) and If disk over a limit (65%)
5 move to different disk after 5 days
7 move to different disk when disk over % limit full

As u can see from the log the move of files has been halted (files from 2021-11) still on ssd

The numbers of event keep rising the move of files is done and the target of the filter (scr path) are as expected emtpy since files have been moved to other disc

Is this a issue with mysql?
How can I resolve it?
Any pointer would be welcome.

Addidtionaly when I try to delete the records by running from web the list event and then deleting some I get
web_php[22664].ERR [10.10.10.11] [SQL-ERR 'SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction', statement was 'DELETE FROM Events WHERE Id = ?' params:158307] at /usr/share/zoneminder/www/includes/database.php line 161

When I change the filter to avoid the dates with missing events the filters run ok.
So the question is how to fix the mising event in the sql db

[Magic919]

Sounds like your DB can't keep up.

If you want to get the FS and DB back in sync, run zmaudit. I'd suggest not running the filters at all when doing so.