Postgres Pro
Downloads
Home   >   mailing lists

Re: Transaction timeout - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: Transaction timeout
Date
Msg-id 59B505DD-1931-49A3-9716-2DD7A002CCC6@yandex-team.ru
Whole thread Raw
In response to Re: Transaction timeout  ("Andrey M. Borodin" <x4mmm@yandex-team.ru>)
Responses Re: Transaction timeout
List pgsql-hackers
Tree view


On 3 Jan 2024, at 11:39, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:



On 1 Jan 2024, at 19:28, Andrey M. Borodin <x4mmm@yandex-team.ru> wrote:

 3. Check that timeout is not rescheduled by new queries (Nik's case)

The test of Nik's case was not stable enough together with COMMIT AND CHAIN. So I've separated these cases into different permutations.
Looking through CI logs it seems variation in sleeps and actual timeouts easily reach 30+ms. I'm not entirely sure we can reach 100% stable tests without too big timeouts.


Best regards, Andrey Borodin.

<v21-0001-Introduce-transaction_timeout.patch>
<v21-0002-Add-better-tests-for-transaction_timeout.patch>
<v21-0003-Try-to-enable-transaction_timeout-before-next-co.patch>
<v21-0004-fix-reschedule-timeout-for-each-commmand.patch>
 I do not understand why, but mailing list did not pick patches that I sent. I'll retry.

Best regards, Andrey Borodin.

Attachment

pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Random pg_upgrade test failure on drongo
Next
From: Andrew Dunstan
Date:
Subject: Re: WIP Incremental JSON Parser