Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
N/A
CREATE TABLE t (a INT , v BLOB NOT NULL , VECTOR INDEX (v));
ANALYZE TABLE t PERSISTENT FOR COLUMNS() INDEXES (v);
# Cleanup
DROP TABLE t;
bb-11.6-MDEV-32887-vector f20a1f4e94f5fc700959ff6b7945aa8a5fd0c307
#3 <signal handler called>
#4 0x000055b8d862d044 in Index_statistics::get_avg_frequency (this=0x0, i=0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_statistics.h:615
#5 0x000055b8d8631f2d in Index_stat::store_stat_fields (this=0x7f4818cbc660) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_statistics.cc:1506
#6 0x000055b8d862e34a in Stat_table::update_stat (this=0x7f4818cbc660) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_statistics.cc:715
#7 0x000055b8d8622008 in update_statistics_for_table (thd=0x62c0000c0218, table=0x61900009dd98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_statistics.cc:2980
#8 0x000055b8d8888a97 in mysql_admin_table (thd=0x62c0000c0218, tables=0x6290000e6370, check_opt=0x62c0000c5a40, operator_name=0x55b8dbd749a0 <msg_analyze>, lock_type=TL_READ_NO_INSERT, org_open_for_modify=true, no_errors_from_open=false, extra_open_options=0, prepare_func=0x0, operator_func=(int (handler::*)(handler * const, THD *, HA_CHECK_OPT *)) 0x55b8d8d14b9c <handler::ha_analyze(THD*, st_ha_check_opt*)>, view_operator_func=0x0, is_cmd_replicated=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_admin.cc:1093
#9 0x000055b8d888d26f in Sql_cmd_analyze_table::execute (this=0x6290000e6b08, thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_admin.cc:1619
#10 0x000055b8d8379a72 in mysql_execute_command (thd=0x62c0000c0218, is_called_from_prepared_stmt=false) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:5846
#11 0x000055b8d8386b8a in mysql_parse (thd=0x62c0000c0218, rawbuf=0x6290000e6238 "ANALYZE TABLE t PERSISTENT FOR COLUMNS() INDEXES (v)", length=52, parser_state=0x7f4818cc29f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
#12 0x000055b8d835dbac in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x629000253219 "", packet_length=52, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
#13 0x000055b8d835a8c0 in do_command (thd=0x62c0000c0218, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1405
#14 0x000055b8d884a421 in do_handle_one_connection (connect=0x6080000034b8, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
#15 0x000055b8d8849de2 in handle_one_connection (arg=0x608000003438) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
#16 0x000055b8d94eb99a in pfs_spawn_thread (arg=0x617000005b98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
#17 0x00007f48242a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#18 0x00007f482432861c 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":1447.3000001907349,"ttfb":346,"pageVisibility":"visible","entityId":130974,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"dcf6151c-68ad-49cf-9b3b-55da6745f430","navigationType":0,"readyForUser":1537.6999998092651,"redirectCount":0,"resourceLoadedEnd":1593.0999994277954,"resourceLoadedStart":361.3999996185303,"resourceTiming":[{"duration":513.8000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":361.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":361.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":875.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":513.8000001907349,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":361.5999994277954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":361.5999994277954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":875.3999996185303,"responseStart":0,"secureConnectionStart":0},{"duration":522.2999992370605,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":361.80000019073486,"connectEnd":361.80000019073486,"connectStart":361.80000019073486,"domainLookupEnd":361.80000019073486,"domainLookupStart":361.80000019073486,"fetchStart":361.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":361.80000019073486,"responseEnd":884.0999994277954,"responseStart":884.0999994277954,"secureConnectionStart":361.80000019073486},{"duration":580.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/2bf333562ca6724060a9d5f1535471f6/_/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":361.8999996185303,"connectEnd":361.8999996185303,"connectStart":361.8999996185303,"domainLookupEnd":361.8999996185303,"domainLookupStart":361.8999996185303,"fetchStart":361.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":361.8999996185303,"responseEnd":942.5999994277954,"responseStart":942.5999994277954,"secureConnectionStart":361.8999996185303},{"duration":584.0999994277954,"initiatorType":"script","name":"https://jira.mariadb.org/s/a9324d6758d385eb45c462685ad88f1d-CDN/lu2cib/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":362.30000019073486,"connectEnd":362.30000019073486,"connectStart":362.30000019073486,"domainLookupEnd":362.30000019073486,"domainLookupStart":362.30000019073486,"fetchStart":362.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":362.30000019073486,"responseEnd":946.3999996185303,"responseStart":946.3999996185303,"secureConnectionStart":362.30000019073486},{"duration":584.3000001907349,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":362.5,"connectEnd":362.5,"connectStart":362.5,"domainLookupEnd":362.5,"domainLookupStart":362.5,"fetchStart":362.5,"redirectEnd":0,"redirectStart":0,"requestStart":362.5,"responseEnd":946.8000001907349,"responseStart":946.8000001907349,"secureConnectionStart":362.5},{"duration":584.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":362.80000019073486,"connectEnd":362.80000019073486,"connectStart":362.80000019073486,"domainLookupEnd":362.80000019073486,"domainLookupStart":362.80000019073486,"fetchStart":362.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":362.80000019073486,"responseEnd":947.3000001907349,"responseStart":947.3000001907349,"secureConnectionStart":362.80000019073486},{"duration":667.1999998092651,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2cib/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":362.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":362.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1030.0999994277954,"responseStart":0,"secureConnectionStart":0},{"duration":584.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":363.19999980926514,"connectEnd":363.19999980926514,"connectStart":363.19999980926514,"domainLookupEnd":363.19999980926514,"domainLookupStart":363.19999980926514,"fetchStart":363.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":363.19999980926514,"responseEnd":947.6999998092651,"responseStart":947.6999998092651,"secureConnectionStart":363.19999980926514},{"duration":667,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2cib/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":363.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":363.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1030.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":584.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/5d5e8fe91fbc506585e83ea3b62ccc4b-CDN/lu2cib/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":363.5,"connectEnd":363.5,"connectStart":363.5,"domainLookupEnd":363.5,"domainLookupStart":363.5,"fetchStart":363.5,"redirectEnd":0,"redirectStart":0,"requestStart":363.5,"responseEnd":948.1999998092651,"responseStart":948.1999998092651,"secureConnectionStart":363.5},{"duration":711.1000003814697,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":364.3999996185303,"connectEnd":364.3999996185303,"connectStart":364.3999996185303,"domainLookupEnd":364.3999996185303,"domainLookupStart":364.3999996185303,"fetchStart":364.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":364.3999996185303,"responseEnd":1075.5,"responseStart":1075.5,"secureConnectionStart":364.3999996185303},{"duration":815.1999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":364.3999996185303,"connectEnd":364.3999996185303,"connectStart":364.3999996185303,"domainLookupEnd":364.3999996185303,"domainLookupStart":364.3999996185303,"fetchStart":364.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":364.3999996185303,"responseEnd":1179.5999994277954,"responseStart":1179.5999994277954,"secureConnectionStart":364.3999996185303},{"duration":52,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1057.1999998092651,"connectEnd":1057.1999998092651,"connectStart":1057.1999998092651,"domainLookupEnd":1057.1999998092651,"domainLookupStart":1057.1999998092651,"fetchStart":1057.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":1057.1999998092651,"responseEnd":1109.1999998092651,"responseStart":1109.1999998092651,"secureConnectionStart":1057.1999998092651},{"duration":271.8999996185303,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/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":1321.1999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1321.1999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1593.0999994277954,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":196,"responseStart":346,"responseEnd":356,"domLoading":359,"domInteractive":1622,"domContentLoadedEventStart":1622,"domContentLoadedEventEnd":1677,"domComplete":2260,"loadEventStart":2261,"loadEventEnd":2261,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1600.5999994277954},{"name":"bigPipe.sidebar-id.end","time":1601.3999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":1601.5},{"name":"bigPipe.activity-panel-pipe-id.end","time":1601.8999996185303},{"name":"activityTabFullyLoaded","time":1684.3000001907349}],"measures":[],"correlationId":"e01d021b4898bd","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":89,"dbReadsTimeInMs":11,"dbConnsTimeInMs":19,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}