[Solved] Only New Events

[Pedulla]

Ubuntu 14.04.5 LTS
ZM 1.30.4
Local mysql db
Apache2
event storage via NFS to FreeNAS.
41 monitors

Code: Select all

df -h
Filesystem                            Size  Used Avail Use% Mounted on
udev                                   16G  4.0K   16G   1% /dev
tmpfs                                 3.2G  748K  3.2G   1% /run
/dev/dm-4                             861G   34G  784G   5% /
none                                  4.0K     0  4.0K   0% /sys/fs/cgroup
none                                  5.0M     0  5.0M   0% /run/lock
tmpfs                                  22G   18G  4.9G  79% /run/shm
none                                  100M     0  100M   0% /run/user
/dev/mapper/isw_didbhibiga_Volume0p1  237M   74M  151M  33% /boot
192.168.1.5:/mnt/zmstor/images        731G  1.7M  731G   1% /var/cache/zoneminder/images
192.168.1.5:/mnt/zmstor/events        8.5T  7.8T  731G  92% /var/cache/zoneminder/events

Been installed and running for 2yrs. Event counter above 20M

Some time this week, something happened and all the events are gone from the database (web gui), but recorded images files up to the 22nd.

Pulled off images of concern and stored them elsewhere, cleared the event db

Code: Select all

# service zoneminder stop
# mysql zm
mysql> TRUNCATE TABLE Events;
mysql> ALTER TABLE Events AUTO_INCREMENT = 1;
mysql> exit
# reboot

and am running the pearl audit script - This will take a while....

Code: Select all

sudo perl -T /usr/bin/zmaudit.pl

With the server back up and ZM started, I can view all the monitor streams but what events are displaying on the Web GUI are all in the New Event status. The "New Events" all have valid time stamps, but no frame count or duration, so no events are actually being recorded.

Here are the logs from the most recent reboot:

zm-log.zip

(26.41 KiB) Downloaded 94 times

[bbunge]

Looks like the connection to the NAS was lost and Zoneminder purged the database. Might be good to upgrade to Ubuntu 16.04 or 18.04 and use a systemd mount.

[Pedulla]

Agree on the update, but I was waiting for the release of 1.31.

So, I can get and rw to the NAS storage now, from the am server. Any clue what’s keeping it from behaving normal now?

[bbunge]

Might be a while for 1.31.x. AS long as you have a working database take a dump of it and use that on your new system after you install 1.30.4. If you have a spare PC set it up with a newer version of Ubuntu and do a test with your existing database. While I have a working setup for Bionic, I am keeping my production server at 16.04 until the guys release an 18.04 version on the PPA. I have tried the zoneminder-master PPA branch several times and have not been pleased with the layout and have had little success even getting it to work. With family issues this summer I've not had time to dig into making it better. And the "issues" seem to keep coming (something like the rain in Pennsylvania)! At least I'm getting one dry day a week to mow the lawn...

[Pedulla]

Thanks @bbunge,

So to get the whole system back up and running again, I had to bounce FreeNAS too. Even though I could see & rw to the events directory from the ZM it wouldn't record.
Kinda like a stale NFS but not really. At any rate I'm back up.

Stay dry my friend and thank you again!.