Re: [Buildfarm:84] Re: stats.sql might fail due to shared buffers also used by parallel tests
Alexander Lakhin <exclusion@gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
To: TAKATSUKA Haruka <harukat@sraoss.co.jp>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda.hayato@fujitsu.com>,
pgsql-hackers <pgsql-hackers@postgresql.org>,
Shlok Kyal <shlok.kyal.oss@gmail.com>, buildfarm@sraoss.co.jp
Date: 2025-07-23T20:00:00Z
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@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