Syslog Plugin - MySQL issue

General discussion about Plugins for Cacti

Moderators: Developers, Moderators

Post Reply
User avatar
Pucho
Cacti User
Posts: 185
Joined: Wed Jul 20, 2016 8:00 pm

Syslog Plugin - MySQL issue

Post by Pucho »

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
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.
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: Select all

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.
mysql_create_syslog_table.txt
(26.89 KiB) Downloaded 182 times
Thanks and sorry for such a looooooong post.
Last edited by Pucho on Mon Jun 25, 2018 4:51 pm, edited 1 time in total.
Cacti - 1.2.15
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
Top
User avatar
Pucho
Cacti User
Posts: 185
Joined: Wed Jul 20, 2016 8:00 pm

Re: Syslog Plugin - MySQL issue

Post by Pucho »

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.2.15
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
Top
netniV
Cacti Guru User
Posts: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Syslog Plugin - MySQL issue

Post by netniV »

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.
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

Cacti Resources:
Cacti Website (including releases)
Cacti Issues
Cacti Development Releases
Cacti Development Documentation
Top
User avatar
Pucho
Cacti User
Posts: 185
Joined: Wed Jul 20, 2016 8:00 pm

Re: Syslog Plugin - MySQL issue

Post by Pucho »

Well this time lasted 2 month. Problem now appears to be specific to deletion of partitions that don't exist at the time.
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
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)'
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
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..
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.2.15
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
Top
netniV
Cacti Guru User
Posts: 3441
Joined: Sun Aug 27, 2017 12:05 am

Re: Syslog Plugin - MySQL issue

Post by netniV »

Basically, you get a duplicate partition name for some reason:

Code: Select all

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.
Cacti Developer & Release Manager
The Cacti Group

Director
BV IT Solutions Ltd

+--------------------------------------------------------------------------+

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

Return to “Plugin General”

Who is online

Users browsing this forum: No registered users and 0 guests