From: Tom Lane <tgl@sss.pgh.pa.us>
To: pavol.sekeres8@gmail.com
Cc: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17755: database queries get stuck for certain IDs
Date: Fri, 20 Jan 2023 12:19:15 -0500
Message-ID: <532118.1674235155@sss.pgh.pa.us> (raw)
In-Reply-To: <17755-e7333e310e686ae4@postgresql.org>
References: <17755-e7333e310e686ae4@postgresql.org>
PG Bug reporting form <noreply@postgresql.org> writes:
> we are using PostgreSQL version 9.6.8 on our production environment which we
> operate ourselves.
You realize, I hope, that you are running a very old minor release
of a branch that's been out of support entirely for more than a year.
You might consider consulting our release note archives
https://www.postgresql.org/docs/release/
to see if your problem matches up with any of the large number of
post-9.6.8 fixes.
> We noticed that the insert/select queries which get stuck and run infinitely
> have specific request_id - starting with 'a6bda' for example
> 'a6bda748-0e31-4da6-8fed-331c6c4a7cdb'.
Smells a little bit like index corruption, perhaps. I'd try reindexing
whatever index(es) exist on that column. But if that doesn't fix it ...
> Do you know what could be the cause for our problems and possibly suggest
> any solution?
Running ancient minor releases is fundamentally unsound database
administration practice. At minimum you should be running the last
9.6.x minor release (9.6.24); but really now would be a good time
to be thinking about upgrading to some still-in-support branch.
If there is an actual Postgres problem here, and it wasn't fixed
by 9.6.24, we aren't ever going to fix it in that branch.
regards, tom lane
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: pgsql-bugs@postgresql.org
Cc: tgl@sss.pgh.pa.us, pavol.sekeres8@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17755: database queries get stuck for certain IDs
In-Reply-To: <532118.1674235155@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox