Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.1
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 ( |
pk INT NOT NULL, |
f1 INT, |
f2 CHAR(32) NOT NULL, |
f3 INT NOT NULL, |
f4 INT NOT NULL, |
f5 INT, |
f6 CHAR(32) NOT NULL, |
f7 CHAR(32), |
f8 CHAR(32), |
PRIMARY KEY (pk) |
) ENGINE=InnoDB;
|
|
INSERT INTO t1 VALUES |
(1,9,'a1',2,88,88,'c1','d1','e1'),(2,48,'a2',8,68,92,'c2','d2','e2'), |
(3,41,'a3',56,84,37,'c3','d3','e3'),(4,NULL,'a4',6,6,NULL,'c4','d4','e4'), |
(5,52,'a5',37,44,20,'c5','d5','e5'),(6,44,'a6',53,4,NULL,'c6','d6','e6'), |
(7,24,'a7',54,8,54,'c7','d7','e7'),(8,80,'a8',3,52,20,'c8','d8','e8'), |
(9,71,'a9',34,32,NULL,'c9','d9','e9'),(10,14,'a10',6,64,88,'c10','d10','e10'), |
(11,48,'a11',8,25,42,'c11','d11','e11'),(12,16,'a12',8,7,NULL,'c12','d12','e12'), |
(13,NULL,'a13',22,0,95,'c13','d13','e13'),(14,4,'a14',72,48,NULL,'c14','d14','e14'), |
(15,4,'a15',5,64,2,'c15','d15','e15'),(16,NULL,'a16',9,40,30,'c16','d16','e16'), |
(17,92,'a17',48,2,NULL,'c17','d17','e17'),(18,36,'a18',48,51,7,'c18','d18','e18'), |
(19,NULL,'a19',80,96,NULL,'c19','d19','e19'),(20,96,'a20',9,80,NULL,'c20','d20','e20'), |
(21,50,'a21',16,40,NULL,'c21','d21','e21'),(22,NULL,'a22',7,84,8,'c22','d22','e22'), |
(23,28,'a23',93,80,NULL,'c23','d23','e23'),(24,31,'a24',40,38,NULL,'c24','d24','e24'), |
(25,85,'a25',8,5,88,'c25','d25','e25'),(26,66,'a26',8,32,4,'c26','d26','e26'), |
(51,52,'a51',6,92,15,'c51','d51','e51'),(52,77,'a52',24,24,28,'c52','d52','e52'), |
(53,8,'a53',75,31,NULL,'c53','d53','e53'),(54,48,'a54',5,8,1,'c54','d54','e54'), |
(55,90,'a55',56,12,5,'c55','d55','e55'),(56,92,'a56',4,9,88,'c56','d56','e56'), |
(57,83,'a57',23,40,72,'c57','d57','e57'),(58,7,'a58',4,40,32,'c58','d58','e58'), |
(59,28,'a59',2,3,32,'c59','d59','e59'),(60,16,'a60',80,4,NULL,'c60','d60','e60'), |
(61,44,'a61',88,24,NULL,'c61','d61','e61'),(62,4,'a62',5,25,3,'c62','d62','e62'), |
(63,NULL,'a63',7,24,76,'c63','d63','e63'),(64,0,'a64',13,40,73,'c64','d64','e64'), |
(101,NULL,'a101',1,49,75,'c101','d101','e101'),(102,34,'a102',10,17,20,'c102','d102','e102'), |
(103,8,'a103',2,2,NULL,'c103','d103','e103'),(104,12,'a104',44,48,52,'c104','d104','e104'), |
(105,8,'a105',4,19,38,'c105','d105','e105'),(106,20,'a106',6,80,9,'c106','d106','e106'), |
(107,72,'a107',72,16,56,'c107','d107','e107'),(108,76,'a108',98,24,21,'c108','d108','e108'), |
(109,67,'a109',16,91,NULL,'c109','d109','e109'),(110,72,'a110',72,3,48,'c110','d110','e110'), |
(151,8,'a151',3,86,NULL,'c151','d151','e151'),(152,NULL,'a152',52,72,0,'c152','d152','e152'), |
(153,NULL,'a153',46,30,92,'c153','d153','e153'),(154,80,'a154',1,40,48,'c154','d154','e154'), |
(155,24,'a155',68,68,8,'c155','d155','e155'),(156,85,'a156',85,72,60,'c156','d156','e156'), |
(157,7,'a157',7,12,6,'c157','d157','e157'),(158,NULL,'a158',48,48,80,'c158','d158','e158'), |
(159,12,'a159',0,36,0,'c159','d159','e159'),(160,2,'a160',6,52,NULL,'c160','d160','e160'), |
(201,0,'a201',1,3,NULL,'c201','d201','e201'),(202,NULL,'a202',3,53,14,'c202','d202','e202'), |
(203,84,'a203',6,20,NULL,'c203','d203','e203'),(204,38,'a204',25,13,88,'c204','d204','e204'), |
(205,1,'a205',2,69,5,'c205','d205','e205'),(206,7,'a206',60,22,NULL,'c206','d206','e206'), |
(207,NULL,'a207',5,4,NULL,'c207','d207','e207'),(251,7,'a251',0,4,40,'c251','d251','e251'), |
(252,4,'a252',16,8,NULL,'c252','d252','e252'),(253,14,'a253',60,12,99,'c253','d253','e253'), |
(254,84,'a254',68,16,5,'c254','d254','e254'),(255,3,'a255',70,36,61,'c255','d255','e255'), |
(256,7,'a256',18,48,NULL,'c256','d256','e256'),(257,NULL,'a257',68,53,NULL,'c257','d257','e257'), |
(258,29,'a258',52,16,64,'c258','d258','e258'),(259,NULL,'a259',80,92,40,'c259','d259','e259'), |
(301,68,'a301',1,48,48,'c301','d301','e301'),(302,2,'a302',1,1,32,'c302','d302','e302'), |
(303,44,'a303',60,96,16,'c303','d303','e303'),(304,32,'a304',52,64,32,'c304','d304','e304'), |
(305,88,'a305',37,72,NULL,'c305','d305','e305'),(306,5,'a306',35,60,20,'c306','d306','e306'), |
(307,35,'a307',4,48,NULL,'c307','d307','e307'),(308,4,'a308',92,44,80,'c308','d308','e308'), |
(351,48,'a351',60,4,40,'c351','d351','e351'),(352,7,'a352',9,61,13,'c352','d352','e352'), |
(353,0,'a353',5,93,53,'c353','d353','e353'),(354,7,'a354',1,20,NULL,'c354','d354','e354'), |
(355,84,'a355',5,48,96,'c355','d355','e355'),(356,NULL,'a356',39,92,36,'c356','d356','e356'), |
(357,88,'a357',9,76,44,'c357','d357','e357'),(358,66,'a358',34,67,80,'c358','d358','e358'), |
(359,8,'a359',8,52,NULL,'c359','d359','e359'),(360,3,'a360',53,83,NULL,'c360','d360','e360'), |
(361,23,'a361',44,9,48,'c361','d361','e361'),(362,4,'a362',0,54,48,'c362','d362','e362'), |
(363,75,'a363',66,76,52,'c363','d363','e363') |
;
|
|
ALTER TABLE t1 ADD COLUMN x VARCHAR(255) DEFAULT ' foobar '; |
UPDATE t1 SET f1 = 0; |
ALTER TABLE t1 DROP COLUMN x; |
|
# Cleanup
|
DROP TABLE t1; |
10.4 27f3329ff6 |
mysqld: /data/src/10.4/storage/innobase/btr/btr0cur.cc:3743: dberr_t btr_cur_pessimistic_insert(ulint, btr_cur_t*, ulint**, mem_heap_t**, dtuple_t*, rec_t**, big_rec_t**, ulint, que_thr_t*, mtr_t*): Assertion `(flags & ulint(~BTR_KEEP_IBUF_BITMAP)) == BTR_NO_LOCKING_FLAG' failed.
|
181123 21:44:54 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007ff877ebaee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6
|
#8 0x0000558da6e53ae4 in btr_cur_pessimistic_insert (flags=7, cursor=0x7ff8711fbde0, offsets=0x7ff8711fbd00, heap=0x7ff8711fbd08, entry=0x7ff82805adf8, rec=0x7ff8711fbbc0, big_rec=0x7ff8711fbbb8, n_ext=2, thr=0x0, mtr=0x7ff8711fbf00) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:3742
|
#9 0x0000558da6e57fe2 in btr_cur_pessimistic_update (flags=10, cursor=0x7ff8711fbde0, offsets=0x7ff8711fbd00, offsets_heap=0x7ff8711fbd08, entry_heap=0x7ff828057ce0, big_rec=0x7ff8711fbd10, update=0x7ff82805a8e8, cmpl_info=1, thr=0x7ff82805a830, trx_id=46, mtr=0x7ff8711fbf00) at /data/src/10.4/storage/innobase/btr/btr0cur.cc:5057
|
#10 0x0000558da6c32529 in innobase_instant_try (ha_alter_info=0x7ff8711fdbb0, ctx=0x7ff828017218, altered_table=0x7ff8280555a0, table=0x7ff8280a7410, trx=0x7ff871cf8218) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:5586
|
#11 0x0000558da6c4cfcb in commit_try_norebuild (ha_alter_info=0x7ff8711fdbb0, ctx=0x7ff828017218, altered_table=0x7ff8280555a0, old_table=0x7ff8280a7410, trx=0x7ff871cf8218, table_name=0x7ff82812cded "t1") at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10013
|
#12 0x0000558da6c3fd02 in ha_innobase::commit_inplace_alter_table (this=0x7ff8280a8048, altered_table=0x7ff8280555a0, ha_alter_info=0x7ff8711fdbb0, commit=true) at /data/src/10.4/storage/innobase/handler/handler0alter.cc:10642
|
#13 0x0000558da68daa78 in handler::ha_commit_inplace_alter_table (this=0x7ff8280a8048, altered_table=0x7ff8280555a0, ha_alter_info=0x7ff8711fdbb0, commit=true) at /data/src/10.4/sql/handler.cc:4457
|
#14 0x0000558da66a4918 in mysql_inplace_alter_table (thd=0x7ff828000b00, table_list=0x7ff828014e80, table=0x7ff8280a7410, altered_table=0x7ff8280555a0, ha_alter_info=0x7ff8711fdbb0, inplace_supported=HA_ALTER_INPLACE_INSTANT, target_mdl_request=0x7ff8711fdce0, alter_ctx=0x7ff8711fe8d0) at /data/src/10.4/sql/sql_table.cc:7599
|
#15 0x0000558da66aa733 in mysql_alter_table (thd=0x7ff828000b00, new_db=0x7ff8280051b8, new_name=0x7ff828005588, create_info=0x7ff8711ff4c0, table_list=0x7ff828014e80, alter_info=0x7ff8711ff400, order_num=0, order=0x0, ignore=false) at /data/src/10.4/sql/sql_table.cc:9692
|
#16 0x0000558da67338bd in Sql_cmd_alter_table::execute (this=0x7ff8280154e8, thd=0x7ff828000b00) at /data/src/10.4/sql/sql_alter.cc:497
|
#17 0x0000558da65d2ab4 in mysql_execute_command (thd=0x7ff828000b00) at /data/src/10.4/sql/sql_parse.cc:6289
|
#18 0x0000558da65d79d8 in mysql_parse (thd=0x7ff828000b00, rawbuf=0x7ff828014d98 "ALTER TABLE t1 DROP COLUMN x", length=28, parser_state=0x7ff871200600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8091
|
#19 0x0000558da65c4cd7 in dispatch_command (command=COM_QUERY, thd=0x7ff828000b00, packet=0x7ff828093db1 "ALTER TABLE t1 DROP COLUMN x", packet_length=28, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
|
#20 0x0000558da65c36fb in do_command (thd=0x7ff828000b00) at /data/src/10.4/sql/sql_parse.cc:1396
|
#21 0x0000558da672db3c in do_handle_one_connection (connect=0x558da9d5c5c0) at /data/src/10.4/sql/sql_connect.cc:1402
|
#22 0x0000558da672d8c0 in handle_one_connection (arg=0x558da9d5c5c0) at /data/src/10.4/sql/sql_connect.cc:1308
|
#23 0x0000558da6bdb0a1 in pfs_spawn_thread (arg=0x558da9de1890) at /data/src/10.4/storage/perfschema/pfs.cc:1862
|
#24 0x00007ff879976494 in start_thread (arg=0x7ff871201700) at pthread_create.c:333
|
#25 0x00007ff877f7793f in clone () from /lib/x86_64-linux-gnu/libc.so.6
|
Not reproducible on 10.3.
Attachments
Issue Links
- is caused by
-
MDEV-17763 Assertion `len == 20U' failed in rec_convert_dtuple_to_rec_comp upon DROP COLUMN
- Closed
- relates to
-
MDEV-21405 Assertion `(flags & ulint(~BTR_KEEP_IBUF_BITMAP)) == BTR_NO_LOCKING_FLAG' failed in btr_cur_pessimistic_insert
- Closed