Bug #1129

ido2db with postgres

Added by cstamas over 3 years ago. Updated almost 3 years ago.

Status:ClosedStart date:01/19/2011
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:-
Target version:-
Icinga Version: DB Type:
IDO Version: DB Version:

Description

Hi,

ido2db crashes when I restart icinga.

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

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.

History

#1 Updated by cstamas over 3 years ago

the dbi version is:

ii  libdbi0                         0.8.2-3                         Database Independent Abstraction Layer for C

#2 Updated by dnsmichi almost 3 years ago

  • Project changed from Icinga 1.x to IDOUtils

#3 Updated by dnsmichi almost 3 years ago

  • Status changed from New to Closed

re-open if this is a current problem.

commit e73f0206e04f235fcabc9501f658c19b3158c27f
Author: Michael Friedrich <michael.friedrich@univie.ac.at>
Date:   Wed Jan 19 10:18:07 2011 +0100

Also available in: Atom PDF