db queue size has grown larger

Current Development version likely to have breaking changes
Post Reply
keyboardgnome
Posts: 63
Joined: Sat Apr 08, 2006 10:18 pm

db queue size has grown larger

Post 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
keyboardgnome
Posts: 63
Joined: Sat Apr 08, 2006 10:18 pm

Re: db queue size has grown larger

Post 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.
dougmccrary
Posts: 1172
Joined: Sat Aug 31, 2019 7:35 am
Location: San Diego

Re: db queue size has grown larger

Post by dougmccrary »

How many cameras/framerate/resolution?
User avatar
iconnor
Posts: 2880
Joined: Fri Oct 29, 2010 1:43 am
Location: Toronto
Contact:

Re: db queue size has grown larger

Post by iconnor »

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