Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-35131

Assertion `std::isnan(v->distance_to_target) || v->distance_to_target >= threshold' failed upon SELECT

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • N/A
    • 11.7.1
    • Vector search
    • 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

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.