Type:
Bug
Priority:
Major
Resolution:
Duplicate
Affects Version/s:
10.4.11 , 10.1(EOL) , 10.2(EOL) , 10.3(EOL) , 10.4(EOL)
Environment:
Tested on Arch Linux and Ubuntu 18.04 with MariaDB repo
After importing a tablespace (created with mariabackup --prepare --export or FLUSH TABLE ... FOR EXPORT ), if the server is restarted before writing to the new table, reading the table crashes the server.
Started with empty datadir, nothing set in my.cnf.
mariadb> create database test;
Query OK, 1 row affected (0.001 sec)
mariadb> create database test2;
Query OK, 1 row affected (0.000 sec)
mariadb> create table test.foo(id int not null primary key);
Query OK, 0 rows affected (0.185 sec)
mariadb> create table test2.foo(id int not null primary key);
Query OK, 0 rows affected (0.143 sec)
mariadb> insert into test.foo values (1);
Query OK, 1 row affected (0.031 sec)
mariadb> alter table test2.foo discard tablespace;
Query OK, 0 rows affected (0.045 sec)
mariadb> flush table test.foo for export;
Query OK, 0 rows affected (0.001 sec)
-- Copy test/foo.cfg and test/foo.ibd to test2/
mariadb> unlock tables;
Query OK, 0 rows affected (0.000 sec)
mariadb> alter table test2.foo import tablespace;
Query OK, 0 rows affected (0.200 sec)
mariadb> select * from test2.foo;
+----+
| id |
+----+
| 1 |
+----+
1 row in set (0.001 sec)
mariadb> exit
-- Restart MariaDB server
mariadb> select * from test2.foo;
ERROR 2013 (HY000): Lost connection to MySQL server during query
The server log (attached) shows:
2019-12-30 9:12:54 0 [Note] /usr/bin/mysqld: ready for connections.
Version: '10.4.11-MariaDB' socket: '/run/mysqld/mysqld.sock' port: 3306 Arch Linux
2019-12-30 09:13:02 0x7f91f41ae700 InnoDB: Assertion failure in file /build/mariadb/src/mariadb-10.4.11/storage/innobase/btr/btr0btr.cc line 204
InnoDB: Failing assertion: mach_read_from_4(seg_header + FSEG_HDR_SPACE) == space
It seems like doing any write to the new table prevents the issue.
Alice Sherepa
made changes -
2020-01-07 13:56
Affects Version/s
10.2
[ 14601
]
Affects Version/s
10.3
[ 22126
]
Affects Version/s
10.4
[ 22408
]
Alice Sherepa
made changes -
2020-01-07 13:56
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Alice Sherepa
made changes -
2020-01-07 14:30
Assignee
Marko Mäkelä
[ marko
]
Alice Sherepa
made changes -
2020-01-07 14:30
Status
Open
[ 1
]
Confirmed
[ 10101
]
Alice Sherepa
made changes -
2020-01-08 11:30
Affects Version/s
10.1
[ 16100
]
Alice Sherepa
made changes -
2020-01-08 11:31
Fix Version/s
10.1
[ 16100
]
Marko Mäkelä
made changes -
2020-01-21 17:17
Assignee
Marko Mäkelä
[ marko
]
Eugene Kosov
[ kevg
]
Marko Mäkelä
made changes -
2020-04-15 12:08
issue.field.resolutiondate
2020-04-15 12:08:00.0
2020-04-15 12:08:00.704
Marko Mäkelä
made changes -
2020-04-15 12:08
Fix Version/s
10.1.45
[ 23913
]
Fix Version/s
10.2.32
[ 24221
]
Fix Version/s
10.3.23
[ 24222
]
Fix Version/s
10.5.3
[ 24263
]
Fix Version/s
10.2
[ 14601
]
Fix Version/s
10.1
[ 16100
]
Fix Version/s
10.3
[ 22126
]
Fix Version/s
10.4
[ 22408
]
Assignee
Eugene Kosov
[ kevg
]
Marko Mäkelä
[ marko
]
Resolution
Duplicate
[ 3
]
Status
Confirmed
[ 10101
]
Closed
[ 6
]
Sergei Golubchik
made changes -
2021-12-06 21:50
Workflow
MariaDB v3
[ 102702
]
MariaDB v4
[ 157154
]
{"report":{"fcp":1058.8000000715256,"ttfb":302.89999997615814,"pageVisibility":"visible","entityId":82001,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"cea852b3-c8ff-4d76-9e3c-26f3d6d0088a","navigationType":0,"readyForUser":1149.3999999761581,"redirectCount":0,"resourceLoadedEnd":1442.3999999761581,"resourceLoadedStart":308.39999997615814,"resourceTiming":[{"duration":264.60000002384186,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":308.39999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":573,"responseStart":0,"secureConnectionStart":0},{"duration":264.7000000476837,"initiatorType":"link","name":"https://jira.mariadb.org/s/7ebd35e77e471bc30ff0eba799ebc151-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":308.60000002384186,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":308.60000002384186,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":573.3000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":276.89999997615814,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":308.8000000715256,"connectEnd":308.8000000715256,"connectStart":308.8000000715256,"domainLookupEnd":308.8000000715256,"domainLookupStart":308.8000000715256,"fetchStart":308.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":308.8000000715256,"responseEnd":585.7000000476837,"responseStart":585.7000000476837,"secureConnectionStart":308.8000000715256},{"duration":345.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/099b33461394b8015fc36c0a4b96e19f-CDN/lu2bu7/820016/12ta74/8679b4946efa1a0bb029a3a22206fb5d/_/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":309,"connectEnd":309,"connectStart":309,"domainLookupEnd":309,"domainLookupStart":309,"fetchStart":309,"redirectEnd":0,"redirectStart":0,"requestStart":309,"responseEnd":654.6000000238419,"responseStart":654.6000000238419,"secureConnectionStart":309},{"duration":349.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/94c15bff32baef80f4096a08aceae8bc-CDN/lu2bu7/820016/12ta74/c92c0caa9a024ae85b0ebdbed7fb4bd7/_/download/contextbatch/js/atl.global,-_super/batch.js?locale=en","startTime":309.3000000715256,"connectEnd":309.3000000715256,"connectStart":309.3000000715256,"domainLookupEnd":309.3000000715256,"domainLookupStart":309.3000000715256,"fetchStart":309.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":309.3000000715256,"responseEnd":658.3999999761581,"responseStart":658.3999999761581,"secureConnectionStart":309.3000000715256},{"duration":349.60000002384186,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-en/jira.webresources:calendar-en.js","startTime":309.5,"connectEnd":309.5,"connectStart":309.5,"domainLookupEnd":309.5,"domainLookupStart":309.5,"fetchStart":309.5,"redirectEnd":0,"redirectStart":0,"requestStart":309.5,"responseEnd":659.1000000238419,"responseStart":659.1000000238419,"secureConnectionStart":309.5},{"duration":349.6999999284744,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:calendar-localisation-moment/jira.webresources:calendar-localisation-moment.js","startTime":309.7000000476837,"connectEnd":309.7000000476837,"connectStart":309.7000000476837,"domainLookupEnd":309.7000000476837,"domainLookupStart":309.7000000476837,"fetchStart":309.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":309.7000000476837,"responseEnd":659.3999999761581,"responseStart":659.3000000715256,"secureConnectionStart":309.7000000476837},{"duration":417.90000009536743,"initiatorType":"link","name":"https://jira.mariadb.org/s/b04b06a02d1959df322d9cded3aeecc1-CDN/lu2bu7/820016/12ta74/a2ff6aa845ffc9a1d22fe23d9ee791fc/_/download/contextbatch/css/jira.global.look-and-feel,-_super/batch.css","startTime":309.89999997615814,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":309.89999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":727.8000000715256,"responseStart":0,"secureConnectionStart":0},{"duration":349.8000000715256,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":310,"connectEnd":310,"connectStart":310,"domainLookupEnd":310,"domainLookupStart":310,"fetchStart":310,"redirectEnd":0,"redirectStart":0,"requestStart":310,"responseEnd":659.8000000715256,"responseStart":659.8000000715256,"secureConnectionStart":310},{"duration":417.6999999284744,"initiatorType":"link","name":"https://jira.mariadb.org/s/3ac36323ba5e4eb0af2aa7ac7211b4bb-CDN/lu2bu7/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":310.2000000476837,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":310.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":727.8999999761581,"responseStart":0,"secureConnectionStart":0},{"duration":350,"initiatorType":"script","name":"https://jira.mariadb.org/s/3339d87fa2538a859872f2df449bf8d0-CDN/lu2bu7/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":310.3000000715256,"connectEnd":310.3000000715256,"connectStart":310.3000000715256,"domainLookupEnd":310.3000000715256,"domainLookupStart":310.3000000715256,"fetchStart":310.3000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":310.3000000715256,"responseEnd":660.3000000715256,"responseStart":660.3000000715256,"secureConnectionStart":310.3000000715256},{"duration":601.9000000953674,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-js/jira.webresources:bigpipe-js.js","startTime":311.39999997615814,"connectEnd":311.39999997615814,"connectStart":311.39999997615814,"domainLookupEnd":311.39999997615814,"domainLookupStart":311.39999997615814,"fetchStart":311.39999997615814,"redirectEnd":0,"redirectStart":0,"requestStart":311.39999997615814,"responseEnd":913.3000000715256,"responseStart":913.3000000715256,"secureConnectionStart":311.39999997615814},{"duration":1110.3999999761581,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/820016/12ta74/1.0/_/download/batch/jira.webresources:bigpipe-init/jira.webresources:bigpipe-init.js","startTime":316.2000000476837,"connectEnd":316.2000000476837,"connectStart":316.2000000476837,"domainLookupEnd":316.2000000476837,"domainLookupStart":316.2000000476837,"fetchStart":316.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":316.2000000476837,"responseEnd":1426.6000000238419,"responseStart":1426.6000000238419,"secureConnectionStart":316.2000000476837},{"duration":186.70000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":739.5,"connectEnd":739.5,"connectStart":739.5,"domainLookupEnd":739.5,"domainLookupStart":739.5,"fetchStart":739.5,"redirectEnd":0,"redirectStart":0,"requestStart":739.5,"responseEnd":926.2000000476837,"responseStart":926.2000000476837,"secureConnectionStart":739.5},{"duration":427.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/d41d8cd98f00b204e9800998ecf8427e-CDN/lu2bu7/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":1014.8000000715256,"connectEnd":1014.8000000715256,"connectStart":1014.8000000715256,"domainLookupEnd":1014.8000000715256,"domainLookupStart":1014.8000000715256,"fetchStart":1014.8000000715256,"redirectEnd":0,"redirectStart":0,"requestStart":1014.8000000715256,"responseEnd":1442.3999999761581,"responseStart":1442.3999999761581,"secureConnectionStart":1014.8000000715256},{"duration":405.89999997615814,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1052.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1052.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1458.3999999761581,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":68,"responseStart":303,"responseEnd":308,"domLoading":306,"domInteractive":1460,"domContentLoadedEventStart":1460,"domContentLoadedEventEnd":1508,"domComplete":2192,"loadEventStart":2192,"loadEventEnd":2192,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1428.6000000238419},{"name":"bigPipe.sidebar-id.end","time":1429.5},{"name":"bigPipe.activity-panel-pipe-id.start","time":1429.6000000238419},{"name":"bigPipe.activity-panel-pipe-id.end","time":1434.1000000238419},{"name":"activityTabFullyLoaded","time":1526.3999999761581}],"measures":[],"correlationId":"cd5b42c20e0d38","effectiveType":"4g","downlink":9.3,"rtt":0,"serverDuration":166,"dbReadsTimeInMs":35,"dbConnsTimeInMs":45,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}