Crash when query_cache_strip_comments enabled
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Percona Server moved to https://jira.percona.com/projects/PS |
Fix Released
|
High
|
Alexey Kopytov | ||
5.1 |
Incomplete
|
High
|
Unassigned | ||
5.5 |
Fix Released
|
High
|
Alexey Kopytov |
Bug Description
Hello,
This query makes our Percona servers (5.5.11 and 5.5.15) crash when query_cache_
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\"
The trace:
*** glibc detected *** ./mysqld: malloc(): memory corruption: 0x00000000020f8560 ***
======= Backtrace: =========
/lib/libc.
/lib/libc.
/lib/libc.
./mysqld(
./mysqld(
./mysqld(
./mysqld(
./mysqld(
./mysqld(
./mysqld(
./mysqld(
./mysqld(
/lib/libpthread
/lib/libc.
======= Memory map: ========
00400000-00d4d000 r-xp 00000000 fc:05 155614 /opt/Percona-
00f4c000-01068000 rw-p 0094c000 fc:05 155614 /opt/Percona-
01068000-01095000 rw-p 00000000 00:00 0
014c0000-0313d000 rw-p 00000000 00:00 0 [heap]
7f2e5c000000-
7f2e5c021000-
7f2e61857000-
7f2e61858000-
7f2e62058000-
7f2e62059000-
7f2e62859000-
7f2e6285a000-
7f2e6305a000-
7f2e6305b000-
7f2e6385b000-
7f2e6385c000-
7f2e6405c000-
7f2e6405d000-
7f2e64f09000-
7f2e64f0a000-
7f2e6570a000-
7f2e6570b000-
7f2e65f0b000-
7f2e65f0c000-
7f2e6670c000-
7f2e6670d000-
7f2e66f0d000-
7f2e66f0e000-
7f2e6770e000-
7f2e6770f000-
7f2e67f0f000-
7f2e67f10000-
7f2e68710000-
7f2e68711000-
7f2e68f11000-
7f2e68f12000-
7f2e75f8c000-
7f2e75f98000-
7f2e76197000-
7f2e76198000-
7f2e76199000-
7f2e761a3000-
7f2e763a2000-
7f2e763a3000-
7f2e763a4000-
7f2e763bb000-
7f2e765ba000-
7f2e765bb000-
7f2e765bc000-
7f2e765be000-
7f2e765c6000-
7f2e767c5000-
7f2e767c6000-
7f2e767c7000-
7f2e767dd000-
7f2e769dc000-
7f2e769dd000-
7f2e769de000-
7f2e769df000-
7f2e771df000-
7f2e77359000-
7f2e77558000-
7f2e7755c000-
7f2e7755d000-
7f2e77562000-
7f2e77564000-
7f2e77764000-
7f2e77765000-
7f2e77766000-
7f2e7776f000-
7f2e7796f000-
7f2e77970000-
7f2e77971000-
7f2e7799f000-
7f2e779a6000-
7f2e77ba5000-
7f2e77ba6000-
7f2e77ba7000-
Even if I don't really understand why, disabling query_cache_
Related branches
- Stewart Smith (community): Approve
- Laurynas Biveinis: Pending requested
- Alexey Kopytov: Pending requested
-
Diff: 1752 lines (+1210/-418)1 file modifiedpatches/query_cache_enhance.patch (+1210/-418)
- Laurynas Biveinis (community): Disapprove
- Laurynas Biveinis (community): Approve
-
Diff: 1805 lines (+448/-1188)1 file modifiedpatches/query_cache_enhance.patch (+448/-1188)
Changed in percona-server: | |
assignee: | nobody → Oleg Tsarev (tsarev) |
importance: | Undecided → High |
Changed in percona-server: | |
assignee: | Patrick Crews (patrick-crews) → Oleg Tsarev (tsarev) |
status: | Triaged → In Progress |
Changed in percona-server: | |
status: | In Progress → Fix Committed |
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