-
Incident report
-
Resolution: Won't fix
-
Trivial
-
None
-
6.0.24
-
None
-
None
Steps to reproduce:
- Navigate to Report -> Audit
- Click any Recordset ID to apply filter
- Wait for it load
Result:
In 5 of 10 times after some time there is an error like this:
Error in query [SELECT a.auditid,a.userid,a.username,a.clock,a.action,a.resourcetype,a.ip,a.resourceid,a.resourcename,a.details,a.recordsetid FROM auditlog a WHERE a.clock>='1703077331' AND a.clock<='1705669331' AND a.recordsetid='clr7tawnb0000iktmx022cxy4' ORDER BY a.auditid DESC LIMIT 1001] [Query execution was interrupted] [zabbix.php:22 → require_once() → ZBase->run() → ZBase->processRequest() → CController->run() → CControllerAuditLogList->doAction() → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CAuditLog->get() → DBselect() → trigger_error() in include/db.inc.php:248]
Expected:
Filtred list.
I guess it depends on size of installation. But can we do some optimization to fronted to mitigate this?