[Pgpool-general] "server closed the connection unexpectedly" on sql syntax errors

asaf at lingnu.com asaf at lingnu.com
Wed Feb 17 20:25:24 UTC 2010


running pgpool-II (2.3.2), replication mode with 2 backends

when running  select * from testtable;
and the table does not exist, instead of getting:

"ERROR:  relation "testtable" does not exist"

i'm getting:

 "server closed the connection unexpectedly
        This probably means the server terminated abnormally
        before or while processing the request."
The connection to the server was lost. Attempting reset: Succeeded.

apart from that, everything works ok

pgpool log:

2010-02-17 15:18:03 DEBUG: pid 18730: read kind from frontend Q(51)
2010-02-17 15:18:03 DEBUG: pid 18730: statement2: select * from testtable;
2010-02-17 15:18:03 DEBUG: pid 18730: wait_for_query_response: waiting for
backend 0 completing the query
2010-02-17 15:18:03 LOG:   pid 18730: SimpleQuery: Error or notice message
from backend: : DB node id: 0 backend pid: 18731 statement: select * from
testtable; message: relation "testtable" does not exist
2010-02-17 15:18:03 DEBUG: pid 18730: read_kind_from_backend: read kind
from 0 th backend  NUM_BACKENDS: 1
2010-02-17 15:18:03 ERROR: pid 18730: pool_process_query: kind is 0!
2010-02-17 15:18:03 LOG:   pid 18730: do_child: exits with status 1 due to
error
2010-02-17 15:18:03 DEBUG: pid 18563: reap_handler called
2010-02-17 15:18:03 DEBUG: pid 18563: reap_handler: call wait3
2010-02-17 15:18:03 DEBUG: pid 18563: child 18730 exits with status 256
2010-02-17 15:18:03 DEBUG: pid 18812: I am 18812
2010-02-17 15:18:03 DEBUG: pid 18563: fork a new child pid 18812
2010-02-17 15:18:03 DEBUG: pid 18563: reap_handler: normally exited
2010-02-17 15:18:06 DEBUG: pid 18812: I am 18812 accept fd 5
2010-02-17 15:18:06 DEBUG: pid 18812: Protocol Major: 3 Minor: 0 database:
spy user: postgres
2010-02-17 15:18:06 DEBUG: pid 18812: new_connection: connecting 0 backend
2010-02-17 15:18:06 DEBUG: pid 18812: new_connection: connecting 1 backend
2010-02-17 15:18:06 DEBUG: pid 18812: pool_ssl: SSL requested but SSL
support is not available
2010-02-17 15:18:06 DEBUG: pid 18812: pool_ssl: SSL requested but SSL
support is not available
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length: slot: 0
length: 8
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length: slot: 1
length: 8
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 0 length: 25
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 1 length: 25
2010-02-17 15:18:06 DEBUG: pid 18812: 0 th backend: name: client_encoding
value: UTF8
2010-02-17 15:18:06 DEBUG: pid 18812: 1 th backend: name: client_encoding
value: UTF8
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 0 length: 23
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 1 length: 23
2010-02-17 15:18:06 DEBUG: pid 18812: 0 th backend: name: DateStyle value:
ISO, MDY
2010-02-17 15:18:06 DEBUG: pid 18812: 1 th backend: name: DateStyle value:
ISO, MDY
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 0 length: 26
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 1 length: 26
2010-02-17 15:18:06 DEBUG: pid 18812: 0 th backend: name:
integer_datetimes value: off
2010-02-17 15:18:06 DEBUG: pid 18812: 1 th backend: name:
integer_datetimes value: off
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 0 length: 20
2010-02-17 15:18:06 DEBUG: pid 18812: pool_read_message_length2: master
slot: 1 length: 20






More information about the Pgpool-general mailing list