Categories
MySQL

MySQL 5.5.22

The packages of MySQL 5.5.22 are now available for Debian 6.0 “Squeeze” on both amd64 and i386 architectures with no major change except bug fixes.

As usual, please read carefully the full Changelogs of MySQL 5.5.21 and MySQL 5.5.22 before upgrading.

16 replies on “MySQL 5.5.22”

Hello,

Thanks for all the hard work. I am however encountering an issue after upgrading to this package. I was running 5.5.20 prior to upgrading and had 1 master 2 slaves using semisynchronous replication. After upgrading all was well and is still working on these boxes.

The problem I am running into is that I am trying to add a slave to the group and unfortunately after importing the data and trying to start the slave I am getting errors about duplicate keys or unable to delete record errors. It’s like either the data from mysqldump is not complete, the master is reporting the wrong position, or it’s not importing the data correctly.

I thought this might be a case of some update happening to the master between displaying the log file and dumping the data, so I turned off all the boxes, changed the port on the master, and locked all the tables just to make sure there were no changes going on… but unfortunately this did not work.

Is this a possible bug in 5.5.22?

Thanks again,
Westin

@Guillaume – Thanks for the quick response. It actually looks like flush tables isn’t really flushing the tables. I noticed that once I had locked the tables and then did the mysqldump the log pos changed quite dramatically. Using this new log pos everything came up as expected.

Thanks again for all your hard work and helping to keep our systems up to date. It is appreciated.

Westin

But you are helping. If it wasn’t for all you do I’d still be using stock packages of mysql with out semisynchronous replication. Besides, I’m sure this will be fixed in the next dot release which I will be able to grab shortly after it’s available thanks to dotdeb. 😀

hello,

when installed mysql, I met the following errro:

# apt-get install libmysqlclient-dev mysql-client-5.5 mysql-server-5.5 mysql-common
Reading package lists… Done
Building dependency tree
Reading state information… Done
mysql-common is already the newest version.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
mysql-client-5.5 : Depends: libdbi-perl but it is not going to be installed
Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed
mysql-server-5.5 : Depends: libdbi-perl but it is not going to be installed
E: Broken packages

# apt-get install libmysqlclient-dev mysql-client-5.5 mysql-server-5.5 mysql-common libdbi-perl libdbd-mysql-perl
Reading package lists… Done
Building dependency tree
Reading state information… Done
mysql-common is already the newest version.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
libdbd-mysql-perl : Depends: perlapi-5.10.1
libdbi-perl : Depends: perlapi-5.10.1
E: Broken packages

# apt-get install libmysqlclient-dev mysql-client-5.5 mysql-server-5.5 mysql-common libdbi-perl libdbd-mysql-perl perlapi-5.10.1
Reading package lists… Done
Building dependency tree
Reading state information… Done
Package perlapi-5.10.1 is a virtual package provided by:
perl-base 5.10.1-17squeeze2 [Not candidate version]
perl-base 5.10.1-17squeeze3 [Not candidate version]

E: Package ‘perlapi-5.10.1’ has no installation candidate

# apt-get install libmysqlclient-dev mysql-client-5.5 mysql-server-5.5 mysql-common libdbi-perl libdbd-mysql-perl perl-base
Reading package lists… Done
Building dependency tree
Reading state information… Done
mysql-common is already the newest version.
perl-base is already the newest version.
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
libdbd-mysql-perl : Depends: perlapi-5.10.1
libdbi-perl : Depends: perlapi-5.10.1
E: Broken packages

The content of the /etc/apt/sources.list file :

# cat /etc/apt/sources.list
deb http://apt.x.netease.com:8660/data/debian/ stable main contrib non-free
deb http://apt.x.netease.com:8660/data/debian-security stable/updates main contrib non-free
deb http://packages.dotdeb.org stable all
deb-src http://packages.dotdeb.org stable all

@harvezh : first focus on installing libdbi-perl, then install MySQL 5.5. And use a decent package manager such as dselect, aptitude or synaptic to resolve your dependencies

By Post Author

@Guillaume: thank you
It is my bad. The perl-base package was upgraded unexpectedly to the version in debian testing.

Hello,

Thank you for your hard work and making these updates available.

Are there any plans to update the pinba-mysql-engine package – this seems tied to MySQL 5.1.61-2~dotdeb at the moment – which makes installation of pinba awkward.

David.

@David Goodwin : I’ll update it soon. FYI building external storage engine is currently discussed in MySQL mailing lists, I hope it will be easier in a near future. Stay tuned 🙂

By Post Author

Hello,
i want to install apt-get install mysql-client-5.1 mysql-server-5.1 on debian . but below error i am getting for dependencies as below
——————————————————————————————————————
The following packages have unmet dependencies:
mysql-client-5.1 : Depends: libdbi-perl but it is not going to be installed
Depends: libdbd-mysql-perl (>= 1.2202) but it is not going to be installed
Depends: mysql-common (>= 5.1.73-1) but it is not going to be installed
Depends: libmysqlclient16 (>= 5.1.73-1) but it is not going to be installed
mysql-server-5.1 : Depends: libdbi-perl but it is not going to be installed
Depends: libmysqlclient16 (>= 5.1.21-1) but it is not going to be installed
PreDepends: mysql-common (>= 5.1.73-1) but it is not going to be installed

—————————————————————————————————————-

Can you please help me to come out of it.

Comments are closed.