Re: Weird failure in explain.out with OpenBSD - Mailing list pgsql-hackers

From Mikael Kjellström
Subject Re: Weird failure in explain.out with OpenBSD
Date
Msg-id dee173b6-ba7a-7ef8-38cc-903475cb8178@mksoft.nu
Whole thread Raw
In response to Re: Weird failure in explain.out with OpenBSD  (Thomas Munro <thomas.munro@gmail.com>)
List pgsql-hackers
On 2021-11-11 02:15, Thomas Munro wrote:
> On Thu, Nov 11, 2021 at 1:15 PM Michael Paquier <michael@paquier.xyz> wrote:
>> morepork uses 6.9 now, but it has been recently upgraded from 5.4 or
>> a version close to that, right?  I am wondering if 7.0 may help
>> regarding this issue.  Postgres is not wrong here.
> 
> I dunno.  Clocks on virtualised systems and even metal seem to be a
> minefield of quirks and heuristics.  Some discussion, may or may not
> be relevant:
> 
> https://marc.info/?l=openbsd-tech&m=161657532610882&w=2

Hm, interesting.


> Some starter questions for Mikael would be: could you please check
> which clock source it's using?,

It's disabling TSC:

cpu1: disabling user TSC (skew=-4465)

so it seems to be using the acpitimer?

acpitimer0 at acpi0: 3579545 Hz, 24 bits



> is it under a hypervisor, and if so
> which?,

VMWare ESXI 6.7 latest updates installed.

> what is the CPU model?, what are other kernels choosing when
> running as guests on the same hypervisor (if applicable)? 

AMD Ryzen 5 3600X

> Did
> anything interesting happen on either the guest or host operating
> system (if not bare metal) some time around 2021-11-10 21:59 CET?

Nope, not that I can see.


> I'm no expert on this stuff but something tells me that a 124ms leap
> needs a different explanation than the sub-µs difference reported
> earlier...


It's running ntpd to keep time in sync if that matters?

/Mikael




pgsql-hackers by date:

Previous
From: Amit Kapila
Date:
Subject: Re: Parallel vacuum workers prevent the oldest xmin from advancing
Next
From: Mikael Kjellström
Date:
Subject: Re: Weird failure in explain.out with OpenBSD