Upgrade 1.8 to 2.0.9 server gentoo

[juliansoares]

I'm having trouble updating zabbix version , done installing version 2.0.9 on gentoo , there appeared in my logs errors :

16722:20131216:103709.038 [ Z3005 ] query failed: [ 1054 ] Unknown column ' s ' in ' field list' [ insert into events ( eventid , source , object , objectid , clock , ns , value , value_changed ) values ( 236,139.2 , 3,5,1387197429,0,1,0 ) ]
*16722:20131216:103709.090 can not send list of active checks to [ 10.0.0.12 ] : host [ CFLEX12 ] not found
*16722:20131216:103710.914 [ Z3005 ] query failed: [ 1054 ] Unknown column ' s ' in ' field list' [ insert into events ( eventid , source , object , objectid , clock , ns , value , value_changed ) values ( 236,139.2 , 3,4,1387197430,0,1,0 ) ]
*16722:20131216:103710.964 can not send list of active checks to [ 10.0.20.1 ] : host [ CFLEX2 ] not found
*16722:20131216:103711.563 [ Z3005 ] query failed: [ 1054 ] Unknown column ' s ' in ' field list' [ insert into events ( eventid , source , object , objectid , clock , ns , value , value_changed ) values ( 236,139.2 , 3,17,1387197431,0,1,0 ) ]
*16722:20131216:103711.626 can not send list of active checks to [ 10.0.0.1 ] : host [ CFLEX1 ] not found
*16722:20131216:103714.501 [ Z3005 ] query failed: [ 1054 ] Unknown column ' s ' in ' field list' [ insert into events ( eventid , source , object , objectid , clock , ns , value , value_changed ) values ( 236,139.2 , 3,18,1387197434,0,1,0 ) ]
*16722:20131216:103714.537 can not send list of active checks to [ 10.0.20.7 ] : host [ DEDALUS ] not found
*16722:20131216:103715.507 [ Z3005 ] query failed: [ 1054 ] Unknown column ' s ' in ' field list' [ insert into events ( eventid , source , object , objectid , clock , ns , value , value_changed ) values ( 236,139.2 , 3,9,1387197435,0,1,0 ) ]


*16710:20131216:104557.076 watchdog : database is down
*16709:20131216:104557.215 [ Z3005 ] query failed: [ 1054 ] Unknown column ' t.value_flags ' in ' field list' [ select distinct t.triggerid , t.description , t.expression , t.error , t.priority , t . type , t.value , t.value_flags from hosts h , items i , functions f , triggers h.hostid where t = i.hostid and i.itemid = f.itemid and f.triggerid = t.triggerid and h.status in ( 0 ) and i.status in ( 0.3 ) and in t.status ( 0 ) and t.flags not in ( 2 ) and between 0 and h.hostid 99999999999999 ]
*16709:20131216:104557.215 [ Z3005 ] query failed: [ 1054 ] Unknown column ' t.flags ' in 'where clause ' [select i.itemid , f.functionid , f.function , f.parameter , t.triggerid from hosts h , items i , functions f , triggers h.hostid where t = i.hostid and i.itemid = f.itemid and f.triggerid = t.triggerid and h.status in ( 0 ) and i.status in ( 0.3 ) and t.status in ( 0 ) and t.flags not in ( 2 ) and between 0 and h.hostid 99999999999999 ]
*16709:20131216:104557.216 [ Z3005 ] query failed: [ 1054 ] Unknown column ' jmx_errors_from ' in ' field list' [select from hosts where status in ( 0,5,6 ) and between 0 and hostid 99999999999999 ]
*16710:20131216:104657.082 [ Z3005 ] query failed: [ 1054 ] Unknown column ' mt.status ' in 'where clause ' [select from medium m , users_groups u , c config , where m.userid media_type mt = u.userid and u.usrgrpid = c.alert_usrgrpid and m.mediatypeid = mt.mediatypeid and m.active mt.status = 0 and = 0 ]


I ran the patch from mysql :

mysql > mysql - uzabbix - pzabbix < patch.sql
ERROR 1005 ( HY000 ) at line 6 : Can not create table ' # sql - zabbix 6dd2_20bc . ' ( Errno : 121 )


I do not know what else to do , can someone help ?

[juliansoares]

restored, come back again

apollo mysql # ./upgrade zabbix -uzabbix -pzabbix123
WARNING: backup your database before performing upgrade

This is an UNSUPPORTED Zabbix upgrade script from 1.8 to 2.0 for MySQL
It does the following things:
1. Updates indexes that might require changes;
2. Patches the database from 1.8 schema to 2.0 schema;
3. Adds 'Disabled' and 'Debug' usergroup if any missing;
4. Checks for hosts not belonging to any group and adds them to one if any found.

Usage: pass required MySQL parameters to this script (like database, user, password etc).

Continue ? (y/n) y
Patching the database
ERROR 1050 (42S01) at line 171: Table 'globalvars' already exists
Failed to patch Zabbix database. Restore from backup

and now?