1.1Alpha 11 table missing server won't start

[skendall]

I ran into a problem upgrading from 1.1Alpha10 to 1.1Alpha11 that might help others. The DB upgrade script does not create the needed escalation_log table and it does not exist in the 1.1Alpha10 install schema.

I used the table add data from the create/mysql/schema.sql script that you would need to import on a new install.

mysql> CREATE TABLE escalation_log (
-> escalationlogid int(4) NOT NULL auto_increment,
-> triggerid int(4) DEFAULT '0' NOT NULL,
-> alarmid int(4) DEFAULT '0' NOT NULL,
-> escalationid int(4) DEFAULT '0' NOT NULL,
-> actiontype int(4) DEFAULT '0' NOT NULL,
-> level int(4) DEFAULT '0' NOT NULL,
-> adminlevel int(4) DEFAULT '0' NOT NULL,
-> nextcheck int(4) DEFAULT '0' NOT NULL,
-> status int(4) DEFAULT '0' NOT NULL,
-> PRIMARY KEY (escalationlogid),
-> KEY (alarmid,escalationid),
-> KEY (triggerid)
-> ) type=InnoDB;
Query OK, 0 rows affected (0.15 sec)

mysql>

Without adding this table from an upgrade from 1.1Alpha10 to 1.1Alpha11 the server process won't start and dies with this error.

007017:20050809:150344 Query::select escalationlogid,triggerid, alarmid, escalationid, level, adminlevel, nextcheck,
status from escalation_log where status=0 and nextcheck<=1123617824
007017:20050809:150344 Query failed:Table 'zabbix.escalation_log' doesn't exist [1146]
007018:20050809:150344 server #5 started [Poller. SNMP:ON]
007013:20050809:150344 One child process died. Exiting .


It looks like the upgrades/dbpatches/1.1apcha10_to_1.1apcha11/mysql/patch.sql needs to be updated so that the escalation_log table is added.