[pgpool-general: 8124] Re: Pg_stat_activity hung queries issue
ishii at sraoss.co.jp
Wed May 4 21:19:31 JST 2022
SRA OSS, Inc. Japan
> 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
More information about the pgpool-general