[Pgpool-general] cont. pgpool with enterprisedb + slony-I

Thu Mar 30 01:13:55 GMT 2006

It seems your secondary server returns an error right after
successfull authentication. Do you see any error message in the
secondary PostgreSQL log?
--
Tatsuo Ishii
SRA OSS, Inc. Japan

> Hi all,
> I cannot post reply to my previous thread (do not know how to)
> I am running pgpool-3.0.0-1.i386.rpm installed on FedoraCore3 with
> EnterpriseDB_8.1.3.12 + bundled Slony-I
> 
> Question: Am I suppose to run pgpool where enterprisedb running. In this case
> yes, I am running pgpool where I am running enterprisedb server (on master).
> 
> (master 203 : running enterprisedb + slony-I + pgpool)
> (slave 204  : running enterprisedb + slony-I)
> 
> (Actually I have tried also running pgpool on different machine say 205)
> 
> I was wondering if I could run pgpool on machine say 205 as a loadbalancer if I
> could get to work my current problem?
> 
> Here is my logfile output with -d option:
> ***********************************************
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: listen_addresses
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: '*' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: port
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 9999 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: socket_dir
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: '/tmp' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: backend_host_name
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: '192.168.5.203' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: :192.168.5.203:
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: backend_port
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 5444 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: backend_socket_dir
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: '/tmp' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: secondary_backend_host_name
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: '192.168.5.204' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: :192.168.5.204:
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: secondary_backend_port
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 5444 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: num_init_children
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 32 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: max_pool
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 4 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: child_life_time
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 300 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: connection_life_time
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 0 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: child_max_connections
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 0 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: logdir
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: '/tmp' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_mode
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: false kind: 1
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_strict
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_timeout
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 5000 kind: 2
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: load_balance_mode
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: weight_master
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 0.5 kind: 3
> 2006-03-30 20:29:37 DEBUG: pid 10623: weight_master: 0.500000
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: weight_secondary
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 0.5 kind: 3
> 2006-03-30 20:29:37 DEBUG: pid 10623: weight_secondary: 0.500000
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: replication_stop_on_mismatch
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: false kind: 1
> 2006-03-30 20:29:37 DEBUG: pid 10623: replication_stop_on_mismatch: 0
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: reset_query_list
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: 'ABORT; RESET ALL; SET SESSION
> AUTHORIZATION DEFAULT' kind: 4
> 2006-03-30 20:29:37 DEBUG: pid 10623: extract_string_tokens: token: ABORT
> 2006-03-30 20:29:37 DEBUG: pid 10623: extract_string_tokens: token:  RESET ALL
> 2006-03-30 20:29:37 DEBUG: pid 10623: extract_string_tokens: token:  SET SESSION
> AUTHORIZATION DEFAULT
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: print_timestamp
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: master_slave_mode
> 2006-03-30 20:29:37 DEBUG: pid 10623: value: true kind: 1
> 2006-03-30 20:29:37 DEBUG: pid 10623: key: connection_cache
> 2006-03-30 20:29:38 DEBUG: pid 10623: value: true kind: 1
> 2006-03-30 20:29:38 DEBUG: pid 10623: key: health_check_timeout
> 2006-03-30 20:29:38 DEBUG: pid 10623: value: 20 kind: 2
> 2006-03-30 20:29:38 DEBUG: pid 10623: key: health_check_period
> 2006-03-30 20:29:38 DEBUG: pid 10623: value: 60 kind: 2
> 2006-03-30 20:29:38 DEBUG: pid 10623: key: health_check_user
> 2006-03-30 20:29:38 DEBUG: pid 10623: value: 'enterprisedb' kind: 4
> 2006-03-30 20:29:38 DEBUG: pid 10623: key: insert_lock
> 2006-03-30 20:29:38 DEBUG: pid 10623: value: false kind: 1
> 2006-03-30 20:29:38 DEBUG: pid 10623: key: ignore_leading_white_space
> 2006-03-30 20:29:38 DEBUG: pid 10623: value: true kind: 1
> 2006-03-30 20:29:38 DEBUG: pid 10623: weight: 1073741823
> 2006-03-30 20:29:38 DEBUG: pid 10624: I am 10624
> 2006-03-30 20:29:38 DEBUG: pid 10626: I am 10626
> 2006-03-30 20:29:38 DEBUG: pid 10627: I am 10627
> 2006-03-30 20:29:38 DEBUG: pid 10628: I am 10628
> 2006-03-30 20:29:38 DEBUG: pid 10625: I am 10625
> 2006-03-30 20:29:38 DEBUG: pid 10629: I am 10629
> 2006-03-30 20:29:38 DEBUG: pid 10630: I am 10630
> 2006-03-30 20:29:38 DEBUG: pid 10631: I am 10631
> 2006-03-30 20:29:38 DEBUG: pid 10632: I am 10632
> 2006-03-30 20:29:38 DEBUG: pid 10634: I am 10634
> 2006-03-30 20:29:38 DEBUG: pid 10635: I am 10635
> 2006-03-30 20:29:38 DEBUG: pid 10636: I am 10636
> 2006-03-30 20:29:38 DEBUG: pid 10633: I am 10633
> 2006-03-30 20:29:38 DEBUG: pid 10637: I am 10637
> 2006-03-30 20:29:38 DEBUG: pid 10638: I am 10638
> 2006-03-30 20:29:38 DEBUG: pid 10639: I am 10639
> 2006-03-30 20:29:39 DEBUG: pid 10640: I am 10640
> 2006-03-30 20:29:39 DEBUG: pid 10641: I am 10641
> 2006-03-30 20:29:39 DEBUG: pid 10642: I am 10642
> 2006-03-30 20:29:39 DEBUG: pid 10643: I am 10643
> 2006-03-30 20:29:39 DEBUG: pid 10644: I am 10644
> 2006-03-30 20:29:39 DEBUG: pid 10645: I am 10645
> 2006-03-30 20:29:39 DEBUG: pid 10646: I am 10646
> 2006-03-30 20:29:39 DEBUG: pid 10647: I am 10647
> 2006-03-30 20:29:39 DEBUG: pid 10648: I am 10648
> 2006-03-30 20:29:39 DEBUG: pid 10649: I am 10649
> 2006-03-30 20:29:39 DEBUG: pid 10650: I am 10650
> 2006-03-30 20:29:39 DEBUG: pid 10651: I am 10651
> 2006-03-30 20:29:39 DEBUG: pid 10652: I am 10652
> 2006-03-30 20:29:39 DEBUG: pid 10653: I am 10653
> 2006-03-30 20:29:39 DEBUG: pid 10654: I am 10654
> 2006-03-30 20:29:39 DEBUG: pid 10655: I am 10655
> 2006-03-30 20:29:39 LOG:   pid 10623: pgpool successfully started
> 2006-03-30 20:29:39 LOG:   pid 10623: starting health checking
> 2006-03-30 20:30:40 LOG:   pid 10623: starting health checking
> 2006-03-30 20:31:40 LOG:   pid 10623: starting health checking
> 2006-03-30 20:32:41 LOG:   pid 10623: starting health checking
> 2006-03-30 20:33:10 DEBUG: pid 10655: I am 10655 accept fd 6
> 2006-03-30 20:33:10 DEBUG: pid 10655: Protocol Major: 3 Minor: 0 database:
> edb_master user: enterprisedb
> 2006-03-30 20:33:11 DEBUG: pid 10655: pool_read_message_length: lenghth: 8
> 2006-03-30 20:33:11 ERROR: pid 10655: read_kind: kind does not match between
> backends master(83) secondary(69)
> 2006-03-30 20:33:11 ERROR: pid 10655: pool_do_auth: failed to read kind before
> backendkeydata
> 2006-03-30 20:33:42 LOG:   pid 10623: starting health checking
> 2006-03-30 20:34:44 LOG:   pid 10623: starting health checking
> 2006-03-30 20:35:45 LOG:   pid 10623: starting health checking
> 2006-03-30 20:36:45 LOG:   pid 10623: starting health checking
> 
> ***********************************************
> 
> -------------------------------------------------
> This mail sent through IMP: www.resolution.com
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general
>