ALTER table Crash in highperf release

Bug #327726 reported by Percona
2
Affects Status Importance Assigned to Milestone
Percona patches
Fix Released
Critical
Unassigned

Bug Description

ALTER TABLE art55.article55 ADD `domain_id` INT UNSIGNED NOT NULL AFTER `site_id`,
    -> ADD `subdomain_id` INT UNSIGNED NOT NULL AFTER `domain_id`;

InnoDB: Assertion failure in thread 1283164512 in file btr0sea.c line 967
InnoDB: Failing assertion: 0 == ut_dulint_cmp(tree_id, index->id)
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
InnoDB: Thread 1256540512 stopped in file row0sel.c line 2088
090210 10:59:12 - mysqld got signal 11 ;

Program received signal SIGSEGV, Segmentation fault.
[Switching to Thread 1265858912 (LWP 30454)]
0x00000000006f30a0 in btr_search_drop_page_hash_index ()
(gdb) bt
#0 0x00000000006f30a0 in btr_search_drop_page_hash_index ()
#1 0x000000000071fa0e in buf_LRU_search_and_free_block ()
#2 0x000000000071fd72 in buf_LRU_get_free_block ()
#3 0x000000000071290f in buf_page_init_for_read ()
#4 0x000000000072178f in buf_LRU_print ()
#5 0x000000000072250c in buf_read_ahead_linear ()
#6 0x0000000000717ff7 in buf_page_get_gen ()
#7 0x00000000006ed7c0 in btr_pcur_move_to_next_page ()
#8 0x00000000006c21bc in row_search_for_mysql ()
#9 0x000000000061aaeb in ha_innobase::general_fetch ()
#10 0x000000000061ae2a in ha_innobase::rnd_next ()
#11 0x000000000060a095 in rr_sequential ()
#12 0x00000000006299f3 in mysql_alter_table ()
#13 0x00000000005725e0 in mysql_execute_command ()
#14 0x0000000000572c90 in mysql_parse ()
#15 0x00000000005733ec in dispatch_command ()
#16 0x0000000000574d41 in handle_one_connection ()
#17 0x00000030e4b06137 in start_thread () from /lib64/tls/libpthread.so.0
#18 0x00000030e42c9883 in clone () from /lib64/tls/libc.so.6

Percona (percona-team)
Changed in percona-patches:
importance: Undecided → Critical
Revision history for this message
Percona (percona-team) wrote :

I see this problem only in -highperf release, not in regular one

Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

I have pushed the branch.

I think the fix should avoid this bug.
Please try it.

Changed in percona-patches:
assignee: nobody → yasufumi-kinoshita
status: New → Fix Committed
Changed in percona-patches:
status: Fix Committed → Fix Released
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.