From: Bruce Momjian <bruce@momjian.us>
To: jakub.zemanek@gmail.com
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16965: Select query fails with ERROR: XX000: could not find pathkey item to sort
Date: Thu, 15 Apr 2021 17:38:50 -0400
Message-ID: <20210415213850.GA17131@momjian.us> (raw)
In-Reply-To: <16965-d02be1c323c94896@postgresql.org>
References: <16965-d02be1c323c94896@postgresql.org>
On Thu, Apr 15, 2021 at 04:05:03PM +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
>
> Bug reference: 16965
> Logged by: Jakub Zemanek
> Email address: jakub.zemanek@gmail.com
> PostgreSQL version: 13.2
> Operating system: Ubuntu 20.04
> Description:
>
> Hi,
> after upgrade of our zabbix database from v 12 to v 13, we have encountered
> error in select queries. When we SET max_parallel_workers_per_gather=0; then
> the query finishes without error. The query looks like this:
> SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM
> triggers t,functions f,items i WHERE i.hostid=10406 AND
> f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN (0,4) GROUP BY
> i.hostid;'
> ERROR: XX000: could not find pathkey item to sort
> LOCATION: prepare_sort_from_pathkeys, createplan.c:6013
This issue was reported on April 12 by someone else:
https://www.postgresql.org/message-id/flat/91f3ec99-85a4-fa55-ea74-33f85a5c651f%40swarm64.com
A patch to fix it is being considered. You might want to watch that
thread to test or apply the patch, or wait for a fix in the next minor
release.
--
Bruce Momjian <bruce@momjian.us> https://momjian.us
EDB https://enterprisedb.com
If only the physical world exists, free will is an illusion.
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: bruce@momjian.us, jakub.zemanek@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #16965: Select query fails with ERROR: XX000: could not find pathkey item to sort
In-Reply-To: <20210415213850.GA17131@momjian.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