thats true, this problem only happens when I try to connect using "pgAdmin III 1.8",
It'a a problem with "pgAdmin III 1.8", with psql works fine. Can you report a bug for me ? Tatsuo Ishii wrote: > It seems you are using pgpool in master/slave mode. > > The query causing the trouble is a muti-statement one which is treated > as single one in pgpool: > > SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS > encoding, datlastsysoid > FROM pg_database WHERE oid = 16401 > > The query is using oids which are not guaranteed consistent between > master and slave DBs if you are using Slony-I. > > workaround: > > 1) Issue the query separetely. i.e. > > SET DateStyle=ISO; > SELECT oid, pg_encoding_to_char(encoding) AS > encoding, datlastsysoid > FROM pg_database WHERE oid = 16401; > > 2) Do not use queries using oids > -- > Tatsuo Ishii > SRA OSS, Inc. Japan > > >> anyone can help me ?: >> >> >> I am trying a load balance with 2 postgresql machines. >> >> postgresql version 8.33 >> >> >> >> >> [EMAIL PROTECTED] ~]# 2008-09-05 14:57:32 DEBUG: pid 5483: read kind >> from frontend Q(51) >> 2008-09-05 14:57:32 DEBUG: pid 5483: statement2: SELECT version(); >> 2008-09-05 14:57:32 DEBUG: pid 5483: waiting for backend 0 completing >> the query >> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind >> from 0 th backend T NUM_BACKENDS: 1 >> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from >> backend: T >> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind >> from 0 th backend D NUM_BACKENDS: 1 >> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from >> backend: D >> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind >> from 0 th backend C NUM_BACKENDS: 1 >> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from >> backend: C >> 2008-09-05 14:57:32 DEBUG: pid 5483: read_kind_from_backend: read kind >> from 0 th backend Z NUM_BACKENDS: 1 >> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_process_query: kind from >> backend: Z >> 2008-09-05 14:57:32 DEBUG: pid 5483: pool_read_message_length: slot: 0 >> length: 5 >> 2008-09-05 14:57:32 DEBUG: pid 5483: ReadyForQuery: message length: 5 >> 2008-09-05 14:57:32 DEBUG: pid 5483: ReadyForQuery: transaction state: I >> 2008-09-05 14:57:32 DEBUG: pid 5483: end_load_balance: end load balance mode >> 2008-09-05 14:57:52 DEBUG: pid 5482: I am 5482 accept fd 0 >> 2008-09-05 14:57:52 DEBUG: pid 5482: Protocol Major: 3 Minor: 0 >> database: db_master user: itamar >> 2008-09-05 14:57:52 DEBUG: pid 5482: new_connection: connecting 0 backend >> 2008-09-05 14:57:52 DEBUG: pid 5482: new_connection: connecting 1 backend >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 0 >> length: 8 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 1 >> length: 8 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 25 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 25 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: client_encoding >> value: UTF8 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: client_encoding >> value: UTF8 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 23 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 23 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: DateStyle >> value: ISO, MDY >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: DateStyle >> value: ISO, MDY >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 26 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 26 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: >> integer_datetimes value: off >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: >> integer_datetimes value: off >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 20 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 20 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: is_superuser >> value: on >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: is_superuser >> value: on >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 25 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 25 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: server_encoding >> value: UTF8 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: server_encoding >> value: UTF8 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 25 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 25 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: server_version >> value: 8.3.3 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: server_version >> value: 8.3.3 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 33 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 33 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: >> session_authorization value: itamar >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: >> session_authorization value: itamar >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 36 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 36 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: >> standard_conforming_strings value: off >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: >> standard_conforming_strings value: off >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 24 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 25 >> 2008-09-05 14:57:52 ERROR: pid 5482: pool_read_message_length2: message >> length (25) in slot 1 does not match with slot 0(24) >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: TimeZone value: >> US/Eastern >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: TimeZone value: >> Brazil/East >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 0 >> length: 12 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 1 >> length: 12 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_send_auth_ok: send pid 21303 >> to frontend >> 2008-09-05 14:57:52 DEBUG: pid 5482: select_load_balancing_node: >> selected backend id is 0 >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 0 th backend Z NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 1 th backend Z NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from >> backend: Z >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 0 >> length: 5 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length: slot: 1 >> length: 5 >> 2008-09-05 14:57:52 DEBUG: pid 5482: ReadyForQuery: message length: 5 >> 2008-09-05 14:57:52 DEBUG: pid 5482: ReadyForQuery: transaction state: I >> 2008-09-05 14:57:52 DEBUG: pid 5482: read kind from frontend Q(51) >> 2008-09-05 14:57:52 DEBUG: pid 5482: statement2: SET >> DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS encoding, >> datlastsysoid >> FROM pg_database WHERE oid = 16401 >> 2008-09-05 14:57:52 DEBUG: pid 5482: SimpleQuery: set master_slave_dml >> query: SET DateStyle=ISO;SELECT oid, pg_encoding_to_char(encoding) AS >> encoding, datlastsysoid >> FROM pg_database WHERE oid = 16401 >> 2008-09-05 14:57:52 DEBUG: pid 5482: waiting for backend 0 completing >> the query >> 2008-09-05 14:57:52 DEBUG: pid 5482: waiting for backend 1 completing >> the query >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 0 th backend S NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 1 th backend S NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from >> backend: S >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 0 length: 23 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_read_message_length2: master >> slot: 1 length: 23 >> 2008-09-05 14:57:52 DEBUG: pid 5482: 0 th backend: name: DateStyle >> value: ISO, MDY >> 2008-09-05 14:57:52 DEBUG: pid 5482: 1 th backend: name: DateStyle >> value: ISO, MDY >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 0 th backend C NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 1 th backend C NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from >> backend: C >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 0 th backend T NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 1 th backend T NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: pool_process_query: kind from >> backend: T >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 0 th backend D NUM_BACKENDS: 2 >> 2008-09-05 14:57:52 DEBUG: pid 5482: read_kind_from_backend: read kind >> from 1 th backend C NUM_BACKENDS: 2 >> *2008-09-05 14:57:52 ERROR: pid 5482: pool_process_query: 1 th kind C >> does not match with master connection kind D >> 2008-09-05 14:57:52 LOG: pid 5482: do_child: exits with status 1 due >> to error* >> 2008-09-05 14:57:52 DEBUG: pid 5475: reap_handler called >> 2008-09-05 14:57:52 DEBUG: pid 5475: reap_handler: call wait3 >> 2008-09-05 14:57:52 DEBUG: pid 5475: child 5482 exits with status 256 by >> signal 0 >> 2008-09-05 14:57:52 DEBUG: pid 5610: I am 5610 >> 2008-09-05 14:57:52 DEBUG: pid 5475: fork a new child pid 5610 >> 2008-09-05 14:57:52 DEBUG: pid 5475: reap_handler: normally exited >> >> >> _______________________________________________ >> Pgpool-general mailing list >> [email protected] >> http://pgfoundry.org/mailman/listinfo/pgpool-general >> > > > _______________________________________________ Pgpool-general mailing list [email protected] http://pgfoundry.org/mailman/listinfo/pgpool-general
