[ZBX-6973] saving host with "Template Virt VMware vCenter" produces sql errors and can not be upadated Created: 2013 Sep 10 Updated: 2017 May 30 Resolved: 2013 Sep 18 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | Frontend (F), Templates (T) |
Affects Version/s: | 2.1.4 |
Fix Version/s: | 2.1.6, 2.2.0 |
Type: | Incident report | Priority: | Trivial |
Reporter: | Janis Perkons | Assignee: | Unassigned |
Resolution: | Fixed | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified | ||
Environment: |
SUSE Linux Enterprise Server 11 (x86_64) Server version: Apache/2.2.10 (Linux/SUSE) postgres (PostgreSQL) 8.3.9 |
Description |
Added ESXi host to host list and trying to assign template Created: Application "Log" on "VM". Created: Application "Clusters" on "VM". Created: Discovery rule "Discover vCenter VMs" on "VM". Created: Discovery rule "Discover vCenter hypervisors" on "VM". Created: Discovery rule "Discover vCenter clusters" on "VM". Created: Item prototype "Status of "$2" cluster" on "VM". pg_query(): Query failed: ERROR: zero-length delimited identifier at or near """" LINE 1: ...WHERE hg.hostid IN ('10090','10092') AND hg.name NOT LIKE "" ^ [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT hg.group_prototypeid,hg.hostid FROM group_prototype hg WHERE hg.hostid IN ('10090','10092') AND hg.name NOT LIKE ""] [ERROR: zero-length delimited identifier at or near """" LINE 1: ...WHERE hg.hostid IN ('10090','10092') AND hg.name NOT LIKE "" ^] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->select() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT t.* FROM group_prototype t WHERE 1=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->select() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->select() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->createRelationMap() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT t.hosttemplateid,t.hostid,t.templateid FROM hosts_templates t WHERE t.hostid IN ('10090','10092')] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->createRelationMap() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CZBXAPI->createRelationMap() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CTemplate->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT h.hostid,h.templateid FROM hosts h WHERE h.status=3 AND 1=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CTemplate->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->get() ? CHostPrototype->addRelatedObjects() ? CTemplate->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CDiscoveryRule->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT i.itemid,i.hostid FROM items i,hosts h WHERE i.flags=1 AND i.itemid IN ('23542','23554') AND h.hostid=i.hostid AND h.status=3] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CDiscoveryRule->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CDiscoveryRule->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CHost->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT h.hostid,h.host,h.status FROM hosts h,hosts_templates ht WHERE h.flags IN (0,4) AND h.hostid='10093' AND 1=0 AND h.hostid=ht.hostid AND h.status IN (0,1,3) AND h.flags='0'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CHost->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHostPrototype->syncTemplates() ? CHostPrototype->inherit() ? CHostPrototype->prepareInheritedObjects() ? CHost->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CItem->syncTemplates() ? CItem->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.hostid,i.name,i.description,i.key_,i.delay,i.history,i.trends,i.status,i.value_type,i.trapper_hosts,i.units,i.multiplier,i.delta,i.snmpv3_contextname,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authprotocol,i.snmpv3_authpassphrase,i.snmpv3_privprotocol,i.snmpv3_privpassphrase,i.formula,i.logtimefmt,i.valuemapid,i.delay_flex,i.params,i.ipmi_sensor,i.data_type,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.filter,i.port,i.inventory_link,i.lifetime FROM items i WHERE i.type<>9 AND i.flags IN (0,4) AND i.hostid='10088' AND i.flags='0'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CItem->syncTemplates() ? CItem->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CItem->syncTemplates() ? CItem->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT ht.httptestid,ht.name,ht.applicationid,ht.delay,ht.status,ht.variables,ht.agent,ht.authentication,ht.http_user,ht.http_password,ht.hostid,ht.templateid FROM httptest ht WHERE ht.hostid='10088'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT hs.httpstepid,hs.httptestid,hs.name,hs.no,hs.url,hs.timeout,hs.posts,hs.variables,hs.required,hs.status_codes FROM httpstep hs WHERE 1=0] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? CHttpTestManager->inherit() ? CHttpTestManager->getChildHostsFromHttpTests() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT ht.templateid,ht.hostid FROM hosts_templates ht WHERE 1=0 AND ht.hostid='10093'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? CHttpTestManager->inherit() ? CHttpTestManager->getChildHostsFromHttpTests() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CHttpTestManager->link() ? CHttpTestManager->inherit() ? CHttpTestManager->getChildHostsFromHttpTests() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplates() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT i.hostid,t.* FROM triggers t,functions f,items i WHERE i.hostid='10088' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4')] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplates() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplates() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTriggerPrototype->syncTemplates() ? CTriggerPrototype->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT i.hostid,t.* FROM triggers t,functions f,items i WHERE t.flags=2 AND i.hostid='10088' AND f.triggerid=t.triggerid AND f.itemid=i.itemid] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTriggerPrototype->syncTemplates() ? CTriggerPrototype->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTriggerPrototype->syncTemplates() ? CTriggerPrototype->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10093' AND ht.templateid='10088'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? CGraphPrototype->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT i.hostid,g.* FROM graphs g,graphs_items gi,items i WHERE g.flags=2 AND i.hostid='10088' AND gi.graphid=g.graphid AND i.itemid=gi.itemid] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? CGraphPrototype->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraphPrototype->syncTemplates() ? CGraphPrototype->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT ht.hostid,ht.templateid FROM hosts_templates ht WHERE ht.hostid='10093' AND ht.templateid='10088'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? CGraph->get() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT i.hostid,g.* FROM graphs g,graphs_items gi,items i WHERE i.hostid='10088' AND gi.graphid=g.graphid AND i.itemid=gi.itemid AND g.flags IN ('0','4')] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? CGraph->get() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CGraph->syncTemplates() ? CGraph->get() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplateDependencies() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBselect() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:411] Error in query [SELECT DISTINCT t.triggerid FROM triggers t,functions f,items i WHERE i.hostid='10088' AND f.triggerid=t.triggerid AND f.itemid=i.itemid AND t.flags IN ('0','4')] [ERROR: current transaction is aborted, commands ignored until end of transaction block] pg_fetch_assoc() expects parameter 1 to be resource, boolean given [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplateDependencies() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_fetch_assoc() in /srv/www/htdocs/php/include/db.inc.php:622] pg_free_result(): supplied argument is not a valid PostgreSQL result resource [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? CHost->massAdd() ? CHostGeneral->massAdd() ? CHostGeneral->link() ? CTrigger->syncTemplateDependencies() ? CTrigger->get() ? CZBXAPI->customFetch() ? DBfetchArray() ? DBfetch() ? pg_free_result() in /srv/www/htdocs/php/include/db.inc.php:623] pg_query(): Query failed: ERROR: current transaction is aborted, commands ignored until end of transaction block [hosts.php:479 ? CAPIObject->update() ? CAPIObject->__call() ? czbxrpc::call() ? czbxrpc::callAPI() ? call_user_func() ? CHost->update() ? CHost->massUpdate() ? DBexecute() ? pg_query() in /srv/www/htdocs/php/include/db.inc.php:547] Error in query [DELETE FROM host_inventory WHERE hostid='10093'] [ERROR: current transaction is aborted, commands ignored until end of transaction block] Cannot delete inventory. |
Comments |
Comment by Janis Perkons [ 2013 Sep 10 ] |
Template Virt VMware vCenter Guest - can be assigned and saved Template Virt VMware vSphere - SQL errors |
Comment by Vitalij Romanovskij (Inactive) [ 2013 Sep 18 ] |
fixed in the development branch svn://svn.zabbix.com/branches/dev/ZBX-6973 |
Comment by Pavels Jelisejevs (Inactive) [ 2013 Sep 19 ] |
TESTED. |
Comment by Vitalij Romanovskij (Inactive) [ 2013 Sep 20 ] |
fixed in pre-2.1.6 (trunk) r38667 |