PDA

View Full Version : Zabbix Server 1.1beta2 hangs on startup

chocho63
13-10-2005, 15:47
I can't load zabbix_server 1.1beta2. I hangs with error :

025105:20051013:153752 server #6 started [Trapper]
025100:20051013:153752 Query::select escalationlogid,triggerid, alarmid, escalationid, level, adminlevel, nextcheck, status from escalation_log where status=0 and nextcheck<=1129210672
025100:20051013:153752 Query failed:Table 'zabbix.escalation_log' doesn't exist [1146]
025106:20051013:153752 server #7 started [Trapper]
025070:20051013:153752 One child process died. Exiting ...
025107:20051013:153752 server #8 started [Trapper]
025070:20051013:153752 Got QUIT or INT or TERM or PIPE signal. Exiting...
025107:20051013:153752 Got QUIT or INT or TERM or PIPE signal. Exiting...


The table escalation_log doesn't exist.

I've applied patch.sql.
Alexei
13-10-2005, 15:57
What ZABBIX version you're upgrading from?
chocho63
13-10-2005, 16:25
I'm upgrading from 1.1alpha11 to 1.1beta2, but I've applied patch.sql for 1.1apha11 to 1.1alpha12, 1.1alpha12 to 1.1beta1 and 1.1beta1 to 1.1beta2.
chocho63
13-10-2005, 16:34
I've found the solution : the creation of escalation_log is found in 1.1alpha10 to 1.1alpha11 patch.sql. My first version of Zabbix was 1.1alpha10, but I've already applied patch.sql, I don't understand.
marc
14-10-2005, 03:10
I've found the solution : the creation of escalation_log is found in 1.1alpha10 to 1.1alpha11 patch.sql. My first version of Zabbix was 1.1alpha10, but I've already applied patch.sql, I don't understand.

sounds a bit like an sql error on applying the patch.
i tricked myself by ignoring a mysql error applying patch to 1.1beta2. i added the new autoreg table from cvs and my cat patch.sql | mysql ... failed because existing table. server aint startet because the new 'ALTER" statements were missing.

this is just an example because seems like you just forgot something.
set Debuglevel 4 in zabbix_server.conf and check Logfile for missing columns or tables.