zoneminder icon indicating copy to clipboard operation
zoneminder copied to clipboard
verified publisher icon ZoneMinder

Database logging not clearing

Open basildane opened this issue 3 years ago • 2 comments

Describe Your Environment

  • Version of ZoneMinder [1.36.19]
  • How you installed ZoneMinder [PPA]
  • Full name and version of OS: [Ubuntu 20.04]
  • Browser name and version (if this is an issue with the web interface)

If the issue concerns a camera

Describe the bug LOG_LEVEL_DATABASE set to INFO LOG_DATABASE_LIMIT set to 7 Days I have 1.3 million log entries and system is slowing down.

To Reproduce Steps to reproduce the behavior:

Expected behavior I expect the log entries to be purged after 7 days old.

Debug Logs

basildane avatar Jul 06 '22 13:07 basildane

I truncated the Log table successfully. However, I would like to understand why this happened.

basildane avatar Jul 06 '22 14:07 basildane

Log deleting happens in a process called zmstats. It you are logging faster than it can delete them, then you will have a problem. check in /var/log/zm/zmstats.log for errors.

connortechnology avatar Jul 12 '22 21:07 connortechnology