[MDEV-237] LP:990187 - Assertion `share->reopen == 1' failed at maria_extra on ADD PARTITION Created: 2012-04-28  Updated: 2012-05-22  Resolved: 2012-05-22

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: None
Fix Version/s: 5.5.24

Type: Bug Priority: Critical
Reporter: Elena Stepanova Assignee: Michael Widenius
Resolution: Fixed Votes: 0
Labels: Aria


 Description   

https://bugs.launchpad.net/maria/+bug/990187

mysqld: storage/maria/ma_extra.c:288: maria_extra: Assertion `share->reopen == 1' failed.
 
#6 0x00007f544d7c0d4d in __GI___assert_fail (assertion=0xdf6f72 "share->reopen == 1", file=<optimized out>, line=288, function=<optimized out>) at assert.c:81
#7 0x0000000000997387 in maria_extra (info=0x34a0a90, function=HA_EXTRA_FORCE_REOPEN, extra_arg=0x0) at storage/maria/ma_extra.c:288
#8 0x0000000000952038 in ha_maria::extra (this=0x34cf618, operation=HA_EXTRA_FORCE_REOPEN) at storage/maria/ha_maria.cc:2510
#9 0x0000000000c7bf3a in ha_partition::loop_extra (this=0x34ceb28, operation=HA_EXTRA_FORCE_REOPEN) at sql/ha_partition.cc:6261
#10 0x0000000000c7b963 in ha_partition::extra (this=0x34ceb28, operation=HA_EXTRA_FORCE_REOPEN) at sql/ha_partition.cc:6025
#11 0x00000000005ad69f in wait_while_table_is_used (thd=0x3383fe0, table=0x34ce160, function=HA_EXTRA_FORCE_REOPEN) at sql/sql_base.cc:2341
#12 0x000000000091b73e in fast_alter_partition_table (thd=0x3383fe0, table=0x34ce160, alter_info=0x7f5442ea4660, create_info=0x7f5442ea4560, table_list=0x34867e8, db=0x3486db0 "test", table_name=0x34867b0 "t", fast_alter_table=0x3512590) at sql/sql_partition.cc:6823
#13 0x00000000006a9877 in mysql_alter_table (thd=0x3383fe0, new_db=0x3486db0 "test", new_name=0x34867b0 "t", create_info=0x7f5442ea4560, table_list=0x34867e8, alter_info=0x7f5442ea4660, order_num=0, order=0x0, ignore=false, require_online=false) at sql/sql_table.cc:6517
#14 0x000000000092ec66 in Alter_table_statement::execute (this=0x3486fd0, thd=0x3383fe0) at sql/sql_alter.cc:106
#15 0x00000000006119d9 in mysql_execute_command (thd=0x3383fe0) at sql/sql_parse.cc:4454
#16 0x0000000000614b7b in mysql_parse (thd=0x3383fe0, rawbuf=0x34866e8 "ALTER TABLE t ADD PARTITION PARTITIONS 2", length=40, parser_state=0x7f5442ea5500) at sql/sql_parse.cc:5731
#17 0x000000000060841f in dispatch_command (command=COM_QUERY, thd=0x3383fe0, packet=0x347eed1 "ALTER TABLE t ADD PARTITION PARTITIONS 2", packet_length=40) at sql/sql_parse.cc:1055
#18 0x00000000006076d6 in do_command (thd=0x3383fe0) at sql/sql_parse.cc:794
#19 0x0000000000707cef in do_handle_one_connection (thd_arg=0x3383fe0) at sql/sql_connect.cc:1253
#20 0x00000000007076da in handle_one_connection (arg=0x3383fe0) at sql/sql_connect.cc:1168
#21 0x0000000000bf6a1b in pfs_spawn_thread (arg=0x35077b0) at storage/perfschema/pfs.cc:1015
#22 0x00007f544e502efc in start_thread (arg=0x7f5442ea6700) at pthread_create.c:304
 
Query (0x34866e8): ALTER TABLE t ADD PARTITION PARTITIONS 2
Connection ID (thread ID): 2
Status: NOT_KILLED

bzr version-info

revision-id: sergii@pisem.net-20120421005728-b75h9qm83czzi89k
date: 2012-04-21 02:57:28 +0200
build-date: 2012-04-28 03:31:08 +0400
revno: 3388

Not reproducible on MariaDB 5.1, 5.2, 5.3.

  1. Test case:

CREATE TABLE t ( i INT ) ENGINE=Aria
  PARTITION BY HASH(i) PARTITIONS 2;
ALTER TABLE t ADD PARTITION PARTITIONS 2;



 Comments   
Comment by Michael Widenius [ 2012-05-16 ]

Fixed and pushed

Comment by Sergei Golubchik [ 2012-05-22 ]

I'm closing it, as lp:990187 is "Patch Committed"

Generated at Thu Feb 08 06:27:15 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.