InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON upon LOAD DATA REPLACE with unique blob

Author: Sergei Golubchik

Date:   Thu Jul 18 14:40:15 2024 +0200

    cleanup: prepare_for_insert() -> prepare_for_modify()

--source include/have_innodb.inc

CREATE TABLE t (id INT PRIMARY KEY, a VARCHAR(1024), b INT, UNIQUE(a,id,b)) ENGINE=InnoDB;

--write_file $MYSQL_TMP_DIR/load.data

1;;10

2;;10

1;;20

EOF

--eval LOAD DATA LOCAL INFILE '$MYSQL_TMP_DIR/load.data' REPLACE INTO TABLE t FIELDS TERMINATED BY ';';

# Cleanup

DROP TABLE t;

--remove_file $MYSQL_TMP_DIR/load.data

InnoDB: Failing assertion: node->pcur->rel_pos == BTR_PCUR_ON

#7  0x00007fec2c245472 in __GI_abort () at ./stdlib/abort.c:79

#8  0x0000557321c0344c in ut_dbg_assertion_failed (expr=0x5573232369e0 "node->pcur->rel_pos == BTR_PCUR_ON", file=0x557323234940 "/data/bld/preview-vector-asan/storage/innobase/row/row0mysql.cc", line=1630) at /data/bld/preview-vector-asan/storage/innobase/ut/ut0dbg.cc:60

#9  0x0000557321a4d5d4 in row_update_for_mysql (prebuilt=0x620000015120) at /data/bld/preview-vector-asan/storage/innobase/row/row0mysql.cc:1630

#10 0x00005573215dc4e0 in ha_innobase::update_row (this=0x61d0002f30b8, old_row=0x6250001a0150 "", new_row=0x62500019f138 "\370\001") at /data/bld/preview-vector-asan/storage/innobase/handler/ha_innodb.cc:8523

#11 0x0000557320bd0ead in handler::ha_update_row (this=0x61d0002f30b8, old_data=0x6250001a0150 "", new_data=0x62500019f138 "\370\001") at /data/bld/preview-vector-asan/sql/handler.cc:8220

#12 0x000055732013761a in write_record (thd=0x62c0001e0218, table=0x6190000c8a98, info=0x7fec1da41ee0, sink=0x0) at /data/bld/preview-vector-asan/sql/sql_insert.cc:2240

#13 0x00005573201da4a8 in read_sep_field (thd=0x62c0001e0218, info=..., table_list=0x6290000fa4c8, fields_vars=..., set_fields=..., set_values=..., read_info=..., enclosed=..., skip_lines=0, ignore_check_option_errors=false) at /data/bld/preview-vector-asan/sql/sql_load.cc:1249

#14 0x00005573201d61a1 in mysql_load (thd=0x62c0001e0218, ex=0x6290000fa410, table_list=0x6290000fa4c8, fields_vars=..., set_fields=..., set_values=..., handle_duplicates=DUP_REPLACE, ignore=false, read_file_from_client=true) at /data/bld/preview-vector-asan/sql/sql_load.cc:712

#15 0x0000557320204f84 in mysql_execute_command (thd=0x62c0001e0218, is_called_from_prepared_stmt=false) at /data/bld/preview-vector-asan/sql/sql_parse.cc:4846

#16 0x00005573202195a6 in mysql_parse (thd=0x62c0001e0218, rawbuf=0x6290000fa238 "LOAD DATA LOCAL INFILE '/mnt8t/bld/preview-vector-asan/mysql-test/var/tmp/load.data' REPLACE INTO TABLE t FIELDS TERMINATED BY ';'", length=130, parser_state=0x7fec1da439d0) at /data/bld/preview-vector-asan/sql/sql_parse.cc:7888

#17 0x00005573201f0522 in dispatch_command (command=COM_QUERY, thd=0x62c0001e0218, packet=0x629000280219 ";;10\n2;;10\n1;;20\n", packet_length=131, blocking=true) at /data/bld/preview-vector-asan/sql/sql_parse.cc:1892

#18 0x00005573201ed22a in do_command (thd=0x62c0001e0218, blocking=true) at /data/bld/preview-vector-asan/sql/sql_parse.cc:1405

#19 0x00005573206e3672 in do_handle_one_connection (connect=0x608000008cb8, put_in_cache=true) at /data/bld/preview-vector-asan/sql/sql_connect.cc:1448

#20 0x00005573206e302e in handle_one_connection (arg=0x608000008c38) at /data/bld/preview-vector-asan/sql/sql_connect.cc:1350

#21 0x000055732139e874 in pfs_spawn_thread (arg=0x617000008218) at /data/bld/preview-vector-asan/storage/perfschema/pfs.cc:2198

#22 0x00007fec2c2a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442

#23 0x00007fec2c32861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81