Re: idle-in-transaction timeout error does not give a hint

2019-03-31 Thread Tatsuo Ishii
>>From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] >> >>> Personally, I don't find this hint particularly necessary. The >>> session was terminated because nothing was happening, so the real fix >>> on the application side is probably more involved than just retrying. >>> This is different from some

RE: idle-in-transaction timeout error does not give a hint

2019-03-31 Thread Ideriha, Takeshi
>From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] > >> Personally, I don't find this hint particularly necessary. The >> session was terminated because nothing was happening, so the real fix >> on the application side is probably more involved than just retrying. >> This is different from some of th

Re: idle-in-transaction timeout error does not give a hint

2019-03-29 Thread Tatsuo Ishii
> Personally, I don't find this hint particularly necessary. The session > was terminated because nothing was happening, so the real fix on the > application side is probably more involved than just retrying. This is > different from some of the other cases that were cited, such as > serializatio

Re: idle-in-transaction timeout error does not give a hint

2019-03-28 Thread Peter Eisentraut
On 2018-11-28 04:17, Tatsuo Ishii wrote: > + errmsg("terminating connection due to > idle-in-transaction timeout"), > + errhint("In a moment you should be > able to reconnect to the" > +

RE: idle-in-transaction timeout error does not give a hint

2019-02-14 Thread Jamison, Kirk
Hi, On Monday, February 4, 2019 2:15 AM +, Michael Paquier wrote: > On Tue, Dec 04, 2018 at 04:07:34AM +, Ideriha, Takeshi wrote: > > Sure. I didn't have a strong opinion about it, so it's ok. > From what I can see this is waiting input from a native English speaker, so > for now I have

Re: idle-in-transaction timeout error does not give a hint

2019-02-03 Thread Michael Paquier
On Tue, Dec 04, 2018 at 04:07:34AM +, Ideriha, Takeshi wrote: > Sure. I didn't have a strong opinion about it, so it's ok. From what I can see this is waiting input from a native English speaker, so for now I have moved this entry to next CF. -- Michael signature.asc Description: PGP signatu

RE: idle-in-transaction timeout error does not give a hint

2018-12-03 Thread Ideriha, Takeshi
>From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] >Subject: Re: idle-in-transaction timeout error does not give a hint > >>>>>>Alternative HINT message would be something like: >>>>>> >>>>>>HINT: In a moment you should be able to rec

Re: idle-in-transaction timeout error does not give a hint

2018-12-02 Thread Tatsuo Ishii
>Alternative HINT message would be something like: > >HINT: In a moment you should be able to reconnect to the > database and restart your transaction. > >This could make the meaning of the error (transaction aborted) >cleaner and might give a better suggestion to t

RE: idle-in-transaction timeout error does not give a hint

2018-12-02 Thread Ideriha, Takeshi
>From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] > >Hi Ideriha-san, > > Hi, it makes sense to me. One can submit transaction again same as > other cases you mentioned. > > I didn't attach the patch but according to my simple experiment in > psql the output would become the follow

Re: idle-in-transaction timeout error does not give a hint

2018-11-29 Thread Tatsuo Ishii
Hi, > Hello. > > At Thu, 29 Nov 2018 09:16:01 +0900 (JST), Tatsuo Ishii > wrote in <20181129.091601.830026250066724330.t-is...@sraoss.co.jp> >> >>> Hi, it makes sense to me. One can submit transaction again same as >> >>> other cases you mentioned. >> >>> >> >>> I didn't attach the patch but ac

Re: idle-in-transaction timeout error does not give a hint

2018-11-29 Thread Kyotaro HORIGUCHI
Hello. At Thu, 29 Nov 2018 09:16:01 +0900 (JST), Tatsuo Ishii wrote in <20181129.091601.830026250066724330.t-is...@sraoss.co.jp> > >>> Hi, it makes sense to me. One can submit transaction again same as > >>> other cases you mentioned. > >>> > >>> I didn't attach the patch but according to my sim

Re: idle-in-transaction timeout error does not give a hint

2018-11-29 Thread Tatsuo Ishii
Hi Ideriha-san, Hi, it makes sense to me. One can submit transaction again same as other cases you mentioned. I didn't attach the patch but according to my simple experiment in psql the output would become the following: FATAL: terminating connection due to idle

Re: idle-in-transaction timeout error does not give a hint

2018-11-28 Thread Tatsuo Ishii
>>> Hi, it makes sense to me. One can submit transaction again same as >>> other cases you mentioned. >>> >>> I didn't attach the patch but according to my simple experiment in >>> psql the output would become the following: >>> >>> FATAL: terminating connection due to idle-in-transaction timeout

RE: idle-in-transaction timeout error does not give a hint

2018-11-28 Thread Ideriha, Takeshi
>> Hi, it makes sense to me. One can submit transaction again same as >> other cases you mentioned. >> >> I didn't attach the patch but according to my simple experiment in >> psql the output would become the following: >> >> FATAL: terminating connection due to idle-in-transaction timeout >> HINT

Re: idle-in-transaction timeout error does not give a hint

2018-11-28 Thread Tatsuo Ishii
> Hi, it makes sense to me. One can submit transaction again same as other cases > you mentioned. > > I didn't attach the patch but according to my simple experiment > in psql the output would become the following: > > FATAL: terminating connection due to idle-in-transaction timeout > HINT: In

RE: idle-in-transaction timeout error does not give a hint

2018-11-27 Thread Ideriha, Takeshi
>From: Tatsuo Ishii [mailto:is...@sraoss.co.jp] >Sent: Wednesday, November 28, 2018 12:18 PM >To: pgsql-hackers@lists.postgresql.org >Subject: idle-in-transaction timeout error does not give a hint > >idle-in-transaction timeout error closed the session. I think in this case the >error >message sh