After upgrade to 4.0.0 - Monitoring: Mysql2::Error: Incorrect datetime value


  • Used Zammad version: 4.0.0-1616833066.ac840931.buster
  • Used Zammad installation source: package
  • Operating system: Debian Buster
  • Browser + version: FF, Chromium

Expected behavior:

  • system/monitoring status green

Actual behavior:

  • Failed to run scheduled job 'Execute jobs'. Cause: Failed to run after 10 tries #<ActiveRecord::StatementInvalid: Mysql2::Error: Incorrect datetime value: '2021-03-28 02:00:00.268000' for column `zammad`.`jobs`.`next_run_at` at row 1: UPDATE `jobs` SET `next_run_at` = '2021-03-28 02:00:00.268000'

Steps to reproduce the behavior:

  • occurred right after upgrade to 4.0.0
  • mysql column of type timestamp(3)
  • there is no migrate job which changes to timestamp fraction 6

I saved all the scheduled jobs again and now it works.


This topic was automatically closed 120 days after the last reply. New replies are no longer allowed.