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 replies on “Critical update : MySQL 5.5.25a”
what has changed between dotdeb.0 and dotdeb.1?
@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.
I see. TY.
Why do I need gdb and gdbserver packages? They are dependencies.
@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.
I’ve tried to install on Ubuntu 11.04 but it required Initscripts 2.88 (Ubuntu 11.04 is using 2.87) 🙁
@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 🙂
@voro1984 MySQL 5.5.25 worked fine on Ubuntu 11.04 😀 It’s ok because dotdeb is not designed fro Ubuntu 😀
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
Sorry, my mistake. 🙁
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?
@Sergey : just make the libmysqlclient18 dependency less restrictive for your freeradius-mysql package by editing your debian/control. Then rebuild it.
You will update MySQL to 6.0+?
@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.
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 !
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
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.