plugin_syslog icon indicating copy to clipboard operation
plugin_syslog copied to clipboard

[4.0] - Duplicate Partition name errors

Open bmfmancini opened this issue 3 years ago • 1 comments

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

bmfmancini avatar Nov 06 '22 13:11 bmfmancini

It's the infamous daylight savings time issue. Good think it only happens once a year!

TheWitness avatar Jun 26 '23 12:06 TheWitness