[icinga-users] Problem with PostgreSQL and FROM_UNIXTIME(int)?

Bjørn T Johansen btj at havleik.no
Sun Dec 16 20:29:29 CET 2012

I have just installed Icinga and I see a lot of these in my log...:

Dec 16 03:32:38 gandalf ido2db: Error: database query failed for 'UPDATE icinga_programstatus SET status_update_time=FROM_UNIXTIME(1355625158), program_start_time=FROM_UNIXTIME(1355614426), is_currently_
running=1, process_id=20690, daemon_mode=1, last_command_check=FROM_UNIXTIME(1355625158), last_log_rotation=FROM_UNIXTIME(0), notifications_enabled=1, active_service_checks_enabled=1, passive_service_che
cks_enabled=1, active_host_checks_enabled=1, passive_host_checks_enabled=1, event_handlers_enabled=1, flap_detection_enabled=1, failure_prediction_enabled=1, process_performance_data=0, obsess_over_hosts
=0, obsess_over_services=0, modified_host_attributes=0, modified_service_attributes=0, global_host_event_handler=E'', global_service_event_handler=E'' WHERE instance_id=1' - 'ERROR:  function from_unixti
me(integer) does not exist#012LINE 1: ...PDATE icinga_programstatus SET status_update_time=FROM_UNIXT...#012                                                             ^#012HINT:  No function matches th
e given name and argument types. You might need to add explicit type casts.#012'

Is this a known bug or? How can I fix it?



Bjørn T Johansen

btj at havleik.no
Someone wrote:
"I understand that if you play a Windows CD backwards you hear strange Satanic messages"
To which someone replied:
"It's even worse than that; play it forwards and it installs Windows"

This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.

More information about the icinga-users mailing list