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

Assertion `v->distance_to_target >= threshold' fails upon adding overflowing values to vector key #2

    XMLWordPrintable

Details

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

          Activity

            People

              serg Sergei Golubchik
              elenst Elena Stepanova
              Votes:
              0 Vote for this issue
              Watchers:
              1 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.