Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-20923

known issue for particular posgresql version 13.2 - "could not find pathkey item to sort"

    XMLWordPrintable

Details

    • Incident report
    • Status: Confirmed
    • Trivial
    • Resolution: Unresolved
    • 5.0.23rc1, 6.0.3
    • None
    • Documentation (D)
    • None

    Description

      This SQL fails for zabbix frontend:

      2022-04-20 05:11:35.299 EDT [2232] ERROR:  could not find pathkey item to sort
      2022-04-20 05:11:35.299 EDT [2232] STATEMENT:  SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid=62298 AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN (0,4) GROUP BY i.hostid
      

      Release notes for postgresql 13.3 includes a bugfix with the description:

      Fix “could not find pathkey item to sort” planner errors in some situations where the sort key involves an aggregate or window function (James Coleman, Tom Lane)
      https://www.postgresql.org/docs/13/release-13-3.html

      Suggestion is to include this information to know issues in Zabbix documentation - https://www.zabbix.com/documentation/current/en/manual/installation/known_issues

      Attachments

        Activity

          People

            zabbix.dev Zabbix Development Team
            zalex_ua Oleksii Zagorskyi
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: