After the first 1.37.62 update the server logs(syslog/journal) grow indefenitely, zoneminder throws errors about not able to query or find monitors.
no change after updating to 1.37.62~20240707094607-jammy, which is current version installed
the monitors are showing in the database, somehow there is one extra monitor which is not showing in the gui, 5 and 6 are identical buy only 4 and 6 are showing in the gui
is there a way to rebuild the database or fix this somehow?
Code: Select all
Jul 07 20:34:43 server zmdc[956]: ERR ['zmc -m 6' exited abnormally, exit status 255]
Jul 07 20:34:43 server zmc_m6[1234]: ERR [zmc_m6] [No monitors found]
Jul 07 20:34:43 server zmc_m6[1234]: ERR [zmc_m6] [Can't use query result: ]
Jul 07 20:34:43 server zmc_m6[1234]: ERR [zmc_m6] [Can't run query: SELECT `Id`, `Name`, `Deleted`, `ServerId`, `StorageId`, `Type`, `Capturing`+0, `Analysing`+0, `AnalysisSource`+0, `AnalysisImage`+0, `Recording`+0, `RecordingSource`+0, `Decoding`+0, `RTSP2WebEnabled`, `RTSP2WebType`, `JanusEnabled`, `JanusAudio>
Jul 07 20:34:41 server zmdc[956]: ERR ['zmc -m 6' exited abnormally, exit status 255]
Jul 07 20:34:41 server zmc_m6[1232]: ERR [zmc_m6] [No monitors found]
Jul 07 20:34:41 server zmc_m6[1232]: ERR [zmc_m6] [Can't use query result: ]
Jul 07 20:34:41 server zmc_m6[1232]: ERR [zmc_m6] [Can't run query: SELECT `Id`, `Name`, `Deleted`, `ServerId`, `StorageId`, `Type`, `Capturing`+0, `Analysing`+0, `AnalysisSource`+0, `AnalysisImage`+0, `Recording`+0, `RecordingSource`+0, `Decoding`+0, `RTSP2WebEnabled`, `RTSP2WebType`, `JanusEnabled`, `JanusAudio>
Jul 07 20:34:38 server zmdc[956]: ERR ['zmc -m 6' exited abnormally, exit status 255]
Jul 07 20:34:38 server zmc_m6[1102]: ERR [zmc_m6] [No monitors found]
Jul 07 20:34:38 server zmc_m6[1102]: ERR [zmc_m6] [Can't use query result: ]
Jul 07 20:34:38 server zmc_m6[1102]: ERR [zmc_m6] [Can't run query: SELECT `Id`, `Name`, `Deleted`, `ServerId`, `StorageId`, `Type`, `Capturing`+0, `Analysing`+0, `AnalysisSource`+0, `AnalysisImage`+0, `Recording`+0, `RecordingSource`+0, `Decoding`+0, `RTSP2WebEnabled`, `RTSP2WebType`, `JanusEnabled`, `JanusAudio>Code: Select all
mysql> SELECT * FROM Monitors;
--+--------------------+--------------+
| Id | Name | Deleted | Notes | ServerId | StorageId | ManufacturerId | ModelId | Type | Function | Capturing | Analysing | AnalysisSource | AnalysisImage | Recording | Enabled | DecodingEnabled | Decoding | RTSP2WebEnabled | RTSP2WebType | JanusEnabled | JanusAudioEnabled | Janus_Profile_Override | Janus_
Use_RTSP_Restream | Janus_RTSP_User | Janus_RTSP_Session_Timeout | LinkedMonitors | Triggers | EventStartCommand | EventEndCommand | ONVIF_URL | ONVIF_Events_Path | ONVIF_Username | ONVIF_Password | ONVIF_Options | ONVIF_Event_Listener | ONVIF_Alarm_Text | use_Amcrest_API | Device | Channel | Format | V4LMultiBuffer
| V4LCapturesPerFrame | Protocol | Method | Host | Port | SubPath | Path | SecondPath | Options | User | Pass | Width | Height | Colours | Palette | Orientation | Deinterlacing | Decoder | DecoderHWAccelName | DecoderHWAccelDevice | SaveJPEGs | V
ideoWriter | OutputCodec | Encoder | OutputContainer | EncoderParameters | RecordAudio | RecordingSource | RTSPDescribe | Brightness | Contrast | Hue | Colour | EventPrefix | LabelFormat | LabelX | LabelY | LabelSize | ImageBufferCount | MaxImageBufferCount | WarmupCount | PreEventCount | PostEventCount | StreamRepl
ayBuffer | AlarmFrameCount | SectionLength | SectionLengthWarn | EventCloseMode | MinSectionLength | FrameSkip | MotionFrameSkip | AnalysisFPSLimit | AnalysisUpdateDelay | MaxFPS | AlarmMaxFPS | FPSReportInterval | RefBlendPerc | AlarmRefBlendPerc | Controllable | ControlId | ControlDevice | ControlAddress | AutoSto
pTimeout | TrackMotion | TrackDelay | ReturnLocation | ReturnDelay | ModectDuringPTZ | DefaultRate | DefaultScale | DefaultCodec | SignalCheckPoints | SignalCheckColour | WebColour | Exif | Sequence | ZoneCount | Refresh | Latitude | Longitude | RTSPServer | RTSPStreamName | SOAP_wsa_compl | Importance | MQTT_Enable
d | MQTT_Subscriptions | StartupDelay |
--+--------------------+--------------+
| 4 | driveway-old | 0 | | 0 | 3 | 9 | NULL | Ffmpeg | Monitor | None | None | Primary | FullColour | None | 0 | 1 | Always | 0 | HLS | 0 | 0 | |
0 | NULL | 0 | NULL | | | | | | | | | 0 | | 0 | | 0 | 0 | NULL
| 1 | NULL | rtpRtsp | NULL | | | http://ip0/videostream.cgi?user=visitor&pwd=camera-pass | NULL | NULL | | | 640 | 480 | 4 | 0 | ROTATE_0 | 0 | auto | NULL | NULL | 0 |
2 | 0 | auto | NULL | | 0 | Primary | 0 | -1 | -1 | -1 | -1 | Event- | | 0 | 0 | 2 | 3 | 121 | 0 | 5 | 5 |
0 | 1 | 600 | 0 | system | 10 | 0 | 0 | 1.00 | 0 | NULL | NULL | 100 | 12 | 12 | 0 | NULL | NULL | NULL |
NULL | 0 | NULL | -1 | NULL | 0 | 100 | 0 | auto | 0 | #0000be | #1b0986 | 0 | 1 | 1 | NULL | NULL | NULL | 0 | | 0 | Normal |
0 | | 0 |
| 5 | driveway | 1 | | 0 | 3 | NULL | NULL | Ffmpeg | Monitor | Always | Always | Primary | FullColour | OnMotion | 0 | 1 | Always | 0 | HLS | 0 | 0 | |
0 | NULL | 0 | NULL | | | | | /Events | | | | 0 | MotionAlarm | 0 | | 0 | 0 | NULL
| 1 | NULL | rtpRtsp | NULL | | | rtsp://ip1:554/tcp_live/ch0_0 | NULL | NULL | camera-user | camera-pass | 1280 | 720 | 4 | 0 | ROTATE_0 | 0 | auto | NULL | NULL | 0 |
2 | 0 | auto | NULL | | 0 | Primary | 0 | -1 | -1 | -1 | -1 | Event- | | 0 | 0 | 2 | 3 | 121 | 0 | 5 | 5 |
0 | 1 | 600 | 0 | system | 10 | 0 | 0 | 1.00 | 0 | NULL | NULL | 100 | 12 | 12 | 0 | NULL | NULL | NULL |
NULL | 0 | NULL | -1 | NULL | 0 | 100 | 0 | auto | 0 | #0000be | #b85d21 | 0 | 2 | 1 | NULL | NULL | NULL | 0 | | 0 | Normal |
0 | | 0 |
| 6 | driveway | 0 | | 0 | 3 | NULL | NULL | Ffmpeg | Monitor | Always | Always | Primary | FullColour | OnMotion | 0 | 1 | Always | 0 | HLS | 0 | 0 | |
0 | NULL | 0 | NULL | | | | | /Events | | | | 0 | MotionAlarm | 0 | | 0 | 0 | NULL
| 1 | NULL | rtpRtsp | NULL | | | rtsp://ip1:554/tcp_live/ch0_0 | NULL | NULL | camera-user | camera-pass | 1280 | 720 | 4 | 0 | ROTATE_0 | 0 | auto | NULL | NULL | 0 |
2 | 0 | auto | NULL | | 0 | Primary | 0 | -1 | -1 | -1 | -1 | Event- | | 0 | 0 | 2 | 3 | 121 | 0 | 10 | 10 |
0 | 1 | 600 | 0 | system | 10 | 0 | 0 | 2.00 | 0 | NULL | NULL | 100 | 12 | 12 | 0 | NULL | NULL | NULL |
NULL | 0 | NULL | -1 | NULL | 0 | 100 | 0 | auto | 0 | #0000be | #747200 | 0 | 3 | 1 | NULL | NULL | NULL | 0 | | 0 | Normal |
0 | | 0 |
+----+--------------+---------+-------+----------+-----------+----------------+---------+--------+----------+-----------+-----------+----------------+---------------+-------
3 rows in set (0.01 sec)