mysql problem after yum update

General support questions including new installations
Post Reply
betgares
Posts: 2
Joined: 2015/09/16 11:40:07

mysql problem after yum update

Post by betgares » 2015/09/16 11:45:03

i ran yum update now i cant start mysql please help! log file is

150916 06:21:19 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [ERROR] Error message file '/usr/share/mysql/english/errmsg.sys' had only 481 error messages,
but it should contain at least 641 error messages.
Check that the above file is the right version for this program!
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
150916 6:21:19 [Warning] /usr/libexec/mysqld: Option '--set-variable' is deprecated. Use --variable-name=value instead.
/usr/libexec/mysqld: Unknown error 1146
150916 6:21:19 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
150916 6:21:19 InnoDB: Initializing buffer pool, size = 2.0M
150916 6:21:19 InnoDB: Completed initialization of buffer pool
150916 6:21:20 InnoDB: Started; log sequence number 0 78431534
150916 6:21:20 [ERROR] /usr/libexec/mysqld: unknown option '--skip-bdb'
150916 6:21:20 [ERROR] Aborting

150916 6:21:20 InnoDB: Starting shutdown...
150916 6:21:25 InnoDB: Shutdown completed; log sequence number 0 78431534
150916 6:21:25 [Note]
150916 06:21:25 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: mysql problem after yum update

Post by TrevorH » 2015/09/16 13:33:15

You've almost certainly installed mixed versions of your mysql packages. Post the output from rpm -qa \*mysql\* | sort so we can see what you have.
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

betgares
Posts: 2
Joined: 2015/09/16 11:40:07

Re: mysql problem after yum update

Post by betgares » 2015/09/16 17:12:42

Looks like I have 5 versions

[root@vps ~]# rpm -qa \*mysql\*
mysqlclient15-5.0.91-1.jason.1
mysql-server-5.1.58-jason.1
mysql-5.0.95-5.el5_9
php-mysql-5.3.25-1.w5
mysql-5.1.58-jason.1

User avatar
TrevorH
Site Admin
Posts: 33202
Joined: 2009/09/24 10:40:56
Location: Brighton, UK

Re: mysql problem after yum update

Post by TrevorH » 2015/09/16 18:38:41

Yes, you've installed some weird third party repo that supplies an incompatible version of mysql. Worse, bits of it are actually older than the one that CentOS supplies. You need to get them in sync so I'd start by trying yum upgrade mysql\* and see if that offers to correct the problem. What you should have installed on a 5.11 system is

Code: Select all

mysql-5.0.95-5.el5_9
mysql-server-5.0.95-5.el5_9
Oh, right, so mysql-server is the problem package here in that it is 5.1.58 and the CentOS supplied version is 5.0.95 so try yum downgrade mysql-server mysql and see if that offers you 5.0.95. If it does then say yes. You could also try with --disablerepo=\* --enablerepo=base,updates to see if that allows the downgrade correctly.

You've really got quite a mess there - php-mysql 5.3.25? CentOS 5 ships 5.1.6 not 5.3 and w5 presumably means webtatic :-( I don't believe that either utterramblings (the jason stuff) or webtatic are listed in the additional repos page on the wiki and they're not ones we generally recommend to anyone. https://wiki.centos.org/AdditionalResou ... positories
The future appears to be RHEL or Debian. I think I'm going Debian.
Info for USB installs on http://wiki.centos.org/HowTos/InstallFromUSBkey
CentOS 5 and 6 are deadest, do not use them.
Use the FAQ Luke

Post Reply