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

From Alexander Lakhin
Subject Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests
Date
Msg-id 6d309b6c-8eda-4a09-a88c-51465133201e@gmail.com
Whole thread Raw
In response to Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests  (TAKATSUKA Haruka <harukat@sraoss.co.jp>)
Responses Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests
List 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@ml.sraoss.co.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

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Making type Datum be 8 bytes everywhere
Next
From: Greg Hennessy
Date:
Subject: Re: simple patch for discussion