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

[Toshihiro Kitagawa]

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 <clodoaldo.pinto.neto at gmail.com> 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