Zabbix 5.2.7 Error in web-interface

[Osetrik]

Hi!
I'am have Zabbix 5.2.7 + PostgreSQL 13 + TimeScaleDB 2.1. It's installed on 2 separate server (Debian 10). If I logged in as a user with the administrator role, then I see the following message in the host configuration web interface:




If you log in as a regular user, there is no error.

In zabbix db server log same error:



I'am updated all package on 2 servers.

Please help with the solution of this problem.

[Osetrik]

Sorry, i upload bad screenshots.
In text:

WEB

• pg_query(): Query failed: ERROR: could not find pathkey item to sort [hosts.php:1617 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CTrigger->get() → DBselect() → pg_query() in include/db.inc.php:248]
• Error in query [SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid=16966 AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN (0,4) GROUP BY i.hostid] [ERROR: could not find pathkey item to sort]
• pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:1617 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CGraph->get() → DBselect() → pg_query() in include/db.inc.php:248]
• Error in query [SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid=16966 AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN (0,4) GROUP BY i.hostid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
• pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:1617 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CHttpTest->get() → DBselect() → pg_query() in include/db.inc.php:248]
• Error in query [SELECT COUNT(DISTINCT ht.httptestid) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid=16966 GROUP BY ht.hostid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
• pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:1617 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CHostGeneral->addRelatedObjects() → CApplication->get() → DBselect() → pg_query() in include/db.inc.php:248]
• Error in query [SELECT COUNT(DISTINCT a.applicationid) AS rowscount,a.hostid FROM applications a WHERE a.hostid=16966 GROUP BY a.hostid] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
• pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:1617 → CView->getOutput() → include() → getHostNavigation() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CHost->get() → CHost->addRelatedObjects() → CApiService->select() → DBselect() → pg_query() in include/db.inc.php:248]
• Error in query [SELECT t.hostid,t.ts_delete FROM host_discovery t WHERE t.hostid=16966] [ERROR: current transaction is aborted, commands ignored until end of transaction block]

/var/log/postgresql/postgresql-13-main.log

2021-07-01 14:58:22.719 +05 [29275] zabbix@zabbix ERROR: could not find pathkey item to sort
2021-07-01 14:58:22.719 +05 [29275] zabbix@zabbix STATEMENT: SELECT DISTINCT COUNT(DISTINCT t.triggerid) AS rowscount,i.hostid FROM triggers t,functions f,items i WHERE i.hostid=16966 AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN (0,4) GROUP BY i.hostid
2021-07-01 14:58:22.719 +05 [29275] zabbix@zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
2021-07-01 14:58:22.719 +05 [29275] zabbix@zabbix STATEMENT: SELECT DISTINCT COUNT(DISTINCT g.graphid) AS rowscount,i.hostid FROM graphs g,graphs_items gi,items i WHERE i.hostid=16966 AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN (0,4) GROUP BY i.hostid
2021-07-01 14:58:22.719 +05 [29275] zabbix@zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
2021-07-01 14:58:22.719 +05 [29275] zabbix@zabbix STATEMENT: SELECT COUNT(DISTINCT ht.httptestid) AS rowscount,ht.hostid FROM httptest ht WHERE ht.hostid=16966 GROUP BY ht.hostid
2021-07-01 14:58:22.720 +05 [29275] zabbix@zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
2021-07-01 14:58:22.720 +05 [29275] zabbix@zabbix STATEMENT: SELECT COUNT(DISTINCT a.applicationid) AS rowscount,a.hostid FROM applications a WHERE a.hostid=16966 GROUP BY a.hostid
2021-07-01 14:58:22.720 +05 [29275] zabbix@zabbix ERROR: current transaction is aborted, commands ignored until end of transaction block
2021-07-01 14:58:22.720 +05 [29275] zabbix@zabbix STATEMENT: SELECT t.hostid,t.ts_delete FROM host_discovery t WHERE t.hostid=16966