Crash in handler::mark_trx_read_write on ALTER TABLE after REPAIR non-existing partition
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MariaDB |
New
|
Undecided
|
Sergei Golubchik |
Bug Description
#3 0x081ba181 in handle_segfault (sig=11) at /home/elenst/
#4 <signal handler called>
#5 0x083e9e65 in handler:
#6 0x083e8e1b in handler:
#7 0x08861325 in ha_partition:
at /home/elenst/
#8 0x083e8e49 in handler:
at /home/elenst/
#9 0x082eb76e in copy_data_
order_num=1, order=0xa156048, copied=0x826771e0, deleted=0x826771d8, keys_onoff=
at /home/elenst/
#10 0x082e9937 in mysql_alter_table (thd=0xa0aab80, new_db=0xa155f98 "test", new_name=0xa155b70 "t", create_
table_
at /home/elenst/
#11 0x08536363 in Alter_table_
at /home/elenst/
#12 0x0825fcc8 in mysql_execute_
#13 0x08262b02 in mysql_parse (thd=0xa0aab80, rawbuf=0xa155ae8 "ALTER TABLE t ORDER BY b", length=24, parser_
at /home/elenst/
#14 0x08256fb5 in dispatch_command (command=COM_QUERY, thd=0xa0aab80, packet=0xa149639 "ALTER TABLE t ORDER BY b",
packet_
#15 0x0825647a in do_command (thd=0xa0aab80) at /home/elenst/
#16 0x0833dd18 in do_handle_
#17 0x0833d866 in handle_
#18 0x0855b199 in pfs_spawn_thread (arg=0xa1aa490) at /home/elenst/
#19 0xb771bb25 in start_thread () from /lib/libpthread
bzr version-info
revision-id: <email address hidden>
date: 2012-01-11 13:35:27 +0100
build-date: 2012-01-16 03:06:55 +0400
revno: 3214
branch-nick: maria-5.5
Also reproducible on MySQL 5.5.20 and 5.6.4, filed as http://
Test case:
CREATE TABLE t ( a INT, b INT );
INSERT INTO t VALUES (5,3),(5,6);
ALTER TABLE t PARTITION BY KEY(b) PARTITIONS 3 ;
ALTER TABLE t REPAIR PARTITION p1, p3;
ALTER TABLE t ORDER BY b;
Changed in maria: | |
assignee: | nobody → Sergei (sergii) |
summary: |
- Crash in handler::ha_thd on ALTER TABLE after REPAIR non-existing - partition + Crash in handler::mark_trx_read_write on ALTER TABLE after REPAIR non- + existing partition |
tags: | added: crash partitions upstream |
Also filed as JIRA issue MDEV-111