MySQL 5.5.25

June 5, 2012 · Guillaume Plessis

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.

Parsec June 6, 2012
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 June 6, 2012
  @Parsec : your problem comes from virtuzo, not from mysql
b.miguel11 June 6, 2012
@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?
Jason Weir June 6, 2012
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
Guillaume Plessis June 6, 2012
@Jason Weir : you repositories infos seem to be outdated. Please run “apt-get update” (or any aptitude/dselect/synaptic equivalent) before upgrading your packages.
Jason Weir June 6, 2012
I always run apt-get update first… Tried again - got same message..
-J
Boris June 6, 2012
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.
Guillaume Plessis June 6, 2012
Could you please try to uninstall libmysqlclient-dev before any further upgrade?
Boris June 6, 2012
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.
Jason Weir June 6, 2012
>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).
Jockl June 7, 2012
Thank you for updating, Guillaume! Due to the above comments I will try apt-get upgrade -s first… ;)
NanoG6 June 7, 2012
I’ve upgraded mine successfully, no problem at all.
Alex June 8, 2012
Getting the same errors as the people above. I don’t really dare to force the install, in case something might break.
Jockl June 9, 2012
Finally, everything went well! :)
mrbradeli June 10, 2012
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.
Guillaume Plessis June 11, 2012
@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?
terii June 16, 2012
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
terii June 17, 2012
Ran “dpkg -r –force-depends libmysqlclient-dev” to fix the problem.
Andrew June 18, 2012
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.
Jason Weir June 18, 2012
FYI apt-get -f upgrade installs the latest mysql server version and gets rid of the dependency errors..
-J
Meik July 1, 2012
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.
Jérémy July 5, 2012
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 Plessis July 5, 2012
  @Jérémy : if your machine hasn’t been restarted since last saturday, this is certainly the leap second side effect. Here is the fix : http://blog.mozilla.org/it/2012/06/30/mysql-and-the-leap-second-high-cpu-and-the-fix/
HV July 9, 2012
@Guillaume Because of the innodb-tables bug mentioned by Meik, is there any release date for MySQL 5.5.25a on the dotdeb repository?

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

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-1dotdeb.1) but 5.5.25-1dotdeb.0 is installed E: Unmet dependencies. Try using -f.

dpkg -l |grep mysql