We’ve updated our Icinga Environment from 2.12 to the last 2.13 Version and Icingaweb from 2.8 to 2.11. Actually all is fine except of one thing. On “history → event grid” we get a error that we not understand.
SQLSTATE[42883]: Undefined function: 7 ERROR: function from_unixtime(timestamp without time zone) does not exist
LINE 1: SELECT DATE(FROM_UNIXTIME(sth.timestamp)) AS day, SUM(CASE W...
^
HINT: No function matches the given name and argument types. You might need to add explicit type casts., query was: SELECT DATE(FROM_UNIXTIME(sth.timestamp)) AS day, SUM(CASE WHEN sth.state = 2 AND sth.type = 'hard_state' THEN 1 ELSE 0 END) AS cnt_critical_hard FROM (SELECT sh.statehistory_id AS id, ('service') AS object_type, h.display_name AS host_display_name, so.name1 AS host_name, so.name2 AS service_description, s.display_name AS service_display_name, so.name1 AS service_host_name, (CASE WHEN sh.state_type = 1 THEN 'hard_state' ELSE 'soft_state' END) AS type, sh.state_time AS timestamp, sh.object_id, sh.state, (CASE WHEN sh.state_type = 1 THEN sh.output ELSE '[ ' || sh.current_check_attempt || '/' || sh.max_check_attempts || ' ] ' || sh.output END) AS output FROM icinga_statehistory AS sh
INNER JOIN icinga_objects AS so ON so.object_id = sh.object_id AND so.is_active = 1 AND so.objecttype_id = 2
INNER JOIN icinga_services AS s ON s.service_object_id = so.object_id
INNER JOIN icinga_hosts AS h ON h.host_object_id = s.host_object_id WHERE (sh.state_time >= '2022-04-20 14:09:16')) AS sth GROUP BY DATE(FROM_UNIXTIME(sth.timestamp)) ORDER BY DATE(FROM_UNIXTIME(sth.timestamp)) DESC
i’ve executed all database update sql-files. but we can’t fix the error.
informations about our environment:
icinga2 - The Icinga 2 network monitoring daemon (version: r2.13.4-1)
Copyright (c) 2012-2022 Icinga GmbH (https://icinga.com/)
License GPLv2+: GNU GPL version 2 or later https://gnu.org/licenses/gpl2.html
This is free software: you are free to change and redistribute it.
There is NO WARRANTY, to the extent permitted by law.
System information:
Platform: CentOS Linux
Platform version: 7 (Core)
Kernel: Linux
Kernel version: 4.14.35-2047.514.5.el7uek.x86_64
Architecture: x86_64
Build information:
Compiler: GNU 11.2.1
Build host: runner-hh8q3bz2-project-322-concurrent-0
OpenSSL version: OpenSSL 1.0.2k-fips 26 Jan 2017
Application information:
General paths:
Config directory: /etc/icinga2
Data directory: /var/lib/icinga2
Log directory: /var/log/icinga2
Cache directory: /var/cache/icinga2
Spool directory: /var/spool/icinga2
Run directory: /run/icinga2
Old paths (deprecated):
Installation root: /usr
Sysconf directory: /etc
Run directory (base): /run
Local state directory: /var
Internal paths:
Package data directory: /usr/share/icinga2
State path: /var/lib/icinga2/icinga2.state
Modified attributes path: /var/lib/icinga2/modified-attributes.conf
Objects path: /var/cache/icinga2/icinga2.debug
Vars path: /var/cache/icinga2/icinga2.vars
PID path: /run/icinga2/icinga2.pid
Icinga Web 2 2.11.0
Git Commit 46998464ea9f9e3c2889d98f9fb6df639d972550
PHP Version 7.3.29
MODULE VERSION
director 1.9.1
incubator 0.17.0
jira 1.2.1
monitoring 2.11.0
reactbundle 0.9.0
translation 2.11.0