oceanbase / oceanbase/seekdb

mysqltest vector_index.sparse_vector_index_vsag_offline_ddl fails with 'Invalid argument (1210)' on INSERT for VSAG+SINDI sparse vector index table

Open
#515 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

dima type: bug
Dominant language
C++
Stars
2.9k
Forks
339
Avg merge
1d 19h
Merged PRs (30d)
52

Description

Environment

  • Version: Server version: 5.7.25 OceanBase seekdb (r) (Built 1-6006e21fa93bdfcf5496d13de61fe94aacaebaa4 Apr 6 2026)

Reproduction Environment

  • Machine: Android Studio Android Virtual Device
  • Device: emulator-5554
  • Platform: arm64
  • Startup Command: ./data/local/tmp/seekdb --nodaemon --base-dir /data/local/tmp/seekdb_data --port 5881
  • Listening Port: 5881

Actual Result

Error Screenshot

Steps to Reproduce

  1. Navigate to the directory /obdata/data/AndroidTest/ob_opensource_test/tools/deploy on the machine.
  2. Execute the following commands:
export OCEANBASE_HOME=/obdata/data/AndroidTest/ob_opensource_test/
cd ${OCEANBASE_HOME}/tools/deploy
source activate_obd.sh
export OBD_SEEKDB_STATUS_FALLBACK_TCP=1

obd test mysqltest test_env --mysqltest-bin=${OCEANBASE_HOME}/deps/3rd/u01/obclient/bin/mysqltest --obclient-bin=${OCEANBASE_HOME}/deps/3rd/u01/obclient/bin/obclient --init-only --init-sql-dir=${OCEANBASE_HOME}/tools/deploy --init-sql-files='init.sql,init_user.sql|root@sys|test'
obd test mysqltest test_env --mysqltest-bin=${OCEANBASE_HOME}/deps/3rd/u01/obclient/bin/mysqltest --obclient-bin=${OCEANBASE_HOME}/deps/3rd/u01/obclient/bin/obclient --disable-reboot --test-set=vector_index.sparse_vector_index_vsag_offline_ddl

Execution Output:
Execution Screenshot 1
Execution Screenshot 2

SQL to Reproduce

CREATE DATABASE IF NOT EXISTS sparse_offline_ddl;
USE sparse_offline_ddl;

ALTER SYSTEM SET ob_vector_memory_limit_percentage = 20;

DROP TABLE IF EXISTS t1;

CREATE TABLE t1(
  c1 INT,
  c2 SPARSEVECTOR,
  PRIMARY KEY(c1),
  VECTOR INDEX idx1(c2)
    WITH (distance=inner_product, type=sindi, lib=vsag)
);

-- Optional: Confirm table creation succeeded
SHOW CREATE TABLE t1;

-- 【Failure】Expected to succeed, actual error 1210
INSERT INTO t1 VALUES (1, '{1:0.1, 2:0.2, 3:0.3}');

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Research direction

Start by running the mysqltest set vector_index.sparse_vector_index_vsag_offline_ddl with the provided deployment commands, then reproduce the INSERT from the SQL example. Trace the sparse-vector table path for the VSAG+SINDI offline DDL configuration and determine why the INSERT returns error 1210. Done means the INSERT succeeds and the named mysqltest passes with regression coverage for this case.

Written by the indexing model from the issue text.

Assessment

Tech stack
sql
Domain
databases
Issue type
Bug
Difficulty
4/5
Estimated time
3-5 days
Activity status
Quiet
Clarity
Mostly clear
Newbie friendliness
45/100

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.