Join GitHub today
GitHub is home to over 40 million developers working together to host and review code, manage projects, and build software together.Sign up
[dev.icinga.com #2978] Postgresql: Datetime field overflow on host and servicestatus cronks #867
This issue has been migrated from Redmine: https://dev.icinga.com/issues/2978
Created by mfrosch on 2012-08-13 13:24:24 +00:00
I have some sql errors with cronks that use the hoststatus or servicestatus table.
Here are 2 examples:
2012-08-13 14:51:20 +00:00 by mhein 1a5552c
2012-08-13 14:52:12 +00:00 by mhein 7940ba4
Updated by mfrosch on 2012-08-13 14:28:34 +00:00
This bug is introduced by the changes in #2736
Problem: '0000-00-00 00:00:00' is a not supported timestamp in Postgres. The database schema sets '1970-01-01 00:00:00' as default in pgsql.
I suggest the following changes:
This works with MySQL and PgSQL, tested that.
The patch is required for Icinga Web 1.7.2 to work with a Pgsql IDO.