Emergency

Recall of Percona Server 5.1.47-11.0



PREVIOUS POST
NEXT POST

Percona Server release 11.0 which we announced few days ago unfortunately was released with a bug introduced while implementing stripping comments in query cache which could cause server crash with certain types of queries if query cache is enabled. We have released Percona Server release 11.1 which includes a fix for this issue. If you can’t perform upgrade promptly you can disable query cache until you can do this.

We’re sorry for shipping release with such bug.

The issue with this bug in more details is as follows:
MySQL Query Cache works by checking incoming queries if they may be found in query cache – this is done by performing simple check if query is starting from SEL or comment. After Query is parsed and executed MySQL stores results for SELECT queries in Query Cache. There are cases when queries will not be considered as cachable query during first check, however result for them will be stored in the query cache. This rare case was not handled properly in the new feature added and it was causing MySQL to crash.

The most typical case for queries causing issues would be queries starting with brackets and having space before select such as ( select * from t1 ) Queries starting with brackets are often used with UNION queries.

PREVIOUS POST
NEXT POST
Tags:

, , ,

Categories:
Percona Software


Comments

  • Just to be clear, will this only be an issue if we set query_cache_strip_comments=on? If we stick with default value, then this bug should not have an affect?

    Thanks for the quick update.

    Gary

  • Gary,

    Unfortunately this is NOT the case. Anyone with query cache enabled running these specific query types if affected.

  • Ok, that is odd, I could not reproduce on our production server. However we updated anyhow. Thanks for the info.

  • Gary,

    It would not crash for every query only for some. It is great if it does not crash for you. Bug report contains repeatable example (which was added to test suite to trigger the crash

  • Thanks for the heads up, last week we started seeing this type of crashing behavior on our database servers after they were upgraded to the latest Percona build. I could not for the life of me figure out why certain servers were crashing more often than others, but the query caching issue seems to explain it perfectly. We just downgraded our servers to a previous build and that seemed to fix the issue.

    That will teach me to leave a Yum repo enabled :)

  • Gary – did you try with space after first “(” ? This is what caused problems things like (select 1) worked OK

  • Here is the bug filed with MySQL on this issue which in the end was exposed as crash with this patch
    http://bugs.mysql.com/bug.php?id=55032

  • [root@sql-poll ~]# yum install Percona-Server-shared-compat
    Loaded plugins: fastestmirror
    Loading mirror speeds from cached hostfile
    * addons: mirror.vcu.edu
    * base: centos.mirror.nac.net
    * epel: mirror.ipnode.info
    * extras: mirrors.rit.edu
    * updates: mirror.cogentco.com
    Setting up Install Process
    Resolving Dependencies
    –> Running transaction check
    —> Package Percona-Server-shared-compat.x86_64 0:5.1.43-3 set to be updated
    –> Finished Dependency Resolution

    Dependencies Resolved

    ======================================================================================================================================
    Package Arch Version Repository Size
    ======================================================================================================================================
    Installing:
    Percona-Server-shared-compat x86_64 5.1.43-3 percona 4.9 M

    Transaction Summary
    ======================================================================================================================================
    Install 1 Package(s)
    Update 0 Package(s)
    Remove 0 Package(s)

    Total size: 4.9 M
    Is this ok [y/N]: y
    Downloading Packages:
    Running rpm_check_debug
    Running Transaction Test
    Finished Transaction Test

    Transaction Check Error:
    file /usr/lib64/libmysqlclient.so.16.0.0 from install of Percona-Server-shared-compat-5.1.43-3.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.47-rel11.2.53.rhel5.x86_64
    file /usr/lib64/libmysqlclient_r.so.16.0.0 from install of Percona-Server-shared-compat-5.1.43-3.x86_64 conflicts with file from package Percona-Server-shared-51-5.1.47-rel11.2.53.rhel5.x86_64

    Error Summary
    ————-

  • Jim,

    Please do not use commits to report “bugs” there is bugs database for that on launchpad:
    https://bugs.launchpad.net/percona-server/+filebug

    It looks like name for package is changed so you better to leave old package or remove it and install new one.

  • Aleksandr Kuzminsky

    Jim,

    New version of Percona-Server-shared-compat is uploaded. This issue is fixed in it.
    Could you please try?

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">