upgrade from 1.9.8 to 1.9.9 didn't go well

[my36]

My server logs started spewing LOTS of new error msgs like:

8223:20120209:101759.635 Escalation cancelled: Event [0] deleted.

18031:20120209:100634.790 [Z3005] query failed: [1054] Unknown column 'mt.status' in 'field list' [select m.mediatypeid,m.sendto,m.severity,m.period,mt.stat us from media m,media_type mt where m.mediatypeid=mt.mediatypeid and m.active=0 and m.userid=3]

Email notifications also stopped. I had to roll back to 1.9.8.

Did the DB schema change?

[jesmit]

I'm not a dev, but I will answer. Yes it did, quite a bit. I managed to get everything migrated manually as best I can tell and I'm stable for over a week now. I don't exactly have a procedure for a migration. mysqldump + a schema diff + lots of manually dumping the data back in to get my templates back.

A well known hazard of living off the beta.. :-)

[my36]

Thanks for the info.

I think I had better just stay with 1.9.8 until 2.0 is released.

The real problem is that I can't seem to export templates. That's going to make
the move to 2.0 very painful. Maybe I'll have to do as you did and try to migrate
at the table level.

You are correct - living with Beta's has it's downside but the new discovery and JMX
stuff is so important to us, I took my chances.

Cheers,
Lawrence

[richlv]

db schema changes almost constantly in the development builds. there are no official patches to keep up with that.
some unofficial ones for mysql can be found here :

https://zabbix.org/wiki/How_to/trunk_db_patches

http://www.zabbix.org/svn/zabbixorg/zabbix/upgrade_incremental/README