Request a Demo
Home   >   mailing lists

Re: bug reapper: Empty query_id in pg_stat_activity - Mailing list pgsql-bugs

From Greg Sabino Mullane
Subject Re: bug reapper: Empty query_id in pg_stat_activity
Date
Msg-id CAKAnmmLYvGuDD1k1gqgSdYzhhZGdz32bS-mo8ZF40Fw7UxtG7w@mail.gmail.com
Whole thread Raw
In response to Re: bug reapper: Empty query_id in pg_stat_activity  (Srinath Reddy Sadipiralla <srinath2133@gmail.com>)
Responses Re: bug reapper: Empty query_id in pg_stat_activity
List pgsql-bugs
Tree view
On Thu, Aug 28, 2025 at 8:25 AM Srinath Reddy Sadipiralla <srinath2133@gmail.com> wrote:
The fix I tried is to retain the previous query_id (prev_st_query_id) and return it when st_query_id is still 0 but query_id computation is enabled, thoughts?

This just moves the race condition around a little - you can end up with a query that does not agree with its query_id.

 
Cheers,
Greg

--
Enterprise Postgres Software Products & Tech Support

pgsql-bugs by date:

Previous
From: Srinath Reddy Sadipiralla
Date:
Subject: Re: bug reapper: Empty query_id in pg_stat_activity
Next
From: PG Bug reporting form
Date:
Subject: BUG #19036: Failed prepared INSERT statement make another SELECT query generate wrong result