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

Server crashes in FVectorNode::gref_len with insufficient mhnsw_max_cache_size

    XMLWordPrintable

Details

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

          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.