InnoDB: Assertion failure in thread 70366860931392 in file fil0fil.cc line 475
|
InnoDB: Failing assertion: space
|
Thread 1 (LWP 23827):
|
#0 0x00003fffa2b34de0 in __pthread_kill (threadid=<optimized out>, signo=<optimized out>) at ../sysdeps/unix/sysv/linux/pthread_kill.c:60
|
#1 0x0000000028a786c8 in my_write_core (sig=<optimized out>) at /home/buildbot/maria-slave/power8-vlp03-bintar/build/mysys/stacktrace.c:456
|
#2 0x00000000284a7750 in handle_fatal_signal (sig=<optimized out>) at /home/buildbot/maria-slave/power8-vlp03-bintar/build/sql/signal_handler.cc:266
|
#3 <signal handler called>
|
#4 0x00003fffa2250b60 in __GI_raise (sig=<optimized out>) at ../sysdeps/unix/sysv/linux/raise.c:55
|
#5 0x00003fffa2253404 in __GI_abort () at abort.c:89
|
#6 0x00003fff9ad6bd8c in fil_space_get_type (id=5) at /home/buildbot/maria-slave/power8-vlp03-bintar/build/storage/innobase/fil/fil0fil.cc:475
|
#7 0x00003fff9ad810a8 in fil_crypt_space_needs_rotation (recheck=<optimized out>, key_state=<optimized out>, state=<optimized out>) at /home/buildbot/maria-slave/power8-vlp03-bintar/build/storage/innobase/fil/fil0crypt.cc:1215
|
#8 fil_crypt_find_space_to_rotate (key_state=0x3fff8fbfe0d4, state=0x3fff8fbfe110, recheck=0x3fff8fbfe0c7) at /home/buildbot/maria-slave/power8-vlp03-bintar/build/storage/innobase/fil/fil0crypt.cc:1513
|
#9 0x00003fff9ad8197c in fil_crypt_thread (arg=<optimized out>) at /home/buildbot/maria-slave/power8-vlp03-bintar/build/storage/innobase/fil/fil0crypt.cc:2185
|
#10 0x0000000000000000 in ?? ()
|
{"report":{"fcp":781.2999999523163,"ttfb":198.60000014305115,"pageVisibility":"visible","entityId":52344,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"462a7929-e357-40a6-a43a-d8ccf5beb7bf","navigationType":0,"readyForUser":887.7000000476837,"redirectCount":0,"resourceLoadedEnd":515,"resourceLoadedStart":203.40000009536743,"resourceTiming":[{"duration":4.299999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":203.40000009536743,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":207.70000004768372,"responseStart":0,"secureConnectionStart":0},{"duration":5.200000047683716,"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":203.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":203.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":209,"responseStart":0,"secureConnectionStart":0},{"duration":189.90000009536743,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":207.70000004768372,"connectEnd":207.70000004768372,"connectStart":207.70000004768372,"domainLookupEnd":207.70000004768372,"domainLookupStart":207.70000004768372,"fetchStart":207.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":211.90000009536743,"responseEnd":397.60000014305115,"responseStart":226.40000009536743,"secureConnectionStart":207.70000004768372},{"duration":306.7999999523163,"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":208.20000004768372,"connectEnd":208.20000004768372,"connectStart":208.20000004768372,"domainLookupEnd":208.20000004768372,"domainLookupStart":208.20000004768372,"fetchStart":208.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":212.70000004768372,"responseEnd":515,"responseStart":232,"secureConnectionStart":208.20000004768372},{"duration":26.800000190734863,"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":208.29999995231628,"connectEnd":208.29999995231628,"connectStart":208.29999995231628,"domainLookupEnd":208.29999995231628,"domainLookupStart":208.29999995231628,"fetchStart":208.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":213.70000004768372,"responseEnd":235.10000014305115,"responseStart":230.70000004768372,"secureConnectionStart":208.29999995231628},{"duration":38.39999985694885,"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":208.40000009536743,"connectEnd":208.40000009536743,"connectStart":208.40000009536743,"domainLookupEnd":208.40000009536743,"domainLookupStart":208.40000009536743,"fetchStart":208.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":218.70000004768372,"responseEnd":246.79999995231628,"responseStart":242.90000009536743,"secureConnectionStart":208.40000009536743},{"duration":38.5,"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":208.5,"connectEnd":208.5,"connectStart":208.5,"domainLookupEnd":208.5,"domainLookupStart":208.5,"fetchStart":208.5,"redirectEnd":0,"redirectStart":0,"requestStart":219.10000014305115,"responseEnd":247,"responseStart":243.60000014305115,"secureConnectionStart":208.5},{"duration":7.5,"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":208.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":208.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":216.10000014305115,"responseStart":0,"secureConnectionStart":0},{"duration":38.59999990463257,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":208.70000004768372,"connectEnd":208.70000004768372,"connectStart":208.70000004768372,"domainLookupEnd":208.70000004768372,"domainLookupStart":208.70000004768372,"fetchStart":208.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":219.40000009536743,"responseEnd":247.29999995231628,"responseStart":244.60000014305115,"secureConnectionStart":208.70000004768372},{"duration":8,"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":208.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":208.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":216.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":38.59999990463257,"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":208.90000009536743,"connectEnd":208.90000009536743,"connectStart":208.90000009536743,"domainLookupEnd":208.90000009536743,"domainLookupStart":208.90000009536743,"fetchStart":208.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":220.29999995231628,"responseEnd":247.5,"responseStart":245.5,"secureConnectionStart":208.90000009536743},{"duration":297.7999999523163,"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":211.40000009536743,"connectEnd":211.40000009536743,"connectStart":211.40000009536743,"domainLookupEnd":211.40000009536743,"domainLookupStart":211.40000009536743,"fetchStart":211.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":223,"responseEnd":509.2000000476837,"responseStart":504.2000000476837,"secureConnectionStart":211.40000009536743},{"duration":298,"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":211.40000009536743,"connectEnd":211.40000009536743,"connectStart":211.40000009536743,"domainLookupEnd":211.40000009536743,"domainLookupStart":211.40000009536743,"fetchStart":211.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":224.90000009536743,"responseEnd":509.40000009536743,"responseStart":505,"secureConnectionStart":211.40000009536743},{"duration":87.80000019073486,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":542.7999999523163,"connectEnd":542.7999999523163,"connectStart":542.7999999523163,"domainLookupEnd":542.7999999523163,"domainLookupStart":542.7999999523163,"fetchStart":542.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":596.6000001430511,"responseEnd":630.6000001430511,"responseStart":629.5,"secureConnectionStart":542.7999999523163},{"duration":134.20000004768372,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":773.4000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":773.4000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":907.6000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":173.29999995231628,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":780.2000000476837,"connectEnd":780.2000000476837,"connectStart":780.2000000476837,"domainLookupEnd":780.2000000476837,"domainLookupStart":780.2000000476837,"fetchStart":780.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":912.6000001430511,"responseEnd":953.5,"responseStart":951.5,"secureConnectionStart":780.2000000476837}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":60,"responseStart":199,"responseEnd":211,"domLoading":202,"domInteractive":940,"domContentLoadedEventStart":940,"domContentLoadedEventEnd":982,"domComplete":1322,"loadEventStart":1322,"loadEventEnd":1322,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":920.1000001430511},{"name":"bigPipe.sidebar-id.end","time":921},{"name":"bigPipe.activity-panel-pipe-id.start","time":921.1000001430511},{"name":"bigPipe.activity-panel-pipe-id.end","time":922},{"name":"activityTabFullyLoaded","time":1000.2999999523163}],"measures":[],"correlationId":"3b943d7df304","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":70,"dbReadsTimeInMs":10,"dbConnsTimeInMs":16,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Bug
Major
commit 53623d932a89dd4760fd28db42956b341ac451ed
Author: Jan Lindström <jan.lindstrom@mariadb.com>
Date: Wed Jul 22 08:42:52 2015 +0300
MDEV-8522: InnoDB: Assertion failure in file fil0fil.cc line 475Analysis: In fil_crypt_space_needs_rotation we first make sure that
tablespace is found and then separately that it is normal tablespace.
Thus, tablespace could be dropped between these two functions calls.
Fix: If space is not found from fil_system return tablespace type
ULINT_UNDEFINED and naturally do not continue rotating space.