[pgpool-general: 4342] preferredTestQuery" value="SELECT 1" - error or notice message from backend

[Dan Sirbu]

Hi,

   I do have an app using hibernate & c3p0. In order to avoid the default c3p0 test query I set the following :

<property name="hibernate.c3p0.preferredTestQuery" value="SELECT 1"/>

   In the pgpool logs, I do see the following error:

2016-01-19 09:48:47: pid 7736: pname CHILD:LOG:  statement: SELECT 1
2016-01-19 09:48:47: pid 7736: pname CHILD:LOG:  DB node id: 1 backend pid: 14756 statement: SELECT 1
....
2016-01-19 09:49:16: pid 7721: pname CHILD:LOG:  statement: SELECT 1
2016-01-19 09:49:16: pid 7721: pname CHILD:LOG:  DB node id: 1 backend pid: 14865 statement: SELECT 1
....
2016-01-19 09:49:18: pid 7683: pname CHILD:LOG:  statement: SELECT 1
2016-01-19 09:49:18: pid 7683: pname CHILD:LOG:  DB node id: 1 backend pid: 14867 statement: SELECT 1
....
2016-01-19 09:49:21: pid 7704: pname CHILD:LOG:  DB node id: 1 backend pid: 14872 statement: Parse: SELECT 1
2016-01-19 09:49:21: pid 7704: pname CHILD:LOG:  pool_send_and_wait: Error or notice message from backend: : DB node id: 1 backend pid: 14872 statement: "SELECT 1" message: "current transaction is aborted, commands ignored until end of transaction block"
2016-01-19 09:49:21: pid 7704: pname CHILD:LOG:  Parse: Error or notice message from backend: : DB node id: 1 backend pid: 14872 statement: "SELECT 1" message: "current transaction is aborted, commands ignored until end of transaction block"
...

   My question is why this would fail or is it 'normal' ?!?
   From my searches on google it seems that for postgresql that is the preferred query. Is there another preferred test query ?!?

  I am using version: rpm -qa | grep pgpool
         pgpool-II-pg93-3.4.3-1pgdg.rhel6.x86_64

   Thx.

BR,
Dan S.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.sraoss.jp/pipermail/pgpool-general/attachments/20160119/c408d7ac/attachment.html>