db queue size has grown larger

[keyboardgnome]

Howdy do!

I'm getting this message, in various forms, spamming my syslog and making the zoneminder system unresponsive

Here's a small sample:

Nov 28 13:47:20 zoneminder zmc_m10[2271656]: WAR [zmc_m10] [db queue size has grown larger 25 than 20 entries]
Nov 28 13:47:20 zoneminder zmc_m7[2795649]: WAR [zmc_m7] [db queue size has grown larger 65 than 20 entries]
Nov 28 13:47:20 zoneminder zmc_m9[2868253]: WAR [zmc_m9] [db queue size has grown larger 46 than 20 entries]
Nov 28 13:47:20 zoneminder zmc_m10[2271656]: WAR [zmc_m10] [db queue size has grown larger 24 than 20 entries]
Nov 28 13:47:20 zoneminder zmc_m7[2795649]: WAR [zmc_m7] [db queue size has grown larger 64 than 20 entries]
Nov 28 13:47:20 zoneminder zmc_m9[2868253]: WAR [zmc_m9] [db queue size has grown larger 45 than 20 entries]

It impacts all camera's.

The only fix so far is to restart zoneminder. I've tried increasing DB threads, etc.

Thoughts as to what may be causing the error?

Currently running 1.37.3~20211124134504-focal

[keyboardgnome]

I see in https://github.com/ZoneMinder/zoneminde ... /zm_db.cpp

The function "void zmDbQueue::process()" references this error message on or about line 258.

It appears the mQueue.size is hard set at 20, but I'm thinking this is an issue between the database and zoneminder at this point, but I'm not seeing any errors out of the DB.

[dougmccrary]

How many cameras/framerate/resolution?

[iconnor]

There are no limits to the db queue. That message is telling you that the db is not keeping up.