[Pgpool-general] Bug report pgpool-II-2.3.1 plus ODBC

[Tatsuo Ishii]

I'm not familiar with unixODBC, but I guess it uses older protocol
(version 2) right? If so, it might be a source of the problem. I will
look into this.
--
Tatsuo Ishii
SRA OSS, Inc. Japan

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