Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-26 Thread Alexander Lakhin
Hello Kuroda-san and Takatsuka-san, 24.07.2025 03:49, TAKATSUKA Haruka wrote: {snip} Maybe you could try tools.syncTime = "0" by any chance? It has been already tools.syncTime = "0" so far. I confirmed the following GUI setting. ... 23.07.2025 09:15, Hayato Kuroda (Fujitsu) wrote: It looks

Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-23 Thread TAKATSUKA Haruka
On Wed, 23 Jul 2025 23:00:00 +0300 Alexander Lakhin wrote: {snip} > >>> Nagata-san, could you please share the configuration of hamerkop? If it's > >>> running inside VM, what virtualization software is used? > > It's vmware ESXi 7.0.3 (21930508). > > This Windows enable auto-synchronize with '

Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-23 Thread Alexander Lakhin
Hello Takatsuka-san, 23.07.2025 08:48, TAKATSUKA Haruka wrote: Hello Alexander, On Wed, 23 Jul 2025 00:55:37 + Yugo Nagata - Buildfarm wrote: Nagata-san, could you please share the configuration of hamerkop? If it's running inside VM, what virtualization software is used? It's vmware ESX

RE: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-22 Thread Hayato Kuroda (Fujitsu)
Dear Alexander, > And here it is [1]: > diff --strip-trailing-cr -U3 > c:/build-farm-local/buildroot/HEAD/pgsql/src/test/isolation/expected/stats.ou > t > c:/build-farm-local/buildroot/HEAD/pgsql.build/testrun/isolation/isolation/res > ults/stats.out > --- > c:/build-farm-local/buildroot/HEAD/pgsq

Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-22 Thread TAKATSUKA Haruka
Hello Alexander, On Wed, 23 Jul 2025 00:55:37 + Yugo Nagata - Buildfarm wrote: > > Nagata-san, could you please share the configuration of hamerkop? If it's > > running inside VM, what virtualization software is used? It's vmware ESXi 7.0.3 (21930508). This Windows enable auto-synchronize

Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-22 Thread Alexander Lakhin
Hello Kuroda-san, 20.07.2025 11:00, Alexander Lakhin wrote: Yeah, I made a simple test for GetSystemTimePreciseAsFileTime() and confirmed that in my VM it provides sub-microsecond precision. Regarding NTP, I think the second failure of this ilk [1] makes this cause close to impossible. (Can't w

Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-22 Thread Yugo Nagata
Hello Alexander, > Nagata-san, could you please share the configuration of hamerkop? If it's > running inside VM, what virtualization software is used? > > [1] > https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=hamerkop&dt=2025-07-09%2011%3A02%3A23 I am not the person in charge of it, s

Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-20 Thread Alexander Lakhin
Hello Kuroda-san, Thank you for your attention to this! 15.07.2025 10:33, Hayato Kuroda (Fujitsu) wrote: GetSystemTimePreciseAsFileTime() returns FILETIME structure, which represents the time UTC with 100-nanosecod intervals [1]. The stack overflow seemed to refer it. However, the document fo

RE: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-15 Thread Hayato Kuroda (Fujitsu)
Dear Alexander, > > So according to me, I suspect the following causes > > 1) The time difference between 'prev_stats_reset' and current > > 'stats_reset' value is less than 1 microseconds. > > 'stats_reset' is of type 'timestamp with time zone' and the content of > > it is like: '2025-06-30 21:01

Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-04 Thread Alexander Lakhin
Hello Shlok, 03.07.2025 09:54, Shlok Kyal wrote: I have also encountered a similar buildfarm failure [1]. | 1/1 + subscription 142 ms FAIL 1/1 postgresql:regress / regress/regress ERROR 284.85s exit status 1 diff --strip-trailing-cr -U3 c:/build-farm-lo

Re: stats.sql might fail due to shared buffers also used by parallel tests

2025-07-02 Thread Shlok Kyal
On Mon, 6 Jan 2025 at 12:30, Alexander Lakhin wrote: > > Hello hackers, > > I'd like to share my investigation of one mysterious stats.sql failure > occurred in December: [1]. > The difference of the failure is: > --- C:/prog/bf/root/HEAD/pgsql/src/test/regress/expected/stats.out 2024-09-18 > 19: