Page 1 of 1

db queue size has grown larger

Posted: Sun Nov 28, 2021 6:51 pm
by 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

Re: db queue size has grown larger

Posted: Sun Nov 28, 2021 6:54 pm
by 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.

Re: db queue size has grown larger

Posted: Sun Nov 28, 2021 9:51 pm
by dougmccrary
How many cameras/framerate/resolution?

Re: db queue size has grown larger

Posted: Sun Nov 28, 2021 11:05 pm
by iconnor
There are no limits to the db queue. That message is telling you that the db is not keeping up.