Multi-storage issues and DB inconsistency
Posted: Tue Dec 07, 2021 12:45 pm
Hi there,
I have been using ZM for a while and it runs nicely. Recently, i have added a second Storage and set a filter "Move Archived to Extra" to move archived events there (when archive status equal to archived only and storage area not equal to Extra then Move all matches to Extra).
Unfortunately, there seems to be an issue in ZM when moving videos between archives: a trigger is started to recalculate storage space for each event and it seems somehow to go in loop and saturate MySQL. I had to restart ZM/MySQL several times and now i've ended up in the situation where some of the archived events cannot be played anymore because the video files have been moved to the Extra storage but the corresponding DB record has not been updated.
How can i solve this?
I have been using ZM for a while and it runs nicely. Recently, i have added a second Storage and set a filter "Move Archived to Extra" to move archived events there (when archive status equal to archived only and storage area not equal to Extra then Move all matches to Extra).
Unfortunately, there seems to be an issue in ZM when moving videos between archives: a trigger is started to recalculate storage space for each event and it seems somehow to go in loop and saturate MySQL. I had to restart ZM/MySQL several times and now i've ended up in the situation where some of the archived events cannot be played anymore because the video files have been moved to the Extra storage but the corresponding DB record has not been updated.
How can i solve this?