zabbix will not restart upon upgrade

[terrywhitejr2000]

Upgraded to the version
zabbix-server-2.2.5-1.el6.x86_64
zabbix-2.2.5-1.el6.x86_64
zabbix-server-mysql-2.2.5-1.el6.x86_64
zabbix-web-2.2.5-1.el6.noarch
zabbix-web-mysql-2.2.5-1.el6.noarch
zabbix-agent-2.2.5-1.el6.x86_64

This is the error I am getting from the logs

==> /var/log/zabbix/zabbix_server.log <==
1813:20140811:174735.302 VMware monitoring: YES
1813:20140811:174735.302 Jabber notifications: YES
1813:20140811:174735.302 Ez Texting notifications: YES
1813:20140811:174735.302 ODBC: YES
1813:20140811:174735.302 SSH2 support: YES
1813:20140811:174735.302 IPv6 support: YES
1813:20140811:174735.302 ******************************
1813:20140811:174735.302 using configuration file: /etc/zabbix/zabbix_server.conf
1813:20140811:174735.416 [Z3005] query failed: [1286] Unknown table engine 'InnoDB' [select mandatory,optional from dbversion]
1813:20140811:174735.416 Cannot get the database version. Exiting ...

[Koral]

Have you tried downgrading to previous version?
Is there anything in mysql logs?

[terrywhitejr2000]

==> mysqld.log <==
140812 5:13:47 InnoDB: Completed initialization of buffer pool
InnoDB: Unable to lock ./ib_logfile0, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Error in opening ./ib_logfile0
140812 5:13:47 [ERROR] Plugin 'InnoDB' init function returned error.
140812 5:13:47 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140812 5:13:47 [Note] Event Scheduler: Loaded 0 events
140812 5:13:47 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

[terrywhitejr2000]

Yes, I did try to downgrade.... I even restored the entire system for giggles.

[terrywhitejr2000]

So this is what I am getting from the web
Database error
The frontend does not match Zabbix database. Current database version (mandatory/optional): 0/0. Required mandatory version: 2020000. Contact your system administrator.

and this is now in the mysql log

InnoDB: using the same InnoDB data or log files.
InnoDB: Unable to lock ./ib_logfile0, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Error in opening ./ib_logfile0
140813 19:47:05 [ERROR] Plugin 'InnoDB' init function returned error.
140813 19:47:05 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
140813 19:47:05 [Note] Event Scheduler: Loaded 0 events
140813 19:47:05 [Note] /usr/libexec/mysqld: ready for connections.
Version: '5.1.73' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution

[bbrendon]

Did I miss something? What version are you upgrading from?

[Koral]

Have you tried googling with this errors?
There is something about deleting/moving ibdatalog files and restarting mysql - have you tried this?
Or maybe I misunderstand - the mysql service alone is starting but with those errors?

[cookiemonster]

==> mysqld.log <==
InnoDB: Unable to lock ./ib_logfile0, error: 11
distribution

I would check for permissions on the mysql files for the MySQL user.

Also check this for possible solution http://dbhk.wordpress.com/2012/02/27...ile0-error-11/

Your issue is not zabbix, but the database itself.

[troffasky]

I had this, and it was caused by Zentyal packages dropping a file with

innodb = off

into /etc/mysql/conf.d

Cue much confusion, as everything MySQL-based other than Zabbix worked fine. It seems that my Zabbix table was the only one that uses InnoDB!

[bernard]

Disabled InnoDB log file size

The answer is quite late but I hop it could help someone else.

I disabled "innodb_log_file_size" from /etc/my.cnf and restart mySQL.

#innodb_log_file_size = 64M

I cannot explain why. I got this settings on my old Zabbix server, but it doesn't work anymore on my new installation. Is it Zabbix or mySQL issue