Ad blocker detected: Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker on our website.
Post general support questions here that do not specifically fall into the Linux or Windows categories.
Moderators: Developers , Moderators
ahlund
Posts: 5 Joined: Fri Nov 26, 2021 7:04 am
Post
by ahlund » Wed Sep 06, 2023 4:17 am
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
Cacti Guru User
Posts: 1424 Joined: Mon Jan 05, 2015 10:10 am
Post
by Osiris » Wed Sep 06, 2023 4:25 am
Can you put this into GitHub? What is the reindex method for the data query?
Before history, there was a paradise, now dust.
ahlund
Posts: 5 Joined: Fri Nov 26, 2021 7:04 am
Post
by ahlund » Wed Sep 06, 2023 5:29 am
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
Cacti Guru User
Posts: 1424 Joined: Mon Jan 05, 2015 10:10 am
Post
by Osiris » Wed Sep 06, 2023 6:07 am
Take a dump of the database just in case, and then run the repair_database.php CLI script. Post the output.
Before history, there was a paradise, now dust.
TheWitness
Developer
Posts: 17047 Joined: Tue May 14, 2002 5:08 pm
Location: MI, USA
Contact:
Post
by TheWitness » Wed Sep 06, 2023 9:21 am
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
Users browsing this forum: No registered users and 0 guests