| Bug #78643 | InnoDB: Failing assertion: val <= 4294967295u in fts0vlc.ic line 96 | ||
|---|---|---|---|
| Submitted: | 30 Sep 2015 10:44 | Modified: | 30 Sep 2015 11:04 |
| Reporter: | Ramesh Sivaraman (OCA) | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: FULLTEXT search | Severity: | S3 (Non-critical) |
| Version: | 5.6.26, 5.6.28, 5.7.10 | OS: | CentOS (CentOS 7) |
| Assigned to: | CPU Architecture: | Any | |
| Tags: | debug | ||
[30 Sep 2015 10:44]
Ramesh Sivaraman
Testcase bundle
Attachment: 1443601117.tar.gz (application/gzip, text), 1.00 MiB.
[30 Sep 2015 11:04]
Umesh Shastry
Hello Ramesh Sivaraman, Thank you for the report and test case. Observed that 5.6.26,5.6.28/5.7.10 debug builds are affected. Thanks, Umesh
[30 Sep 2015 11:05]
Umesh Shastry
// 5.6.28 - only debug build affected
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.6.28: cat docs/INFO_SRC
commit: cba294cfbde9bd40ee49541d5c2723fe41e8b98c
date: 2015-09-22 15:04:14 +0200
build-date: 2015-09-23 14:47:15 +0200
short: cba294c
branch: mysql-5.6
MySQL source 5.6.28
(gdb) bt
#0 0x00007fed72d6b5d7 in raise () from /lib64/libc.so.6
#1 0x00007fed72d6ccc8 in abort () from /lib64/libc.so.6
#2 0x0000000000d427a0 in fts_encode_int (val=42949672950, buf=0x7fed0c00bf40 "")
at /export/home/pb2/build/sb_0-16559838-1443014914.12/mysqlcom-pro-5.6.28/storage/innobase/include/fts0vlc.ic:96
#3 0x0000000000d4d7c0 in fts_cache_node_add_positions (cache=0x0, node=0x7fed0c00a040, doc_id=42949672950, positions=0x7fed0c00a100)
at /export/home/pb2/build/sb_0-16559838-1443014914.12/mysqlcom-pro-5.6.28/storage/innobase/fts/fts0fts.cc:1352
#4 0x0000000000bbcf04 in row_fts_insert_tuple (ins_ctx=0x7fed397fad90, word=0x7fed397fadf0, positions=0x7fed0c00a100, in_doc_id=0x7fed397fae18, dtuple=0x0)
at /export/home/pb2/build/sb_0-16559838-1443014914.12/mysqlcom-pro-5.6.28/storage/innobase/row/row0ftsort.cc:1057
#5 0x0000000000bbda1f in row_fts_merge_insert (index=0x7fed1c020ca8, table=0x7fed1c062c18, psort_info=0x7fed1c026928, id=2)
at /export/home/pb2/build/sb_0-16559838-1443014914.12/mysqlcom-pro-5.6.28/storage/innobase/row/row0ftsort.cc:1489
#6 0x0000000000bbe060 in fts_parallel_merge (arg=0x7fed1c06eee8) at /export/home/pb2/build/sb_0-16559838-1443014914.12/mysqlcom-pro-5.6.28/storage/innobase/row/row0ftsort.cc:932
#7 0x00007fed74160df5 in start_thread () from /lib64/libpthread.so.0
#8 0x00007fed72e2c60d in clone () from /lib64/libc.so.6
(gdb)
[30 Sep 2015 11:05]
Umesh Shastry
// 5.7.10 - only debug build affected
[umshastr@hod03]/export/umesh/server/binaries/mysql-advanced-5.7.10: cat docs/INFO_SRC
commit: c70ec0ed106ddd0b9ec0adb551be63b99d969c5d
date: 2015-09-27 04:27:17 +0200
build-date: 2015-09-27 18:04:34 +0200
short: c70ec0e
branch: mysql-5.7
MySQL source 5.7.10
(gdb) bt
#0 0x00007f92c67fe5d7 in raise () from /lib64/libc.so.6
#1 0x00007f92c67ffcc8 in abort () from /lib64/libc.so.6
#2 0x0000000001a35c07 in ut_dbg_assertion_failed (expr=0x22c03d4 "val <= 4294967295u",
file=0x22c0368 "/export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/include/fts0vlc.ic", line=96)
at /export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/ut/ut0dbg.cc:67
#3 0x0000000001b4b1aa in fts_encode_int (val=42949672950, buf=0x7f9244023728 "")
at /export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/include/fts0vlc.ic:96
#4 0x0000000001b4d70a in fts_cache_node_add_positions (cache=0x0, node=0x7f92440212e8, doc_id=42949672950, positions=0x7f92440213a8)
at /export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/fts/fts0fts.cc:1304
#5 0x000000000191db35 in row_fts_insert_tuple (ins_ctx=0x7f927cdf9800, word=0x7f927cdf97e0, positions=0x7f92440213a8, in_doc_id=0x7f927cdf9b28, dtuple=0x0)
at /export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/row/row0ftsort.cc:1215
#6 0x000000000191ef0c in row_fts_merge_insert (index=0x7f9258950d90, table=0x7f9258957750, psort_info=0x7f9258963a98, id=2)
at /export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/row/row0ftsort.cc:1673
#7 0x000000000191d55b in fts_parallel_merge (arg=0x7f9258968338) at /export/home2/pb2/build/sb_0-16591632-1443371030.54/mysqlcom-pro-5.7.10/storage/innobase/row/row0ftsort.cc:1049
#8 0x00007f92c7dffdf5 in start_thread () from /lib64/libpthread.so.0
#9 0x00007f92c68bf60d in clone () from /lib64/libc.so.6
(gdb)
Description: +bt #0 0x00007f2dbfea75d7 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56 #1 0x00007f2dbfea8cc8 in __GI_abort () at abort.c:90 #2 0x0000000000dd4e99 in fts_encode_int (val=42949672950, buf=0x7f2d9c846040 "") at /sda/ms/mysql-5.6.26/storage/innobase/include/fts0vlc.ic:96 #3 0x0000000000dd714b in fts_cache_node_add_positions (cache=0x0, node=0x7f2d9c8440c0, doc_id=42949672950, positions=0x7f2d9c844180) at /sda/ms/mysql-5.6.26/storage/innobase/fts/fts0fts.cc:1352 #4 0x0000000000c42d78 in row_fts_insert_tuple (ins_ctx=0x7f2d9bffed70, word=0x7f2d9bffed50, positions=0x7f2d9c844180, in_doc_id=0x7f2d9bffedd8, dtuple=0x0) at /sda/ms/mysql-5.6.26/storage/innobase/row/row0ftsort.cc:1057 #5 0x0000000000c43ef3 in row_fts_merge_insert (index=0x7f2da2874b78, table=0x7f2da286d378, psort_info=0x7f2da289ac78, id=2) at /sda/ms/mysql-5.6.26/storage/innobase/row/row0ftsort.cc:1489 #6 0x0000000000c42a26 in fts_parallel_merge (arg=0x7f2da2854798) at /sda/ms/mysql-5.6.26/storage/innobase/row/row0ftsort.cc:932 #7 0x00007f2dc1096df5 in start_thread (arg=0x7f2d9bfff700) at pthread_create.c:308 #8 0x00007f2dbff681ad in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:113 (gdb) +set logging off How to repeat: testcase # mysqld options required for replay: --sql_mode=ONLY_FULL_GROUP_BY DROP DATABASE test;CREATE DATABASE test;USE test; SET @@session.insert_id=42949672950; CREATE TABLE t1(FTS_DOC_ID BIGINT UNSIGNED AUTO_INCREMENT KEY,title CHAR (1),body TEXT) ENGINE=InnoDB; INSERT INTO t1(title,body)VALUES ('myfulltext database','my test fulltext database'); CREATE FULLTEXT INDEX idx2 ON t1(body); The attached tarball gives the testcase as an exact match of our system, including some handy utilities $ vi 1443601117_mybase # STEP1: Update the base path in this file (usually the only change required!). If you use a non-binary distribution, please update SOURCE_DIR location also $ ./1443601117_init # STEP2: Initializes the data dir $ ./1443601117_start # STEP3: Starts mysqld $ ./1443601117_cl # STEP4: To check mysqld is up $ ./1443601117_run_pquery # STEP5: Run the testcase with the pquery binary $ ./1443601117_run # OPTIONAL: Run the testcase with the mysql CLI (may not reproduce the issue, as the pquery binary was used for the original testcase reduction) $ vi /dev/shm/1443601117/error.log.out # STEP6: Verify the error log $ ./1443601117_gdb # OPTIONAL: Brings you to a gdb prompt with gdb attached to the used mysqld and attached to the generated core $ ./1443601117_parse_core # STEP7: Create 1443601117_STD.gdb and 1443601117_FULL.gdb; standard and full variables gdb stack traces