-
Patch request
-
Resolution: Incomplete
-
Trivial
-
None
-
6.0.7
-
None
Steps to reproduce:
- Open "Linux by Zabbix agent active"
- Create new trigger "Version of Zabbix agent is outdated" which checks "last(/Linux by Zabbix agent active/agent.version)<>"{$MAINSTREAM_AGENT_VERSION}""
- Select depdendencies tab
- Add depend on "Zabbix agent is not available" trigger from same template
- Click "Update" template
- Got error "Cannot update trigger"
Result:
Undefined offset: 10443 [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() in include/classes/api/services/CTriggerGeneral.php:3091]
Undefined offset: 10450 [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() in include/classes/api/services/CTriggerGeneral.php:3091]
pg_query(): Query failed: ERROR: invalid input syntax for type bigint: ""
LINE 1: ...own FROM trigger_depends WHERE triggerid_down IN ('',26831,2...
^ [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() → CTriggerGeneral::checkCircularDependencies() → DBselect() → pg_query() in include/db.inc.php:254]
Error in query [SELECT triggerdepid,triggerid_up,triggerid_down FROM trigger_depends WHERE triggerid_down IN ('',26831,26832,26833,26834,26835,26836,26837,26838,26839,26840,26841,26843,26844,31056,31097,31138,31308,31331,31354,31377,31600,31623,31646,31669)] [ERROR: invalid input syntax for type bigint: ""
LINE 1: ...own FROM trigger_depends WHERE triggerid_down IN ('',26831,2...
^]
pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() → DB::insertBatch() → DB::addIds() → DB::reserveIds() → DBselect() → pg_query() in include/db.inc.php:254]
Error in query [SELECT nextid FROM ids WHERE table_name='trigger_depends' AND field_name='triggerdepid' FOR UPDATE] [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 [triggers.php:406 → CApiWrapper->__call() → CFrontendApiWrapper->callMethod() → CApiWrapper->callMethod() → CFrontendApiWrapper->callClientMethod() → CLocalApiClient->callMethod() → CTrigger->update() → CTriggerGeneral::updateDependencies() → CTriggerGeneral::inheritDependencies() → DB::insertBatch() → DB::addIds() → DB::reserveIds() → DBexecute() → pg_query() in include/db.inc.php:373]
Error in query [SELECT nextid FROM ids WHERE table_name='trigger_depends' AND field_name='triggerdepid' FOR UPDATE] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
Your database is not working properly. Please wait a few minutes and try to repeat this action. If the problem still persists, please contact system administrator. The problem might be caused by long running transaction or row level lock accomplished by your database management system.
Expected:
Dependencies should be created and saved.{}
