Critical update : MySQL 5.5.25a

July 10, 2012 · Guillaume Plessis

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.

voro1984 July 10, 2012
what has changed between dotdeb.0 and dotdeb.1?
- Guillaume Plessis July 10, 2012
  @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.
voro1984 July 10, 2012
I see. TY.
Matic July 10, 2012
Why do I need gdb and gdbserver packages? They are dependencies.
- Guillaume Plessis July 11, 2012
  @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.
Giang July 14, 2012
I’ve tried to install on Ubuntu 11.04 but it required Initscripts 2.88 (Ubuntu 11.04 is using 2.87) :(
voro1984 July 16, 2012
@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 :)
Giang July 17, 2012
@voro1984 MySQL 5.5.25 worked fine on Ubuntu 11.04 :D It’s ok because dotdeb is not designed fro Ubuntu :D
Ondra42 July 19, 2012
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
Ondra42 July 19, 2012
Sorry, my mistake. :(
Sergey July 21, 2012
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?
Guillaume Plessis July 21, 2012
@Sergey : just make the libmysqlclient18 dependency less restrictive for your freeradius-mysql package by editing your debian/control. Then rebuild it.
Lincoln Marques July 28, 2012
You will update MySQL to 6.0+?
- Guillaume Plessis July 28, 2012
  @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.
MasterBotWeb August 4, 2012
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-1dotdeb.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-1dotdeb.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 !
MasterBotWeb August 5, 2012
The result this command : dpkg -l |grep php
ii libapache2-mod-php5 5.4.5-1dotdeb.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-1dotdeb.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
MasterBotWeb August 5, 2012
My problem is solved on Debian Squeeze/Sid !!! :D 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.