Posted by & filed under MySQL.

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 Responses to “MySQL 5.5.22”

  1. Westin Shafer

    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

  2. Westin Shafer

    @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

  3. Westin Shafer

    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. 😀

  4. harvezh

    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

  5. Guillaume Plessis

    @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

  6. harvezh

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

  7. Aris S. Ripandi

    before i want to say thank you for your job. i had use this repository for my own VPS. But, can i request repo for MongoDB?

    thanks

  8. David Goodwin

    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.

  9. Guillaume Plessis

    @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 🙂

  10. Sandeep

    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.