Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
N/A
Note: max_edges_per_node is not important for the scenario, it just allows to achieve the same result with less rows in the table (and thus quicker INSERT).
Still, the test case is non-deterministic, sleep value and the size of the table may need to be adjusted depending on the machine and the build type. Please don't put it into the regression suite, I suppose it should be possible to create a synchronized one instead.
--source include/have_innodb.inc
--source include/have_sequence.inc
--let $datadir= `select @@datadir`
create table t (a vector(1) not null ) engine=InnoDB;
insert into t select 0x00000000 from seq_1_to_1000;
--connect (con1,localhost,root,,)
--send alter table t add vector(a) max_edges_per_node=200
--connection default
--sleep 1
--let $shutdown_timeout= 0
--source include/restart_mysqld.inc
show create table t;
drop table t;
--list_files $datadir/test/
bb-11.6-MDEV-32887-vector 764592a4da2a1b490471732fbefe2ce745ce1f32
show create table t;
Table Create Table
t CREATE TABLE `t` (
`a` vector(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_uca1400_ai_ci
drop table t;
#sql-alter-1a7cfc-5#i#00.ibd
...
MTR's internal check of the test case 'bug.t' failed.
...
DEBUG_SYNC ON - current signals: ''
+#sql-alter-1a7cfc-5#i#00.ibd
is caused by
MDEV-34939
vector search in 11.7
Closed
{"report":{"fcp":702.1000001430511,"ttfb":125,"pageVisibility":"visible","entityId":131198,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"993ff90c-788e-458b-8cef-6431158d21ae","navigationType":0,"readyForUser":762.1000001430511,"redirectCount":0,"resourceLoadedEnd":833.3000001907349,"resourceLoadedStart":130.30000019073486,"resourceTiming":[{"duration":115.29999995231628,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":130.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":130.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":245.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":115,"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":130.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":130.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":245.60000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":123.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":130.80000019073486,"connectEnd":130.80000019073486,"connectStart":130.80000019073486,"domainLookupEnd":130.80000019073486,"domainLookupStart":130.80000019073486,"fetchStart":130.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":130.80000019073486,"responseEnd":254.70000004768372,"responseStart":254.70000004768372,"secureConnectionStart":130.80000019073486},{"duration":166.20000004768372,"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":130.90000009536743,"connectEnd":130.90000009536743,"connectStart":130.90000009536743,"domainLookupEnd":130.90000009536743,"domainLookupStart":130.90000009536743,"fetchStart":130.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":130.90000009536743,"responseEnd":297.10000014305115,"responseStart":297.10000014305115,"secureConnectionStart":130.90000009536743},{"duration":169.80000019073486,"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":131,"connectEnd":131,"connectStart":131,"domainLookupEnd":131,"domainLookupStart":131,"fetchStart":131,"redirectEnd":0,"redirectStart":0,"requestStart":131,"responseEnd":300.80000019073486,"responseStart":300.80000019073486,"secureConnectionStart":131},{"duration":170.29999995231628,"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":131.10000014305115,"connectEnd":131.10000014305115,"connectStart":131.10000014305115,"domainLookupEnd":131.10000014305115,"domainLookupStart":131.10000014305115,"fetchStart":131.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":131.10000014305115,"responseEnd":301.40000009536743,"responseStart":301.40000009536743,"secureConnectionStart":131.10000014305115},{"duration":170.5,"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":131.20000004768372,"connectEnd":131.20000004768372,"connectStart":131.20000004768372,"domainLookupEnd":131.20000004768372,"domainLookupStart":131.20000004768372,"fetchStart":131.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":131.20000004768372,"responseEnd":301.7000000476837,"responseStart":301.7000000476837,"secureConnectionStart":131.20000004768372},{"duration":170.79999995231628,"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":131.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":131.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":170.70000004768372,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":131.40000009536743,"connectEnd":131.40000009536743,"connectStart":131.40000009536743,"domainLookupEnd":131.40000009536743,"domainLookupStart":131.40000009536743,"fetchStart":131.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":131.40000009536743,"responseEnd":302.10000014305115,"responseStart":302.10000014305115,"secureConnectionStart":131.40000009536743},{"duration":170.89999985694885,"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":131.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":131.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":302.5,"responseStart":0,"secureConnectionStart":0},{"duration":171,"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":131.70000004768372,"connectEnd":131.70000004768372,"connectStart":131.70000004768372,"domainLookupEnd":131.70000004768372,"domainLookupStart":131.70000004768372,"fetchStart":131.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":131.70000004768372,"responseEnd":302.7000000476837,"responseStart":302.7000000476837,"secureConnectionStart":131.70000004768372},{"duration":306.5,"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":132.5,"connectEnd":132.5,"connectStart":132.5,"domainLookupEnd":132.5,"domainLookupStart":132.5,"fetchStart":132.5,"redirectEnd":0,"redirectStart":0,"requestStart":132.5,"responseEnd":439,"responseStart":438.90000009536743,"secureConnectionStart":132.5},{"duration":700.8000001907349,"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":132.5,"connectEnd":132.5,"connectStart":132.5,"domainLookupEnd":132.5,"domainLookupStart":132.5,"fetchStart":132.5,"redirectEnd":0,"redirectStart":0,"requestStart":132.5,"responseEnd":833.3000001907349,"responseStart":833.3000001907349,"secureConnectionStart":132.5},{"duration":368.2000000476837,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":464.40000009536743,"connectEnd":464.40000009536743,"connectStart":464.40000009536743,"domainLookupEnd":464.40000009536743,"domainLookupStart":464.40000009536743,"fetchStart":464.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":464.40000009536743,"responseEnd":832.6000001430511,"responseStart":832.6000001430511,"secureConnectionStart":464.40000009536743}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":125,"responseEnd":127,"domLoading":129,"domInteractive":856,"domContentLoadedEventStart":856,"domContentLoadedEventEnd":889,"domComplete":1860,"loadEventStart":1860,"loadEventEnd":1861,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":839.9000000953674},{"name":"bigPipe.sidebar-id.end","time":840.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":840.7000000476837},{"name":"bigPipe.activity-panel-pipe-id.end","time":842.8000001907349},{"name":"activityTabFullyLoaded","time":894.9000000953674}],"measures":[],"correlationId":"94e3b8ae917483","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":66,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}