Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 10.0.4
-
Fix Version/s: 10.0.8
-
Component/s: Storage Engine - InnoDB
-
Labels:
Description
I'm submitting it for the record, there seems to be no need to work on the fix just yet, since it was fixed some time between MySQL 5.6.10 and 5.6.12 (reproducible on 5.6.10, not reproducible on 5.6.12). But I keep running onto it, and so might the users, so better to have it filed (and to re-check after the merge with MySQL 5.6.12+).
2013-08-06 16:26:14 7f52fc634700 InnoDB: Assertion failure in thread 139994398410496 in file row0upd.cc line 1311 InnoDB: Failing assertion: thr
#5 0x00007f5311dbdb8b in __GI_abort () at abort.c:91 #6 0x0000000000ce1d9b in row_upd_changes_ord_field_binary_func (index=0x7f52a400b788, update=0x7f52a403cfb0, thr=0x0, row=0x0, ext=0x0) at 10.0-serg/storage/innobase/row/row0upd.cc:1311 #7 0x0000000000d55da1 in btr_cur_update_in_place (flags=31, cursor=0x7f52fc630060, offsets=0x7f52a404bf70, update=0x7f52a403cfb0, cmpl_info=0, thr=0x0, trx_id=0, mtr=0x7f52fc6301b0) at 10.0-serg/storage/innobase/btr/btr0cur.cc:2000 #8 0x0000000000d562dd in btr_cur_optimistic_update (flags=31, cursor=0x7f52fc630060, offsets=0x7f52fc630148, heap=0x7f52fc630030, update=0x7f52a403cfb0, cmpl_info=0, thr=0x0, trx_id=0, mtr=0x7f52fc6301b0) at 10.0-serg/storage/innobase/btr/btr0cur.cc:2122 #9 0x0000000000d56be7 in btr_cur_pessimistic_update (flags=31, cursor=0x7f52fc630060, offsets=0x7f52fc630148, offsets_heap=0x7f52fc630030, entry_heap=0x7f52a403cbc0, big_rec=0x7f52fc630160, update=0x7f52a403cfb0, cmpl_info=0, thr=0x0, trx_id=0, mtr=0x7f52fc6301b0) at 10.0-serg/storage/innobase/btr/btr0cur.cc:2380 #10 0x0000000000cbb56e in row_log_table_apply_update (thr=0x7f52a403bf50, trx_id_col=1, new_trx_id_col=1, mrec=0x7f52abef8d7d "\200", offsets=0x7f52a400b560, offsets_heap=0x7f52a404be60, heap=0x7f52a403cbc0, dup=0x7f52fc6308b0, trx_id=2921, old_pk=0x7f52a403cc38) at 10.0-serg/storage/innobase/row/row0log.cc:1688 #11 0x0000000000cbc2bd in row_log_table_apply_op (thr=0x7f52a403bf50, trx_id_col=1, new_trx_id_col=1, dup=0x7f52fc6308b0, error=0x7f52fc630868, offsets_heap=0x7f52a404be60, heap=0x7f52a403cbc0, mrec=0x7f52abef8d7d "\200", mrec_end=0x7f52abf05034 "", offsets=0x7f52a400b560) at 10.0-serg/storage/innobase/row/row0log.cc:2033 #12 0x0000000000cbd1a7 in row_log_table_apply_ops (thr=0x7f52a403bf50, dup=0x7f52fc6308b0) at 10.0-serg/storage/innobase/row/row0log.cc:2326 #13 0x0000000000cbd5bd in row_log_table_apply (thr=0x7f52a403bf50, old_table=0x7f52c40a0658, table=0x7f52a4047600) at 10.0-serg/storage/innobase/row/row0log.cc:2420 #14 0x0000000000be56a1 in ha_innobase::inplace_alter_table (this=0x7f52c411f9f8, altered_table=0x7f52a4047600, ha_alter_info=0x7f52fc630b10) at 10.0-serg/storage/innobase/handler/handler0alter.cc:3883 #15 0x00000000006ecb55 in handler::ha_inplace_alter_table (this=0x7f52c411f9f8, altered_table=0x7f52a4047600, ha_alter_info=0x7f52fc630b10) at 10.0-serg/sql/handler.h:3488 #16 0x00000000006e5183 in mysql_inplace_alter_table (thd=0x483dc80, table_list=0x7f52a4005540, table=0x7f52c409e1b0, altered_table=0x7f52a4047600, ha_alter_info=0x7f52fc630b10, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f52fc6320b0, alter_ctx=0x7f52fc630c30) at 10.0-serg/sql/sql_table.cc:6417 #17 0x00000000006e97ed in mysql_alter_table (thd=0x483dc80, new_db=0x7f52a4005b08 "test", new_name=0x0, create_info=0x7f52fc6322f0, table_list=0x7f52a4005540, alter_info=0x7f52fc632400, order_num=0, order=0x0, ignore=false) at 10.0-serg/sql/sql_table.cc:8183 #18 0x00000000007517c5 in Sql_cmd_alter_table::execute (this=0x7f52a4005cb0, thd=0x483dc80) at 10.0-serg/sql/sql_alter.cc:312 #19 0x000000000063c358 in mysql_execute_command (thd=0x483dc80) at 10.0-serg/sql/sql_parse.cc:4952 #20 0x000000000063f58e in mysql_parse (thd=0x483dc80, rawbuf=0x7f52a4005418 "ALTER TABLE E ADD COLUMN filler VARCHAR(255) DEFAULT ' filler '", length=63, parser_state=0x7f52fc633510) at 10.0-serg/sql/sql_parse.cc:6264 #21 0x00000000006323c6 in dispatch_command (command=COM_QUERY, thd=0x483dc80, packet=0x4844291 "ALTER TABLE E ADD COLUMN filler VARCHAR(255) DEFAULT ' filler '", packet_length=63) at 10.0-serg/sql/sql_parse.cc:1277 #22 0x0000000000631800 in do_command (thd=0x483dc80) at 10.0-serg/sql/sql_parse.cc:983 #23 0x000000000074ce35 in do_handle_one_connection (thd_arg=0x483dc80) at 10.0-serg/sql/sql_connect.cc:1379 #24 0x000000000074cb88 in handle_one_connection (arg=0x483dc80) at 10.0-serg/sql/sql_connect.cc:1293 #25 0x00000000009d6c7b in pfs_spawn_thread (arg=0x46d2a00) at 10.0-serg/storage/perfschema/pfs.cc:1853 #26 0x00007f5312d99e9a in start_thread (arg=0x7f52fc634700) at pthread_create.c:308 #27 0x00007f5311e77cbd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
bzr version-info
revision-id: igor@askmonty.org-20130805141607-7fmq996gngriw72q revno: 3815 branch-nick: 10.0-serg
RQG grammar (test.yy):
query: update | administrative ; update: UPDATE IGNORE E SET `col_int_nokey` = _int ; administrative: ALTER TABLE E ADD COLUMN filler VARCHAR(255) DEFAULT ' filler ' | ALTER TABLE E DROP COLUMN filler ;
RQG command line:
perl ./runall-new.pl --threads=2 --duration=300 --queries=100M --grammar=test.yy --basedir=/home/elenst/bzr/10.0-serg/ --vardir1=/data/logs/merge
Gliffy Diagrams
Attachments
Issue Links
- is blocked by
-
MDEV-5242 merge 5.6 bugfixes into 10.0
-
- Open
-
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
The problem didn't happen on 10.0 for quite a while, and expectedly so since InnoDB 5.6.14 was merged into 10.0.8. Closing as fixed.