Database Query Errors

[Sbcarpcont]

Hello,

This is my first post to this board so I would like to start off with thanking the developers and contributors for all their efforts! I have been using Zoneminder for several years but recently updated the Ubuntu server to 18.04 from 16.04. I was using 1.29.x without any problems for years. After the update I ran into issues with the 1.29.x version so I did a complete purge and install recently to 1.33.3. It runs fine for a few days but then it starts to log errors with increasing frequency to a point where it crashes. Some background; running on stand alone headless Ubuntu 18.04 and 1 camera at this time (I have 3 other cameras that were damaged during a storm a couple months ago and cannot be replaced until spring really comes!). During the purge and install I did not add the other cameras yet but I keep thinking that the problems are with them somehow. Here is a copy of Syslog;

Code: Select all

Mar 22 06:11:29 Camera-server zms_m3[29924]: ERR [zms_m3] [Bogus number of lines return from query, 0 returned for query SELECT Id, Name, ServerId, StorageId, Type, Function+0, Enabled, LinkedMonitors, AnalysisFPSLimit, AnalysisUpdateDelay, MaxFPS, AlarmMaxFPS,Device, Channel, Format, V4LMultiBuffer, V4LCapturesPerFrame, Protocol, Method, Options, User, Pass, Host, Port, Path, Width, Height, Colours, Palette, Orientation+0, Deinterlacing, RTSPDescribe, SaveJPEGs, VideoWriter, EncoderParameters, RecordAudio, Brightness, Contrast, Hue, Colour, EventPrefix, LabelFormat, LabelX, LabelY, LabelSize,ImageBufferCount, WarmupCount, PreEventCount, PostEventCount, StreamReplayBuffer, AlarmFrameCount, SectionLength, FrameSkip, MotionFrameSkip, FPSReportInterval, RefBlendPerc, AlarmRefBlendPerc, TrackMotion, Exif, SignalCheckPoints, SignalCheckColour FROM Monitors WHERE Id=3.]
Mar 22 06:11:30 Camera-server zms_m2[29925]: ERR [zms_m2] [Bogus number of lines return from query, 0 returned for query SELECT Id, Name, ServerId, StorageId, Type, Function+0, Enabled, LinkedMonitors, AnalysisFPSLimit, AnalysisUpdateDelay, MaxFPS, AlarmMaxFPS,Device, Channel, Format, V4LMultiBuffer, V4LCapturesPerFrame, Protocol, Method, Options, User, Pass, Host, Port, Path, Width, Height, Colours, Palette, Orientation+0, Deinterlacing, RTSPDescribe, SaveJPEGs, VideoWriter, EncoderParameters, RecordAudio, Brightness, Contrast, Hue, Colour, EventPrefix, LabelFormat, LabelX, LabelY, LabelSize,ImageBufferCount, WarmupCount, PreEventCount, PostEventCount, StreamReplayBuffer, AlarmFrameCount, SectionLength, FrameSkip, MotionFrameSkip, FPSReportInterval, RefBlendPerc, AlarmRefBlendPerc, TrackMotion, Exif, SignalCheckPoints, SignalCheckColour FROM Monitors WHERE Id=2.]
Mar 22 06:11:30 Camera-server zms_m3[29924]: ERR [zms_m3] [Can't use query result: ]
Mar 22 06:11:30 Camera-server zms_m2[29925]: ERR [zms_m2] [Can't use query result: ]
Mar 22 06:11:30 Camera-server zms_m3[29924]: ERR [zms_m3] [Unable to load monitor id 3 for streaming]
Mar 22 06:11:30 Camera-server zms_m2[29925]: ERR [zms_m2] [Unable to load monitor id 2 for streaming]
Mar 22 06:11:30 Camera-server zms_m3[29924]: ERR [zms_m3] [Unable to connect to zmc process for monitor 3]
Mar 22 06:11:30 Camera-server zms_m2[29925]: ERR [zms_m2] [Unable to connect to zmc process for monitor 2]

Here is df -h;

Code: Select all

Filesystem                           Size  Used Avail Use% Mounted on
udev                                  16G     0   16G   0% /dev
tmpfs                                3.2G  1.1M  3.2G   1% /run
/dev/mapper/Camera--server--vg-root  885G  193G  647G  23% /
tmpfs                                 16G  159M   16G   1% /dev/shm
tmpfs                                5.0M     0  5.0M   0% /run/lock
tmpfs                                 16G     0   16G   0% /sys/fs/cgroup
/dev/sdc2                            473M  155M  294M  35% /boot
/dev/sdc1                            511M  6.1M  505M   2% /boot/efi
/dev/sdd1                            9.1T  242G  8.4T   3% /mnt/sdb1
tmpfs                                3.2G     0  3.2G   0% /run/user/1000

Any help would be greatly appreciated!

Thanks
Jim

[rockedge]

Hello Jim,
you have now 1 camera setup and running? ZM starts off running Ok then after time develops the errors leading to a crash of ZM?

just to set the stage, could you open a terminal and run

Code: Select all

zmupdate.pl -f

[Sbcarpcont]

Hi
Thanks for getting back to me! Sorry for the delay. I ran that script and here was the response.

Code: Select all

Freshening configuration in database
Loading config from DB 225 entries
Saving config to DB 225 entries

Correct I have just 1 camera up and running right now.
Thanks

[rockedge]

does the console work now? Or does it throw any errors at all, what do the logs show?

[Sbcarpcont]

The console works fine. I did not set the log to save. I set it now. Syslog still shows the same errors. I should be able to get the other cameras working again this weekend.

[Sbcarpcont]

Looks like it crashed again. This is the last error report from syslog.

Code: Select all

Mar 28 15:45:34 Camera-server zms_m2[8102]: ERR [zms_m2] [Can't use query result: ]
Mar 28 15:45:34 Camera-server zms_m3[8103]: ERR [zms_m3] [Can't use query result: ]
Mar 28 15:45:34 Camera-server zms_m2[8102]: ERR [zms_m2] [Unable to load monitor id 2 for streaming]
Mar 28 15:45:34 Camera-server zms_m3[8103]: ERR [zms_m3] [Unable to load monitor id 3 for streaming]
Mar 28 15:45:34 Camera-server zms_m2[8102]: ERR [zms_m2] [Unable to connect to zmc process for monitor 2]
Mar 28 15:45:34 Camera-server zms_m3[8103]: ERR [zms_m3] [Unable to connect to zmc process for monitor 3]
Mar 28 21:22:16 Camera-server zmc_m1[14490]: ERR [zmc_m1] [Unable to send packet at frame 3319143: Invalid data found when processing input, continuing]
Binary file (standard input) matches

There was nothing in /var/crash. Not sure why it is crashing. Not sure why it thinks there are 3 monitors either.