1.8 -> 2.0 upgrade

[adambmedent]

Hey all!

I am working on upgrading my 1.8 install to 2.0. Here are my steps.

1. Uninstall zabbix
- yum remove zabbix*

2. Install zabbix20
- yum install zabbix20 zabbix20-agent zabbix20-server zabbix20-server-mysql zabbix20-web zabbix20-web-mysql

3. cd /usr/share/zabbix-mysql/upgrades/2.0/

4. chmod 777 upgrade

5. ./upgrade -p zabbix

All goes well for 10-15 minutes. Then the process bombs out and mysql just sits at 100% usage.

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)
Failed to patch Zabbix database. Restore from backup

This is a virtual machine so I can simply restore the back VM image when this happens. Any ideas why mysql keeps dieing on me? I appreciate the input!

[adambmedent]

Giving this another try it seems to be going a bit further. How long should this upgrade process take? So far I am roughly 2 hours in and it hasn't finished.

[adambmedent]

Giving this another try it seems to be going a bit further. How long should this upgrade process take? So far I am roughly 2 hours in and it hasn't finished.

Looks like it bombed out again. I am now trying to just simply restore the database. I am almost thinking about just starting fresh.