Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-19814

Assertion `update->n_fields < ulint(table->n_cols + table->n_v_cols)' on DELETE HISTORY

    XMLWordPrintable

Details

    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

          Activity

            People

              midenok Aleksey Midenkov
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.