Posted by & filed under MySQL.

The packages of MySQL 5.5.25a are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures. They fixes a very annoying bug on InnoDB : bug #65745, “UPDATE on InnoDB table enters recursion, eats all disk space”.

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

17 Responses to “Critical update : MySQL 5.5.25a”

  1. Guillaume Plessis

    @voro1984 : dotdeb.0 was à try to run mysqld_safe as mysql user. It brought potential trouble (with open_files_limit, for exemple). I’ve reverted this change.

  2. Matic

    Why do I need gdb and gdbserver packages? They are dependencies.

  3. Guillaume Plessis

    @Matic : I don’t think gdb and gdbserver are direct and explicit dependencies. Maybe they’re just recommendations for one package from the second dependency level. Please check it with a decent package manager (such as aptitude or deselect) that will allows you to fine-tune your package selection and to know why a package is needed.
    And in general, please avoid installing *-dev or *-dbg programs on a production server.

  4. Giang

    I’ve tried to install on Ubuntu 11.04 but it required Initscripts 2.88 (Ubuntu 11.04 is using 2.87) 🙁

  5. voro1984

    @Giang From About: “[…]The packages from Dotdeb should work on Ubuntu, but no additional support will be provided.”
    Also, ubuntu 11.10 has initscripts 2.88dsf-13.10ubuntu4 and LTS is 12.04, so I shouldn’t blame on Guillaume…
    Backport or upgrade 🙂

  6. Giang

    @voro1984 MySQL 5.5.25 worked fine on Ubuntu 11.04 😀 It’s ok because dotdeb is not designed fro Ubuntu 😀

  7. Ondra42

    Debian squeeze(6.0.5) + dotdeb , kernel 3.0.4 x86_64

    Can’t start mysql server after update. #fail :o(

    InnoDB: Error: space id and page n:o stored in the page
    InnoDB: Database page corruption on disk or a failed

  8. Sergey

    Hello

    Sorry for my clumsy English!

    Debian is installed squeeze 6.0.5

    Set of mysql from your repository server, then downloaded the freeradius version 2.1.12, compiled from the source through the dpkg-buildpackage, then trying to install freeradius-mysql.

    install:
    dpkg -i freeradius-mysql_2.1.12 + git_amd64.deb
    Selecting previously deselected package freeradius-of muscle
    (Reading database … currently installed 34515 files and directories.)
    Unpacking freeradius-mysql (from the file freeradius-mysql_2.1.12 + git_amd64.deb) …
    dpkg: dependency problems prevent configuration of freeradius-mysql:
    freeradius-mysql depends on libmysqlclient18 (> = 5.5.25a-1), but:
       Version of the system libmysqlclient18 5.5.25a-1 ~ dotdeb.1.
    dpkg: error processing freeradius-mysql (- install):

    dependency problems – leaving unconfigured
    When processing the following Errors were encountered:
      freeradius-mysql

    How to solve this problem?

  9. Guillaume Plessis

    @Sergey : just make the libmysqlclient18 dependency less restrictive for your freeradius-mysql package by editing your debian/control. Then rebuild it.

  10. Guillaume Plessis

    @Lincoln Marques : MySQL 6.0 does not exist. The next MySQL version release will be 5.6. Yes, I’ll keep on packaging it, in an Oracle or MariaDB flavour.

  11. MasterBotWeb

    Hello,

    OS : Debian Squeeze/Sid

    I update mysql-server without uninstalled the old version. It’s work but I have this message in phpMyadmin.

    “Your PHP MySQL library version 5.1.63 differs from your MySQL server version 5.5.25a. This may cause unpredictable behavior.”

    In the Shell :
    > dpkg -l |grep mysql
    ii libdbd-mysql-perl 4.016-1 Perl5 database interface to the MySQL database
    ii libmysql-java 5.1.10+dfsg-2 Java database (JDBC) driver for MySQL
    ii libmysqlclient-dev 5.5.25a-1~dotdeb.1 MySQL database development files
    ii libmysqlclient16 5.1.63-0+squeeze1 MySQL database client library
    ii libmysqlclient18 5.5.25a-1~dotdeb.1 MySQL database client library
    ii libmysqld-dev 5.5.25a-1~dotdeb.1 MySQL embedded database development files
    ii libmysqld-pic 5.5.25a-1~dotdeb.1 PIC version of MySQL embedded server development files
    ii mysql-client 5.5.25a-1~dotdeb.1 MySQL database client (metapackage depending on the latest version)
    ii mysql-client-5.5 5.5.25a-1~dotdeb.1 MySQL database client binaries
    ii mysql-client-core-5.5 5.5.25a-1~dotdeb.1 MySQL database core client binaries
    ii mysql-common 5.5.25a-1~dotdeb.1 MySQL database common files, e.g. /etc/mysql/my.cnf
    ii mysql-server 5.5.25a-1~dotdeb.1 MySQL database server (metapackage depending on the latest version)
    rc mysql-server-5.1 5.1.63-0+squeeze1 MySQL database server binaries and system database setup
    ii mysql-server-5.5 5.5.25a-1~dotdeb.1 MySQL database server binaries and system database setup
    ii mysql-server-core-5.5 5.5.25a-1~dotdeb.1 MySQL database server binaries
    ii php5-mysql 5.4.5-1~dotdeb.0 MySQL module for php5
    ii postfix-mysql 2.7.1-1+squeeze1 MySQL map support for Postfix
    ii pure-ftpd-mysql 1.0.28-3+squeeze1 Secure and efficient FTP server with MySQL user authentication

    Help me please for mysql-server used the library 5.5 !!

    Thanks you !

  12. MasterBotWeb

    The result this command : dpkg -l |grep php

    ii libapache2-mod-php5 5.4.5-1~dotdeb.0 server-side, HTML-embedded scripting language (Apache 2 module)
    ii libapache2-mod-suphp 0.7.1-1 Apache2 module to run php scripts with the owner permissions
    ii php-auth 1.6.2-1 PHP PEAR modules for creating an authentication system
    ii php-pear 5.4.5-1~dotdeb.0 PEAR – PHP Extension and Application Repository
    ii php5 5.4.5-1~dotdeb.0 server-side, HTML-embedded scripting language (metapackage)
    ii php5-cgi 5.4.5-1~dotdeb.0 server-side, HTML-embedded scripting language (CGI binary)
    ii php5-cli 5.4.5-1~dotdeb.0 command-line interpreter for the php5 scripting language
    ii php5-common 5.4.5-1~dotdeb.0 Common files for packages built from the php5 source
    ii php5-dbg 5.4.5-1~dotdeb.0 Debug symbols for PHP5
    ii php5-dev 5.4.5-1~dotdeb.0 Files for PHP5 module development
    ii php5-gd 5.4.5-1~dotdeb.0 GD module for php5
    ii php5-imagick 5.4.5-1~dotdeb.0 imagick module for php5
    ii php5-imap 5.4.5-1~dotdeb.0 IMAP module for php5
    ii php5-intl 5.4.5-1~dotdeb.0 internationalisation module for php5
    ii php5-mcrypt 5.4.5-1~dotdeb.0 MCrypt module for php5
    ii php5-mysql 5.4.5-1~dotdeb.0 MySQL module for php5
    ii php5-pgsql 5.4.5-1~dotdeb.0 PostgreSQL module for php5
    ii php5-sqlite 5.4.5-1~dotdeb.0 SQLite module for php5
    rc php5-suhosin 0.9.32.1-1 advanced protection module for php5
    ii php5-xdebug 5.4.5-1~dotdeb.0 xdebug module for php5
    ii php5-xhprof 5.4.5-1~dotdeb.0 xhprof module for php5
    ii php5-xsl 5.4.5-1~dotdeb.0 XSL module for php5
    ii phpmyadmin 4:3.3.7-7 MySQL web administration tool
    ii suphp-common 0.7.1-1 Common files for mod suphp

    But if you haven’t solution in this problem !
    How to remove this message in phpMyAdmin ?

    Thanks

  13. MasterBotWeb

    My problem is solved on Debian Squeeze/Sid !!! 😀
    This is the problem :
    “Your PHP MySQL library version 5.1.63 differs from your MySQL server version 5.5.25a. This may cause unpredictable behavior.”

    Solutions : Install php5-mysqlnd and download the last version of phpMyAdmin.

    #cd /root/
    #cp -R /usr/share/phpmyadmin/config.inc.php /root/config.inc.php
    #apt-get install php5-mysqlnd

    php5-mysqlnd remove automatically php5-mysql and phpMyAdmin

    #wget http://sourceforge.net/projects/phpmyadmin/files/phpMyAdmin/3.5.2.1/phpMyAdmin-3.5.2.1-all-languages.tar.gz
    #tar xvzf phpMyAdmin-3.5.2.1-all-languages.tar.gz
    #mv phpMyAdmin-3.5.2.1-all-languages /usr/share/phpmyadmin
    #cp -R config.inc.php /usr/share/phpmyadmin/config.inc.php

    Now I have not a message in my phpMyAdmin homepage after login and it’s work.