Posted by & filed under MySQL.

MySQL 5.1.46 is now available on Dotdeb for your Lenny servers, in amd64 and i386 flavours. It fixes a lot of annoying bugs and upgrades the InnoDB plugin to version 1.0.7 for more performances.

Be careful : the MySQL server is now split in two separate packages :

  • mysql-server-core-5.1 that contains only the mysqld binary and some system files,
  • mysql-server-5.1 that depends on mysql-server-core-5.1 and that contains the init scripts and utilities to run the MySQL server in a Debian environment.

The migration to this new packaging schema is transparent and will not break any dependencies.

As usual, please read the changes in MySQL 5.1.46 and what’s new in the InnoDB plugin 1.0.7 before upgrading.

9 Responses to “MySQL 5.1.46 is now available”

  1. littlecho

    Hello,
    While I upgrade to the version 5.1.46, I get a notice about “Your PHP MySQL library version 5.0.51a differs from your MySQL server version 5.1.45.” from phpmyamdin.
    Can you give me some idea to fixed this warning msg?

  2. Guillaume Plessis

    @littleecho : They are PHP client-side pieces of information. PHP is built against the old libmysqlclient15off (5.0.51a) to avoid Apache-related issues and segfaults.
    Anyway, 5.0.51a-linked clients interacts with a 5.1.46 server without any issue. Just tweak PHPMyAdmin to avoid the display.

  3. Sorin

    I tried today to update to the new version:

    Preparing to replace mysql-server-5.1 5.1.45-0.dotdeb.0 (using …/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb) …
    Stopping MySQL database server: mysqld failed!
    invoke-rc.d: initscript mysql, action “stop” failed.
    dpkg: warning – old pre-removal script returned error exit status 1
    dpkg – trying script from the new package instead …
    Stopping MySQL database server: mysqld failed!
    invoke-rc.d: initscript mysql, action “stop” failed.
    dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack):
    subprocess new pre-removal script returned error exit status 1
    Stopping MySQL database server: mysqld failed!
    invoke-rc.d: initscript mysql, action “stop” failed.
    Starting MySQL database server: mysqld already running.
    dpkg: regarding …/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb containing mysql-server-core-5.1:
    mysql-server-core-5.1 conflicts with mysql-server-5.1 (<< 5.1.45-2)
    mysql-server-5.1 (version 5.1.45-0.dotdeb.0) is present and installed.
    dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack):
    conflicting packages – not installing mysql-server-core-5.1
    Errors were encountered while processing:
    /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb
    /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb
    E: Sub-process /usr/bin/dpkg returned an error code (1)
    A package failed to install. Trying to recover.

    Any solution to this ?

  4. Guillaume Plessis

    Strange. Follow these steps :

    Stop MySQL manually :/etc/init.d/mysql stop
    Place an exit 0 at the beginning of /etc/init.d/mysql
    Try to upgrade
    Remove the previously-inserted exit 0

  5. Import Worker

    Preparing to replace mysql-server-5.1 5.1.45-0.dotdeb.0 (using …/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb) …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: warning – old pre-removal script returned error exit status 1dpkg – trying script from the new package instead …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): subprocess new pre-removal script returned error exit status 1Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.Starting MySQL database server: mysqld already running.dpkg: regarding …/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb containing mysql-server-core-5.1: mysql-server-core-5.1 conflicts with mysql-server-5.1 (<< 5.1.45-2) mysql-server-5.1 (version 5.1.45-0.dotdeb.0) is present and installed.dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): conflicting packages – not installing mysql-server-core-5.1Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.debE: Sub-process /usr/bin/dpkg returned an error code (1)A package failed to install. Trying to recover.
    +1

  6. Guillaume Plessis

    @Import Worker : as written on the above comment :

    Follow these steps :

    Stop MySQL manually :/etc/init.d/mysql stop
    Place an exit 0 at the beginning of /etc/init.d/mysql
    Try to upgrade
    Remove the previously-inserted exit 0

  7. Steve

    Preparing to replace mysql-server-5.1 5.1.45-0.dotdeb.0 (using …/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb) …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: warning – old pre-removal script returned error exit status 1dpkg – trying script from the new package instead …Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.dpkg: error processing /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): subprocess new pre-removal script returned error exit status 1Stopping MySQL database server: mysqld failed!invoke-rc.d: initscript mysql, action “stop” failed.Starting MySQL database server: mysqld already running.dpkg: regarding …/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb containing mysql-server-core-5.1: mysql-server-core-5.1 conflicts with mysql-server-5.1 (<< 5.1.45-2) mysql-server-5.1 (version 5.1.45-0.dotdeb.0) is present and installed.dpkg: error processing /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.deb (–unpack): conflicting packages – not installing mysql-server-core-5.1Errors were encountered while processing: /var/cache/apt/archives/mysql-server-5.1_5.1.46-0.dotdeb.0_amd64.deb /var/cache/apt/archives/mysql-server-core-5.1_5.1.46-0.dotdeb.0_amd64.debE: Sub-process /usr/bin/dpkg returned an error code (1)A package failed to install. Trying to recover.
    +1

  8. Guillaume Plessis

    @Steve : Follow these steps…

    • Stop MySQL manually :/etc/init.d/mysql stop
    • Place an exit 0 at the beginning of /etc/init.d/mysql
    • Try to upgrade
    • Remove the previously-inserted exit 0