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