[MDEV-17901] Assertion failure in file storage/innobase/include/row0row.ic line 211 after dropping column Created: 2018-12-04  Updated: 2019-01-17  Resolved: 2018-12-11

Status: Closed
Project: MariaDB Server
Component/s: Data Definition - Alter Table, Storage Engine - InnoDB
Affects Version/s: 10.4.0
Fix Version/s: 10.4.1

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Marko Mäkelä
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Problem/Incident
is caused by MDEV-15562 Instant DROP COLUMN or changing the o... Closed
Relates
relates to MDEV-18149 InnoDB: Assertion failure in file /ho... Closed
relates to MDEV-17735 Assertion failure in row_parse_int() ... Closed
relates to MDEV-18076 InnoDB: Assertion failure in file sto... Closed

 Description   

--source include/have_innodb.inc
 
CREATE TABLE t1 (id INT NOT NULL AUTO_INCREMENT, f CHAR(8) NOT NULL DEFAULT '', KEY(id)) ENGINE=InnoDB;
ALTER TABLE t1 DROP COLUMN id;
INSERT INTO t1 () VALUES (),();
 
# Cleanup
DROP TABLE t1;

10.4 f89a27b4e5

2018-12-04 20:17:30 0x7ff6180c1700  InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/include/row0row.ic line 211
InnoDB: We intentionally generate a memory trap.
 
#6  0x000055d182dbd213 in ut_dbg_assertion_failed (expr=0x0, file=0x55d183380f50 "/data/src/10.4/storage/innobase/include/row0row.ic", line=211) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60
#7  0x000055d182cde312 in row_parse_int (data=0x7ff5c8059ad1 "        ", '\245' <repeats 23 times>, len=8, mtype=2, unsigned_type=false) at /data/src/10.4/storage/innobase/include/row0row.ic:211
#8  0x000055d182cda6da in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7ff5c812d6a8, n_uniq=0, entry=0x7ff5c812fc58, n_ext=0, thr=0x7ff5c812f510, dup_chk_only=false) at /data/src/10.4/storage/innobase/row/row0ins.cc:2619
#9  0x000055d182cdc5da in row_ins_clust_index_entry (index=0x7ff5c812d6a8, entry=0x7ff5c812fc58, thr=0x7ff5c812f510, n_ext=0, dup_chk_only=false) at /data/src/10.4/storage/innobase/row/row0ins.cc:3252
#10 0x000055d182cdca90 in row_ins_index_entry (index=0x7ff5c812d6a8, entry=0x7ff5c812fc58, thr=0x7ff5c812f510) at /data/src/10.4/storage/innobase/row/row0ins.cc:3377
#11 0x000055d182cdd165 in row_ins_index_entry_step (node=0x7ff5c812f2b0, thr=0x7ff5c812f510) at /data/src/10.4/storage/innobase/row/row0ins.cc:3545
#12 0x000055d182cdd599 in row_ins (node=0x7ff5c812f2b0, thr=0x7ff5c812f510) at /data/src/10.4/storage/innobase/row/row0ins.cc:3688
#13 0x000055d182cddd99 in row_ins_step (thr=0x7ff5c812f510) at /data/src/10.4/storage/innobase/row/row0ins.cc:3933
#14 0x000055d182cfd85d in row_insert_for_mysql (mysql_rec=0x7ff5c8059ad0 "\377        ", '\245' <repeats 23 times>, prebuilt=0x7ff5c812ed98, ins_mode=ROW_INS_NORMAL) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1460
#15 0x000055d182b9b7b6 in ha_innobase::write_row (this=0x7ff5c805a0d8, record=0x7ff5c8059ad0 "\377        ", '\245' <repeats 23 times>) at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8045
#16 0x000055d18287b652 in handler::ha_write_row (this=0x7ff5c805a0d8, buf=0x7ff5c8059ad0 "\377        ", '\245' <repeats 23 times>) at /data/src/10.4/sql/handler.cc:6238
#17 0x000055d182520a0b in write_record (thd=0x7ff5c8000b00, table=0x7ff5c812e160, info=0x7ff6180bfb80) at /data/src/10.4/sql/sql_insert.cc:2022
#18 0x000055d18251dd97 in mysql_insert (thd=0x7ff5c8000b00, table_list=0x7ff5c8014e90, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1063
#19 0x000055d18256419f in mysql_execute_command (thd=0x7ff5c8000b00) at /data/src/10.4/sql/sql_parse.cc:4732
#20 0x000055d18256ed5e in mysql_parse (thd=0x7ff5c8000b00, rawbuf=0x7ff5c8014da8 "INSERT INTO t1 () VALUES (),()", length=30, parser_state=0x7ff6180c0600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8092
#21 0x000055d18255c04c in dispatch_command (command=COM_QUERY, thd=0x7ff5c8000b00, packet=0x7ff5c8093c71 "INSERT INTO t1 () VALUES (),()", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
#22 0x000055d18255aa70 in do_command (thd=0x7ff5c8000b00) at /data/src/10.4/sql/sql_parse.cc:1396
#23 0x000055d1826c613e in do_handle_one_connection (connect=0x55d184d01340) at /data/src/10.4/sql/sql_connect.cc:1402
#24 0x000055d1826c5ec2 in handle_one_connection (arg=0x55d184d01340) at /data/src/10.4/sql/sql_connect.cc:1308
#25 0x000055d182b7a3a2 in pfs_spawn_thread (arg=0x55d184d866c0) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#26 0x00007ff61f1d4494 in start_thread (arg=0x7ff6180c1700) at pthread_create.c:333
#27 0x00007ff61d7d593f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Not reproducible on 10.3.



 Comments   
Comment by Marko Mäkelä [ 2018-12-11 ]

We failed to reset the dict_table_t::persistent_autoinc when instantly dropping an AUTO_INCREMENT column.

Generated at Thu Feb 08 08:40:00 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.