Cacti (home)ForumsDocumentation
Cacti: offical forums and support
It is currently Fri Mar 22, 2019 10:07 pm

All times are UTC - 5 hours




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: Syslog Plugin - MySQL issue
PostPosted: Mon Jun 25, 2018 4:25 pm 
Offline
Cacti User
User avatar

Joined: Wed Jul 20, 2016 8:00 pm
Posts: 180
Hi there,

I've setup syslog 10 days ago to run on separated database on the same host with a bunch of alerts/reports/removal rules. It was running fine until Today around 3.58am when it looks like it started to fail

I think I've selected 2 partitions per day.

Logs found on /var/log/mariadb/mariadb.log
Quote:
180626 3:58:36 [ERROR] mysqld: Incorrect information in file: './syslog/syslog.frm'
180626 3:58:36 [ERROR] mysqld: Incorrect information in file: './syslog/syslog_removed.frm'
180626 4:00:01 [ERROR] Error in accept: Too many open files
180626 4:21:54 [ERROR] Error in accept: Too many open files
180626 5:22:34 [ERROR] Error in accept: Too many open files
180626 6:55:02 [ERROR] Error in accept: Too many open files


Logs from cacti.log, there is a lot of crap after syslog and weathermap got disabled and apparently MariaDB crashed or something.

Quote:
26/Jun/2018 05:57:57 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:57:57 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:57:57 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:56:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:56:59 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:56:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:56:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:56:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:56:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:50:01 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:50:01 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:50:01 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:45:19 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:45:19 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:45:19 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:40:18 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:40:18 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:40:18 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:35:03 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:35:03 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:35:03 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:33:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:33:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:33:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 05:33:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:31:25 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:31:25 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:31:25 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:31:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:31:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:31:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:31:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:23:29 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:23:29 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:23:29 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:22:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:22:59 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:22:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:22:59 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:22:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:22:59 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:21:59 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 05:21:59 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:21:09 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:21:09 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:21:09 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:21:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:21:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:21:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 05:21:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:20:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:20:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:20:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:20:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:20:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:20:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:16:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 05:16:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:16:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 05:16:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:15:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:15:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:12:04 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:12:04 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:12:04 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 05:12:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:12:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:10:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:10:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:10:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 05:10:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 05:04:16 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 05:04:16 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 05:04:16 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:59:20 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:59:20 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:59:20 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:54:18 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:54:18 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:54:18 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:49:40 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:49:40 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:49:40 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:48:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:48:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:47:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:47:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:47:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:47:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:47:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:47:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:46:15 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:46:15 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:46:15 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:46:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 04:46:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:45:02 - DBCALL ERROR: SQL Assoc Failed!, Error: Can't read dir of './cacti1x/' (errno: 24)
26/Jun/2018 04:45:02 - DBCALL ERROR: SQL Assoc Failed!, Error:1018, SQL:'SHOW TABLE STATUS WHERE `Name` LIKE 'reportit_tmp_%' AND (UNIX_TIMESTAMP(`Update_time`) + 300) <= UNIX_TIMESTAMP()'
26/Jun/2018 04:45:02 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'cacti1x.plugin_thold_host_failed' doesn't exist
26/Jun/2018 04:45:02 - DBCALL ERROR: A DB Exec Failed!, Error:1146, SQL:'TRUNCATE plugin_thold_host_failed'
26/Jun/2018 04:37:29 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:37:29 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:37:29 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:35:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_1.MAI' (Errcode: 24)
26/Jun/2018 04:35:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:35:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 04:35:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:33:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:33:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:33:00 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:33:00 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:32:09 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:32:09 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:32:09 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
26/Jun/2018 04:32:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:32:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:30:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:30:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:23:42 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:23:42 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:23:42 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 43
2018/06/26 04:23:01 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Waiting for Threads to End
2018/06/26 04:22:59 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Processing Devices Internal
2018/06/26 04:22:02 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Waiting for Threads to End
26/Jun/2018 04:22:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 04:22:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
2018/06/26 04:22:00 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Processing Devices Internal
26/Jun/2018 04:21:06 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'syslog'
26/Jun/2018 04:21:06 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:21:06 - ERROR PHP ERROR in Plugin 'syslog': Call to undefined function syslog_db_fetch_row() in file: /usr/share/cacti-1.1.37/plugins/syslog/functions.php on line: 70
2018/06/26 04:21:02 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Waiting for Threads to End
26/Jun/2018 04:21:01 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAI' (Errcode: 24)
26/Jun/2018 04:21:01 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
2018/06/26 04:21:00 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Processing Devices Internal
26/Jun/2018 04:15:04 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/syslog/syslog_process.php: 154 syslog_is_partitioned)(/plugins/syslog/functions.php: 71 CactiErrorHandler)(/lib/functions.php: 4590 cacti_debug_backtrace)
26/Jun/2018 04:15:04 - ERROR PHP NOTICE in Plugin 'syslog': Undefined index: Create Table in file: /usr/share/cacti-1.1.37/plugins/syslog/functions.php on line: 71
26/Jun/2018 04:15:02 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:15:02 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
2018/06/26 04:12:03 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Waiting for Threads to End
2018/06/26 04:12:01 - SPINE: Poller[Main Poller] ERROR: Spine Timed Out While Processing Devices Internal
26/Jun/2018 04:10:02 - CMDPHP ERRORS DETECTED - DISABLING PLUGIN 'weathermap'
26/Jun/2018 04:10:02 - CMDPHP PHP ERROR Backtrace: (CactiShutdownHandler)(/lib/functions.php: 4628 cacti_debug_backtrace)
26/Jun/2018 04:10:02 - ERROR PHP ERROR in Plugin 'weathermap': Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: 1018 Can't read dir of './cacti1x/' (errno: 24)' in /usr/share/cacti-1.1.37/plugins/weathermap/lib/datasources/WeatherMapDataSource_cactithold.php:64
26/Jun/2018 04:06:46 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'syslog.syslog_statistics' doesn't exist
26/Jun/2018 04:06:46 - DBCALL ERROR: A DB Exec Failed!, Error:1146, SQL:'TRUNCATE `syslog`.`syslog_statistics`'
26/Jun/2018 04:06:46 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/syslog/syslog_process.php: 154 syslog_is_partitioned)(/plugins/syslog/functions.php: 71 CactiErrorHandler)(/lib/functions.php: 4590 cacti_debug_backtrace)
26/Jun/2018 04:06:46 - ERROR PHP NOTICE in Plugin 'syslog': Undefined index: Create Table in file: /usr/share/cacti-1.1.37/plugins/syslog/functions.php on line: 71
26/Jun/2018 04:06:12 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'syslog.syslog_statistics' doesn't exist
26/Jun/2018 04:06:12 - DBCALL ERROR: A DB Exec Failed!, Error:1146, SQL:'TRUNCATE `syslog`.`syslog_statistics`'
26/Jun/2018 04:06:12 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/syslog/syslog_process.php: 154 syslog_is_partitioned)(/plugins/syslog/functions.php: 71 CactiErrorHandler)(/lib/functions.php: 4590 cacti_debug_backtrace)
26/Jun/2018 04:06:12 - ERROR PHP NOTICE in Plugin 'syslog': Undefined index: Create Table in file: /usr/share/cacti-1.1.37/plugins/syslog/functions.php on line: 71
26/Jun/2018 04:06:10 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:06:10 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 04:05:34 - CMDPHP ERROR: A DB Exec Failed!, Error: Table 'syslog.syslog_statistics' doesn't exist
26/Jun/2018 04:05:34 - DBCALL ERROR: A DB Exec Failed!, Error:1146, SQL:'TRUNCATE `syslog`.`syslog_statistics`'
26/Jun/2018 04:05:34 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/syslog/syslog_process.php: 154 syslog_is_partitioned)(/plugins/syslog/functions.php: 71 CactiErrorHandler)(/lib/functions.php: 4590 cacti_debug_backtrace)
26/Jun/2018 04:05:34 - ERROR PHP NOTICE in Plugin 'syslog': Undefined index: Create Table in file: /usr/share/cacti-1.1.37/plugins/syslog/functions.php on line: 71
26/Jun/2018 04:05:33 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 04:05:33 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT sm.* FROM snmpagent_managers_notifications AS smn INNER JOIN snmpagent_managers AS sm ON sm.id = smn.manager_id WHERE smn.notification = ? AND smn.mib = ? ORDER BY sm.snmp_message_type'
26/Jun/2018 03:58:36 - CMDPHP ERROR: A DB Exec Failed!, Error: Out of resources when opening file './syslog/syslog_statistics.MYD' (Errcode: 24)
26/Jun/2018 03:58:36 - DBCALL ERROR: A DB Exec Failed!, Error:23, SQL:'TRUNCATE `syslog`.`syslog_statistics`'
26/Jun/2018 03:58:36 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 03:58:36 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT * FROM `information_schema`.`partitions` WHERE table_schema='syslog' AND table_name='syslog' ORDER BY partition_ordinal_position'
26/Jun/2018 03:58:36 - CMDPHP ERROR: A DB Exec Failed!, Error: Failed to read from the .par file
26/Jun/2018 03:58:36 - DBCALL ERROR: A DB Exec Failed!, Error:1696, SQL:'ALTER TABLE `syslog`.`syslog_removed` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180626 VALUES LESS THAN (TO_DAYS('2018-06-27')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'
26/Jun/2018 03:58:36 - DBCALL ERROR: SQL Assoc Failed!, Error: Out of resources when opening file '/var/tmp/#sql_2734_0.MAD' (Errcode: 24)
26/Jun/2018 03:58:36 - DBCALL ERROR: SQL Assoc Failed!, Error:23, SQL:'SELECT * FROM `information_schema`.`partitions` WHERE table_schema='syslog' AND table_name='syslog' ORDER BY partition_ordinal_position'
26/Jun/2018 03:58:36 - CMDPHP ERROR: A DB Exec Failed!, Error: Failed to read from the .par file
26/Jun/2018 03:58:36 - DBCALL ERROR: A DB Exec Failed!, Error:1696, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180626 VALUES LESS THAN (TO_DAYS('2018-06-27')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'


Not very familiar with this sort of mysql issues...suggestions? ideas?

Open files limit is set to 2000 but I'm suspecting I'm having I/O issues? This is running on a VM

Code:
open_files_limit = 2000


I also ran show create table syslog; It shows older partitions I remember to have run some tests using syslog db and then dropped it and set it back up 10 days ago or so. So I'm not sure how those partitions are still there. MySQL isn't clearly my thing..

See attached.
Attachment:
mysql_create_syslog_table.txt [26.89 KiB]
Downloaded 34 times


Thanks and sorry for such a looooooong post.

_________________
Cacti - 1.1.37
Poller Type - Spine
Weathermap 0.98a
Server Info - Linux 3.10.0 - Centos 7
Web Server - Apache/2.4.6 PHP 5.4.16
MySQL - 5.5 ;RRDTool - 1.4.8 ;SNMP - 5.7.2
Religion - Anti forum pets
Code:
SYSTEM STATS: Time:17.7383 Method:spine Processes:1 Threads:10 Hosts:279 HostsPerProcess:279 DataSources:7309 RRDsProcessed:3718

Code:
WEATHERMAP STATS: Weathermap 0.98 run complete - Thu, 16 Nov 17 08:42:56 +1300: 39 maps were run in 23.22 seconds with 0 warnings.


Last edited by Pucho on Mon Jun 25, 2018 4:51 pm, edited 1 time in total.

Top
 Profile  
 
 Post subject: Re: Syslog Plugin - MySQL issue
PostPosted: Mon Jun 25, 2018 4:41 pm 
Offline
Cacti User
User avatar

Joined: Wed Jul 20, 2016 8:00 pm
Posts: 180
Found this post

Not sure what the impact could be..it might make more obvious if it's an I/O issue right?

BTW, is there any way of getting an email from cacti when a plugin has been disabled? Is anyone doing something like that?

_________________
Cacti - 1.1.37
Poller Type - Spine
Weathermap 0.98a
Server Info - Linux 3.10.0 - Centos 7
Web Server - Apache/2.4.6 PHP 5.4.16
MySQL - 5.5 ;RRDTool - 1.4.8 ;SNMP - 5.7.2
Religion - Anti forum pets
Code:
SYSTEM STATS: Time:17.7383 Method:spine Processes:1 Threads:10 Hosts:279 HostsPerProcess:279 DataSources:7309 RRDsProcessed:3718

Code:
WEATHERMAP STATS: Weathermap 0.98 run complete - Thu, 16 Nov 17 08:42:56 +1300: 39 maps were run in 23.22 seconds with 0 warnings.


Top
 Profile  
 
 Post subject: Re: Syslog Plugin - MySQL issue
PostPosted: Mon Jun 25, 2018 5:28 pm 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2296
That last part is something that I have suggested. If I get chance this week, I may add it as a pull request. No promises though.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
 Post subject: Re: Syslog Plugin - MySQL issue
PostPosted: Sun Aug 19, 2018 11:30 pm 
Offline
Cacti User
User avatar

Joined: Wed Jul 20, 2016 8:00 pm
Posts: 180
Well this time lasted 2 month. Problem now appears to be specific to deletion of partitions that don't exist at the time.
Quote:
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP
20/Aug/2018 00:52:35 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180522'
20/Aug/2018 00:52:35 - CMDPHP ERROR: A DB Exec Failed!, Error: Error in list of partitions to DROP



That's just one partition of 4-5 it tried to delete. I ran 'show create table syslog' and those partition don't exist.

These two exist so I'm not sure what is it complaining about

Quote:
17/Aug/2018 00:02:26 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180817 VALUES LESS THAN (TO_DAYS('2018-08-18')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'
17/Aug/2018 00:02:26 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180817 VALUES LESS THAN (TO_DAYS('2018-08-18')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'


Quote:
Log [Total Lines: 3 - Admin View - Additional Filter in Affect]
18/Aug/2018 00:03:52 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180818 VALUES LESS THAN (TO_DAYS('2018-08-19')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'
18/Aug/2018 00:03:52 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180818 VALUES LESS THAN (TO_DAYS('2018-08-19')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'
18/Aug/2018 00:03:52 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180818 VALUES LESS THAN (TO_DAYS('2018-08-19')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'


Then I disabled the plugin and stopped rsyslog. After collecting the logs I started them again and got this

Quote:
20/Aug/2018 16:02:06 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/syslog/syslog_counter.php: 47 CactiErrorHandler)(/lib/functions.php: 4590 cacti_debug_backtrace)
20/Aug/2018 16:02:06 - ERROR PHP NOTICE in Plugin 'syslog': Undefined index: Auto_increment in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 47
20/Aug/2018 16:02:06 - CMDPHP PHP ERROR NOTICE Backtrace: (/plugins/syslog/syslog_counter.php: 44 CactiErrorHandler)(/lib/functions.php: 4590 cacti_debug_backtrace)
20/Aug/2018 16:02:06 - ERROR PHP NOTICE in Plugin 'syslog': Undefined index: Auto_increment in file: /usr/share/cacti-1.1.37/plugins/syslog/syslog_counter.php on line: 44


These lines are from the day it all started, I think. It looks like it got screw trying to remove partition dd20180519..

Quote:
Log [Total Lines: 1489 - Admin View - No Other Filter in Affect]
17/Aug/2018 00:03:27 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php: 159 syslog_partition_manage)(/plugins/syslog/functions.php: 114 syslog_partition_remove)(/plugins/syslog/functions.php: 166 syslog_db_execute)(/plugins/syslog/database.php: 52 db_execute)(/lib/database.php: 136 db_execute_prepared)(/lib/database.php: 209 cacti_debug_backtrace)
17/Aug/2018 00:03:27 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180519'
17/Aug/2018 00:03:27 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php: 159 syslog_partition_manage)(/plugins/syslog/functions.php: 114 syslog_partition_remove)(/plugins/syslog/functions.php: 166 syslog_db_execute)(/plugins/syslog/database.php: 52 db_execute)(/lib/database.php: 136 db_execute_prepared)(/lib/database.php: 209 cacti_debug_backtrace)
17/Aug/2018 00:03:27 - DBCALL ERROR: A DB Exec Failed!, Error:1507, SQL:'ALTER TABLE `syslog`.`syslog` DROP PARTITION d20180519'
17/Aug/2018 00:03:27 - SYSTEM SYSLOG STATS:Time:595.89 Deletes:0 Incoming:37 Removes:0 XFers:37 Alerts:19 Alarms:17 Reports:4
17/Aug/2018 00:03:27 - SYSLOG WARNING: The Syslog Intance Alert 'Cisco DHCP Snooping Alerts' with Severity 'Warning', has been Triggered, Count was '20', and Sequence '2812'
17/Aug/2018 00:02:26 - SYSTEM SYSLOG: Removing old partition 'dd20180519'
17/Aug/2018 00:02:26 - SYSTEM SYSLOG: Removing old partition 'dd20180519'
17/Aug/2018 00:02:26 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php: 159 syslog_partition_manage)(/plugins/syslog/functions.php: 113 syslog_partition_create)(/plugins/syslog/functions.php: 140 syslog_db_execute)(/plugins/syslog/database.php: 52 db_execute)(/lib/database.php: 136 db_execute_prepared)(/lib/database.php: 209 cacti_debug_backtrace)
17/Aug/2018 00:02:26 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180817 VALUES LESS THAN (TO_DAYS('2018-08-18')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'
17/Aug/2018 00:02:26 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php: 159 syslog_partition_manage)(/plugins/syslog/functions.php: 113 syslog_partition_create)(/plugins/syslog/functions.php: 140 syslog_db_execute)(/plugins/syslog/database.php: 52 db_execute)(/lib/database.php: 136 db_execute_prepared)(/lib/database.php: 209 cacti_debug_backtrace)
17/Aug/2018 00:02:26 - DBCALL ERROR: A DB Exec Failed!, Error:1517, SQL:'ALTER TABLE `syslog`.`syslog` REORGANIZE PARTITION dMaxValue INTO ( PARTITION d20180817 VALUES LESS THAN (TO_DAYS('2018-08-18')), PARTITION dMaxValue VALUES LESS THAN MAXVALUE)'
17/Aug/2018 00:02:26 - SYSTEM SYSLOG STATS:Time:321.83 Deletes:0 Incoming:14 Removes:3 XFers:0 Alerts:19 Alarms:0 Reports:4
17/Aug/2018 00:02:26 - SYSTEM SYSLOG: Removing old partition 'dd20180519'
17/Aug/2018 00:02:05 - SYSTEM SYSLOG: Creating new partition 'd20180817'
17/Aug/2018 00:01:24 - SYSTEM SYSLOG STATS:Time:367.35 Deletes:0 Incoming:1 Removes:0 XFers:1 Alerts:19 Alarms:0 Reports:4
17/Aug/2018 00:01:23 - SYSLOG WARNING: The Syslog Intance Alert 'Cisco DHCP Snooping Alerts' with Severity 'Warning', has been Triggered, Count was '14', and Sequence '2811'
17/Aug/2018 00:01:23 - SYSTEM SYSLOG STATS:Time:424.15 Deletes:0 Incoming:0 Removes:0 XFers:0 Alerts:19 Alarms:0 Reports:4
17/Aug/2018 00:00:58 - SYSTEM SYSLOG: Creating new partition 'd20180817'
17/Aug/2018 00:00:15 - SYSTEM SYSLOG: Creating new partition 'd20180817'


Any suggestion on how to get it going again without re installing the plugin?

_________________
Cacti - 1.1.37
Poller Type - Spine
Weathermap 0.98a
Server Info - Linux 3.10.0 - Centos 7
Web Server - Apache/2.4.6 PHP 5.4.16
MySQL - 5.5 ;RRDTool - 1.4.8 ;SNMP - 5.7.2
Religion - Anti forum pets
Code:
SYSTEM STATS: Time:17.7383 Method:spine Processes:1 Threads:10 Hosts:279 HostsPerProcess:279 DataSources:7309 RRDsProcessed:3718

Code:
WEATHERMAP STATS: Weathermap 0.98 run complete - Thu, 16 Nov 17 08:42:56 +1300: 39 maps were run in 23.22 seconds with 0 warnings.


Top
 Profile  
 
 Post subject: Re: Syslog Plugin - MySQL issue
PostPosted: Mon Aug 20, 2018 3:10 am 
Offline
Cacti Guru User

Joined: Sun Aug 27, 2017 12:05 am
Posts: 2296
Basically, you get a duplicate partition name for some reason:

Code:
Error: 1517 SQLSTATE: HY000 (ER_SAME_NAME_PARTITION)

Message: Duplicate partition name %s


I do not know enough about partitions in mysql or how syslog uses them to give authoritative advice on how it should work but clearly duplicating a name shouldn't happen. On the emailing when disabled front, that has been added to 1.2 which will hopefully be in beta by early September. Once that's done, we will be reviewing the plugins and seeing how they work with 1.2 so I may get a better understanding then.

In the meantime, I would open this as a bug on the syslog repo.

_________________
Official Cacti Developer

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation

My resources:
How to submit Pull Requests
Development Wiki and How To's
Updated NetSNMP Memory template for Cacti 1.x
Cisco SFP template for Cacti 0.8.8


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC - 5 hours


Who is online

Users browsing this forum: No registered users and 6 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  

Protected by Anti-Spam ACP Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group