Cacti database dump failure

[krw]

Trying to move cacti to a new VM.

Old version: 1.2.15
New: 1.2.23

Go to dump the database:

mysqldump: Got error: 1932: "Table 'cacti.snmpagent_cache' doesn't exist in engine" when using LOCK TABLES

Run mysqlcheck:

cacti.snmp_query OK
cacti.snmp_query_graph OK
cacti.snmp_query_graph_rrd OK
cacti.snmp_query_graph_rrd_sv OK
cacti.snmp_query_graph_sv OK
cacti.snmpagent_cache
Warning : Tablespace is missing for table 'cacti/snmpagent_cache'
Error : Table 'cacti.snmpagent_cache' doesn't exist in engine
status : Operation failed
cacti.snmpagent_cache_notifications
Warning : Tablespace is missing for table 'cacti/snmpagent_cache_notifications'
Error : Table 'cacti.snmpagent_cache_notifications' doesn't exist in engine
status : Operation failed
cacti.snmpagent_cache_textual_conventions OK
cacti.snmpagent_managers OK
cacti.snmpagent_managers_notifications OK
cacti.snmpagent_mibs
Warning : Tablespace is missing for table 'cacti/snmpagent_mibs'
Error : Table 'cacti.snmpagent_mibs' doesn't exist in engine
status : Operation failed
cacti.snmpagent_notifications_log OK

# php audit_database.php --report
FATAL: Failed to find Audit Schema
---------------------------------------------------------------------------------------------
Checking Table: 'aggregate_graph_templates' - Does not Exist. Possible Plugin

Everything shows up as Does not exist. Possible Plugin.

Appears this corruption is in older database backups too. This is preventing a dump
of the database to move to a new cacti VM.

New cacti database is good. Should I just start adding in hosts again and just not bother with
trying to fix this?

Thanks.

Googlefu is failing me, not sure how to possibly fix this.

Thanks.

[macan]

you can try create table snmpagent_cache and snmpagent_mibs on old host. Definition is in your_cacti_installation/cacti.sql. Next step is mysqldump again and import to new host.

Maybe you don't need these tables it depends on your cacti configuration.

I suggest install 1.2.26, not old 1.2.23 version.
Here is actual version
https://www.cacti.net/info/downloads

Here is how to upgrade
https://docs.cacti.net/

[krw]

As the new cacti is not production I just updated it via dnf to whats in the rocky distro tree, 1.2.25.

Dropped each table that was giving grief and recreated each one from the cacti.sql directly
in mysql.

After this was completed I was able to get a full mysql dump of the cacti database with no errors.

Thanks.

[TheWitness]

It's likely an error from an old MySQL/MariaDB outage. It was likely InnoDB and at some point in time either the file was removed from the /var/lib/mysql/cacti directory or some other ugly crash in MySQL/MariaDB.