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

[Tatsuo Ishii]

This has been fixed in 2.3.2.1.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> 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
> 
> 
> 
> 
> _______________________________________________
> Pgpool-general mailing list
> Pgpool-general at pgfoundry.org
> http://pgfoundry.org/mailman/listinfo/pgpool-general