origin/bb-10.6-thiru c3983ee54025d70ffc23daab6af077b592800a22 2022-02-01T12:28:00+05:30 (The tree contains the fix for MDEV-26326).
|
But the bad effect should not be caused by the fix for MDEV-26326.
|
|
Workflow:
|
1. Start server + generate some initial data.
|
2. Several sessions run a DDL/DML mix.
|
3. During 2. is ongoing
|
mariabackup --backup to some location A
|
mariabackup --prepare on location A
|
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 822]2022-02-01 2:57:01 0 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 826]2022-02-01 2:57:01 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 851]2022-02-01 2:57:01 0 [Note] InnoDB: Number of pools: 1
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 855]2022-02-01 2:57:01 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 881]2022-02-01 2:57:01 0 [Note] InnoDB: Initializing buffer pool, total size = 104857600, chunk size = 104857600
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 893]2022-02-01 2:57:01 0 [Note] InnoDB: Completed initialization of buffer pool
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 940]2022-02-01 2:57:01 0 [Note] InnoDB: Setting O_DIRECT on file ./ibdata1 failed
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 961]2022-02-01 2:57:01 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=11687970,12259007
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 1003]2022-02-01 2:57:01 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 1501
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 1007]2022-02-01 2:57:01 0 [ERROR] InnoDB: Plugin initialization aborted at srv0start.cc[1445] with error Data structure corruption
|
# 2022-02-01T02:58:42 [1307818] | [rr 1397379 1011][00] FATAL ERROR: 2022-02-01 02:57:01 mariabackup: innodb_init() returned 37 (Data structure corruption).
|
|
RQG
|
===
|
# git clone https://github.com/mleich1/rqg --branch experimental RQG
|
#
|
# GIT_SHOW: HEAD -> experimental, origin/experimental 067340e8ec78c25880ccd2e67dd62ad134edc531 2022-01-31T17:10:39+01:00
|
# rqg.pl : Version 4.0.4 (2021-12)
|
#
|
# $RQG_HOME/rqg.pl \
|
# --grammar=conf/runtime/alter_online.yy \
|
# --gendata=conf/runtime/alter_online.zz \
|
# --mysqld=--loose-innodb_lock_schedule_algorithm=fcfs \
|
# --mysqld=--loose-idle_write_transaction_timeout=0 \
|
# --mysqld=--loose-idle_transaction_timeout=0 \
|
# --mysqld=--loose-idle_readonly_transaction_timeout=0 \
|
# --mysqld=--connect_timeout=60 \
|
# --mysqld=--interactive_timeout=28800 \
|
# --mysqld=--slave_net_timeout=60 \
|
# --mysqld=--net_read_timeout=30 \
|
# --mysqld=--net_write_timeout=60 \
|
# --mysqld=--loose-table_lock_wait_timeout=50 \
|
# --mysqld=--wait_timeout=28800 \
|
# --mysqld=--lock-wait-timeout=86400 \
|
# --mysqld=--innodb-lock-wait-timeout=50 \
|
# --no-mask \
|
# --queries=10000000 \
|
# --seed=random \
|
# --reporters=Backtrace \
|
# --reporters=ErrorLog \
|
# --reporters=Deadlock1 \
|
# --validators=None \
|
# --mysqld=--log_output=none \
|
# --mysqld=--log_bin_trust_function_creators=1 \
|
# --mysqld=--loose-debug_assert_on_not_freed_memory=0 \
|
# --engine=InnoDB \
|
# --restart_timeout=360 \
|
# --mysqld=--plugin-load-add=file_key_management.so \
|
# --mysqld=--loose-file-key-management-filename=$RQG_HOME/conf/mariadb/encryption_keys.txt \
|
# --mysqld=--plugin-load-add=provider_lzo.so \
|
# --mysqld=--plugin-load-add=provider_bzip2.so \
|
# --mysqld=--plugin-load-add=provider_lzma \
|
# --mysqld=--plugin-load-add=provider_snappy \
|
# --mysqld=--plugin-load-add=provider_lz4 \
|
# --duration=300 \
|
# --mysqld=--loose-innodb_fatal_semaphore_wait_threshold=300 \
|
# --mysqld=--loose-innodb_read_only_compressed=OFF \
|
# --reporters=Mariabackup_linux \
|
# --mysqld=--innodb_log_file_size=402653184 \
|
# --duration=300 \
|
# --mysqld=--loose-innodb-sync-debug \
|
# --mysqld=--innodb_stats_persistent=off \
|
# --mysqld=--innodb_adaptive_hash_index=off \
|
# --mysqld=--log-bin \
|
# --mysqld=--sync-binlog=1 \
|
# --mysqld=--loose-innodb_evict_tables_on_commit_debug=off \
|
# --mysqld=--loose-max-statement-time=30 \
|
# --threads=2 \
|
# --mysqld=--innodb-use-native-aio=0 \
|
# --mysqld=--loose-gdb \
|
# --mysqld=--loose-debug-gdb \
|
# --rr=Extended \
|
# --rr_options=--wait \
|
# --mysqld=--innodb_rollback_on_timeout=OFF \
|
# --vardir_type=fast \
|
# --mysqld=--innodb_page_size=16K \
|
# --mysqld=--innodb-buffer-pool-size=8M \
|
# --no_mask \
|
# <local settings>
|
|
sdp:/data/results/1643708142/TBR-1345/dev/shm/rqg/1643708142/101/1_clone/rr
|
_RR_TRACE_DIR="." rr replay --mark-stdio mariabackup-0 # mariabackup --backup
|
_RR_TRACE_DIR="." rr replay --mark-stdio mariabackup-1 # mariabackup --prepare
|
|
- relates to
-
MDEV-28870
InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT during crash recovery
-
-
Closed
{"report":{"fcp":663.9000000953674,"ttfb":130.90000009536743,"pageVisibility":"visible","entityId":107476,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":1,"journeyId":"6746a647-b891-49a0-aaa4-5a6eba938c8d","navigationType":0,"readyForUser":737.9000000953674,"redirectCount":0,"resourceLoadedEnd":577.0999999046326,"resourceLoadedStart":137,"resourceTiming":[{"duration":56.799999952316284,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":137,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":193.79999995231628,"responseStart":0,"secureConnectionStart":0},{"duration":56.60000014305115,"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":137.29999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137.29999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":193.90000009536743,"responseStart":0,"secureConnectionStart":0},{"duration":71.79999995231628,"initiatorType":"script","name":"https://jira.mariadb.org/s/fbf975c0cce4b1abf04784eeae9ba1f4-CDN/lu2bu7/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":137.40000009536743,"connectEnd":137.40000009536743,"connectStart":137.40000009536743,"domainLookupEnd":137.40000009536743,"domainLookupStart":137.40000009536743,"fetchStart":137.40000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":137.40000009536743,"responseEnd":209.20000004768372,"responseStart":209.09999990463257,"secureConnectionStart":137.40000009536743},{"duration":142,"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":137.5,"connectEnd":137.5,"connectStart":137.5,"domainLookupEnd":137.5,"domainLookupStart":137.5,"fetchStart":137.5,"redirectEnd":0,"redirectStart":0,"requestStart":137.5,"responseEnd":279.5,"responseStart":279.5,"secureConnectionStart":137.5},{"duration":138.5,"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":137.5,"connectEnd":137.5,"connectStart":137.5,"domainLookupEnd":137.5,"domainLookupStart":137.5,"fetchStart":137.5,"redirectEnd":0,"redirectStart":0,"requestStart":137.5,"responseEnd":276,"responseStart":276,"secureConnectionStart":137.5},{"duration":142.59999990463257,"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":137.70000004768372,"connectEnd":137.70000004768372,"connectStart":137.70000004768372,"domainLookupEnd":137.70000004768372,"domainLookupStart":137.70000004768372,"fetchStart":137.70000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":137.70000004768372,"responseEnd":280.2999999523163,"responseStart":280.2999999523163,"secureConnectionStart":137.70000004768372},{"duration":144,"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":137.79999995231628,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":137.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":281.7999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":143.20000004768372,"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":137.79999995231628,"connectEnd":137.79999995231628,"connectStart":137.79999995231628,"domainLookupEnd":137.79999995231628,"domainLookupStart":137.79999995231628,"fetchStart":137.79999995231628,"redirectEnd":0,"redirectStart":0,"requestStart":137.79999995231628,"responseEnd":281,"responseStart":281,"secureConnectionStart":137.79999995231628},{"duration":143.89999985694885,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":137.90000009536743,"connectEnd":137.90000009536743,"connectStart":137.90000009536743,"domainLookupEnd":137.90000009536743,"domainLookupStart":137.90000009536743,"fetchStart":137.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":137.90000009536743,"responseEnd":281.7999999523163,"responseStart":281.7999999523163,"secureConnectionStart":137.90000009536743},{"duration":144.39999985694885,"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":138.20000004768372,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":138.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":282.59999990463257,"responseStart":0,"secureConnectionStart":0},{"duration":144.5,"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":138.20000004768372,"connectEnd":138.20000004768372,"connectStart":138.20000004768372,"domainLookupEnd":138.20000004768372,"domainLookupStart":138.20000004768372,"fetchStart":138.20000004768372,"redirectEnd":0,"redirectStart":0,"requestStart":138.20000004768372,"responseEnd":282.7000000476837,"responseStart":282.7000000476837,"secureConnectionStart":138.20000004768372},{"duration":352.19999980926514,"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":138.90000009536743,"connectEnd":138.90000009536743,"connectStart":138.90000009536743,"domainLookupEnd":138.90000009536743,"domainLookupStart":138.90000009536743,"fetchStart":138.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":138.90000009536743,"responseEnd":491.09999990463257,"responseStart":491.09999990463257,"secureConnectionStart":138.90000009536743},{"duration":438.09999990463257,"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":139,"connectEnd":139,"connectStart":139,"domainLookupEnd":139,"domainLookupStart":139,"fetchStart":139,"redirectEnd":0,"redirectStart":0,"requestStart":139,"responseEnd":577.0999999046326,"responseStart":577.0999999046326,"secureConnectionStart":139},{"duration":146.20000004768372,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":419.09999990463257,"connectEnd":419.09999990463257,"connectStart":419.09999990463257,"domainLookupEnd":419.09999990463257,"domainLookupStart":419.09999990463257,"fetchStart":419.09999990463257,"redirectEnd":0,"redirectStart":0,"requestStart":419.09999990463257,"responseEnd":565.2999999523163,"responseStart":565.2999999523163,"secureConnectionStart":419.09999990463257}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":3,"responseStart":131,"responseEnd":132,"domLoading":134,"domInteractive":795,"domContentLoadedEventStart":795,"domContentLoadedEventEnd":829,"domComplete":1756,"loadEventStart":1757,"loadEventEnd":1758,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":779.5999999046326},{"name":"bigPipe.sidebar-id.end","time":780.2999999523163},{"name":"bigPipe.activity-panel-pipe-id.start","time":780.4000000953674},{"name":"bigPipe.activity-panel-pipe-id.end","time":782.7000000476837},{"name":"activityTabFullyLoaded","time":837.0999999046326}],"measures":[],"correlationId":"fbaf4675ce9eef","effectiveType":"4g","downlink":10,"rtt":0,"serverDuration":68,"dbReadsTimeInMs":10,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}