Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1(EOL)
Description
10.1 9f848da640dd6c3f44d56eae18204370ae7f835c |
2018-06-17 04:31:32 7fb03ad51b00 InnoDB: Assertion failure in thread 140394878016256 in file dict0dict.cc line 2737
|
InnoDB: Failing assertion: ++retries < 10000
|
 |
#5 0x00007fb0635c3028 in abort () from /lib/x86_64-linux-gnu/libc.so.6
|
#6 0x0000557f3f6b3832 in dict_index_remove_from_cache_low (table=0x557f431fcd28, index=0x557f4308a998, lru_evict=0) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:2737
|
#7 0x0000557f3f6b24de in dict_table_remove_from_cache_low (table=0x557f431fcd28, lru_evict=0) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:2114
|
#8 0x0000557f3f6b2895 in dict_table_remove_from_cache (table=0x557f431fcd28) at /home/travis/src/storage/xtradb/dict/dict0dict.cc:2151
|
#9 0x0000557f3f594b5e in row_drop_table_for_mysql (name=0x557f42f57590 "test/#sql-ib3458-1040254509", trx=0x7fb00000bf98, drop_db=false, create_failed=0, nonatomic=false) at /home/travis/src/storage/xtradb/row/row0mysql.cc:4430
|
#10 0x0000557f3f58544a in row_merge_drop_table (trx=0x7fb00000bf98, table=0x557f431fcd28) at /home/travis/src/storage/xtradb/row/row0merge.cc:3823
|
#11 0x0000557f3f4a7768 in ha_innobase::commit_inplace_alter_table (this=0x7fb0000aa158, altered_table=0x7fb0000cac40, ha_alter_info=0x7fb03ad4dad0, commit=true) at /home/travis/src/storage/xtradb/handler/handler0alter.cc:6323
|
#12 0x0000557f3f13e52f in handler::ha_commit_inplace_alter_table (this=0x7fb0000aa158, altered_table=0x7fb0000cac40, ha_alter_info=0x7fb03ad4dad0, commit=true) at /home/travis/src/sql/handler.cc:4225
|
#13 0x0000557f3efb471b in mysql_inplace_alter_table (thd=0x557f42fea610, table_list=0x7fb00003b0c8, table=0x7fb0000d7390, altered_table=0x7fb0000cac40, ha_alter_info=0x7fb03ad4dad0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7fb03ad4db40, alter_ctx=0x7fb03ad4e6e0) at /home/travis/src/sql/sql_table.cc:7222
|
#14 0x0000557f3efb9085 in mysql_alter_table (thd=0x557f42fea610, new_db=0x7fb00003b6b8 "test", new_name=0x0, create_info=0x7fb03ad4f2d0, table_list=0x7fb00003b0c8, alter_info=0x7fb03ad4f240, order_num=0, order=0x0, ignore=true) at /home/travis/src/sql/sql_table.cc:9048
|
#15 0x0000557f3f02b4a8 in Sql_cmd_alter_table::execute (this=0x7fb00003b770, thd=0x557f42fea610) at /home/travis/src/sql/sql_alter.cc:325
|
#16 0x0000557f3eef9f39 in mysql_execute_command (thd=0x557f42fea610) at /home/travis/src/sql/sql_parse.cc:5696
|
#17 0x0000557f3eefe6a1 in mysql_parse (thd=0x557f42fea610, rawbuf=0x7fb00003add8 "ALTER ONLINE IGNORE TABLE `table_partitioned` DROP FOREIGN KEY IF EXISTS j, DROP COLUMN IF EXISTS tscol5, ALGORITHM=COPY, FORCE, LOCK=NONE, ALGORITHM=INPLACE, DROP COLUMN IF EXISTS `field4`, ALGORITHM"..., length=246, parser_state=0x7fb03ad50630) at /home/travis/src/sql/sql_parse.cc:7449
|
#18 0x0000557f3eeed0ed in dispatch_command (command=COM_QUERY, thd=0x557f42fea610, packet=0x557f43149741 "ALTER ONLINE IGNORE TABLE `table_partitioned` DROP FOREIGN KEY IF EXISTS j, DROP COLUMN IF EXISTS tscol5, ALGORITHM=COPY, FORCE, LOCK=NONE, ALGORITHM=INPLACE, DROP COLUMN IF EXISTS `field4`, ALGORITHM"..., packet_length=247) at /home/travis/src/sql/sql_parse.cc:1492
|
#19 0x0000557f3eeebe6d in do_command (thd=0x557f42fea610) at /home/travis/src/sql/sql_parse.cc:1121
|
#20 0x0000557f3f026a95 in do_handle_one_connection (thd_arg=0x557f42fea610) at /home/travis/src/sql/sql_connect.cc:1330
|
#21 0x0000557f3f0267f9 in handle_one_connection (arg=0x557f42fea610) at /home/travis/src/sql/sql_connect.cc:1242
|
#22 0x00007fb063f64184 in start_thread () from /lib/x86_64-linux-gnu/libpthread.so.0
|
#23 0x00007fb063686ffd in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
ALTER ONLINE IGNORE TABLE `table_partitioned` DROP FOREIGN KEY IF EXISTS j, DROP COLUMN IF EXISTS tscol5, ALGORITHM=COPY, FORCE, LOCK=NONE, ALGORITHM=INPLACE, DROP COLUMN IF EXISTS `field4`, ALGORITHM=DEFAULT, CHECKSUM 1 |
Full threads are attached. Datadir, coredump, binary, and logs are available on perro.
Attachments
Issue Links
- causes
-
MDEV-16647 InnoDB fails to drop large temporary table on disconnect
- Closed
-
MDEV-16862 build failure for WITH_INNODB_AHI=0
- Closed
-
MDEV-17470 Orphan temporary files after interrupted ALTER cause InnoDB: Operating system error number 17 and eventual fatal error 71
- Closed
-
MDEV-18237 InnoDB: Unable to drop FTS index aux table and further errors (possibly bogus)
- Closed
-
MDEV-20102 When the ctas from a big table is interrupted ,then you can't drop or recreate the table!
- Closed
- relates to
-
MDEV-14491 rpl.rpl_row_mixing_engines, rpl.rpl_non_direct_row_mixing_engines failed in buildbot with long semaphore wait
- Closed
-
MDEV-14727 innodb_fts.fulltext2 failed in buildbot with long semaphore wait
- Closed
-
MDEV-16283 ALTER TABLE...DISCARD TABLESPACE still takes long on a large buffer pool
- Closed
-
MDEV-16759 InnoDB: Assertion failure in thread 139946191502080 in file row0ins.cc line 285
- Closed
-
MDEV-23223 If you cancel CTAS Query on MariaDB Server, it will not be canceled and Rollback will be executed
- Closed
-
MDEV-9663 InnoDB assertion failure: *cursor->index->name == TEMP_INDEX_PREFIX, or !cursor->index->is_committed()
- Closed