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
