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

after installing timescaledb, the following error appeared

XMLWordPrintable

    • Icon: Problem report Problem report
    • Resolution: Won't fix
    • Icon: Trivial Trivial
    • None
    • 6.4.14
    • Frontend (F)
    • AlmaLinux 9, postgresql16

      AlmaLinux 9, postgresql16, TimescaleDB 2.13.0

      Error:

      pg_query(): Query failed: ОШИБКА: ORDER/GROUP BY expression not found in targetlist [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → Widgets\TopHosts\Actions\WidgetView->doAction() → Widgets\TopHosts\Actions\WidgetView->getData() → Widgets\TopHosts\Actions\WidgetView::getItemValues() → CHistoryManager->getLastValues() → CHistoryManager->getLastValuesFromSqlWithPk() → DBselect() → pg_query() in include/db.inc.php:254]
      Error in query [SELECT h.itemid,MAX(h.clock) AS clock FROM history h WHERE h.itemid=42269 AND h.clock>1714054823 GROUP BY h.itemid] [ОШИБКА: ORDER/GROUP BY expression not found in targetlist]
      

      How to fix?

            zabbix.support Zabbix Support Team
            KHII_NITA KHII_NITA
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Created:
              Updated:
              Resolved: