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

[Tatsuo Ishii]

Hi,

Toshihiro Kitagawa fix the problem. I have committed the changes into
CVS Head. Please try it out.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

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