We have crash recovery tests, but those mainly target InnoDB. Aria is only involved in 10.4 to the extent that the server with Aria system tables starts after the crash.
We'll run similar tests but with Aria tables instead of InnoDB. Data creation needs to be adjusted, pre-crash DML can remain basically the same, after-recovery checks might need to be adjusted, post-crash DML/DDL can remain the same.
The tests are to be run in Travis regularly (daily at first, weekly after GA) along with other various tests.
Tests are being run regularly and are mostly saturated due to the amount of existing bugs (see MDEV-19813 for more details).
Elena Stepanova
added a comment - Tests are being run regularly and are mostly saturated due to the amount of existing bugs (see MDEV-19813 for more details).
CrashRestart reporter didn't work well, switched to CrashUpgrade scenario (same basedir), adjusted configuration, added runs with encryption and group commit.
Elena Stepanova
added a comment - CrashRestart reporter didn't work well, switched to CrashUpgrade scenario (same basedir), adjusted configuration, added runs with encryption and group commit.
Elena Stepanova
added a comment - - edited Added a first small set of tests:
- --grammar=conf/mariadb/oltp-transactional.yy --gendata=conf/mariadb/oltp-aria.zz
- --grammar=conf/mariadb/oltp.yy --gendata=conf/mariadb/oltp-aria.zz
- --grammar=conf/mariadb/generic-dml.yy --gendata=conf/mariadb/oltp-aria.zz
- --grammar=conf/engines/engine_stress.yy --gendata=conf/engines/engine_stress.zz --engine=Aria
each in 3 variations:
- as is
- --gendata-advanced --vcols --default-storage-engine=Aria
- --mysqld=--log_bin_trust_function_creators=1 --mysqld=--log-bin
all with CrashRestart reporter.
Also need to add encrypted version.
People
Elena Stepanova
Elena Stepanova
Votes:
0Vote for this issue
Watchers:
2Start watching this issue
Dates
Created:
Updated:
Resolved:
Git Integration
Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.
{"report":{"fcp":1222,"ttfb":585.6999998092651,"pageVisibility":"visible","entityId":71144,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"555d0ab5-dbbe-4faa-89c2-5efbf2ab355a","navigationType":0,"readyForUser":1289.5999999046326,"redirectCount":0,"resourceLoadedEnd":1625.8999996185303,"resourceLoadedStart":591.3999996185303,"resourceTiming":[{"duration":122.60000038146973,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":591.3999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":591.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714,"responseStart":0,"secureConnectionStart":0},{"duration":122.59999990463257,"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":591.6999998092651,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":591.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":714.2999997138977,"responseStart":0,"secureConnectionStart":0},{"duration":176.80000019073486,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":591.8999996185303,"connectEnd":591.8999996185303,"connectStart":591.8999996185303,"domainLookupEnd":591.8999996185303,"domainLookupStart":591.8999996185303,"fetchStart":591.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":591.8999996185303,"responseEnd":768.6999998092651,"responseStart":768.6999998092651,"secureConnectionStart":591.8999996185303},{"duration":242.09999990463257,"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":592.0999999046326,"connectEnd":592.0999999046326,"connectStart":592.0999999046326,"domainLookupEnd":592.0999999046326,"domainLookupStart":592.0999999046326,"fetchStart":592.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":592.0999999046326,"responseEnd":834.1999998092651,"responseStart":834.1999998092651,"secureConnectionStart":592.0999999046326},{"duration":245.60000038146973,"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":592.3999996185303,"connectEnd":592.3999996185303,"connectStart":592.3999996185303,"domainLookupEnd":592.3999996185303,"domainLookupStart":592.3999996185303,"fetchStart":592.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":592.3999996185303,"responseEnd":838,"responseStart":838,"secureConnectionStart":592.3999996185303},{"duration":245.7999997138977,"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":592.5999999046326,"connectEnd":592.5999999046326,"connectStart":592.5999999046326,"domainLookupEnd":592.5999999046326,"domainLookupStart":592.5999999046326,"fetchStart":592.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":592.5999999046326,"responseEnd":838.3999996185303,"responseStart":838.3999996185303,"secureConnectionStart":592.5999999046326},{"duration":246.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":592.6999998092651,"connectEnd":592.6999998092651,"connectStart":592.6999998092651,"domainLookupEnd":592.6999998092651,"domainLookupStart":592.6999998092651,"fetchStart":592.6999998092651,"redirectEnd":0,"redirectStart":0,"requestStart":592.6999998092651,"responseEnd":838.7999997138977,"responseStart":838.7999997138977,"secureConnectionStart":592.6999998092651},{"duration":317.80000019073486,"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":592.8999996185303,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":592.8999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":910.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":246.2999997138977,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":593,"connectEnd":593,"connectStart":593,"domainLookupEnd":593,"domainLookupStart":593,"fetchStart":593,"redirectEnd":0,"redirectStart":0,"requestStart":593,"responseEnd":839.2999997138977,"responseStart":839.2999997138977,"secureConnectionStart":593},{"duration":317.7000002861023,"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":593.2999997138977,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":593.2999997138977,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":911,"responseStart":0,"secureConnectionStart":0},{"duration":246.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":593.3999996185303,"connectEnd":593.3999996185303,"connectStart":593.3999996185303,"domainLookupEnd":593.3999996185303,"domainLookupStart":593.3999996185303,"fetchStart":593.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":593.3999996185303,"responseEnd":839.7999997138977,"responseStart":839.7999997138977,"secureConnectionStart":593.3999996185303},{"duration":816.5,"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":594.3999996185303,"connectEnd":594.3999996185303,"connectStart":594.3999996185303,"domainLookupEnd":594.3999996185303,"domainLookupStart":594.3999996185303,"fetchStart":594.3999996185303,"redirectEnd":0,"redirectStart":0,"requestStart":594.3999996185303,"responseEnd":1410.8999996185303,"responseStart":1410.8999996185303,"secureConnectionStart":594.3999996185303},{"duration":1031.3999996185303,"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":594.5,"connectEnd":594.5,"connectStart":594.5,"domainLookupEnd":594.5,"domainLookupStart":594.5,"fetchStart":594.5,"redirectEnd":0,"redirectStart":0,"requestStart":594.5,"responseEnd":1625.8999996185303,"responseStart":1625.8999996185303,"secureConnectionStart":594.5},{"duration":493.90000009536743,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":921.5999999046326,"connectEnd":921.5999999046326,"connectStart":921.5999999046326,"domainLookupEnd":921.5999999046326,"domainLookupStart":921.5999999046326,"fetchStart":921.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":921.5999999046326,"responseEnd":1415.5,"responseStart":1415.5,"secureConnectionStart":921.5999999046326}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":431,"responseStart":586,"responseEnd":589,"domLoading":590,"domInteractive":1651,"domContentLoadedEventStart":1651,"domContentLoadedEventEnd":1691,"domComplete":3682,"loadEventStart":3682,"loadEventEnd":3683,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1630.1999998092651},{"name":"bigPipe.sidebar-id.end","time":1630.8999996185303},{"name":"bigPipe.activity-panel-pipe-id.start","time":1631.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1632.5999999046326},{"name":"activityTabFullyLoaded","time":1704.1999998092651}],"measures":[],"correlationId":"38198b438b5478","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":101,"dbReadsTimeInMs":15,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Task
Critical
MDEV-17912
Aria with encryption fails upon crash recovery: Redo phase failed, "Got error 192"
MDEV-17913 Encrypted transactional Aria tables remain corrupt after crash recovery, automatic repairment does not work
Tests are being run regularly and are mostly saturated due to the amount of existing bugs (see MDEV-19813 for more details).