Posted by & filed under MySQL.

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 Responses to “MySQL 5.5.25”

  1. Parsec

    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..
    ======================

    Reply
  2. b.miguel11

    @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?

    Reply
  3. Jason Weir

    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

    Reply
  4. Guillaume Plessis

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

    Reply
  5. Jason Weir

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

    -J

    Reply
  6. Boris

    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.

    Reply
  7. Boris

    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.

    Reply
  8. Jason Weir

    >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).

    Reply
  9. Jockl

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

    Reply
  10. Alex

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

    Reply
  11. mrbradeli

    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.

    Reply
  12. Guillaume Plessis

    @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?

    Reply
  13. terii

    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

    Reply
  14. Andrew

    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.

    Reply
  15. Jason Weir

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

    -J

    Reply
  16. Meik

    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.

    Reply
  17. Jérémy

    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

    Reply
  18. HV

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

    Reply

Leave a Reply

  • (will not be published)


three × = 21