[Pgpool-general] Error with streaming/balancing / pgpool 3.0.4

[Olivier NOEL]

2011/8/16 Tatsuo Ishii <ishii at sraoss.co.jp>:
> What operation did you do when you were getting errors below? Did you
> try to connect to pgpool using psql? Or starting pgpool immediately
> causes the errors?

Starting pgpool causes the errors

> Also turning on debug mode of pgpool-II will give you slightly detailed info.
> I suggest this if you are getting errors.

here are the complete error messages :

2011-08-16 12:25:41 DEBUG: pid 1568: pool_ssl: SSL requested but SSL
support is not available
2011-08-16 12:25:41 DEBUG: pid 1568: s_do_auth: auth kind: 0
2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "E"
before processing BackendKeyData
2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response ""
before processing BackendKeyData
2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response ""
before processing BackendKeyData
2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response ""
before processing BackendKeyData
2011-08-16 12:25:41 ERROR: pid 1568: s_do_auth: unknown response "]"
before processing BackendKeyData
2011-08-16 12:25:41 DEBUG: pid 1568: s_do_auth: parameter status data received
2011-08-16 12:25:41 ERROR: pid 1568: pool_read2: failed to realloc
2011-08-16 12:25:46 DEBUG: pid 1534: pool_ssl: SSL requested but SSL
support is not available
2011-08-16 12:25:46 DEBUG: pid 1534: s_do_auth: auth kind: 0
2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "E"
before processing BackendKeyData
2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response ""
before processing BackendKeyData
2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response ""
before processing BackendKeyData
2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response ""
before processing BackendKeyData
2011-08-16 12:25:46 ERROR: pid 1534: s_do_auth: unknown response "]"
before processing BackendKeyData
2011-08-16 12:25:46 DEBUG: pid 1534: s_do_auth: parameter status data received
2011-08-16 12:25:46 ERROR: pid 1534: pool_read2: failed to realloc

SSL is disabled on the Postgresql servers.

> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
> English: http://www.sraoss.co.jp/index_en.php
> Japanese: http://www.sraoss.co.jp
>
>>  Hello,
>>
>> I have an error with pgpool 3.0.4 in a streaming/balancing
>> configuration with 1 master and 2 slaves :
>>
>> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown
>> response "E" before processing BackendKeyData
>> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown response "
>> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown response "
>> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown response "
>> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: s_do_auth: unknown
>> response "]" before processing BackendKeyData
>> pgpool: 2011-08-16 10:51:58 ERROR: pid 1239: pool_read2: failed to realloc
>>
>> I followed the documentation on the website for the configuration of
>> the postgresql servers and pgpool.
>>
>> DB servers are FreeBSD with latest Postgresql server, configured in
>> streaming mode (1 master and 2 slaves), replication/failover is
>> functional.
>>
>> The pgpool host is a Debian Wheezy with pgpooladmin. Pgpool has been
>> install from packages. I have the same error without pgpooladmin.
>>
>> I tested installing pgpool from sources and I have the same error.
>>
>> I also tested pgpool on a FreeBSD box from ports and from sources, and
>> same error.
>>
>> here is the config file :
>>
>> listen_addresses = '*'
>>
>> port = 5432
>>
>> pcp_port = 9898
>>
>> socket_dir = '/tmp'
>>
>> pcp_socket_dir = '/tmp'
>>
>> backend_socket_dir = '/tmp'
>>
>> pcp_timeout = 10
>>
>> num_init_children = 32
>>
>> max_pool = 4
>>
>> child_life_time = 300
>>
>> connection_life_time = 0
>>
>> child_max_connections = 0
>>
>> client_idle_limit = 0
>>
>> authentication_timeout = 60
>>
>> logdir = '/tmp'
>>
>> pid_file_name = '/tmp/pgpool.pid'
>>
>> replication_mode = false
>>
>> load_balance_mode = true
>>
>> 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 = true
>>
>> master_slave_sub_mode = 'stream'
>>
>> delay_threshold = 10000000
>>
>> log_standby_delay = 'if_over_threshold'
>>
>> connection_cache = true
>>
>> health_check_timeout = 10
>>
>> health_check_period = 20
>>
>> health_check_user = 'postgres'
>>
>> failover_command = '/usr/local/etc/failover.sh %d "%h" %p %D %m %M "%H" %P'
>>
>> failback_command = ''
>>
>> fail_over_on_backend_error = true
>>
>> insert_lock = false
>>
>> ignore_leading_white_space = true
>>
>> log_statement = false
>>
>> log_per_node_statement = false
>>
>> log_connections = false
>>
>> log_hostname = false
>>
>> parallel_mode = false
>>
>> enable_query_cache = false
>>
>> pgpool2_hostname = 'pglb01'
>>
>> system_db_hostname = 'fpg01'
>> system_db_port = 5432
>> system_db_dbname = 'pgpool'
>> system_db_schema = 'pgpool_catalog'
>> system_db_user = 'pgpool'
>> system_db_password = 'password'
>>
>>
>> nable_pool_hba = false
>>
>> recovery_user = 'postgres'
>>
>> recovery_password = ''
>>
>> recovery_1st_stage_command = 'basebackup.sh'
>>
>> recovery_2nd_stage_command = ''
>>
>> recovery_timeout = 90
>>
>> client_idle_limit_in_recovery = 0
>>
>> lobj_lock_table = ''
>>
>> ssl = false
>>
>> debug_level = 0
>> replication_timeout = 5000
>> backend_hostname0 = 'fpg01'
>> backend_port0 = 5432
>> backend_data_directory0 = '/usr/local/pgsql/data'
>> backend_weight0 = 1
>> backend_hostname1 = 'fpg02'
>> backend_port1 = 5432
>> backend_data_directory1 = '/usr/local/pgsql/data'
>> backend_weight1 = 2
>> backend_hostname2 = 'fpg03'
>> backend_port2 = 5432
>> backend_data_directory2 = '/usr/local/pgsql/data'
>> backend_weight2 = 2
>>
>> --
>> Olivier
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
>