MySQL 5.6.21 has been released on September 23rd, 2014, fixing 24 security issues and various bugs affecting previous versions.
Please read the full Changelog fore more details.
The corresponding packages are now available for Debian 7 “Wheezy”, on both amd64 and i386 architectures.
Note : Some people reported having difficulties upgrading from 5.6.19 to 5.6.21. If this is your case, prefer using apt-get dist-upgrade (or equivalent) instead of apt-get upgrade.
Same here too.
mysql-server-5.6 : Dépend: mysql-server-core-5.6 (= 5.6.19-1
dotdeb.1) mais 5.6.21-1dotdeb.1 est installéCould you please help me by taking a look at /var/log/mysql/error.log or /var/log/syslog, tell me if something specific to MySQL went wrong during the upgrade?
Paste the result in a gist. Your help is greatly appreciated.
As far as I can see, at least for me, this is stricly a dependancy error.
It tells me I have some dependancies not satisfied: mysql-server-5-6 depends on mysql-server-core-5.6 (= 5.6.19-1
dotdeb.1) But 5.6.21-1dotdeb.1 is installed.It won’t upgrade anything
dotdeb.1 i386 MySQL database client library ii mysql-client 5.6.21-1dotdeb.1 all MySQL database client (metapackage depending on the latest version) ii mysql-client-5.6 5.6.19-1dotdeb.1 i386 MySQL database client binaries ii mysql-client-core-5.6 5.6.21-1dotdeb.1 i386 MySQL database core client binaries ii mysql-common 5.6.21-1dotdeb.1 all MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.6.21-1dotdeb.1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-5.6 5.6.19-1dotdeb.1 i386 MySQL database server binaries and system database setup ii mysql-server-core-5.6 5.6.19-1dotdeb.1 i386 MySQL database server binaries ii php5-mysql 5.5.18-1~dotdeb.1 i386 MySQL module for php5 ii python-mysqldb 1.2.3-2 i386 Python interface to MySQLapt-get dist-upgrade seems to solve the “problem” (any explanation why ? :-) ). Below the results:
ii libdbd-mysql-perl 4.021-1+b1 i386 Perl5 database interface to the MySQL database ii libmysqlclient18:i386 5.6.21-1
dotdeb.1 i386 MySQL database client library ii mysql-client 5.6.21-1dotdeb.1 all MySQL database client (metapackage depending on the latest version) ii mysql-client-5.6 5.6.21-1dotdeb.1 i386 MySQL database client binaries ii mysql-client-core-5.6 5.6.21-1dotdeb.1 i386 MySQL database core client binaries ii mysql-common 5.6.21-1dotdeb.1 all MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.6.21-1dotdeb.1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-5.6 5.6.21-1dotdeb.1 i386 MySQL database server binaries and system database setup ii mysql-server-core-5.6 5.6.21-1dotdeb.1 i386 MySQL database server binaries ii php5-mysql 5.5.18-1~dotdeb.1 i386 MySQL module for php5 ii python-mysqldb 1.2.3-2 i386 Python interface to MySQLConfirmed. Even if the upgrade process finishes with no errors, I still have 5.6.19. Phpmyadmin reads:
Server version: 5.6.19-1~dotdeb.1 - (Debian) Database client version: libmysql - 5.6.19.
My apt-get log:
Log started: 2014-10-29 12:33:14 (Reading database … 20696 files and directories currently installed.) Preparing to replace mysql-common 5.6.19-1
dotdeb.1 (using …/mysql-common_5.6.21-1dotdeb.1_all.deb) … Unpacking replacement mysql-common … Preparing to replace libmysqlclient18:i386 5.6.19-1dotdeb.1 (using …/libmysqlclient18_5.6.21-1dotdeb.1_i386.deb) … Unpacking replacement libmysqlclient18:i386 … Preparing to replace mysql-client 5.6.19-1dotdeb.1 (using …/mysql-client_5.6.21-1dotdeb.1_all.deb) … Unpacking replacement mysql-client … Preparing to replace mysql-client-core-5.6 5.6.19-1dotdeb.1 (using …/mysql-client-core-5.6_5.6.21-1dotdeb.1_i386.deb) … Unpacking replacement mysql-client-core-5.6 … Preparing to replace mysql-server 5.6.19-1dotdeb.1 (using …/mysql-server_5.6.21-1dotdeb.1_all.deb) … Unpacking replacement mysql-server … Processing triggers for man-db … Setting up mysql-common (5.6.21-1dotdeb.1) … Installing new version of config file /etc/mysql/my.cnf … Setting up libmysqlclient18:i386 (5.6.21-1dotdeb.1) … Setting up mysql-client (5.6.21-1dotdeb.1) … Setting up mysql-client-core-5.6 (5.6.21-1dotdeb.1) … Setting up mysql-server (5.6.21-1~dotdeb.1) … Log ended: 2014-10-29 12:33:24BTW: apt-get upgrade show that such packages were upgraded but others were keeped at current version (didn’t remeber exactly since I erased that part of the log)
following my previous comment, apt-get upgrade says:
The following packages have been kept back: mysql-client-5.6 mysql-server-5.6 mysql-server-core-5.6 0 upgraded, 0 newly installed, 0 to remove and 3 not upgraded.
dotdeb.1 i386 MySQL database client library ii mysql-client-5.5 5.5.40-0+wheezy1 i386 MySQL database client binaries ii mysql-client-5.6 5.6.19-1dotdeb.1 i386 MySQL database client binaries ii mysql-client-core-5.6 5.6.19-1dotdeb.1 i386 MySQL database core client binaries ii mysql-common 5.6.21-1dotdeb.1 all MySQL database common files, e.g. /etc/mysql/my.cnf ii mysql-server 5.6.21-1dotdeb.1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-5.6 5.6.19-1dotdeb.1 i386 MySQL database server binaries and system database setup ii mysql-server-core-5.6 5.6.19-1dotdeb.1 i386 MySQL database server binaries ii php5-mysql 5.4.34-1dotdeb.1 i386 MySQL module for php5 ii python-mysqldb 1.2.3-2 i386 Python interface to MySQLI tried apt-get dist-upgrade and am getting this result:
apt-get dist-upgrade -u Reading package lists… Done Building dependency tree Reading state information… Done Calculating upgrade… Done The following NEW packages will be installed: mysql-common-5.6 The following packages will be upgraded: mysql-client mysql-server mysql-server-5.6 mysql-server-core-5.6 4 upgraded, 1 newly installed, 0 to remove and 0 not upgraded. 6 not fully installed or removed. Need to get 0 B/22.0 MB of archives. After this operation, 4610 kB disk space will be freed. Do you want to continue [Y/n]?
Y =>
Unpacking replacement mysql-client-5.6 … Processing triggers for man-db … Use of uninitialized value in concatenation (.) or string at /usr/share/perl5/Debconf/DbDriver/File.pm line 44, chunk 3. Use of uninitialized value in -e at /usr/share/perl5/Debconf/DbDriver/File.pm line 46, chunk 3. Use of uninitialized value in pattern match (m//) at /usr/share/perl5/Debconf/DbDriver/File.pm line 47, chunk 3. Use of uninitialized value $directory in -d at /usr/share/perl5/Debconf/DbDriver/File.pm line 48, chunk 3. Use of uninitialized value $directory in concatenation (.) or string at /usr/share/perl5/Debconf/DbDriver/File.pm line 49, chunk 3. debconf: DbDriver “config”: mkdir :No such file or directory dpkg: error processing man-db (–unpack): subprocess installed post-installation script returned error exit status 1 Errors were encountered while processing: man-db E: Sub-process /usr/bin/dpkg returned an error code (1)
oot@server:
# dpkg -l ‘mysql’ | grep ‘^.i’ ii libdbd-mysql-perl 4.021-1+b1 amd64 Perl5 database interface to the MySQL database ii mysql-client 5.6.19-1dotdeb.1 all MySQL database client (metapackage depending on the latest version) ii mysql-server 5.6.19-1dotdeb.1 all MySQL database server (metapackage depending on the latest version) ii mysql-server-5.6 5.6.19-1dotdeb.1 amd64 MySQL database server binaries and system database setup ii mysql-server-core-5.6 5.6.19-1dotdeb.1 amd64 MySQL database server binaries ii mysqltuner 1.2.0-1 all high-performance MySQL tuning script ii php5-mysqlnd 5.4.34-1dotdeb.1 amd64 MySQL module for php5 (Native Driver)Aptitude shows me no upgrade possibility to MySQL 5.6.21 at all.
I am using http://packages.dotdeb.org wheezy-php55 all
to correctly update I had to
apt-get update apt-get dist-upgrade
apt-get install mysql-server (which was uninstalled by dist upgrade and prevented upgrade of packages mysql-server and mysql-server-core)
This on a fresh debian install.
For me:
aptitude upgrade
works fine!
Upgrading worked fine for me with dist-upgrade
But now after upgrade my CPU utilization went through the roof. It maxed out at 100% so I had to increase the number of cores, now two cores at 70%.
I look at my Munin stats and it seems like at the same time the CPU went to 100% the number of mysql queries just increased dramtically.
This happend just a few hours after I upgraded mysql on my server. Any idea for why that is or how I could solve it?
Running top or ps aux show almost no use of the CPU what so ever.
ulimit ‘open files’ and MySQL ‘open_files_limit’ … How to set permanently the limit of open files and MySQL open_files_limit but i set the limit in my.cnf and limits.conf but after restart server the limit is restored to default 1024.
Thanks you.