Hi, > 2011-07-23 18:38:13 DEBUG: pid 11886: pool_do_auth: auth kind:5 > 2011-07-23 18:38:13 DEBUG: pid 11886: trying md5 authentication > 2011-07-23 18:38:13 DEBUG: pid 11886: DB node id: 0 salt: 3a4508 > 2011-07-23 18:38:13 DEBUG: pid 11881: reap_handler called > 2011-07-23 18:38:13 DEBUG: pid 11881: reap_handler: call wait3 > 2011-07-23 18:38:13 ERROR: pid 11881: Child process 11886 was terminated by > segmentation fault > 2011-07-23 18:38:13 DEBUG: pid 11881: child 11886 exits with status 139 by > signal 11 > 2011-07-23 18:38:13 DEBUG: pid 11881: fork a new child pid 11905
I think that this might be the following bug which was fixed in version 3.0.3. - Fix bug with md5 authentication. If raw mode or number of backend is 1, pgpool child segfaults. Patch contributed by Rob Shepherd(Tatsuo) -- Toshihiro Kitagawa SRA OSS, Inc. Japan On Sat, 23 Jul 2011 16:02:57 -0300 Clodoaldo Neto <[email protected]> wrote: > pgpool-II-90.x86_64 3.0.1-1.rhel6 @pgdg90 Centos 6 > > $ psql -h localhost -p 9999 -U user db > Password for user user: > psql: server closed the connection unexpectedly > This probably means the server terminated abnormally > before or while processing the request. > > 2011-07-23 18:38:10 LOG: pid 11886: connection received: host=127.0.0.1 > port=53791 > 2011-07-23 18:38:10 DEBUG: pid 11886: Protocol Major: 1234 Minor: 5679 > database: user: > 2011-07-23 18:38:10 DEBUG: pid 11886: SSLRequest from client > 2011-07-23 18:38:10 DEBUG: pid 11886: pool_ssl: SSL requested but SSL > support is not available > 2011-07-23 18:38:10 DEBUG: pid 11886: Protocol Major: 3 Minor: 0 database: > fahstats user: kakaostats > 2011-07-23 18:38:10 DEBUG: pid 11886: new_connection: connecting 0 backend > 2011-07-23 18:38:10 DEBUG: pid 11886: pool_ssl: SSL requested but SSL > support is not available > 2011-07-23 18:38:11 DEBUG: pid 11886: pool_read_message_length: slot: 0 > length: 12 > 2011-07-23 18:38:11 DEBUG: pid 11886: pool_do_auth: auth kind:5 > 2011-07-23 18:38:11 DEBUG: pid 11886: trying md5 authentication > 2011-07-23 18:38:11 DEBUG: pid 11886: DB node id: 0 salt: 3f813d73 > 2011-07-23 18:38:11 DEBUG: pid 11886: read_password_packet_password: failed > to read password packet "p" > 2011-07-23 18:38:11 ERROR: pid 11886: do_md5: read_password_packet failed > 2011-07-23 18:38:11 DEBUG: pid 11886: do_md5failed in slot 0 > 2011-07-23 18:38:12 DEBUG: pid 11886: I am 11886 accept fd 5 > 2011-07-23 18:38:12 LOG: pid 11886: connection received: host=127.0.0.1 > port=53794 > 2011-07-23 18:38:12 DEBUG: pid 11886: Protocol Major: 1234 Minor: 5679 > database: user: > 2011-07-23 18:38:12 DEBUG: pid 11886: SSLRequest from client > 2011-07-23 18:38:12 DEBUG: pid 11886: pool_ssl: SSL requested but SSL > support is not available > 2011-07-23 18:38:12 DEBUG: pid 11886: Protocol Major: 3 Minor: 0 database: > fahstats user: kakaostats > 2011-07-23 18:38:12 DEBUG: pid 11886: new_connection: connecting 0 backend > 2011-07-23 18:38:12 DEBUG: pid 11886: pool_ssl: SSL requested but SSL > support is not available > 2011-07-23 18:38:13 DEBUG: pid 11886: pool_read_message_length: slot: 0 > length: 12 > 2011-07-23 18:38:13 DEBUG: pid 11886: pool_do_auth: auth kind:5 > 2011-07-23 18:38:13 DEBUG: pid 11886: trying md5 authentication > 2011-07-23 18:38:13 DEBUG: pid 11886: DB node id: 0 salt: 3a4508 > 2011-07-23 18:38:13 DEBUG: pid 11881: reap_handler called > 2011-07-23 18:38:13 DEBUG: pid 11881: reap_handler: call wait3 > 2011-07-23 18:38:13 ERROR: pid 11881: Child process 11886 was terminated by > segmentation fault > 2011-07-23 18:38:13 DEBUG: pid 11881: child 11886 exits with status 139 by > signal 11 > 2011-07-23 18:38:13 DEBUG: pid 11881: fork a new child pid 11905 > > It works connecting diretly to the db: > > $ psql -h localhost -p 5433 -U user db > Password for user user: > psql (9.0.4, server 8.4.8) > WARNING: psql version 9.0, server version 8.4. > Some psql features might not work. > Type "help" for help. > > listen_addresses = 'localhost' > port = 9999 > pcp_port = 9898 > socket_dir = '/var/run/pgpool-II-90' > pcp_socket_dir = '/var/run/pgpool-II-90' > backend_socket_dir = '/var/run/pgpool-II-90' > pcp_timeout = 10 > num_init_children = 16 > max_pool = 4 > child_life_time = 300 > connection_life_time = 0 > child_max_connections = 0 > client_idle_limit = 30 > authentication_timeout = 60 > logdir = '/var/log/pgpool-II' > pid_file_name = '/var/run/pgpool-II-90/pgpool.pid' > replication_mode = false > load_balance_mode = false > replication_stop_on_mismatch = false > failover_if_affected_tuples_mismatch = false > replicate_select = false > reset_query_list = 'ABORT; DISCARD ALL' > white_function_list = '' > black_function_list = 'nextval,setval' > print_timestamp = true > master_slave_mode = false > master_slave_sub_mode = 'slony' > delay_threshold = 0 > log_standby_delay = 'none' > connection_cache = true > health_check_timeout = 20 > health_check_period = 0 > health_check_user = 'nobody' > failover_command = '' > failback_command = '' > fail_over_on_backend_error = true > insert_lock = true > ignore_leading_white_space = true > log_statement = false > log_per_node_statement = false > log_connections = true > log_hostname = false > parallel_mode = false > enable_query_cache = false > pgpool2_hostname = '' > system_db_hostname = 'localhost' > system_db_port = 5432 > system_db_dbname = 'pgpool' > system_db_schema = 'pgpool_catalog' > system_db_user = 'pgpool' > system_db_password = '' > backend_hostname0 = 'localhost' > backend_port0 = 5433 > backend_weight0 = 1 > backend_data_directory0 = '/var/lib/pgsql/9.0/data' > enable_pool_hba = false > recovery_user = 'nobody' > recovery_password = '' > recovery_1st_stage_command = '' > recovery_2nd_stage_command = '' > recovery_timeout = 90 > client_idle_limit_in_recovery = 0 > lobj_lock_table = '' > ssl = false > debug_level = 1 > > Regards, Clodoaldo _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
