Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.4.4, 10.4.5, 10.5.0, 10.5.4, 10.4.14, 10.6.0, 10.6
Description
Problem found during RQG testing
|
mysqld: storage/innobase/handler/handler0alter.cc:2289: virtual enum_alter_inplace_result ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*): Assertion `((((*af)->unireg_check) & 127U) == Field::NEXT_NUMBER) == (((f->unireg_check) & 127U) == Field::NEXT_NUMBER)' failed.
|
190417 16:04:44 [ERROR] mysqld got signal 6 ;
|
...
|
Query (0x7f8020013450): ALTER TABLE t4 MODIFY COLUMN col_int INTEGER NOT NULL, ALGORITHM = NOCOPY, LOCK = NONE /* E_R Thread5 QNO 3766 CON_ID 272 */
|
Connection ID (thread ID): 272
|
Status: NOT_KILLED
|
|
#3 <signal handler called>
|
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58
|
#5 0x00007f80d5dae37a in __GI_abort () at abort.c:89
|
#6 0x00007f80d5da4b47 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x5594655f9548 "((((*af)->unireg_check) & 127U) == Field::NEXT_NUMBER) == (((f->unireg_check) & 127U) == Field::NEXT_NUMBER)", file=file@entry=0x5594655f8268 "storage/innobase/handler/handler0alter.cc", line=line@entry=2289, function=function@entry=0x5594655fe620 <ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*)::__PRETTY_FUNCTION__> "virtual enum_alter_inplace_result ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*)") at assert.c:92
|
#7 0x00007f80d5da4bf2 in __GI___assert_fail (assertion=0x5594655f9548 "((((*af)->unireg_check) & 127U) == Field::NEXT_NUMBER) == (((f->unireg_check) & 127U) == Field::NEXT_NUMBER)", file=0x5594655f8268 "storage/innobase/handler/handler0alter.cc", line=2289, function=0x5594655fe620 <ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*)::__PRETTY_FUNCTION__> "virtual enum_alter_inplace_result ha_innobase::check_if_supported_inplace_alter(TABLE*, Alter_inplace_info*)") at assert.c:101
|
#8 0x0000559464d5110b in ha_innobase::check_if_supported_inplace_alter (this=0x7f80284b4e90, altered_table=0x7f80b831c6e0, ha_alter_info=0x7f80b831c650) at storage/innobase/handler/handler0alter.cc:2289
|
#9 0x00005594648a3828 in mysql_alter_table (thd=0x7f8020000a98, new_db=0x7f8020005240, new_name=0x7f8020005648, create_info=0x7f80b831ed40, table_list=0x7f80200135f8, alter_info=0x7f80b831ec80, order_num=0, order=0x0, ignore=false) at sql/sql_table.cc:9939
|
#10 0x00005594649341b3 in Sql_cmd_alter_table::execute (this=0x7f8020013dd8, thd=0x7f8020000a98) at sql/sql_alter.cc:496
|
#11 0x00005594647c4788 in mysql_execute_command (thd=0x7f8020000a98) at sql/sql_parse.cc:6344
|
|
10.4 ee4a2fef18136165a3267b4429e5921fc306cc20 2019-04-17
|
#12 0x00005594647c9a47 in mysql_parse (thd=0x7f8020000a98, rawbuf=0x7f8020013450 "ALTER TABLE t4 MODIFY COLUMN col_int INTEGER NOT NULL, ALGORITHM = NOCOPY, LOCK = NONE /* E_R Thread5 QNO 3766 CON_ID 272 */", length=125, parser_state=0x7f80b83201d0, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8154
|
#13 0x00005594647b5122 in dispatch_command (command=COM_QUERY, thd=0x7f8020000a98, packet=0x7f802000a059 " ALTER TABLE t4 MODIFY COLUMN col_int INTEGER NOT NULL, ALGORITHM = NOCOPY, LOCK = NONE /* E_R Thread5 QNO 3766 CON_ID 272 */ ", packet_length=127, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:1832
|
#14 0x00005594647b38e2 in do_command (thd=0x7f8020000a98) at sql/sql_parse.cc:1365
|
#15 0x000055946492b133 in do_handle_one_connection (connect=0x55946933c178) at sql/sql_connect.cc:1398
|
#16 0x000055946492ae97 in handle_one_connection (arg=0x55946933c178) at sql/sql_connect.cc:1301
|
#17 0x00007f80d6bf16da in start_thread (arg=0x7f80b8321700) at pthread_create.c:456
|
#18 0x00007f80d5e7fd7f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:105
|
|
No replay of the problem on
|
10.3.15 commit a2335b791aa06fbf4b784486ed9d34ba75af9d51 2019-04-15
|
Attachments
Issue Links
- is caused by
-
MDEV-12836 Avoid table rebuild when removing of auto_increment settings
- Closed
- relates to
-
MDEV-24511 null field is created with CREATE..SELECT
- Closed
-
MDEV-26224 InnoDB fails to remove AUTO_INCREMENT attribute
- Closed