Percona Server moved to https://jira.percona.com/projects/PS

Crash when query_cache_strip_comments enabled

Bug #856404 reported by Arnaud
20
This bug affects 4 people
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Alexey Kopytov
Percona Server moved to https://jira.percona.com/projects/PS 5.5.18-23.0
5.1
Incomplete
High
Unassigned
5.5
Fix Released
High
Alexey Kopytov
Percona Server moved to https://jira.percona.com/projects/PS 5.5.18-23.0

Bug Description

Hello,

This query makes our Percona servers (5.5.11 and 5.5.15) crash when query_cache_strip_comments is enabled :

Query (0x337e880): SELECT s.lid, t.translation, s.version FROM locales_source s LEFT JOIN locales_target t ON s.lid = t.lid AND t
.language = 'fr' WHERE s.source = 'If you need to translate Views labels into other languages, consider installing the <a href=\"
!path\">Internationalization</a> package\'s Views translation module.' AND s.context = '' AND s.textgroup = 'default'

The trace:

*** glibc detected *** ./mysqld: malloc(): memory corruption: 0x00000000020f8560 ***
======= Backtrace: =========
/lib/libc.so.6(+0x775b6)[0x7f2e772565b6]
/lib/libc.so.6(+0x7b6d8)[0x7f2e7725a6d8]
/lib/libc.so.6(__libc_malloc+0x6e)[0x7f2e7725b58e]
./mysqld(my_malloc+0x32)[0x7ca472]
./mysqld(alloc_root+0x7e)[0x7c4dce]
./mysqld(_Z10MYSQLparsePv+0x13bab)[0x659e9b]
./mysqld(_Z9parse_sqlP3THDP12Parser_stateP19Object_creation_ctx+0x9d)[0x57183d]
./mysqld(_Z11mysql_parseP3THDPcjP12Parser_state+0x2c1)[0x57d621]
./mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x148e)[0x57eb9e]
./mysqld(_Z10do_commandP3THD+0x106)[0x57ef36]
./mysqld(_Z24do_handle_one_connectionP3THD+0x111)[0x619a81]
./mysqld(handle_one_connection+0x54)[0x619b74]
/lib/libpthread.so.0(+0x69ca)[0x7f2e780329ca]
/lib/libc.so.6(clone+0x6d)[0x7f2e772c570d]
======= Memory map: ========
00400000-00d4d000 r-xp 00000000 fc:05 155614 /opt/Percona-Server-5.5.15-rel21.0-158.Linux.x86_64/bin/mysqld
00f4c000-01068000 rw-p 0094c000 fc:05 155614 /opt/Percona-Server-5.5.15-rel21.0-158.Linux.x86_64/bin/mysqld
01068000-01095000 rw-p 00000000 00:00 0
014c0000-0313d000 rw-p 00000000 00:00 0 [heap]
7f2e5c000000-7f2e5c021000 rw-p 00000000 00:00 0
7f2e5c021000-7f2e60000000 ---p 00000000 00:00 0
7f2e61857000-7f2e61858000 ---p 00000000 00:00 0
7f2e61858000-7f2e62058000 rw-p 00000000 00:00 0
7f2e62058000-7f2e62059000 ---p 00000000 00:00 0
7f2e62059000-7f2e62859000 rw-p 00000000 00:00 0
7f2e62859000-7f2e6285a000 ---p 00000000 00:00 0
7f2e6285a000-7f2e6305a000 rw-p 00000000 00:00 0
7f2e6305a000-7f2e6305b000 ---p 00000000 00:00 0
7f2e6305b000-7f2e6385b000 rw-p 00000000 00:00 0
7f2e6385b000-7f2e6385c000 ---p 00000000 00:00 0
7f2e6385c000-7f2e6405c000 rw-p 00000000 00:00 0
7f2e6405c000-7f2e6405d000 ---p 00000000 00:00 0
7f2e6405d000-7f2e64aeb000 rw-p 00000000 00:00 0
7f2e64f09000-7f2e64f0a000 ---p 00000000 00:00 0
7f2e64f0a000-7f2e6570a000 rw-p 00000000 00:00 0
7f2e6570a000-7f2e6570b000 ---p 00000000 00:00 0
7f2e6570b000-7f2e65f0b000 rw-p 00000000 00:00 0
7f2e65f0b000-7f2e65f0c000 ---p 00000000 00:00 0
7f2e65f0c000-7f2e6670c000 rw-p 00000000 00:00 0
7f2e6670c000-7f2e6670d000 ---p 00000000 00:00 0
7f2e6670d000-7f2e66f0d000 rw-p 00000000 00:00 0
7f2e66f0d000-7f2e66f0e000 ---p 00000000 00:00 0
7f2e66f0e000-7f2e6770e000 rw-p 00000000 00:00 0
7f2e6770e000-7f2e6770f000 ---p 00000000 00:00 0
7f2e6770f000-7f2e67f0f000 rw-p 00000000 00:00 0
7f2e67f0f000-7f2e67f10000 ---p 00000000 00:00 0
7f2e67f10000-7f2e68710000 rw-p 00000000 00:00 0
7f2e68710000-7f2e68711000 ---p 00000000 00:00 0
7f2e68711000-7f2e68f11000 rw-p 00000000 00:00 0
7f2e68f11000-7f2e68f12000 ---p 00000000 00:00 0
7f2e68f12000-7f2e75f8c000 rw-p 00000000 00:00 0
7f2e75f8c000-7f2e75f98000 r-xp 00000000 fc:05 131850 /lib/libnss_files-2.11.1.so
7f2e75f98000-7f2e76197000 ---p 0000c000 fc:05 131850 /lib/libnss_files-2.11.1.so
7f2e76197000-7f2e76198000 r--p 0000b000 fc:05 131850 /lib/libnss_files-2.11.1.so
7f2e76198000-7f2e76199000 rw-p 0000c000 fc:05 131850 /lib/libnss_files-2.11.1.so
7f2e76199000-7f2e761a3000 r-xp 00000000 fc:05 131852 /lib/libnss_nis-2.11.1.so
7f2e761a3000-7f2e763a2000 ---p 0000a000 fc:05 131852 /lib/libnss_nis-2.11.1.so
7f2e763a2000-7f2e763a3000 r--p 00009000 fc:05 131852 /lib/libnss_nis-2.11.1.so
7f2e763a3000-7f2e763a4000 rw-p 0000a000 fc:05 131852 /lib/libnss_nis-2.11.1.so
7f2e763a4000-7f2e763bb000 r-xp 00000000 fc:05 131847 /lib/libnsl-2.11.1.so
7f2e763bb000-7f2e765ba000 ---p 00017000 fc:05 131847 /lib/libnsl-2.11.1.so
7f2e765ba000-7f2e765bb000 r--p 00016000 fc:05 131847 /lib/libnsl-2.11.1.so
7f2e765bb000-7f2e765bc000 rw-p 00017000 fc:05 131847 /lib/libnsl-2.11.1.so
7f2e765bc000-7f2e765be000 rw-p 00000000 00:00 0
7f2e765be000-7f2e765c6000 r-xp 00000000 fc:05 131848 /lib/libnss_compat-2.11.1.so
7f2e765c6000-7f2e767c5000 ---p 00008000 fc:05 131848 /lib/libnss_compat-2.11.1.so
7f2e767c5000-7f2e767c6000 r--p 00007000 fc:05 131848 /lib/libnss_compat-2.11.1.so
7f2e767c6000-7f2e767c7000 rw-p 00008000 fc:05 131848 /lib/libnss_compat-2.11.1.so
7f2e767c7000-7f2e767dd000 r-xp 00000000 fc:05 131757 /lib/libgcc_s.so.1
7f2e767dd000-7f2e769dc000 ---p 00016000 fc:05 131757 /lib/libgcc_s.so.1
7f2e769dc000-7f2e769dd000 r--p 00015000 fc:05 131757 /lib/libgcc_s.so.1
7f2e769dd000-7f2e769de000 rw-p 00016000 fc:05 131757 /lib/libgcc_s.so.1
7f2e769de000-7f2e769df000 ---p 00000000 00:00 0
7f2e769df000-7f2e771df000 rw-p 00000000 00:00 0
7f2e771df000-7f2e77359000 r-xp 00000000 fc:05 131840 /lib/libc-2.11.1.so
7f2e77359000-7f2e77558000 ---p 0017a000 fc:05 131840 /lib/libc-2.11.1.so
7f2e77558000-7f2e7755c000 r--p 00179000 fc:05 131840 /lib/libc-2.11.1.so
7f2e7755c000-7f2e7755d000 rw-p 0017d000 fc:05 131840 /lib/libc-2.11.1.so
7f2e7755d000-7f2e77562000 rw-p 00000000 00:00 0
7f2e77562000-7f2e77564000 r-xp 00000000 fc:05 131844 /lib/libdl-2.11.1.so
7f2e77564000-7f2e77764000 ---p 00002000 fc:05 131844 /lib/libdl-2.11.1.so
7f2e77764000-7f2e77765000 r--p 00002000 fc:05 131844 /lib/libdl-2.11.1.so
7f2e77765000-7f2e77766000 rw-p 00003000 fc:05 131844 /lib/libdl-2.11.1.so
7f2e77766000-7f2e7776f000 r-xp 00000000 fc:05 131843 /lib/libcrypt-2.11.1.so
7f2e7776f000-7f2e7796f000 ---p 00009000 fc:05 131843 /lib/libcrypt-2.11.1.so
7f2e7796f000-7f2e77970000 r--p 00009000 fc:05 131843 /lib/libcrypt-2.11.1.so
7f2e77970000-7f2e77971000 rw-p 0000a000 fc:05 131843 /lib/libcrypt-2.11.1.so
7f2e77971000-7f2e7799f000 rw-p 00000000 00:00 0
7f2e7799f000-7f2e779a6000 r-xp 00000000 fc:05 131960 /lib/librt-2.11.1.so
7f2e779a6000-7f2e77ba5000 ---p 00007000 fc:05 131960 /lib/librt-2.11.1.so
7f2e77ba5000-7f2e77ba6000 r--p 00006000 fc:05 131960 /lib/librt-2.11.1.so
7f2e77ba6000-7f2e77ba7000 rw-p 00007000 fc:05 131960 /lib/librt-2.11.1.so
7f2e77ba7000-7f2e77c29000 r-xp 00000000 fc:05 131845 /lib/libm-2.11.1.so

Even if I don't really understand why, disabling query_cache_strip_comments has stopped the crashes...

Related branches

lp:~tsarev/percona-server/5.5_fix_bug_856404
Stewart Smith (community): Approve
Laurynas Biveinis: Pending requested
Alexey Kopytov: Pending requested
Diff: 1752 lines (+1210/-418)
1 file modified
patches/query_cache_enhance.patch (+1210/-418)
lp:~tsarev/percona-server/5.1_fix_bug_856404
Rejected for merging into lp:percona-server/5.1
Laurynas Biveinis (community): Disapprove
lp:~akopytov/percona-server/bug915814-5.5
Laurynas Biveinis (community): Approve
Diff: 1805 lines (+448/-1188)
1 file modified
patches/query_cache_enhance.patch (+448/-1188)
Oleg Tsarev (tsarev)
Changed in percona-server:
assignee: nobody → Oleg Tsarev (tsarev)
importance: Undecided → High
Revision history for this message
Stewart Smith (stewart) wrote :

lp:~stewart/dbqp/query_cache_strip_comments

./dbqp.py --libeatmydata --default-server-type=mysql --basedir=/home/stewart/percona-server/5.5/Percona-Server --suite=randgen_basic query_cache_strip_comments_test

Changed in percona-server:
status: New → Triaged
Revision history for this message
Oleg Tsarev (tsarev) wrote :

Looks like to bug in dbqp. Please ask anything if you need.

oleg.tsarev (0) /storage/dev/percona/query_cache_strip_comments$ ./dbqp.py --libeatmydata --default-server-type=mysql --basedir=/storage/dev/percona/query_cache_strip_comments_source/Percona-Server-5.5.16-rel21.0-debug/ --suite=randgen_basic query_cache_strip_comments_test
20111031-160425 INFO Linking workdir /storage/dev/percona/query_cache_strip_comments/workdir to /dev/shm/dbqp_workdir_oleg.tsarev_63c851d2-12a7-459e-acac-bfbd5e877562
20111031-160425 ERROR Required file not found out of options: /storage/dev/percona/query_cache_strip_comments_source/Percona-Server-5.5.16-rel21.0-debug/mysql/charsets ,/storage/dev/percona/query_cache_strip_comments_source/Percona-Server-5.5.16-rel21.0-debug/sql/share/charsets ,/storage/dev/percona/query_cache_strip_comments_source/Percona-Server-5.5.16-rel21.0-debug/share/charsets

Changed in percona-server:
assignee: Oleg Tsarev (tsarev) → Patrick Crews (patrick-crews)
Revision history for this message
Patrick Crews (patrick-crews) wrote :

Need to do some work to handle out of source builds to find things nicely. Will have a patch for this asap

Oleg Tsarev (tsarev)
Changed in percona-server:
assignee: Patrick Crews (patrick-crews) → Oleg Tsarev (tsarev)
status: Triaged → In Progress
Oleg Tsarev (tsarev)
Changed in percona-server:
status: In Progress → Fix Committed
Revision history for this message
Dr. Tyrell (dr.tyrell) wrote :

Has this been committed to 5.1 series. We have 5.1.59 x86_64
We had query_cache_strip_comments=ON and have been getting the same error.
I have now turned it off based on this thread.

Thanks.

Revision history for this message
Oleg Tsarev (tsarev) wrote :

Dr. Turell,

Thank you for your feedback. I have a fix, after merge to 5.5 will port fix to 5.1.

Regards, Oleg

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.