MySQL 5.5.31 for Squeeze

Hello everyone,

I’m trying to switch from 5.1 to: 5.5 mysql and get this error:
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
invoke-rc.d: initscript mysql, action “start” failed.
dpkg: error processing mysql-server-5.5 (–configure):
subprocess installed post-installation script returned error exit status 1
configured to not write apport reports
dpkg: dependency problems prevent configuration of mysql-server:
mysql-server depends on mysql-server-5.5; however:
Package mysql-server-5.5 is not configured yet.
dpkg: error processing mysql-server (–configure):
dependency problems – leaving unconfigured
configured to not write apport reports
Errors were encountered while processing:
mysql-server-5.5
mysql-server
E: Sub-process /usr/bin/dpkg returned an error code (1)

Not sure what I’m missing since logs/mysql.log and logs/mysql.err are empty …

@huglester : MySQL errors go to /var/log/syslog. Take a look at it, you’ll know why your server won’t start

Guillaume thanks for help. Indeed it helped. Had my custom mysql config with some options already not supported, removed it temporary and now it is ok 🙂

By the way, what would be the best to get the default config of mysql 5.5 in todteb repo? Download deb file and extract config? or is there a clearer way?

Because I would like to replace my 5.1 config with default 5.5 and start modifying it ..

@huglester check default conf files at

/usr/share/doc/mysql-server-5.5/examples/my-huge.cnf.gz
/usr/share/doc/mysql-server-5.5/examples/my-innodb-heavy-4G.cnf.gz
/usr/share/doc/mysql-server-5.5/examples/my-large.cnf.gz
/usr/share/doc/mysql-server-5.5/examples/my-medium.cnf.gz
/usr/share/doc/mysql-server-5.5/examples/my-small.cnf

Just today set up a new server with Nginx, MySQL and PHP on Debian Squeeze by using dotdeb repositories.

Is there a problem with having PHP MySQL client API v5.1.66 while dotdeb gave me MySQL v5.5.31?

Installed packages:

php-pear 5.4.15-1~dotdeb.1
php5-apc 5.4.15-1~dotdeb.1
php5-cli 5.4.15-1~dotdeb.1
php5-common 5.4.15-1~dotdeb.1
php5-curl 5.4.15-1~dotdeb.1
php5-dev 5.4.15-1~dotdeb.1
php5-fpm 5.4.15-1~dotdeb.1
php5-gd 5.4.15-1~dotdeb.1
php5-imagick 5.4.15-1~dotdeb.1
php5-intl 5.4.15-1~dotdeb.1
php5-mcrypt 5.4.15-1~dotdeb.1
php5-mysql 5.4.15-1~dotdeb.1
php5-sqlite 5.4.15-1~dotdeb.1

mysql-client-5.5 5.5.31-1~dotdeb.0
mysql-client-core-5.5 5.5.31-1~dotdeb.0
mysql-common 5.5.31-1~dotdeb.0
mysql-server-5.5 5.5.31-1~dotdeb.0
mysql-server-core-5.5 5.5.31-1~dotdeb.0

Kind regards,
razorness

@razorness : no problem with that. PHP is built against 5.1.66 to avoid segfaults and duplicate symbols when loaded with other MySQL-linked pieces of software. If you want to get rid of warnings, install php5-mysqlnd instead of php5-mysql

Thank you for your fast and good response.

Done it with php5-msqlnd. 🙂

Can you add MariaDB to your fine repository? MySQL seems no longer 100% to be free.

http://bugs.mysql.com/bug.php?id=69512

Of course, they say its a bug, but is it?

Hi Guillaume
Thank you for all your hard work. Just tried to upgrade my squeeze distro and it gives me following:
The following packages have unmet dependencies:
mysql-client-core-5.5 : Breaks: mysql-client-5.5 (< 5.5.31-1~dotdeb.0) but 5.5.30-1~dotdeb.0 is installed

Any ideas?
Thanks

Denis

@Denis : As said on this page (http://localhost:8080/2013/05/05/debian-7-0-wheezy-has-been-released/), the following list of commands should help you :

apt-get -f install -o Dpkg::Options::=”–force-overwrite”
apt-get remove mysql-client-core-5.5
apt-get dist-upgrade

Thanks for the answer – I was thinking of staying on squeeze, but I guess that is not an option? Sorry, probably being more dense than I ought to be, but backup has finished so I will give it a go.
Thanks

Denis

Having trouble upgrading from mysql 5.1:

The following packages have been kept back:
mysql-server
0 upgraded, 0 newly installed, 0 to remove and 1 not upgraded.

…
The following packages have unmet dependencies:
mysql-server : Depends: mysql-server-5.5 but it is not going to be installed
E: Broken packages

The following packages have unmet dependencies:
mysql-server-5.5 : Depends: mysql-server-core-5.5 (= 5.5.31-1~dotdeb.0) but it is not going to be installed
E: Broken packages

The following packages have unmet dependencies:
mysql-server-core-5.5 : Depends: libaio1 but it is not installable
E: Broken packages

Any chance to get 5.5.34 for Squeeze?

@Kenn Ejima : sorry, no, you’ll have to upgrade to Wheezy

@Guillaume

Is Dotdeb v5.5.34 out?

Hi Guillaume,
always no plans for MySQL 5.6?
The 5.6.7 version is the first who is correcting Bug #62429 http://bugs.mysql.com/bug.php?id=62429
I have try this versions :
— 5.1.61-community-log
— 5.5.20-log
— 5.5.33-log
— 5.5.33a-MariaDB
— 10.0.4-MariaDB
And MariaDB is also not patching the issue.

@immobilia : still working on it, sorry. My job doesn’t let me as much spare time as before.

There is any problem, your job is already a great help for Debian deployments. And thx for that!
In the meantime I use an alternative solution deported on programing language, and I stay with 5.1 MySQL version in production, who seems to be faster than 5.5 and probably than the new 5.6 (at least for MyISAM).
Have good job, and after work, unfortunately time is not scalable …

Debian 6, MySql 5.1 -> 5.5

I had a same error:

@huglester:
“I’m trying to switch from 5.1 to: 5.5 mysql and get this error:
Starting MySQL database server: mysqld . . . . . . . . . . . . . . failed!
…
…”

Found @Guillaume Plessis’s anwer:
“MySQL errors go to /var/log/syslog. Take a look at it, you’ll know why your server won’t start”

In my syslog:
Oct 23 21:21:03 mysqld: 131023 21:21:03 InnoDB: The InnoDB memory heap is disabled
Oct 23 21:21:03 mysqld: 131023 21:21:03 InnoDB: Mutexes and rw_locks use GCC atomic builtins
Oct 23 21:21:03 mysqld: 131023 21:21:03 InnoDB: Compressed tables use zlib 1.2.3.4
Oct 23 21:21:03 mysqld: 131023 21:21:03 InnoDB: Using Linux native AIO
Oct 23 21:21:03 mysqld: 131023 21:21:03 InnoDB: Warning: io_setup() failed with EAGAIN. Will make 5 attempts before giving up.
Oct 23 21:21:03 mysqld: InnoDB: Warning: io_setup() attempt 1 failed.
Oct 23 21:21:03 mysqld: InnoDB: Warning: io_setup() attempt 2 failed.
Oct 23 21:21:04 mysqld: InnoDB: Warning: io_setup() attempt 3 failed.
Oct 23 21:21:04 mysqld: InnoDB: Warning: io_setup() attempt 4 failed.
Oct 23 21:21:05 mysqld: InnoDB: Warning: io_setup() attempt 5 failed.
Oct 23 21:21:05 mysqld: 131023 21:21:05 InnoDB: Error: io_setup() failed with EAGAIN after 5 attempts.
Oct 23 21:21:05 mysqld: InnoDB: You can disable Linux Native AIO by setting innodb_use_native_aio = 0 in my.cnf
Oct 23 21:21:05 mysqld: 131023 21:21:05 InnoDB: Fatal error: cannot initialize AIO sub-system
Oct 23 21:21:05 mysqld: 131023 21:21:05 [ERROR] Plugin ‘InnoDB’ init function returned error.
Oct 23 21:21:05 mysqld: 131023 21:21:05 [ERROR] Plugin ‘InnoDB’ registration as a STORAGE ENGINE failed.
Oct 23 21:21:05 mysqld: 131023 21:21:05 [ERROR] Unknown/unsupported storage engine: InnoDB
Oct 23 21:21:05 mysqld: 131023 21:21:05 [ERROR] Aborting
Oct 23 21:21:05 mysqld:
Oct 23 21:21:05 mysqld: 131023 21:21:05 [Note] /usr/sbin/mysqld: Shutdown complete
Oct 23 21:21:05 mysqld:
Oct 23 21:21:05 mysqld_safe: mysqld from pid file /var/run/mysqld/mysqld.pid ended
Oct 23 21:21:17 /etc/init.d/mysql[18366]: 0 processes alive and ‘/usr/bin/mysqladmin –defaults-file=/etc/mysql/debian.cnf ping’ result$
Oct 23 21:21:17 /etc/init.d/mysql[18366]: ^G/usr/bin/mysqladmin: connect to server at ‘localhost’ failed
Oct 23 21:21:17 /etc/init.d/mysql[18366]: error: ‘Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)’
Oct 23 21:21:17 /etc/init.d/mysql[18366]: Check that mysqld is running and that the socket: ‘/var/run/mysqld/mysqld.sock’ exists!

Added “setting innodb_use_native_aio = 0” in my.cnf
Restart mysql service. Success!
Guillaume thanks for help. : )

21 replies on “MySQL 5.5.31 for Squeeze”