Ad Widget

Collapse

Mass update bug

Collapse
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • frankcheong
    Member
    • Oct 2009
    • 73
    #1

    Mass update bug

    I have problem in mass updating the "update interval of CPU iowait time, CPU system time, CPU idle time, CPU nice time and CPU user time" zabbix just return without changing those figures. Same case for updating the "update interval of Incoming Traffic or Outgoing Traffic for all available interface". Zabbix also didn't prompt for any error, it just return without doing anything. While I have tried to update some other item like Free diskspace or Used diskspace related setting without problems.
    Tags: None
    • frankcheong
      Member
      • Oct 2009
      • 73
      #2
      The problem is quite consistent while when I mass update say the CPU utilization related items together with free memory related items, it worked. But when I include some more into the mix say Incoming traffic for some interface, it didn't work again.

        Comment

        • frankcheong
          Member
          • Oct 2009
          • 73
          #3
          My bad, I just saw that there are some red word above the filter selection as below:-

          Item 'hostA:net.if.out[eth1,bytes]' updated
          Item 'hostB:net.if.out[eth1,bytes]' updated
          Item 'Template_Linux:net.if.out[eth1,bytes]' updated
          Item 'hostA:net.if.out[eth0,bytes]' updated
          Error in query [UPDATE items SET description='Outgoing traffic on interface $1',key_='net.if.out[eth0,bytes]',hostid=10017,delay=60,history=7,type=0,snmp_comm unity='',snmp_oid='',value_type=0,data_type=0,trap per_hosts='',snmp_port=161,units='Bps',multiplier= 0,delta=1,snmpv3_securityname='',snmpv3_securityle vel=0,snmpv3_authpassphrase='',snmpv3_privpassphra se='',formula='0',trends=365,logtimefmt='',valuema pid=0,delay_flex='',params='',ipmi_sensor='',templ ateid=10084,authtype=0,username='',password='',pub lickey='',privatekey='' WHERE itemid=18443] [ERROR: deadlock detected DETAIL: Process 18516 waits for ShareLock on transaction 52412396; blocked by process 5869. Process 5869 waits for ShareLock on transaction 52412128; blocked by process 18516.]
          Error in query [SELECT * FROM items WHERE (itemid IN (18443)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          Error in query [SELECT itemid,description,key_,hostid,delay,history,statu s,type,snmp_community,snmp_oid,value_type,data_typ e,trapper_hosts,snmp_port,units,multiplier,delta,s nmpv3_securityname,snmpv3_securitylevel,snmpv3_aut hpassphrase,snmpv3_privpassphrase,formula,trends,l ogtimefmt,valuemapid,delay_flex,params,ipmi_sensor ,templateid,authtype,username,password,publickey,p rivatekey FROM items WHERE itemid=10081] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          No item with itemid=[10081]
          Error in query [SELECT itemid,description,key_,hostid,delay,history,statu s,type,snmp_community,snmp_oid,value_type,data_typ e,trapper_hosts,snmp_port,units,multiplier,delta,s nmpv3_securityname,snmpv3_securitylevel,snmpv3_aut hpassphrase,snmpv3_privpassphrase,formula,trends,l ogtimefmt,valuemapid,delay_flex,params,ipmi_sensor ,templateid,authtype,username,password,publickey,p rivatekey FROM items WHERE itemid=10081] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          No item with itemid=[10081]
          Error in query [SELECT DISTINCT app.applicationid as result FROM applications app, items_applications ia WHERE app.applicationid=ia.applicationid AND (ia.itemid IN (10081)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          Error in query [SELECT * FROM hosts WHERE hostid=] [ERROR: syntax error at end of input at character 34]
          No host with hostid=[]
          Incorrect key format 'key_name[param1,param2,...]'
          Error in query [SELECT itemid,description,key_,hostid,delay,history,statu s,type,snmp_community,snmp_oid,value_type,data_typ e,trapper_hosts,snmp_port,units,multiplier,delta,s nmpv3_securityname,snmpv3_securitylevel,snmpv3_aut hpassphrase,snmpv3_privpassphrase,formula,trends,l ogtimefmt,valuemapid,delay_flex,params,ipmi_sensor ,templateid,authtype,username,password,publickey,p rivatekey FROM items WHERE itemid=10027] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          No item with itemid=[10027]
          Error in query [SELECT itemid,description,key_,hostid,delay,history,statu s,type,snmp_community,snmp_oid,value_type,data_typ e,trapper_hosts,snmp_port,units,multiplier,delta,s nmpv3_securityname,snmpv3_securitylevel,snmpv3_aut hpassphrase,snmpv3_privpassphrase,formula,trends,l ogtimefmt,valuemapid,delay_flex,params,ipmi_sensor ,templateid,authtype,username,password,publickey,p rivatekey FROM items WHERE itemid=10027] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          No item with itemid=[10027]
          Error in query [SELECT DISTINCT app.applicationid as result FROM applications app, items_applications ia WHERE app.applicationid=ia.applicationid AND (ia.itemid IN (10027)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          Error in query [SELECT * FROM hosts WHERE hostid=] [ERROR: syntax error at end of input at character 34]
          No host with hostid=[]
          Incorrect key format 'key_name[param1,param2,...]'
          Error in query [SELECT itemid,description,key_,hostid,delay,history,statu s,type,snmp_community,snmp_oid,value_type,data_typ e,trapper_hosts,snmp_port,units,multiplier,delta,s nmpv3_securityname,snmpv3_securitylevel,snmpv3_aut hpassphrase,snmpv3_privpassphrase,formula,trends,l ogtimefmt,valuemapid,delay_flex,params,ipmi_sensor ,templateid,authtype,username,password,publickey,p rivatekey FROM items WHERE itemid=10015] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          No item with itemid=[10015]
          Error in query [SELECT itemid,description,key_,hostid,delay,history,statu s,type,snmp_community,snmp_oid,value_type,data_typ e,trapper_hosts,snmp_port,units,multiplier,delta,s nmpv3_securityname,snmpv3_securitylevel,snmpv3_aut hpassphrase,snmpv3_privpassphrase,formula,trends,l ogtimefmt,valuemapid,delay_flex,params,ipmi_sensor ,templateid,authtype,username,password,publickey,p rivatekey FROM items WHERE itemid=10015] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          No item with itemid=[10015]
          Error in query [SELECT DISTINCT app.applicationid as result FROM applications app, items_applications ia WHERE app.applicationid=ia.applicationid AND (ia.itemid IN (10015)) ] [ERROR: current transaction is aborted, commands ignored until end of transaction block]
          Error in query [SELECT * FROM hosts WHERE hostid=] [ERROR: syntax error at end of input at character 34]
          No host with hostid=[]
          Incorrect key format 'key_name[param1,param2,...]'

            Comment

            Previous template Next
            Working...