[pgpool-hackers: 557] Re: Possible bug not solved in pgpool 3.3.3

[Tatsuo Ishii]

No problem. I'm glad to hear that upgrading to 3.3.3 solved your problem.
Thanks for the report.

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

> Well sorry, the error seemed to be happening from a different server that uses the 3.3.2 version of pgpool. Person who upgraded all other servers seem to have missed this one. 
> Am extremely sorry for taking your time. Thanks for the reply though!
> 
> Regards, Preethi
> 
> On Jun 23, 2014, at 3:44 PM, Tatsuo Ishii <ishii at postgresql.org> wrote:
> 
>> I don't see "ERROR: unnamed prepared statement does not exist"
>> error. What's your problem?
>> 
>> Best regards,
>> --
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
>> Japanese:http://www.sraoss.co.jp
>> 
>>> Hi Tatsuo,
>>> 
>>> We use pgpool just for connection pooling,  by turning on log_statement the pgpool.log had,
>>> 
>>> Jun 23 10:58:58 app-3 pgpool[11082]: statement: set client_encoding to 'utf8'
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement: set client_encoding to 'utf8'
>>> Jun 23 10:58:58 app-3 pgpool[11082]: statement: SET bytea_output = 'escape'; SELECT oid FROM pg_type WHERE typname = 'bytea'
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement: SET bytea_output = 'escape'; SELECT oid FROM pg_type WHERE typname = 'bytea'
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement: Parse: SELECT name,value FROM mdl_config
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement: B message
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement: D message
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement: Execute: SELECT name,value FROM mdl_config
>>> Jun 23 10:58:58 app-3 pgpool[11082]: statement:  DISCARD ALL
>>> Jun 23 10:58:58 app-3 pgpool[11082]: DB node id: 0 backend pid: 10642 statement:  DISCARD ALL
>>> Jun 23 10:59:08 app-3 pgpool[11082]: connection received: host=localhost port=51333
>>> Jun 23 10:59:08 app-3 pgpool[11082]: statement: set client_encoding to ‘utf8'
>>> 
>>> 
>>> I’ve attached pgpool.conf along with this mail.
>