Crash during query of a table with VECTOR columns

251114 10:32:29 [ERROR] /usr/sbin/mariadbd got signal 11 ;

Sorry, we probably made a mistake, and this is a bug.

Your assistance in bug reporting will enable us to fix this for the next release.

To report this bug, see https://mariadb.com/kb/en/reporting-bugs about how to report

a bug on https://jira.mariadb.org/.

Please include the information from the server start above, to the end of the

information below.

Server version: 11.7.2-MariaDB-ubu2204-log source revision: 80067a69feaeb5df30abb1bfaf7d4e713ccbf027

The information page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mariadbd/

contains instructions to obtain a better version of the backtrace below.

Following these instructions will help MariaDB developers provide a fix quicker.

Attempting backtrace. Include this in the bug report.

(note: Retrieving this information may fail)

Thread pointer: 0x7f730c01c238

stack_bottom = 0x7f73e00fd000 thread_stack 0x49000

2025-11-14 10:32:30 0 [Note] /usr/sbin/mariadbd (initiated by: unknown): Normal shutdown

/usr/sbin/mariadbd(my_print_stacktrace+0x30)[0x558898da5180]

/usr/sbin/mariadbd(handle_fatal_signal+0x365)[0x55889892fe65]

/lib/x86_64-linux-gnu/libc.so.6(+0x42520)[0x7fded678d520]

/usr/sbin/mariadbd(_Z15mhnsw_read_nextP5TABLE+0x30a)[0x558898a7bf3a]

/usr/sbin/mariadbd(+0x8927a6)[0x55889869f7a6]

/usr/sbin/mariadbd(_Z10sub_selectP4JOINP13st_join_tableb+0x2b7)[0x55889869d8f7]

/usr/sbin/mariadbd(_ZN4JOIN10exec_innerEv+0xfa2)[0x55889866f472]

/usr/sbin/mariadbd(_ZN4JOIN4execEv+0x37)[0x55889866f8b7]

/usr/sbin/mariadbd(_Z12mysql_selectP3THDP10TABLE_LISTR4ListI4ItemEPS4_jP8st_orderS9_S7_S9_yP13select_resultP18st_select_lex_unitP13st_select_lex+0x136)[0x558898677ce6]

/usr/sbin/mariadbd(_Z13handle_selectP3THDP3LEXP13select_resulty+0x189)[0x5588986787e9]

/usr/sbin/mariadbd(+0x810b21)[0x55889861db21]

/usr/sbin/mariadbd(_Z21mysql_execute_commandP3THDb+0x3c40)[0x558898629cf0]

/usr/sbin/mariadbd(_Z11mysql_parseP3THDPcjP12Parser_state+0x1b1)[0x558898631b61]

/usr/sbin/mariadbd(_Z16dispatch_command19enum_server_commandP3THDPcjb+0xe9c)[0x5588986236fc]

/usr/sbin/mariadbd(_Z10do_commandP3THDb+0x17a)[0x558898624f3a]

/usr/sbin/mariadbd(_Z11tp_callbackP13TP_connection+0xbc)[0x5588988a710c]

/usr/sbin/mariadbd(+0xca8c7d)[0x558898ab5c7d]

/usr/sbin/mariadbd(+0xd5217c)[0x558898b5f17c]

/lib/x86_64-linux-gnu/libc.so.6(+0x94ac3)[0x7fded67dfac3]

/lib/x86_64-linux-gnu/libc.so.6(+0x1268c0)[0x7fded68718c0]

Connection ID (thread ID): 67

Status: KILL_SERVER

Query (0x7f730c0033c0): SELECT run_errorString_embeddings.run_id, VEC_DISTANCE_EUCLIDEAN(embedding, VEC_FromText(@myvec)) as distance FROM run_errorString_embeddings  JOIN run on run_errorString_embeddings.run_id = run.id JOIN testAndSuite on run.testAndSuite_id = testAndSuite.id  JOIN testAndSuite_owner on testAndSuite.id = testAndSuite_owner.testAndSuite_id  JOIN owner on testAndSuite_owner.owner_id = owner.id STRAIGHT_JOIN regressRun on run.regressRun_id = regressRun.id  WHERE run_errorString_embeddings.vector_added = 1  and regressRun.date >= '2025-09-14 09:45:54'  and regressRun.branch_id = 4 ORDER BY distance LIMIT 1200

Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=on,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on,split_materialized=on,condition_pushdown_for_subquery=on,rowid_filter=on,condition_pushdown_from_having=on,not_null_range_scan=off,hash_join_cardinality=on,cset_narrowing=on,sargable_casefold=on

Writing a core file...

Working directory at /mysql2/data

Resource Limits (excludes unlimited resources):

Limit                     Soft Limit           Hard Limit           Units

Max stack size            8388608              unlimited            bytes

Max core file size        0                    unlimited            bytes

Max processes             2062037              2062037              processes

Max open files            32768                32768                files

Max locked memory         524288               524288               bytes

Max pending signals       2062037              2062037              signals

Max msgqueue size         819200               819200               bytes

Max nice priority         0                    0

Max realtime priority     0                    0

Core pattern: |/usr/share/apport/apport -p%p -s%s -c%c -d%d -P%P -u%u -g%g -F%F -- %E

Kernel version: Linux version 5.15.0-131-generic (buildd@lcy02-amd64-057) (gcc (Ubuntu 11.4.0-1ubuntu1~22.04) 11.4.0, GNU ld (GNU Binutils for Ubuntu) 2.38) #141-Ubuntu SMP Fri Jan 10 21:18:28 UTC 2025

CREATE TABLE `run_errorString_embeddings` (

	`run_id` INT(10) UNSIGNED NOT NULL,

	`attributes` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin',

	`embedding` VECTOR(1024) NOT NULL,

	`vector_added` TINYINT(1) NOT NULL DEFAULT '0',

	PRIMARY KEY (`run_id`) USING BTREE,

	VECTOR INDEX `vect_embeddings` (`embedding`),

	CONSTRAINT `attributes` CHECK (json_valid(`attributes`))

)

COLLATE='utf8mb4_bin'

ENGINE=InnoDB

;