[ZBX-8067] not able to upgrade zabbix 2.0.11 to 2.2.3 Created: 2014 Apr 11  Updated: 2017 May 30  Resolved: 2014 Apr 11

Status: Closed
Project: ZABBIX BUGS AND ISSUES
Component/s: Server (S)
Affects Version/s: 2.2.3
Fix Version/s: None

Type: Incident report Priority: Major
Reporter: somasundaram Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: database, dm
Remaining Estimate: Not Specified
Time Spent: Not Specified
Original Estimate: Not Specified
Environment:

Centos 5.8 (final), cpu model name : Intel(R) Xeon(R) CPU E5645 @ 2.40GHz, ram 1.7gb.


Issue Links:
Duplicate
duplicates ZBX-7253 unknown column errors with node setup Closed

 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.



 Comments   
Comment by Andrei Gushchin (Inactive) [ 2014 Apr 11 ]

This project only for bug request.
Please, use Zabbix forums or IRC for consultancy.
Also please, read Zabbix bug reporting guidelines. https://zabbix.org/wiki/Docs/bug_reporting_guidelines

Comment by Oleksii Zagorskyi [ 2014 Apr 11 ]

Seems it duplicates ZBX-7253, feel free to reopen if it's not.
Closed.

Generated at Fri Mar 29 06:56:29 EET 2024 using Jira 9.12.4#9120004-sha1:625303b708afdb767e17cb2838290c41888e9ff0.