Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug

From: Pawel Veselov <pawel(dot)veselov(at)gmail(dot)com>
To: Alban Hertroys <haramrae(at)gmail(dot)com>
Cc: Scot Kreienkamp <Scot(dot)Kreienkamp(at)la-z-boy(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, "depesz(at)depesz(dot)com" <depesz(at)depesz(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Date: 2025-08-20 11:42:32
Message-ID: CAMnJ+Bd5h2-AbL+326sM51ComYVOY1=K-aYjkOrM4CuQ2UbDCQ@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > 匀礀渀挀栀爀漀渀漀甀猀 挀漀洀洀椀琀㼀  伀爀 愀猀礀渀挀栀爀漀渀漀甀猀㼀ഀ਀ഀ਀ഀ਀匀挀漀琀 䬀爀攀椀攀渀欀愀洀瀀 簀 䄀瀀瀀氀椀挀愀琀椀漀渀猀 䤀渀昀爀愀猀琀爀甀挀琀甀爀攀 䄀爀挀栀椀琀攀挀琀 簀 䰀愀ⴀ娀ⴀ䈀漀礀 䌀漀爀瀀漀爀愀琀攀ഀ਀⠀㜀㌀㐀⤀ ㌀㠀㐀ⴀ㘀㐀 ㌀ 簀 ㄀ⴀ㜀㌀㐀ⴀ㤀㄀㔀ⴀ㄀㐀㐀㐀 簀 匀挀漀琀⸀䬀
> This looks like a bug in Outlook (at work) that I ran into over 3 years ago after enabling beta-support for UTF-8 encoding… The fun part was that the messages looked perfectly fine on my end, but were gibberish on the receiving ends only. Is that bug still present perhaps?

Interesting.
Your email client probably incorrectly interprets UTF-16 encoding.
That's what the content charset is in Scott's email.
The first text character in Scott's email is "S" (U0053), but when
sending(?) it translates to 匀 (U5300).

Gmail web also is struggling with it, judging by the spaces I see
between the characters in the Scott's original. Those spaces are
replaced '0x00' chars from the first byte of each UTF-16 char.

>
> Or is it just my end that turns Scott's (and only Scott's) messages into gibberish Chinese?
>
> Alban Hertroys
> --
> There is always an exception to always.
>
>
>
>
>
>

--
With best of best regards
Pawel S. Veselov

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2025-08-20 12:03:39 Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Previous Message hubert depesz lubaczewski 2025-08-20 11:35:20 Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug