Zabbix Database upgrade ?

[chandra22]

Hi Guys,

I have upgraded the Zabbix from 2.4.7 to 3.0 (upgrade completed fine)
After the upgrade i have started the Zabbix server, but its showing as not running.

sudo /etc/init.d/zabbix-server start
* Starting Zabbix server zabbix_server
sudo /etc/init.d/zabbix-server status
* zabbix_server is not running

Its been around 2 hours. I am not sure whether it still upgrading the Database or the Database upgrade process not started at all ?

# tail /var/log/zabbix/zabbix_server.log
32155:20160330:122018.863 poller #45 [got 10 values in 0.342636 sec, getting values]
32148:20160330:122018.863 poller #38 [got 10 values in 0.351091 sec, getting values]
32129:20160330:122018.863 poller #19 [got 9 values in 0.344776 sec, getting values]
32159:20160330:122018.863 poller #49 [got 10 values in 0.344905 sec, getting values]
32126:20160330:122018.863 poller #16 [got 9 values in 0.350108 sec, getting values]
32136:20160330:122018.864 poller #26 [got 8 values in 0.336054 sec, getting values]
32149:20160330:122018.864 poller #39 [got 12 values in 0.354949 sec, getting values]
32134:20160330:122018.864 poller #24 [got 1 values in 0.365587 sec, getting values]
32105:20160330:122018.864 zbx_on_exit() called
32150:20160330:122018.864 In get_values()

I can't find any logs written since the Zabbix server upgrade process started.

Could you please let me know how to check if the Database upgrade process started or not ?
why its not writing to log file or i need to check something else

MySQL Database size: 120GB
its located in different server and zabbix user have full permissions. .Config file got correct details

Zabbix front-end error message "–The frontend does not match Zabbix database. Current database version (mandatory/optional): 2040000/2040000. Required mandatory version: 3000000. Contact your system administrator.
"

Thank you

[chandra22]

Its still the same its been 5 hours since the Zabbix upgraded to 3.0

Restarted the Zabbix server service number of times - no use
increased "StartPollers" value
Rebooted the server as well - no luck

when i tried to restart the Zabbix server service - its not even starting for a sec, as well. and its not giving any error as well.

As the Zabbix log file not updated since i started the upgrade process, I am not understanding what to check now

OS: Ubuntu 14.04.4 LTS

Thank you

[roberts.andzans]

MySQL Database size: 120GB
its located in different server and zabbix user have full permissions. .Config file got correct details

Zabbix front-end error message "–The frontend does not match Zabbix database. Current database version (mandatory/optional): 2040000/2040000. Required mandatory version: 3000000. Contact your system administrator."

hey!

Have you checked, if your DB version is compatible with new Zabbix 3.0?

Here I found some info in - https://www.zabbix.com/documentation...n/requirements

[roberts.andzans]

Some notes on your issue:

1. Do not use DebugLevel=4, because it gives redundant information. Instead DebugLevel=3 is good enough

2. Is is good to use two SSH sessions. In one you do your actions and in second use tail -f for your zabbix-server.log to monitor your current progress

3. Zabbix front-end error message "–The frontend does not match Zabbix database - shows that your frontend is upgraded to 3.0, but zabbix-server-mysql is still on old version.
When you will upgrade zabbix-server-mysql to 3.0 this message will disappear

-Rob-

[chandra22]

Hi Guys,

Thanks for your help.

As i mentioned in my previous response, my initial attempt failed when trying to upgrade to 3.0

- I have used command "apt-get upgrade". This may be wrong to use ....
- choose to keep old Config files at the time of upgrade

Not sure what went wrong, after the upgrade the service was not starting at all, after number of attempts I have rolled it back. (restored the Zabbix server snapshot - thanks to virtualisation).

On my second attempt, I have followed below procedure
- I ran the Ubuntu update first
- used cmd "sudo apt-get install --only-upgrade zabbix-server-mysql zabbix-frontend-php zabbix-agent -y"
- choose to overwrite Config files at the time of upgrade

Not sure which option resulted successful upgrade. Now everything working fine and good. later updated the "zabbix_server.conf" file using our own values.

Perfect now. Welcome to 3.0


Regards,