SQL Error Starting ZoneMinder

[kingchr]

Hello,

I have been using a Zoneminder install for a few months and everything was functioning as expected. I have a raid array with 11 TB of usable space and several 4K and 1080p cameras attached I verified that events where being saved there instead of the stock location on the root drive. One day I noticed that neither ZMNinja nor the web interface would let me log in. I sshed into my server (debian 10 with latest updates) and found that my root drive was completely full. When I checked what was taking so much space I found that several directories inside /var/log related to ZoneMinder had filled the 120 GB root partition. I deleted all the contents of these log directories and rebooted the server.

Now ZoneMinder no longer starts on boot and I get the following error when I try to start the service manually.
Message from syslogd@securitycenter at Mar 23 16:21:27 ...
D::mysql::st execute failed: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB at /usr/share/perl5/ZoneMinder/Logger.pm line 600.

I guess my question is two fold. What do I need to do to recover this install or reinstall ZoneMinder and two how do I prevent this from happening again?

Have a good one,
Christopher

[burger]

...
I found that several directories inside /var/log related to ZoneMinder had filled the 120 GB root partition. I deleted all the contents of these log directories and rebooted the server.

There's only one directory for buster: /var/log/zm/. Syslog also can fill up. Settings are adjusted in options for each.

Now ZoneMinder no longer starts on boot and I get the following error when I try to start the service manually.
Message from syslogd@securitycenter at Mar 23 16:21:27 ...
D::mysql::st execute failed: Got error 194 "Tablespace is missing for a table" from storage engine InnoDB at /usr/share/perl5/ZoneMinder/Logger.pm line 600.

I guess my question is two fold. What do I need to do to recover this install or reinstall ZoneMinder and two how do I prevent this from happening again?

Do you have backups of your configuration? Drop the DB, and use those to restore if you can afford to lose the video footage. See wiki.zoneminder.com/MySQL
You may also need to re-add the permissions for the new DB. Everything is covered on the wiki.

Make sure you don't have any HDD / IO errors. And disable or do less logging, so you don't fill the root partition.