[Pgpool-general] pgpool 2.2.4: DEALLOCATED children
Agustin Almonte Ferrada
aalmonte at antica.cl
Sat Sep 12 05:36:32 UTC 2009
Thanks Tatsuo for your reply.
The diferences between backends are just data. We are working with
pgpool 2.2.1 and some inserts/updates don't get to the second backend,
always is the second backend wich has less data, so we are trying now
with version 2.2.4.
Here is the filtered log output for a pid that gets into DEALLOCATE
state:
2009-09-12 00:44:31 DEBUG: pid 17759: I am 17759
2009-09-12 00:45:51 DEBUG: pid 17759: I am 17759 accept fd 5
2009-09-12 00:45:51 LOG: pid 17759: connection received:
host=127.0.0.1 port=44029
2009-09-12 00:45:51 DEBUG: pid 17759: Protocol Major: 3 Minor: 0
database: sess user: sess
2009-09-12 00:45:51 DEBUG: pid 17759: new_connection: connecting 0
backend
2009-09-12 00:45:51 DEBUG: pid 17759: new_connection: connecting 1
backend
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 8
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 8
2009-09-12 00:45:51 DEBUG: pid 17759: trying clear text password
authentication
2009-09-12 00:45:51 DEBUG: pid 17759: trying clear text password
authentication
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 28
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 28
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name:
client_encoding value: UNICODE
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name:
client_encoding value: UNICODE
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 23
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 23
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name: DateStyle
value: ISO, MDY
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name: DateStyle
value: ISO, MDY
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 25
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 25
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name:
integer_datetimes value: on
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name:
integer_datetimes value: on
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 21
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 21
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name: is_superuser
value: off
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name: is_superuser
value: off
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 25
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 25
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name:
server_encoding value: UTF8
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name:
server_encoding value: UTF8
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 26
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 26
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name:
server_version value: 8.1.15
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name:
server_version value: 8.1.15
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 31
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 31
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name:
session_authorization value: sess
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name:
session_authorization value: sess
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 36
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 36
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name:
standard_conforming_strings value: off
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name:
standard_conforming_strings value: off
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 0 length: 23
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length2:
master slot: 1 length: 23
2009-09-12 00:45:51 DEBUG: pid 17759: 0 th backend: name: TimeZone
value: localtime
2009-09-12 00:45:51 DEBUG: pid 17759: 1 th backend: name: TimeZone
value: localtime
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 12
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 12
2009-09-12 00:45:51 DEBUG: pid 17759: pool_send_auth_ok: send pid
26722 to frontend
2009-09-12 00:45:51 DEBUG: pid 17759: select_load_balancing_node:
selected backend id is 1
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend Z NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend Z NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: pool_process_query: kind from
backend: Z
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 5
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:45:51 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:45:51 DEBUG: pid 17759: ReadyForQuery: transaction
state: I
2009-09-12 00:45:51 DEBUG: pid 17759: read kind from frontend P(50)
2009-09-12 00:45:51 DEBUG: pid 17759: Parse: portal name <>
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 5
2009-09-12 00:45:51 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:45:51 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:45:51 DEBUG: pid 17759: ReadyForQuery: transaction
state: I
2009-09-12 00:45:51 DEBUG: pid 17759: waiting for master completing
the query
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: 1
2009-09-12 00:45:51 DEBUG: pid 17759: waiting for 1th backend
completing the query
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend 1 NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend 1 NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read kind from frontend B(42)
2009-09-12 00:45:51 DEBUG: pid 17759: bind message: portal_name
stmt_name
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend 2 NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend 2 NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read kind from frontend D(44)
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend T NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend T NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read kind from frontend E(45)
2009-09-12 00:45:51 DEBUG: pid 17759: Execute: portal name <>
2009-09-12 00:45:51 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 0 completing the query
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: D
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: D
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: D
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: D
2009-09-12 00:45:51 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 1 completing the query
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend D NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend D NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend C NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend C NUM_BACKENDS: 2
2009-09-12 00:45:51 DEBUG: pid 17759: read kind from frontend S(53)
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: Z
2009-09-12 00:45:51 DEBUG: pid 17759: detect_error: kind: Z
.
.
.
2009-09-12 00:45:56 DEBUG: pid 17759: Execute: portal name <>
2009-09-12 00:45:56 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 1 completing the query
2009-09-12 00:45:56 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend C NUM_BACKENDS: 2
2009-09-12 00:45:56 DEBUG: pid 17759: read kind from frontend S(53)
2009-09-12 00:45:56 DEBUG: pid 17759: detect_error: kind: Z
2009-09-12 00:45:56 DEBUG: pid 17759: detect_error: kind: Z
2009-09-12 00:45:56 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend Z NUM_BACKENDS: 2
2009-09-12 00:45:56 DEBUG: pid 17759: pool_process_query: kind from
backend: Z
2009-09-12 00:45:56 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:45:56 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:45:56 DEBUG: pid 17759: ReadyForQuery: transaction
state: I
2009-09-12 00:45:56 DEBUG: pid 17759: end_load_balance: end load
balance mode
2009-09-12 00:46:06 DEBUG: pid 17759: read kind from frontend P(50)
2009-09-12 00:46:06 DEBUG: pid 17759: Parse: portal name <>
2009-09-12 00:46:06 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 5
2009-09-12 00:46:06 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:46:06 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:46:06 DEBUG: pid 17759: ReadyForQuery: transaction
state: I
2009-09-12 00:46:06 DEBUG: pid 17759: waiting for master completing
the query
2009-09-12 00:46:06 DEBUG: pid 17759: detect_error: kind: 1
2009-09-12 00:46:06 DEBUG: pid 17759: waiting for 1th backend
completing the query
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend 1 NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend 1 NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read kind from frontend B(42)
2009-09-12 00:46:06 DEBUG: pid 17759: bind message: portal_name
stmt_name
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend 2 NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend 2 NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read kind from frontend D(44)
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend T NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend T NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read kind from frontend E(45)
2009-09-12 00:46:06 DEBUG: pid 17759: Execute: portal name <>
2009-09-12 00:46:06 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 1 completing the query
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend C NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: read kind from frontend S(53)
2009-09-12 00:46:06 DEBUG: pid 17759: detect_error: kind: Z
2009-09-12 00:46:06 DEBUG: pid 17759: detect_error: kind: Z
2009-09-12 00:46:06 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend Z NUM_BACKENDS: 2
2009-09-12 00:46:06 DEBUG: pid 17759: pool_process_query: kind from
backend: Z
2009-09-12 00:46:06 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:46:06 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:46:06 DEBUG: pid 17759: ReadyForQuery: transaction
state: I
2009-09-12 00:46:06 DEBUG: pid 17759: end_load_balance: end load
balance mode
2009-09-12 00:46:16 DEBUG: pid 17759: read kind from frontend P(50)
2009-09-12 00:46:16 DEBUG: pid 17759: Parse: portal name <>
2009-09-12 00:46:16 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: ReadyForQuery: transaction
state: I
2009-09-12 00:46:16 DEBUG: pid 17759: waiting for master completing
the query
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: 1
2009-09-12 00:46:16 DEBUG: pid 17759: waiting for 1th backend
completing the query
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend 1 NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend 1 NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read kind from frontend B(42)
2009-09-12 00:46:16 DEBUG: pid 17759: bind message: portal_name
stmt_name
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend 2 NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend 2 NUM_BACKENDS: 2
2009-09-12 00:46:16 ERROR: pid 17759: pool_flush_it: write failed
(Broken pipe) offset: 0 wlen: 5
2009-09-12 00:46:16 DEBUG: pid 17759: read kind from frontend D(44)
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend T NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend T NUM_BACKENDS: 2
2009-09-12 00:46:16 ERROR: pid 17759: pool_flush_it: write failed
(Broken pipe) offset: 0 wlen: 149
2009-09-12 00:46:16 DEBUG: pid 17759: read kind from frontend E(45)
2009-09-12 00:46:16 DEBUG: pid 17759: Execute: portal name <>
2009-09-12 00:46:16 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 1 completing the query
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend C NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read kind from frontend S(53)
2009-09-12 00:46:16 DEBUG: pid 17759: read kind from frontend X(58)
2009-09-12 00:46:16 LOG: pid 17759: statement: RESET ALL
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: Query: BEGIN
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: Z
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: transaction state: T
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: Query: BEGIN
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: Z
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: Z
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: transaction state: I
2009-09-12 00:46:16 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 0 completing the query
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: wait_for_query_response: waiting
for backend 1 completing the query
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend C NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend C NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: pool_process_query: kind from
backend: C
2009-09-12 00:46:16 ERROR: pid 17759: pool_flush_it: write failed
(Broken pipe) offset: 0 wlen: 12
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 0 th backend Z NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: read_kind_from_backend: read
kind from 1 th backend Z NUM_BACKENDS: 2
2009-09-12 00:46:16 DEBUG: pid 17759: pool_process_query: kind from
backend: Z
2009-09-12 00:46:16 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: ReadyForQuery: transaction
state: T
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: Query: COMMIT
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: Z
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: Query: COMMIT
2009-09-12 00:46:16 DEBUG: pid 17759: detect_error: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: C
2009-09-12 00:46:16 DEBUG: pid 17759: do_command: kind: Z
2009-09-12 00:46:16 DEBUG: pid 17759: pool_read_message_length: slot:
0 length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: pool_read_message_length: slot:
1 length: 5
2009-09-12 00:46:16 DEBUG: pid 17759: ReadyForQuery: message length: 5
2009-09-12 00:46:16 ERROR: pid 17759: pool_read_kind: kind does not
match between master(73) slot[1] (84)
2009-09-12 00:46:16 DEBUG: pid 17759: error in resetting connections.
discarding connection pools...
2009-09-12 00:46:16 DEBUG: pid 17759: I am 17759 accept fd 5
2009-09-12 00:46:16 LOG: pid 17759: connection received:
host=127.0.0.1 port=51447
2009-09-12 00:46:16 DEBUG: pid 17759: Protocol Major: 3 Minor: 0
database: sess user: sess
2009-09-12 00:46:16 DEBUG: pid 17759: new_connection: connecting 0
backend
2009-09-12 00:46:16 DEBUG: pid 17759: new_connection: connecting 1
backend
Agustín Almonte F.
El 11-09-2009, a las 22:06, Tatsuo Ishii escribió:
> My guess is DEALLOCATE is being issued at end of session between
> pgpool and PostgreSQL. For some reason PostgreSQL returns weired
> packet kind 0x73 on node 0 and 0x84 on node 1.
>
> Anyway, I need more information.
>
> Do you find some errors in PostgreSQL log? What kind of difference are
> there in your databases?
> --
> Tatsuo Ishii
> SRA OSS, Inc. Japan
>
>> Hi,
>>
>> I'm testing pgpool 2.2.4 with some problems.... i hope someone can
>> help me to figure out what the problem is.
>>
>>
>> I have two backends that unfortunately have diferences, that's the
>> initial scenario when i started pgpool, everything goes well for some
>> seconds but after a while a lot of error come out:
>>
>> (filtered output)
>> 2009-09-11 02:19:03 ERROR: pid 28468: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 12
>> 2009-09-11 02:19:03 ERROR: pid 27857: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 12
>> 2009-09-11 02:19:03 ERROR: pid 27857: pool_read_kind: kind does not
>> match between master(73) slot[1] (84)
>> 2009-09-11 02:19:03 ERROR: pid 28235: pool_read_kind: kind does not
>> match between master(84) slot[1] (73)
>> 2009-09-11 02:19:03 ERROR: pid 28414: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 12
>> 2009-09-11 02:19:03 ERROR: pid 27866: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 12
>> 2009-09-11 02:19:03 ERROR: pid 28414: pool_read_kind: kind does not
>> match between master(73) slot[1] (84)
>> 2009-09-11 02:19:03 ERROR: pid 28310: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 12
>> 2009-09-11 02:19:03 ERROR: pid 28469: pool_read_kind: kind does not
>> match between master(73) slot[1] (84)
>> 2009-09-11 02:19:03 ERROR: pid 28419: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 5
>> 2009-09-11 02:19:03 ERROR: pid 28419: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 149
>> 2009-09-11 02:19:03 ERROR: pid 27866: pool_read_kind: kind does not
>> match between master(84) slot[1] (73)
>> 2009-09-11 02:19:03 ERROR: pid 28310: pool_read_kind: kind does not
>> match between master(84) slot[1] (73)
>> 2009-09-11 02:19:03 ERROR: pid 28221: pool_flush_it: write failed
>> (Broken pipe) offset: 0 wlen: 5
>>
>> pgpool processes go from:
>>
>> root 28166 27814 0 02:13 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28167 27814 0 02:13 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28169 27814 6 02:13 ? 00:00:10 pgpool: sess sess
>> 127.0.0.1(43911) DEALLOCATE
>> root 28170 27814 0 02:13 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28174 27814 0 02:13 ? 00:00:00 pgpool: sess sess
>> 127.0.0.1(35292) idle
>> root 28178 27814 1 02:13 ? 00:00:02 pgpool: sess sess
>> 127.0.0.1(44647) DEALLOCATE
>> root 28179 27814 1 02:13 ? 00:00:02 pgpool: sess sess
>> 127.0.0.1(47125) DEALLOCATE
>> root 28181 27814 0 02:13 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28182 27814 0 02:13 ? 00:00:00 pgpool: sess sess
>> 127.0.0.1(52477) idle
>> root 28187 27814 0 02:13 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28193 27814 0 02:14 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28194 27814 0 02:14 ? 00:00:00 pgpool: wait for
>> connection request
>> root 28195 27814 0 02:14 ? 00:00:00 pgpool: wait for
>> connection request
>>
>>
>> to:
>>
>> root 27853 27814 0 02:11 ? 00:00:01 pgpool: sess sess
>> 127.0.0.1(58341) DEALLOCATE
>> root 27887 27814 7 02:11 ? 00:00:21 pgpool: sess sess
>> 127.0.0.1(49142) DEALLOCATE
>> root 27897 27814 4 02:11 ? 00:00:14 pgpool: sess sess
>> 127.0.0.1(58998) DEALLOCATE
>> root 27922 27814 5 02:11 ? 00:00:16 pgpool: sess sess
>> 127.0.0.1(49541) DEALLOCATE
>> root 27923 27814 11 02:11 ? 00:00:34 pgpool: sess sess
>> 127.0.0.1(36883) DEALLOCATE
>> root 27933 27814 7 02:11 ? 00:00:21 pgpool: sess sess
>> 127.0.0.1(42722) DEALLOCATE
>> root 27937 27814 7 02:11 ? 00:00:22 pgpool: sess sess
>> 127.0.0.1(52656) DEALLOCATE
>> root 27939 27814 3 02:11 ? 00:00:10 pgpool: sess sess
>> 127.0.0.1(47648) DEALLOCATE
>> root 27947 27814 11 02:11 ? 00:00:35 pgpool: sess sess
>> 127.0.0.1(44597) DEALLOCATE
>> root 27952 27814 5 02:11 ? 00:00:16 pgpool: sess sess
>> 127.0.0.1(57546) DEALLOCATE
>> root 27954 27814 11 02:11 ? 00:00:34 pgpool: sess sess
>> 127.0.0.1(50946) DEALLOCATE
>> root 28155 27814 2 02:12 ? 00:00:04 pgpool: sess sess
>> 127.0.0.1(47095) DEALLOCATE
>> root 28159 27814 0 02:13 ? 00:00:00 pgpool: sess sess
>> 127.0.0.1(52691) DEALLOCATE
>> root 28163 27814 6 02:13 ? 00:00:10 pgpool: sess sess
>> 127.0.0.1(56219) DEALLOCATE
>> root 28169 27814 6 02:13 ? 00:00:11 pgpool: sess sess
>> 127.0.0.1(43911) DEALLOCATE
>> root 28178 27814 1 02:13 ? 00:00:02 pgpool: sess sess
>> 127.0.0.1(44647) DEALLOCATE
>>
>>
>> And then everything stop working....
>>
>>
>> Is this a normal behaviour when backends are diferents? What can be
>> the reason for children going to DEALLOCATE state?
>>
>>
>> Thanks in Advance
>> Agustín Almonte F.
>>
>>
>>
>>
>>
>> _______________________________________________
>> Pgpool-general mailing list
>> Pgpool-general at pgfoundry.org
>> http://pgfoundry.org/mailman/listinfo/pgpool-general
More information about the Pgpool-general
mailing list