Re: xid_wraparound tests intermittent failure.

On Tue, Jul 30, 2024 at 3:29 AM Andrew Dunstan wrote: > > > On 2024-07-29 Mo 5:25 PM, Masahiko Sawada wrote: > > I've attached the patch. Could you please test if the patch fixes the > instability you observed? > > Since we turn off autovacuum on all three tests and we wait for > autovacuum to com

Re: xid_wraparound tests intermittent failure.

On 2024-07-29 Mo 5:25 PM, Masahiko Sawada wrote: I've attached the patch. Could you please test if the patch fixes the instability you observed? Since we turn off autovacuum on all three tests and we wait for autovacuum to complete processing databases, these tests potentially have a similar (b

Re: xid_wraparound tests intermittent failure.

On Sat, Jul 27, 2024 at 1:06 PM Andrew Dunstan wrote: > > > On 2024-07-26 Fr 1:46 PM, Masahiko Sawada wrote: > > On Thu, Jul 25, 2024 at 6:52 PM Andrew Dunstan wrote: > >> > >> On 2024-07-25 Th 3:40 PM, Masahiko Sawada wrote: > >> > >> On Thu, Jul 25, 2024 at 11:06 AM Masahiko Sawada > >> wrote

Re: xid_wraparound tests intermittent failure.

On 2024-07-26 Fr 1:46 PM, Masahiko Sawada wrote: On Thu, Jul 25, 2024 at 6:52 PM Andrew Dunstan wrote: On 2024-07-25 Th 3:40 PM, Masahiko Sawada wrote: On Thu, Jul 25, 2024 at 11:06 AM Masahiko Sawada wrote: On Thu, Jul 25, 2024 at 10:56 AM Andrew Dunstan wrote: On 2024-07-23 Tu 6:59 PM,

Re: xid_wraparound tests intermittent failure.

On Thu, Jul 25, 2024 at 6:52 PM Andrew Dunstan wrote: > > > On 2024-07-25 Th 3:40 PM, Masahiko Sawada wrote: > > On Thu, Jul 25, 2024 at 11:06 AM Masahiko Sawada > wrote: > > On Thu, Jul 25, 2024 at 10:56 AM Andrew Dunstan wrote: > > On 2024-07-23 Tu 6:59 PM, Masahiko Sawada wrote: > > See > <

Re: xid_wraparound tests intermittent failure.

On 2024-07-25 Th 3:40 PM, Masahiko Sawada wrote: On Thu, Jul 25, 2024 at 11:06 AM Masahiko Sawada wrote: On Thu, Jul 25, 2024 at 10:56 AM Andrew Dunstan wrote: On 2024-07-23 Tu 6:59 PM, Masahiko Sawada wrote: See

Re: xid_wraparound tests intermittent failure.

On Thu, Jul 25, 2024 at 11:06 AM Masahiko Sawada wrote: > > On Thu, Jul 25, 2024 at 10:56 AM Andrew Dunstan wrote: > > > > > > On 2024-07-23 Tu 6:59 PM, Masahiko Sawada wrote: > > > > See > > > > > > > > The fai

Re: xid_wraparound tests intermittent failure.

On Thu, Jul 25, 2024 at 10:56 AM Andrew Dunstan wrote: > > > On 2024-07-23 Tu 6:59 PM, Masahiko Sawada wrote: > > See > > > > The failure logs are from a run where both tests 1 and 2 failed. > > Thank you for sha

Re: xid_wraparound tests intermittent failure.

On 2024-07-23 Tu 6:59 PM, Masahiko Sawada wrote: See The failure logs are from a run where both tests 1 and 2 failed. Thank you for sharing the logs. I think that the problem seems to match what Alexander La

Re: xid_wraparound tests intermittent failure.

On Tue, Jul 23, 2024 at 3:49 AM Andrew Dunstan wrote: > > > On 2024-07-22 Mo 9:29 PM, Masahiko Sawada wrote: > > On Mon, Jul 22, 2024 at 12:53 PM Andrew Dunstan wrote: > > On 2024-07-22 Mo 12:46 PM, Tom Lane wrote: > > Masahiko Sawada writes: > > Looking at dodo's failures, it seems that while i

Re: xid_wraparound tests intermittent failure.

On 2024-07-22 Mo 10:11 PM, Tom Lane wrote: Andrew Dunstan writes: On 2024-07-22 Mo 12:46 PM, Tom Lane wrote: Masahiko Sawada writes: Looking at dodo's failures, it seems that while it passes module-xid_wraparound-check, all failures happened only during testmodules-install-check-C. Can we

Re: xid_wraparound tests intermittent failure.

On 2024-07-22 Mo 9:29 PM, Masahiko Sawada wrote: On Mon, Jul 22, 2024 at 12:53 PM Andrew Dunstan wrote: On 2024-07-22 Mo 12:46 PM, Tom Lane wrote: Masahiko Sawada writes: Looking at dodo's failures, it seems that while it passes module-xid_wraparound-check, all failures happened only durin

Re: xid_wraparound tests intermittent failure.

Andrew Dunstan writes: > On 2024-07-22 Mo 12:46 PM, Tom Lane wrote: >> Masahiko Sawada writes: >>> Looking at dodo's failures, it seems that while it passes >>> module-xid_wraparound-check, all failures happened only during >>> testmodules-install-check-C. Can we check the server logs written >>>

Re: xid_wraparound tests intermittent failure.

On Mon, Jul 22, 2024 at 12:53 PM Andrew Dunstan wrote: > > > On 2024-07-22 Mo 12:46 PM, Tom Lane wrote: > > Masahiko Sawada writes: > > Looking at dodo's failures, it seems that while it passes > module-xid_wraparound-check, all failures happened only during > testmodules-install-check-C. Can we

Re: xid_wraparound tests intermittent failure.

On 2024-07-22 Mo 12:46 PM, Tom Lane wrote: Masahiko Sawada writes: Looking at dodo's failures, it seems that while it passes module-xid_wraparound-check, all failures happened only during testmodules-install-check-C. Can we check the server logs written during xid_wraparound test in testmodule

Re: xid_wraparound tests intermittent failure.

On Mon, Jul 22, 2024 at 9:46 AM Tom Lane wrote: > > Masahiko Sawada writes: > > Looking at dodo's failures, it seems that while it passes > > module-xid_wraparound-check, all failures happened only during > > testmodules-install-check-C. Can we check the server logs written > > during xid_wraparo

Re: xid_wraparound tests intermittent failure.

Masahiko Sawada writes: > Looking at dodo's failures, it seems that while it passes > module-xid_wraparound-check, all failures happened only during > testmodules-install-check-C. Can we check the server logs written > during xid_wraparound test in testmodules-install-check-C? Oooh, that is indee

Re: xid_wraparound tests intermittent failure.

On Sun, Jul 21, 2024 at 2:36 PM Tom Lane wrote: > > Andrew Dunstan writes: > > On 2024-07-21 Su 1:34 PM, Tom Lane wrote: > >> Locally, I've not managed to reproduce the failure yet; so perhaps > >> there is some platform dependency. What are you testing on? > > > Linux ub22arm 5.15.0-116-generic

Re: xid_wraparound tests intermittent failure.

On Sun, Jul 21, 2024 at 7:28 PM Thomas Munro wrote: > On Mon, Jul 22, 2024 at 8:08 AM Alexander Lakhin wrote: > > https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures > > This is great. Thanks for collating all this info here! And of > course all the research and reports behind it. W

Re: xid_wraparound tests intermittent failure.

On 2024-07-21 Su 4:08 PM, Alexander Lakhin wrote: Hello, 21.07.2024 20:34, Tom Lane wrote: Andrew Dunstan writes: I noticed this when working on the PostgreSQL::Test::Session project I have in hand. All the tests pass except occasionally the xid_wraparound tests fail. It's not always the sa

Re: xid_wraparound tests intermittent failure.

On Mon, Jul 22, 2024 at 8:08 AM Alexander Lakhin wrote: > https://wiki.postgresql.org/wiki/Known_Buildfarm_Test_Failures This is great. Thanks for collating all this info here! And of course all the research and reports behind it.

Re: xid_wraparound tests intermittent failure.

Andrew Dunstan writes: > On 2024-07-21 Su 1:34 PM, Tom Lane wrote: >> Locally, I've not managed to reproduce the failure yet; so perhaps >> there is some platform dependency. What are you testing on? > Linux ub22arm 5.15.0-116-generic #126-Ubuntu SMP Mon Jul 1 10:08:40 UTC > 2024 aarch64 aarch6

Re: xid_wraparound tests intermittent failure.

Hello, 21.07.2024 20:34, Tom Lane wrote: Andrew Dunstan writes: I noticed this when working on the PostgreSQL::Test::Session project I have in hand. All the tests pass except occasionally the xid_wraparound tests fail. It's not always the same test script that fails either. I tried everything

Re: xid_wraparound tests intermittent failure.

On 2024-07-21 Su 1:34 PM, Tom Lane wrote: Andrew Dunstan writes: I noticed this when working on the PostgreSQL::Test::Session project I have in hand. All the tests pass except occasionally the xid_wraparound tests fail. It's not always the same test script that fails either. I tried everythin

Re: xid_wraparound tests intermittent failure.

Andrew Dunstan writes: > I noticed this when working on the PostgreSQL::Test::Session project I > have in hand. All the tests pass except occasionally the xid_wraparound > tests fail. It's not always the same test script that fails either. I > tried everything but couldn't make the failure stop

xid_wraparound tests intermittent failure.

I noticed this when working on the PostgreSQL::Test::Session project I have in hand. All the tests pass except occasionally the xid_wraparound tests fail. It's not always the same test script that fails either. I tried everything but couldn't make the failure stop. So then I switched out my