Help - repair_database.php alarming output from debug

[ciela2]

This error is showing up in an F5 device's debug output in the Cacti log:

"Sorry, we could not process your last action.
The Data Query ID [26] that you are trying to Edit does not exist. Please run the repair_database.php CLI script to resolve this database issue"

repair_database.php --debug returns this output:
(Pass 1) NOTE: Found 160321 Invalid Data Input Data Rows in Data Templates

Detailed Checks. Use --force to repair if found.

NOTE: Searching for Invalid Cacti GPRINT Presets
NOTE: Found No Invalid Cacti GPRINT Presets
NOTE: Searching for Invalid Cacti CDEFs Presets
NOTE: Found No Invalid Cacti CDEFs
NOTE: Searching for Invalid Cacti Data Inputs
NOTE: Found 121 Invalid Data Input Rows in Data Templates
NOTE: Searching for Graph Templates whose Graphs have invalid item counts
NOTE: Found 6 Graph Templates with 323 Graphs whose item counts that were incorrect
NOTE: Searching for Invalid Cacti Data Input Fields
NOTE: Found No Invalid Cacti Data Input Fields
NOTE: Searching for Invalid Cacti Data Input Data Rows (Pass 1)
NOTE: Found 160321 Invalid Data Input Data Rows in Data Templates
NOTE: Searching for Invalid Cacti Data Input Data Rows (Pass 2)
NOTE: Found No Invalid Cacti Data Input Data Rows (Pass 2)

What does this all mean? Please advise. Do I dare use the --force option?
We've recently migrated from Cacti 0.8.8h to Cacti 1.2.26

Thanks for any help.

[TheWitness]

Go for it, but make a backup of the database first.

Code: Select all

mysqldump --lock-tables=false cacti > cacti_backup.sql