search

kagkarlsson / db-scheduler

Persistent cluster-friendly scheduler for Java
Apache License 2.0
1.23k stars 188 forks source link

fix: Revert change in behavior for MariaDB and MySQL with regards to time zone assumptions for persisted timestamps #481

Closed kagkarlsson closed 4 months ago

kagkarlsson commented 4 months ago

Change back to default behavior for MySQL and MariaDB with regards to timestamp persistence and assumptions. It is recommended to persist timestamps in UTC for users of MariaDB and MySQL, but db-scheduler will not enforce it as default, since it in reality requires a controlled upgrade.

Ideally the upgrade-process should be:

  1. All instances of the scheduler should be shutdown
  2. Timestamps in the database-table migrated to UTC
  3. Configuration updated to use alwaysPersistTimestampInUTC()
  4. Instances started again
kagkarlsson commented 4 months ago

🎉 This issue has been resolved in v14.0.0 (Release Notes)