public inbox for [email protected]
help / color / mirror / Atom feedFrom: Jim Jones <[email protected]>
To: Kirill Reshke <[email protected]>
To: Kirill Gavrilov <[email protected]>
Cc: Andrey M. Borodin <[email protected]>
Cc: Euler Taveira <[email protected]>
Cc: [email protected]
Subject: Re: Truncate logs by max_log_size
Date: Thu, 28 Nov 2024 15:22:55 +0100
Message-ID: <[email protected]> (raw)
In-Reply-To: <CALdSSPiq+x9pRVYvYtddTQsL8=ZMvob+vSv5mHEXbe0aoPWGig@mail.gmail.com>
References: <CA+E0NR4S+NC6+QHyY_vUuQZMzLhKqczMx-jJVqtjAxF6+=JwAA@mail.gmail.com>
<[email protected]>
<[email protected]>
<[email protected]>
<CA+E0NR4=J-pgqEAV2weymygGmk1ePym45m2AcGyi2hpa9xRvBg@mail.gmail.com>
<CALdSSPiq+x9pRVYvYtddTQsL8=ZMvob+vSv5mHEXbe0aoPWGig@mail.gmail.com>
On 25.11.24 17:52, Kirill Reshke wrote:
> Hello! Please deliver the most recent patch version and fix the issues
> Jim identified [0] as the current commitfest draws to a close.
> Do not forget to include both parts of this patch (This was actually
> developed off-list, and we are now using this on our cloud PostgreSQL
> distribution on versions 12–17).
>
> [0] https://www.postgresql.org/message-id/35096a36-04d4-480b-a7cd-a2d8151fb737%40uni-muenster.de
In addition to these points, this feature seems to fail with queries
containing special characters (more than one byte):
With this "max_log_size"..
postgres=# SHOW max_log_size;
max_log_size
--------------
20
(1 row)
... and this query ..
postgres=# SELECT "ÄÜÖ" FROM t;
ERROR: relation "t" does not exist
LINE 1: SELECT "ÄÜÖ" FROM t;
.. this is the [truncated] log entry we get ..
2024-11-28 14:58:57.912 CET [2258876] ERROR: relation "t" does not
exist at character 19
2024-11-28 14:58:57.912 CET [2258876] STATEMENT: SELECT "ÄÜÖ" FROM
... although the query originally had exactly 20 characters:
postgres=# SELECT length('SELECT "ÄÜÖ" FROM t;');
length
--------
20
(1 row)
postgres=# SELECT length('ÄÜÖ'::bytea), length('AUO'::bytea);
length | length
--------+--------
6 | 3
(1 row)
If it is supposed to be like this, it should be clearly stated so in the
docs.
--
Jim
view thread (5+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected], [email protected], [email protected], [email protected], [email protected]
Subject: Re: Truncate logs by max_log_size
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox