InnoDB: Failing assertion: thr in file que0que.ic line 36 | abort (sig=6) in thr_get_trx

Bug #1225237 reported by Roel Van de Paar
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
Critical
Unassigned

Bug Description

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

Tags: qa qablock
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
Revision history for this message
Roel Van de Paar (roel11) wrote :
no longer affects: percona-server/5.1
no longer affects: percona-server/5.5
no longer affects: percona-server/5.6
Changed in percona-server:
assignee: Laurynas Biveinis (laurynas-biveinis) → Roel Van de Paar (roel11)
status: Confirmed → Invalid
Revision history for this message
Roel Van de Paar (roel11) wrote :

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'
--- Percona-Server/storage/innobase/btr/btr0cur.cc 2013-09-13 06:51:47 +0000
+++ Percona-Server/storage/innobase/btr/btr0cur.cc 2013-09-15 09:00:41 +0000
@@ -1475,7 +1475,8 @@
                        dtuple_convert_back_big_rec(index, entry, big_rec_vec);
                }

- if (err == DB_FAIL && thr_get_trx(thr)->fake_changes) {
+ if (err == DB_FAIL && thr && thr_get_trx(thr)
+ && thr_get_trx(thr)->fake_changes) {
                        fprintf(stderr, "btr_cur_optimistic_insert returning "
                                "DB_FAIL\n");
                }

Revision history for this message
Roel Van de Paar (roel11) wrote :

Fixed by Laurynas in revid 435 of 5.6-QA tree

Changed in percona-server:
status: Invalid → Fix Released
importance: Low → Critical
assignee: Roel Van de Paar (roel11) → nobody
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-373

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.