Search found 88 matches

by c128
Tue Jan 30, 2024 8:14 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: The memory fills progressively
Replies: 31
Views: 18031

Re: The memory fills progressively

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.
by c128
Tue Jan 30, 2024 4:46 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: The memory fills progressively
Replies: 31
Views: 18031

Re: The memory fills progressively

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 available.
by c128
Tue Jan 30, 2024 8:07 am
Forum: ZoneMinder 1.37.x Development Branch
Topic: The memory fills progressively
Replies: 31
Views: 18031

Re: The memory fills progressively

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 on...
by c128
Mon Oct 30, 2023 9:48 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

All working now with no errors after installing 1.37.46~20231030102238-jammy - thanks!
by c128
Mon Oct 30, 2023 12:55 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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_ph...
by c128
Fri Oct 27, 2023 9:30 am
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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...
by c128
Wed Oct 25, 2023 9:56 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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 ;) ).
by c128
Wed Oct 25, 2023 7:48 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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 'SELE...
by c128
Wed Oct 25, 2023 7:39 pm
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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 T...
by c128
Wed Oct 25, 2023 11:59 am
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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...
by c128
Wed Oct 25, 2023 11:48 am
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

Re: SQL-ERR when accessing events view - events missing

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 `...
by c128
Wed Oct 25, 2023 6:03 am
Forum: ZoneMinder 1.37.x Development Branch
Topic: [Fixed] SQL-ERR when accessing timeline view - events missing
Replies: 13
Views: 7742

[Fixed] SQL-ERR when accessing timeline view - events missing

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 'SQLS...
by c128
Tue Feb 16, 2021 11:21 pm
Forum: ZoneMinder 1.35.x Development Branch
Topic: "No more events" in the event viewer, but there are... [FIXED]
Replies: 5
Views: 2236

Re: "No more events" in the event viewer, but there are...

Fixed in 1.35.18~20210216113144-focal - thanks!
by c128
Sun Feb 14, 2021 7:49 am
Forum: ZoneMinder 1.35.x Development Branch
Topic: "No more events" in the event viewer, but there are... [FIXED]
Replies: 5
Views: 2236

Re: "No more events" in the event viewer, but there are...

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 que...