[pgpool-general: 1035] Re: query fails

[Tatsuo Ishii]

I guess there were previous errors which might be caused by pgpool
internal query and your transaction goes into abort mode. This could
happen if required functions such as pgpool_regclass has not been
properly installed. Please verify PostgreSQL log.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp

> I been getting error like this very often. if I make one select query and
> make a mistake in syntax I always get this. How do I fix such error ?
> 
>>[Error] Script lines: 1-2 --------------------------
>  ERROR: current transaction is aborted, commands ignored until end of
> transaction block
>  Line: 1 
> 
> 
> 
> here is my log:
> 
> Sep 20 19:11:10 pgpool pgpool[3399]: DB node id: 0 backend pid: 19894
> statement: Parse: select * from test where username='adfasdfas'
> Sep 20 19:11:10 pgpool pgpool[3399]: pool_send_and_wait: Error or notice
> message from backend: : DB node id: 0 backend pid: 19894 statement: select
> * from testp where username='adfasdfas' message: current transaction is
> aborted, commands ignored until end of transaction block
> Sep 20 19:11:10 pgpool pgpool[3399]: Parse: Error or notice message from
> backend: : DB node id: 0 backend pid: 19894 statement: select * from test
> where username='adfasdfas' message: current transaction is aborted,
> commands ignored until end of transaction block
> 
> 
> my pgool version
> 
> 3.1.4
> postgres version 9.1
> 
> One pgpool server with two postgres backend server