Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
N/A
--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
is caused by
MDEV-34939
vector search in 11.7
Closed
There are no comments yet on this issue.
{"report":{"fcp":985.6000000238419,"ttfb":348.60000002384186,"pageVisibility":"visible","entityId":131173,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"37288c1e-822a-4122-9414-70a1462a4db3","navigationType":0,"readyForUser":1067.3999999761581,"redirectCount":0,"resourceLoadedEnd":1216.699999988079,"resourceLoadedStart":354,"resourceTiming":[{"duration":105.10000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":354,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":354,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":459.10000002384186,"responseStart":0,"secureConnectionStart":0},{"duration":105.69999998807907,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/css/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":354.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":354.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":459.89999997615814,"responseStart":0,"secureConnectionStart":0},{"duration":161.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":354.39999997615814,"connectEnd":354.39999997615814,"connectStart":354.39999997615814,"domainLookupEnd":354.39999997615814,"domainLookupStart":354.39999997615814,"fetchStart":354.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":354.39999997615814,"responseEnd":515.6999999880791,"responseStart":515.6999999880791,"secureConnectionStart":354.39999997615814},{"duration":259,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/download/contextbatch/js/jira.browse.project,project.issue.navigator,jira.view.issue,jira.general,jira.global,atl.general,-_super/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":354.60000002384186,"connectEnd":354.60000002384186,"connectStart":354.60000002384186,"domainLookupEnd":354.60000002384186,"domainLookupStart":354.60000002384186,"fetchStart":354.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":354.60000002384186,"responseEnd":613.6000000238419,"responseStart":613.6000000238419,"secureConnectionStart":354.60000002384186},{"duration":262.5999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":354.80000001192093,"connectEnd":354.80000001192093,"connectStart":354.80000001192093,"domainLookupEnd":354.80000001192093,"domainLookupStart":354.80000001192093,"fetchStart":354.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":354.80000001192093,"responseEnd":617.3999999761581,"responseStart":617.3999999761581,"secureConnectionStart":354.80000001192093},{"duration":262.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":355,"connectEnd":355,"connectStart":355,"domainLookupEnd":355,"domainLookupStart":355,"fetchStart":355,"redirectEnd":0,"redirectStart":0,"requestStart":355,"responseEnd":617.8000000119209,"responseStart":617.8000000119209,"secureConnectionStart":355},{"duration":263,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":355.19999998807907,"connectEnd":355.19999998807907,"connectStart":355.19999998807907,"domainLookupEnd":355.19999998807907,"domainLookupStart":355.19999998807907,"fetchStart":355.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":355.19999998807907,"responseEnd":618.1999999880791,"responseStart":618.1999999880791,"secureConnectionStart":355.19999998807907},{"duration":311.2000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":355.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":355.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":666.6000000238419,"responseStart":0,"secureConnectionStart":0},{"duration":311.0999999642372,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/css/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.css?jira.create.linked.issue=true","startTime":355.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":355.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":666.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":263.0999999642372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":355.60000002384186,"connectEnd":355.60000002384186,"connectStart":355.60000002384186,"domainLookupEnd":355.60000002384186,"domainLookupStart":355.60000002384186,"fetchStart":355.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":355.60000002384186,"responseEnd":618.6999999880791,"responseStart":618.6999999880791,"secureConnectionStart":355.60000002384186},{"duration":263.4000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/820016/12ta74/d176f0986478cc64f24226b3d20c140d/_/download/contextbatch/js/com.atlassian.jira.projects.sidebar.init,-_super,-project.issue.navigator,-jira.view.issue/batch.js?jira.create.linked.issue=true&locale=en","startTime":355.89999997615814,"connectEnd":355.89999997615814,"connectStart":355.89999997615814,"domainLookupEnd":355.89999997615814,"domainLookupStart":355.89999997615814,"fetchStart":355.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":355.89999997615814,"responseEnd":619.3000000119209,"responseStart":619.1999999880791,"secureConnectionStart":355.89999997615814},{"duration":722.7999999523163,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":361.60000002384186,"connectEnd":361.60000002384186,"connectStart":361.60000002384186,"domainLookupEnd":361.60000002384186,"domainLookupStart":361.60000002384186,"fetchStart":361.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":361.60000002384186,"responseEnd":1084.3999999761581,"responseStart":1084.3999999761581,"secureConnectionStart":361.60000002384186},{"duration":785.9000000357628,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":361.69999998807907,"connectEnd":361.69999998807907,"connectStart":361.69999998807907,"domainLookupEnd":361.69999998807907,"domainLookupStart":361.69999998807907,"fetchStart":361.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":361.69999998807907,"responseEnd":1147.6000000238419,"responseStart":1147.6000000238419,"secureConnectionStart":361.69999998807907},{"duration":406,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":678.6999999880791,"connectEnd":678.6999999880791,"connectStart":678.6999999880791,"domainLookupEnd":678.6999999880791,"domainLookupStart":678.6999999880791,"fetchStart":678.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":678.6999999880791,"responseEnd":1084.699999988079,"responseStart":1084.699999988079,"secureConnectionStart":678.6999999880791},{"duration":184.5,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":979.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":979.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1164,"responseStart":0,"secureConnectionStart":0},{"duration":89.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/css/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1112,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1112,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1201.3999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":71.30000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/e65b778d185daf5aee24936755b43da6/_/download/contextbatch/js/browser-metrics-plugin.contrib,-_super,-project.issue.navigator,-jira.view.issue,-atl.general/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":1113.199999988079,"connectEnd":1113.199999988079,"connectStart":1113.199999988079,"domainLookupEnd":1113.199999988079,"domainLookupStart":1113.199999988079,"fetchStart":1113.199999988079,"redirectEnd":0,"redirectStart":0,"requestStart":1113.199999988079,"responseEnd":1184.5,"responseStart":1184.5,"secureConnectionStart":1113.199999988079},{"duration":102.80000001192093,"initiatorType":"script","name":"https://jira.mariadb.org/s/f51ef5507eea4c158f257c66c93b2a3f-CDN/lu2bu7/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/jira.project.sidebar,-_super,-project.issue.navigator,-jira.general,-jira.browse.project,-jira.view.issue,-jira.global,-atl.general,-com.atlassian.jira.projects.sidebar.init/batch.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":1113.8999999761581,"connectEnd":1113.8999999761581,"connectStart":1113.8999999761581,"domainLookupEnd":1113.8999999761581,"domainLookupStart":1113.8999999761581,"fetchStart":1113.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1113.8999999761581,"responseEnd":1216.699999988079,"responseStart":1216.699999988079,"secureConnectionStart":1113.8999999761581}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":191,"responseStart":349,"responseEnd":354,"domLoading":352,"domInteractive":1221,"domContentLoadedEventStart":1221,"domContentLoadedEventEnd":1262,"domComplete":1495,"loadEventStart":1495,"loadEventEnd":1495,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1202.699999988079},{"name":"bigPipe.sidebar-id.end","time":1203.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1203.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1204.199999988079},{"name":"activityTabFullyLoaded","time":1271.6000000238419}],"measures":[],"correlationId":"209e6c2e6d092e","effectiveType":"4g","downlink":9.6,"rtt":0,"serverDuration":95,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}