| Bug #74762 | Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS. | ||
|---|---|---|---|
| Submitted: | 10 Nov 2014 11:49 | Modified: | 10 Nov 2014 12:25 |
| Reporter: | Ramesh Sivaraman | Email Updates: | |
| Status: | Verified | Impact on me: | |
| Category: | MySQL Server: DDL | Severity: | S3 (Non-critical) |
| Version: | 5.6.20-debug, 5.6.23, 5.7.6 | OS: | Linux (CentOS 7) |
| Assigned to: | CPU Architecture: | Any | |
[10 Nov 2014 12:25]
MySQL Verification Team
Hello Ramesh Sivaraman, Thank you for the bug report and test case. Observed that debug build of 5.6.23 affected. Thanks, Umesh
[10 Nov 2014 12:26]
MySQL Verification Team
// 5.6.23
(gdb) bt
#0 0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#1 0x0000003deac33e05 in abort () at abort.c:92
#2 0x0000000000c4c1ef in que_run_threads (thr=0x7f70a0034408) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/que/que0que.cc:1206
#3 0x0000000000e1166c in fts_eval_sql (trx=0x7f70a0027ce8, graph=0x7f70a0034340) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fts/fts0sql.cc:286
#4 0x0000000000df9987 in fts_write_node (trx=0x7f70a0027ce8, graph=0x7f70a00313d0, fts_table=0x7f70cdffad10, word=0x7f70cdffad60, node=0x7f70a00311e0)
at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/fts/fts0fts.cc:3896
#5 0x0000000000c5d6aa in row_merge_write_fts_word (trx=0x7f70a0027ce8, ins_graph=0x7f70a00313c8, word=0x7f70cdffad60, fts_table=0x7f70cdffad10, charset=0x1818980)
at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:1003
#6 0x0000000000c5d945 in row_fts_insert_tuple (ins_ctx=0x7f70cdffad00, word=0x7f70cdffad60, positions=0x7f70a00312a0, in_doc_id=0x7f70cdffad88, dtuple=0x7f70a002cca8)
at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:1102
#7 0x0000000000c5ea86 in row_fts_merge_insert (index=0x7f70b40983a8, table=0x7f70b40611b8, psort_info=0x7f70b40932a8, id=1)
at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:1531
#8 0x0000000000c5d4d4 in fts_parallel_merge (arg=0x7f70b40a0f88) at /export/home/pb2/build/sb_0-13622626-1415294505.52/mysqlcom-pro-5.6.23/storage/innobase/row/row0ftsort.cc:937
#9 0x0000003deb0079d1 in start_thread (arg=0x7f70cdffb700) at pthread_create.c:301
#10 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
[10 Nov 2014 12:38]
MySQL Verification Team
// 5.7.6 debug build
(gdb) bt
#0 __pthread_kill (threadid=<value optimized out>, signo=<value optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63
#1 0x0000000000f990a1 in my_write_core (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/mysys/stacktrace.c:247
#2 0x000000000092d7cc in handle_fatal_signal (sig=6) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/signal_handler.cc:219
#3 <signal handler called>
#4 0x0000003deac32625 in raise (sig=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64
#5 0x0000003deac33e05 in abort () at abort.c:92
#6 0x0000003deac2b74e in __assert_fail_base (fmt=<value optimized out>, assertion=0x16ec2fc "0",
file=0x16ece38 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc", line=<value optimized out>, function=<value optimized out>)
at assert.c:96
#7 0x0000003deac2b810 in __assert_fail (assertion=0x16ec2fc "0", file=0x16ece38 "/pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc",
line=5865, function=0x16f0660 "bool commit_try_norebuild(Alter_inplace_info*, ha_innobase_inplace_ctx*, const TABLE*, trx_t*, const char*)") at assert.c:105
#8 0x000000000106c7f3 in commit_try_norebuild (ha_alter_info=0x7ff4d9fd2870, ctx=0x7ff498007270, old_table=0x7ff498065f60, trx=0x7ff4dabbbd60, table_name=0x7ff49806bf8d "t4")
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc:5865
#9 0x0000000001069619 in ha_innobase::commit_inplace_alter_table (this=0x7ff49806cff0, altered_table=0x7ff49807f850, ha_alter_info=0x7ff4d9fd2870, commit=true)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/innobase/handler/handler0alter.cc:6379
#10 0x0000000000998994 in handler::ha_commit_inplace_alter_table (this=0x7ff49806cff0, altered_table=0x7ff49807f850, ha_alter_info=0x7ff4d9fd2870, commit=true)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/handler.cc:4485
#11 0x0000000000d321e2 in mysql_inplace_alter_table (thd=0x7ff498000cf0, table_list=0x7ff498005db8, table=0x7ff498065f60, altered_table=0x7ff49807f850, ha_alter_info=0x7ff4d9fd2870,
inplace_supported=HA_ALTER_INPLACE_SHARED_LOCK_AFTER_PREPARE, target_mdl_request=0x7ff4d9fd31f0, alter_ctx=0x7ff4d9fd1dd0)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:6794
#12 0x0000000000d367ec in mysql_alter_table (thd=0x7ff498000cf0, new_db=0x7ff498006330 "test", new_name=0x0, create_info=0x7ff4d9fd3c80, table_list=0x7ff498005db8, alter_info=0x7ff4d9fd3d60)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_table.cc:8629
#13 0x0000000000e7d727 in Sql_cmd_alter_table::execute (this=0x7ff498006428, thd=0x7ff498000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_alter.cc:315
#14 0x0000000000cbb4f7 in mysql_execute_command (thd=0x7ff498000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:4785
#15 0x0000000000cbce6a in mysql_parse (thd=0x7ff498000cf0, parser_state=0x7ff4d9fd5660) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:5397
#16 0x0000000000cb0f2c in dispatch_command (command=COM_QUERY, thd=0x7ff498000cf0, packet=0x7ff498009a21 "ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body)", packet_length=49)
at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:1249
#17 0x0000000000cafbd4 in do_command (thd=0x7ff498000cf0) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/sql_parse.cc:833
#18 0x0000000000dbe89c in handle_connection (arg=0x381b830) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/sql/conn_handler/connection_handler_per_thread.cc:298
#19 0x000000000138347f in pfs_spawn_thread (arg=0x3671e40) at /pb2/build/sb_0-13559856-1414670154.69/mysqlcom-pro-5.7.6-m16/storage/perfschema/pfs.cc:2137
#20 0x0000003deb0079d1 in start_thread (arg=0x7ff4d9fd6700) at pthread_create.c:301
#21 0x0000003deace89dd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:115
Description: 2014-11-10 11:39:27 7fcb8bbfd700 InnoDB: Assertion failure in thread 140512199694080 in file que0que.cc line 1206 InnoDB: Failing assertion: thr_get_trx(thr)->error_state == DB_SUCCESS ** GDB info #0 0x00007f1136eb6771 in pthread_kill () from /lib64/libpthread.so.0 #1 0x0000000000a9035e in my_write_core (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/mysys/stacktrace.c:422 #2 0x0000000000723688 in handle_fatal_signal (sig=6) at /ssd/ramesh/mysql-server/mysql-5.6/sql/signal_handler.cc:230 #3 <signal handler called> #4 0x00007f1135cc25c9 in raise () from /lib64/libc.so.6 #5 0x00007f1135cc3cd8 in abort () from /lib64/libc.so.6 #6 0x0000000000bff79c in que_run_threads (thr=0x7f108e87fa18) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/que/que0que.cc:1206 #7 0x0000000000dbf16c in fts_eval_sql (trx=0x7f108e80e478, graph=0x7f108e87f950) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/fts/fts0sql.cc:286 #8 0x0000000000da9088 in fts_write_node (trx=0x7f108e80e478, graph=0x7f108e8442c8, fts_table=0x7f10897fcd80, word=0x7f10897fcd50, node=0x7f108e8440c0) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/fts/fts0fts.cc:3886 #9 0x0000000000c10b6b in row_merge_write_fts_word (trx=0x7f108e80e478, ins_graph=0x7f108e8442a8, word=0x7f10897fcd50, fts_table=0x7f10897fcd80, charset=0x168e0c0 <my_charset_latin1>) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:998 #10 0x0000000000c10dea in row_fts_insert_tuple (ins_ctx=0x7f10897fcd70, word=0x7f10897fcd50, positions=0x7f108e844180, in_doc_id=0x7f10897fcdd8, dtuple=0x7f108e82a678) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:1097 #11 0x0000000000c11ffe in row_fts_merge_insert (index=0x7f109a471d78, table=0x7f109a54a578, psort_info=0x7f109a49a878, id=4) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:1526 #12 0x0000000000c10976 in fts_parallel_merge (arg=0x7f109a454eb8) at /ssd/ramesh/mysql-server/mysql-5.6/storage/innobase/row/row0ftsort.cc:932 #13 0x00007f1136eb1df3 in start_thread () from /lib64/libpthread.so.0 #14 0x00007f1135d8301d in clone () from /lib64/libc.so.6 How to repeat: Got 30 lines in final testcase. I could not reduce it further. ****************** DROP DATABASE test;CREATE DATABASE test;USE test; CREATE TABLE t1(a INT)PARTITION BY RANGE (a) (PARTITION p0 VALUES LESS THAN (6),PARTITION `p1....................` VALUES LESS THAN (9),PARTITION p2 VALUES LESS THAN MAXVALUE); ALTER TABLE t1 ADD ucs2_f CHAR(32)CHARACTER SET ucs2; DROP TABLE t1; CREATE TABLE t2(dummy int)ENGINE=innodb; CREATE TABLE t1(i1 INT); CREATE INDEX t1r ON t1(r(767)); DROP TABLE t1; CREATE TABLE t4(id INT UNSIGNED AUTO_INCREMENT KEY,title CHAR (200),body TEXT,FULLTEXT (title,body)) ENGINE=InnoDB; CREATE TABLE t1(c1 INT); INSERT INTO t1 VALUES(0xACA6); CREATE TABLE `�ԣ�`(`�ã�` ENUM('','',''),INDEX(`�ã�`)) DEFAULT CHARSET=ucs2 engine=innodb; INSERT INTO t4(title,body)VALUES ('MySQL Tutorial','DBMS stINg database comparison ...'),('MySQL Security','When configured properly,MySQL ...'); INSERT INTO t1 VALUES(repeat(0,@@global.max_allowed_packet)); INSERT INTO t1 VALUES(0xA9D8); INSERT INTO t1 VALUES(CONVERT(_ucs2 0x06220646 USING utf8)); INSERT INTO t1 VALUES(@@session.unique_checks); insert t1 values(0); set global innodb_trx_rseg_n_slots_debug=1; ALTER TABLE t1 ADD UNIQUE(c1); REPLACE t1 VALUES(5); insert INTO t1 values(repeat('बांग्लादे',0)); INSERT INTO t1 VALUES(0xA5F8); ALTER TABLE t1 CHANGE c1 c1 REAL UNSIGNED; CREATE TABLE t7(val bit(1)); ALTER TABLE t1 CHANGE c1 c1 BLOB; SELECT * FROM t1; INSERT INTO t1 VALUES(-1),(-2),(-3); ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body); ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body); ALTER TABLE t4 ADD FULLTEXT INDEX idx(title,body);