[pgpool-general: 2141] Re: read_startup_packet: incorrect packet length What does that mean?

Wed Sep 18 00:10:16 JST 2013

In addition.

The errors described in the post could cause also something weird what I am
experiencing.

I hit following to show cluster nodes:

psql -c "show pool_nodes;" -d postgres -U postgres -p 9898

The terminal session is stucked then. I cannot cancel the command even with
CTRL+C. 

However I can attach node successfully with command:

pcp_attach_node -d 5 tc1 9898 postgres postgres 1

Best regards,

Michal Mistina

From: pgpool-general-bounces at pgpool.net
[mailto:pgpool-general-bounces at pgpool.net] On Behalf Of Mistina Michal
Sent: Tuesday, September 17, 2013 1:54 PM
To: pgpool-general at pgpool.net
Subject: [pgpool-general: 2140] read_startup_packet: incorrect packet length
What does that mean?

Dear all.

I don't understand what I see in the log files. Following keeps happening
all the time after I start pgpool:

2013-09-17 13:26:31 ERROR: pid 5697: read_startup_packet: incorrect packet
length (983664419)

2013-09-17 13:26:49 LOG:   pid 3608: do_child: failback event found. restart
myself.

2013-09-17 13:26:49 ERROR: pid 5833: read_startup_packet: incorrect packet
length (983664419)

2013-09-17 13:27:01 LOG:   pid 3591: do_child: failback event found. restart
myself.

2013-09-17 13:27:01 ERROR: pid 6000: read_startup_packet: incorrect packet
length (983664419)

2013-09-17 13:27:19 ERROR: pid 5372: read_startup_packet: incorrect packet
length (983664419)

2013-09-17 13:27:31 LOG:   pid 3586: do_child: failback event found. restart
myself.

2013-09-17 13:27:31 ERROR: pid 5372: read_startup_packet: incorrect packet
length (983664419)

2013-09-17 13:27:49 ERROR: pid 6151: read_startup_packet: incorrect packet
length (983664419)

2013-09-17 13:28:01 ERROR: pid 3590: read_startup_packet: incorrect packet
length (983664419)

Versions:

pgpool-II-3.3.1-1.pgdg.x86_64

postgresql92-9.2.4-1PGDG.rhel6.x86_64

postgresql92-libs-9.2.4-1PGDG.rhel6.x86_64

postgresql92-server-9.2.4-1PGDG.rhel6.x86_64

Where should I look at? When do occure aforementioned errors?

Probably I set something wrong in the config file. Or permissions on some
files are wrong.

The pgpool.conf follows.

listen_addresses = '*'

port = 9999

socket_dir = '/tmp'

pcp_port = 9898

pcp_socket_dir = '/tmp'

backend_hostname0 = 'tc1'

backend_port0 = 5432

backend_weight0 = 1

backend_data_directory0 = '/var/lib/pgsql/9.2/data'

backend_flag0 = 'ALLOW_TO_FAILOVER'

backend_hostname1 = 'tc2'

backend_port1 = 5432

backend_weight1 = 1

backend_data_directory1 = '/var/lib/pgsql/9.2/data'

backend_flag1 = 'ALLOW_TO_FAILOVER'

enable_pool_hba = off

pool_passwd = 'pool_passwd'

authentication_timeout = 60

ssl = off

num_init_children = 32

max_pool = 4

child_life_time = 300

child_max_connections = 0

connection_life_time = 0

client_idle_limit = 0

log_destination = 'stderr'

print_timestamp = on

log_connections = off

log_hostname = off

log_statement = off

log_per_node_statement = off

log_standby_delay = 'none'

syslog_facility = 'LOCAL0'

syslog_ident = 'pgpool'

debug_level = 0

pid_file_name = '/var/run/pgpool/pgpool.pid'

logdir = '/var/log/pgpool'

connection_cache = on

reset_query_list = 'ABORT; DISCARD ALL'

replication_mode = off

replicate_select = off

insert_lock = on

lobj_lock_table = ''

replication_stop_on_mismatch = off

failover_if_affected_tuples_mismatch = off

load_balance_mode = off

ignore_leading_white_space = on

white_function_list = ''

black_function_list = 'nextval,setval'

master_slave_mode = on

master_slave_sub_mode = 'stream'

sr_check_period = 10

sr_check_user = 'replication'

sr_check_password = 'replicate'

delay_threshold = 10000000

follow_master_command = ''

parallel_mode = off

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 = ''

health_check_period = 20

health_check_timeout = 20

health_check_user = 'replication'

health_check_password = 'replicate'

health_check_max_retries = 5

health_check_retry_delay = 1

failover_command = '/usr/pgsql-9.2/bin/failover_stream.sh %d %H
/tmp/trigger_file'

failback_command = ''

fail_over_on_backend_error = on

search_primary_node_timeout = 10

recovery_user = 'nobody'

recovery_password = ''

recovery_1st_stage_command = ''

recovery_2nd_stage_command = ''

recovery_timeout = 90

client_idle_limit_in_recovery = 0

use_watchdog = off

trusted_servers = '192.168.105.254'

ping_path = '/bin'

wd_hostname = ''

wd_port = 9000

wd_authkey = ''

delegate_IP = ''

ifconfig_path = '/sbin'

if_up_cmd = 'ifconfig eth0:0 inet $_IP_$ netmask 255.255.255.0'

if_down_cmd = 'ifconfig eth0:0 down'

arping_path = '/usr/sbin'           

arping_cmd = 'arping -U $_IP_$ -w 1'

clear_memqcache_on_escalation = on

wd_escalation_command = ''

wd_lifecheck_method = 'heartbeat'

wd_interval = 5

wd_heartbeat_port = 9694

wd_heartbeat_keepalive = 2

wd_heartbeat_deadtime = 30

heartbeat_destination0 = 'tc2'

heartbeat_destination_port0 = 9694 

heartbeat_device0 = ''

wd_life_point = 3

wd_lifecheck_query = 'SELECT 1'

wd_lifecheck_dbname = 'template1'

wd_lifecheck_user = 'replication'

wd_lifecheck_password = 'replicate'

relcache_expire = 0

relcache_size = 256

check_temp_table = on

memory_cache_enabled = off

memqcache_method = 'shmem'

memqcache_memcached_host = 'localhost'

memqcache_memcached_port = 11211

memqcache_total_size = 67108864

memqcache_max_num_cache = 1000000

memqcache_expire = 0

memqcache_auto_cache_invalidation = on

memqcache_maxcache = 409600

memqcache_cache_block_size = 1048576

memqcache_oiddir = '/var/log/pgpool/oiddir'

white_memqcache_table_list = ''

black_memqcache_table_list = ''

Best regards,

Michal Mistina

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130917/965540b5/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 3076 bytes
Desc: not available
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20130917/965540b5/attachment-0001.p7s>