[pgpool-general: 2388] Re: Error when use pgpool2 with JDBC

[Tatsuo Ishii]

Denis,

>>   I currently have no test-bed with a running pgpool, but maybe you
>> could create a simple test case: open a JDBC connection (no polling,
>> no protocol specified, straight JDBC) to the pgpool, and observe the
>> log files on both back-ends. Tatsuo Ishii noted, that the pgpool
>> status shows that both back-ends behave differently when the SET is
>> executed. There might be something there.
>>
> 
> The two servers are configured with the same parameters, except fot
> replication of course, and wal archiving, not activated on slave. Is it
> possible that the problem come from ?

I don't think so.

Can you show me PostgreSQL log when you face the problem? There must
be a notice message in the log because pgpool-II detects notice
("N"). I think the key to solve the problem is the content of the
message.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp