Type:
Bug
Priority:
Critical
Resolution:
Fixed
Affects Version/s:
N/A
Not related directly to vectors, but caused by changes in the vector branch.
--source include/have_rocksdb.inc
CREATE TABLE t (s INT , UNIQUE (s) USING HASH) ENGINE=RocksDB;
UPDATE t SET s = 1 WHERE s > 2;
# Cleanup
DROP TABLE t;
bb-11.6-MDEV-32887-vector 77be73c489fb7c21ca58e78cef10e0c166f293d8
mariadbd: /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/rocksdb/ha_rocksdb.cc:8121: int myrocks::ha_rocksdb::position_to_correct_key(const myrocks::Rdb_key_def&, const ha_rkey_function&, bool, const uchar*, const key_part_map&, const rocksdb::Slice&, bool*, int64_t): Assertion `0' failed.
241004 14:51:39 [ERROR] mysqld got signal 6 ;
#9 0x00007fa86a053e32 in __GI___assert_fail (assertion=0x7fa8621b0140 "0", file=0x7fa8621a1880 "/data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/rocksdb/ha_rocksdb.cc", line=8121, function=0x7fa8621b2da0 "int myrocks::ha_rocksdb::position_to_correct_key(const myrocks::Rdb_key_def&, const ha_rkey_function&, bool, const uchar*, const key_part_map&, const rocksdb::Slice&, bool*, int64_t)") at ./assert/assert.c:101
#10 0x00007fa860fd96f7 in myrocks::ha_rocksdb::position_to_correct_key (this=0x61d000267ab8, kd=..., find_flag=@0x7fa85972c920: 134, full_key_match=false, key=0x6210001a3000 "", keypart_map=@0x7fa85972c950: 1, key_slice=..., move_forward=0x7fa85972c8e0, ttl_filter_ts=1728042829) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/rocksdb/ha_rocksdb.cc:8121
#11 0x00007fa860fdd2f9 in myrocks::ha_rocksdb::index_read_map_impl (this=0x61d000267ab8, buf=0x6190000ccbc8 "\377", key=0x6210001a3000 "", keypart_map=1, find_flag=134, end_key=0x0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/rocksdb/ha_rocksdb.cc:8629
#12 0x00007fa860fdbfaf in myrocks::ha_rocksdb::index_read_map (this=0x61d000267ab8, buf=0x6190000ccbc8 "\377", key=0x6210001a3000 "", keypart_map=1, find_flag=134) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/rocksdb/ha_rocksdb.cc:8463
#13 0x0000565226838a44 in handler::ha_index_read_map (this=0x61d000267ab8, buf=0x6190000ccbc8 "\377", key=0x6210001a3000 "", keypart_map=1, find_flag=134) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/handler.cc:3802
#14 0x0000565225b57945 in QUICK_RANGE_SELECT_GEOM::get_next (this=0x613000061240) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/opt_range.cc:13388
#15 0x0000565225bb4b5a in rr_quick (info=0x7fa85972d120) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/records.cc:398
#16 0x0000565225b7efc8 in READ_RECORD::read_record (this=0x7fa85972d120) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/records.h:77
#17 0x0000565226241127 in Sql_cmd_update::update_single_table (this=0x62900004bc88, thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_update.cc:785
#18 0x00005652262574b7 in Sql_cmd_update::execute_inner (this=0x62900004bc88, thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_update.cc:3102
#19 0x000056522608a2ee in Sql_cmd_dml::execute (this=0x62900004bc88, thd=0x62c0000c0218) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_select.cc:33798
#20 0x0000565225ea2790 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:4402
#21 0x0000565225ebabfa in mysql_parse (thd=0x62c0000c0218, rawbuf=0x62900004b238 "UPDATE t SET s = 1 WHERE s > 2", length=30, parser_state=0x7fa85972e9f0) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:7873
#22 0x0000565225e91c1c in dispatch_command (command=COM_QUERY, thd=0x62c0000c0218, packet=0x62900026c219 "UPDATE t SET s = 1 WHERE s > 2", packet_length=30, blocking=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_parse.cc:1892
#23 0x0000565225e8e930 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
#24 0x000056522637e189 in do_handle_one_connection (connect=0x6080000061b8, put_in_cache=true) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1448
#25 0x000056522637db4a in handle_one_connection (arg=0x608000006138) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/sql/sql_connect.cc:1350
#26 0x0000565227021672 in pfs_spawn_thread (arg=0x617000008c98) at /data/bld/preview-11.7-bb-11.6-MDEV-32887-vector-asan/storage/perfschema/pfs.cc:2198
#27 0x00007fa86a0a8044 in start_thread (arg=<optimized out>) at ./nptl/pthread_create.c:442
#28 0x00007fa86a12861c in clone3 () at ../sysdeps/unix/sysv/linux/x86_64/clone3.S:81
The failure started happening after this commit:
commit 8d2bd8dd714e94a2df7ab6566d1f4c465a79ef9a
Author: Sergei Golubchik
Date: Sun Jan 14 11:43:43 2024 +0100
cleanup: key algorithm vs key flags
There are no comments yet on this issue.
{"report":{"fcp":2498.399999976158,"ttfb":1234.2999999523163,"pageVisibility":"visible","entityId":131051,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":32,"apdex":0.5,"journeyId":"cdbc85db-e937-411b-9747-79bf0a500651","navigationType":0,"readyForUser":2589.100000023842,"redirectCount":0,"resourceLoadedEnd":3339.5,"resourceLoadedStart":1249.3999999761581,"resourceTiming":[{"duration":738.6000000238419,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":1249.3999999761581,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1249.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1988,"responseStart":0,"secureConnectionStart":0},{"duration":739.2000000476837,"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":1249.6999999284744,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1249.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1988.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":747.1000000238419,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":1249.8999999761581,"connectEnd":1249.8999999761581,"connectStart":1249.8999999761581,"domainLookupEnd":1249.8999999761581,"domainLookupStart":1249.8999999761581,"fetchStart":1249.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1249.8999999761581,"responseEnd":1997,"responseStart":1997,"secureConnectionStart":1249.8999999761581},{"duration":827.8999999761581,"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":1250.3999999761581,"connectEnd":1250.3999999761581,"connectStart":1250.3999999761581,"domainLookupEnd":1250.3999999761581,"domainLookupStart":1250.3999999761581,"fetchStart":1250.3999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1250.3999999761581,"responseEnd":2078.2999999523163,"responseStart":2078.2999999523163,"secureConnectionStart":1250.3999999761581},{"duration":831.6999999284744,"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":1250.6000000238419,"connectEnd":1250.6000000238419,"connectStart":1250.6000000238419,"domainLookupEnd":1250.6000000238419,"domainLookupStart":1250.6000000238419,"fetchStart":1250.6000000238419,"redirectEnd":0,"redirectStart":0,"requestStart":1250.6000000238419,"responseEnd":2082.2999999523163,"responseStart":2082.2999999523163,"secureConnectionStart":1250.6000000238419},{"duration":832.3000000715256,"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":1250.6999999284744,"connectEnd":1250.6999999284744,"connectStart":1250.6999999284744,"domainLookupEnd":1250.6999999284744,"domainLookupStart":1250.6999999284744,"fetchStart":1250.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1250.6999999284744,"responseEnd":2083,"responseStart":2083,"secureConnectionStart":1250.6999999284744},{"duration":832.6000000238419,"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":1250.8999999761581,"connectEnd":1250.8999999761581,"connectStart":1250.8999999761581,"domainLookupEnd":1250.8999999761581,"domainLookupStart":1250.8999999761581,"fetchStart":1250.8999999761581,"redirectEnd":0,"redirectStart":0,"requestStart":1250.8999999761581,"responseEnd":2083.5,"responseStart":2083.5,"secureConnectionStart":1250.8999999761581},{"duration":894.3999999761581,"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":1251,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1251,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2145.399999976158,"responseStart":0,"secureConnectionStart":0},{"duration":833.4000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":1251.1999999284744,"connectEnd":1251.1999999284744,"connectStart":1251.1999999284744,"domainLookupEnd":1251.1999999284744,"domainLookupStart":1251.1999999284744,"fetchStart":1251.1999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1251.1999999284744,"responseEnd":2084.600000023842,"responseStart":2084.600000023842,"secureConnectionStart":1251.1999999284744},{"duration":894.3999999761581,"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":1251.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1251.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2145.6999999284744,"responseStart":0,"secureConnectionStart":0},{"duration":833.7999999523163,"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":1251.5,"connectEnd":1251.5,"connectStart":1251.5,"domainLookupEnd":1251.5,"domainLookupStart":1251.5,"fetchStart":1251.5,"redirectEnd":0,"redirectStart":0,"requestStart":1251.5,"responseEnd":2085.2999999523163,"responseStart":2085.2999999523163,"secureConnectionStart":1251.5},{"duration":1540.3000000715256,"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":1253.6999999284744,"connectEnd":1253.6999999284744,"connectStart":1253.6999999284744,"domainLookupEnd":1253.6999999284744,"domainLookupStart":1253.6999999284744,"fetchStart":1253.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":1253.6999999284744,"responseEnd":2794,"responseStart":2794,"secureConnectionStart":1253.6999999284744},{"duration":2085.7000000476837,"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":1253.7999999523163,"connectEnd":1253.7999999523163,"connectStart":1253.7999999523163,"domainLookupEnd":1253.7999999523163,"domainLookupStart":1253.7999999523163,"fetchStart":1253.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":1253.7999999523163,"responseEnd":3339.5,"responseStart":3339.5,"secureConnectionStart":1253.7999999523163},{"duration":825.9000000953674,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":2189.6999999284744,"connectEnd":2189.6999999284744,"connectStart":2189.6999999284744,"domainLookupEnd":2189.6999999284744,"domainLookupStart":2189.6999999284744,"fetchStart":2189.6999999284744,"redirectEnd":0,"redirectStart":0,"requestStart":2189.6999999284744,"responseEnd":3015.600000023842,"responseStart":3015.600000023842,"secureConnectionStart":2189.6999999284744}],"fetchStart":0,"domainLookupStart":1027,"domainLookupEnd":1034,"connectStart":1034,"connectEnd":1054,"secureConnectionStart":1042,"requestStart":1054,"responseStart":1234,"responseEnd":1253,"domLoading":1243,"domInteractive":3359,"domContentLoadedEventStart":3359,"domContentLoadedEventEnd":3417,"domComplete":3976,"loadEventStart":3976,"loadEventEnd":3977,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":3342},{"name":"bigPipe.sidebar-id.end","time":3342.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":3343},{"name":"bigPipe.activity-panel-pipe-id.end","time":3343.399999976158},{"name":"activityTabFullyLoaded","time":3424.6999999284744}],"measures":[],"correlationId":"43d1b65841dc7d","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":13,"dbConnsTimeInMs":21,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}