PS @ Percona-Server-5.6.13-rc60.5-434-debug.Linux.x86_64 (in QA-5.6 tree)
RQG @ 906 <email address hidden>
Thread 1 (LWP 4569):
+bt
#0 0x000000363720c69c in pthread_kill () from /lib64/libpthread.so.0
#1 0x00000000006874ae in handle_fatal_signal (sig=6) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/signal_handler.cc:251
#2 <signal handler called>
#3 0x0000003636e328a5 in raise () from /lib64/libc.so.6
#4 0x0000003636e34085 in abort () from /lib64/libc.so.6
#5 0x0000000000b57bb0 in thr_get_trx (thr=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/include/que0que.ic:36
#6 0x0000000000b601d6 in btr_cur_optimistic_insert (flags=23, cursor=0x7f4fcb320c20, offsets=0x7f4fcb320cc0, heap=0x7f4fcb320cf0, entry=0x7f4f5405cb28, rec=0x7f4fcb320cc8, big_rec=0x7f4fcb320cd0, n_ext=2, thr=0x0, mtr=0x7f4fcb320750) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/btr/btr0cur.cc:1478
#7 0x0000000000ac3f4d in row_merge_insert_index_tuples (trx_id=8278, index=0x7f4f540546e8, old_table=0x7f4fa4050908, fd=105, block=0x7f4fc75ac000 "\021\001\001\001\001\001\004\003\003\003\024\303\001", <incomplete sequence \303>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0merge.cc:2348
#8 0x0000000000ac9484 in row_merge_build_indexes (trx=0x7f4f540376e8, old_table=0x7f4fa4050908, new_table=0x7f4f54051b28, online=true, indexes=0x7f4f540510f8, key_numbers=0x7f4f54051160, n_indexes=13, table=0x7f4f54040550, add_cols=0x0, col_map=0x7f4f540516b8, add_autoinc=18446744073709551615, sequence=...) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/row/row0merge.cc:3567
#9 0x0000000000a13f4c in ha_innobase::inplace_alter_table (this=0x7f4f54009040, altered_table=0x7f4f54040550, ha_alter_info=0x7f4fcb322af0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/innobase/handler/handler0alter.cc:3899
#10 0x0000000000c675da in ha_inplace_alter_table (ha_alter_info=0x7f4fcb322af0, altered_table=0x7f4f54040550, this=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/handler.h:2888
#11 ha_partition::inplace_alter_table (this=0x7f4f540085c0, altered_table=0x7f4f54040550, ha_alter_info=0x7f4fcb322af0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/ha_partition.cc:7982
#12 0x000000000077f221 in ha_inplace_alter_table (ha_alter_info=0x7f4fcb322af0, altered_table=0x7f4f54040550, this=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/handler.h:2888
#13 mysql_inplace_alter_table (thd=0x2af1b80, table_list=0x7f4f54004e68, table=0x7f4f54007cd0, altered_table=0x7f4f54040550, ha_alter_info=0x7f4fcb322af0, inplace_supported=HA_ALTER_INPLACE_NO_LOCK_AFTER_PREPARE, target_mdl_request=0x7f4fcb3227f0, alter_ctx=0x7f4fcb3211d0) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_table.cc:6519
#14 0x0000000000784e97 in mysql_alter_table (thd=<optimized out>, new_db=0x7f4f54040550 " \016\004TO\177", new_name=0x7f4f00000000 <Address 0x7f4f00000000 out of bounds>, create_info=<optimized out>, table_list=0x7f4f54004e68, alter_info=0x7f4fcb323290, order_num=0, order=0x0, ignore=false) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_table.cc:8399
#15 0x0000000000894957 in Sql_cmd_alter_table::execute (this=<optimized out>, thd=0x2af1b80) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_alter.cc:317
#16 0x0000000000721e3b in mysql_execute_command (thd=0x2af1b80) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:5159
#17 0x0000000000728628 in mysql_parse (thd=0x2af1b80, rawbuf=0x2af3f40 "P\303\070\001", length=<optimized out>, parser_state=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:6479
#18 0x000000000072978c in dispatch_command (command=COM_QUERY, thd=0x2af1b80, packet=0x7f4fcb324a90 "\200\033\257\002", packet_length=75) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1355
#19 0x000000000072a987 in do_command (thd=0x2af1b80) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_parse.cc:1049
#20 0x00000000006ee1ef in do_handle_one_connection (thd_arg=<optimized out>) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1615
#21 0x00000000006ee2d7 in handle_one_connection (arg=0x2af1b80) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/sql/sql_connect.cc:1526
#22 0x00000000009e033a in pfs_spawn_thread (arg=0x2ad5440) at /bzr/5.6-QA_dbg/Percona-Server-5.6.13-rc60.5/storage/perfschema/pfs.cc:1858
#23 0x0000003637207851 in start_thread () from /lib64/libpthread.so.0
#24 0x0000003636ee890d in clone () from /lib64/libc.so.6
Some similarity with http://bugs.mysql.com/bug.php?id=53541 but stack differs.
2013-09-14 02:05:37 4180 [Note] /ssd/Percona-Server-5.6.13-rc60.5-434-debug.Linux.x86_64/bin/mysqld: ready for connections.
Version: '5.6.13-rc60.5-debug-log' socket: '/ssd//650526/current1_1/tmp/master.sock' port: 13000 Percona Server with XtraDB (GPL), Release rc60.5, Revision 434-debug
2013-09-14 02:07:39 7f4fcb325700 InnoDB: Assertion failure in thread 139980688217856 in file que0que.ic line 36
InnoDB: Failing assertion: thr
[...]
Query (7f4f54004c50): ALTER TABLE `table500_innodb_dynamic_key_pk_parts_2_int` KEY_BLOCK_SIZE = 0
Connection ID (thread ID): 20
Status: NOT_KILLED
Though this bug was never present in a release, it was not invalid. The patch for this was;
=== modified file 'Percona- Server/ storage/ innobase/ btr/btr0cur. cc' Server/ storage/ innobase/ btr/btr0cur. cc 2013-09-13 06:51:47 +0000 Server/ storage/ innobase/ btr/btr0cur. cc 2013-09-15 09:00:41 +0000
dtuple_ convert_ back_big_ rec(index, entry, big_rec_vec);
--- Percona-
+++ Percona-
@@ -1475,7 +1475,8 @@
}
- if (err == DB_FAIL && thr_get_ trx(thr) ->fake_ changes) { trx(thr) ->fake_ changes) {
fprintf( stderr, "btr_cur_ optimistic_ insert returning "
"DB_ FAIL\n" );
+ if (err == DB_FAIL && thr && thr_get_trx(thr)
+ && thr_get_
}