Re: 039_end_of_wal: error in "xl_tot_len zero" test

From: Anton Voloshin <a(dot)voloshin(at)postgrespro(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, David Rowley <dgrowleyml(at)gmail(dot)com>
Cc: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Pg Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: 039_end_of_wal: error in "xl_tot_len zero" test
Date: 2024-05-13 09:49:54
Message-ID: ffe8f1b6-6a2b-4f71-9427-12fc11c6c46e@postgrespro.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 13/05/2024 00:39, Tom Lane wrote:
> Hm. It occurs to me that there *is* a system-specific component to
> the amount of WAL emitted during initdb: the number of locales
> that "locale -a" prints translates directly to the number of
> rows inserted into pg_collation. [...]

Yes. Another system-specific circumstance affecting WAL position is the
name length of the unix user doing initdb. I've seen 039_end_of_wal
failing consistently under user aaaaaaaa but working fine with aaaa,
both on the same machine at the same time.

To be more precise, on one particular machine under those particular
circumstances (including set of locales) it would work for any username
with length < 8 or >= 16, but would fail for length 8..15 (in bytes, not
characters, if non-ASCII usernames were used).

--
Anton Voloshin
Postgres Professional, The Russian Postgres Company
https://postgrespro.ru

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jelte Fennema-Nio 2024-05-13 09:50:59 Re: Direct SSL connection with ALPN and HBA rules
Previous Message Wolfgang Wilhelm 2024-05-13 09:48:34 Re: Is there any chance to get some kind of a result set sifting mechanism in Postgres?