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

Server crashes in mem_heap_dup / innobase_get_computed_value or InnoDB: Record in index was not found on update

    XMLWordPrintable

    Details

      Description

      Only reproducible on 10.3, not on 10.2 (neither current nor somewhat older builds) and not on 10.4.

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
          pk INT,
          f1 INT,
          f2 TINYTEXT,
          f3 DATETIME,
          f4 TIMESTAMP,
          f5 DATETIME,
          vcol TEXT AS (f2) VIRTUAL,
          f7 VARCHAR(1),
          f8 YEAR,
          f9 DATE,
          f10 INT,
          PRIMARY KEY(pk),
          INDEX(vcol(64))
      ) ENGINE=InnoDB;
       
      CREATE TABLE t2 ( 
          pk INT,
          f1 INT,
          f2 VARCHAR(8),
          f3 DATETIME,
          f4 TIMESTAMP,
          f5 DATETIME,
          f6 VARCHAR(8),
          f7 VARCHAR(1),
          f8 YEAR,
          f9 DATE,
          f10 INT,
          f11 INT,
          PRIMARY KEY(pk)
      ) ENGINE=InnoDB;
       
      INSERT INTO t2 VALUES
          (1,1,'foobar','2012-12-12 12:12:12','2006-03-01 12:44:34','2029-10-10 21:27:53','','r',1975,'1989-12-24',9,NULL);
       
      ALTER TABLE t1 ADD COLUMN f11 INT;
      INSERT IGNORE INTO t1 SELECT * FROM t2;
      DELETE FROM t1;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      10.3 b0ff5a6a non-debug

      2019-09-04  1:08:35 9 [ERROR] InnoDB: Record in index `vcol` of table `test`.`t1` was not found on update: TUPLE (info_bits=0, 2 fields): {[0](0x),[4]    (0x80000001)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696E66696D756D00)}
      

      10.3 b0ff5a6a debug

      #3  <signal handler called>
      #4  __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:218
      #5  0x00005622c907d9cc in mem_heap_dup (heap=0x7f55f816f100, data=0xf8130f0000068f8f, len=64) at /data/src/10.3/storage/innobase/include/mem0mem.h:240
      #6  0x00005622c904de9b in dfield_dup (field=0x7f55f80458e0, heap=0x7f55f816f100) at /data/src/10.3/storage/innobase/include/data0data.ic:182
      #7  0x00005622c907a2ea in innobase_get_computed_value (row=0x7f55f8045748, col=0x7f55f80a5678, index=0x7f55f80a5b68, local_heap=0x7f5644f87318, heap=0x7f55f816f100, ifield=0x0, thd=0x7f55f8000b00, mysql_table=0x7f55f81715f0, mysql_rec=0x7f55f804c7a8 "\215\217\217\217\217\217\217\217\217\217\006\246\361\026\370U\177", old_table=0x0, parent_update=0x0, foreign=0x0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:21017
      #8  0x00005622c927151b in row_upd_store_v_row (node=0x7f55f8038a78, update=0x0, thd=0x7f55f8000b00, mysql_table=0x7f55f81715f0) at /data/src/10.3/storage/innobase/row/row0upd.cc:2198
      #9  0x00005622c92717cd in row_upd_store_row (node=0x7f55f8038a78, thd=0x7f55f8000b00, mysql_table=0x7f55f81715f0) at /data/src/10.3/storage/innobase/row/row0upd.cc:2262
      #10 0x00005622c9274619 in row_upd_del_mark_clust_rec (node=0x7f55f8038a78, index=0x7f55f80a5b68, offsets=0x7f5644f87990, thr=0x7f55f803a178, referenced=0, foreign=false, mtr=0x7f5644f87cb0) at /data/src/10.3/storage/innobase/row/row0upd.cc:2983
      #11 0x00005622c927516a in row_upd_clust_step (node=0x7f55f8038a78, thr=0x7f55f803a178) at /data/src/10.3/storage/innobase/row/row0upd.cc:3168
      #12 0x00005622c92756c4 in row_upd (node=0x7f55f8038a78, thr=0x7f55f803a178) at /data/src/10.3/storage/innobase/row/row0upd.cc:3295
      #13 0x00005622c9275cb3 in row_upd_step (thr=0x7f55f803a178) at /data/src/10.3/storage/innobase/row/row0upd.cc:3439
      #14 0x00005622c920332e in row_update_for_mysql (prebuilt=0x7f55f8037c98) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
      #15 0x00005622c9063a29 in ha_innobase::delete_row (this=0x7f55f8172238, record=0x7f55f8036460 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8983
      #16 0x00005622c8e3d24a in handler::ha_delete_row (this=0x7f55f8172238, buf=0x7f55f8036460 "") at /data/src/10.3/sql/handler.cc:6534
      #17 0x00005622c8fe8b0f in TABLE::delete_row (this=0x7f55f81715f0) at /data/src/10.3/sql/sql_delete.cc:253
      #18 0x00005622c8fe5d13 in mysql_delete (thd=0x7f55f8000b00, table_list=0x7f55f80128e0, conds=0x0, order_list=0x7f55f80053c8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:750
      #19 0x00005622c8b0fca8 in mysql_execute_command (thd=0x7f55f8000b00) at /data/src/10.3/sql/sql_parse.cc:4654
      #20 0x00005622c8b1a939 in mysql_parse (thd=0x7f55f8000b00, rawbuf=0x7f55f8012818 "DELETE FROM t1", length=14, parser_state=0x7f5644f895e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7830
      #21 0x00005622c8b07237 in dispatch_command (command=COM_QUERY, thd=0x7f55f8000b00, packet=0x7f55f815fe31 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
      #22 0x00005622c8b05b5e in do_command (thd=0x7f55f8000b00) at /data/src/10.3/sql/sql_parse.cc:1401
      #23 0x00005622c8c7e9f4 in do_handle_one_connection (connect=0x5622ccf91190) at /data/src/10.3/sql/sql_connect.cc:1403
      #24 0x00005622c8c7e756 in handle_one_connection (arg=0x5622ccf91190) at /data/src/10.3/sql/sql_connect.cc:1308
      #25 0x00005622c965fe72 in pfs_spawn_thread (arg=0x5622cced4730) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #26 0x00007f564d7604a4 in start_thread (arg=0x7f5644f8a700) at pthread_create.c:456
      #27 0x00007f564bca8d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      10.3 b0ff5a6a asan

      ==2728==ERROR: AddressSanitizer: unknown-crash on address 0x40a300006bebe at pc 0x7f91d2598f7f bp 0x7f91babe3660 sp 0x7f91babe2e10
      READ of size 64 at 0x40a300006bebe thread T27
          #0 0x7f91d2598f7e  (/usr/lib/x86_64-linux-gnu/libasan.so.3+0x5cf7e)
          #1 0x559cf98c0460 in mem_heap_dup(mem_block_info_t*, void const*, unsigned long) /data/src/10.3/storage/innobase/include/mem0mem.h:240
          #2 0x559cf9854cc4 in dfield_dup /data/src/10.3/storage/innobase/include/data0data.ic:182
          #3 0x559cf98b8c4f in innobase_get_computed_value(dtuple_t*, dict_v_col_t const*, dict_index_t const*, mem_block_info_t**, mem_block_info_t*, dict_field_t const*, THD*, TABLE*, unsigned char*, dict_table_t const*, upd_t*, dict_foreign_t*) /data/src/10.3/storage/innobase/handler/ha_innodb.cc:21017
          #4 0x559cf9cb740c in row_upd_store_v_row /data/src/10.3/storage/innobase/row/row0upd.cc:2198
          #5 0x559cf9cb7ae2 in row_upd_store_row(upd_node_t*, THD*, TABLE*) /data/src/10.3/storage/innobase/row/row0upd.cc:2262
          #6 0x559cf9cbcf36 in row_upd_del_mark_clust_rec /data/src/10.3/storage/innobase/row/row0upd.cc:2983
          #7 0x559cf9cbe194 in row_upd_clust_step /data/src/10.3/storage/innobase/row/row0upd.cc:3168
          #8 0x559cf9cbedb1 in row_upd /data/src/10.3/storage/innobase/row/row0upd.cc:3295
          #9 0x559cf9cbfd3b in row_upd_step(que_thr_t*) /data/src/10.3/storage/innobase/row/row0upd.cc:3439
          #10 0x559cf9bd6ba8 in row_update_for_mysql(row_prebuilt_t*) /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
          #11 0x559cf9884462 in ha_innobase::delete_row(unsigned char const*) /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8983
          #12 0x559cf933efcf in handler::ha_delete_row(unsigned char const*) /data/src/10.3/sql/handler.cc:6534
          #13 0x559cf9759743 in TABLE::delete_row() /data/src/10.3/sql/sql_delete.cc:253
          #14 0x559cf975225a in mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*) /data/src/10.3/sql/sql_delete.cc:750
          #15 0x559cf8c195c4 in mysql_execute_command(THD*) /data/src/10.3/sql/sql_parse.cc:4654
          #16 0x559cf8c2ed1d in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.3/sql/sql_parse.cc:7830
          #17 0x559cf8c07ed6 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.3/sql/sql_parse.cc:1856
          #18 0x559cf8c04c18 in do_command(THD*) /data/src/10.3/sql/sql_parse.cc:1401
          #19 0x559cf8f8f33c in do_handle_one_connection(CONNECT*) /data/src/10.3/sql/sql_connect.cc:1403
          #20 0x559cf8f8ed03 in handle_one_connection /data/src/10.3/sql/sql_connect.cc:1308
          #21 0x559cfa57666d in pfs_spawn_thread /data/src/10.3/storage/perfschema/pfs.cc:1862
          #22 0x7f91d23264a3 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x74a3)
          #23 0x7f91d086ed0e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe8d0e)
       
      ==2728==AddressSanitizer CHECK failed: ../../../../src/libsanitizer/asan/asan_report.cc:346 "((0 && "Address is not in memory and not in shadow?")) != (0)" (0x0, 0x0)
          #0 0x7f91d2606ebd  (/usr/lib/x86_64-linux-gnu/libasan.so.3+0xcaebd)
          #1 0x7f91d260cb13 in __sanitizer::CheckFailed(char const*, int, char const*, unsigned long long, unsigned long long) (/usr/lib/x86_64-linux-gnu/libasan.so.3+0xd0b13)
          #2 0x7f91d26021b7  (/usr/lib/x86_64-linux-gnu/libasan.so.3+0xc61b7)
          #3 0x7f91d2603118  (/usr/lib/x86_64-linux-gnu/libasan.so.3+0xc7118)
          #4 0x7f91d2606376  (/usr/lib/x86_64-linux-gnu/libasan.so.3+0xca376)
          #5 0x7f91d2598f9d  (/usr/lib/x86_64-linux-gnu/libasan.so.3+0x5cf9d)
          #6 0x559cf98c0460 in mem_heap_dup(mem_block_info_t*, void const*, unsigned long) /data/src/10.3/storage/innobase/include/mem0mem.h:240
          #7 0x559cf9854cc4 in dfield_dup /data/src/10.3/storage/innobase/include/data0data.ic:182
          #8 0x559cf98b8c4f in innobase_get_computed_value(dtuple_t*, dict_v_col_t const*, dict_index_t const*, mem_block_info_t**, mem_block_info_t*, dict_field_t const*, THD*, TABLE*, unsigned char*, dict_table_t const*, upd_t*, dict_foreign_t*) /data/src/10.3/storage/innobase/handler/ha_innodb.cc:21017
          #9 0x559cf9cb740c in row_upd_store_v_row /data/src/10.3/storage/innobase/row/row0upd.cc:2198
          #10 0x559cf9cb7ae2 in row_upd_store_row(upd_node_t*, THD*, TABLE*) /data/src/10.3/storage/innobase/row/row0upd.cc:2262
          #11 0x559cf9cbcf36 in row_upd_del_mark_clust_rec /data/src/10.3/storage/innobase/row/row0upd.cc:2983
          #12 0x559cf9cbe194 in row_upd_clust_step /data/src/10.3/storage/innobase/row/row0upd.cc:3168
          #13 0x559cf9cbedb1 in row_upd /data/src/10.3/storage/innobase/row/row0upd.cc:3295
          #14 0x559cf9cbfd3b in row_upd_step(que_thr_t*) /data/src/10.3/storage/innobase/row/row0upd.cc:3439
          #15 0x559cf9bd6ba8 in row_update_for_mysql(row_prebuilt_t*) /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
          #16 0x559cf9884462 in ha_innobase::delete_row(unsigned char const*) /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8983
          #17 0x559cf933efcf in handler::ha_delete_row(unsigned char const*) /data/src/10.3/sql/handler.cc:6534
          #18 0x559cf9759743 in TABLE::delete_row() /data/src/10.3/sql/sql_delete.cc:253
          #19 0x559cf975225a in mysql_delete(THD*, TABLE_LIST*, Item*, SQL_I_List<st_order>*, unsigned long long, unsigned long long, select_result*) /data/src/10.3/sql/sql_delete.cc:750
          #20 0x559cf8c195c4 in mysql_execute_command(THD*) /data/src/10.3/sql/sql_parse.cc:4654
          #21 0x559cf8c2ed1d in mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool) /data/src/10.3/sql/sql_parse.cc:7830
          #22 0x559cf8c07ed6 in dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool) /data/src/10.3/sql/sql_parse.cc:1856
          #23 0x559cf8c04c18 in do_command(THD*) /data/src/10.3/sql/sql_parse.cc:1401
          #24 0x559cf8f8f33c in do_handle_one_connection(CONNECT*) /data/src/10.3/sql/sql_connect.cc:1403
          #25 0x559cf8f8ed03 in handle_one_connection /data/src/10.3/sql/sql_connect.cc:1308
          #26 0x559cfa57666d in pfs_spawn_thread /data/src/10.3/storage/perfschema/pfs.cc:1862
          #27 0x7f91d23264a3 in start_thread (/lib/x86_64-linux-gnu/libpthread.so.0+0x74a3)
          #28 0x7f91d086ed0e in __clone (/lib/x86_64-linux-gnu/libc.so.6+0xe8d0e)
      

      Slight modifications in the test case change the outcome. Here is the stack trace for the same test case, but without f10 column in both tables:

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
          pk INT,
          f1 INT,
          f2 TINYTEXT,
          f3 DATETIME,
          f4 TIMESTAMP,
          f5 DATETIME,
          vcol TEXT AS (f2) VIRTUAL,
          f7 VARCHAR(1),
          f8 YEAR,
          f9 DATE,
          PRIMARY KEY(pk),
          INDEX(vcol(64))
      ) ENGINE=InnoDB;
       
      CREATE TABLE t2 ( 
          pk INT,
          f1 INT,
          f2 VARCHAR(8),
          f3 DATETIME,
          f4 TIMESTAMP,
          f5 DATETIME,
          f6 VARCHAR(8),
          f7 VARCHAR(1),
          f8 YEAR,
          f9 DATE,
          f11 INT,
          PRIMARY KEY(pk)
      ) ENGINE=InnoDB;
       
      INSERT INTO t2 VALUES
          (1,1,'foobar','2012-12-12 12:12:12','2006-03-01 12:44:34','2029-10-10 21:27:53','','r',1975,'1989-12-24',NULL);
       
      ALTER TABLE t1 ADD COLUMN f11 INT;
      INSERT IGNORE INTO t1 SELECT * FROM t2;
      DELETE FROM t1;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      #3  <signal handler called>
      #4  __memmove_avx_unaligned_erms () at ../sysdeps/x86_64/multiarch/memmove-vec-unaligned-erms.S:325
      #5  0x0000564c3b59cfab in String::realloc_raw (this=0x7f49cc173598, alloc_length=181) at /data/src/10.3/sql/sql_string.cc:109
      #6  0x0000564c3b3afbd3 in String::realloc (this=0x7f49cc173598, arg_length=181) at /data/src/10.3/sql/sql_string.h:358
      #7  0x0000564c3b59d4b6 in String::copy (this=0x7f49cc173598) at /data/src/10.3/sql/sql_string.cc:212
      #8  0x0000564c3b7e346c in Field_blob::store_field (this=0x7f49cc1734a8, from=0x7f49cc173048) at /data/src/10.3/sql/field.h:3689
      #9  0x0000564c3b7e8379 in field_conv_incompatible (to=0x7f49cc1734a8, from=0x7f49cc173048) at /data/src/10.3/sql/field_conv.cc:836
      #10 0x0000564c3b7e83d5 in field_conv (to=0x7f49cc1734a8, from=0x7f49cc173048) at /data/src/10.3/sql/field_conv.cc:847
      #11 0x0000564c3b8219e6 in save_field_in_field (from=0x7f49cc173048, null_value=0x7f49cc173cc6, to=0x7f49cc1734a8, no_conversions=false) at /data/src/10.3/sql/item.cc:6730
      #12 0x0000564c3b821c28 in Item_field::save_in_field (this=0x7f49cc173c50, to=0x7f49cc1734a8, no_conversions=false) at /data/src/10.3/sql/item.cc:6781
      #13 0x0000564c3b60143f in TABLE::update_virtual_field (this=0x7f49cc171c50, vf=0x7f49cc1734a8) at /data/src/10.3/sql/table.cc:7885
      #14 0x0000564c3ba41060 in innobase_get_computed_value (row=0x7f49cc0453c8, col=0x7f49cc0a5378, index=0x7f49cc0a7978, local_heap=0x7f4a243e2318, heap=0x7f49cc16ff10, ifield=0x0, thd=0x7f49cc000b00, mysql_table=0x7f49cc171c50, mysql_rec=0x7f49cc04a2d8 "", old_table=0x0, parent_update=0x0, foreign=0x0) at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:20968
      #15 0x0000564c3bc3851b in row_upd_store_v_row (node=0x7f49cc0389b8, update=0x0, thd=0x7f49cc000b00, mysql_table=0x7f49cc171c50) at /data/src/10.3/storage/innobase/row/row0upd.cc:2198
      #16 0x0000564c3bc387cd in row_upd_store_row (node=0x7f49cc0389b8, thd=0x7f49cc000b00, mysql_table=0x7f49cc171c50) at /data/src/10.3/storage/innobase/row/row0upd.cc:2262
      #17 0x0000564c3bc3b619 in row_upd_del_mark_clust_rec (node=0x7f49cc0389b8, index=0x7f49cc0a7978, offsets=0x7f4a243e2990, thr=0x7f49cc048308, referenced=0, foreign=false, mtr=0x7f4a243e2cb0) at /data/src/10.3/storage/innobase/row/row0upd.cc:2983
      #18 0x0000564c3bc3c16a in row_upd_clust_step (node=0x7f49cc0389b8, thr=0x7f49cc048308) at /data/src/10.3/storage/innobase/row/row0upd.cc:3168
      #19 0x0000564c3bc3c6c4 in row_upd (node=0x7f49cc0389b8, thr=0x7f49cc048308) at /data/src/10.3/storage/innobase/row/row0upd.cc:3295
      #20 0x0000564c3bc3ccb3 in row_upd_step (thr=0x7f49cc048308) at /data/src/10.3/storage/innobase/row/row0upd.cc:3439
      #21 0x0000564c3bbca32e in row_update_for_mysql (prebuilt=0x7f49cc037c28) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
      #22 0x0000564c3ba2aa29 in ha_innobase::delete_row (this=0x7f49cc172898, record=0x7f49cc036410 "") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8983
      #23 0x0000564c3b80424a in handler::ha_delete_row (this=0x7f49cc172898, buf=0x7f49cc036410 "") at /data/src/10.3/sql/handler.cc:6534
      #24 0x0000564c3b9afb0f in TABLE::delete_row (this=0x7f49cc171c50) at /data/src/10.3/sql/sql_delete.cc:253
      #25 0x0000564c3b9acd13 in mysql_delete (thd=0x7f49cc000b00, table_list=0x7f49cc0128e0, conds=0x0, order_list=0x7f49cc0053c8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:750
      #26 0x0000564c3b4d6ca8 in mysql_execute_command (thd=0x7f49cc000b00) at /data/src/10.3/sql/sql_parse.cc:4654
      #27 0x0000564c3b4e1939 in mysql_parse (thd=0x7f49cc000b00, rawbuf=0x7f49cc012818 "DELETE FROM t1", length=14, parser_state=0x7f4a243e45e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7830
      #28 0x0000564c3b4ce237 in dispatch_command (command=COM_QUERY, thd=0x7f49cc000b00, packet=0x7f49cc15fe31 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
      #29 0x0000564c3b4ccb5e in do_command (thd=0x7f49cc000b00) at /data/src/10.3/sql/sql_parse.cc:1401
      #30 0x0000564c3b6459f4 in do_handle_one_connection (connect=0x564c3eb36190) at /data/src/10.3/sql/sql_connect.cc:1403
      #31 0x0000564c3b645756 in handle_one_connection (arg=0x564c3eb36190) at /data/src/10.3/sql/sql_connect.cc:1308
      #32 0x0000564c3c026e72 in pfs_spawn_thread (arg=0x564c3ea79730) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #33 0x00007f4a2c35b4a4 in start_thread (arg=0x7f4a243e5700) at pthread_create.c:456
      #34 0x00007f4a2a8a3d0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      And if we also remove f9, we are getting an assertion failure instead:

      --source include/have_innodb.inc
       
      CREATE TABLE t1 ( 
          pk INT,
          f1 INT,
          f2 TINYTEXT,
          f3 DATETIME,
          f4 TIMESTAMP,
          f5 DATETIME,
          vcol TEXT AS (f2) VIRTUAL,
          f7 VARCHAR(1),
          f8 YEAR,
          PRIMARY KEY(pk),
          INDEX(vcol(64))
      ) ENGINE=InnoDB;
       
      CREATE TABLE t2 ( 
          pk INT,
          f1 INT,
          f2 VARCHAR(8),
          f3 DATETIME,
          f4 TIMESTAMP,
          f5 DATETIME,
          f6 VARCHAR(8),
          f7 VARCHAR(1),
          f8 YEAR,
          f11 INT,
          PRIMARY KEY(pk)
      ) ENGINE=InnoDB;
       
      INSERT INTO t2 VALUES
          (1,1,'foobar','2012-12-12 12:12:12','2006-03-01 12:44:34','2029-10-10 21:27:53','','r',1975,NULL);
       
      ALTER TABLE t1 ADD COLUMN f11 INT;
      INSERT IGNORE INTO t1 SELECT * FROM t2;
      DELETE FROM t1;
       
      # Cleanup
      DROP TABLE t1, t2;
      

      2019-09-04  1:11:06 9 [ERROR] InnoDB: Record in index `vcol` of table `test`.`t1` was not found on update: TUPLE (info_bits=0, 2 fields): {[0](0x),[4]    (0x80000001)} at: COMPACT RECORD(info_bits=0, 1 fields): {[8]infimum (0x696E66696D756D00)}
      mysqld: /data/src/10.3/storage/innobase/row/row0upd.cc:2445: dberr_t row_upd_sec_index_entry(upd_node_t*, que_thr_t*): Assertion `btr_validate_index(index, 0, false)' failed.
      190904  1:11:06 [ERROR] mysqld got signal 6 ;
       
       
      #6  0x00007fcadb8cde67 in __assert_fail_base (fmt=<optimized out>, assertion=assertion@entry=0x55ed19329e30 "btr_validate_index(index, 0, false)", file=file@entry=0x55ed193297d8 "/data/src/10.3/storage/innobase/row/row0upd.cc", line=line@entry=2445, function=function@entry=0x55ed1932c720 <row_upd_sec_index_entry(upd_node_t*, que_thr_t*)::__PRETTY_FUNCTION__> "dberr_t row_upd_sec_index_entry(upd_node_t*, que_thr_t*)") at assert.c:92
      #7  0x00007fcadb8cdf12 in __GI___assert_fail (assertion=0x55ed19329e30 "btr_validate_index(index, 0, false)", file=0x55ed193297d8 "/data/src/10.3/storage/innobase/row/row0upd.cc", line=2445, function=0x55ed1932c720 <row_upd_sec_index_entry(upd_node_t*, que_thr_t*)::__PRETTY_FUNCTION__> "dberr_t row_upd_sec_index_entry(upd_node_t*, que_thr_t*)") at assert.c:101
      #8  0x000055ed18ba811b in row_upd_sec_index_entry (node=0x7fca84038960, thr=0x7fca84048238) at /data/src/10.3/storage/innobase/row/row0upd.cc:2445
      #9  0x000055ed18ba89a6 in row_upd_sec_step (node=0x7fca84038960, thr=0x7fca84048238) at /data/src/10.3/storage/innobase/row/row0upd.cc:2559
      #10 0x000055ed18bab845 in row_upd (node=0x7fca84038960, thr=0x7fca84048238) at /data/src/10.3/storage/innobase/row/row0upd.cc:3324
      #11 0x000055ed18babcb3 in row_upd_step (thr=0x7fca84048238) at /data/src/10.3/storage/innobase/row/row0upd.cc:3439
      #12 0x000055ed18b3932e in row_update_for_mysql (prebuilt=0x7fca84037c18) at /data/src/10.3/storage/innobase/row/row0mysql.cc:1888
      #13 0x000055ed18999a29 in ha_innobase::delete_row (this=0x7fca84172878, record=0x7fca84036410 "\200\001") at /data/src/10.3/storage/innobase/handler/ha_innodb.cc:8983
      #14 0x000055ed1877324a in handler::ha_delete_row (this=0x7fca84172878, buf=0x7fca84036410 "\200\001") at /data/src/10.3/sql/handler.cc:6534
      #15 0x000055ed1891eb0f in TABLE::delete_row (this=0x7fca84171c30) at /data/src/10.3/sql/sql_delete.cc:253
      #16 0x000055ed1891bd13 in mysql_delete (thd=0x7fca84000b00, table_list=0x7fca840128e0, conds=0x0, order_list=0x7fca840053c8, limit=18446744073709551615, options=0, result=0x0) at /data/src/10.3/sql/sql_delete.cc:750
      #17 0x000055ed18445ca8 in mysql_execute_command (thd=0x7fca84000b00) at /data/src/10.3/sql/sql_parse.cc:4654
      #18 0x000055ed18450939 in mysql_parse (thd=0x7fca84000b00, rawbuf=0x7fca84012818 "DELETE FROM t1", length=14, parser_state=0x7fcad4c6b5e0, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:7830
      #19 0x000055ed1843d237 in dispatch_command (command=COM_QUERY, thd=0x7fca84000b00, packet=0x7fca8415fe31 "DELETE FROM t1", packet_length=14, is_com_multi=false, is_next_command=false) at /data/src/10.3/sql/sql_parse.cc:1856
      #20 0x000055ed1843bb5e in do_command (thd=0x7fca84000b00) at /data/src/10.3/sql/sql_parse.cc:1401
      #21 0x000055ed185b49f4 in do_handle_one_connection (connect=0x55ed1bc0a190) at /data/src/10.3/sql/sql_connect.cc:1403
      #22 0x000055ed185b4756 in handle_one_connection (arg=0x55ed1bc0a190) at /data/src/10.3/sql/sql_connect.cc:1308
      #23 0x000055ed18f95e72 in pfs_spawn_thread (arg=0x55ed1bb4d730) at /data/src/10.3/storage/perfschema/pfs.cc:1862
      #24 0x00007fcadd4424a4 in start_thread (arg=0x7fcad4c6c700) at pthread_create.c:456
      #25 0x00007fcadb98ad0f in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:97
      

      We have several of these assertions filed, but I'm not sure either of them is quite the same case.

        Attachments

          Activity

            People

            Assignee:
            nikitamalyavin Nikita Malyavin
            Reporter:
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Dates

              Created:
              Updated: