[Pgpool-general] problem to use the replication

Gary Fu gfu at saicmodis.com
Fri Aug 18 16:43:01 UTC 2006 

Hi,

I'm using pgpool 3.1.1 on a linux system with two dbs running PostgreSQL 
8.0.8.

When I tried to use the replication mode I got the
following error message with the command 'psql -p 9999 -c 'show 
pool_status' template1'.
The command works okay if the replication mode is off.
Could any one let me know what is the problem ?  
Thanks,
Gary

5:08pm 259 postgres at nppdist:/var/lib/pgsql/data> psql -p 9999 -c 'show 
pool_status' template1
2006-08-16 17:08:03 DEBUG: pid 2755: I am 2755 accept fd 6
2006-08-16 17:08:03 DEBUG: pid 2755: Protocol Major: 1234 Minor: 5679 
database:  user:
2006-08-16 17:08:03 DEBUG: pid 2755: SSLRequest: sent N; retry startup
2006-08-16 17:08:03 DEBUG: pid 2755: Protocol Major: 3 Minor: 0 
database: template1 user: postgres
2006-08-16 17:08:04 DEBUG: pid 2755: pool_read_message_length: lenghth: 12
2006-08-16 17:08:04 ERROR: pid 2755: pool_read_message_length: length 
does not match between backends master(12) secondary(8)
psql: server closed the connection unexpectedly
       This probably means the server terminated abnormally
       before or while processing the request.

Here is the log when I started up the pgpool :

5:06pm 259 postgres at nppdist:/var/lib/pgsql/data> 2006-08-16 17:06:54 
DEBUG: pid 2734: key: listen_addresses
2006-08-16 17:06:54 DEBUG: pid 2734: value: '192.168.10.75' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: key: port
2006-08-16 17:06:54 DEBUG: pid 2734: value: 9999 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: socket_dir
2006-08-16 17:06:54 DEBUG: pid 2734: value: '/tmp' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: key: backend_host_name
2006-08-16 17:06:54 DEBUG: pid 2734: value: '192.168.10.75' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: :192.168.10.75:
2006-08-16 17:06:54 DEBUG: pid 2734: key: backend_port
2006-08-16 17:06:54 DEBUG: pid 2734: value: 5432 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: backend_socket_dir
2006-08-16 17:06:54 DEBUG: pid 2734: value: '/tmp' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: key: secondary_backend_host_name
2006-08-16 17:06:54 DEBUG: pid 2734: value: '192.168.10.76' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: :192.168.10.76:
2006-08-16 17:06:54 DEBUG: pid 2734: key: secondary_backend_port
2006-08-16 17:06:54 DEBUG: pid 2734: value: 5432 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: num_init_children
2006-08-16 17:06:54 DEBUG: pid 2734: value: 32 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: max_pool
2006-08-16 17:06:54 DEBUG: pid 2734: value: 4 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: child_life_time
2006-08-16 17:06:54 DEBUG: pid 2734: value: 300 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: connection_life_time
2006-08-16 17:06:54 DEBUG: pid 2734: value: 0 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: child_max_connections
2006-08-16 17:06:54 DEBUG: pid 2734: value: 0 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: logdir
2006-08-16 17:06:54 DEBUG: pid 2734: value: '/tmp' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: key: replication_mode
2006-08-16 17:06:54 DEBUG: pid 2734: value: true kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: replication_strict
2006-08-16 17:06:54 DEBUG: pid 2734: value: true kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: replication_timeout
2006-08-16 17:06:54 DEBUG: pid 2734: value: 5000 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: load_balance_mode
2006-08-16 17:06:54 DEBUG: pid 2734: value: true kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: weight_master
2006-08-16 17:06:54 DEBUG: pid 2734: value: 0.5 kind: 3
2006-08-16 17:06:54 DEBUG: pid 2734: weight_master: 0.500000
2006-08-16 17:06:54 DEBUG: pid 2734: key: weight_secondary
2006-08-16 17:06:54 DEBUG: pid 2734: value: 0.5 kind: 3
2006-08-16 17:06:54 DEBUG: pid 2734: weight_secondary: 0.500000
2006-08-16 17:06:54 DEBUG: pid 2734: key: replication_stop_on_mismatch
2006-08-16 17:06:54 DEBUG: pid 2734: value: false kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: replication_stop_on_mismatch: 0
2006-08-16 17:06:54 DEBUG: pid 2734: key: reset_query_list
2006-08-16 17:06:54 DEBUG: pid 2734: value: 'ABORT; RESET ALL; SET 
SESSION AUTHORIZATION DEFAULT' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: extract_string_tokens: token: ABORT
2006-08-16 17:06:54 DEBUG: pid 2734: extract_string_tokens: token:  
RESET ALL
2006-08-16 17:06:54 DEBUG: pid 2734: extract_string_tokens: token:  SET 
SESSION AUTHORIZATION DEFAULT
2006-08-16 17:06:54 DEBUG: pid 2734: key: print_timestamp
2006-08-16 17:06:54 DEBUG: pid 2734: value: true kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: master_slave_mode
2006-08-16 17:06:54 DEBUG: pid 2734: value: false kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: connection_cache
2006-08-16 17:06:54 DEBUG: pid 2734: value: true kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: health_check_timeout
2006-08-16 17:06:54 DEBUG: pid 2734: value: 20 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: health_check_period
2006-08-16 17:06:54 DEBUG: pid 2734: value: 0 kind: 2
2006-08-16 17:06:54 DEBUG: pid 2734: key: health_check_user
2006-08-16 17:06:54 DEBUG: pid 2734: value: 'nobody' kind: 4
2006-08-16 17:06:54 DEBUG: pid 2734: key: insert_lock
2006-08-16 17:06:54 DEBUG: pid 2734: value: false kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: ignore_leading_white_space
2006-08-16 17:06:54 DEBUG: pid 2734: value: false kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: key: log_statement
2006-08-16 17:06:54 DEBUG: pid 2734: value: false kind: 1
2006-08-16 17:06:54 DEBUG: pid 2734: weight: 1073741823
2006-08-16 17:06:54 DEBUG: pid 2736: I am 2736
2006-08-16 17:06:54 DEBUG: pid 2737: I am 2737
2006-08-16 17:06:54 DEBUG: pid 2738: I am 2738
2006-08-16 17:06:54 DEBUG: pid 2739: I am 2739
2006-08-16 17:06:54 DEBUG: pid 2740: I am 2740
2006-08-16 17:06:54 DEBUG: pid 2741: I am 2741
2006-08-16 17:06:54 DEBUG: pid 2742: I am 2742
2006-08-16 17:06:54 DEBUG: pid 2743: I am 2743
2006-08-16 17:06:54 DEBUG: pid 2744: I am 2744
2006-08-16 17:06:54 DEBUG: pid 2745: I am 2745
2006-08-16 17:06:54 DEBUG: pid 2746: I am 2746
2006-08-16 17:06:54 DEBUG: pid 2747: I am 2747
2006-08-16 17:06:54 DEBUG: pid 2748: I am 2748
2006-08-16 17:06:54 DEBUG: pid 2749: I am 2749
2006-08-16 17:06:54 DEBUG: pid 2750: I am 2750
2006-08-16 17:06:54 DEBUG: pid 2751: I am 2751
2006-08-16 17:06:54 DEBUG: pid 2752: I am 2752
2006-08-16 17:06:54 DEBUG: pid 2753: I am 2753
2006-08-16 17:06:54 DEBUG: pid 2754: I am 2754
2006-08-16 17:06:54 DEBUG: pid 2755: I am 2755
2006-08-16 17:06:54 DEBUG: pid 2756: I am 2756
2006-08-16 17:06:54 DEBUG: pid 2757: I am 2757
2006-08-16 17:06:54 DEBUG: pid 2758: I am 2758
2006-08-16 17:06:54 DEBUG: pid 2759: I am 2759
2006-08-16 17:06:54 DEBUG: pid 2760: I am 2760
2006-08-16 17:06:54 DEBUG: pid 2761: I am 2761
2006-08-16 17:06:54 DEBUG: pid 2762: I am 2762
2006-08-16 17:06:54 DEBUG: pid 2763: I am 2763
2006-08-16 17:06:54 DEBUG: pid 2764: I am 2764
2006-08-16 17:06:54 DEBUG: pid 2765: I am 2765
2006-08-16 17:06:54 DEBUG: pid 2766: I am 2766
2006-08-16 17:06:54 DEBUG: pid 2767: I am 2767
2006-08-16 17:06:54 LOG:   pid 2734: pgpool successfully started

More information about the Pgpool-general mailing list