SPINE: Poller[Main Poller] PID[1869445] PT[139818684110592] Device[Server] HT[1] DQ[10] RECACHE ASSERT FAILED: '214=2

[ahlund]

Hi!

I'm getting this message every time the poller i run (the assert part is changing):

Code: Select all

SPINE: Poller[Main Poller] PID[1869445] PT[139818684110592] Device[Server] HT[1] DQ[10] RECACHE ASSERT FAILED: '214=208'

I'm guessing a problem with the database becuse when I click on the 10 in DQ[10] I get these errors in the log:

Code: Select all

2023-09-06 11:13:00 - CMDPHP PHP ERROR NOTICE Backtrace: (/data_queries.php[101]:data_query_edit(), /data_queries.php[1101]:CactiErrorHandler())
2023-09-06 11:13:00 - ERROR PHP NOTICE: Undefined index: name in file: /home/cacti/app/cacti/data_queries.php on line: 1101

Any suggestions what can be done? It's been going on for some time but at the moment I'm running cacti 1.2.25 and spine 1.2.22.

Regards,
Åke

[Osiris]

Can you put this into GitHub? What is the reindex method for the data query?

[ahlund]

Well, the problem is that the data query does not seem to exist... There is no data query with id 10 when I look att the data querys. That is why I suspect a database error.

/Åke

[Osiris]

Take a dump of the database just in case, and then run the repair_database.php CLI script. Post the output.

[TheWitness]

Reported here:

https://github.com/Cacti/cacti/issues/5481

[TheWitness]

You should get output that looks like this. Post your's.

Code: Select all

[root@vmhost5 cli]# php -q repair_database.php --help
Cacti Database Repair Utility, Version 1.2.25 (DB: 1.2.25), Copyright (C) 2004-2023 The Cacti Group

usage: repair_database.php [--dynamic] [--debug] [--force] [--form]

A utility designed to repair the Cacti database if damaged, and optionally repair any
corruption found in the Cacti databases various Templates.

Optional:
    --dynamic - Convert a table to Dynamic row format if available
    --form    - Force rebuilding the indexes from the database creation syntax.
    --tables  - Repair Tables as well as possible database corruptions.
    --local   - Perform the action on the Remote Data Collector if run from there
    --force   - Remove Invalid Template records from the database.
    --debug   - Display verbose output during execution.

[root@vmhost5 cli]# php -q repair_database.php --force --debug --tables
------------------------------------------------------------------------
NOTE: Repairing Tables for Local Database
NOTE: Repairing All 145 Cacti Database Tables
Repairing Table 'aggregate_graph_templates' Successful
Repairing Table 'aggregate_graph_templates_graph' Successful
Repairing Table 'aggregate_graph_templates_item' Successful
Repairing Table 'aggregate_graphs' Successful
Repairing Table 'aggregate_graphs_graph_item' Successful
Repairing Table 'aggregate_graphs_items' Successful
Repairing Table 'automation_devices' Successful
Repairing Table 'automation_graph_rule_items' Successful
Repairing Table 'automation_graph_rules' Successful
Repairing Table 'automation_ips' Successful
Repairing Table 'automation_match_rule_items' Successful
Repairing Table 'automation_networks' Successful
Repairing Table 'automation_processes' Successful
Repairing Table 'automation_snmp' Successful
Repairing Table 'automation_snmp_items' Successful
Repairing Table 'automation_templates' Successful
Repairing Table 'automation_tree_rule_items' Successful
Repairing Table 'automation_tree_rules' Successful
Repairing Table 'cdef' Successful
Repairing Table 'cdef_items' Successful
Repairing Table 'color_template_items' Successful
Repairing Table 'color_templates' Successful
Repairing Table 'colors' Successful
Repairing Table 'data_debug' Successful
Repairing Table 'data_input' Successful
Repairing Table 'data_input_data' Successful
Repairing Table 'data_input_fields' Successful
Repairing Table 'data_local' Successful
Repairing Table 'data_source_profiles' Successful
Repairing Table 'data_source_profiles_cf' Successful
Repairing Table 'data_source_profiles_rra' Successful
Repairing Table 'data_source_purge_action' Successful
Repairing Table 'data_source_purge_temp' Successful
Repairing Table 'data_source_stats_daily' Successful
Repairing Table 'data_source_stats_hourly' Successful
Repairing Table 'data_source_stats_hourly_cache' Successful
Repairing Table 'data_source_stats_hourly_last' Successful
Repairing Table 'data_source_stats_monthly' Successful
Repairing Table 'data_source_stats_weekly' Successful
Repairing Table 'data_source_stats_yearly' Successful
Repairing Table 'data_template' Successful
Repairing Table 'data_template_data' Successful
Repairing Table 'data_template_rrd' Successful
Repairing Table 'external_links' Successful
Repairing Table 'graph_local' Successful
Repairing Table 'graph_template_input' Successful
Repairing Table 'graph_template_input_defs' Successful
Repairing Table 'graph_templates' Successful
Repairing Table 'graph_templates_gprint' Successful
Repairing Table 'graph_templates_graph' Successful
Repairing Table 'graph_templates_item' Successful
Repairing Table 'graph_tree' Successful
Repairing Table 'graph_tree_items' Successful
Repairing Table 'host' Successful
Repairing Table 'host_graph' Successful
Repairing Table 'host_snmp_cache' Successful
Repairing Table 'host_snmp_query' Successful
Repairing Table 'host_template' Successful
Repairing Table 'host_template_graph' Successful
Repairing Table 'host_template_snmp_query' Successful
Repairing Table 'notification_queue' Successful
Repairing Table 'package_public_keys' Successful
Repairing Table 'package_repositories' Successful
Repairing Table 'plugin_config' Successful
Repairing Table 'plugin_db_changes' Successful
Repairing Table 'plugin_hmib_hrDevices' Successful
Repairing Table 'plugin_hmib_hrProcessor' Successful
Repairing Table 'plugin_hmib_hrSWInstalled' Successful
Repairing Table 'plugin_hmib_hrSWRun' Successful
Repairing Table 'plugin_hmib_hrSWRun_ignore' Successful
Repairing Table 'plugin_hmib_hrSWRun_last_seen' Successful
Repairing Table 'plugin_hmib_hrStorage' Successful
Repairing Table 'plugin_hmib_hrSystem' Successful
Repairing Table 'plugin_hmib_hrSystemTypes' Successful
Repairing Table 'plugin_hmib_processes' Successful
Repairing Table 'plugin_hmib_types' Successful
Repairing Table 'plugin_hooks' Successful
Repairing Table 'plugin_intropage_dashboard' Successful
Repairing Table 'plugin_intropage_panel_dashboard' Successful
Repairing Table 'plugin_intropage_panel_data' Successful
Repairing Table 'plugin_intropage_panel_definition' Successful
Repairing Table 'plugin_intropage_trends' Successful
Repairing Table 'plugin_intropage_user_auth' Successful
Repairing Table 'plugin_monitor_dashboards' Successful
Repairing Table 'plugin_notification_lists' Successful
Repairing Table 'plugin_realms' Successful
Repairing Table 'plugin_thold_contacts' Successful
Repairing Table 'plugin_thold_daemon_data' Successful
Repairing Table 'plugin_thold_host' Successful
Repairing Table 'plugin_thold_host_failed' Successful
Repairing Table 'plugin_thold_host_template' Successful
Repairing Table 'plugin_thold_log' Successful
Repairing Table 'plugin_thold_template_contact' Successful
Repairing Table 'plugin_thold_threshold_contact' Successful
Repairing Table 'poller' Successful
Repairing Table 'poller_command' Successful
Repairing Table 'poller_data_template_field_mappings' Successful
Repairing Table 'poller_item' Successful
Repairing Table 'poller_output' Successful
Repairing Table 'poller_output_boost' Successful
Repairing Table 'poller_output_boost_local_data_ids' Successful
Repairing Table 'poller_output_boost_processes' Successful
Repairing Table 'poller_output_realtime' Successful
Repairing Table 'poller_reindex' Successful
Repairing Table 'poller_resource_cache' Successful
Repairing Table 'poller_time' Successful
Repairing Table 'processes' Successful
Repairing Table 'reports' Successful
Repairing Table 'reports_items' Successful
Repairing Table 'rrdcheck' Successful
Repairing Table 'sessions' Successful
Repairing Table 'settings' Successful
Repairing Table 'settings_tree' Successful
Repairing Table 'settings_user' Successful
Repairing Table 'settings_user_group' Successful
Repairing Table 'sites' Successful
Repairing Table 'snmp_query' Successful
Repairing Table 'snmp_query_graph' Successful
Repairing Table 'snmp_query_graph_rrd' Successful
Repairing Table 'snmp_query_graph_rrd_sv' Successful
Repairing Table 'snmp_query_graph_sv' Successful
Repairing Table 'snmpagent_cache' Successful
Repairing Table 'snmpagent_cache_notifications' Successful
Repairing Table 'snmpagent_cache_textual_conventions' Successful
Repairing Table 'snmpagent_managers' Successful
Repairing Table 'snmpagent_managers_notifications' Successful
Repairing Table 'snmpagent_mibs' Successful
Repairing Table 'snmpagent_notifications_log' Successful
Repairing Table 'thold_data' Successful
Repairing Table 'thold_template' Successful
Repairing Table 'user_auth' Successful
Repairing Table 'user_auth_cache' Successful
Repairing Table 'user_auth_group' Successful
Repairing Table 'user_auth_group_members' Successful
Repairing Table 'user_auth_group_perms' Successful
Repairing Table 'user_auth_group_realm' Successful
Repairing Table 'user_auth_perms' Successful
Repairing Table 'user_auth_realm' Successful
Repairing Table 'user_auth_row_cache' Successful
Repairing Table 'user_domains' Successful
Repairing Table 'user_domains_ldap' Successful
Repairing Table 'user_log' Successful
Repairing Table 'vdef' Successful
Repairing Table 'vdef_items' Successful
Repairing Table 'version' Successful

------------------------------------------------------------------------
Simple Checks.  Automatically repair if Found

NOTE: Repairing some possibly corrupted Data Query IDs and Indexes.
NOTE: Found No Problems with Data Query Indexes or IDs
NOTE: Repairing Incorrectly Set Data Query Graph IDs
NOTE: Found No Problems with Data Query Graph IDs
NOTE: Repairing Data Input Data hostname or host_id Type Code issues
NOTE: Found and Repaired 181 invalid Data Input hostname or host_id Type Code issues
NOTE: Repairing orphaned Poller Items.
NOTE: Found No Problems with orphaned Poller Items

------------------------------------------------------------------------
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 No Invalid Cacti Data Inputs
NOTE: Searching for Graph Templates whose Graphs have invalid item counts
NOTE: Found No Graph Templates whose Graphs had incorrect item counts
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 No Invalid Cacti Data Input Data Rows (Pass 1)
NOTE: Searching for Invalid Cacti Data Input Data Rows (Pass 2)
NOTE: Found No Invalid Cacti Data Input Data Rows (Pass 2)

------------------------------------------------------------------------
NOTE: No Invalid Cacti Template Records found in your Database