[MDEV-18076] InnoDB: Assertion failure in file storage/innobase/include/row0row.ic line 211 upon INSERT after DROP COLUMN Created: 2018-12-24  Updated: 2019-01-17  Resolved: 2018-12-27

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.4
Fix Version/s: 10.4.2

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

Issue Links:
Problem/Incident
causes MDEV-18149 InnoDB: Assertion failure in file /ho... Closed
Relates
relates to MDEV-17901 Assertion failure in file storage/inn... Closed
relates to MDEV-18077 Assertion `n < tuple->n_fields' faile... Closed

 Description   

--source include/have_innodb.inc
 
CREATE TABLE t1 (
  pk INT PRIMARY KEY,
  f INT,
  i INT AUTO_INCREMENT,
  t TIMESTAMP,
  KEY (i)
) ENGINE=InnoDB;
 
ALTER TABLE t1 DROP COLUMN f;
INSERT INTO t1 (pk) VALUES (1);
 
# Cleanup
DROP TABLE t1;

10.4 a8eb0c76b

2018-12-25 00:36:17 0x7fbe9ad54700  InnoDB: Assertion failure in file /data/src/10.4/storage/innobase/include/row0row.ic line 211
InnoDB: We intentionally generate a memory trap.
 
#5  0x00007fbea5a593fa in abort () from /lib/x86_64-linux-gnu/libc.so.6
#6  0x000055fc0b52108e in ut_dbg_assertion_failed (expr=0x0, file=0x55fc0baef510 "/data/src/10.4/storage/innobase/include/row0row.ic", line=211) at /data/src/10.4/storage/innobase/ut/ut0dbg.cc:60
#7  0x000055fc0b442522 in row_parse_int (data=0x7fbe4c051209 "\\!_a", '\245' <repeats 19 times>, "@\022\005L\276\177", len=4, mtype=3, unsigned_type=true) at /data/src/10.4/storage/innobase/include/row0row.ic:211
#8  0x000055fc0b43e8ea in row_ins_clust_index_entry_low (flags=0, mode=2, index=0x7fbe4c13b998, n_uniq=1, entry=0x7fbe4c07c4c8, n_ext=0, thr=0x7fbe4c0538e0, dup_chk_only=false) at /data/src/10.4/storage/innobase/row/row0ins.cc:2619
#9  0x000055fc0b4407ea in row_ins_clust_index_entry (index=0x7fbe4c13b998, entry=0x7fbe4c07c4c8, thr=0x7fbe4c0538e0, n_ext=0, dup_chk_only=false) at /data/src/10.4/storage/innobase/row/row0ins.cc:3252
#10 0x000055fc0b440ca0 in row_ins_index_entry (index=0x7fbe4c13b998, entry=0x7fbe4c07c4c8, thr=0x7fbe4c0538e0) at /data/src/10.4/storage/innobase/row/row0ins.cc:3377
#11 0x000055fc0b441375 in row_ins_index_entry_step (node=0x7fbe4c053650, thr=0x7fbe4c0538e0) at /data/src/10.4/storage/innobase/row/row0ins.cc:3545
#12 0x000055fc0b4417a9 in row_ins (node=0x7fbe4c053650, thr=0x7fbe4c0538e0) at /data/src/10.4/storage/innobase/row/row0ins.cc:3688
#13 0x000055fc0b441fa9 in row_ins_step (thr=0x7fbe4c0538e0) at /data/src/10.4/storage/innobase/row/row0ins.cc:3933
#14 0x000055fc0b461a67 in row_insert_for_mysql (mysql_rec=0x7fbe4c051200 "\377\001", prebuilt=0x7fbe4c0530c8, ins_mode=ROW_INS_NORMAL) at /data/src/10.4/storage/innobase/row/row0mysql.cc:1460
#15 0x000055fc0b2ff832 in ha_innobase::write_row (this=0x7fbe4c05ed38, record=0x7fbe4c051200 "\377\001") at /data/src/10.4/storage/innobase/handler/ha_innodb.cc:8066
#16 0x000055fc0afd9cc0 in handler::ha_write_row (this=0x7fbe4c05ed38, buf=0x7fbe4c051200 "\377\001") at /data/src/10.4/sql/handler.cc:6273
#17 0x000055fc0ac79279 in write_record (thd=0x7fbe4c000b00, table=0x7fbe4c052490, info=0x7fbe9ad52b90) at /data/src/10.4/sql/sql_insert.cc:2022
#18 0x000055fc0ac765fd in mysql_insert (thd=0x7fbe4c000b00, table_list=0x7fbe4c015080, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false) at /data/src/10.4/sql/sql_insert.cc:1063
#19 0x000055fc0acbcc59 in mysql_execute_command (thd=0x7fbe4c000b00) at /data/src/10.4/sql/sql_parse.cc:4730
#20 0x000055fc0acc78e4 in mysql_parse (thd=0x7fbe4c000b00, rawbuf=0x7fbe4c014f98 "INSERT INTO t1 (pk) VALUES (1)", length=30, parser_state=0x7fbe9ad53600, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:8104
#21 0x000055fc0acb4b0e in dispatch_command (command=COM_QUERY, thd=0x7fbe4c000b00, packet=0x7fbe4c00b421 "INSERT INTO t1 (pk) VALUES (1)", packet_length=30, is_com_multi=false, is_next_command=false) at /data/src/10.4/sql/sql_parse.cc:1851
#22 0x000055fc0acb3532 in do_command (thd=0x7fbe4c000b00) at /data/src/10.4/sql/sql_parse.cc:1396
#23 0x000055fc0ae1f6de in do_handle_one_connection (connect=0x55fc0e8c65e0) at /data/src/10.4/sql/sql_connect.cc:1402
#24 0x000055fc0ae1f462 in handle_one_connection (arg=0x55fc0e8c65e0) at /data/src/10.4/sql/sql_connect.cc:1308
#25 0x000055fc0b2de338 in pfs_spawn_thread (arg=0x55fc0e8c1580) at /data/src/10.4/storage/perfschema/pfs.cc:1862
#26 0x00007fbea750c494 in start_thread (arg=0x7fbe9ad54700) at pthread_create.c:333
#27 0x00007fbea5b0d93f in clone () from /lib/x86_64-linux-gnu/libc.so.6

Both debug and non-debug builds are affected.
Not reproducible on 10.3.



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

This looks very similar to MDEV-17901. But it is definitely repeatable, even though that fix is present.

Comment by Marko Mäkelä [ 2018-12-27 ]

It turns out that the MDEV-17901 fix was misplaced. Moving the fix to the appropriate place also fixes MDEV-18077.

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