[dev.icinga.com #1129] ido2db with postgres

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/1129

Created by cstamas on 2011-01-19 14:24:17 +00:00

Assignee: (none)
Status: Closed (closed on 2011-05-05 16:12:05 +00:00)
Target Version: (none)
Last Update: 2014-12-08 14:35:41 +00:00 (in Redmine)

Icinga Version: 1.10.0
OS Version: any

---

Hi,

ido2db crashes when I restart icinga.

The postgres version is 8.1
Icinga's git version is e73f020

2011-01-19 10:53:04 CET LOG:  statement: INSERT INTO icinga_logentries (instance_id, logentry_time, entry_time, entry_time_usec, logentry_type, logentry_data, realtime_data, inferred_data_extracted) VALUES ('1', FROM_UNIXTIME(1295430784), FROM_UNIXTIME(1295430784), '165743', '64', 'Successfully shutdown... (PID=14187)', '1', '1')
2011-01-19 10:53:04 CET LOG:  statement: UPDATE icinga_conninfo SET disconnect_time=NOW(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(1295430784), bytes_processed='166738', lines_processed='18600', entries_processed='553' WHERE conninfo_id='18'
2011-01-19 10:53:04 CET FATAL:  no PostgreSQL user name specified in startup packet
2011-01-19 10:53:04 CET FATAL:  no PostgreSQL user name specified in startup packet
2011-01-19 10:53:04 CET FATAL:  no PostgreSQL user name specified in startup packet

[1295430784.313286] [001.2] [pid=14132] ido2db_check_for_client_input() end
[1295430784.313303] [001.2] [pid=14132] ido2db_db_goodbye() start
[1295430784.313315] [001.2] [pid=14132] ido2db_db_timet_to_sql(1295430784) start
[1295430784.313333] [001.2] [pid=14132] ido2db_db_timet_to_sql(FROM_UNIXTIME(1295430784)) end
[1295430784.313356] [001.2] [pid=14132] ido2db_db_query() start
[1295430784.313368] [002.0] [pid=14132] UPDATE icinga_conninfo SET disconnect_time=NOW(), last_checkin_time=NOW(), data_end_time=FROM_UNIXTIME(1295430784), bytes_processed='166738', lines_processed='18600', entries_processed='553' WHERE conninfo_id='18'
[1295430784.330886] [001.2] [pid=14132] ido2db_db_query(0) end
[1295430784.330939] [001.2] [pid=14132] ido2db_db_goodbye() end
[1295430784.330952] [001.2] [pid=14132] ido2db_handle_client_connection() idi.disconnect_client is '0'
[1295430784.330965] [001.2] [pid=14132] ido2db_handle_client_connection() Cancel cleanup thread to terminate
[1295430784.331035] [001.2] [pid=14132] ido2db_child_sighandler() start
[1295430784.331096] [001.2] [pid=14132] Child caught signal '2' exiting
[1295430784.331109] [001.2] [pid=14132] ido2db_child_sighandler() end
[1295430784.331121] [001.2] [pid=14132] ido2db_cleanup_socket() start
[1295430784.331354] [001.2] [pid=14132] ido2db_cleanup_socket() end
[1295430784.331370] [001.2] [pid=14132] ido2db_free_program_memory() start
[1295430784.331388] [001.2] [pid=14132] [1295430784.331390] [001.2] [pid=14132] ido2db_handle_client_connection() cleanup thread terminated
[1295430784.331423] [001.2] [pid=14132] ido2db_db_disconnect() start
[1295430784.331553] [001.2] [pid=14132] ido2db_thread_cleanup() cleanup_exit_handler...
[1295430784.335498] [001.2] [pid=14132] ido2db_db_disconnect() stop
[1295430784.335560] [001.2] [pid=14132] ido2db_db_deinit() start
[1295430784.335595] [001.2] [pid=14132] ido2db_free_cached_object_ids() start
[1295430784.336224] [001.2] [pid=14132] ido2db_free_cached_object_ids() end
[1295430784.336261] [001.2] [pid=14132] ido2db_db_deinit() end
[1295430784.336273] [001.2] [pid=14132] ido2db_free_input_memory() start
[1295430784.336289] [001.2] [pid=14132] ido2db_free_input_memory() end
[1295430784.336301] [001.2] [pid=14132] ido2db_free_connection_memory() start
[1295430784.336313] [001.2] [pid=14132] ido2db_free_connection_memory() end
[1295430784.336325] [001.2] [pid=14132] ido2db_handle_client_connection() end
[1295430784.336460] [001.2] [pid=14132] ido2db_handle_client_connection() start

(this is also available here https://users.itk.ppke.hu/~cstamas/priv/ido2db-vs-postgres2.log)

Thanks.

[icinga-migration]

Updated by cstamas on 2011-01-19 14:26:46 +00:00

the dbi version is:

ii  libdbi0                         0.8.2-3                         Database Independent Abstraction Layer for C

[icinga-migration]

Updated by mfriedrich on 2011-04-27 23:00:39 +00:00

• Project changed from Icinga 1.x to 18

[icinga-migration]

Updated by mfriedrich on 2011-05-05 16:12:05 +00:00

• Status changed from New to Closed

re-open if this is a current problem.

commit e73f0206e04f235fcabc9501f658c19b3158c27f
Author: Michael Friedrich 
Date:   Wed Jan 19 10:18:07 2011 +0100

[icinga-migration]

Updated by mfriedrich on 2014-12-08 14:35:41 +00:00

• Project changed from 18 to Core, Classic UI, IDOUtils
• Category set to IDOUtils
• Icinga Version set to 1
• OS Version set to any