[pgpool-general: 8123] Re: Pg_stat_activity hung queries issue
avi.raboah at gmail.com
Wed May 4 18:36:37 JST 2022
Any news about this thread?
On Mon, 25 Apr 2022 at 11:13 Avi Raboah <avi.raboah at gmail.com> wrote:
> It will be perfect thanks a lot!
> On Mon, 25 Apr 2022 at 10:47 Tatsuo Ishii <ishii at sraoss.co.jp> wrote:
>> > No, it doesn't.
>> > In that case when you make the select statement, piggy internal queries
>> > failed and the session rebooted
>> I see it now.
>> test=# begin;
>> test=*# insert into ttt values(1);
>> ERROR: relation "ttt" does not exist
>> LINE 1: insert into ttt values(1);
>> test=!# select * from t1;
>> FATAL: Backend throw an error message
>> DETAIL: Exiting current session because of an error from backend
>> HINT: BACKEND Error: "current transaction is aborted, commands ignored
>> until end of transaction block"
>> server closed the connection unexpectedly
>> This probably means the server terminated abnormally
>> before or while processing the request.
>> The connection to the server was lost. Attempting reset: Succeeded.
>> I think pgpool could remember that current transaction is in abort
>> status and does not issue the piggyback query when the selec is
>> issued. Let me see what we can do for this.
>> Best reagards,
>> Tatsuo Ishii
>> SRA OSS, Inc. Japan
>> English: http://www.sraoss.co.jp/index_en.php
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the pgpool-general