Re: BUG #17481: sometime pg_stat_statements coredump

From: Michael Paquier <michael(at)paquier(dot)xyz>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: mailtch(at)163(dot)com, pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17481: sometime pg_stat_statements coredump
Date: 2022-05-16 23:52:57
Message-ID: YoLj2fcRQ5KZXAj0@paquier.xyz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Mon, May 16, 2022 at 11:21:21AM -0400, Tom Lane wrote:
> Not much info here. Can you install the debug symbols for the postgres
> package you're using and repeat the backtrace? Another potentially useful
> bit of info would be the source text for the query that's causing the
> failure, which you could get with "p debug_query_string" in gdb.

CleanQuerytext() would crash on a NULL string AFAIK, but this really
smells like a case where a utility code path is freeing the pointer of
the query string that PGSS is attempting to look at. I have seen this
problem in the past, where this subtle issue could be created even if
the code was rather careful in the query string handling. Here, are
we dealing with a CALL that involves plpgsql? Or is that a different
language, like something out of core?
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrey Lepikhov 2022-05-17 12:59:23 Re: Negative value of numGroups
Previous Message James Coleman 2022-05-16 21:02:06 pg_rewind fails to detect timeline change