Categories
MySQL

MySQL 5.5.25

The packages of MySQL 5.5.25 are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures. They fixes some InnoDB- and replication-related issues.

As usual, please read carefully the full Changelog before upgrading.

24 replies on “MySQL 5.5.25”

Thanks.
I’ve upgraded from MySQL 5.5.24 to 5.5.25 successfully.
But there was an error message during upgrade.

======================
apt-get update
apt-get upgrade

These packages upgraded: mysql-client mysql-client-5.5 mysql-common mysql-server-5.5 mysql-server-core-5.5

Stopping MySQL database server: mysqld.
insserv: warning: script is corrupt or invalid: /etc/init.d/../rc6.d/K00vzreboot
Starting MySQL database server: mysqld ..
Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..
======================

@Guillaume Plessis : Thank you very much for taking the time to package this version!
@Parsec : I made a fresh install of this package and didn’t get the error message you reported. Can that possibly be related to a previous, corrupted installation?

getting the following error when updating my debian squeeze boxes

The following packages have unmet dependencies:
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.24-1~dotdeb.1) but 5.5.25-1~dotdeb.0 is installed
E: Unmet dependencies. Try using -f.
Reading package lists… Done
Building dependency tree
Reading state information… Done
You might want to run ‘apt-get -f install’ to correct these.
The following packages have unmet dependencies:
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.24-1~dotdeb.1) but 5.5.25-1~dotdeb.0 is installed

Ideas?
Jason

@Jason Weir : you repositories infos seem to be outdated. Please run “apt-get update” (or any aptitude/dselect/synaptic equivalent) before upgrading your packages.

I always run apt-get update first… Tried again – got same message..

-J

Same for me.
apt-get update && apt-get upgrade
Give me :
=

Unpacking replacement mysql-server-5.5 …
dpkg: error processing /var/cache/apt/archives/mysql-server-5.5_5.5.25-1~dotdeb.0_amd64.deb (–unpack):
trying to overwrite ‘/usr/lib/mysql/plugin/ha_example.so’, which is also in package libmysqlclient-dev 5.5.24-1~dotdeb.1
configured to not write apport reports
dpkg-deb: subprocess paste killed by signal (Broken pipe)
Stopping MySQL database server: mysqld.
Starting MySQL database server: mysqld ..
Checking for tables which need an upgrade, are corrupt or were

Processing triggers for man-db …
Errors were encountered while processing:
/var/cache/apt/archives/mysql-server-5.5_5.5.25-1~dotdeb.0_amd64.deb
==

After running another apt-get update:
==

You might want to run ‘apt-get -f install’ to correct these.
The following packages have unmet dependencies:
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.24-1~dotdeb.1) but 5.5.25-1~dotdeb.0 is installed
E: Unmet dependencies. Try using -f.
==

MySQL is still working fine, so I didn’t try this operation.

apt-get remove –purge libmysqlclient-dev
Give me this :

The following packages have unmet dependencies:
libmysql++-dev : Depends: libmysqlclient15-dev
libmysqld-dev : Depends: libmysqlclient-dev (>= 5.5.25-1~dotdeb.0) but it is not going to be installed
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.24-1~dotdeb.1) but 5.5.25-1~dotdeb.0 is to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).
===

apt-get -f install
fix the problem.
So I don’t know where was the problem.
Usually apt-get -f install broke a lot of stuff, not this time 😉

Thanks you for your time and your packages.

>By Guillaume Plessis on Jun 6, 2012 | Reply
>
>Could you please try to uninstall libmysqlclient-dev before any further upgrade?

gives the same message…

Jason

#apt-get remove libmysqlclient-dev

Reading package lists… Done
Building dependency tree

Reading state information… Done
You might want to run ‘apt-get -f install’ to correct these:
The following packages have unmet dependencies:
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.24-1~dotdeb.1) but 5.5.25-1~dotdeb.0 is to be installed
E: Unmet dependencies. Try ‘apt-get -f install’ with no packages (or specify a solution).

Thank you for updating, Guillaume! Due to the above comments I will try apt-get upgrade -s first… 😉

Getting the same errors as the people above. I don’t really dare to force the install, in case something might break.

I’ve been getting ERROR 2003 (HY000) when connecting from a remote host ever since I upgraded. Not sure why… my iptables are still setup and nothing else has changed. telneting also times out.

@mrbradeli : are you sure that “skip-networking” is commented in /etc/mysql/my.cnf and that “bind-address” is set at a good value.

Which version did you upgrade from?

i’m getting same type errors as others. unfortunately no matter what i do, it just stays there. below are the package version, seems mismatched… any ideas?

# dpkg -l |grep mysql
ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database
ii libmysqlclient-dev 5.5.23-1~dotdeb.0 MySQL database development files
ii libmysqlclient16 5.1.61-2~dotdeb.0 MySQL database client library
ii libmysqlclient18 5.5.23-1~dotdeb.0 MySQL database client library
iU mysql-client-5.5 5.5.25-1~dotdeb.0 MySQL database client binaries
ii mysql-common 5.5.25-1~dotdeb.0 MySQL database common files, e.g. /etc/mysql/my.cnf
iU mysql-server 5.5.25-1~dotdeb.0 MySQL database server (metapackage depending on the latest version)
ii mysql-server-5.5 5.5.23-1~dotdeb.0 MySQL database server binaries and system database setup
iU mysql-server-core-5.5 5.5.25-1~dotdeb.0 MySQL database server binaries
ii php5-mysql 5.3.10-1~dotdeb.1 MySQL module for php5
ii python-mysqldb 1.2.2-10+b1 A Python interface to MySQL

I had the same issue other people here were having. I found that I had an invalid option in the my.cf file

[mysqld]
set-variable=local-infile=0

That should be

[mysqld]
local-infile=0

After changing that MySQL started fine and aptitude finished successfully.

If anyone else is having issues then try running mysqld from the command line and see if it throws any error messages.

FYI apt-get -f upgrade installs the latest mysql server version and gets rid of the dependency errors..

-J

there is a bug in this version, that can cause innodb-tables to use all diskspace.
http://bugs.mysql.com/65745

It has a workaround:

SET GLOBAL optimizer_switch = ‘index_merge=off’;

So it would be better to stay on 5.5.24 and update only to newer Version where the bug is fixed. 5.5.25a should solve this if it gets GA-status.

Hi,

After a fresh installation to debian 6.0.5 and Mysql 5.5.25, i see that cpu high load for mysqld.
I used the command “top” :

PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMANDE
2697 mysql 20 0 427m 183m 8184 s 88 3.0 2162:28 myslqd

There is nothing else on this machine.

best regards

@Guillaume
Because of the innodb-tables bug mentioned by Meik, is there any release date for MySQL 5.5.25a on the dotdeb repository?

Comments are closed.