Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
I couldn't scale it up to higher values of mhnsw_cache_size with a larger number of queries in the table and/or in the search, but see MDEV-35284, which appears to be the same problem on a larger scale.
--source include/have_innodb.inc
|
--source include/have_sequence.inc
|
|
SET @cache.save= @@mhnsw_cache_size; |
SET GLOBAL mhnsw_cache_size= 1024*1024*2; |
|
CREATE TABLE t (v VECTOR(1) NOT NULL, VECTOR(v)) ENGINE=InnoDB; |
START TRANSACTION; |
INSERT INTO t SELECT 0x30303030 FROM seq_1_to_200; |
SELECT v FROM t ORDER BY VEC_DISTANCE_EUCLIDEAN(v, 0x31313131) LIMIT 2; |
COMMIT; |
|
# Cleanup
|
DROP TABLE t; |
SET GLOBAL mhnsw_cache_size= @cache.save; |
bb-11.6-MDEV-32887-vector 4dfa605f405df3bee7142be6bcdc364f5a5e0db3 |
#4 <signal handler called>
|
#5 0x000056419d511901 in FVectorNode::gref_len (this=this@entry=0x7fee2cc3e770) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/vector_mhnsw.cc:797
|
#6 0x000056419d511b7a in FVectorNode::tref (this=this@entry=0x7fee2cc3e770) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/vector_mhnsw.cc:799
|
#7 0x000056419d51c778 in mhnsw_read_next (table=table@entry=0x7fee2c233628) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/vector_mhnsw.cc:1297
|
#8 0x000056419bec9389 in TABLE::hlindex_read_next (this=this@entry=0x7fee2c233628) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_base.cc:9973
|
#9 0x000056419c262d44 in join_hlindex_read_next (info=0x7fee2c081a50) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:24801
|
#10 0x000056419c23c419 in READ_RECORD::read_record (this=0x7fee2c081a50) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/records.h:77
|
#11 sub_select (join=0x7fee2c0185e8, join_tab=0x7fee2c081980, end_of_records=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:23671
|
#12 0x000056419c2a317c in do_select (join=join@entry=0x7fee2c0185e8, procedure=<optimized out>) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:23165
|
#13 0x000056419c323c0a in JOIN::exec_inner (this=this@entry=0x7fee2c0185e8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:5026
|
#14 0x000056419c324094 in JOIN::exec (this=this@entry=0x7fee2c0185e8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:4809
|
#15 0x000056419c31df8d in mysql_select (thd=thd@entry=0x7fee2c000d58, tables=0x7fee2c017218, fields=..., conds=conds@entry=0x0, og_num=og_num@entry=1, order=order@entry=0x7fee2c018470, group=0x0, having=0x0, proc_param=0x0, select_options=<optimized out>, result=0x7fee2c0185c0, unit=0x7fee2c005250, select_lex=0x7fee2c016bd8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:5342
|
#16 0x000056419c31eab2 in handle_select (thd=thd@entry=0x7fee2c000d58, lex=lex@entry=0x7fee2c005170, result=result@entry=0x7fee2c0185c0, setup_tables_done_option=setup_tables_done_option@entry=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_select.cc:624
|
#17 0x000056419c0f4c74 in execute_sqlcom_select (thd=thd@entry=0x7fee2c000d58, all_tables=0x7fee2c017218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:6151
|
#18 0x000056419c11d862 in mysql_execute_command (thd=thd@entry=0x7fee2c000d58, is_called_from_prepared_stmt=is_called_from_prepared_stmt@entry=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:3953
|
#19 0x000056419c132828 in mysql_parse (thd=thd@entry=0x7fee2c000d58, rawbuf=<optimized out>, length=<optimized out>, parser_state=parser_state@entry=0x7fee369fa440) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:7873
|
#20 0x000056419c1391fc in dispatch_command (command=command@entry=COM_QUERY, thd=thd@entry=0x7fee2c000d58, packet=packet@entry=0x7fee2c00b3c9 "", packet_length=packet_length@entry=70, blocking=blocking@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:1892
|
#21 0x000056419c1419ed in do_command (thd=0x7fee2c000d58, blocking=blocking@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_parse.cc:1405
|
#22 0x000056419c63c898 in do_handle_one_connection (connect=<optimized out>, connect@entry=0x5641a420b368, put_in_cache=put_in_cache@entry=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_connect.cc:1448
|
#23 0x000056419c63d74e in handle_one_connection (arg=0x5641a420b368) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/sql/sql_connect.cc:1350
|
#24 0x000056419d80b397 in pfs_spawn_thread (arg=0x5641a41723c8) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-ubsan/storage/perfschema/pfs.cc:2198
|
#25 0x00007fee5eea8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
|
#26 0x00007fee5ef2861c 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
- is duplicated by
-
MDEV-35284 Server crash or ASAN errors in mhnsw_read_next upon using vectors within transaction
- Closed