Hello there,
After running out of space on my hard drive, i cleared logs directory:
rm -rf /opt/librenms/logs/*
and i tried to optimize database:
MariaDB [librenms]> OPTIMIZE TABLE syslog;
But got an error:
MariaDB [librenms]> OPTIMIZE TABLE syslog;
±----------------±---------±---------±-----------------------------------------------------------------------------+
| Table | Op | Msg_type | Msg_text |
±----------------±---------±---------±-----------------------------------------------------------------------------+
| librenms.syslog | optimize | Warning | Tablespace is missing for table ‘librenms/syslog’ |
| librenms.syslog | optimize | Error | Got error 194 “Tablespace is missing for a table” from storage engine InnoDB |
| librenms.syslog | optimize | error | Corrupt |
±----------------±---------±---------±-----------------------------------------------------------------------------+
3 rows in set (0.000 sec)
What can be the issue? I receive an error message continuously and my diskspace run out extremely quick.
TIA, Ruslan