Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
MDEV-35063 is fixed in the branch, but the failure still occurs with different values:
CREATE TABLE t (a INT, v BLOB NOT NULL, VECTOR(v)); |
INSERT INTO t VALUES (1,x'6161616161616161'),(2,x'6161616161616161'); |
|
# Cleanup
|
DROP TABLE t; |
bb-11.6-MDEV-32887-vector 77be73c489fb7c21ca58e78cef10e0c166f293d8 |
mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1043: int search_layer(MHNSW_Share*, TABLE*, const FVector*, float, uint, size_t, Neighborhood*, bool): Assertion `v->distance_to_target >= threshold' failed.
|
241005 17:52:01 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007f5069453e32 in __GI___assert_fail (assertion=0x5560f077a400 "v->distance_to_target >= threshold", file=0x5560f0779ba0 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc", line=1043, function=0x5560f077a320 "int search_layer(MHNSW_Share*, TABLE*, const FVector*, float, uint, size_t, Neighborhood*, bool)") at ./assert/assert.c:101
|
#10 0x00005560eeb3de20 in search_layer (ctx=0x61d00023f0b8, graph=0x6190000a37b8, target=0x7f505c9a9978, threshold=-1, result_size=12, layer=0, inout=0x7f505e142ce0, construction=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1043
|
#11 0x00005560eeb4080e in mhnsw_insert (table=0x61900009dd98, keyinfo=0x61900009e530) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1206
|
#12 0x00005560edbdaca1 in TABLE::hlindexes_on_insert (this=0x61900009dd98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:9919
|
#13 0x00005560ee730885 in handler::ha_write_row (this=0x61d000224cb8, buf=0x61900009e2c8 "\376\002") at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc:8163
|
#14 0x00005560edcac63e in write_record (thd=0x62c0000c0218, table=0x61900009dd98, info=0x7f505e1434e0, sink=0x0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_insert.cc:2322
|
#15 0x00005560edca2d6e in mysql_insert (thd=0x62c0000c0218, table_list=0x6290000e63a8, fields=..., values_list=..., update_fields=..., update_values=..., duplic=DUP_ERROR, ignore=false, result=0x0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_insert.cc:1179
|
#16 0x00005560edd73038 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:4458
|
#17 0x00005560edd8abfa in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "INSERT INTO t VALUES (1,x'6161616161616161'),(2,x'6161616161616161')", length=68, parser_state=0x7f505e1449f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
|
#18 0x00005560edd61c1c in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "INSERT INTO t VALUES (1,x'6161616161616161'),(2,x'6161616161616161')", packet_length=68, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
|
#19 0x00005560edd5e930 in do_command (thd=0x62c0000c0218, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1405
|
#20 0x00005560ee24e189 in do_handle_one_connection (connect=0x6080000034b8, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
|
#21 0x00005560ee24db4a in handle_one_connection (arg=0x608000003438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
|
#22 0x00005560eeef1672 in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
|
#23 0x00007f50694a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#24 0x00007f506952861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
The value translates into [259845894142441800000.000000,259845894142441800000.000000].
Also reproducible with 6262626262626262 ([1044013347355448300000.000000,1044013347355448300000.000000]), 6363636363636363 ([4194572472564517400000.000000,4194572472564517400000.000000]), etc.
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
- Closed
- relates to
-
MDEV-35063 Assertion `v->distance_to_target >= threshold' fails upon adding certain values to vector key
- Closed