Type:
Priority:
Resolution:
Fixed
Affects Version/s:
10.1.19 , 10.3.4 , 10.2.13 , 10.4.0 , 10.5.0
Environment:
Ubuntu 17.04 (Zesty Zapus) but I assume that the OS is not important.
Sorry, but the frontend did not allow me to fill in the MariaDB versions used.
10.2.17 commit 400cf017152c732387c89deaa082b43c8fb42d71
10.3.8 commit 71144afa966a85d08053eb616a1021fd339102d1
Server error log entries + Backtrace of 10.3:
InnoDB: Assertion failure in file storage/innobase/lock/lock0lock.cc line 5019
InnoDB: Failing assertion: !other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)
...
Query: DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* E_R Thread1 QNO 6083 CON_ID 15 */
...
Status: NOT_KILLED
#3 <signal handler called>
#4 __GI_raise (sig=sig@entry=6) at ../sysdeps/unix/sysv/linux/raise.c:58
#5 0x00007f8acda5237a in __GI_abort () at abort.c:89
#6 0x000055e6267f1eaf in ut_dbg_assertion_failed (expr=0x55e626e559d8 "!other_lock || wsrep_thd_is_BF(lock->trx->mysql_thd, FALSE) || wsrep_thd_is_BF(other_lock->trx->mysql_thd, FALSE)", file=0x55e626e53a40 "storage/innobase/lock/lock0lock.cc", line=5019) at storage/innobase/ut/ut0dbg.cc:61
#7 0x000055e62664b06c in lock_rec_queue_validate (locked_lock_trx_sys=false, block=0x7f8aaba3e100, rec=0x7f8aac52c149 "", index=0x7f8a2c2cdb18, offsets=0x7f8ac41923b0) at storage/innobase/lock/lock0lock.cc:5017
#8 0x000055e62664dd24 in lock_clust_rec_read_check_and_lock (flags=0, block=0x7f8aaba3e100, rec=0x7f8aac52c149 "", index=0x7f8a2c2cdb18, offsets=0x7f8ac41923b0, mode=LOCK_X, gap_mode=1024, thr=0x7f8a2c2de240) at storage/innobase/lock/lock0lock.cc:5862
#9 0x000055e62674f5e1 in sel_set_rec_lock (pcur=0x7f8a2c2ddd38, rec=0x7f8aac52c149 "", index=0x7f8a2c2cdb18, offsets=0x7f8ac41923b0, mode=3, type=1024, thr=0x7f8a2c2de240, mtr=0x7f8ac4192cd0) at storage/innobase/row/row0sel.cc:1247
#10 0x000055e6267588d4 in row_search_mvcc (buf=0x7f8a2c2dd720 "\377", mode=PAGE_CUR_G, prebuilt=0x7f8a2c2ddb78, match_mode=0, direction=0) at storage/innobase/row/row0sel.cc:5020
#11 0x000055e6265c17bd in ha_innobase::index_read (this=0x7f8a2c2dcf90, buf=0x7f8a2c2dd720 "\377", key_ptr=0x0, key_len=0, find_flag=HA_READ_AFTER_KEY) at storage/innobase/handler/ha_innodb.cc:9315
#12 0x000055e6265c2ab6 in ha_innobase::index_first (this=0x7f8a2c2dcf90, buf=0x7f8a2c2dd720 "\377") at storage/innobase/handler/ha_innodb.cc:9732
#13 0x000055e6265c2cc5 in ha_innobase::rnd_next (this=0x7f8a2c2dcf90, buf=0x7f8a2c2dd720 "\377") at storage/innobase/handler/ha_innodb.cc:9825
#14 0x000055e6263b16f1 in handler::ha_rnd_next (this=0x7f8a2c2dcf90, buf=0x7f8a2c2dd720 "\377") at sql/handler.cc:2764
#15 0x000055e62652db86 in rr_sequential (info=0x7f8ac41935c0) at sql/records.cc:481
#16 0x000055e62602aa5d in READ_RECORD::read_record (this=0x7f8ac41935c0) at sql/records.h:73
#17 0x000055e62654ae08 in mysql_delete (thd=0x7f8a2c000a98, table_list=0x7f8a2c014c78, conds=0x7f8a2c0157b8, order_list=0x7f8a2c0052f0, limit=18446744073709551615, options=549755813888, result=0x0) at sql/sql_delete.cc:727
#18 0x000055e6260c5c03 in mysql_execute_command (thd=0x7f8a2c000a98) at sql/sql_parse.cc:4916
#19 0x000055e6260cfe9e in mysql_parse (thd=0x7f8a2c000a98, rawbuf=0x7f8a2c014b20 "DELETE FROM t1 WHERE col1 = 1 OR col1 IS NULL /* E_R Thread1 QNO 6083 CON_ID 15 */", length=83, parser_state=0x7f8ac4194640, is_com_multi=false, is_next_command=false) at sql/sql_parse.cc:8076
...
{"report":{"fcp":1137.2000002861023,"ttfb":314.40000009536743,"pageVisibility":"visible","entityId":68482,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"daf868c1-ed2c-48b8-8851-562f4cdb9144","navigationType":0,"readyForUser":1422.7000002861023,"redirectCount":0,"resourceLoadedEnd":1424,"resourceLoadedStart":320.59999990463257,"resourceTiming":[{"duration":159.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":320.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":320.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":480.09999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":159.40000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":320.90000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":320.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":480.30000019073486,"responseStart":0,"secureConnectionStart":0},{"duration":267.40000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":321.09999990463257,"connectEnd":321.09999990463257,"connectStart":321.09999990463257,"domainLookupEnd":321.09999990463257,"domainLookupStart":321.09999990463257,"fetchStart":321.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":321.09999990463257,"responseEnd":588.5,"responseStart":588.5,"secureConnectionStart":321.09999990463257},{"duration":405.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/2d8175ec2fa4c816e8023260bd8c1786-CDN/lu2cib/820016/12ta74/494e4c556ecbb29f90a3d3b4f09cb99c/_/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&whisper-enabled=true","startTime":321.30000019073486,"connectEnd":321.30000019073486,"connectStart":321.30000019073486,"domainLookupEnd":321.30000019073486,"domainLookupStart":321.30000019073486,"fetchStart":321.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":321.30000019073486,"responseEnd":726.8000001907349,"responseStart":726.8000001907349,"secureConnectionStart":321.30000019073486},{"duration":409.59999990463257,"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":321.5,"connectEnd":321.5,"connectStart":321.5,"domainLookupEnd":321.5,"domainLookupStart":321.5,"fetchStart":321.5,"redirectEnd":0,"redirectStart":0,"requestStart":321.5,"responseEnd":731.0999999046326,"responseStart":731.0999999046326,"secureConnectionStart":321.5},{"duration":409.90000009536743,"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":321.59999990463257,"connectEnd":321.59999990463257,"connectStart":321.59999990463257,"domainLookupEnd":321.59999990463257,"domainLookupStart":321.59999990463257,"fetchStart":321.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":321.59999990463257,"responseEnd":731.5,"responseStart":731.5,"secureConnectionStart":321.59999990463257},{"duration":410.09999990463257,"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":321.80000019073486,"connectEnd":321.80000019073486,"connectStart":321.80000019073486,"domainLookupEnd":321.80000019073486,"domainLookupStart":321.80000019073486,"fetchStart":321.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":321.80000019073486,"responseEnd":731.9000000953674,"responseStart":731.9000000953674,"secureConnectionStart":321.80000019073486},{"duration":425.90000009536743,"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":322,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":322,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":747.9000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":410.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":322.2000002861023,"connectEnd":322.2000002861023,"connectStart":322.2000002861023,"domainLookupEnd":322.2000002861023,"domainLookupStart":322.2000002861023,"fetchStart":322.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":322.2000002861023,"responseEnd":732.3000001907349,"responseStart":732.3000001907349,"secureConnectionStart":322.2000002861023},{"duration":425.90000009536743,"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":322.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":322.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":748.2000002861023,"responseStart":0,"secureConnectionStart":0},{"duration":409.40000009536743,"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":323.5,"connectEnd":323.5,"connectStart":323.5,"domainLookupEnd":323.5,"domainLookupStart":323.5,"fetchStart":323.5,"redirectEnd":0,"redirectStart":0,"requestStart":323.5,"responseEnd":732.9000000953674,"responseStart":732.9000000953674,"secureConnectionStart":323.5},{"duration":687.0999999046326,"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":330.2000002861023,"connectEnd":330.2000002861023,"connectStart":330.2000002861023,"domainLookupEnd":330.2000002861023,"domainLookupStart":330.2000002861023,"fetchStart":330.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":330.2000002861023,"responseEnd":1017.3000001907349,"responseStart":1017.3000001907349,"secureConnectionStart":330.2000002861023},{"duration":885.7999997138977,"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":330.2000002861023,"connectEnd":330.2000002861023,"connectStart":330.2000002861023,"domainLookupEnd":330.2000002861023,"domainLookupStart":330.2000002861023,"fetchStart":330.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":330.2000002861023,"responseEnd":1216,"responseStart":1216,"secureConnectionStart":330.2000002861023},{"duration":231.09999990463257,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":787.8000001907349,"connectEnd":787.8000001907349,"connectStart":787.8000001907349,"domainLookupEnd":787.8000001907349,"domainLookupStart":787.8000001907349,"fetchStart":787.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":787.8000001907349,"responseEnd":1018.9000000953674,"responseStart":1018.8000001907349,"secureConnectionStart":787.8000001907349},{"duration":377.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2cib/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&whisper-enabled=true","startTime":1046.9000000953674,"connectEnd":1046.9000000953674,"connectStart":1046.9000000953674,"domainLookupEnd":1046.9000000953674,"domainLookupStart":1046.9000000953674,"fetchStart":1046.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1046.9000000953674,"responseEnd":1424,"responseStart":1424,"secureConnectionStart":1046.9000000953674}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":131,"responseStart":314,"responseEnd":320,"domLoading":319,"domInteractive":1496,"domContentLoadedEventStart":1496,"domContentLoadedEventEnd":1562,"domComplete":2287,"loadEventStart":2287,"loadEventEnd":2288,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1459.8000001907349},{"name":"bigPipe.sidebar-id.end","time":1460.7000002861023},{"name":"bigPipe.activity-panel-pipe-id.start","time":1460.8000001907349},{"name":"bigPipe.activity-panel-pipe-id.end","time":1462.5999999046326},{"name":"activityTabFullyLoaded","time":1580.0999999046326}],"measures":[],"correlationId":"427502095e8307","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":117,"dbReadsTimeInMs":24,"dbConnsTimeInMs":35,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
MDEV-11039 Add new scheduling algorithm for reducing tail latencies
MDEV-23877was filed for documenting the deprecation of the parameter innodb_lock_schedule_algorithm.This ticket will be used for tracking the originally reported corruption that is caused by the setting innodb_lock_schedule_algorithm=VATS. Once the feature is fixed to work correctly, and if it has been demonstrated to improve performance, it can be permanently enabled in a later version. The code does not exist in the current MariaDB 10.6 development branch.