Cacti / plugin_syslog

Syslog Plugin for Cacti
GNU General Public License v2.0
21 stars 16 forks source link

[4.0] - Dupliocate partition warnings #198

Closed seanmancini closed 1 year ago

seanmancini commented 1 year ago

Last night I saw the following errors on all of my Cacti instances the only thing that I can think of is that day light savings times started last night

Different mariadb versions different cacti versions

2022/11/06 00:58:05 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate partition name d20221106
2022/11/06 00:58:05 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[146]:syslog_partition_manage(), /plugins/syslog/functions.php[172]:syslog_partition_create(), /plugins/syslog/functions.php[208]:syslog_db_execute(), /plugins/syslog/database.php[69]:db_execute(), /lib/database.php[272]:db_execute_prepared())
2022/11/06 00:58:05 - CMDPHP ERROR: A DB Exec Failed!, Error: VALUES LESS THAN value must be strictly increasing for each partition
2022/11/06 00:56:55 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[146]:syslog_partition_manage(), /plugins/syslog/functions.php[177]:syslog_partition_create(), /plugins/syslog/functions.php[208]:syslog_db_execute(), /plugins/syslog/database.php[69]:db_execute(), /lib/database.php[272]:db_execute_prepared())
2022/11/06 00:56:55 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate partition name d20221106
2022/11/06 00:56:55 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[146]:syslog_partition_manage(), /plugins/syslog/functions.php[172]:syslog_partition_create(), /plugins/syslog/functions.php[208]:syslog_db_execute(), /plugins/syslog/database.php[69]:db_execute(), /lib/database.php[272]:db_execute_prepared())
2022/11/06 00:56:55 - CMDPHP ERROR: A DB Exec Failed!, Error: VALUES LESS THAN value must be strictly increasing for each partition
2022/11/06 00:56:10 - CMDPHP SQL Backtrace: (/plugins/syslog/syslog_process.php[146]:syslog_partition_manage(), /plugins/syslog/functions.php[177]:syslog_partition_create(), /plugins/syslog/functions.php[208]:syslog_db_execute(), /plugins/syslog/database.php[69]:db_execute(), /lib/database.php[272]:db_execute_prepared())
2022/11/06 00:56:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Duplicate partition name d20221106