Uploaded image for project: 'ZABBIX BUGS AND ISSUES'
  1. ZABBIX BUGS AND ISSUES
  2. ZBX-8067

not able to upgrade zabbix 2.0.11 to 2.2.3

    Details

    • Type: Incident report
    • Status: Closed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 2.2.3
    • Fix Version/s: None
    • Component/s: Server (S)
    • Labels:
    • Environment:
      Centos 5.8 (final), cpu model name : Intel(R) Xeon(R) CPU E5645 @ 2.40GHz, ram 1.7gb.

      Description

      We are getting the below error after the upgradation from zabbix server 2.0.11 to 2.2.3.

      12897:20140411:032353.277 Starting Zabbix Server. Zabbix 2.2.3 (revision 44105).
      12897:20140411:032353.277 ****** Enabled features ******
      12897:20140411:032353.277 SNMP monitoring: YES
      12897:20140411:032353.277 IPMI monitoring: NO
      12897:20140411:032353.277 WEB monitoring: YES
      12897:20140411:032353.277 VMware monitoring: NO
      12897:20140411:032353.277 Jabber notifications: YES
      12897:20140411:032353.277 Ez Texting notifications: YES
      12897:20140411:032353.277 ODBC: NO
      12897:20140411:032353.277 SSH2 support: NO
      12897:20140411:032353.277 IPv6 support: NO
      12897:20140411:032353.277 ******************************
      12897:20140411:032353.277 NodeID: 9
      12897:20140411:032353.277 ******************************
      12897:20140411:032353.277 using configuration file: /usr/local/etc/zabbix_server.conf
      12897:20140411:032353.368 current database version (mandatory/optional): 02020000/02020000
      12897:20140411:032353.368 required mandatory version: 02020000
      12897:20140411:032353.368 starting automatic database upgrade
      12897:20140411:032353.462 completed 100% of database upgrade
      12897:20140411:032353.462 database upgrade fully completed
      12897:20140411:032353.463 [Z3005] query failed: [1054] Unknown column 'hk_events_mode' in 'field list' [select refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends from config where configid between 900000000000000 and 999999999999999]
      12897:20140411:032353.463 no records in table 'config'
      12897:20140411:032353.464 [Z3005] query failed: [1054] Unknown column 'hk_events_mode' in 'field list' [select refresh_unsupported,discovery_groupid,snmptrap_logging,severity_name_0,severity_name_1,severity_name_2,severity_name_3,severity_name_4,severity_name_5,hk_events_mode,hk_events_trigger,hk_events_internal,hk_events_discovery,hk_events_autoreg,hk_services_mode,hk_services,hk_audit_mode,hk_audit,hk_sessions_mode,hk_sessions,hk_history_mode,hk_history_global,hk_history,hk_trends_mode,hk_trends_global,hk_trends from config where configid between 900000000000000 and 999999999999999]
      12897:20140411:032353.482 [Z3005] query failed: [1054] Unknown column 'i.state' in 'field list' [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_type,i.value_type,i.key_,i.snmp_community,i.snmp_oid,i.port,i.snmpv3_securityname,i.snmpv3_securitylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassphrase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_hosts,i.logtimefmt,i.params,i.state,i.authtype,i.username,i.password,i.publickey,i.privatekey,i.flags,i.interfaceid,i.snmpv3_authprotocol,i.snmpv3_privprotocol,i.snmpv3_contextname,i.lastlogsize,i.mtime from items i,hosts h where i.hostid=h.hostid and h.status=0 and i.status=0 and i.flags<>2 and i.itemid between 900000000000000 and 999999999999999]
      12897:20140411:032353.482 [Z3005] query failed: [1054] Unknown column 't.state' in 'field list' [select distinct t.triggerid,t.description,t.expression,t.error,t.priority,t.type,t.value,t.state,t.lastchange from hosts h,items i,functions f,triggers t where h.hostid=i.hostid and i.itemid=f.itemid and f.triggerid=t.triggerid and h.status=0 and i.status=0 and t.status=0 and t.flags<>2 and h.hostid between 900000000000000 and 999999999999999]
      12897:20140411:032353.540 [Z3005] query failed: [1054] Unknown column 'flags' in 'where clause' [select hostid,proxy_hostid,host,ipmi_authtype,ipmi_privilege,ipmi_username,ipmi_password,maintenance_status,maintenance_type,maintenance_from,errors_from,available,disable_until,snmp_errors_from,snmp_available,snmp_disable_until,ipmi_errors_from,ipmi_available,ipmi_disable_until,jmx_errors_from,jmx_available,jmx_disable_until,status,name from hosts where status in (0,5,6) and flags<>2 and hostid between 900000000000000 and 999999999999999]
      12897:20140411:032353.547 no records in table 'config'
      12901:20140411:032353.549 server #1 started configuration syncer #1
      12902:20140411:032353.550 server #2 started db watchdog #1
      12910:20140411:032353.556 server #9 started trapper #1
      12912:20140411:032353.558 server #10 started trapper #2
      12914:20140411:032353.559 server #11 started trapper #3
      12916:20140411:032353.561 server #12 started trapper #4
      12918:20140411:032353.562 server #13 started trapper #5
      12919:20140411:032353.596 server #14 started icmp pinger #1
      12921:20140411:032353.597 server #15 started alerter #1
      12923:20140411:032353.599 server #16 started housekeeper #1
      12923:20140411:032353.599 executing housekeeper
      12925:20140411:032353.600 server #17 started timer #1
      12927:20140411:032353.602 server #18 started node watcher #1
      12929:20140411:032353.604 server #19 started http poller #1
      12929:20140411:032353.605 [Z3005] query failed: [1054] Unknown column 't.variables' in 'field list' [select h.hostid,h.host,h.name,t.httptestid,t.name,t.variables,t.agent,t.authentication,t.http_user,t.http_password,t.http_proxy,t.retries from httptest t,hosts h where t.hostid=h.hostid and t.nextcheck<=1397183033 and mod(t.httptestid,1)=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 900000000000000 and 999999999999999]
      12929:20140411:032353.605 [Z3005] query failed: [1054] Unknown column 't.hostid' in 'where clause' [select min(t.nextcheck) from httptest t,hosts h where t.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.proxy_hostid is null and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 900000000000000 and 999999999999999]
      12932:20140411:032353.607 server #21 started history syncer #1
      12934:20140411:032353.609 server #22 started history syncer #2
      12936:20140411:032353.610 server #23 started history syncer #3
      12938:20140411:032353.612 server #24 started history syncer #4
      12940:20140411:032353.614 server #25 started escalator #1
      12940:20140411:032353.614 [Z3005] query failed: [1054] Unknown column 'itemid' in 'field list' [select escalationid,actionid,triggerid,eventid,r_eventid,nextcheck,esc_step,status,itemid from escalations where escalationid between 900000000000000 and 999999999999999 order by actionid,triggerid,itemid,escalationid]
      12942:20140411:032353.616 server #26 started proxy poller #1
      12944:20140411:032353.618 server #27 started self-monitoring #1
      12897:20140411:032353.618 server #0 started [main process]
      12904:20140411:032354.318 server #3 started poller #1
      12905:20140411:032354.319 server #4 started poller #2
      12906:20140411:032354.360 server #5 started poller #3
      12909:20140411:032354.544 server #8 started unreachable poller #1
      12931:20140411:032354.651 server #20 started discoverer #1
      12907:20140411:032354.693 server #6 started poller #4
      12908:20140411:032354.799 server #7 started poller #5
      12927:20140411:032354.800 [Z3005] query failed: [1054] Unknown column 'flags' in 'field list' [insert into node_cksum (nodeid,tablename,recordid,cksumtype,cksum) select 9,'hosts',hostid,1,concat_ws(',',case when proxy_hostid is null then 'NULL' else cast(proxy_hostid as char) end,md5(host),status,md5(error),available,lastaccess,ipmi_authtype,ipmi_privilege,md5(ipmi_username),md5(ipmi_password),ipmi_available,snmp_available,case when maintenanceid is null then 'NULL' else cast(maintenanceid as char) end,maintenance_status,maintenance_type,maintenance_from,md5(ipmi_error),md5(snmp_error),jmx_available,md5(jmx_error),md5(name),flags,case when templateid is null then 'NULL' else cast(templateid as char) end) from hosts where hostid between 900000000000000 and 999999999999999]

      and when i checked the process, its shows like this

      ps -ef | grep zabbix
      root 12892 12867 0 03:23 pts/1 00:00:00 tail -f /tmp/zabbix_server.log
      zabbix 12897 1 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server
      zabbix 12901 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: configuration syncer [waiting 60 sec for processes]
      zabbix 12902 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: db watchdog [synced alerts config in 0.000814 sec, idle 60 sec]
      zabbix 12904 12897 15 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: poller #1 [got 0 values in 0.000046 sec, idle 5 sec]
      zabbix 12905 12897 12 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: poller #2 [got 0 values in 0.000038 sec, idle 5 sec]
      zabbix 12906 12897 10 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: poller #3 [got 0 values in 0.000038 sec, idle 5 sec]
      zabbix 12907 12897 10 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: poller #4 [got 0 values in 0.000046 sec, idle 5 sec]
      zabbix 12908 12897 6 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: poller #5 [got 0 values in 0.000046 sec, idle 5 sec]
      zabbix 12909 12897 12 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: unreachable poller #1 [got 0 values in 0.000045 sec, idle 5 sec]
      zabbix 12910 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: trapper #1 [processed data in 0.000000 sec, waiting for connection]
      zabbix 12912 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: trapper #2 [processed data in 0.000000 sec, waiting for connection]
      zabbix 12914 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: trapper #3 [processed data in 0.000000 sec, waiting for connection]
      zabbix 12916 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: trapper #4 [processed data in 0.000000 sec, waiting for connection]
      zabbix 12918 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: trapper #5 [processed data in 0.000000 sec, waiting for connection]
      zabbix 12919 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: icmp pinger #1 [got 0 values in 0.000042 sec, idle 5 sec]
      zabbix 12921 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: alerter [sent alerts: 0 success, 0 fail in 0.070929 sec, idle 30 sec]
      zabbix 12923 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: housekeeper [removing old history and trends]
      zabbix 12925 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: timer #1 [processed 0 triggers, 0 events in 0.000000 sec, 0 maint.periods in 0.000000 sec, idle 7 sec]
      zabbix 12927 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: node watcher [synced with nodes in 0.000000 sec, syncing with nodes]
      zabbix 12929 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: http poller #1 [got 0 values in 0.000268 sec, idle 5 sec]
      zabbix 12931 12897 10 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: discoverer #1 [processed 0 rules in 0.042933 sec, idle 60 sec]
      zabbix 12932 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: history syncer #1 [synced 0 items in 0.000021 sec, idle 5 sec]
      zabbix 12934 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: history syncer #2 [synced 0 items in 0.000020 sec, idle 5 sec]
      zabbix 12936 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: history syncer #3 [synced 0 items in 0.000021 sec, idle 5 sec]
      zabbix 12938 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: history syncer #4 [synced 0 items in 0.000028 sec, idle 5 sec]
      zabbix 12940 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: escalator [processed 0 escalations in 0.000227 sec, idle 3 sec]
      zabbix 12942 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: proxy poller #1 [exchanged data with 0 proxies in 0.000025 sec, idle 5 sec]
      zabbix 12944 12897 0 03:23 ? 00:00:00 /usr/local/sbin/zabbix_server: self-monitoring [processed data in 0.000006 sec, idle 1 sec]
      root 12953 3541 0 03:23 pts/0 00:00:00 grep zabbix

      can u please help me on this.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                soma somasundaram
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: