[Pgpool-general] Child process # was terminated by segmentation fault

[Clodoaldo Neto]

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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://pgfoundry.org/pipermail/pgpool-general/attachments/20110723/718a29c4/attachment.html>