ZoneMinder Forums

Well, it seems to have worked for me.
I upgraded to 1.37.50~20240130093217-jammy a couple of hours ago, and memory usage has stayed pretty constant since.

Hey, are people who are experiencing this using Decoding=OnDemand? I think I found the problem, and it's because Analysis is waiting for decode and so capture thread is just filling up the queue. new package building should fix this. I am :) - thanks, will check out the new build when it's ...

I'm seeing the same issue on a system that's basically remained the same (in terms of camera and configuration) for a couple of years. I'm currently running 1.37.50~20240129103951-jammy , and I can't really tell with which release it started happening, but server memory is slowly eaten up, moving ...

All working now with no errors after installing 1.37.46~20231030102238-jammy - thanks!

Since the very latest release: # apt-cache policy zoneminder zoneminder: Installed: 1.37.46~20231027104343-jammy Candidate: 1.37.46~20231027104343-jammy The timeline view seems to all be working again now - thanks! I do see this error in the logs when accessing it though: Oct 30 12:52:58 cctv web ...

Thanks! Picked up that change today. However, I'm now getting the second error that I mentioned above (when I tried the manual tweak for the fix now in source/packaged): Oct 27 10:28:37 cctv web_php[573322]: 10/27/23, 10:28:37 AM GMT+1.454289 web_php[573322].ERR [10.10.20.1] [SQL-ERR 'SQLSTATE[21000 ...

iconnor wrote: ↑Wed Oct 25, 2023 8:31 pm Oh timeline! You said events view.. ok now i know where to look

Ah, apologies - it's the only view I use for viewing events, guess it's what I've always called it as a result (at least in my head ).

Right, so, I manually fixed that error in the file, restarted and got this error instead: Oct 25 20:37:25 cctv web_php[801]: 10/25/23, 8:37:25 PM GMT+1.211368 web_php[801].ERR [10.10.20.1] [SQL-ERR 'SQLSTATE[21000]: Cardinality violation: 1241 Operand should contain 1 column(s)', statement was ...

Yeah, super weird. This is my /usr/share/zoneminder/www/skins/classic/views/timeline.php : $eventIdsSql = ' SELECT E.Id, GROUP_CONCAT(T.Name SEPARATOR ", ") AS TagsFROM Events AS E INNER JOIN Monitors AS M ON (E.MonitorId = M.Id) LEFT JOIN Events_Tags AS ET ON E.Id = ET.EventId LEFT JOIN Tags AS T ...

So,the full query causing the issue is this: SELECT EventId,FrameId,Delta,Score FROM Frames WHERE EventId IN( SELECT E.Id, GROUP_CONCAT(T.Name SEPARATOR ", ") AS TagsFROM Events AS E INNER JOIN Monitors AS M ON (E.MonitorId = M.Id) LEFT JOIN Events_Tags AS ET ON E.Id = ET.EventId LEFT JOIN Tags AS T ...

Hmm. I thought I was already at that, but I just got it and don't get that error. Perhaps you're doing something I'm not? Anyway, I'm fairly certain that LEFT JOI' at line 5', statement was should be a JOIN Maybe just try a reinstall...sudo apt remove zoneminder / sudo apt install zoneminder That ...

Hi, Running the latest build dev build on Ubuntu 22.04: 1.37.45~20231023170647-jammy , Mysql 8.0.34-0ubuntu0.22.04.1 . Whenever I access the events view, I get the following in the logs: Oct 25 06:53:30 cctv web_php[795]: 10/25/23, 6:53:30 AM GMT+1.284832 web_php[795].ERR [10.10.20.1] [SQL-ERR ...

Fixed in 1.35.18~20210216113144-focal - thanks!

Looks like it's already an issue on Github: https://github.com/ZoneMinder/zoneminder/issues/3162.

There’s a lot of work going on at the minute. Go on Slack to make sure they are aware. If you don’t like the bumpy ride, I’d stay on 1.35.16 at the moment. Yeah, I'm aware of the above and the implications/acceptance of using the latest ZM release (I'm a long time ZM user) - I'm just asking the ques ...