Percona Server moved to https://jira.percona.com/projects/PS

InnoDB: Failing assertion: DICT_TF2_FLAG_IS_SET(index->table, DICT_TF2_TEMPORARY) in trx_undo_report_row_operation

Bug #1414624 reported by Ramesh Sivaraman
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Incomplete
Undecided
Unassigned
5.1
Won't Fix
Undecided
Unassigned
5.5
Incomplete
Undecided
Unassigned
5.6
Incomplete
Undecided
Unassigned

Bug Description

** Startup
/sda/Percona-Server-5.6.22-rel71.0-729.Linux.x86_64-debug/bin/mysqld --no-defaults --event-scheduler=ON --maximum-bulk_insert_buffer_size=1M --maximum-join_buffer_size=1M --maximum-max_heap_table_size=1M --maximum-max_join_size=1M --maximum-myisam_max_sort_file_size=1M --maximum-myisam_mmap_size=1M --maximum-myisam_sort_buffer_size=1M --maximum-optimizer_trace_max_mem_size=1M --maximum-preload_buffer_size=1M --maximum-query_alloc_block_size=1M --maximum-query_prealloc_size=1M --maximum-range_alloc_block_size=1M --maximum-read_buffer_size=1M --maximum-read_rnd_buffer_size=1M --maximum-sort_buffer_size=1M --maximum-tmp_table_size=1M --maximum-transaction_alloc_block_size=1M --maximum-transaction_prealloc_size=1M --log-output=none --sql_mode=ONLY_FULL_GROUP_BY --enforce_storage_engine=INNODB --basedir=/sda/Percona-Server-5.6.22-rel71.0-729.Linux.x86_64-debug --datadir=/dev/shm/012728/11247/data --tmpdir=/dev/shm/012728/11247/tmp

** GDB info

#0 0x00007f0f0e2d3771 in pthread_kill () from /lib64/libpthread.so.0
#1 0x0000000000ab978e in my_write_core (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-7
1.0/mysys/stacktrace.c:422
#2 0x00000000007301a3 in handle_fatal_signal (sig=6) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.
6.22-71.0/sql/signal_handler.cc:236
#3 <signal handler called>
#4 0x00007f0f0ced75c9 in raise () from /lib64/libc.so.6
#5 0x00007f0f0ced8cd8 in abort () from /lib64/libc.so.6
#6 0x0000000000c52006 in trx_undo_report_row_operation (flags=0, op_type=1, thr=0x7f0eee95a998, index=0x7f0eee082678, clust_entry=0x7f0eea1b5a78, upd
ate=0x0, cmpl_info=0, rec=0x0, offsets=0x0, roll_ptr=0x7f0f0e8885b0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/pe
rcona-server-5.6.22-71.0/storage/innobase/trx/trx0rec.cc:1242
#7 0x0000000000c9ac84 in btr_cur_ins_lock_and_undo (flags=0, cursor=0x7f0f0e888710, entry=0x7f0eea1b5a78, thr=0x7f0eee95a998, mtr=0x7f0f0e888790, inh
erit=0x7f0f0e888620) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/btr/bt
r0cur.cc:1274
#8 0x0000000000c9b3e7 in btr_cur_optimistic_insert (flags=0, cursor=0x7f0f0e888710, offsets=0x7f0f0e888c80, heap=0x7f0f0e888c70, entry=0x7f0eea1b5a78
, rec=0x7f0f0e888c68, big_rec=0x7f0f0e888c78, n_ext=0, thr=0x7f0eee95a998, mtr=0x7f0f0e888790) at /mnt/workspace/percona-server-5.6-binaries-debug-yas
sl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/btr/btr0cur.cc:1501
#9 0x0000000000bc23a3 in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7f0eee082678, n_uniq=0, entry=0x7f0eea1b5a78, n_ext=0, thr=0x7f0eee9
5a998) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0ins.cc:2493
#10 0x0000000000bc32e7 in row_ins_clust_index_entry (index=0x7f0eee082678, entry=0x7f0eea1b5a78, thr=0x7f0eee95a998, n_ext=0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0ins.cc:2897
#11 0x0000000000bc35e7 in row_ins_index_entry (index=0x7f0eee082678, entry=0x7f0eea1b5a78, thr=0x7f0eee95a998) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0ins.cc:2995
#12 0x0000000000bc38c8 in row_ins_index_entry_step (node=0x7f0eee95a620, thr=0x7f0eee95a998) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0ins.cc:3072
#13 0x0000000000bc3bcc in row_ins (node=0x7f0eee95a620, thr=0x7f0eee95a998) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0ins.cc:3212
#14 0x0000000000bc3f51 in row_ins_step (thr=0x7f0eee95a998) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0ins.cc:3337
#15 0x0000000000bdc2ba in row_insert_for_mysql (mysql_rec=0x7f0eeea68410 "Tì>\031", prebuilt=0x7f0eee95a078) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/row/row0mysql.cc:1367
#16 0x0000000000ad8c6d in ha_innobase::write_row (this=0x7f0eee3c1110, record=0x7f0eeea68410 "Tì>\031") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/innobase/handler/ha_innodb.cc:7296
#17 0x000000000064cfba in handler::ha_write_row (this=0x7f0eee3c1110, buf=0x7f0eeea68410 "Tì>\031") at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/handler.cc:7659
#18 0x0000000000712559 in Log_to_csv_event_handler::log_general (this=0x7f0f0c7ff178, thd=0x7f0ef5ac9000, event_time=1422109758, user_host=0x7f0f0e889890 "root[root] @ localhost []", user_host_len=25, thread_id=5, command_type=0xf4e8cc "Query", command_type_len=5, sql_text=0x7f0eeea7f010 "ALTER TABLE t1 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL", sql_text_len=53, client_cs=0x1769d40 <my_charset_tis620_thai_ci>) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/log.cc:512
#19 0x0000000000713fa4 in LOGGER::general_log_write (this=0x187c0c0 <logger>, thd=0x7f0ef5ac9000, command=COM_QUERY, query=0x7f0eeea7f010 "ALTER TABLE t1 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL", query_length=53) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/log.cc:1160
#20 0x0000000000717ade in general_log_write (thd=0x7f0ef5ac9000, command=COM_QUERY, query=0x7f0eeea7f010 "ALTER TABLE t1 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL", query_length=53) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/log.cc:2403
#21 0x00000000007edce7 in mysql_parse (thd=0x7f0ef5ac9000, rawbuf=0x7f0eeea7f010 "ALTER TABLE t1 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL", length=53, parser_state=0x7f0f0e889df0) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:6863
#22 0x00000000007dfdb7 in dispatch_command (command=COM_QUERY, thd=0x7f0ef5ac9000, packet=0x7f0ef5acd001 "ALTER TABLE t1 CHANGE c1 c1 INTEGER UNSIGNED NOT NULL;", packet_length=54) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1434
#23 0x00000000007decd5 in do_command (thd=0x7f0ef5ac9000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_parse.cc:1051
#24 0x00000000007a6c4d in do_handle_one_connection (thd_arg=0x7f0efc771000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1532
#25 0x00000000007a6755 in handle_one_connection (arg=0x7f0efc771000) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/sql/sql_connect.cc:1443
#26 0x0000000000dc9e60 in pfs_spawn_thread (arg=0x7f0f07b46240) at /mnt/workspace/percona-server-5.6-binaries-debug-yassl/label_exp/centos6-64/percona-server-5.6.22-71.0/storage/perfschema/pfs.cc:1860
#27 0x00007f0f0e2cedf3 in start_thread () from /lib64/libpthread.so.0
#28 0x00007f0f0cf981ad in clone () from /lib64/libc.so.6

Tags: qa
Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

Core, GDB, error log etc
Single threaded run, single mysqld involved

Revision history for this message
Laurynas Biveinis (laurynas-biveinis) wrote :

Where is the testcase?

What is the upstream status of the bug?

Revision history for this message
Valerii Kravchuk (valerii-kravchuk) wrote :

I know the following similar upstream reports:

http://bugs.mysql.com/bug.php?id=72080 - still "Open"
http://bugs.mysql.com/bug.php?id=73102 - private, but Google says:

"Jun 24, 2014 - ... regular memcached on MySQL memcached there is an assertion failure: InnoDB: Failing assertion: DICT_TF2_FLAG_IS_SET(index->table, ..."

about it.

Revision history for this message
Ramesh Sivaraman (rameshvs02) wrote :

pquery run reported this bug in many trials but could not reduce the testcase.

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

Laurynas, any hopes of the core telling more?

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

I too tried to reproduce without success

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-3252

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

Other bug subscribers

Remote bug watches

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