[Pgpool-general] Bug report pgpool-II-2.3.1 plus ODBC
Bill W
pgpool at aastral.net
Tue Jan 12 17:46:35 UTC 2010
Hello Tatsuo,
I've been using 2.2.6 on openSUSE 11.2 (i586) with
postgresql-server-8.4.1-2.1.i586 and unixODBC-2.2.12-199.4.i586, and
it's been working successfully.
I have applications connecting to pgpool through odbc. So the flow is
application -> odbc -> pgpool -> postgresql.
I recently upgraded to pgpool-II-2.3.1 and now this arrangement fails.
I downgraded to 2.2.6 and things started working again, so a bug must
have crept in somewhere.
Here is the debug output:
2010-01-12 12:41:49 DEBUG: pid 32132: read kind from frontend Q(51)
2010-01-12 12:41:49 DEBUG: pid 32132: pool_read_string: read all from
pending data. po:0 len:0
2010-01-12 12:41:49 LOG: pid 32132: statement: insert into
sip_authentication (nonce,expires,profile_name,hostname, last_nc)
values('b54199a6-c62e-46ee-b18c-cb6fa92597e1', 1263316044, 'external',
'test', 0);
2010-01-12 12:41:49 DEBUG: pid 32132: do_command: Query: BEGIN
2010-01-12 12:41:49 DEBUG: pid 32132: wait_for_query_response: waiting
for backend 0 completing the query
2010-01-12 12:41:49 DEBUG: pid 32132: detect_error: kind: C
2010-01-12 12:41:49 DEBUG: pid 32132: do_command: kind: C
2010-01-12 12:41:49 DEBUG: pid 32132: pool_read_string: read all from
pending data. po:7 len:1
2010-01-12 12:41:49 DEBUG: pid 32132: do_command: kind: Z
2010-01-12 12:41:49 DEBUG: pid 32132: do_query: kind: I
2010-01-12 12:41:49 ERROR: pid 32132: pool_read2: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: do_query: error while reading rest
of message
2010-01-12 12:41:49 ERROR: pid 32132: pool_search_relcache: do_query failed
2010-01-12 12:41:49 DEBUG: pid 32132: wait_for_query_response: waiting
for backend 0 completing the query
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: pool_read: EOF encountered with
backend
2010-01-12 12:41:49 ERROR: pid 32132: read_kind_from_backend: failed to
read kind from 0 th backend
2010-01-12 12:41:49 LOG: pid 32132: do_child: exits with status 1 due
to error
2010-01-12 12:41:49 ERROR: pid 32132: pool_flush_it: write failed to
backend (0). reason: Broken pipe offset: 0 wlen: 1
2010-01-12 12:41:49 DEBUG: pid 32113: reap_handler called
2010-01-12 12:41:49 DEBUG: pid 32113: reap_handler: call wait3
2010-01-12 12:41:49 DEBUG: pid 32113: child 32132 exits with status 256
2010-01-12 12:41:49 DEBUG: pid 32113: fork a new child pid 32392
2010-01-12 12:41:49 DEBUG: pid 32392: I am 32392
2010-01-12 12:41:49 DEBUG: pid 32113: reap_handler: normally exited
ISQL returns:
[ISQL]ERROR: Could not SQLExecute
Postgres log is:
2010-01-12 12:46:01 EST fs_sofia sofia LOG: statement: BEGIN
2010-01-12 12:46:01 EST fs_sofia sofia LOG: duration: 0.134 ms
2010-01-12 12:46:01 EST fs_sofia sofia LOG: statement:
2010-01-12 12:46:01 EST fs_sofia sofia LOG: duration: 0.047 ms
2010-01-12 12:46:01 EST fs_sofia sofia FATAL: invalid frontend message
type 0
Any ideas?
Thanks!
Bill
More information about the Pgpool-general
mailing list