Траблы после обновления (1.4.7 -> 1.8.5)

[UUVtQD]

Всем привет!
Расскажу свою грустную историю, может кто поможет...
Стоял у меня zabbix версии 1.4.7 на CentOS 5.6. В один прекрасный момент я решил подключить репозиторий Atomic и обновится. Обновился. И обновился zabbix, до версии 1.8.5 . И все упало
В логах куча всяких ошибок, типа

3751:20110908:164832.309 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489712 and escalationid between 000000000000000 and 099999999999999]
3744:20110908:164833.011 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489713 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164833.011 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164835.312 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489715 and escalationid between 000000000000000 and 099999999999999]
3734:20110908:164836.099 [Z3005] Query failed: [1054] Unknown column 'proxy_hostid' in 'where clause' [select hostid,status from hosts where host='KYIV-RDP-V0001' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
3734:20110908:164836.099 [Z3005] Query failed: [1146] Table 'zabbix.autoreg_host' doesn't exist [select autoreg_hostid from autoreg_host where proxy_hostid=0 and host='KYIV-RDP-V0001' and autoreg_hostid between 000000000000000 and 099999999999999]
3734:20110908:164836.100 [Z3005] Query failed: [1146] Table 'zabbix.autoreg_host' doesn't exist [insert into autoreg_host (autoreg_hostid,proxy_hostid,host) values (3837,0,'KYIV-RDP-V0001')]
3734:20110908:164836.101 Send list of active checks to [172.25.12.40] failed: host [KYIV-RDP-V0001] not found
3744:20110908:164838.014 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489718 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164838.014 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164838.313 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489718 and escalationid between 000000000000000 and 099999999999999]
3719:20110908:164838.554 [Z3005] Query failed: [1054] Unknown column 'h.proxy_hostid' in 'field list' [select i.itemid,i.hostid,h.proxy_hostid,i.type,i.data_typ e,i.value_type,i.key_,i.snmp_community,i.snmp_oid, i.snmp_port,i.snmpv3_securityname,i.snmpv3_securit ylevel,i.snmpv3_authpassphrase,i.snmpv3_privpassph rase,i.ipmi_sensor,i.delay,i.delay_flex,i.trapper_ hosts,i.logtimefmt,i.params,i.status,i.authtype,i. username,i.password,i.publickey,i.privatekey from items i,hosts h where i.hostid=h.hostid and h.status in (0) and i.status in (0,3) and i.itemid between 000000000000000 and 099999999999999]
3719:20110908:164838.554 [Z3005] Query failed: [1054] Unknown column 'proxy_hostid' in 'field list' [select hostid,proxy_hostid,host,useip,ip,dns,port,useipmi ,ipmi_ip,ipmi_port,ipmi_authtype,ipmi_privilege,ip mi_username,ipmi_password,maintenance_status,maint enance_type,maintenance_from,errors_from,available ,disable_until,snmp_errors_from,snmp_available,snm p_disable_until,ipmi_errors_from,ipmi_available,ip mi_disable_until,status from hosts where status in (0,5,6) and hostid between 000000000000000 and 099999999999999]
3745:20110908:164839.034 [Z3005] Query failed: [1054] Unknown column 'unique_dcheckid' in 'field list' [select druleid,iprange,name,unique_dcheckid from drules where proxy_hostid=0 and status=0 and (nextcheck<=1315489719 or nextcheck>1315489719+delay) and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
3745:20110908:164839.034 [Z3005] Query failed: [1054] Unknown column 'proxy_hostid' in 'where clause' [select count(*),min(nextcheck) from drules where proxy_hostid=0 and status=0 and mod(druleid,1)=0 and druleid between 000000000000000 and 099999999999999]
3734:20110908:164839.166 [Z3005] Query failed: [1054] Unknown column 'proxy_hostid' in 'where clause' [select hostid,status from hosts where host='localhost' and status in (0,1) and proxy_hostid=0 and hostid between 000000000000000 and 099999999999999]
3734:20110908:164839.166 [Z3005] Query failed: [1146] Table 'zabbix.autoreg_host' doesn't exist [select autoreg_hostid from autoreg_host where proxy_hostid=0 and host='localhost' and autoreg_hostid between 000000000000000 and 099999999999999]
3734:20110908:164839.166 [Z3005] Query failed: [1146] Table 'zabbix.autoreg_host' doesn't exist [insert into autoreg_host (autoreg_hostid,proxy_hostid,host) values (3838,0,'localhost')]
3734:20110908:164839.169 Sending list of active checks to [127.0.0.1] failed: host [localhost] not found
3751:20110908:164841.314 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489721 and escalationid between 000000000000000 and 099999999999999]
3738:20110908:164841.501 [Z3005] Query failed: [1054] Unknown column 'a.alerttype' in 'where clause' [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,mt.mediatypeid,mt.type,mt.description, mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_ path,mt.gsm_modem,mt.username,mt.passwd,a.retries from alerts a,media_type mt where a.status=0 and a.mediatypeid=mt.mediatypeid and a.alerttype=0 and mt.mediatypeid between 000000000000000 and 099999999999999 order by a.clock]
3744:20110908:164843.016 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489723 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164843.016 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164844.316 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489724 and escalationid between 000000000000000 and 099999999999999]
3751:20110908:164847.318 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489727 and escalationid between 000000000000000 and 099999999999999]
3744:20110908:164848.017 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489728 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164848.018 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164850.319 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489730 and escalationid between 000000000000000 and 099999999999999]
3744:20110908:164853.019 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489733 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164853.019 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164853.321 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489733 and escalationid between 000000000000000 and 099999999999999]
3751:20110908:164856.323 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489736 and escalationid between 000000000000000 and 099999999999999]
3744:20110908:164858.022 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489738 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164858.022 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164859.326 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489739 and escalationid between 000000000000000 and 099999999999999]
3742:20110908:164900.635 [Z3005] Query failed: [1054] Unknown column 't.type' in 'field list' [select distinct t.triggerid,t.type,t.value,t.error,t.expression from triggers t,functions f,items i,hosts h where t.triggerid=f.triggerid and f.itemid=i.itemid and i.hostid=h.hostid and t.status=0 and f.function in ('nodata','date','dayofmonth','dayofweek','time',' now') and i.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and h.hostid between 000000000000000 and 099999999999999]
3742:20110908:164900.635 [Z3005] Query failed: [1146] Table 'zabbix.maintenances' doesn't exist [select m.maintenanceid,m.maintenance_type,m.active_since, tp.timeperiod_type,tp.every,tp.month,tp.dayofweek, tp.day,tp.start_time,tp.period,tp.start_date from maintenances m,maintenances_windows mw,timeperiods tp where m.maintenanceid=mw.maintenanceid and mw.timeperiodid=tp.timeperiodid and 1315489740 between m.active_since and m.active_till]
3742:20110908:164900.636 [Z3005] Query failed: [1054] Unknown column 'maintenance_type' in 'field list' [select hostid,maintenance_type,maintenance_from from hosts where status=0 and maintenance_status=1]
3751:20110908:164902.327 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489742 and escalationid between 000000000000000 and 099999999999999]
3744:20110908:164903.023 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489743 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164903.023 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164905.329 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489745 and escalationid between 000000000000000 and 099999999999999]
3744:20110908:164908.025 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489748 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164908.025 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164908.330 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489748 and escalationid between 000000000000000 and 099999999999999]
3751:20110908:164911.332 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489751 and escalationid between 000000000000000 and 099999999999999]
3738:20110908:164911.503 [Z3005] Query failed: [1054] Unknown column 'a.alerttype' in 'where clause' [select a.alertid,a.mediatypeid,a.sendto,a.subject,a.messa ge,a.status,mt.mediatypeid,mt.type,mt.description, mt.smtp_server,mt.smtp_helo,mt.smtp_email,mt.exec_ path,mt.gsm_modem,mt.username,mt.passwd,a.retries from alerts a,media_type mt where a.status=0 and a.mediatypeid=mt.mediatypeid and a.alerttype=0 and mt.mediatypeid between 000000000000000 and 099999999999999 order by a.clock]
3744:20110908:164913.027 [Z3005] Query failed: [1054] Unknown column 't.authentication' in 'field list' [select t.httptestid,t.name,t.applicationid,t.nextcheck,t. status,t.macros,t.agent,t.authentication,t.http_us er,t.http_password from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and t.nextcheck<=1315489753 and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3744:20110908:164913.028 [Z3005] Query failed: [1054] Unknown column 'h.maintenance_status' in 'where clause' [select min(t.nextcheck) from httptest t,applications a,hosts h where t.applicationid=a.applicationid and a.hostid=h.hostid and mod(t.httptestid,1)=0 and t.status=0 and h.status=0 and (h.maintenance_status=0 or h.maintenance_type=0) and t.httptestid between 000000000000000 and 099999999999999]
3751:20110908:164914.334 [Z3005] Query failed: [1146] Table 'zabbix.escalations' doesn't exist [select escalationid,actionid,triggerid,eventid,r_eventid, esc_step,status from escalations where status in (0,4,5,1) and nextcheck<=1315489754 and escalationid between 000000000000000 and 099999999999999]

На веб-морде присутствует такое:

Error in query [SELECT u.*,s.* FROM sessions s,users u WHERE s.sessionid='23c1b8b2f735c04b0d759657673710ea' AND s.status=0 AND s.userid=u.userid AND ((s.lastaccess+u.autologout>1315397816) OR (u.autologout=0)) AND ((u.userid BETWEEN 000000000000000 AND 099999999999999))] [Unknown column 's.status' in 'where clause']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:607]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:609]
Error in query [SELECT s.* FROM sessions s WHERE s.sessionid='23c1b8b2f735c04b0d759657673710ea' AND s.status=0 AND ((s.userid BETWEEN 000000000000000 AND 099999999999999))] [Unknown column 's.status' in 'where clause']
mysql_fetch_assoc() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:607]
mysql_free_result() expects parameter 1 to be resource, boolean given[/usr/share/zabbix/include/db.inc.php:609]
Undefined index: authentication_type[/usr/share/zabbix/index.php:59]

и такое

Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (256, 0, 'web.menu.login.last', 'index.php', 3, 0)] [Unknown column 'value_str' in 'field list']
Error in query [INSERT INTO profiles (profileid, userid, idx, value_str, type, idx2) VALUES (257, 0, 'web.paging.lastpage', 'index.php', 3, 0)] [Unknown column 'value_str' in 'field list']

Вот картинка:

Я так понял, что в новой версии другой формат таблиц, и поэтому оно так жестко глюкануло. Можно ли как то это дело исправить? А то не очень все заново подымать...
В общем, посоветуйте, что можно сделать.
Заранее спасибо.
P.S. И да, как всегда бекапа нет

[Salagin]

О, вот последствия апдейта без чтения документации... Конвертить базу до 1.6, потом до 1.8. Скрипты конвертации баз есть в исходниках каждой следующей версии.

[UUVtQD]

О, вот последствия апдейта без чтения документации... Конвертить базу до 1.6, потом до 1.8. Скрипты конвертации баз есть в исходниках каждой следующей версии.

Дело в том, что обновлять забикс я не хотел... Оно само.Ну да ладно, я был невнимателен, моя ошибка...
Вопрос в следующем - где найти эти скрипты? Смотрел тут - http://www.zabbix.com/download2.php - только агенты. Собственно, не могу найти только 1.6 версию, 1.8.7 есть.
Подскажите или поделитесь.
Спасибо!

[Salagin]

http://sourceforge.net/projects/zabbix/files/ZABBIX%20Latest%20Stable/

[UUVtQD]

http://sourceforge.net/projects/zabb...test%20stable/

Спасибо!
Все поднялось. Будешь в Киеве - с меня пиво