zabbix_server 1.1beta5 stopping

[patrick]

I have a problem with zabbix upgrade 1.1beta5 (and patch mysql database with 1.1beta4_to_1.1beta5). After a time it stops and this is the information I get in the file zabbix_server.log

002686:20060109:095333 Query::select actionid,userid,delay,subject,message,scope,severi ty,recipient,good,maxrepeats,repeatdelay from actions where (scope=0 and triggerid=12236 and (good=1 or good=2) and nextcheck<=1136796813) or (scope=1 and (good=1 or good=2)) or (scope=2 and (good=1 or good=2))
002686:20060109:095333 Query failed:Unknown column 'scope' in 'field list' [1054]
002680:20060109:095333 One child process died. Exiting ...
002689:20060109:095333 Got QUIT or INT or TERM or PIPE signal. Exiting...
(....................)

Thanks
Patrick

[Nate Bell]

Well, it looks like Zabbix is making a query on actions and is still selecting scope, good, severity, and triggerid. However, according to the beta4 -> beta5 upgrade, all of these were dropped from the actions table.

alter table actions drop triggerid;
alter table actions drop scope;
alter table actions drop good;
alter table actions drop severity;

If you've upgraded your database, and have upgraded your server and agents, then also make sure you have upgraded your web interface. That would be my first line of attack, since the database seems to be upgraded, but something is still making queries on it that are looking for an older database. That's assuming, of course, that it isn't a bug.

Nate

[Alexei]

You are running old ZABBIX server. Use ZABBIX 1.1beta5 binaries!

[patrick]

Thank you. I think that was the reason. I forgot to copy the new binary.
Thanks