I loose the ability to connect via internet (no web access or other), so no ability to diagnose (system is headless). I can only force a reboot via power off/on and then look for crumbs (never finding anything).
The most recent event resulted in mysql failing due to innoDB files, so I moved them out of the way and was then able to start OK. But, zoneminder will not start.
sudo systemctl status zoneminder.service produces:
Jan 26 18:31:47 mandeportal systemd[1]: Starting ZoneMinder CCTV recording and surveillance system...
Jan 26 18:31:47 mandeportal zmpkg.pl[1674]: DBD::mysql::st execute failed: Lost connection to MySQL server during query at /usr/share/perl5/ZoneMinder/Logger.pm l
Jan 26 18:31:47 mandeportal zmpkg[1674]: ERR [Can't execute log entry 'INSERT INTO Logs ( TimeKey, Component, ServerId, Pid, Level, Code, Message, File, Line ) VA
Jan 26 18:31:47 mandeportal zmpkg.pl[1674]: DBD::mysql::st execute failed: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)
Jan 26 18:31:47 mandeportal zmpkg[1674]: FAT [Can't execute: Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111)]
Jan 26 18:31:47 mandeportal systemd[1]: zoneminder.service: Control process exited, code=exited, status=255/EXCEPTION
Jan 26 18:31:47 mandeportal systemd[1]: zoneminder.service: Failed with result 'exit-code'.
Jan 26 18:31:47 mandeportal systemd[1]: Failed to start ZoneMinder CCTV recording and surveillance system.
MariaDB [zm]> check table Logs; produces:
Can anyone point me toward some resolution?ERROR 2013 (HY000): Lost connection to MySQL server during query