Details
-
Bug
-
Resolution: Fixed
-
Major
-
None
-
None
-
None
Description
Hi,
We see this error at our SQL DB:
2025-07-13 08:06:54 MySQL_Session.cpp:4311:handler_minus1_LogErrorDuringQuery(): [WARNING] Error during query on (40,tools-db-master,3306,53996069) , user "tools_observium_rw@10.10.10.10" , schema "observium" , 1525, Incorrect TIMESTAMP value: 'DATE_SUB(NOW(), INTERVAL 24 HOUR)' . digest_text = "SELECT * FROM `ports` AS I LEFT JOIN `devices` AS D ON I.`device_id` = D.`device_id` WHERE D.`status` = ? AND D.`ignore` = ? AND I.`ignore` = ? AND I.`deleted` = ? AND `I`.`ifAdminStatus` = ? AND `I`.`ifOperStatus` IN (?,?) AND `I`.`ifLastChange` >= ? AND ((`I`.`port_id` NOT IN (?,?,?,...) AND `I`.`port_id` IS NOT ?)) ORDER BY I.`ifLastChange` DESC,D.`hostname` ASC,I.`ifDescr` *? ASC"
We are using version
25.5.14029 (rolling) (23rd May 2025) |
Please update your install. This should be already fixed since r14086.