Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
10.2.25 , 10.0(EOL) , 10.1(EOL) , 10.3(EOL) , 10.4(EOL) , 10.5
Environment:
Linux Ubuntu 17.04 but most probably unimportant
Problem found during RQG testing.
The maximum runtime (300s) of the RQG worker threads gets exceeded even though
the worker threads would exit in case this limit is already exceeded and the next query would have to be generated. This lets assume that the worker threads are since some long
timespan within the execution of a statement which has not finished yet.
The processlist shows the following
Id User Host db Command Time State Info Progress
1 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
2 system user NULL Daemon NULL InnoDB purge coordinator NULL 0.000
3 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
4 system user NULL Daemon NULL InnoDB purge worker NULL 0.000
5 system user NULL Daemon NULL InnoDB shutdown handler NULL 0.000
8 root localhost:56266 mysql Sleep 671 NULL 0.000
16 root localhost:56332 test Query 659 preparing for alter table ALTER TABLE t_09 DROP INDEX `Marvão_ftidx1`, ADD FULLTEXT INDEX `MarVão_ftidx1` ( col_text ), LOCK 0.000
17 root localhost:56334 test Query 655 setup ALTER TABLE t_06 ADD FULLTEXT INDEX `Marvão_ftidx1` ( col_text ), LOCK = SHARED /* E_R Thread2 QNO 0.000
18 root localhost:56336 test Query 643 setup ALTER TABLE t_07 ADD FULLTEXT INDEX `MarvãO_ftidx1` ( col_text ), LOCK = SHARED /* E_R Thread3 QNO 0.000
19 root localhost:56340 test Query 659 Unlocking tables ALTER TABLE t_02 DROP INDEX `Marvão_ftidx1`, ADD FULLTEXT INDEX `Marvão_ftidx1` ( col_text ), LOCK 0.000
20 root localhost:56342 test Query 657 Unlocking tables ALTER TABLE t_04 DROP INDEX `Marvão_ftidx1`, ADD FULLTEXT INDEX `Marvão_ftidx1` ( col_text ), LOCK 0.000
21 root localhost:56344 test Query 657 Unlocking tables ALTER TABLE t_05 DROP INDEX `MarVão_ftidx1`, ADD FULLTEXT INDEX `Marvão_ftidx1` ( col_text ), LOCK 0.000
23 root localhost:56348 test Query 659 committing alter table to storage engine ALTER TABLE t_03 DROP INDEX `Marvão_ftidx1`, ADD FULLTEXT INDEX `Marvão_ftidx1` ( col_text ), LOCK 0.000
24 root localhost:56350 test Query 653 Unlocking tables ALTER TABLE t_08 DROP INDEX `MarvãO_ftidx1`, ADD FULLTEXT INDEX `MArvão_ftidx1` ( col_text ), LOCK 0.000
25 root localhost:56352 test Query 659 preparing for alter table ALTER TABLE t_10 DROP INDEX `MArvão_ftidx1`, ADD FULLTEXT INDEX `MarVão_ftidx1` ( col_text ), LOCK 0.000
26 root localhost:56354 test Query 659 committing alter table to storage engine ALTER TABLE t_01 DROP INDEX `MArvão_ftidx1`, ADD FULLTEXT INDEX `Marvão_ftidx1` ( col_text ), LOCK 0.000
114 root localhost NULL Query 0 init SHOW PROCESSLIST 0.000
RQG declares "deadlock" in that case.
The problem reported here might be a sibling of already reported bugs where
server do not react on "mysqladmin ... shutdown" or SIGTERM.
Roughly the same effects was observed on 10.3 too.
In the moment I do not know if the Storage engine InnoDB or the server is guilty.
So please adjust the assignee if necessary.
Matthias Leich
made changes -
2019-05-20 14:29
Field
Original Value
New Value
Attachment
simp_Z.yy
[ 48095
]
Marko Mäkelä
made changes -
2019-05-21 10:32
Fix Version/s
10.1
[ 16100
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Fix Version/s
10.5
[ 23123
]
Affects Version/s
10.0
[ 16000
]
Affects Version/s
10.1
[ 16100
]
Affects Version/s
10.3
[ 22126
]
Affects Version/s
10.4
[ 22408
]
Affects Version/s
10.5
[ 23123
]
Assignee
Thirunarayanan Balathandayuthapani
[ thiru
]
Marko Mäkelä
made changes -
2019-05-21 10:33
Status
Open
[ 1
]
Confirmed
[ 10101
]
Marko Mäkelä
made changes -
2019-05-21 10:33
Summary
Draft: Deadlock when running concurrent DDL/DML
InnoDB hang on DROP FULLTEXT INDEX
Status
Confirmed
[ 10101
]
In Progress
[ 3
]
Matthias Leich
made changes -
2019-09-12 16:36
Attachment
simp_Z.yy
[ 48095
]
Matthias Leich
made changes -
2019-09-12 16:37
Attachment
MDEV-19529.tgz
[ 48949
]
Assignee
Thirunarayanan Balathandayuthapani
[ thiru
]
Marko Mäkelä
[ marko
]
Status
In Progress
[ 3
]
In Review
[ 10002
]
Marko Mäkelä
made changes -
2019-09-17 12:51
Assignee
Marko Mäkelä
[ marko
]
Thirunarayanan Balathandayuthapani
[ thiru
]
Status
In Review
[ 10002
]
Stalled
[ 10000
]
Fix Version/s
10.1.42
[ 23407
]
Fix Version/s
10.2.28
[ 23910
]
Fix Version/s
10.3.19
[ 23908
]
Fix Version/s
10.4.9
[ 23906
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.1
[ 16100
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Resolution
Fixed
[ 1
]
Status
Stalled
[ 10000
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:49
Workflow
MariaDB v3
[ 96834
]
MariaDB v4
[ 156228
]
{"report":{"fcp":1647.0999999046326,"ttfb":372.80000019073486,"pageVisibility":"visible","entityId":76128,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"71555e3d-4330-4a85-9a9b-0a6103d2ac7f","navigationType":0,"readyForUser":1815.5,"redirectCount":0,"resourceLoadedEnd":2152.4000000953674,"resourceLoadedStart":393.2000002861023,"resourceTiming":[{"duration":552.0999999046326,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":393.2000002861023,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":393.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":945.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":552.1999998092651,"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":393.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":393.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":945.5999999046326,"responseStart":0,"secureConnectionStart":0},{"duration":561.0999999046326,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":393.7000002861023,"connectEnd":393.7000002861023,"connectStart":393.7000002861023,"domainLookupEnd":393.7000002861023,"domainLookupStart":393.7000002861023,"fetchStart":393.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":393.7000002861023,"responseEnd":954.8000001907349,"responseStart":954.8000001907349,"secureConnectionStart":393.7000002861023},{"duration":636,"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":393.90000009536743,"connectEnd":393.90000009536743,"connectStart":393.90000009536743,"domainLookupEnd":393.90000009536743,"domainLookupStart":393.90000009536743,"fetchStart":393.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":393.90000009536743,"responseEnd":1029.9000000953674,"responseStart":1029.9000000953674,"secureConnectionStart":393.90000009536743},{"duration":638.9000000953674,"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":394.5,"connectEnd":394.5,"connectStart":394.5,"domainLookupEnd":394.5,"domainLookupStart":394.5,"fetchStart":394.5,"redirectEnd":0,"redirectStart":0,"requestStart":394.5,"responseEnd":1033.4000000953674,"responseStart":1033.4000000953674,"secureConnectionStart":394.5},{"duration":639.1999998092651,"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":394.7000002861023,"connectEnd":394.7000002861023,"connectStart":394.7000002861023,"domainLookupEnd":394.7000002861023,"domainLookupStart":394.7000002861023,"fetchStart":394.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":394.7000002861023,"responseEnd":1033.9000000953674,"responseStart":1033.9000000953674,"secureConnectionStart":394.7000002861023},{"duration":639.4000000953674,"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":394.90000009536743,"connectEnd":394.90000009536743,"connectStart":394.90000009536743,"domainLookupEnd":394.90000009536743,"domainLookupStart":394.90000009536743,"fetchStart":394.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":394.90000009536743,"responseEnd":1034.3000001907349,"responseStart":1034.3000001907349,"secureConnectionStart":394.90000009536743},{"duration":755.2000002861023,"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":395.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":395.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1150.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":640.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":395.30000019073486,"connectEnd":395.30000019073486,"connectStart":395.30000019073486,"domainLookupEnd":395.30000019073486,"domainLookupStart":395.30000019073486,"fetchStart":395.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":395.30000019073486,"responseEnd":1035.5999999046326,"responseStart":1035.5999999046326,"secureConnectionStart":395.30000019073486},{"duration":755.0999999046326,"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":395.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":395.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1150.5,"responseStart":0,"secureConnectionStart":0},{"duration":640.8000001907349,"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":395.59999990463257,"connectEnd":395.59999990463257,"connectStart":395.59999990463257,"domainLookupEnd":395.59999990463257,"domainLookupStart":395.59999990463257,"fetchStart":395.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":395.59999990463257,"responseEnd":1036.4000000953674,"responseStart":1036.4000000953674,"secureConnectionStart":395.59999990463257},{"duration":1755.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":396.7000002861023,"connectEnd":396.7000002861023,"connectStart":396.7000002861023,"domainLookupEnd":396.7000002861023,"domainLookupStart":396.7000002861023,"fetchStart":396.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":396.7000002861023,"responseEnd":2151.800000190735,"responseStart":2151.800000190735,"secureConnectionStart":396.7000002861023},{"duration":1755.6999998092651,"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":396.7000002861023,"connectEnd":396.7000002861023,"connectStart":396.7000002861023,"domainLookupEnd":396.7000002861023,"domainLookupStart":396.7000002861023,"fetchStart":396.7000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":396.7000002861023,"responseEnd":2152.4000000953674,"responseStart":2152.4000000953674,"secureConnectionStart":396.7000002861023},{"duration":658.6999998092651,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1176.2000002861023,"connectEnd":1176.2000002861023,"connectStart":1176.2000002861023,"domainLookupEnd":1176.2000002861023,"domainLookupStart":1176.2000002861023,"fetchStart":1176.2000002861023,"redirectEnd":0,"redirectStart":0,"requestStart":1176.2000002861023,"responseEnd":1834.9000000953674,"responseStart":1834.9000000953674,"secureConnectionStart":1176.2000002861023},{"duration":504.40000009536743,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1693,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1693,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":2197.4000000953674,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":152,"responseStart":373,"responseEnd":378,"domLoading":390,"domInteractive":2217,"domContentLoadedEventStart":2217,"domContentLoadedEventEnd":2267,"domComplete":3127,"loadEventStart":3127,"loadEventEnd":3127,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":2161.300000190735},{"name":"bigPipe.sidebar-id.end","time":2162.0999999046326},{"name":"bigPipe.activity-panel-pipe-id.start","time":2162.2000002861023},{"name":"bigPipe.activity-panel-pipe-id.end","time":2167.4000000953674},{"name":"activityTabFullyLoaded","time":2287.9000000953674}],"measures":[],"correlationId":"e31ee821bcbc57","effectiveType":"4g","downlink":9.5,"rtt":0,"serverDuration":150,"dbReadsTimeInMs":28,"dbConnsTimeInMs":38,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}