RE: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind - Mailing list pgsql-hackers

From Onur Tirtir
Subject RE: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind
Date
Msg-id AM9PR83MB0498C9DFFA9804AA13325E84E9879@AM9PR83MB0498.EURPRD83.prod.outlook.com
Whole thread Raw
In response to Re: [PATCH] Report the query string that caused a memory error under Valgrind  (Peter Eisentraut <peter.eisentraut@enterprisedb.com>)
Responses Re: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hey Peter,

Thank you for reviewing the patch and for your feedback. I believe the v2 patch should be able to handle other protocol
messagestoo. 

-----Original Message-----
From: Peter Eisentraut <peter.eisentraut@enterprisedb.com>
Sent: Wednesday, March 22, 2023 7:00 PM
To: Onur Tirtir <Onur.Tirtir@microsoft.com>; pgsql-hackers@lists.postgresql.org
Subject: [EXTERNAL] Re: [PATCH] Report the query string that caused a memory error under Valgrind

[You don't often get email from peter.eisentraut@enterprisedb.com. Learn why this is important at
https://aka.ms/LearnAboutSenderIdentification] 

On 31.01.23 15:00, Onur Tirtir wrote:
> We use Valgrind --together with the suppression file provided in
> Postgres repo-- to test Citus extension against memory errors.
>
> We replace /bin/postgres executable with a simple bash script that
> executes the original postgres executable under Valgrind and then we
> run our usual regression tests.
>
> However, it is quite hard to understand which query caused a memory
> error in the stack traces that has been dumped into valgrind logfile.
>
> For this reason, we propose the attached patch to allow Valgrind to
> report the query string that caused a memory error right after the
> relevant stack trace.
>
> I belive this would not only be useful for Citus but also for Postgres
> and other extensions in their valgrind-testing process.

I can see how this could be useful.  But this only handles queries using the simple protocol.  At least the extended
protocolshould be handled as well.  Maybe it would be better to move this up to PostgresMain() and handle all protocol
messages?


Attachment

pgsql-hackers by date:

Previous
From: Tomas Vondra
Date:
Subject: Re: Add LZ4 compression in pg_dump
Next
From: Jeff Davis
Date:
Subject: Re: ICU locale validation / canonicalization