Page 1 of 1

Error loading event recorded video

Posted: Tue Jun 03, 2025 3:29 pm
by vgimenez
First of all, sorry for my english level.

I'm new as admin with ZoneMinder. I'm using v1.34 and i know that it is a unsupported version. I have a problem when i try to load any video-event.

I have few cameras that records short video (5 seconds more or less), but i have two cameras that records events with 10 minutes duration. Thought interface web, when i want to see an event with short duration, i can see it, but when i want to see a event with long duration, i can't view it.

In error.log from apache2, i can see the error: "Unable to connect to ZM DB SQLSTATE[HY000] [1040] Too many connections".

I check the mysql config and it support 150 connections. I already have 80~85 connections. The user database hasn't connection limit (max_user_connections = 0).

the zoneminder daemon is running and zmc processes is running too.

ZoneMinder works fine: it is recording, web interface runs ok, short video-events can be loaded, only long video-events doesn't load.

I don't know where is the problem. This system has been working for several years, it is only now that it has started to show this error.

Thanks for any help!

Re: Error loading event recorded video

Posted: Tue Jun 03, 2025 9:50 pm
by dougmccrary
It's been a while, but I seem to remember increasing the mySQL connection limit got around this.
It was pretty easy as I recall - google it.

Re: Error loading event recorded video

Posted: Wed Jun 04, 2025 9:23 am
by vgimenez
I did it but isn't fix it.

I've found the solution. When I use Google Chrome in ZoneMinder and i try to load that videos, the browser enter in a loop with multiple conections over the database and increase and increase raise to the conections and query limit, in this moment the server responses "too many connections". If I use another browser like Mozilla Firefox, isn't happend.

I think i've receive any update on our antivirus software or anything that crashes the Google's browser with mysql connections.

Easy solution: stop using Google Chrome for ZoneMinder.

Re: Error loading event recorded video

Posted: Wed Jun 04, 2025 10:18 pm
by dougmccrary
That's new(ish).
Thanks for the update.