2015-09-20 1:45:55 140516505151232 [Note] InnoDB: Creating #1 thread id 140515701946112 total threads 5.
|
2015-09-20 1:45:55 140515676768000 [ERROR] InnoDB: Corruption: Block space_id 45 != page space_id 0 or Block offset 1 != page offset 0
|
2015-09-20 01:45:55 7fcc5affc700 InnoDB: Assertion failure in thread 140515676768000 in file buf0buf.cc line 2551
|
InnoDB: Failing assertion: block->page.space == page_get_space_id(page_align(ptr))
|
InnoDB: We intentionally generate a memory trap.
|
#5 0x00007f73f7e243e0 in *__GI_abort () at abort.c:92
|
#6 0x00007f73fad431a0 in buf_block_align_instance (buf_pool=0x7f73f766b078, ptr=0x7f73e3b28000 "") at 10.1/storage/xtradb/buf/buf0buf.cc:2550
|
#7 0x00007f73fad4325b in buf_block_align (ptr=0x7f73e3b28000 "") at 10.1/storage/xtradb/buf/buf0buf.cc:2583
|
#8 0x00007f73fabdf4df in mtr_memo_contains_page (mtr=0x7f73c9bfcf70, ptr=0x7f73e3b28000 "", type=2) at 10.1/storage/xtradb/mtr/mtr0mtr.cc:424
|
#9 0x00007f73fab97dce in ibuf_bitmap_page_get_bits_low (page=0x7f73e3b28000 "", page_no=2, zip_size=0, latch_type=2, mtr=0x7f73c9bfcf70, bit=2) at 10.1/storage/xtradb/ibuf/ibuf0ibuf.cc:768
|
#10 0x00007f73fab9f967 in ibuf_merge_or_delete_for_page (block=0x7f73dbfc0d40, space=45, page_no=2, zip_size=0, update_ibuf_bitmap=1) at 10.1/storage/xtradb/ibuf/ibuf0ibuf.cc:4686
|
#11 0x00007f73fad481c4 in buf_page_io_complete (bpage=0x7f73dbfc0d40) at 10.1/storage/xtradb/buf/buf0buf.cc:4779
|
#12 0x00007f73fad6610b in buf_read_page_low (err=0x7f73c9bfd60c, sync=true, mode=132, space=45, zip_size=0, unzip=0, tablespace_version=8, offset=2, trx=0x0, rbpage=0x7f73c9bfd688) at 10.1/storage/xtradb/buf/buf0rea.cc:262
|
#13 0x00007f73fad6659b in buf_read_page (space=45, zip_size=0, offset=2, trx=0x0, bpage=0x7f73c9bfd688) at 10.1/storage/xtradb/buf/buf0rea.cc:474
|
#14 0x00007f73fad43b89 in buf_page_get_gen (space=45, zip_size=0, offset=2, rw_latch=2, guess=0x0, mode=16, file=0x7f73fb299b90 "10.1/storage/xtradb/fil/fil0crypt.cc", line=1863, mtr=0x7f73c9bfd860, err=0x0) at 10.1/storage/xtradb/buf/buf0buf.cc:2895
|
#15 0x00007f73fadc6fec in fil_crypt_get_page_throttle_func (state=0x7f73c9bfddc0, space=45, zip_size=0, offset=2, mtr=0x7f73c9bfd860, sleeptime_ms=0x7f73c9bfd818, file=0x7f73fb299b90 "10.1/storage/xtradb/fil/fil0crypt.cc", line=1863) at 10.1/storage/xtradb/fil/fil0crypt.cc:1748
|
#16 0x00007f73fadc738a in fil_crypt_rotate_page (key_state=0x7f73c9bfddb0, state=0x7f73c9bfddc0) at 10.1/storage/xtradb/fil/fil0crypt.cc:1860
|
#17 0x00007f73fadc78ff in fil_crypt_rotate_pages (key_state=0x7f73c9bfddb0, state=0x7f73c9bfddc0) at 10.1/storage/xtradb/fil/fil0crypt.cc:2027
|
#18 0x00007f73fadc8044 in fil_crypt_thread (arg=0x0) at 10.1/storage/xtradb/fil/fil0crypt.cc:2250
|
#19 0x00007f73f9e35b50 in start_thread (arg=<optimized out>) at pthread_create.c:304
|
#20 0x00007f73f7eca95d in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112
|
MDEV-8817 and MDEV-8819 can appear interchangeably on the test flow from MDEV-8817.
The test for MDEV-8819 is very similar to MDEV-8817, with slight differences, which hopefully make MDEV-8817 be triggered less (or never), and thus the probability of MDEV-8819 will increase.
RQG command line
|
perl runall-new.pl --threads=2 --duration=600 --queries=100M --redefine=mdev8819-redefine.yy --restart-timeout=30 --validators=none --mysqld=--log_output=FILE --mysqld=--plugin_load_add=file_key_management.so --mysqld=--file_key_management_filename=$BASEDIR/mysql-test/std_data/keys.txt --reporters=QueryTimeout,Backtrace,ErrorLog,Deadlock,CrashRestart --grammar=mdev8819.yy --gendata=mdev8819.zz --engine=InnoDB --basedir=$BASEDIR --vardir=<your vardir>
|
Use RQG from lp:~elenst/randgen/mariadb-patches.
mdev8819.yy, mdev8819-redefine.yy and mdev8819.zz are attached.
The test can also trigger MDEV-8821.
- relates to
-
MDEV-14140
IMPORT TABLESPACE must not go beyond FSP_FREE_LIMIT
-
-
Closed
{"report":{"fcp":845.8000000119209,"ttfb":235,"pageVisibility":"visible","entityId":53259,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"69adb2e0-485f-4608-8619-e5eedbec3292","navigationType":0,"readyForUser":924.1999999880791,"redirectCount":0,"resourceLoadedEnd":803.8000000119209,"resourceLoadedStart":261.19999998807907,"resourceTiming":[{"duration":124.90000000596046,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":261.19999998807907,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.19999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":386.09999999403954,"responseStart":0,"secureConnectionStart":0},{"duration":124.90000000596046,"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":261.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":261.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":386.40000000596046,"responseStart":0,"secureConnectionStart":0},{"duration":133.5,"initiatorType":"script","name":"https://jira.mariadb.org/s/e9b27a47da5fb0f74a35acd57e9847fb-CDN/lu2bv2/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":261.69999998807907,"connectEnd":261.69999998807907,"connectStart":261.69999998807907,"domainLookupEnd":261.69999998807907,"domainLookupStart":261.69999998807907,"fetchStart":261.69999998807907,"redirectEnd":0,"redirectStart":0,"requestStart":261.69999998807907,"responseEnd":395.19999998807907,"responseStart":395.19999998807907,"secureConnectionStart":261.69999998807907},{"duration":191.5,"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":261.80000001192093,"connectEnd":261.80000001192093,"connectStart":261.80000001192093,"domainLookupEnd":261.80000001192093,"domainLookupStart":261.80000001192093,"fetchStart":261.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":261.80000001192093,"responseEnd":453.30000001192093,"responseStart":453.30000001192093,"secureConnectionStart":261.80000001192093},{"duration":194.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":262.09999999403954,"connectEnd":262.09999999403954,"connectStart":262.09999999403954,"domainLookupEnd":262.09999999403954,"domainLookupStart":262.09999999403954,"fetchStart":262.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":262.09999999403954,"responseEnd":456.80000001192093,"responseStart":456.80000001192093,"secureConnectionStart":262.09999999403954},{"duration":195,"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":262.30000001192093,"connectEnd":262.30000001192093,"connectStart":262.30000001192093,"domainLookupEnd":262.30000001192093,"domainLookupStart":262.30000001192093,"fetchStart":262.30000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":262.30000001192093,"responseEnd":457.30000001192093,"responseStart":457.30000001192093,"secureConnectionStart":262.30000001192093},{"duration":195.09999999403954,"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":262.5,"connectEnd":262.5,"connectStart":262.5,"domainLookupEnd":262.5,"domainLookupStart":262.5,"fetchStart":262.5,"redirectEnd":0,"redirectStart":0,"requestStart":262.5,"responseEnd":457.59999999403954,"responseStart":457.59999999403954,"secureConnectionStart":262.5},{"duration":273.5,"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":262.59999999403954,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.59999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":536.0999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":195.19999998807907,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":262.80000001192093,"connectEnd":262.80000001192093,"connectStart":262.80000001192093,"domainLookupEnd":262.80000001192093,"domainLookupStart":262.80000001192093,"fetchStart":262.80000001192093,"redirectEnd":0,"redirectStart":0,"requestStart":262.80000001192093,"responseEnd":458,"responseStart":458,"secureConnectionStart":262.80000001192093},{"duration":273.40000000596046,"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":262.90000000596046,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":262.90000000596046,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":536.3000000119209,"responseStart":0,"secureConnectionStart":0},{"duration":195.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":263.09999999403954,"connectEnd":263.09999999403954,"connectStart":263.09999999403954,"domainLookupEnd":263.09999999403954,"domainLookupStart":263.09999999403954,"fetchStart":263.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":263.09999999403954,"responseEnd":458.59999999403954,"responseStart":458.59999999403954,"secureConnectionStart":263.09999999403954},{"duration":320.09999999403954,"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":264,"connectEnd":264,"connectStart":264,"domainLookupEnd":264,"domainLookupStart":264,"fetchStart":264,"redirectEnd":0,"redirectStart":0,"requestStart":264,"responseEnd":584.0999999940395,"responseStart":584.0999999940395,"secureConnectionStart":264},{"duration":446.40000000596046,"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":264.09999999403954,"connectEnd":264.09999999403954,"connectStart":264.09999999403954,"domainLookupEnd":264.09999999403954,"domainLookupStart":264.09999999403954,"fetchStart":264.09999999403954,"redirectEnd":0,"redirectStart":0,"requestStart":264.09999999403954,"responseEnd":710.5,"responseStart":710.5,"secureConnectionStart":264.09999999403954},{"duration":37.19999998807907,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":547.4000000059605,"connectEnd":547.4000000059605,"connectStart":547.4000000059605,"domainLookupEnd":547.4000000059605,"domainLookupStart":547.4000000059605,"fetchStart":547.4000000059605,"redirectEnd":0,"redirectStart":0,"requestStart":547.4000000059605,"responseEnd":584.5999999940395,"responseStart":584.5999999940395,"secureConnectionStart":547.4000000059605},{"duration":201.90000000596046,"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":601.6999999880791,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":601.6999999880791,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":803.5999999940395,"responseStart":0,"secureConnectionStart":0},{"duration":201.5,"initiatorType":"link","name":"https://jira.mariadb.org/s/50bc9be5bfead1a25e72c1a9338c94f6-CDN/lu2bv2/820016/12ta74/e108c7645258ccb43280ed3404e3e949/_/download/contextbatch/css/com.atlassian.jira.plugins.jira-development-integration-plugin:0,-_super,-jira.view.issue,-jira.global,-jira.general,-jira.browse.project,-project.issue.navigator,-atl.general/batch.css?agile_global_admin_condition=true&jag=true&jira.create.linked.issue=true&slack-enabled=true","startTime":602.3000000119209,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":602.3000000119209,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":803.8000000119209,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":77,"responseStart":235,"responseEnd":236,"domLoading":258,"domInteractive":1012,"domContentLoadedEventStart":1012,"domContentLoadedEventEnd":1057,"domComplete":1323,"loadEventStart":1323,"loadEventEnd":1324,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":958.3000000119209},{"name":"bigPipe.sidebar-id.end","time":959},{"name":"bigPipe.activity-panel-pipe-id.start","time":959.1999999880791},{"name":"bigPipe.activity-panel-pipe-id.end","time":960.3000000119209},{"name":"activityTabFullyLoaded","time":1075.0999999940395}],"measures":[],"correlationId":"828a586d0c14d2","effectiveType":"4g","downlink":9,"rtt":0,"serverDuration":98,"dbReadsTimeInMs":15,"dbConnsTimeInMs":24,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Hmm, totally empty page in buf_block_align_instance, do not yet understand this one.