[pgpool-general: 4165] Re: ERROR: Cannot get bind message

[Tatsuo Ishii]

Probably this is the source of the problem:

> 2015-11-03 11:07:43 LOG:   pid 26314: statement: BEGIN;declare

pgpool-II does not support multi statement queries.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese:http://www.sraoss.co.jp

> Wea re just getting theses errors: CANNOT GET BIND MESSAGE with 1 new
> application software.
> Other software we are running is OK.
> 
> Pgpool 3.3.6 (replication mode but with only 1 active node)
> 
> 
> 
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: select oid, typbasetype
> from pg_type where typname = 'lo'
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: SET TIMEZONE TO 'UTC'
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: DEALLOCATE
> "_PLAN0000000004BB75C0"
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: DEALLOCATE
> "_PLAN0000000004BB75C0"
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: DEALLOCATE
> "_PLAN0000000004BB75C0"
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: DEALLOCATE
> "_PLAN0000000004BB75C0"
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: BEGIN
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: COMMIT
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: DEALLOCATE
> "_PLAN0000000004BB75C0"
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: DEALLOCATE
> "_PLAN0000000004BB75C0"
> 2015-11-03 11:07:43 LOG:   pid 26314: statement: BEGIN;declare
> "SQL_CUR0000000004D0C450" cursor for select relname, nspname, relkind from
> pg_catalog.pg_class c, pg_catalog.pg_namespace n where r$
> 2015-11-03 11:07:43 *ERROR: pid 26314: Execute: cannot get bind message*
> 2015-11-03 11:07:43 LOG:   pid 26314: do_child: exits with status 1 due to
> error
> 
> 
> 2015-11-03 11:07:43 LOG:   pid 26324: connection received:
> host=192.168.2.105 port=56244
> 2015-11-03 11:07:43 LOG:   pid 26324: statement: select oid, typbasetype
> from pg_type where typname = 'lo'
> 2015-11-03 11:07:43 LOG:   pid 26324: statement: SET TIMEZONE TO 'UTC'
> 2015-11-03 11:07:43 LOG:   pid 26324: statement: BEGIN;declare
> "SQL_CUR0000000004C879C0" cursor for select relname, nspname, relkind from
> pg_catalog.pg_class c, pg_catalog.pg_namespace n where r$
> 2015-11-03 11:07:43 *ERROR: pid 26324: Execute: cannot get bind message*
> 2015-11-03 11:07:43 LOG:   pid 26324: do_child: exits with status 1 due to
> error