BUG #19581: Non-UTF8-encoded text in log file

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: redoute(at)tortenboxer(dot)de
Subject: BUG #19581: Non-UTF8-encoded text in log file
Date: 2026-07-26 10:28:01
Message-ID: 19581-e1b37ea2556ab74d@postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 19581
Logged by: Redoute
Email address: redoute(at)tortenboxer(dot)de
PostgreSQL version: 17.4
Operating system: Windows 11
Description:

Internal log messages (e.g. checkpoint messages) are written with CP1252
bytes (0xFC for ü) instead of UTF-8. Consequently
pg_read_file(pg_current_logfile()) fails with invalid byte sequence for
encoding "UTF8": 0xfc. SQL error messages in the same log appear correctly
encoded.

Wrongly encoded log file entry:

2026-07-26 08:26:19 CEST LOG: Checkpoint komplett: 7 Puffer geschrieben
(0.0%); 0 WAL-Datei(en) hinzugefügt, 0 entfernt, 0 wiederverwendet;
Schreiben=0,776 s, Sync=0,047 s, gesamt=0,864 s; sync. Dateien=6,
l䮧ste=0,019 s, Durchschnitt=0.008 s; Entfernung=3 kB, Sch䴺ung=213 kB;
LSN=2E4/8A2C65C0, Redo-LSN=2E4/8A2C6568

Correctly encoded log file entries in the same file:

2026-07-26 11:36:16 CEST FEHLER: ungültige Byte-Sequenz für Kodierung
»UTF8«: 0xfc
2026-07-26 11:36:16 CEST ANWEISUNG: /*pga4dash*/
SELECT pg_read_file(pg_current_logfile(), 0, 14787);

2026-07-26 11:37:54 CEST FEHLER: kann Tabelle netex.authority nicht
löschen, weil andere Objekte davon abhängen
2026-07-26 11:37:54 CEST DETAIL: Sicht netex.operators hängt von Tabelle
netex.authority ab
Sicht netex.linestat hängt von Tabelle netex.authority ab
2026-07-26 11:37:54 CEST TIPP: Verwenden Sie DROP ... CASCADE, um die
abhängigen Objekte ebenfalls zu löschen.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Rui Zhao 2026-07-26 16:28:06 Re: BUG #19483: pg_upgrade fails with orphan records in pg_init_priv catalog table
Previous Message PG Bug reporting form 2026-07-25 07:24:18 BUG #19580: Can not FINALIZE detach partition. Table in stuck