Ad Widget

Collapse

no more data collection after upgrade from 3 to 4.

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • no more data collection after upgrade from 3 to 4.

    hello, i m facing a problem that i can't solved alone. We upgrade our zabbix appliance to version4 and since the upgrade no more data are collecting.
    we can connect on front end show host, screen and all of items but when we try to clone a host we have this error :

    Details Cannot add host
    • Error in query [SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.host id,i.name,i.description,i.key_,i.master_itemid,i.d elay,i.history,i.trends,i.status,i.value_type,i.tr apper_hosts,i.units,i.snmpv3_contextname,i.snmpv3_ securityname,i.snmpv3_securitylevel,i.snmpv3_authp rotocol,i.snmpv3_authpassphrase,i.snmpv3_privproto col,i.snmpv3_privpassphrase,i.formula,i.logtimefmt ,i.valuemapid,i.params,i.ipmi_sensor,i.authtype,i. username,i.password,i.publickey,i.privatekey,i.fla gs,i.port,i.inventory_link,i.lifetime,i.jmx_endpoi nt,i.url,i.timeout,i.query_fields,i.posts,i.status _codes,i.follow_redirects,i.post_type,i.http_proxy ,i.headers,i.retrieve_mode,i.request_method,i.outp ut_format,i.allow_traps,i.ssl_cert_file,i.ssl_key_ file,i.ssl_key_password,i.verify_peer,i.verify_hos t,i.evaltype FROM items i WHERE i.flags=1 AND i.hostid='10186'] [Unknown column 'i.ssl_cert_file' in 'field list']
    • Error in query [SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.host id,i.name,i.description,i.key_,i.master_itemid,i.d elay,i.history,i.trends,i.status,i.value_type,i.tr apper_hosts,i.units,i.snmpv3_contextname,i.snmpv3_ securityname,i.snmpv3_securitylevel,i.snmpv3_authp rotocol,i.snmpv3_authpassphrase,i.snmpv3_privproto col,i.snmpv3_privpassphrase,i.formula,i.logtimefmt ,i.valuemapid,i.params,i.ipmi_sensor,i.authtype,i. username,i.password,i.publickey,i.privatekey,i.fla gs,i.port,i.inventory_link,i.lifetime,i.jmx_endpoi nt,i.url,i.timeout,i.query_fields,i.posts,i.status _codes,i.follow_redirects,i.post_type,i.http_proxy ,i.headers,i.retrieve_mode,i.request_method,i.outp ut_format,i.allow_traps,i.ssl_cert_file,i.ssl_key_ file,i.ssl_key_password,i.verify_peer,i.verify_hos t FROM items i WHERE i.type<>9 AND i.hostid='10186' AND i.flags='0'] [Unknown column 'i.ssl_cert_file' in 'field list']
    • Error in query [SELECT i.itemid,i.type,i.snmp_community,i.snmp_oid,i.host id,i.name,i.description,i.key_,i.master_itemid,i.d elay,i.history,i.trends,i.status,i.value_type,i.tr apper_hosts,i.units,i.snmpv3_contextname,i.snmpv3_ securityname,i.snmpv3_securitylevel,i.snmpv3_authp rotocol,i.snmpv3_authpassphrase,i.snmpv3_privproto col,i.snmpv3_privpassphrase,i.formula,i.logtimefmt ,i.valuemapid,i.params,i.ipmi_sensor,i.authtype,i. username,i.password,i.publickey,i.privatekey,i.fla gs,i.port,i.inventory_link,i.lifetime,i.jmx_endpoi nt,i.url,i.timeout,i.query_fields,i.posts,i.status _codes,i.follow_redirects,i.post_type,i.http_proxy ,i.headers,i.retrieve_mode,i.request_method,i.outp ut_format,i.allow_traps,i.ssl_cert_file,i.ssl_key_ file,i.ssl_key_password,i.verify_peer,i.verify_hos t FROM items i WHERE i.flags=2 AND i.hostid='10186'] [Unknown column 'i.ssl_cert_file' in 'field list']
    • Incorrect item key "icmpping" provided for trigger expression on "AIRPORT-EP_test".


    after checking more things we identify that no data are collecting by the appliance.

    during the upgrade all seems to be well.

    any idea how to fix this?

    Regards


  • zux
    replied
    You should start by looking at the log file (/var/log/zabbix/zabbix_server.log), there are probably some errors there.
    How did you do the upgrade?
    It's correct that Zabbix doesn't recommend appliance for production, but upgrading should still work.

    Leave a comment:


  • gofree
    replied
    I'm not sure if appliance is a good thing for production - eg. I guess Zabbix doent recommend to use applaince in production - who lnows what could have gone wrong ....not an answe though

    Leave a comment:

Announcement

Collapse
No announcement yet.
Working...
X