random crashing

Forum for questions and support relating to the 1.30.x releases only.
Locked
herrjon
Posts: 6
Joined: Mon Aug 15, 2016 9:42 pm

random crashing

Post by herrjon »

I have zoneminder 1.30.4 installed on two different servers, one an older Intel Core2 Duo with a gig of ram and the other on a dual Xeon 12 core server with 128G of RAM.

Both of them have developed a random crashing problem. The zoneminder service will run for about 12 hours after a complete server reboot then die. After that I can restart the service and it will run between minutes or hours. The only longer term fix is to reboot the server which is unacceptable.

I have plenty of tmp space and etc per the tuning guides....

Distributor ID: Ubuntu
Description: Ubuntu 16.04.3 LTS
Release: 16.04
Codename: xenial

4.4.0-96-generic #119-Ubuntu SMP Tue Sep 12 14:59:54 UTC 2017 x86_64 x86_64 x86_64 GNU/Linux

Filesystem Size Used Avail Use% Mounted on
udev 63G 0 63G 0% /dev
tmpfs 13G 1.4G 12G 11% /run
/dev/mapper/herrgate2950--vg-root 7.3T 3.2T 3.8T 46% /
tmpfs 63G 0 63G 0% /dev/shm
tmpfs 5.0M 4.0K 5.0M 1% /run/lock
tmpfs 63G 0 63G 0% /sys/fs/cgroup
/dev/sda2 473M 106M 343M 24% /boot
cgmfs 100K 0 100K 0% /run/cgmanager/fs
/dev/mapper/2tb_seagate 1.8T 1.8T 0 100% /mnt/2tb_seagate
tmpfs 13G 0 13G 0% /run/user/1000
j

I've been using zoneminder for 10+ years and never had this problem before. In fact it only started on the 128g_Xeon about a month ago.

here's a snipped of my log file after a crash:

-Jon
------
Oct 10 04:01:02 <128g_Xeon> web_php[31371]: INF [Login successful for user "admin_user"]
Oct 10 04:01:02 <128g_Xeon> zms[32497]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
Oct 10 04:01:02 <128g_Xeon> zms[32497]: ERR [Got signal 11 (Segmentation fault), crashing]
Oct 10 04:01:02 <128g_Xeon> zms[32496]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
Oct 10 04:01:02 <128g_Xeon> zms[32498]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
Oct 10 04:01:02 <128g_Xeon> zms[32497]: ERR [Signal address is (nil), from 0x564df3a1f8c6]
Oct 10 04:01:02 <128g_Xeon> zms[32496]: ERR [Got signal 11 (Segmentation fault), crashing]
Oct 10 04:01:02 <128g_Xeon> zms[32498]: ERR [Got signal 11 (Segmentation fault), crashing]
Oct 10 04:01:02 <128g_Xeon> zms[32497]: ERR [Backtrace 0: /usr/lib/zoneminder/cgi-bin/nph-zms(_Z14zm_die_handleriP9siginfo_tPv+0x78) [0x564df3a65fa8]]
Oct 10 04:01:02 <128g_Xeon> zms[32496]: ERR [Signal address is (nil), from 0x5639158198c6]
Oct 10 04:01:02 <128g_Xeon> zms[32498]: ERR [Signal address is (nil), from 0x55b3f1d618c6]
Oct 10 04:01:02 <128g_Xeon> zms[32497]: ERR [Backtrace 1: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f6cd05e4390]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 0: /usr/lib/zoneminder/cgi-bin/nph-zms(_Z14zm_die_handleriP9siginfo_tPv+0x78) [0x56391585ffa8]]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 0: /usr/lib/zoneminder/cgi-bin/nph-zms(_Z14zm_die_handleriP9siginfo_tPv+0x78) [0x55b3f1da7fa8]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: ERR [Backtrace 2: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN7Monitor11SingleImageEi+0x46) [0x564df3a1f8c6]]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 1: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f6e892ef390]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 1: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7f11110fa390]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: ERR [Backtrace 3: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN13MonitorStream9runStreamEv+0xb9a) [0x564df3a2058a]]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 2: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN7Monitor11SingleImageEi+0x46) [0x55b3f1d618c6]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 2: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN7Monitor11SingleImageEi+0x46) [0x5639158198c6]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: ERR [Backtrace 4: /usr/lib/zoneminder/cgi-bin/nph-zms(main+0xb9e) [0x564df39e606e]]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 3: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN13MonitorStream9runStreamEv+0xb9a) [0x55b3f1d6258a]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 3: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN13MonitorStream9runStreamEv+0xb9a) [0x56391581a58a]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: ERR [Backtrace 5: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f6ccccd5830]]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 4: /usr/lib/zoneminder/cgi-bin/nph-zms(main+0xb9e) [0x55b3f1d2806e]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 4: /usr/lib/zoneminder/cgi-bin/nph-zms(main+0xb9e) [0x5639157e006e]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: ERR [Backtrace 6: /usr/lib/zoneminder/cgi-bin/nph-zms(_start+0x29) [0x564df39e6f69]]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 5: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f6e859e0830]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 5: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7f110d7eb830]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: INF [Backtrace complete, please execute the following command for more information]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: ERR [Backtrace 6: /usr/lib/zoneminder/cgi-bin/nph-zms(_start+0x29) [0x55b3f1d28f69]]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: ERR [Backtrace 6: /usr/lib/zoneminder/cgi-bin/nph-zms(_start+0x29) [0x5639157e0f69]]
Oct 10 04:01:03 <128g_Xeon> zms[32497]: INF [addr2line -e /usr/lib/zoneminder/cgi-bin/nph-zms 0x564df3a65fa8 0x7f6cd05e4390 0x564df3a1f8c6 0x564df3a2058a 0x564df39e606e 0x7f6ccc cd5830 0x564df39e6f69]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: INF [Backtrace complete, please execute the following command for more information]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: INF [Backtrace complete, please execute the following command for more information]
Oct 10 04:01:03 <128g_Xeon> zms[32498]: INF [addr2line -e /usr/lib/zoneminder/cgi-bin/nph-zms 0x55b3f1da7fa8 0x7f6e892ef390 0x55b3f1d618c6 0x55b3f1d6258a 0x55b3f1d2806e 0x7f6e85 9e0830 0x55b3f1d28f69]
Oct 10 04:01:03 <128g_Xeon> zms[32496]: INF [addr2line -e /usr/lib/zoneminder/cgi-bin/nph-zms 0x56391585ffa8 0x7f11110fa390 0x5639158198c6 0x56391581a58a 0x5639157e006e 0x7f110d 7eb830 0x5639157e0f69]
Oct 10 04:01:03 <128g_Xeon> web_php[31040]: INF [Login successful for user "admin_user"]
Oct 10 04:01:03 <128g_Xeon> zms[32499]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
Oct 10 04:01:03 <128g_Xeon> zms[32499]: ERR [Got signal 11 (Segmentation fault), crashing]
Oct 10 04:01:03 <128g_Xeon> zms[32499]: ERR [Signal address is (nil), from 0x55c5d25b78c6]
Oct 10 04:01:03 <128g_Xeon> zms[32502]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
Oct 10 04:01:03 <128g_Xeon> zms[32501]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
Oct 10 04:01:03 <128g_Xeon> zms[32499]: ERR [Backtrace 0: /usr/lib/zoneminder/cgi-bin/nph-zms(_Z14zm_die_handleriP9siginfo_tPv+0x78) [0x55c5d25fdfa8]]
bbunge
Posts: 2930
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: random crashing

Post by bbunge »

Have you checked the resources on the database server? MySQL or Mariadb? Use mysqltuner to check the innodb_buffer_pool_size and related files. Running 12 hours the crashing seems like the time the system runs before doing an event purge which could tax the database server.

If you are having issues with MySQL may I recommend Mariadb. I have been running it on my 17 camera system for several months with no issues!
dingbatca
Posts: 13
Joined: Tue Feb 09, 2016 11:36 pm

Re: random crashing

Post by dingbatca »

Bump. I think I am having the same issue. Any solutions?

Code: Select all

root@ZoneMinder:~# cat /etc/*version*
stretch/sid

#snip from the logs
...
May 26 21:29:19 ZoneMinder zms[3672]: INF [Authenticated user 'admin']
May 26 21:29:19 ZoneMinder zms[3673]: INF [Authenticated user 'admin']
May 26 21:29:19 ZoneMinder zms[3675]: INF [Authenticated user 'admin']
May 26 21:29:19 ZoneMinder zms[3674]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3676]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3677]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3680]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3678]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3679]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3677]: ERR [Got empty memory map file size 0, is the zmc process for this monitor running?]
May 26 21:29:20 ZoneMinder zms[3677]: ERR [Got signal 11 (Segmentation fault), crashing]
May 26 21:29:20 ZoneMinder zms[3677]: ERR [Signal address is (nil), from 0x5572021ef8c6]
May 26 21:29:20 ZoneMinder zms[3677]: ERR [Backtrace 0: /usr/lib/zoneminder/cgi-bin/nph-zms(_Z14zm_die_handleriP9siginfo_tPv+0x78) [0x557202235fa8]]
May 26 21:29:20 ZoneMinder zms[3683]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3677]: ERR [Backtrace 1: /lib/x86_64-linux-gnu/libpthread.so.0(+0x11390) [0x7fed8e52d390]]
May 26 21:29:20 ZoneMinder zms[3684]: INF [Authenticated user 'admin']
May 26 21:29:20 ZoneMinder zms[3677]: ERR [Backtrace 2: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN7Monitor11SingleImageEi+0x46) [0x5572021ef8c6]]
May 26 21:29:21 ZoneMinder zms[3677]: ERR [Backtrace 3: /usr/lib/zoneminder/cgi-bin/nph-zms(_ZN13MonitorStream9runStreamEv+0xb9a) [0x5572021f058a]]
May 26 21:29:21 ZoneMinder zms[3677]: ERR [Backtrace 4: /usr/lib/zoneminder/cgi-bin/nph-zms(main+0xb9e) [0x5572021b606e]]
May 26 21:29:21 ZoneMinder zms[3677]: ERR [Backtrace 5: /lib/x86_64-linux-gnu/libc.so.6(__libc_start_main+0xf0) [0x7fed8ac1b830]]
May 26 21:29:21 ZoneMinder zms[3677]: ERR [Backtrace 6: /usr/lib/zoneminder/cgi-bin/nph-zms(_start+0x29) [0x5572021b6f69]]
May 26 21:29:21 ZoneMinder zms[3677]: INF [Backtrace complete, please execute the following command for more information]
May 26 21:29:21 ZoneMinder zms[3677]: INF [addr2line -e /usr/lib/zoneminder/cgi-bin/nph-zms 0x557202235fa8 0x7fed8e52d390 0x5572021ef8c6 0x5572021f058a 0x5572021b606e 0x7fed8ac1b830 0x5572021b6f69]
May 26 21:29:21 ZoneMinder zms[3685]: INF [Authenticated user 'admin']
May 26 21:29:21 ZoneMinder zms[3686]: INF [Authenticated user 'admin']
May 26 21:29:21 ZoneMinder zms[3687]: INF [Authenticated user 'admin']
May 26 21:29:21 ZoneMinder zms[3688]: INF [Authenticated user 'admin']
May 26 21:29:21 ZoneMinder zms[3689]: INF [Authenticated user 'admin']
...

root@ZoneMinder:~# df -h
Filesystem      Size  Used Avail Use% Mounted on
/dev/sdc        2.8T  488G  2.0T  20% /
none            492K     0  492K   0% /dev
tmpfs            16G  5.7G   11G  36% /dev/shm
tmpfs            16G   17M   16G   1% /run
tmpfs           5.0M     0  5.0M   0% /run/lock
tmpfs            16G     0   16G   0% /sys/fs/cgroup
tmpfs           3.2G     0  3.2G   0% /run/user/0

dingbatca
Posts: 13
Joined: Tue Feb 09, 2016 11:36 pm

Re: random crashing

Post by dingbatca »

Interesting. Similar behavior with 18.04 and ZM 1.31.44~20180522170754-bionic

Code: Select all

May 28 21:35:58 zoneminder zmdc[1464]: INF ['zma -m 9' starting at 18/05/28 21:35:58, pid = 1776]
May 28 21:35:58 zoneminder zmdc[1776]: INF ['zma -m 9' started at 18/05/28 21:35:58]
May 28 21:35:59 zoneminder zmdc[1464]: INF [Starting pending process, zmc -m 9]
May 28 21:35:59 zoneminder zmdc[1464]: INF ['zmc -m 9' starting at 18/05/28 21:35:59, pid = 1777]
May 28 21:35:59 zoneminder zmdc[1777]: INF ['zmc -m 9' started at 18/05/28 21:35:59]
May 28 21:35:59 zoneminder zma_m9[1776]: ERR [zma_m9] [Shared data not initialised by capture daemon for monitor License Plate Cam]
May 28 21:35:59 zoneminder zmdc[1464]: ERR ['zma -m 9' exited abnormally, exit status 255]
May 28 21:35:59 zoneminder zmdc[1464]: INF ['zmc -m 9' crashed, signal 134]
I am going to try blanking my DB and see if I have a configuration problem.
zarkov
Posts: 2
Joined: Sun Jan 22, 2006 10:19 pm

Re: random crashing

Post by zarkov »

Hi all,

I've started receiving the exact same issue in the last couple of weeks with my set up that had been running fine for around 3 months prior.

Did anyone find a solution to this problem?

M
bbunge
Posts: 2930
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: random crashing

Post by bbunge »

zarkov wrote: Tue Jul 17, 2018 10:42 pm Hi all,

I've started receiving the exact same issue in the last couple of weeks with my set up that had been running fine for around 3 months prior.

Did anyone find a solution to this problem?

M
Have you checked the resources the database server uses? Adding events means the database will need more resources such as innodb_buffer_pool_size.
theob
Posts: 1
Joined: Thu Aug 16, 2018 2:11 am

Re: random crashing

Post by theob »

Been having this problem since I started using ZoneMinder, anyone find a concrete solution?
rockandroller
Posts: 51
Joined: Tue Dec 22, 2015 12:44 am

Re: random crashing

Post by rockandroller »

Just noticed random crashes ('system stopped' - and no restart) started in the last couple of months... (ZM 1.30.4).
Was always running fine before.. I suspect some (???) linux component update (Centos 7)...

some recent zmdc logs (not sure what to look for...)

Code: Select all

2018-08-27 12:19:45.207720	zmdc		13371	INF	'zmupdate.pl -c' started at 18/08/27 12:19:45	zmdc.pl	
2018-08-27 12:19:45.207440	zmdc		21109	INF	'zmupdate.pl -c' starting at 18/08/27 12:19:45, pid = 13371	zmdc.pl	
2018-08-27 12:19:45.129430	zmdc		21109	INF	Starting pending process, zmupdate.pl -c	zmdc.pl	
2018-08-27 12:19:45.120540	zmdc		21109	ERR	'zmupdate.pl -c' exited abnormally, exit status 9	zmdc.pl	
2018-08-26 11:19:43.789710	zmdc		21109	INF	'zmupdate.pl -c' starting at 18/08/26 11:19:43, pid = 8656	zmdc.pl	
2018-08-26 11:19:43.789710	zmdc		8656	INF	'zmupdate.pl -c' started at 18/08/26 11:19:43	zmdc.pl	
2018-08-26 11:19:43.778360	zmdc		21109	INF	Starting pending process, zmupdate.pl -c	zmdc.pl	
2018-08-26 11:19:43.768970	zmdc		21109	ERR	'zmupdate.pl -c' exited abnormally, exit status 9	zmdc.pl	
2018-08-25 11:19:42.129650	zmdc		4311	INF	'zmupdate.pl -c' started at 18/08/25 11:19:42	zmdc.pl	
2018-08-25 11:19:42.129460	zmdc		21109	INF	'zmupdate.pl -c' starting at 18/08/25 11:19:42, pid = 4311	zmdc.pl	
2018-08-25 11:19:42.118580	zmdc		21109	INF	Starting pending process, zmupdate.pl -c	zmdc.pl	
2018-08-25 11:19:42.109480	zmdc		21109	ERR	'zmupdate.pl -c' exited abnormally, exit status 9	zmdc.pl	
2018-08-24 11:19:40.558640	zmdc		31762	INF	'zmupdate.pl -c' started at 18/08/24 11:19:40	zmdc.pl	
2018-08-24 11:19:40.558520	zmdc		21109	INF	'zmupdate.pl -c' starting at 18/08/24 11:19:40, pid = 31762	zmdc.pl	
2018-08-24 11:19:40.547640	zmdc		21109	INF	Starting pending process, zmupdate.pl -c	zmdc.pl	
2018-08-24 11:19:40.537590	zmdc		21109	ERR	'zmupdate.pl -c' exited abnormally, exit status 9	zmdc.pl	
2018-08-23 11:19:39.294370	zmdc		26385	INF	'zmupdate.pl -c' started at 18/08/23 11:19:39	zmdc.pl	
2018-08-23 11:19:39.294230	zmdc		21109	INF	'zmupdate.pl -c' starting at 18/08/23 11:19:39, pid = 26385	zmdc.pl	
2018-08-23 11:19:39.283110	zmdc		21109	INF	Starting pending process, zmupdate.pl -c	zmdc.pl	
2018-08-23 11:19:39.273000	zmdc		21109	ERR	'zmupdate.pl -c' exited abnormally, exit status 9	zmdc.pl	
2018-08-22 11:19:42.192650	zmdc		21350	INF	'zma -m 7' started at 18/08/22 11:19:42	zmdc.pl	
2018-08-22 11:19:42.192650	zmdc		21109	INF	'zma -m 7' starting at 18/08/22 11:19:42, pid = 21350	zmdc.pl	
2018-08-22 11:19:42.172770	zmdc		21109	INF	Starting pending process, zma -m 7	zmdc.pl	
2018-08-22 11:19:42.165100	zmdc		21347	INF	'zma -m 6' started at 18/08/22 11:19:42	zmdc.pl	
2018-08-22 11:19:42.165100	zmdc		21109	INF	'zma -m 6' starting at 18/08/22 11:19:42, pid = 21347	zmdc.pl	
2018-08-22 11:19:42.099260	zmdc		21109	INF	Starting pending process, zma -m 6	zmdc.pl	
2018-08-22 11:19:41.092100	zmdc		21338	INF	'zma -m 5' started at 18/08/22 11:19:41	zmdc.pl	
2018-08-22 11:19:41.092020	zmdc		21109	INF	'zma -m 5' starting at 18/08/22 11:19:41, pid = 21338	zmdc.pl	
2018-08-22 11:19:41.072760	zmdc		21109	INF	Starting pending process, zma -m 5	zmdc.pl	
2018-08-22 11:19:41.067120	zmdc		21335	INF	'zma -m 1' started at 18/08/22 11:19:41	zmdc.pl	
2018-08-22 11:19:41.067000	zmdc		21109	INF	'zma -m 1' starting at 18/08/22 11:19:41, pid = 21335	zmdc.pl	
2018-08-22 11:19:41.017130	zmdc		21109	INF	Starting pending process, zma -m 1	zmdc.pl	
2018-08-22 11:19:38.545100	zmdc		21312	INF	'zmtelemetry.pl' started at 18/08/22 11:19:38	zmdc.pl	
2018-08-22 11:19:38.545020	zmdc		21109	INF	'zmtelemetry.pl' starting at 18/08/22 11:19:38, pid = 21312	zmdc.pl	
2018-08-22 11:19:38.313350	zmdc		21303	INF	'zmupdate.pl -c' started at 18/08/22 11:19:38	zmdc.pl	
2018-08-22 11:19:38.313340	zmdc		21109	INF	'zmupdate.pl -c' starting at 18/08/22 11:19:38, pid = 21303	zmdc.pl	
2018-08-22 11:19:38.135300	zmdc		21290	INF	'zmwatch.pl' started at 18/08/22 11:19:38	zmdc.pl	
2018-08-22 11:19:38.135180	zmdc		21109	INF	'zmwatch.pl' starting at 18/08/22 11:19:38, pid = 21290	zmdc.pl	
2018-08-22 11:19:37.943490	zmdc		21275	INF	'zmaudit.pl -c' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.943430	zmdc		21109	INF	'zmaudit.pl -c' starting at 18/08/22 11:19:37, pid = 21275	zmdc.pl	
2018-08-22 11:19:37.773270	zmdc		21266	INF	'zmfilter.pl' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.773230	zmdc		21109	INF	'zmfilter.pl' starting at 18/08/22 11:19:37, pid = 21266	zmdc.pl	
2018-08-22 11:19:37.703590	zmdc		21109	ERR	'zma -m 7' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:37.644640	zmdc		21257	INF	'zma -m 7' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.644640	zmdc		21109	INF	'zma -m 7' starting at 18/08/22 11:19:37, pid = 21257	zmdc.pl	
2018-08-22 11:19:37.633630	zmdc		21109	INF	Starting pending process, zma -m 7	zmdc.pl	
2018-08-22 11:19:37.628680	zmdc		21109	ERR	'zma -m 7' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:37.563770	zmdc		21250	INF	'zma -m 7' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.563600	zmdc		21109	INF	'zma -m 7' starting at 18/08/22 11:19:37, pid = 21250	zmdc.pl	
2018-08-22 11:19:37.427870	zmdc		21241	INF	'zmc -m 7' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.427750	zmdc		21109	INF	'zmc -m 7' starting at 18/08/22 11:19:37, pid = 21241	zmdc.pl	
2018-08-22 11:19:37.416900	zmdc		21109	INF	Starting pending process, zmc -m 7	zmdc.pl	
2018-08-22 11:19:37.409720	zmdc		21109	ERR	'zmc -m 7' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:37.362190	zmdc		21234	INF	'zmc -m 7' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.362080	zmdc		21109	INF	'zmc -m 7' starting at 18/08/22 11:19:37, pid = 21234	zmdc.pl	
2018-08-22 11:19:37.312060	zmdc		21109	ERR	'zma -m 6' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:37.244970	zmdc		21225	INF	'zma -m 6' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.244970	zmdc		21109	INF	'zma -m 6' starting at 18/08/22 11:19:37, pid = 21225	zmdc.pl	
2018-08-22 11:19:37.233620	zmdc		21109	INF	Starting pending process, zma -m 6	zmdc.pl	
2018-08-22 11:19:37.228370	zmdc		21109	ERR	'zma -m 6' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:37.161670	zmdc		21218	INF	'zma -m 6' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.161630	zmdc		21109	INF	'zma -m 6' starting at 18/08/22 11:19:37, pid = 21218	zmdc.pl	
2018-08-22 11:19:37.035880	zmdc		21209	INF	'zmc -m 6' started at 18/08/22 11:19:37	zmdc.pl	
2018-08-22 11:19:37.035870	zmdc		21109	INF	'zmc -m 6' starting at 18/08/22 11:19:37, pid = 21209	zmdc.pl	
2018-08-22 11:19:37.025200	zmdc		21109	INF	Starting pending process, zmc -m 6	zmdc.pl	
2018-08-22 11:19:37.015580	zmdc		21109	ERR	'zmc -m 6' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.954880	zmdc		21202	INF	'zmc -m 6' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.954700	zmdc		21109	INF	'zmc -m 6' starting at 18/08/22 11:19:36, pid = 21202	zmdc.pl	
2018-08-22 11:19:36.903870	zmdc		21109	ERR	'zma -m 5' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.836230	zmdc		21193	INF	'zma -m 5' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.836220	zmdc		21109	INF	'zma -m 5' starting at 18/08/22 11:19:36, pid = 21193	zmdc.pl	
2018-08-22 11:19:36.825130	zmdc		21109	INF	Starting pending process, zma -m 5	zmdc.pl	
2018-08-22 11:19:36.820230	zmdc		21109	ERR	'zma -m 5' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.751130	zmdc		21186	INF	'zma -m 5' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.750970	zmdc		21109	INF	'zma -m 5' starting at 18/08/22 11:19:36, pid = 21186	zmdc.pl	
2018-08-22 11:19:36.628080	zmdc		21177	INF	'zmc -m 5' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.628080	zmdc		21109	INF	'zmc -m 5' starting at 18/08/22 11:19:36, pid = 21177	zmdc.pl	
2018-08-22 11:19:36.616800	zmdc		21109	INF	Starting pending process, zmc -m 5	zmdc.pl	
2018-08-22 11:19:36.611330	zmdc		21109	ERR	'zmc -m 5' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.577010	zmdc		21109	ERR	'zma -m 1' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.545870	zmdc		21167	INF	'zmc -m 5' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.545740	zmdc		21109	INF	'zmc -m 5' starting at 18/08/22 11:19:36, pid = 21167	zmdc.pl	
2018-08-22 11:19:36.502910	zmdc		21163	INF	'zma -m 1' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.502900	zmdc		21109	INF	'zma -m 1' starting at 18/08/22 11:19:36, pid = 21163	zmdc.pl	
2018-08-22 11:19:36.489910	zmdc		21109	INF	Starting pending process, zma -m 1	zmdc.pl	
2018-08-22 11:19:36.409770	zmdc		21109	ERR	'zma -m 1' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.344930	zmdc		21151	INF	'zma -m 1' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.344760	zmdc		21109	INF	'zma -m 1' starting at 18/08/22 11:19:36, pid = 21151	zmdc.pl	
2018-08-22 11:19:36.336060	zmdc		21148	INF	'zmc -m 1' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.335930	zmdc		21109	INF	'zmc -m 1' starting at 18/08/22 11:19:36, pid = 21148	zmdc.pl	
2018-08-22 11:19:36.325110	zmdc		21109	INF	Starting pending process, zmc -m 1	zmdc.pl	
2018-08-22 11:19:36.291360	zmdc		21109	ERR	'zmc -m 1' exited abnormally, exit status 255	zmdc.pl	
2018-08-22 11:19:36.105050	zmdc		21138	INF	'zmc -m 1' started at 18/08/22 11:19:36	zmdc.pl	
2018-08-22 11:19:36.104960	zmdc		21109	INF	'zmc -m 1' starting at 18/08/22 11:19:36, pid = 21138	zmdc.pl	
2018-08-22 11:19:32.879030	zmdc		21109	INF	Server starting at 18/08/22 11:19:32	zmdc.pl	
2018-08-22 11:07:28.677480	zmdc		13256	INF	'zma -m 6' crashed, signal 8	zmdc.pl	
2018-08-22 11:07:26.152780	zmdc		13256	WAR	'zma -m 6' has not stopped at 18/08/22 11:07:26. Sending KILL to pid 13474	zmdc.pl	
2018-08-22 11:07:22.719700	zmdc		13256	WAR	'zma -m 6' has not stopped at 18/08/22 11:07:22. Sending KILL to pid 13474	zmdc.pl	
2018-08-22 11:07:20.860610	zmdc		13256	WAR	'zma -m 6' has not stopped at 18/08/22 11:07:20. Sending KILL to pid 13474	zmdc.pl	
2018-08-22 11:07:19.294020	zmdc		13256	WAR	'zma -m 6' has not stopped at 18/08/22 11:07:19. Sending KILL to pid 13474	zmdc.pl	
2018-08-22 11:07:17.952260	zmdc		13256	WAR	'zma -m 6' has not stopped at 18/08/22 11:07:17. Sending KILL to pid 13474	zmdc.pl	
2018-08-22 11:07:16.470400	zmdc		13256	WAR	'zma -m 6' has not stopped at 18/08/22 11:07:16. Sending KILL to pid 13474	zmdc.pl	
2018-08-22 11:07:00.552250	zmdc		13256	INF	'zma -m 6' sending stop to pid 13474 at 18/08/22 11:07:00	zmdc.pl	
PS: here is an unfiltered log, taken after today's restart ( after some system updates)

Code: Select all

2018-08-28 11:11:52.291701	zma_m6		1851	INF	CAM6: 2000 - Analysing at 4.02 fps	zm_monitor.cpp	1296
2018-08-28 11:11:52.054713	zma_m7		1897	INF	CAM7: 2000 - Analysing at 4.00 fps	zm_monitor.cpp	1296
2018-08-28 11:11:51.722044	zma_m5		1815	INF	CAM5: 2000 - Analysing at 4.00 fps	zm_monitor.cpp	1296
2018-08-28 11:11:49.042900	zmc_m7		1867	INF	CAM7: 2000 - Capturing at 4.00 fps	zm_monitor.cpp	3125
2018-08-28 11:11:48.538774	zmc_m6		1832	INF	CAM6: 2000 - Capturing at 4.00 fps	zm_monitor.cpp	3125
2018-08-28 11:11:47.691902	zmc_m5		1796	INF	CAM5: 2000 - Capturing at 4.00 fps	zm_monitor.cpp	3125
2018-08-28 11:11:44.058076	zma_m1		2014	INF	CAM1: 2000 - Analysing at 4.00 fps	zm_monitor.cpp	1296
2018-08-28 11:11:39.066816	zmc_m1		1762	INF	CAM1: 2000 - Capturing at 4.00 fps	zm_monitor.cpp	3125
2018-08-28 11:08:02.118116	zma_m6		1851	INF	CAM6: 1079 - Closing event 413827, alarm end	zm_monitor.cpp	1716
2018-08-28 11:08:02.108636	zma_m6		1851	INF	CAM6: 1079 - Left alarm state (413827) - 107(57) images	zm_monitor.cpp	1711
2018-08-28 11:07:55.877984	zma_m6		1851	INF	CAM6: 1054 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:07:43.019471	zma_m6		1851	INF	CAM6: 1000 - Analysing at 3.88 fps	zm_monitor.cpp	1296
2018-08-28 11:07:42.070205	zma_m7		1897	INF	CAM7: 1000 - Analysing at 3.91 fps	zm_monitor.cpp	1296
2018-08-28 11:07:41.729270	zma_m5		1815	INF	CAM5: 1000 - Analysing at 3.91 fps	zm_monitor.cpp	1296
2018-08-28 11:07:41.707827	zma_m6		1851	INF	CAM6: 997 - Opening new event 413827, alarm start	zm_monitor.cpp	1660
2018-08-28 11:07:41.629286	zma_m6		1851	INF	CAM6: 997 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:07:39.059296	zmc_m7		1867	INF	CAM7: 1000 - Capturing at 3.95 fps	zm_monitor.cpp	3125
2018-08-28 11:07:38.548135	zmc_m6		1832	INF	CAM6: 1000 - Capturing at 3.95 fps	zm_monitor.cpp	3125
2018-08-28 11:07:37.713365	zmc_m5		1796	INF	CAM5: 1000 - Capturing at 3.97 fps	zm_monitor.cpp	3125
2018-08-28 11:07:34.372449	zma_m1		2014	INF	CAM1: 1000 - Analysing at 4.08 fps	zm_monitor.cpp	1296
2018-08-28 11:07:30.893001	zma_m6		1851	INF	CAM6: 954 - Closing event 413826, alarm end	zm_monitor.cpp	1716
2018-08-28 11:07:30.882962	zma_m6		1851	INF	CAM6: 954 - Left alarm state (413826) - 54(3) images	zm_monitor.cpp	1711
2018-08-28 11:07:29.377209	zmc_m1		1762	INF	CAM1: 1000 - Capturing at 4.08 fps	zm_monitor.cpp	3125
2018-08-28 11:07:24.871336	zma_m6		1851	INF	CAM6: 929 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:07:24.756107	zma_m6		1851	INF	CAM6: 928 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:07:24.662796	zma_m6		1851	INF	CAM6: 927 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:07:23.668037	zma_m6		1851	INF	CAM6: 925 - Opening new event 413826, alarm start	zm_monitor.cpp	1660
2018-08-28 11:07:23.612551	zma_m6		1851	INF	CAM6: 925 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:07:05.600843	zma_m6		1851	INF	CAM6: 853 - Closing event 413825, alarm end	zm_monitor.cpp	1716
2018-08-28 11:07:05.596070	zma_m6		1851	INF	CAM6: 853 - Left alarm state (413825) - 123(54) images	zm_monitor.cpp	1711
2018-08-28 11:06:59.356257	zma_m6		1851	INF	CAM6: 828 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:06:48.927575	zma_m6		1851	INF	CAM6: 786 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:06:44.603474	zma_m6		1851	INF	CAM6: 769 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:06:43.905529	zma_m6		1851	INF	CAM6: 766 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:06:43.610324	zma_m6		1851	INF	CAM6: 765 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:06:42.924298	zma_m6		1851	INF	CAM6: 762 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:06:42.596480	zma_m6		1851	INF	CAM6: 761 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:06:41.200737	zma_m6		1851	INF	CAM6: 755 - Opening new event 413825, alarm start	zm_monitor.cpp	1660
2018-08-28 11:06:41.150568	zma_m6		1851	INF	CAM6: 755 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:06:10.325527	zma_m6		1851	INF	CAM6: 632 - Closing event 413824, alarm end	zm_monitor.cpp	1716
2018-08-28 11:06:10.315480	zma_m6		1851	INF	CAM6: 632 - Left alarm state (413824) - 92(42) images	zm_monitor.cpp	1711
2018-08-28 11:06:04.132662	zma_m6		1851	INF	CAM6: 607 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:05:53.666924	zma_m6		1851	INF	CAM6: 565 - Opening new event 413824, alarm start	zm_monitor.cpp	1660
2018-08-28 11:05:53.609096	zma_m6		1851	INF	CAM6: 565 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:05:19.764962	zma_m6		1851	INF	CAM6: 428 - Closing event 413823, alarm end	zm_monitor.cpp	1716
2018-08-28 11:05:19.356119	zma_m6		1851	INF	CAM6: 428 - Left alarm state (413823) - 127(33) images	zm_monitor.cpp	1711
2018-08-28 11:05:13.126494	zma_m6		1851	INF	CAM6: 403 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:05:11.375947	zma_m6		1851	INF	CAM6: 396 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:05:08.649175	zma_m6		1851	INF	CAM6: 385 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:05:07.663659	zma_m6		1851	INF	CAM6: 381 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:05:05.650109	zma_m6		1851	INF	CAM6: 373 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:05:02.157881	zma_m6		1851	INF	CAM6: 359 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:04:55.869468	zma_m6		1851	INF	CAM6: 334 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:04:55.815804	zma_m5		1815	INF	CAM5: 336 - Closing event 413822, alarm end	zm_monitor.cpp	1716
2018-08-28 11:04:55.807497	zma_m5		1815	INF	CAM5: 336 - Left alarm state (413822) - 51(1) images	zm_monitor.cpp	1711
2018-08-28 11:04:54.074286	zma_m6		1851	INF	CAM6: 326 - Opening new event 413823, alarm start	zm_monitor.cpp	1660
2018-08-28 11:04:53.885814	zma_m6		1851	INF	CAM6: 326 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:04:50.851448	zma_m5		1815	INF	CAM5: 311 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:04:49.669939	zma_m5		1815	INF	CAM5: 310 - Opening new event 413822, alarm start	zm_monitor.cpp	1660
2018-08-28 11:04:48.558978	zma_m5		1815	INF	CAM5: 310 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:04:17.106866	zma_m6		1851	INF	CAM6: 179 - Closing event 413821, alarm end	zm_monitor.cpp	1716
2018-08-28 11:04:17.096730	zma_m6		1851	INF	CAM6: 179 - Left alarm state (413821) - 89(17) images	zm_monitor.cpp	1711
2018-08-28 11:04:10.928986	zma_m6		1851	INF	CAM6: 154 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:04:10.625925	zma_m6		1851	INF	CAM6: 153 - Gone back into alarm state	zm_monitor.cpp	1695
2018-08-28 11:04:05.175927	zma_m6		1851	INF	CAM6: 131 - Gone into alert state	zm_monitor.cpp	1704
2018-08-28 11:04:00.519972	zma_m6		1851	INF	CAM6: 115 - Opening new event 413821, alarm start	zm_monitor.cpp	1660
2018-08-28 11:04:00.392962	zma_m6		1851	INF	CAM6: 115 - Gone into alarm state	zm_monitor.cpp	1614
2018-08-28 11:03:34.843866	zma_m7		1897	INF	In mode 3/1, warming up	zma.cpp	142
2018-08-28 11:03:34.311775	zma_m6		1851	INF	In mode 3/1, warming up	zma.cpp	142
2018-08-28 11:03:33.781158	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:33.754064	zma_m5		1815	INF	In mode 3/1, warming up	zma.cpp	142
2018-08-28 11:03:33.247601	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:32.755926	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:32.697738	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:32.230958	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:31.722586	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:31.497608	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:31.180853	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:30.664221	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:30.464163	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:30.147455	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:29.622533	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:29.447350	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:29.254656	zma_m1		2014	INF	In mode 3/1, warming up	zma.cpp	142
2018-08-28 11:03:29.142020	zmdc		2014	INF	'zma -m 1' started at 18/08/28 11:03:29	zmdc.pl	
2018-08-28 11:03:29.141880	zmdc		1660	INF	'zma -m 1' starting at 18/08/28 11:03:29, pid = 2014	zmdc.pl	
2018-08-28 11:03:29.105742	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:29.065490	zmdc		1660	INF	Starting pending process, zma -m 1	zmdc.pl	
2018-08-28 11:03:28.547324	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:28.422232	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:28.039046	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:27.999960	zmdc		1970	INF	'zmtelemetry.pl' started at 18/08/28 11:03:27	zmdc.pl	
2018-08-28 11:03:27.999950	zmdc		1660	INF	'zmtelemetry.pl' starting at 18/08/28 11:03:27, pid = 1970	zmdc.pl	
2018-08-28 11:03:27.597270	zmwatch		1939	INF	Watchdog pausing for 30 seconds	zmwatch.pl	
2018-08-28 11:03:27.593440	zmdc		1959	INF	'zmupdate.pl -c' started at 18/08/28 11:03:27	zmdc.pl	
2018-08-28 11:03:27.593190	zmdc		1660	INF	'zmupdate.pl -c' starting at 18/08/28 11:03:27, pid = 1959	zmdc.pl	
2018-08-28 11:03:27.578660	zmwatch		1939	INF	Watchdog starting	zmwatch.pl	
2018-08-28 11:03:27.530711	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:27.389672	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:27.168940	zmdc		1939	INF	'zmwatch.pl' started at 18/08/28 11:03:27	zmdc.pl	
2018-08-28 11:03:26.931297	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:26.843430	zmfilter		1900	INF	Scanning for events	zmfilter.pl	
2018-08-28 11:03:26.708620	zmdc		1923	INF	'zmaudit.pl -c' started at 18/08/28 11:03:26	zmdc.pl	
2018-08-28 11:03:26.708530	zmdc		1660	INF	'zmaudit.pl -c' starting at 18/08/28 11:03:26, pid = 1923	zmdc.pl	
2018-08-28 11:03:26.518281	zma_m7		1897	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:26.467160	zmdc		1900	INF	'zmfilter.pl' started at 18/08/28 11:03:26	zmdc.pl	
2018-08-28 11:03:26.467150	zmdc		1660	INF	'zmfilter.pl' starting at 18/08/28 11:03:26, pid = 1900	zmdc.pl	
2018-08-28 11:03:26.416240	zmdc		1897	INF	'zma -m 7' started at 18/08/28 11:03:26	zmdc.pl	
2018-08-28 11:03:26.416190	zmdc		1660	INF	'zma -m 7' starting at 18/08/28 11:03:26, pid = 1897	zmdc.pl	
2018-08-28 11:03:26.413794	zmc_m7		1867	INF	Priming capture from rtsp://admin:88Rcam61@192.168.0.7:554//Streaming/Channels/1?tcp	zm_ffmpeg_camera.cpp	104
2018-08-28 11:03:26.378392	zmc_m7		1867	INF	Starting Capture version 1.30.4	zmc.cpp	247
2018-08-28 11:03:26.347220	zmdc		1660	INF	Starting pending process, zma -m 7	zmdc.pl	
2018-08-28 11:03:26.338764	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:26.317690	zmdc		1660	ERR	'zma -m 7' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:26.246975	zma_m7		1878	ERR	Shared data not initialised by capture daemon for monitor CAM7	zm_monitor.cpp	442
2018-08-28 11:03:26.108470	zmdc		1878	INF	'zma -m 7' started at 18/08/28 11:03:26	zmdc.pl	
2018-08-28 11:03:26.108210	zmdc		1660	INF	'zma -m 7' starting at 18/08/28 11:03:26, pid = 1878	zmdc.pl	
2018-08-28 11:03:26.008100	zmdc		1867	INF	'zmc -m 7' started at 18/08/28 11:03:26	zmdc.pl	
2018-08-28 11:03:26.008040	zmdc		1660	INF	'zmc -m 7' starting at 18/08/28 11:03:26, pid = 1867	zmdc.pl	
2018-08-28 11:03:25.972160	zmdc		1660	INF	Starting pending process, zmc -m 7	zmdc.pl	
2018-08-28 11:03:25.966920	zmdc		1660	ERR	'zmc -m 7' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:25.884957	zma_m6		1851	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:25.872104	zmc_m6		1832	INF	Priming capture from rtsp://admin:88Rcam61@192.168.0.6:554//Streaming/Channels/1?tcp	zm_ffmpeg_camera.cpp	104
2018-08-28 11:03:25.829650	zmdc		1855	INF	'zmc -m 7' started at 18/08/28 11:03:25	zmdc.pl	
2018-08-28 11:03:25.829550	zmdc		1660	INF	'zmc -m 7' starting at 18/08/28 11:03:25, pid = 1855	zmdc.pl	
2018-08-28 11:03:25.827474	zmc_m6		1832	INF	Starting Capture version 1.30.4	zmc.cpp	247
2018-08-28 11:03:25.749820	zmdc		1851	INF	'zma -m 6' started at 18/08/28 11:03:25	zmdc.pl	
2018-08-28 11:03:25.749740	zmdc		1660	INF	'zma -m 6' starting at 18/08/28 11:03:25, pid = 1851	zmdc.pl	
2018-08-28 11:03:25.722150	zmdc		1660	INF	Starting pending process, zma -m 6	zmdc.pl	
2018-08-28 11:03:25.700780	zmdc		1660	ERR	'zma -m 6' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:25.672683	zma_m6		1839	ERR	Shared data not initialised by capture daemon for monitor CAM6	zm_monitor.cpp	442
2018-08-28 11:03:25.583970	zmdc		1839	INF	'zma -m 6' started at 18/08/28 11:03:25	zmdc.pl	
2018-08-28 11:03:25.583800	zmdc		1660	INF	'zma -m 6' starting at 18/08/28 11:03:25, pid = 1839	zmdc.pl	
2018-08-28 11:03:25.491200	zmdc		1832	INF	'zmc -m 6' started at 18/08/28 11:03:25	zmdc.pl	
2018-08-28 11:03:25.491040	zmdc		1660	INF	'zmc -m 6' starting at 18/08/28 11:03:25, pid = 1832	zmdc.pl	
2018-08-28 11:03:25.421970	zmdc		1660	INF	Starting pending process, zmc -m 6	zmdc.pl	
2018-08-28 11:03:25.374700	zmdc		1660	ERR	'zmc -m 6' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:25.320367	zma_m5		1815	WAR	Waiting for capture daemon	zm_monitor.cpp	503
2018-08-28 11:03:25.236000	zmdc		1819	INF	'zmc -m 6' started at 18/08/28 11:03:25	zmdc.pl	
2018-08-28 11:03:25.235880	zmdc		1660	INF	'zmc -m 6' starting at 18/08/28 11:03:25, pid = 1819	zmdc.pl	
2018-08-28 11:03:25.221967	zmc_m5		1796	INF	Priming capture from rtsp://admin:88Rcam61@192.168.0.5:554//Streaming/Channels/1?tcp	zm_ffmpeg_camera.cpp	104
2018-08-28 11:03:25.211036	zmc_m5		1796	INF	Starting Capture version 1.30.4	zmc.cpp	247
2018-08-28 11:03:25.199340	zmdc		1815	INF	'zma -m 5' started at 18/08/28 11:03:25	zmdc.pl	
2018-08-28 11:03:25.199340	zmdc		1660	INF	'zma -m 5' starting at 18/08/28 11:03:25, pid = 1815	zmdc.pl	
2018-08-28 11:03:25.180270	zmdc		1660	INF	Starting pending process, zma -m 5	zmdc.pl	
2018-08-28 11:03:25.142580	zmdc		1660	ERR	'zma -m 5' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:25.091698	zma_m5		1806	ERR	Shared data not initialised by capture daemon for monitor CAM5	zm_monitor.cpp	442
2018-08-28 11:03:24.984310	zmdc		1806	INF	'zma -m 5' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.984170	zmdc		1660	INF	'zma -m 5' starting at 18/08/28 11:03:24, pid = 1806	zmdc.pl	
2018-08-28 11:03:24.939696	zmc_m1		1762	INF	Starting Capture version 1.30.4	zmc.cpp	247
2018-08-28 11:03:24.883100	zmdc		1796	INF	'zmc -m 5' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.882790	zmdc		1660	INF	'zmc -m 5' starting at 18/08/28 11:03:24, pid = 1796	zmdc.pl	
2018-08-28 11:03:24.871990	zmdc		1660	INF	Starting pending process, zmc -m 5	zmdc.pl	
2018-08-28 11:03:24.861680	zmdc		1660	ERR	'zmc -m 5' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:24.794500	zmdc		1787	INF	'zmc -m 5' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.794500	zmdc		1660	INF	'zmc -m 5' starting at 18/08/28 11:03:24, pid = 1787	zmdc.pl	
2018-08-28 11:03:24.750200	zmdc		1660	ERR	'zma -m 1' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:24.739827	zma_m1		1776	ERR	Shared data not initialised by capture daemon for monitor CAM1	zm_monitor.cpp	442
2018-08-28 11:03:24.683590	zmdc		1776	INF	'zma -m 1' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.683190	zmdc		1660	INF	'zma -m 1' starting at 18/08/28 11:03:24, pid = 1776	zmdc.pl	
2018-08-28 11:03:24.671980	zmdc		1660	INF	Starting pending process, zma -m 1	zmdc.pl	
2018-08-28 11:03:24.667390	zmdc		1660	ERR	'zma -m 1' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:24.648452	zma_m1		1765	ERR	Shared data not initialised by capture daemon for monitor CAM1	zm_monitor.cpp	442
2018-08-28 11:03:24.591340	zmdc		1765	INF	'zma -m 1' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.591230	zmdc		1660	INF	'zma -m 1' starting at 18/08/28 11:03:24, pid = 1765	zmdc.pl	
2018-08-28 11:03:24.582830	zmdc		1762	INF	'zmc -m 1' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.582730	zmdc		1660	INF	'zmc -m 1' starting at 18/08/28 11:03:24, pid = 1762	zmdc.pl	
2018-08-28 11:03:24.572030	zmdc		1660	INF	Starting pending process, zmc -m 1	zmdc.pl	
2018-08-28 11:03:24.538860	zmdc		1660	ERR	'zmc -m 1' exited abnormally, exit status 255	zmdc.pl	
2018-08-28 11:03:24.332140	zmdc		1747	INF	'zmc -m 1' started at 18/08/28 11:03:24	zmdc.pl	
2018-08-28 11:03:24.332020	zmdc		1660	INF	'zmc -m 1' starting at 18/08/28 11:03:24, pid = 1747	zmdc.pl	
2018-08-28 11:03:24.106770	zmpkg		1631	INF	Single server configuration detected. Starting up services.	zmpkg.pl	
2018-08-28 11:03:19.098870	zmdc		1660	INF	Server starting at 18/08/28 11:03:19	zmdc.pl	
2018-08-28 11:03:18.613760	zmpkg		1631	INF	Command: start	zmpkg.pl	
2018-08-28 11:03:18.110610	zmpkg		1631	INF	Sanity checking States table...	zmpkg.pl	
2018-08-28 11:01:12.395960	zmdc		21109	INF	Server shutdown at 18/08/28 11:01:12	zmdc.pl	
2018-08-28 11:01:02.131900	zmdc		21109	INF	'zmc -m 7' exited normally	zmdc.pl	
2018-08-28 11:01:02.102060	zmdc		21109	INF	'zma -m 1' exited normally	zmdc.pl	
2018-08-28 11:01:02.022420	zmdc		21109	INF	'zmc -m 5' exited normally	zmdc.pl	
2018-08-28 11:01:02.012170	zmdc		21109	INF	'zmtelemetry.pl' exited, signal 14	zmdc.pl	
2018-08-28 11:01:01.997481	zma_m1		21335	INF	Got signal 15 (Terminated), exiting	zm_signal.cpp	40
2018-08-28 11:01:01.997480	zmdc		21109	INF	'zmtelemetry.pl' sending stop to pid 21312 at 18/08/28 11:01:01	zmdc.pl	
2018-08-28 11:01:01.987350	zmdc		21109	INF	'zma -m 6' exited normally	zmdc.pl	
2018-08-28 11:01:01.880840	zmdc		21109	INF	'zmc -m 1' exited normally	zmdc.pl	
2018-08-28 11:01:01.787120	zmdc		21109	INF	'zma -m 1' sending stop to pid 21335 at 18/08/28 11:01:01	zmdc.pl	
2018-08-28 11:01:01.787096	zmc_m7		21241	INF	Got signal 15 (Terminated), exiting	zm_signal.cpp	40
2018-08-28 11:01:01.747445	zma_m6		21347	INF	Got signal 15 (Terminated), exiting	zm_signal.cpp	40
2018-08-28 11:01:01.747390	zmdc		21109	INF	'zmc -m 7' sending stop to pid 21241 at 18/08/28 11:01:01	zmdc.pl	
2018-08-28 11:01:01.737230	zmdc		21109	INF	'zma -m 5' exited normally	zmdc.pl	
2018-08-28 11:01:01.653785	zma_m5		21338	INF	Got signal 15 (Terminated), exiting	zm_signal.cpp	40
2018-08-28 11:01:01.653770	zmdc		21109	INF	'zma -m 6' sending stop to pid 21347 at 18/08/28 11:01:01	zmdc.pl	
2018-08-28 11:01:01.530940	zmdc		21109	INF	'zma -m 5' sending stop to pid 21338 at 18/08/28 11:01:01	zmdc.pl	
2018-08-28 11:01:01.530884	zmc_m5		21177	INF	Got signal 15 (Terminated), exiting	zm_signal.cpp	40
2018-08-28 11:01:01.512075	zmc_m1		21148	ERR	Unable to get response, disconnecting	zm_remote_camera_http.cpp	1141
2018-08-28 11:01:01.322610	zmdc		21109	INF	'zmc -m 6' exited normally	zmdc.pl	
2018-08-28 11:01:01.272279	zmc_m1		21148	ERR	Unable to read subheader	zm_remote_camera_http.cpp	977
2018-08-28 11:01:01.239040	zmdc		21109	INF	'zma -m 7' exited normally	zmdc.pl	
2018-08-28 11:01:01.230631	zmc_m1		21148	ERR	Select error: Interrupted system call	zm_remote_camera_http.cpp	175
2018-08-28 11:01:01.222510	zmdc		21109	INF	'zmc -m 5' sending stop to pid 21177 at 18/08/28 11:01:01	zmdc.pl	
2018-08-28 11:01:01.222425	zmc_m1		21148	INF	Got signal 15 (Terminated), exiting	zm_signal.cpp	40
Backisen
Posts: 2
Joined: Mon Sep 24, 2018 6:15 am

Re: random crashing

Post by Backisen »

Have someone found a solution for this? I am seeing the same problem in my log. Updated som linux components yesterday so that is likely the problem.
bbunge
Posts: 2930
Joined: Mon Mar 26, 2012 11:40 am
Location: Pennsylvania

Re: random crashing

Post by bbunge »

Backisen wrote: Mon Sep 24, 2018 6:19 am Have someone found a solution for this? I am seeing the same problem in my log. Updated som linux components yesterday so that is likely the problem.
Linux distro and version?
MySQL or Mariadb?
What free space do you have in tmpfs (/dev/shm)?
Have you run mysqltuner to see if you need to allocate more resources to your database program?
Backisen
Posts: 2
Joined: Mon Sep 24, 2018 6:15 am

Re: random crashing

Post by Backisen »

bbunge wrote: Tue Sep 25, 2018 1:49 am
Backisen wrote: Mon Sep 24, 2018 6:19 am Have someone found a solution for this? I am seeing the same problem in my log. Updated som linux components yesterday so that is likely the problem.
Linux distro and version?
MySQL or Mariadb?
What free space do you have in tmpfs (/dev/shm)?
Have you run mysqltuner to see if you need to allocate more resources to your database program?
It's a virtual machine running on FreeNAS with Ubuntu 16.04.5 LTS
MySQL 5.7.23

Code: Select all

tmpfs                          976M     0  976M   0% /dev/shm
Output from mysqltuner --noinfo:

Code: Select all

 >>  MySQLTuner 1.6.0 - Major Hayden <major@mhtx.net>
 >>  Bug reports, feature requests, and downloads at http://mysqltuner.com/
 >>  Run with '--help' for additional options and output filtering
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
[OK] Currently running supported MySQL version 5.7.23-0ubuntu0.16.04.1
[OK] Operating on 64-bit architecture

-------- Storage Engine Statistics -------------------------------------------
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
[!!] Total fragmented tables: 2
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.

-------- Security Recommendations  -------------------------------------------
mysql: [Warning] Using a password on the command line interface can be insecure.
[OK] There is no anonymous account in all database users
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
[OK] All database users have passwords assigned
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 1054 (42S22) at line 1: Unknown column 'password' in 'where clause'
mysql: [Warning] Using a password on the command line interface can be insecure.
mysql: [Warning] Using a password on the command line interface can be insecure.

-------- Performance Metrics -------------------------------------------------
[OK] Maximum reached memory usage: 1.1G (39.87% of installed RAM)
[OK] Maximum possible memory usage: 1.1G (39.65% of installed RAM)
[OK] Slow queries: 0% (0/746K)
[!!] Highest connection usage: 100%  (152/151)
[OK] Aborted connections: 0.35%  (402/113958)
[OK] Query cache efficiency: 89.3% (212K cached / 238K selects)
[OK] Query cache prunes per day: 0
[OK] Sorts requiring temporary tables: 0% (0 temp sorts / 3K sorts)
[OK] Temporary tables created on disk: 22% (12K on disk / 56K total)
[OK] Thread cache hit rate: 99% (707 created / 113K connections)
[!!] Table cache hit rate: 18% (368 open / 1K opened)
[OK] Open file limit used: 2% (25/1K)
[OK] Table locks acquired immediately: 100% (102K immediate / 102K locks)

-------- MyISAM Metrics -----------------------------------------------------
[!!] Key buffer used: 18.2% (3M used / 16M cache)
[OK] Key buffer size / total MyISAM indexes: 16.0M/43.0K
[!!] Read Key buffer hit rate: 83.3% (186 cached / 31 reads)

-------- InnoDB Metrics -----------------------------------------------------
[OK] InnoDB buffer pool / data size: 128.0M/95.3M
[OK] InnoDB buffer pool instances: 1
[!!] InnoDB Used buffer: 61.80% (5062 used/ 8191 total)
[OK] InnoDB Read buffer efficiency: 100.00% (87509487 hits/ 87512018 total)
[!!] InnoDB Write buffer efficiency: 0.00% (0 hits/ 1 total)
[OK] InnoDB log waits: 0.00% (0 waits / 288587 writes)

-------- AriaDB Metrics -----------------------------------------------------

-------- Replication Metrics -------------------------------------------------

-------- Recommendations -----------------------------------------------------
General recommendations:
    Run OPTIMIZE TABLE to defragment tables for better performance
    Reduce or eliminate persistent connections to reduce connection usage
    Increase table_open_cache gradually to avoid file descriptor limits
    Read this before increasing table_open_cache over 64: http://bit.ly/1mi7c4C
    Beware that open_files_limit (1024) variable
    should be greater than table_open_cache ( 431)
Variables to adjust:
    max_connections (> 151)
    wait_timeout (< 28800)
    interactive_timeout (< 28800)
    table_open_cache (> 431)
computer_freak_8
Posts: 7
Joined: Sun May 14, 2017 5:13 am

Re: random crashing

Post by computer_freak_8 »

Must be a bug in 1.30.4? I'm having this issue also, I had it a while back, then a ZM update came out and it was stable, then another ZM update came out and now I'm back to having it run between minutes and hours, then stopping. I can restart it from the WebUI (click "stopped", change state to "start", click "apply")

My setup (this is a VM dedicated to ZoneMinder):
1.30.4

Code: Select all

$ uname -r
3.16.0-4-amd64
$ lsb_release -sir
Debian
9.5
$ cat /proc/cpuinfo | grep model
model           : 4
model name      : AMD Phenom(tm) II X4 955 Processor
model           : 4
model name      : AMD Phenom(tm) II X4 955 Processor
$ cat /proc/meminfo | grep -i total
MemTotal:        4110428 kB
SwapTotal:        524284 kB
VmallocTotal:   34359738367 kB

Code: Select all

Nov  4 16:11:01 zoneminder zmwatch[31011]: ERR [Error getting last capture time for  Dericam]
Nov  4 16:11:01 zoneminder zmc_m6[22619]: ERR [Error while decoding frame 251]
Nov  4 16:11:01 zoneminder zmwatch[31011]: INF [Restarting analysis daemon for  Dericam]
Nov  4 16:11:01 zoneminder zmc_m6[22619]: ERR [8: 00 00 01 06 e5 01 70 80]
Nov  4 16:11:01 zoneminder zmdc[30941]: INF ['zma -m 6' sending stop to pid 22531 at 18/11/04 16:11:01]
Nov  4 16:11:02 zoneminder zma_m6[22531]: INF [Got signal 15 (Terminated), exiting]
Nov  4 16:11:02 zoneminder zmdc[30941]: INF ['zma -m 6' exited normally]
Nov  4 16:11:03 zoneminder zmc_m6[22619]: ERR [Error while decoding frame 301]
Nov  4 16:11:04 zoneminder zmc_m6[22619]: ERR [8: 00 00 01 06 e5 01 72 80]
Nov  4 16:11:07 zoneminder zma_m1[19299]: INF [Foscam_direct: 168578 - Gone into alarm state]
Nov  4 16:11:07 zoneminder zma_m1[19299]: INF [Foscam_direct: 168578 - Opening new event 35092, alarm start]
Nov  4 16:11:08 zoneminder zma_m1[19299]: INF [Foscam_direct: 168579 - Gone into alert state]
Nov  4 16:11:08 zoneminder zmc_m6[22619]: ERR [RTSP timed out]
Nov  4 16:11:10 zoneminder zmc_m6[22619]: ERR [Failed to pre-capture monitor 6 424516292 (1/1)]
Nov  4 16:11:10 zoneminder zmdc[30941]: ERR ['zmc -m 6' exited abnormally, exit status 255]
Nov  4 16:11:11 zoneminder zma_m1[19299]: INF [Foscam_direct: 168604 - Left alarm state (35092) - 51(1) images]
Nov  4 16:11:11 zoneminder zma_m1[19299]: INF [Foscam_direct: 168604 - Closing event 35092, alarm end]
Nov  4 16:11:12 zoneminder zmwatch[31011]: ERR [Memory map file '/dev/shm/zm.mmap.6' does not exist.  zmc might not be running.]
Nov  4 16:11:12 zoneminder zmwatch[31011]: INF [Restarting capture daemon for Dericam, shared data not valid]
Nov  4 16:11:12 zoneminder zmdc[30941]: INF ['zmc -m 6' starting at 18/11/04 16:11:12, pid = 22634]
Nov  4 16:11:12 zoneminder zmdc[22634]: INF ['zmc -m 6' started at 18/11/04 16:11:12]
Nov  4 16:11:12 zoneminder zmdc[30941]: ERR ['zmc -m 6' exited abnormally, exit status 255]
Nov  4 16:11:22 zoneminder zmwatch[31011]: INF [Restarting capture daemon for Dericam, shared data not valid]
Nov  4 16:11:23 zoneminder zmdc[30941]: INF ['zmc -m 6' starting at 18/11/04 16:11:23, pid = 22639]
Nov  4 16:11:23 zoneminder zmdc[22639]: INF ['zmc -m 6' started at 18/11/04 16:11:23]
Nov  4 16:11:23 zoneminder zmc_m6[22639]: INF [Starting Capture version 1.30.4]
Nov  4 16:11:33 zoneminder zmc_m6[22639]: FAT [No RTSP sources]
Nov  4 16:11:33 zoneminder zmdc[30941]: ERR ['zmc -m 6' exited abnormally, exit status 255]
Nov  4 16:11:50 zoneminder zma_m1[19299]: INF [Foscam_direct: 169000 - Analysing at 9.43 fps]
Nov  4 16:12:29 zoneminder zmc_m1[20611]: INF [Foscam_direct: 109000 - Capturing at 10.00 fps]
Nov  4 16:13:30 zoneminder zma_m1[19299]: INF [Foscam_direct: 170000 - Analysing at 10.00 fps]
Nov  4 16:14:09 zoneminder zmc_m1[20611]: INF [Foscam_direct: 110000 - Capturing at 10.00 fps]
Nov  4 16:15:10 zoneminder zma_m1[19299]: INF [Foscam_direct: 171000 - Analysing at 10.00 fps]
Nov  4 16:15:49 zoneminder zmc_m1[20611]: INF [Foscam_direct: 111000 - Capturing at 10.00 fps]
Nov  4 16:16:50 zoneminder zma_m1[19299]: INF [Foscam_direct: 172000 - Analysing at 10.00 fps]
Nov  4 16:17:29 zoneminder zmc_m1[20611]: INF [Foscam_direct: 112000 - Capturing at 10.00 fps]
Nov  4 16:17:54 zoneminder zmc_m1[20611]: WAR [Unexpected format RTSP interleaved data, resyncing by 201 bytes]
Nov  4 16:17:59 zoneminder zmc_m1[20611]: ERR [Unexpected channel selector 157 in RTSP interleaved data]
Nov  4 16:17:59 zoneminder zmc_m1[20611]: WAR [Unexpected format RTSP interleaved data, resyncing by 12 bytes]
Nov  4 16:18:00 zoneminder zmc_m1[20611]: WAR [12: 4d 18 07 1c 65 6c 5c d0 9f a4 a7 5e]
Nov  4 16:18:01 zoneminder zmc_m1[20611]: WAR [Packet in sequence, gap 34]
Nov  4 16:18:01 zoneminder zmc_m1[20611]: WAR [Discarding partial frame 116124, 27250 bytes]
Nov  4 16:18:01 zoneminder zmc_m1[20611]: WAR [Unexpected format RTSP interleaved data, resyncing by 8 bytes]
Nov  4 16:18:01 zoneminder zmc_m1[20611]: WAR [8: b6 71 79 4f 8a a7 65 28]
Nov  4 16:18:03 zoneminder zmwatch[31011]: INF [Restarting capture daemon for Foscam_direct, time since last capture 10 seconds (1541369883-1541369873)]
Nov  4 16:18:03 zoneminder zmdc[30941]: INF ['zmc -m 1' sending stop to pid 20611 at 18/11/04 16:18:03]
Nov  4 16:18:03 zoneminder zmc_m1[20611]: INF [Got signal 15 (Terminated), exiting]
Nov  4 16:18:09 zoneminder zmc_m1[20611]: ERR [Unexpected channel selector 98 in RTSP interleaved data]
Nov  4 16:18:09 zoneminder zmc_m1[20611]: WAR [Unexpected format RTSP interleaved data, resyncing by 202 bytes]
Nov  4 16:18:09 zoneminder zmdc[30941]: WAR ['zmc -m 1' has not stopped at 18/11/04 16:18:09. Sending KILL to pid 20611]
Nov  4 16:18:09 zoneminder zmdc[30941]: INF ['zmc -m 1' crashed, signal 8]
Nov  4 16:18:10 zoneminder zmdc[30941]: INF [Starting pending process, zmc -m 1]
Nov  4 16:18:10 zoneminder zmdc[30941]: INF ['zmc -m 1' starting at 18/11/04 16:18:10, pid = 22715]
Nov  4 16:18:10 zoneminder zmdc[22715]: INF ['zmc -m 1' started at 18/11/04 16:18:10]
Nov  4 16:18:10 zoneminder zmc_m1[22715]: INF [Starting Capture version 1.30.4]
Nov  4 16:18:20 zoneminder zmc_m1[22715]: FAT [No RTSP sources]
Nov  4 16:18:20 zoneminder zmdc[30941]: ERR ['zmc -m 1' exited abnormally, exit status 255]
Nov  4 16:18:25 zoneminder zmdc[30941]: INF [Starting pending process, zmc -m 1]
Nov  4 16:18:25 zoneminder zmdc[30941]: INF ['zmc -m 1' starting at 18/11/04 16:18:25, pid = 22718]
Nov  4 16:18:25 zoneminder zmdc[22718]: INF ['zmc -m 1' started at 18/11/04 16:18:25]
Nov  4 16:18:25 zoneminder zmc_m1[22718]: INF [Starting Capture version 1.30.4]
Nov  4 16:18:33 zoneminder zmc_m1[22718]: INF [Received new Content-Base in DESCRIBE response header. Updated device Url to: 'rtsp://192.168.3.212:65534/videoMain/']
Nov  4 16:18:51 zoneminder zmc_m1[22718]: ERR [RTSP timed out]
Nov  4 16:18:52 zoneminder zmc_m1[22718]: ERR [Failed to pre-capture monitor 1 -1817724220 (1/1)]
Nov  4 16:18:52 zoneminder zmdc[30941]: ERR ['zmc -m 1' exited abnormally, exit status 255]
Nov  4 16:18:52 zoneminder zma_m1[19299]: WAR [Signal: Lost]
Nov  4 16:18:59 zoneminder zmwatch[31011]: ERR [Memory map file '/dev/shm/zm.mmap.1' does not exist.  zmc might not be running.]
Nov  4 16:18:59 zoneminder zmwatch[31011]: INF [Restarting capture daemon for Foscam_direct, shared data not valid]
Nov  4 16:19:00 zoneminder zmdc[30941]: INF ['zmc -m 1' starting at 18/11/04 16:19:00, pid = 22731]
Nov  4 16:19:00 zoneminder zmdc[22731]: INF ['zmc -m 1' started at 18/11/04 16:19:00]
Nov  4 16:19:00 zoneminder zmdc[30941]: ERR ['zmc -m 1' exited abnormally, exit status 255]
Nov  4 16:19:10 zoneminder zmwatch[31011]: INF [Restarting capture daemon for Foscam_direct, shared data not valid]
Nov  4 16:19:10 zoneminder zmdc[30941]: INF ['zmc -m 1' starting at 18/11/04 16:19:10, pid = 22735]
Nov  4 16:19:10 zoneminder zmdc[22735]: INF ['zmc -m 1' started at 18/11/04 16:19:10]
Nov  4 16:19:11 zoneminder zmc_m1[22735]: INF [Starting Capture version 1.30.4]
Nov  4 16:19:14 zoneminder zmc_m1[22735]: INF [Received new Content-Base in DESCRIBE response header. Updated device Url to: 'rtsp://192.168.3.212:65534/videoMain/']
Nov  4 16:19:30 zoneminder zmwatch[31011]: ERR [Error getting last capture time for  Foscam_direct]
Nov  4 16:19:31 zoneminder zmwatch[31011]: INF [Restarting analysis daemon for  Foscam_direct]
Nov  4 16:19:31 zoneminder zmdc[30941]: INF ['zma -m 1' sending stop to pid 19299 at 18/11/04 16:19:31]
Nov  4 16:19:31 zoneminder zma_m1[19299]: INF [Got signal 15 (Terminated), exiting]
Nov  4 16:19:31 zoneminder zmdc[30941]: INF ['zma -m 1' exited normally]
Nov  4 16:19:31 zoneminder zmdc[30941]: INF [Starting pending process, zma -m 1]
Nov  4 16:19:31 zoneminder zmdc[30941]: INF ['zma -m 1' starting at 18/11/04 16:19:31, pid = 22740]
Nov  4 16:19:31 zoneminder zmdc[22740]: INF ['zma -m 1' started at 18/11/04 16:19:31]
Nov  4 16:19:32 zoneminder zma_m1[22740]: INF [In mode 3/1, warming up]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, dumping 233 bytes]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [32: 3a 65 27 34 73 90 8f a5 97 5c 7a f1 97 f0 7a 7f 43 d8 30 cf 8c 27 48 9f 91 98 fa 8b 18 dd b3 48]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, resyncing by 4 bytes]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [4: 6c 70 a1 7b]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [Packet in sequence, gap 2]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [Discarding partial frame 17, 1438 bytes]
Nov  4 16:19:39 zoneminder zmc_m1[22735]: WAR [Discarding incomplete frame 17, 0 bytes]
Nov  4 16:19:42 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, resyncing by 311 bytes]
Nov  4 16:19:42 zoneminder zmc_m1[22735]: ERR [Can't insert log entry: sql(insert into Logs ( TimeKey, Component, ServerId, Pid, Level, Code, Message, File, Line ) values ( 1541369982.067752, 'zmc_m1', 0, 22736, -1, 'WAR', '311: c4 16 86 7c 0d 7d 3a cf 4a 99 83 b9 b4 98 0e f9 86 db e2 f0 94 86 79 45 01 e9 6c 4c 80 3a e7 7b e9 92 70 f0 be f6 f2 56 bb 21 c3 c2 15 6c b6 8c f4 8f c3 37 bd d9 a9 28 18 b4 82 e7 c1 27 34 5d 82 0e 92 f3 3c 0d 80 52 40 cd 4e 46 9c f2 82 ec 95 c9 f5 de b8 80 d9 bc fd 5d ea 84 0d 32 ab 80 5f e0 4e 15 7b 33 64 8c 20 2e 65 9f 43 ba 29 1a fa 8d f3 46 43 ca 11 42 5a 5d 23 5a b9 13 a9 85 3d 9a 3e 96 9d 65 2b 26 f8 ec d9 90 9b 81 20 0d 37 75 79 22 3f d8 4e df a8 1b 76 0d c1 aa 91 f9 d7 a3 57 5e 63 a5 94 9f 96 26 e9 e1 c7 c2 e1 e5 ef 16 8e 2d ed b4 74 59 a3 46 fa 4e 3c 2a d3 09 cd 75 91 5a b8 f6 2a 56 96 ec a4 2b e3 bd 0c 95 1a 47 fb db 3b f8 8e 9c 54 0a 7b 82 68 83 fc cf e7 f3 6d 83 d9 f4 e2 6b 2a 94 c0 a2 59 73 bf 50 dd 42 13 a4 01 5a 55 51 65 98 e9 67 b2 33 9d 97 1b f4 78 4c 3e 62 b8 b2 84 b1 04 3d 3d 49 30 9a e2 59 fa 86 56 77 7c ca 86 31 ef fc b5 56 80 a6 95 6a) error(You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ''311: c4 16 86 7c 0d 7d 3a cf 4a 99 83 b9 b4 98 0e f9 86 db e2 f0 94 86 79 45 01' at line 1)]
Nov  4 16:19:42 zoneminder zmc_m1[22735]: WAR [311: c4 16 86 7c 0d 7d 3a cf 4a 99 83 b9 b4 98 0e f9 86 db e2 f0 94 86 79 45 01 e9 6c 4c 80 3a e7 7b e9 92 70 f0 be f6 f2 56 bb 21 c3 c2 15 6c b6 8c f4 8f c3 37 bd d9 a9 28 18 b4 82 e7 c1 27 34 5d 82 0e 92 f3 3c 0d 80 52 40 cd 4e 46 9c f2 82 ec 95 c9 f5 de b8 80 d9 bc fd 5d ea 84 0d 32 ab 80 5f e0 4e 15 7b 33 64 8c 20 2e 65 9f 43 ba 29 1a fa 8d f3 46 43 ca 11 42 5a 5d 23 5a b9 13 a9 85 3d 9a 3e 96 9d 65 2b 26 f8 ec d9 90 9b 81 20 0d 37 75 79 22 3f d8 4e df a8 1b 76 0d c1 aa 91 f9 d7 a3 57 5e 63 a5 94 9f 96 26 e9 e1 c7 c2 e1 e5 ef 16 8e 2d ed b4 74 59 a3 46 fa 4e 3c 2a d3 09 cd 75 91 5a b8 f6 2a 56 96 ec a4 2b e3 bd 0c 95 1a 47 fb db 3b f8 8e 9c 54 0a 7b 82 68 83 fc cf e7 f3 6d 83 d9 f4 e2 6b 2a 94 c0 a2 59 73 bf 50 dd 42 13 a4 01 5a 55 51 65 98 e9 67 b2 33 9d 97 1b f4 78 4c 3e 62 b8 b2 84 b1 04 3d 3d 49 30 9a e2 59 fa 86 56 77 7c ca 86 31 ef fc b5 56 80 a6 95 6a 35 74 5e 04 9d 77 66 32 96 f3 e5 93 9e 39 67 c5 ed 89 95 c5 57]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: ERR [Unexpected channel selector 18 in RTSP interleaved data]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, resyncing by 4 bytes]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [4: 53 59 12 e8]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [Packet in sequence, gap 23]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [Discarding frame 19]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [Discarding incomplete frame 19, 0 bytes]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, resyncing by 58 bytes]
Nov  4 16:19:45 zoneminder zmc_m1[22735]: WAR [58: bf 9a 9f 4f 91 b0 44 1d 60 9a cd f4 95 44 11 c9 26 c3 5a 4b a9 fd b9 36 2a c1 1e 59 69 e9 db 00 fa 58 ed 9c 68 09 44 ac 5b 1b 46 8f 02 e9 9e 34 5e 0a 72 93 ef cd fc 7c f9 3f]
Nov  4 16:19:47 zoneminder zmc_m1[22735]: ERR [Unexpected channel selector 97 in RTSP interleaved data]
Nov  4 16:19:47 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, resyncing by 86 bytes]
Nov  4 16:19:47 zoneminder zmc_m1[22735]: WAR [86: 5e 0d f0 99 32 3d 9c 39 3b be d2 00 a8 b1 9a dd 4c 68 58 1f 6b 1f cb 40 ea ee e1 9c b7 dc 3c 97 52 ac d0 fc 66 11 2c 6a 13 1c d7 16 30 61 41 56 23 7c 64 d9 2c de 4b b3 47 39 fd 58 2d c9 90 50 b7 3c fb 7c 19 a4 60 a9 54 8d e3 40 2f 74 ea 46 ef a9 65 3d 6a 93]
Nov  4 16:19:51 zoneminder zmc_m1[22735]: ERR [Unexpected channel selector 211 in RTSP interleaved data]
Nov  4 16:19:51 zoneminder zmwatch[31011]: INF [Restarting capture daemon for Foscam_direct, time since last capture 6 seconds (1541369991-1541369985)]
Nov  4 16:19:51 zoneminder zmdc[30941]: INF ['zmc -m 1' sending stop to pid 22735 at 18/11/04 16:19:51]
Nov  4 16:19:51 zoneminder zmc_m1[22735]: INF [Got signal 15 (Terminated), exiting]
Nov  4 16:19:52 zoneminder zmc_m1[22735]: WAR [Unexpected format RTSP interleaved data, resyncing by 4 bytes]
Nov  4 16:19:53 zoneminder zmc_m1[22735]: WAR [4: 2f 05 69 45]
Nov  4 16:19:53 zoneminder zmc_m1[22735]: WAR [Packet in sequence, gap 43]
Nov  4 16:19:53 zoneminder zmc_m1[22735]: WAR [Discarding partial frame 20, 2872 bytes]
Nov  4 16:19:57 zoneminder zmdc[30941]: WAR ['zmc -m 1' has not stopped at 18/11/04 16:19:57. Sending KILL to pid 22735]
Nov  4 16:19:57 zoneminder zmdc[30941]: INF ['zmc -m 1' exited normally]
Nov  4 16:19:58 zoneminder zmpkg[22752]: INF [Sanity checking States table...]
Nov  4 16:19:58 zoneminder zmpkg[22752]: INF [Command: stop]
Nov  4 16:19:58 zoneminder zma_m1[22740]: INF [Got signal 15 (Terminated), exiting]
Potentially related:
viewtopic.php?t=25037

viewtopic.php?t=25816
computer_freak_8
Posts: 7
Joined: Sun May 14, 2017 5:13 am

Re: random crashing

Post by computer_freak_8 »

In case anyone wants it, I set this up to help keep video going when ZoneMinder decides to crash. Definitely not a fix, but a usable workaround until things get fixed. Do the devs watch these threads? Are we better off just installing a newer version and trying our luck there?

Line in root crontab:

Code: Select all

0,5,10,15,20,25,30,35,40,45,55 * * * * /opt/scripts/zm-restart.sh

The "zm-restart.sh" script:

Code: Select all

#!/bin/bash

# location:
# /opt/scripts/zm-restart.sh

date -Iseconds >> /opt/log/zm-restart.log
MYVAR=`tail /var/log/zm/zm.log | grep 'Got signal 15' | wc -l`
if [ $MYVAR = "0" ]; then
        echo "guessing it is still running"
        echo "doing nothing" >> /opt/log/zm-restart.log
else
        echo "guessing it has quit"
        /usr/sbin/service zoneminder start
        echo "attempted to restart zoneminder" >> /opt/log/zm-restart.log
fi
echo "" >> /opt/log/zm-restart.log
Locked