pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18318: Different character codes are mixed in the log file in Japanese locale.
2+ messages / 2 participants
[nested] [flat]
* BUG #18318: Different character codes are mixed in the log file in Japanese locale.
@ 2024-01-31 09:56 PG Bug reporting form <noreply@postgresql.org>
0 siblings, 1 reply; 2+ messages in thread
From: PG Bug reporting form @ 2024-01-31 09:56 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: gomikioshi@gmail.com
The following bug has been logged on the website:
Bug reference: 18318
Logged by: Mick ee
Email address: gomikioshi@gmail.com
PostgreSQL version: 15.2
Operating system: Windows11
Description:
Different character codes are mixed in the log file in Japanese locale like
following.
2023-12-27 12:52:55.156 JST [10428] LOG: チェックポイント完了: 7572個のバッファを出力 (46.2%);
0個のWALファイルを追加、0個を削除、5個を再利用; 書き出し=269.047秒, 同期=0.087秒, 全体=269.187秒;
同期したファイル=41, 最長=0.005秒, 平均=0.003秒; 距離=69337 kB, 予測=69337 kB
2023-12-27 12:53:09.914 JST [37840] ERROR: 12譎る俣蠖｢蠑上〒縺ｯ"0"譎ゅ��荳肴ｭ｣縺ｧ縺�
2023-12-27 12:53:09.914 JST [37840] 繝偵Φ繝�: 24譎る俣蠖｢蠑上ｒ菴ｿ縺��°縲√ｂ縺励￥縺ｯ 1 縺九ｉ
12 縺ｮ髢薙〒謖��ｮ壹＠縺ｦ縺上□縺輔＞縲�
2023-12-27 12:53:09.914 JST [37840] 譁�: select * from temp.kyocera1227 k
where to_timestamp('2023-12-07 00:00:00','YYYY-MM-DD hh:MI:SS')< k."Last
seen"
2023-12-27 12:58:25.183 JST [10428] LOG: チェックポイント開始: time
2023-12-27 12:58:26.657 JST [10428] LOG: チェックポイント完了: 14個のバッファを出力 (0.1%);
0個のWALファイルを追加、0個を削除、0個を再利用; 書き出し=1.418秒, 同期=0.024秒, 全体=1.474秒; 同期したファイル=7,
最長=0.012秒, 平均=0.004秒; 距離=57 kB, 予測=62409 kB
I can send entire of the some log files.
Regards.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: BUG #18318: Different character codes are mixed in the log file in Japanese locale.
@ 2024-01-31 15:38 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Bug reporting form <noreply@postgresql.org>
0 siblings, 0 replies; 2+ messages in thread
From: Tom Lane @ 2024-01-31 15:38 UTC (permalink / raw)
To: gomikioshi@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
PG Bug reporting form <noreply@postgresql.org> writes:
> Different character codes are mixed in the log file in Japanese locale like
> following.
This is expected, if you're running an installation that has a mix of
different database encodings. Processes will log in whatever encoding
is used by the database they're connected to. Processes not connected
to any DB will log in the encoding suggested by the locale
environment. (At least that's how it works on Unix; less sure about
Windows.) There's not much we can do to change this. If we tried to
convert all these to a common encoding, what happens if the encoding
conversion fails?
regards, tom lane
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2024-01-31 15:38 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-31 09:56 BUG #18318: Different character codes are mixed in the log file in Japanese locale. PG Bug reporting form <noreply@postgresql.org>
2024-01-31 15:38 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox