Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4.0
-
None
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.
Attachments
Issue Links
- is caused by
-
MDEV-15562 Instant DROP COLUMN or changing the order of columns
- Closed
- relates to
-
MDEV-18149 InnoDB: Assertion failure in file /home/travis/src/storage/innobase/include/row0row.ic line 211 upon REPLACE after DROP COLUMN
- Closed
-
MDEV-17735 Assertion failure in row_parse_int() on first ADD/DROP COLUMN when an AUTO_INCREMENT column is not in PRIMARY KEY
- Closed
-
MDEV-18076 InnoDB: Assertion failure in file storage/innobase/include/row0row.ic line 211 upon INSERT after DROP COLUMN
- Closed