[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