Type:
Bug
Priority:
Major
Resolution:
Fixed
Affects Version/s:
None
While uploading Mariadb 10.5.13 to Ubuntu 21.10 Impish the following failure in autopkgtests (that runs the mtr among others) was noticed on platform ppc64el:
main.long_unique w1 [ fail ]
Test ended at 2021-12-02 15:01:58
CURRENT_TEST: main.long_unique
mysqltest: At line 409: query 'insert into t1 values(concat(repeat('sachin',10000000),'1'),concat(repeat('sachin',10000000),'1'),
concat(repeat('sachin',10000000),'1'))' failed: 2013: Lost connection to MySQL server during query
The result from queries just before the failure was:
< snip >
Field Type Null Key Default Extra
a longblob YES UNI NULL
b longblob YES MUL NULL
c longblob YES NULL
show create table t1;
Table Create Table
t1 CREATE TABLE `t1` (
`a` longblob DEFAULT NULL,
`b` longblob DEFAULT NULL,
`c` longblob DEFAULT NULL,
UNIQUE KEY `a` (`a`) USING HASH,
UNIQUE KEY `b` (`b`,`c`) USING HASH
) ENGINE=MyISAM DEFAULT CHARSET=latin1
show keys from t1;
Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment
t1 0 a 1 a A NULL NULL NULL YES HASH
t1 0 b 1 b A NULL NULL NULL YES HASH
t1 0 b 2 c A NULL NULL NULL YES HASH
insert into t1 values(concat(repeat('sachin',10000000),'1'),concat(repeat('sachin',10000000),'1'),
concat(repeat('sachin',10000000),'1'));
More results from queries before failure can be found in /tmp/tmp.P0sky4MUVI/var/1/log/long_unique.log
Server [mysqld.1 - pid: 4618, winpid: 4618, exit: 256] failed during test run
Server log from this test:
----------SERVER LOG START-----------
----------SERVER LOG END-------------
For more details please see https://bugs.launchpad.net/ubuntu/+source/mariadb-10.5/+bug/1951709/comments/5
relates to
MDEV-371
Unique indexes for blobs
Closed
{"report":{"fcp":1077.4000000059605,"ttfb":214.5,"pageVisibility":"visible","entityId":105697,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"9bd90339-2b03-43c2-8073-5b9704d0a1a3","navigationType":0,"readyForUser":1154.699999988079,"redirectCount":0,"resourceLoadedEnd":996.6999999880791,"resourceLoadedStart":236.69999998807907,"resourceTiming":[{"duration":294,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":236.69999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":236.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":530.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":292.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":238.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":238.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":531.0999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":347.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":238.80000001192093,"connectEnd":238.80000001192093,"connectStart":238.80000001192093,"domainLookupEnd":238.80000001192093,"domainLookupStart":238.80000001192093,"fetchStart":238.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":238.80000001192093,"responseEnd":586.3000000119209,"responseStart":586.3000000119209,"secureConnectionStart":238.80000001192093},{"duration":388.2999999821186,"initiatorType":"script","name":"https://jira.mariadb.org/s/c32eb0da7ad9831253f8397e6cc26afd-CDN/lu2bv2/820016/12ta74/2380add21a9a1006587582385952de73/_/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":239.40000000596046,"connectEnd":239.40000000596046,"connectStart":239.40000000596046,"domainLookupEnd":239.40000000596046,"domainLookupStart":239.40000000596046,"fetchStart":239.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":239.40000000596046,"responseEnd":627.6999999880791,"responseStart":627.6999999880791,"secureConnectionStart":239.40000000596046},{"duration":391.7000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/s/bc0bcb146314416123c992714ee00ff7-CDN/lu2bv2/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":239.59999999403954,"connectEnd":239.59999999403954,"connectStart":239.59999999403954,"domainLookupEnd":239.59999999403954,"domainLookupStart":239.59999999403954,"fetchStart":239.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":239.59999999403954,"responseEnd":631.3000000119209,"responseStart":631.3000000119209,"secureConnectionStart":239.59999999403954},{"duration":392.2999999821186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":239.80000001192093,"connectEnd":239.80000001192093,"connectStart":239.80000001192093,"domainLookupEnd":239.80000001192093,"domainLookupStart":239.80000001192093,"fetchStart":239.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":239.80000001192093,"responseEnd":632.0999999940395,"responseStart":632.0999999940395,"secureConnectionStart":239.80000001192093},{"duration":392.40000000596046,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":240,"connectEnd":240,"connectStart":240,"domainLookupEnd":240,"domainLookupStart":240,"fetchStart":240,"redirectEnd":0,"redirectStart":0,"requestStart":240,"responseEnd":632.4000000059605,"responseStart":632.4000000059605,"secureConnectionStart":240},{"duration":488.59999999403954,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bv2/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":240.40000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":240.40000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":729,"responseStart":0,"secureConnectionStart":0},{"duration":392.2000000178814,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":240.59999999403954,"connectEnd":240.59999999403954,"connectStart":240.59999999403954,"domainLookupEnd":240.59999999403954,"domainLookupStart":240.59999999403954,"fetchStart":240.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":240.59999999403954,"responseEnd":632.8000000119209,"responseStart":632.8000000119209,"secureConnectionStart":240.59999999403954},{"duration":488.39999997615814,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bv2/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":240.80000001192093,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":240.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":729.1999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":392.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/719848dd97ebe0663199f49a3936487a-CDN/lu2bv2/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":240.90000000596046,"connectEnd":240.90000000596046,"connectStart":240.90000000596046,"domainLookupEnd":240.90000000596046,"domainLookupStart":240.90000000596046,"fetchStart":240.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":240.90000000596046,"responseEnd":633.4000000059605,"responseStart":633.4000000059605,"secureConnectionStart":240.90000000596046},{"duration":449.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":282.59999999403954,"connectEnd":282.59999999403954,"connectStart":282.59999999403954,"domainLookupEnd":282.59999999403954,"domainLookupStart":282.59999999403954,"fetchStart":282.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":282.59999999403954,"responseEnd":732.1999999880791,"responseStart":732.1999999880791,"secureConnectionStart":282.59999999403954},{"duration":439.39999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":296.30000001192093,"connectEnd":296.30000001192093,"connectStart":296.30000001192093,"domainLookupEnd":296.30000001192093,"domainLookupStart":296.30000001192093,"fetchStart":296.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":296.30000001192093,"responseEnd":735.6999999880791,"responseStart":735.6999999880791,"secureConnectionStart":296.30000001192093},{"duration":18.599999994039536,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":757.5999999940395,"connectEnd":757.5999999940395,"connectStart":757.5999999940395,"domainLookupEnd":757.5999999940395,"domainLookupStart":757.5999999940395,"fetchStart":757.5999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":757.5999999940395,"responseEnd":776.1999999880791,"responseStart":776.1999999880791,"secureConnectionStart":757.5999999940395},{"duration":217.09999999403954,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2bv2/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":779.5999999940395,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":779.5999999940395,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":996.6999999880791,"responseStart":0,"secureConnectionStart":0},{"duration":466.59999999403954,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bv2/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","startTime":780.4000000059605,"connectEnd":780.4000000059605,"connectStart":780.4000000059605,"domainLookupEnd":780.4000000059605,"domainLookupStart":780.4000000059605,"fetchStart":780.4000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":780.4000000059605,"responseEnd":1247,"responseStart":1247,"secureConnectionStart":780.4000000059605},{"duration":476.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/s/53a43b6764f587426c7bb9a150184c00-CDN/lu2bv2/820016/12ta74/be4b45e9cec53099498fa61c8b7acba4/_/download/contextbatch/js/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.js?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&locale=en&slack-enabled=true","startTime":780.9000000059605,"connectEnd":780.9000000059605,"connectStart":780.9000000059605,"domainLookupEnd":780.9000000059605,"domainLookupStart":780.9000000059605,"fetchStart":780.9000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":780.9000000059605,"responseEnd":1257.0999999940395,"responseStart":1257.0999999940395,"secureConnectionStart":780.9000000059605},{"duration":181.90000000596046,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1079.199999988079,"connectEnd":1079.199999988079,"connectStart":1079.199999988079,"domainLookupEnd":1079.199999988079,"domainLookupStart":1079.199999988079,"fetchStart":1079.199999988079,"redirectEnd":0,"redirectStart":0,"requestStart":1079.199999988079,"responseEnd":1261.0999999940395,"responseStart":1261.0999999940395,"secureConnectionStart":1079.199999988079}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":32,"responseStart":214,"responseEnd":296,"domLoading":217,"domInteractive":1210,"domContentLoadedEventStart":1210,"domContentLoadedEventEnd":1258,"domComplete":1306,"loadEventStart":1306,"loadEventEnd":1307,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1189.800000011921},{"name":"bigPipe.sidebar-id.end","time":1190.699999988079},{"name":"bigPipe.activity-panel-pipe-id.start","time":1190.699999988079},{"name":"bigPipe.activity-panel-pipe-id.end","time":1192.300000011921},{"name":"activityTabFullyLoaded","time":1272.699999988079}],"measures":[],"correlationId":"d160b39b560d7c","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":93,"dbReadsTimeInMs":10,"dbConnsTimeInMs":18,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Could it be simple exceeding the available memory? We got the following happening on AIX:
10.5 78bd7d86a4a0b3733ba38373213645a6b3a9b9c6
main.long_unique w5 [ fail ]
Test ended at 2021-06-18 00:14:45
CURRENT_TEST: main.long_unique
mysqltest: At line 409: query 'insert into t1 values(concat(repeat('sachin',10000000),'1'),concat(repeat('sachin',10000000),'1'),
concat(repeat('sachin',10000000),'1'))' failed: 1041: Out of memory.
It feels steep to construct a row of two 60,000,001-byte columns, but the purpose of this test section seems to be to test long BLOB values. The storage engine likely is Aria, because one is not being explicitly specified in the test.
The actual memory consumption could be several times the 120MB. And this section of the test will attempt to insert 4 such rows.
Perhaps this part of the test should be moved to a separate test file that would only be run with --big-test.