Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
N/A
-
None
Description
--source include/have_sequence.inc
|
|
set rand_seed1=709623935, rand_seed2=306417196; |
|
CREATE TABLE t (pk INT PRIMARY KEY, v BLOB NOT NULL, VECTOR(v)); |
INSERT INTO t SELECT seq, VEC_FROMTEXT(CONCAT('[', ROUND(RAND()-1,1), ',', ROUND(RAND()-1,1), ']')) FROM seq_1_to_106; |
|
SELECT v, VEC_TOTEXT(v) FROM t WHERE v = x'0000000000000000' ORDER BY VEC_DISTANCE_EUCLIDEAN(v, VEC_FROMTEXT('[0.0,0.0]')) ASC LIMIT 2; |
bb-11.6-MDEV-32887-vector 4b8dada45a24902357dfbeda4f058bfaf732bda3 |
mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1042: int search_layer(MHNSW_Share*, TABLE*, const FVector*, float, uint, size_t, Neighborhood*, bool): Assertion `std::isnan(v->distance_to_target) || v->distance_to_target >= threshold' failed.
|
241012 19:24:49 [ERROR] mysqld got signal 6 ;
|
|
#9 0x00007fa350253e32 in __GI___assert_fail (assertion=0x555ecc5c1688 "std::isnan(v->distance_to_target) || v->distance_to_target >= threshold", file=0x555ecc5c1390 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc", line=1042, function=0x555ecc5c1608 "int search_layer(MHNSW_Share*, TABLE*, const FVector*, float, uint, size_t, Neighborhood*, bool)") at ./assert/assert.c:101
|
#10 0x0000555ecba0095f in search_layer (ctx=0x7fa338b18db0, graph=0x7fa338088450, target=0x7fa338c1ce38, threshold=0.365002781, result_size=2, layer=0, inout=0x7fa338c1d180, construction=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1042
|
#11 0x0000555ecba028ac in mhnsw_read_next (table=0x7fa33821d858) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/vector_mhnsw.cc:1352
|
#12 0x0000555ecb3510ca in TABLE::hlindex_read_next (this=0x7fa33821d858) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_base.cc:9973
|
#13 0x0000555ecb4ad974 in join_hlindex_read_next (info=0x7fa338c1b438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:24801
|
#14 0x0000555ecb29f019 in READ_RECORD::read_record (this=0x7fa338c1b438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/records.h:77
|
#15 0x0000555ecb4aa95e in sub_select (join=0x7fa33801a0e0, join_tab=0x7fa338c1b368, end_of_records=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:23671
|
#16 0x0000555ecb4a9950 in do_select (join=0x7fa33801a0e0, procedure=0x0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:23165
|
#17 0x0000555ecb4754b9 in JOIN::exec_inner (this=0x7fa33801a0e0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:5026
|
#18 0x0000555ecb474499 in JOIN::exec (this=0x7fa33801a0e0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:4809
|
#19 0x0000555ecb475f54 in mysql_select (thd=0x7fa338000dc8, tables=0x7fa338018790, fields=..., conds=0x7fa338019078, og_num=1, order=0x7fa338019f58, group=0x0, having=0x0, proc_param=0x0, select_options=2164525824, result=0x7fa33801a0b8, unit=0x7fa3380052c0, select_lex=0x7fa338017ee8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:5342
|
#20 0x0000555ecb463f15 in handle_select (thd=0x7fa338000dc8, lex=0x7fa3380051e0, result=0x7fa33801a0b8, setup_tables_done_option=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:624
|
#21 0x0000555ecb406677 in execute_sqlcom_select (thd=0x7fa338000dc8, all_tables=0x7fa338018790) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:6151
|
#22 0x0000555ecb3fe2cd in mysql_execute_command (thd=0x7fa338000dc8, is_called_from_prepared_stmt=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:3953
|
#23 0x0000555ecb40b638 in mysql_parse (thd=0x7fa338000dc8, rawbuf=0x7fa338017d80 "SELECT v, VEC_TOTEXT(v) FROM t WHERE v = x'", '0' <repeats 16 times>, "' ORDER BY VEC_DISTANCE_EUCLIDEAN(v, VEC_FROMTEXT('[0.0,0.0]')) ASC LIMIT 2", length=134, parser_state=0x7fa3499002f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
|
#24 0x0000555ecb3f7a94 in dispatch_command (command=COM_QUERY, thd=0x7fa338000dc8, packet=0x7fa33800be39 "", packet_length=134, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
|
#25 0x0000555ecb3f63ed in do_command (thd=0x7fa338000dc8, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1405
|
#26 0x0000555ecb5ff103 in do_handle_one_connection (connect=0x555ecf18ee08, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
|
#27 0x0000555ecb5fee78 in handle_one_connection (arg=0x555ecf18d758) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
|
#28 0x0000555ecbb743c0 in pfs_spawn_thread (arg=0x555ecf18e978) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
|
#29 0x00007fa3502a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#30 0x00007fa35032861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
|
Attachments
Issue Links
- is caused by
-
MDEV-34939 vector search in 11.7
- Closed