On Fri, 2008-01-04 at 18:19 +0900, Yoshiyuki Asaba wrote: > I cannot reproduce it in my environment. > > % pgpool -n -d -f pgpool.conf &; sleep 5; psql -p 9999 -c 'select 1' > postgres > ... > DEBUG: pid 28641: select_load_balancing_node: selected backend id is 1 > ... > LOG: pid 28641: statement: select 1; *** select slave node *** > DEBUG: pid 28641: waiting for backend 0 completing the query > DEBUG: pid 28641: read_kind_from_backend: read kind from 0 th backend T > NUM_BACKENDS: 1 > DEBUG: pid 28641: pool_process_query: kind from backend: T > DEBUG: pid 28641: read_kind_from_backend: read kind from 0 th backend D > NUM_BACKENDS: 1 > DEBUG: pid 28641: pool_process_query: kind from backend: D > DEBUG: pid 28641: read_kind_from_backend: read kind from 0 th backend C > NUM_BACKENDS: 1 > DEBUG: pid 28641: pool_process_query: kind from backend: C > > Can you show us debug log?
pgpool -n -d -f /tmp/pgpool-test.conf 2>/tmp/log_pgpool >&1 psql -Uoperator -d hmxmms -h pgpool_server -c 'select 1' -p 9999 DEBUG: pid 11472: I am 11472 accept fd 6 DEBUG: pid 11472: Protocol Major: 1234 Minor: 5679 database: user: DEBUG: pid 11472: SSLRequest: sent N; retry startup DEBUG: pid 11472: Protocol Major: 3 Minor: 0 database: hmxmms user: operator DEBUG: pid 11472: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432 <-------- DEBUG: pid 11472: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7 <----- DEBUG: pid 11472: trying md5 authentication ERROR: pid 11472: pool_read: EOF encountered ERROR: pid 11472: do_md5_password: failed to read password packet "p" ERROR: pid 11472: pool_do_auth: backend does not return authenticaton ok DEBUG: pid 11472: I am 11472 accept fd 6 DEBUG: pid 11472: Protocol Major: 1234 Minor: 5679 database: user: DEBUG: pid 11472: SSLRequest: sent N; retry startup DEBUG: pid 11472: Protocol Major: 3 Minor: 0 database: hmxmms user: operator DEBUG: pid 11472: connecting postmaster Unix domain socket: /tmp/.s.PGSQL.5432 DEBUG: pid 11472: connected to postmaster Unix domain socket: /tmp/.s.PGSQL.5432 fd: 7 DEBUG: pid 11472: trying md5 authentication DEBUG: pid 11472: name: client_encoding value: SQL_ASCII DEBUG: pid 11472: name: DateStyle value: ISO, MDY DEBUG: pid 11472: name: integer_datetimes value: off DEBUG: pid 11472: name: is_superuser value: on DEBUG: pid 11472: name: server_encoding value: SQL_ASCII DEBUG: pid 11472: name: server_version value: 8.2.5 DEBUG: pid 11472: name: session_authorization value: operator DEBUG: pid 11472: name: standard_conforming_strings value: off DEBUG: pid 11472: name: TimeZone value: Asia/Kuala_Lumpur DEBUG: pid 11472: read kind from backend pending data Z len: 5 po: 287 DEBUG: pid 11472: ReadyForQuery: message length: 5 DEBUG: pid 11472: ReadyForQuery: transaction state: I DEBUG: pid 11472: read kind from frontend Q(51) DEBUG: pid 11472: Query: select 1 DEBUG: pid 11472: read kind from backend T DEBUG: pid 11472: read kind from backend pending data D len: 29 po: 34 DEBUG: pid 11472: read kind from backend pending data C len: 17 po: 46 DEBUG: pid 11472: read kind from backend pending data Z len: 5 po: 58 DEBUG: pid 11472: ReadyForQuery: message length: 5 DEBUG: pid 11472: ReadyForQuery: transaction state: I DEBUG: pid 11472: read kind from frontend X(58) DEBUG: pid 11472: Query: RESET ALL DEBUG: pid 11472: read kind from backend C DEBUG: pid 11472: read kind from backend pending data Z len: 5 po: 11 DEBUG: pid 11472: ReadyForQuery: message length: 5 DEBUG: pid 11472: ReadyForQuery: transaction state: I DEBUG: pid 11472: pool_connection_pool_timer: called Notice the Arrows, For some reason, it seems to talk to a domain socket. pgpool.conf replication_mode = false master_slave_mode = true load_balance_mode = true backend_hostname0 = 'pgmaster' backend_port0 = 5432 backend_weight0 = 0.2 backend_hostname1 = 'pgslave' backend_port1 = 5432 backend_weight1 = 0.8 /etc/hosts file is updated on the server to reflect the correct IP addresses. Many Thanks. _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
