Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.3(EOL), 10.4(EOL)
-
None
Description
--source include/have_innodb.inc
|
|
CREATE TABLE t1 (f VARCHAR(1), row_start BIGINT UNSIGNED AS ROW START, row_end BIGINT UNSIGNED AS ROW END, PERIOD FOR SYSTEM_TIME(row_start,row_end)) WITH SYSTEM VERSIONING ENGINE=InnoDB; |
INSERT INTO t1 (f) VALUES ('a'),('b'),('c'),('d'),('e'),('f'),('g'),('h'); |
DELETE FROM t1; |
DELETE HISTORY FROM t1; |
|
# Cleanup
|
DROP TABLE t1; |
10.3 95d783af non-debug |
#3 <signal handler called>
|
#4 row_upd_del_mark_clust_rec (mtr=0x7faec61a4ff0, foreign=false, referenced=0, thr=0x7fae780737d0, offsets=0x7faec61a46d0, index=0x7fae78071ae0, node=0x7fae780734a8) at /data/src/10.3/storage/innobase/row/row0upd.cc:2987
|
#5 row_upd_clust_step (node=node@entry=0x7fae780734a8, thr=thr@entry=0x7fae780737d0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3172
|
#6 0x0000562f59cc38c4 in row_upd (thr=0x7fae780737d0, node=0x7fae780734a8) at /data/src/10.3/storage/innobase/row/row0upd.cc:3299
|
#7 row_upd_step (thr=thr@entry=0x7fae780737d0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3443
|
#8 0x0000562f59c98b9c in row_update_for_mysql (prebuilt=0x7fae780729b0) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1887
|
#9 0x0000562f59becb3e in ha_innobase::delete_row (this=0x7fae78072220, record=0x7fae78080018 "\376\001g$") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8999
|
#10 0x0000562f59a85f84 in handler::ha_delete_row (this=0x7fae78072220, buf=0x7fae78080018 "\376\001g$") at /data/src/10.3/sql/handler.cc:6534
|
#11 0x0000562f59b93947 in mysql_delete (thd=thd@entry=0x7fae780009a8, table_list=0x7fae7800f528, conds=<optimized out>, order_list=order_list@entry=0x7fae780050a0, limit=18446744073709551609, options=<optimized out>, result=0x0) at /data/src/10.3/sql/sql_delete.cc:747
|
#12 0x0000562f598baf71 in mysql_execute_command (thd=thd@entry=0x7fae780009a8) at /data/src/10.3/sql/sql_parse.cc:4655
|
#13 0x0000562f598bc809 in mysql_parse (thd=thd@entry=0x7fae780009a8, rawbuf=<optimized out>, length=22, parser_state=parser_state@entry=0x7faec61a7630, is_com_multi=<optimized out>, is_next_command=<optimized out>) at /data/src/10.3/sql/sql_parse.cc:7824
|
#14 0x0000562f598bf055 in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fae780009a8, packet=packet@entry=0x7fae780070a9 "DELETE HISTORY FROM t1", packet_length=packet_length@entry=22, is_com_multi=is_com_multi@entry=false, is_next_command=is_next_command@entry=false) at /data/src/10.3/sql/sql_parse.cc:1858
|
#15 0x0000562f598bfcc6 in do_command (thd=0x7fae780009a8) at /data/src/10.3/sql/sql_parse.cc:1403
|
#16 0x0000562f599861d4 in do_handle_one_connection (connect=connect@entry=0x562f5b8df878) at /data/src/10.3/sql/sql_connect.cc:1402
|
#17 0x0000562f59986354 in handle_one_connection (arg=arg@entry=0x562f5b8df878) at /data/src/10.3/sql/sql_connect.cc:1308
|
#18 0x0000562f59ef1a84 in pfs_spawn_thread (arg=0x562f5b8a03f8) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#19 0x00007faed28b64a4 in start_thread (arg=0x7faec61a8700) at pthread_create.c:456
|
#20 0x00007faed0dfed0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
10.3 debug |
mysqld: /data/src/10.3/storage/innobase/row/row0upd.cc:3489: void upd_node_t::make_versioned_helper(const trx_t*, ulint): Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' failed.
|
190620 20:52:35 [ERROR] mysqld got signal 6 ;
|
|
#7 0x00007f0ffea1ff12 in __GI___assert_fail (assertion=0x556ab5dc1158 "update->n_fields < ulint(table->n_cols + table->n_v_cols)", file=0x556ab5dc0358 "/data/src/10.3/storage/innobase/row/row0upd.cc", line=3489, function=0x556ab5dc3d40 <upd_node_t::make_versioned_helper(trx_t const*, unsigned long)::__PRETTY_FUNCTION__> "void upd_node_t::make_versioned_helper(const trx_t*, ulint)") at assert.c:101
|
#8 0x0000556ab56d0fe1 in upd_node_t::make_versioned_helper (this=0x7f0fa80a7028, trx=0x7f0ff88b60f0, idx=1) at /data/src/10.3/storage/innobase/row/row0upd.cc:3489
|
#9 0x0000556ab56d1126 in upd_node_t::make_versioned_update (this=0x7f0fa80a7028, trx=0x7f0ff88b60f0) at /data/src/10.3/storage/innobase/row/row0upd.cc:3512
|
#10 0x0000556ab56753cf in row_update_for_mysql (prebuilt=0x7f0fa80a64f8) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1878
|
#11 0x0000556ab551b1c9 in ha_innobase::delete_row (this=0x7f0fa80a5d48, record=0x7f0fa8184cb0 "\376\001f$") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8999
|
#12 0x0000556ab53139ac in handler::ha_delete_row (this=0x7f0fa80a5d48, buf=0x7f0fa8184cb0 "\376\001f$") at /data/src/10.3/sql/handler.cc:6534
|
#13 0x0000556ab54a6ed5 in TABLE::delete_row (this=0x7f0fa80a5100) at /data/src/10.3/sql/sql_delete.cc:253
|
#14 0x0000556ab54a4238 in mysql_delete (thd=0x7f0fa8000b00, table_list=0x7f0fa80128e0, conds=0x0, order_list=0x7f0fa80053b8, limit=18446744073709551610, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:747
|
#15 0x0000556ab500ab03 in mysql_execute_command (thd=0x7f0fa8000b00) at /data/src/10.3/sql/sql_parse.cc:4655
|
#16 0x0000556ab5014df4 in mysql_parse (thd=0x7f0fa8000b00, rawbuf=0x7f0fa8012808 "DELETE HISTORY FROM t1", length=22, parser_state=0x7f0ff3db35f0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7824
|
#17 0x0000556ab5002a62 in dispatch_command (command=COM_QUERY, thd=0x7f0fa8000b00, packet=0x7f0fa815fe71 "DELETE HISTORY FROM t1", packet_length=22, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1858
|
#18 0x0000556ab5001485 in do_command (thd=0x7f0fa8000b00) at /data/src/10.3/sql/sql_parse.cc:1403
|
#19 0x0000556ab516a91d in do_handle_one_connection (connect=0x556ab8c33040) at /data/src/10.3/sql/sql_connect.cc:1402
|
#20 0x0000556ab516a694 in handle_one_connection (arg=0x556ab8c33040) at /data/src/10.3/sql/sql_connect.cc:1308
|
#21 0x0000556ab5a43578 in pfs_spawn_thread (arg=0x556ab8b766a0) at /data/src/10.3/storage/perfschema/pfs.cc:1862
|
#22 0x00007f10005944a4 in start_thread (arg=0x7f0ff3db4700) at pthread_create.c:456
|
#23 0x00007f0ffeadcd0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
|
Looks similar to MDEV-18870.
Attachments
Issue Links
- causes
-
MDEV-20186 Wrong result or Assertion on INSERT after DELETE HISTORY
- Closed
- is duplicated by
-
MDEV-18870 Server crashes in row_upd or in row_upd_del_mark_clust_rec upon DELETE HISTORY from table with system and application periods
- Closed
- relates to
-
MDEV-19486 Server crashes in row_upd or row_upd_del_mark_clust_rec on REPLACE into a versioned table
- Closed
-
MDEV-18870 Server crashes in row_upd or in row_upd_del_mark_clust_rec upon DELETE HISTORY from table with system and application periods
- Closed