Uploaded image for project: 'Observium'
  1. Observium
  2. OBS-5056

SQL Error - Incorrect TIMESTAMP value

Details

    • Bug
    • Resolution: Fixed
    • Major
    • None
    • None
    • Default
    • 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)
       

      Attachments

        Activity

          [OBS-5056] SQL Error - Incorrect TIMESTAMP value

          Please update your install. This should be already fixed since r14086.

          landy Mike Stupalov added a comment - Please update your install. This should be already fixed since r14086.

          People

            landy Mike Stupalov
            Shama Tarek
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: