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

From: Alexander Lakhin <exclusion(at)gmail(dot)com>
To: TAKATSUKA Haruka <harukat(at)sraoss(dot)co(dot)jp>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, Shlok Kyal <shlok(dot)kyal(dot)oss(at)gmail(dot)com>, buildfarm(at)sraoss(dot)co(dot)jp
Subject: Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests
Date: 2025-07-23 20:00:00
Message-ID: 6d309b6c-8eda-4a09-a88c-51465133201e@gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello Takatsuka-san,

23.07.2025 08:48, TAKATSUKA Haruka wrote:
> Hello Alexander,
>
> On Wed, 23 Jul 2025 00:55:37 +0000
> Yugo Nagata - Buildfarm<buildfarm(at)ml(dot)sraoss(dot)co(dot)jp> 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 with 'time.windows.com'.
> VMware Tools 12.1.5 build 20735119 is installed in the VM.

Thank you for your prompt response!

I used VirtualBox, not VMWare, when trying to reproduce the issue, maybe
that's the reason why I failed. It looks like VMWare has it's own
specifics related to timekeeping: [1].

Maybe you could try tools.syncTime = "0" by any chance?

There is also an interesting note in VMware Tools 11 docs [2]:
If the clock on the guest operating system is ahead of the clock on the
host, VMware Tools causes the clock on the guest to run more slowly until
the clocks are synchronized.

But still it's hard to say without experimentation whether this can cause
the observed effect.

[1] https://knowledge.broadcom.com/external/article?legacyId=1318
[2]
https://techdocs.broadcom.com/us/en/vmware-cis/vsphere/tools/11-1-0/vmware-tools-administration-11-1-0/configuring-vmware-tools-components/using-vmware-tools-configuration-utility/enable-periodic-time-synchronization.html

Best regards,
Alexander

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Greg Hennessy 2025-07-23 20:52:15 Re: simple patch for discussion
Previous Message Tom Lane 2025-07-23 19:00:04 Re: Making type Datum be 8 bytes everywhere