agora inbox for pgsql-bugs@postgresql.org
help / color / mirror / Atom feedBUG #19581: Non-UTF8-encoded text in log file
2+ messages / 2 participants
[nested] [flat]
* BUG #19581: Non-UTF8-encoded text in log file
@ 2026-07-26 10:28 PG Bug reporting form <noreply@postgresql.org>
2026-07-27 12:32 ` Re: BUG #19581: Non-UTF8-encoded text in log file Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2026-07-26 10:28 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: redoute@tortenboxer.de
The following bug has been logged on the website:
Bug reference: 19581
Logged by: Redoute
Email address: redoute@tortenboxer.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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #19581: Non-UTF8-encoded text in log file
2026-07-26 10:28 BUG #19581: Non-UTF8-encoded text in log file PG Bug reporting form <noreply@postgresql.org>
@ 2026-07-27 12:32 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2026-07-27 12:32 UTC (permalink / raw)
To: redoute@tortenboxer.de; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> Internal log messages (e.g. checkpoint messages) are written with CP1252
> bytes (0xFC for ü) instead of UTF-8.
I see no reason to think this is a bug. It's documented that sessions
write to the log in whatever their prevailing encoding is. I think
the checkpointer isn't attached to any particular database, so instead
of adopting some database's encoding it would use whatever is implied
by the postmaster's locale environment (LANG, LC_ALL, LC_CTYPE, or
related environment variables). So would the postmaster itself, for
that matter.
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2026-07-27 12:32 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2026-07-26 10:28 BUG #19581: Non-UTF8-encoded text in log file PG Bug reporting form <noreply@postgresql.org>
2026-07-27 12:32 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox