Use one of the below test cases few times:
2015-05-20 20:36:29 7ffa58ff9700 InnoDB: Error: trying to access tablespace 11262 page no. 7,
|
InnoDB: but the tablespace does not exist or is just being dropped.
|
InnoDB: Error: Unable to read tablespace 11262 page no 7 into the buffer pool after 100 attempts
|
InnoDB: The most probable cause of this error may be that the table has been corrupted.
|
InnoDB: You can try to fix this problem by using innodb_force_recovery.
|
InnoDB: Please see reference manual for more details.
|
InnoDB: Aborting...
|
2015-05-20 20:36:29 7ffa58ff9700 InnoDB: Assertion failure in thread 140713211696896 in file buf0buf.cc line 2817
|
|
#0 0x00007ffa93329621 in __pthread_kill (threadid=<optimized out>, signo=6) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:61
|
#1 0x00007ffa95b6909a in my_write_core (sig=6) at /home/jan/mysql/10.1-encryption/mysys/stacktrace.c:456
|
#2 0x00007ffa9551609e in handle_fatal_signal (sig=6) at /home/jan/mysql/10.1-encryption/sql/signal_handler.cc:266
|
#3 <signal handler called>
|
#4 0x00007ffa92983cc9 in __GI_raise (sig=sig@entry=6) at ../nptl/sysdeps/unix/sysv/linux/raise.c:56
|
#5 0x00007ffa929870d8 in __GI_abort () at abort.c:89
|
#6 0x00007ffa95a43058 in buf_page_get_gen (space=11262, zip_size=0, offset=7, rw_latch=2, guess=0x0, mode=16, file=0x7ffa95de4180 "/home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc", line=1812, mtr=0x7ffa58ff88b0) at /home/jan/mysql/10.1-encryption/storage/xtradb/buf/buf0buf.cc:2817
|
#7 0x00007ffa95ac2d2d in fil_crypt_get_page_throttle_func (state=0x7ffa58ff8e10, space=11262, zip_size=0, offset=7, mtr=0x7ffa58ff88b0, sleeptime_ms=0x7ffa58ff8868, file=0x7ffa95de4180 "/home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc", line=1812) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:1697
|
#8 0x00007ffa95ac309a in fil_crypt_rotate_page (key_state=0x7ffa58ff8e00, state=0x7ffa58ff8e10) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:1809
|
#9 0x00007ffa95ac35f2 in fil_crypt_rotate_pages (key_state=0x7ffa58ff8e00, state=0x7ffa58ff8e10) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:1970
|
#10 0x00007ffa95ac3d09 in fil_crypt_thread (arg=0x0) at /home/jan/mysql/10.1-encryption/storage/xtradb/fil/fil0crypt.cc:2193
|
#11 0x00007ffa93324182 in start_thread (arg=0x7ffa58ff9700) at pthread_create.c:312
|
#12 0x00007ffa92a4747d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:111
|
|
query:
|
INSERT IGNORE INTO _table ( _field ) VALUES ( _digit ), ( _digit ), ( _digit ), ( _digit ) |
|
DELETE FROM _table WHERE `pk` > _digit LIMIT 4 ;
|
|
thread2:
|
set_encrypt_option |
|
create_or_replace;
|
|
set_encrypt_option:
|
SET GLOBAL innodb_encrypt_tables = enc_tables |
|
SET GLOBAL innodb_encryption_threads = _digit |
|
SET GLOBAL innodb_scrub_log_speed = _smallint_unsigned
|
;
|
|
encrypt_on_off:
|
ON | OFF ;
|
|
enc_tables:
|
ON | OFF | 'FORCE' ;
|
|
create_or_replace:
|
CREATE OR REPLACE TABLE `create_or_replace_t` AS SELECT * FROM _table ;
|
RQG data template enc2.zz
|
$tables = {
|
rows => [0, 1, 10 ],
|
pk => [ 'int auto_increment' ]
|
};
|
|
$fields = {
|
types => [ 'int' ],
|
indexes => [ 'key', undef ]
|
};
|
|
$data = {
|
numbers => [ 'digit', 'null', undef ],
|
strings => [ 'letter', 'english' ],
|
blobs => [ 'data' ],
|
temporals => ['date', 'year', 'null', undef ]
|
}
|
RQG command line (use lp:~elenst/randgen/mariadb-patches):
perl ./runall-new.pl --threads=2 --duration=400 --queries=100M --mysqld=--plugin-load-add=file_key_management.so --mysqld=--file_key_management_filename=<your basedir>/mysql-test/std_data/keys.txt --grammar=enc2.yy --gendata=enc2.zz --mtr-build-thread=73 --basedir1=<your basedir> --vardir1=<your vardir>
|
See MDEV-8171 for instructions how to run the same test several times.
Transition |
Time In Source Status |
Execution Times |
Open |
|
In Progress |
|
1m 30s
|
1
|
In Progress |
|
Closed |
|
18h 40m
|
1
|
{"report":{"fcp":1424.6999998092651,"ttfb":455.90000009536743,"pageVisibility":"visible","entityId":51417,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"ccdb91a9-da34-45c8-9bcf-8f008f9d07ef","navigationType":0,"readyForUser":1527.5999999046326,"redirectCount":0,"resourceLoadedEnd":1850.3000001907349,"resourceLoadedStart":462.30000019073486,"resourceTiming":[{"duration":214.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":462.30000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":462.30000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":676.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":214.09999990463257,"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":462.59999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":462.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":676.6999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":223.09999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":462.80000019073486,"connectEnd":462.80000019073486,"connectStart":462.80000019073486,"domainLookupEnd":462.80000019073486,"domainLookupStart":462.80000019073486,"fetchStart":462.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":462.80000019073486,"responseEnd":685.9000000953674,"responseStart":685.9000000953674,"secureConnectionStart":462.80000019073486},{"duration":621.8000001907349,"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":463,"connectEnd":463,"connectStart":463,"domainLookupEnd":463,"domainLookupStart":463,"fetchStart":463,"redirectEnd":0,"redirectStart":0,"requestStart":463,"responseEnd":1084.8000001907349,"responseStart":1084.8000001907349,"secureConnectionStart":463},{"duration":625.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":463.19999980926514,"connectEnd":463.19999980926514,"connectStart":463.19999980926514,"domainLookupEnd":463.19999980926514,"domainLookupStart":463.19999980926514,"fetchStart":463.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":463.19999980926514,"responseEnd":1089.0999999046326,"responseStart":1089.0999999046326,"secureConnectionStart":463.19999980926514},{"duration":626.0999999046326,"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":463.40000009536743,"connectEnd":463.40000009536743,"connectStart":463.40000009536743,"domainLookupEnd":463.40000009536743,"domainLookupStart":463.40000009536743,"fetchStart":463.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":463.40000009536743,"responseEnd":1089.5,"responseStart":1089.4000000953674,"secureConnectionStart":463.40000009536743},{"duration":626.3000001907349,"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":463.59999990463257,"connectEnd":463.59999990463257,"connectStart":463.59999990463257,"domainLookupEnd":463.59999990463257,"domainLookupStart":463.59999990463257,"fetchStart":463.59999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":463.59999990463257,"responseEnd":1089.9000000953674,"responseStart":1089.9000000953674,"secureConnectionStart":463.59999990463257},{"duration":627.3999996185303,"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":463.80000019073486,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":463.80000019073486,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1091.1999998092651,"responseStart":0,"secureConnectionStart":0},{"duration":626.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":463.90000009536743,"connectEnd":463.90000009536743,"connectStart":463.90000009536743,"domainLookupEnd":463.90000009536743,"domainLookupStart":463.90000009536743,"fetchStart":463.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":463.90000009536743,"responseEnd":1090.4000000953674,"responseStart":1090.4000000953674,"secureConnectionStart":463.90000009536743},{"duration":627.3000001907349,"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":464.09999990463257,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":464.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1091.4000000953674,"responseStart":0,"secureConnectionStart":0},{"duration":626.7000002861023,"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":464.19999980926514,"connectEnd":464.19999980926514,"connectStart":464.19999980926514,"domainLookupEnd":464.19999980926514,"domainLookupStart":464.19999980926514,"fetchStart":464.19999980926514,"redirectEnd":0,"redirectStart":0,"requestStart":464.19999980926514,"responseEnd":1090.9000000953674,"responseStart":1090.9000000953674,"secureConnectionStart":464.19999980926514},{"duration":871.5999999046326,"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":465,"connectEnd":465,"connectStart":465,"domainLookupEnd":465,"domainLookupStart":465,"fetchStart":465,"redirectEnd":0,"redirectStart":0,"requestStart":465,"responseEnd":1336.5999999046326,"responseStart":1336.5999999046326,"secureConnectionStart":465},{"duration":1332.9000000953674,"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":465.09999990463257,"connectEnd":465.09999990463257,"connectStart":465.09999990463257,"domainLookupEnd":465.09999990463257,"domainLookupStart":465.09999990463257,"fetchStart":465.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":465.09999990463257,"responseEnd":1798,"responseStart":1798,"secureConnectionStart":465.09999990463257},{"duration":414.69999980926514,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":839.8000001907349,"connectEnd":839.8000001907349,"connectStart":839.8000001907349,"domainLookupEnd":839.8000001907349,"domainLookupStart":839.8000001907349,"fetchStart":839.8000001907349,"redirectEnd":0,"redirectStart":0,"requestStart":839.8000001907349,"responseEnd":1254.5,"responseStart":1254.5,"secureConnectionStart":839.8000001907349},{"duration":480.7000002861023,"initiatorType":"link","name":"https://jira.mariadb.org/s/d5715adaadd168a9002b108b2b039b50-CDN/lu2cib/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&whisper-enabled=true","startTime":1369.5999999046326,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1369.5999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1850.3000001907349,"responseStart":0,"secureConnectionStart":0},{"duration":477.30000019073486,"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":1371.0999999046326,"connectEnd":1371.0999999046326,"connectStart":1371.0999999046326,"domainLookupEnd":1371.0999999046326,"domainLookupStart":1371.0999999046326,"fetchStart":1371.0999999046326,"redirectEnd":0,"redirectStart":0,"requestStart":1371.0999999046326,"responseEnd":1848.4000000953674,"responseStart":1848.4000000953674,"secureConnectionStart":1371.0999999046326},{"duration":523.6999998092651,"initiatorType":"script","name":"https://jira.mariadb.org/s/097ae97cb8fbec7d6ea4bbb1f26955b9-CDN/lu2cib/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&whisper-enabled=true","startTime":1371.5,"connectEnd":1371.5,"connectStart":1371.5,"domainLookupEnd":1371.5,"domainLookupStart":1371.5,"fetchStart":1371.5,"redirectEnd":0,"redirectStart":0,"requestStart":1371.5,"responseEnd":1895.1999998092651,"responseStart":1895.1999998092651,"secureConnectionStart":1371.5}],"fetchStart":1,"domainLookupStart":1,"domainLookupEnd":1,"connectStart":1,"connectEnd":1,"requestStart":285,"responseStart":456,"responseEnd":460,"domLoading":460,"domInteractive":1859,"domContentLoadedEventStart":1859,"domContentLoadedEventEnd":1904,"domComplete":2479,"loadEventStart":2479,"loadEventEnd":2480,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1838},{"name":"bigPipe.sidebar-id.end","time":1839},{"name":"bigPipe.activity-panel-pipe-id.start","time":1839.1999998092651},{"name":"bigPipe.activity-panel-pipe-id.end","time":1840.3000001907349},{"name":"activityTabFullyLoaded","time":1918.3000001907349}],"measures":[],"correlationId":"f91aefbda6403e","effectiveType":"4g","downlink":9.2,"rtt":0,"serverDuration":104,"dbReadsTimeInMs":20,"dbConnsTimeInMs":31,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}