Failing assertion: cursor->old_rec in innobase/btr/btr0pcur.cc or `sec_mtr->has_committed() == node->vcol_info.is_requested()' in row_purge_poss_sec

--source include/have_innodb.inc

--let $run= 50

while ($run)

{

  CREATE TABLE t1 ( 

    f1 INT,

    f2 CHAR(8),

    f3 YEAR,

    f4 CHAR(8) AS (f2) VIRTUAL,

    f5 YEAR AS (f3) VIRTUAL,

    f6 CHAR(8),

    f7 INT,

    PRIMARY KEY(f1),

    UNIQUE(f4,f7),

    UNIQUE(f6,f5),

    UNIQUE(f4)

  ) ENGINE=InnoDB;

  CREATE TABLE t2 ( 

    f1 INT,

    f2 CHAR(8) DEFAULT '',

    f3 YEAR,

    f4 CHAR(8) DEFAULT '',

    f5 YEAR,

    f6 CHAR(8),

    f7 INT

  ) ENGINE=InnoDB;

  INSERT IGNORE INTO t2 (f1,f5,f6,f7) VALUES

   (1,2018,'a',NULL),

   (2,NULL,'b',10),

   (3,2030,'c',11),

   (4,2000,'d',12),

   (5,1978,'e',13),

   (1,1977,'f',14),

   (6,2012,'t',15),

   (7,1999,'t',16),

   (8,1997,'t',17);

  SELECT * FROM t2 INTO OUTFILE 'load.data';

  LOAD DATA INFILE 'load.data' REPLACE INTO TABLE t1;

  # Cleanup

  DROP TABLE t1, t2;

  --let $datadir=`SELECT @@datadir`

  --remove_file $datadir/test/load.data

  --dec $run

  --echo #

  --echo # $run round(s) left

  --echo #

  --source include/restart_mysqld.inc

}

2018-09-07 21:18:00 0x7f80fa7fc700  InnoDB: Assertion failure in file /data/src/10.2/storage/innobase/btr/btr0pcur.cc line 273

InnoDB: Failing assertion: cursor->old_rec

#4  0x00007f8115e2c3fa in abort () from /lib/x86_64-linux-gnu/libc.so.6

#5  0x0000558e856b3c05 in ut_dbg_assertion_failed (expr=0x558e85f10ecc "cursor->old_rec", file=0x558e85f10ef8 "/data/src/10.2/storage/innobase/btr/btr0pcur.cc", line=273) at /data/src/10.2/storage/innobase/ut/ut0dbg.cc:61

#6  0x0000558e85c7b8b0 in btr_pcur_restore_position_func (latch_mode=8194, cursor=0x7f80fa7fb460, file=0x558e85f039d8 "/data/src/10.2/storage/innobase/row/row0purge.cc", line=279, mtr=0x7f80fa7fb6c0) at /data/src/10.2/storage/innobase/btr/btr0pcur.cc:273

#7  0x0000558e85bdc229 in row_purge_restore_vsec_cur (is_tree=false, sec_mtr=0x7f80fa7fb6c0, sec_pcur=0x7f80fa7fb460, index=0x7f80bc024820, node=0x558e8973a620) at /data/src/10.2/storage/innobase/row/row0purge.cc:277

#8  row_purge_poss_sec (node=node@entry=0x558e8973a620, index=index@entry=0x7f80bc024820, entry=entry@entry=0x7f80d4006e20, sec_pcur=sec_pcur@entry=0x7f80fa7fb460, sec_mtr=sec_mtr@entry=0x7f80fa7fb6c0, is_tree=is_tree@entry=false) at /data/src/10.2/storage/innobase/row/row0purge.cc:379

#9  0x0000558e85bdc85f in row_purge_remove_sec_if_poss_leaf (node=0x558e8973a620, index=0x7f80bc024820, entry=0x7f80d4006e20) at /data/src/10.2/storage/innobase/row/row0purge.cc:597

#10 0x0000558e85bde9d8 in row_purge_remove_sec_if_poss (entry=<optimized out>, index=<optimized out>, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0purge.cc:710

#11 row_purge_del_mark (node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0purge.cc:784

#12 row_purge_record_func (updated_extern=<optimized out>, thr=<optimized out>, undo_rec=<optimized out>, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0purge.cc:1094

#13 row_purge (thr=<optimized out>, undo_rec=<optimized out>, node=<optimized out>) at /data/src/10.2/storage/innobase/row/row0purge.cc:1155

#14 row_purge_step (thr=0x2, thr@entry=0x558e8973a470) at /data/src/10.2/storage/innobase/row/row0purge.cc:1241

#15 0x0000558e85b9fd96 in que_thr_step (thr=0x558e8973a470) at /data/src/10.2/storage/innobase/que/que0que.cc:1049

#16 que_run_threads_low (thr=0x558e8973a470) at /data/src/10.2/storage/innobase/que/que0que.cc:1111

#17 que_run_threads (thr=thr@entry=0x558e8973a470) at /data/src/10.2/storage/innobase/que/que0que.cc:1151

#18 0x0000558e85c0a4d6 in srv_task_execute () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2561

#19 srv_worker_thread (arg=<optimized out>) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2608

#20 0x00007f8117afa494 in start_thread (arg=0x7f80fa7fc700) at pthread_create.c:333

#21 0x00007f8115ee093f in clone () from /lib/x86_64-linux-gnu/libc.so.6

mysqld: /data/src/10.2/storage/innobase/row/row0purge.cc:327: bool row_purge_poss_sec(purge_node_t*, dict_index_t*, const dtuple_t*, btr_pcur_t*, mtr_t*, bool): Assertion `sec_mtr->has_committed() == node->vcol_info.is_requested()' failed.

180907 21:20:00 [ERROR] mysqld got signal 6 ;

#7  0x00007f9adfc4cee2 in __assert_fail () from /lib/x86_64-linux-gnu/libc.so.6

#8  0x0000557446235d9a in row_purge_poss_sec (node=0x557449b92108, index=0x7f9a88134f88, entry=0x7f9aa80117a8, sec_pcur=0x7f9ac4ff8560, sec_mtr=0x7f9ac4ff87c0, is_tree=false) at /data/src/10.2/storage/innobase/row/row0purge.cc:326

#9  0x0000557446236a87 in row_purge_remove_sec_if_poss_leaf (node=0x557449b92108, index=0x7f9a88134f88, entry=0x7f9aa80117a8) at /data/src/10.2/storage/innobase/row/row0purge.cc:597

#10 0x0000557446236f6a in row_purge_remove_sec_if_poss (node=0x557449b92108, index=0x7f9a88134f88, entry=0x7f9aa80117a8) at /data/src/10.2/storage/innobase/row/row0purge.cc:710

#11 0x0000557446237177 in row_purge_del_mark (node=0x557449b92108) at /data/src/10.2/storage/innobase/row/row0purge.cc:784

#12 0x0000557446237d94 in row_purge_record_func (node=0x557449b92108, undo_rec=0x557449b926b8 "\001a\016\001\023", thr=0x557449b91f50, updated_extern=false) at /data/src/10.2/storage/innobase/row/row0purge.cc:1094

#13 0x000055744623800b in row_purge (node=0x557449b92108, undo_rec=0x557449b926b8 "\001a\016\001\023", thr=0x557449b91f50) at /data/src/10.2/storage/innobase/row/row0purge.cc:1155

#14 0x000055744623834a in row_purge_step (thr=0x557449b91f50) at /data/src/10.2/storage/innobase/row/row0purge.cc:1241

#15 0x00005574461c991b in que_thr_step (thr=0x557449b91f50) at /data/src/10.2/storage/innobase/que/que0que.cc:1049

#16 0x00005574461c9b19 in que_run_threads_low (thr=0x557449b91f50) at /data/src/10.2/storage/innobase/que/que0que.cc:1111

#17 0x00005574461c9cc2 in que_run_threads (thr=0x557449b91f50) at /data/src/10.2/storage/innobase/que/que0que.cc:1151

#18 0x000055744628470a in srv_task_execute () at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2561

#19 0x0000557446284858 in srv_worker_thread (arg=0x0) at /data/src/10.2/storage/innobase/srv/srv0srv.cc:2608

#20 0x00007f9ae1923494 in start_thread (arg=0x7f9ac4ff9700) at pthread_create.c:333

#21 0x00007f9adfd0993f in clone () from /lib/x86_64-linux-gnu/libc.so.6