I have a Slave Server from which I would like to create a Backup of a subset of tables. I use the following command:
mariadb-backup --backup --user=... --password=... --safe-slave-backup --target-dir=/bitnami/mariadb/backup --tables=application.prefix_*
|
The Backup Step finishes without any Errors, but it seems like there is some sort of race condition, as some of the backups are invalid. I assume so, since every fourth or fifth backup fails in the following prepare step. I trigger the prepare using the following command:
mariadb-backup --prepare --export --target-dir=/bitnami/mariadb/backup
|
The Output is as follows:
$ mariadb-backup --prepare --export --target-dir=/bitnami/mariadb/backuptest
|
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
|
[00] 2025-02-28 11:27:29 mariabackup: auto-enabling --innodb-file-per-table due to the --export option
|
[00] 2025-02-28 11:27:29 cd to /bitnami/mariadb/backuptest/
|
[00] 2025-02-28 11:27:29 open files limit requested 0, set to 1073741816
|
[00] 2025-02-28 11:27:29 This target seems to be not prepared yet.
|
[00] 2025-02-28 11:27:29 mariabackup: using the following InnoDB configuration for recovery:
|
[00] 2025-02-28 11:27:29 innodb_data_home_dir = .
|
[00] 2025-02-28 11:27:29 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2025-02-28 11:27:29 innodb_log_group_home_dir = .
|
[00] 2025-02-28 11:27:29 InnoDB: Using Linux native AIO
|
[00] 2025-02-28 11:27:29 Starting InnoDB instance for recovery.
|
[00] 2025-02-28 11:27:29 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
|
2025-02-28 11:27:29 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
|
2025-02-28 11:27:29 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-02-28 11:27:29 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
|
2025-02-28 11:27:30 0 [Note] InnoDB: Using Linux native AIO
|
2025-02-28 11:27:30 0 [Note] InnoDB: Initializing buffer pool, total size = 100.000MiB, chunk size = 100.000MiB
|
2025-02-28 11:27:30 0 [Note] InnoDB: Completed initialization of buffer pool
|
2025-02-28 11:27:30 0 [Note] InnoDB: Memory-mapped log (block size=512 bytes)
|
2025-02-28 11:27:30 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=74448152457258
|
2025-02-28 11:27:30 0 [Note] InnoDB: End of log at LSN=74448161922835
|
2025-02-28 11:27:30 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 1299
|
[00] 2025-02-28 11:27:30 mariadb-backup: srv_start() returned 37 (Data structure corruption).
|
However, using the exact same commands, some backups are valid and can be prepared correctly:
$ mariadb-backup --prepare --export --target-dir=/bitnami/mariadb/backuptest
|
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
|
[00] 2025-02-28 11:29:35 mariabackup: auto-enabling --innodb-file-per-table due to the --export option
|
[00] 2025-02-28 11:29:35 cd to /bitnami/mariadb/backuptest/
|
[00] 2025-02-28 11:29:35 open files limit requested 0, set to 1073741816
|
[00] 2025-02-28 11:29:35 This target seems to be not prepared yet.
|
[00] 2025-02-28 11:29:35 mariabackup: using the following InnoDB configuration for recovery:
|
[00] 2025-02-28 11:29:35 innodb_data_home_dir = .
|
[00] 2025-02-28 11:29:35 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2025-02-28 11:29:35 innodb_log_group_home_dir = .
|
[00] 2025-02-28 11:29:35 InnoDB: Using Linux native AIO
|
[00] 2025-02-28 11:29:35 Starting InnoDB instance for recovery.
|
[00] 2025-02-28 11:29:35 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
|
2025-02-28 11:29:35 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
|
2025-02-28 11:29:35 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-02-28 11:29:35 0 [Note] InnoDB: Using SSE4.2 crc32 instructions
|
2025-02-28 11:29:35 0 [Note] InnoDB: Using Linux native AIO
|
2025-02-28 11:29:35 0 [Note] InnoDB: Initializing buffer pool, total size = 100.000MiB, chunk size = 100.000MiB
|
2025-02-28 11:29:35 0 [Note] InnoDB: Completed initialization of buffer pool
|
2025-02-28 11:29:35 0 [Note] InnoDB: Memory-mapped log (block size=512 bytes)
|
2025-02-28 11:29:35 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=74448320586424
|
2025-02-28 11:29:35 0 [Note] InnoDB: End of log at LSN=74448330399689
|
2025-02-28 11:29:35 0 [Note] InnoDB: Tablespace 1298 was not found at './<database>/<table>.ibd', but there were no modifications either.
|
2025-02-28 11:29:35 0 [Note] InnoDB: Tablespace 162839 was not found at './<database>/<table>.ibd', but there were no modifications either.
|
2025-02-28 11:29:35 0 [Note] InnoDB: Tablespace 785882 was not found at './<database>/<table>.ibd', but there were no modifications either.
|
2025-02-28 11:29:35 0 [Note] InnoDB: Tablespace 6255447 was not found at './<database>/<table>.ibd', but there were no modifications either.
|
2025-02-28 11:29:35 0 [Note] InnoDB: Tablespace 6622460 was not found at './<database>/<table>.ibd', but there were no modifications either.
|
2025-02-28 11:29:35 0 [Note] InnoDB: Tablespace 6709548 was not found at './<database>/<table>.ibd', but there were no modifications either.
|
2025-02-28 11:29:35 0 [Note] InnoDB: To recover: 428 pages
|
2025-02-28 11:29:35 0 [Note] InnoDB: Last binlog file './mysql-bin.000543', position 533747945
|
2025-02-28 11:29:35 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
|
[00] 2025-02-28 11:29:35 Last binlog file ./mysql-bin.000543, position 533747945
|
[00] 2025-02-28 11:29:35 mariabackup: Recovered WSREP position: ea67368c-1e60-11e7-9d0b-abd1aba3d531:5406066765 domain_id: 0
|
|
[00] 2025-02-28 11:29:35 Prepare export : executing "/opt/bitnami/mariadb/bin/mariadb-backup" --mysqld --defaults-file=./backup-my.cnf --defaults-group-suffix= --datadir=. --innodb --innodb-fast-shutdown=0 --loose-partition --innodb-buffer-pool-size=104857600 --console --log-error= --skip-log-bin --bootstrap < mariabackup_prepare_for_export.sql
|
|
mysqld: Deprecated program name. It will be removed in a future release, use '/opt/bitnami/mariadb/bin/mariadb-backup' instead
|
[00] 2025-02-28 11:29:36 completed OK!
|
Current Version:
$ mariadb --version
|
mariadb from 11.4.5-MariaDB, client 15.2 for Linux (x86_64) using readline 5.1
|
$ mariadb-backup --version
|
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
|
- relates to
-
MDEV-36206
mariadb-backup --prepare --export complains of deprecated mysqld
-
-
Closed
{"report":{"fcp":1643.5,"ttfb":436.5,"pageVisibility":"visible","entityId":133056,"key":"jira.project.issue.view-issue","isInitial":true,"threshold":1000,"elementTimings":{},"userDeviceMemory":8,"userDeviceProcessors":64,"apdex":0.5,"journeyId":"f01efeb6-1505-4d2e-bd56-33b0abb1250a","navigationType":0,"readyForUser":1734.7999999523163,"redirectCount":0,"resourceLoadedEnd":1778.2000000476837,"resourceLoadedStart":450.60000014305115,"resourceTiming":[{"duration":445.09999990463257,"initiatorType":"link","name":"https://jira.mariadb.org/s/2c21342762a6a02add1c328bed317ffd-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/css/_super/batch.css","startTime":450.60000014305115,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":450.60000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":895.7000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":445.30000019073486,"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":450.7999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":450.7999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":896.1000001430511,"responseStart":0,"secureConnectionStart":0},{"duration":456,"initiatorType":"script","name":"https://jira.mariadb.org/s/0917945aaa57108d00c5076fea35e069-CDN/lu2cib/820016/12ta74/0a8bac35585be7fc6c9cc5a0464cd4cf/_/download/contextbatch/js/_super/batch.js?locale=en","startTime":451.10000014305115,"connectEnd":451.10000014305115,"connectStart":451.10000014305115,"domainLookupEnd":451.10000014305115,"domainLookupStart":451.10000014305115,"fetchStart":451.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":451.10000014305115,"responseEnd":907.1000001430511,"responseStart":907.1000001430511,"secureConnectionStart":451.10000014305115},{"duration":515.7000000476837,"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":451.2999999523163,"connectEnd":451.2999999523163,"connectStart":451.2999999523163,"domainLookupEnd":451.2999999523163,"domainLookupStart":451.2999999523163,"fetchStart":451.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":451.2999999523163,"responseEnd":967,"responseStart":967,"secureConnectionStart":451.2999999523163},{"duration":567.1000001430511,"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":451.5,"connectEnd":451.5,"connectStart":451.5,"domainLookupEnd":451.5,"domainLookupStart":451.5,"fetchStart":451.5,"redirectEnd":0,"redirectStart":0,"requestStart":451.5,"responseEnd":1018.6000001430511,"responseStart":1018.6000001430511,"secureConnectionStart":451.5},{"duration":593.5,"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":451.7000000476837,"connectEnd":451.7000000476837,"connectStart":451.7000000476837,"domainLookupEnd":451.7000000476837,"domainLookupStart":451.7000000476837,"fetchStart":451.7000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":451.7000000476837,"responseEnd":1045.2000000476837,"responseStart":1045.2000000476837,"secureConnectionStart":451.7000000476837},{"duration":598.2000000476837,"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":451.90000009536743,"connectEnd":451.90000009536743,"connectStart":451.90000009536743,"domainLookupEnd":451.90000009536743,"domainLookupStart":451.90000009536743,"fetchStart":451.90000009536743,"redirectEnd":0,"redirectStart":0,"requestStart":451.90000009536743,"responseEnd":1050.1000001430511,"responseStart":1050.1000001430511,"secureConnectionStart":451.90000009536743},{"duration":672.2999999523163,"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":452,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":452,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1124.2999999523163,"responseStart":0,"secureConnectionStart":0},{"duration":598.5,"initiatorType":"script","name":"https://jira.mariadb.org/rest/api/1.0/shortcuts/820016/47140b6e0a9bc2e4913da06536125810/shortcuts.js?context=issuenavigation&context=issueaction","startTime":452.10000014305115,"connectEnd":452.10000014305115,"connectStart":452.10000014305115,"domainLookupEnd":452.10000014305115,"domainLookupStart":452.10000014305115,"fetchStart":452.10000014305115,"redirectEnd":0,"redirectStart":0,"requestStart":452.10000014305115,"responseEnd":1050.6000001430511,"responseStart":1050.6000001430511,"secureConnectionStart":452.10000014305115},{"duration":672.9000000953674,"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":452.2999999523163,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":452.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1125.2000000476837,"responseStart":0,"secureConnectionStart":0},{"duration":598.7000000476837,"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":452.5,"connectEnd":452.5,"connectStart":452.5,"domainLookupEnd":452.5,"domainLookupStart":452.5,"fetchStart":452.5,"redirectEnd":0,"redirectStart":0,"requestStart":452.5,"responseEnd":1051.2000000476837,"responseStart":1051.2000000476837,"secureConnectionStart":452.5},{"duration":1185.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":456.2000000476837,"connectEnd":456.2000000476837,"connectStart":456.2000000476837,"domainLookupEnd":456.2000000476837,"domainLookupStart":456.2000000476837,"fetchStart":456.2000000476837,"redirectEnd":0,"redirectStart":0,"requestStart":456.2000000476837,"responseEnd":1641.7000000476837,"responseStart":1641.7000000476837,"secureConnectionStart":456.2000000476837},{"duration":1204.5,"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":456.2999999523163,"connectEnd":456.2999999523163,"connectStart":456.2999999523163,"domainLookupEnd":456.2999999523163,"domainLookupStart":456.2999999523163,"fetchStart":456.2999999523163,"redirectEnd":0,"redirectStart":0,"requestStart":456.2999999523163,"responseEnd":1660.7999999523163,"responseStart":1660.7999999523163,"secureConnectionStart":456.2999999523163},{"duration":138.39999985694885,"initiatorType":"xmlhttprequest","name":"https://jira.mariadb.org/rest/webResources/1.0/resources","startTime":1150.9000000953674,"connectEnd":1150.9000000953674,"connectStart":1150.9000000953674,"domainLookupEnd":1150.9000000953674,"domainLookupStart":1150.9000000953674,"fetchStart":1150.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1150.9000000953674,"responseEnd":1289.2999999523163,"responseStart":1289.2999999523163,"secureConnectionStart":1150.9000000953674},{"duration":328,"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":1446.5,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1446.5,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1774.5,"responseStart":0,"secureConnectionStart":0},{"duration":317.10000014305115,"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":1447.5,"connectEnd":1447.5,"connectStart":1447.5,"domainLookupEnd":1447.5,"domainLookupStart":1447.5,"fetchStart":1447.5,"redirectEnd":0,"redirectStart":0,"requestStart":1447.5,"responseEnd":1764.6000001430511,"responseStart":1764.6000001430511,"secureConnectionStart":1447.5},{"duration":330.2999999523163,"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":1447.9000000953674,"connectEnd":1447.9000000953674,"connectStart":1447.9000000953674,"domainLookupEnd":1447.9000000953674,"domainLookupStart":1447.9000000953674,"fetchStart":1447.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":1447.9000000953674,"responseEnd":1778.2000000476837,"responseStart":1778.2000000476837,"secureConnectionStart":1447.9000000953674},{"duration":319.09999990463257,"initiatorType":"script","name":"https://www.google-analytics.com/analytics.js","startTime":1509.9000000953674,"connectEnd":0,"connectStart":0,"domainLookupEnd":0,"domainLookupStart":0,"fetchStart":1509.9000000953674,"redirectEnd":0,"redirectStart":0,"requestStart":0,"responseEnd":1829,"responseStart":0,"secureConnectionStart":0}],"fetchStart":0,"domainLookupStart":0,"domainLookupEnd":0,"connectStart":0,"connectEnd":0,"requestStart":208,"responseStart":437,"responseEnd":444,"domLoading":448,"domInteractive":1847,"domContentLoadedEventStart":1847,"domContentLoadedEventEnd":1940,"domComplete":3382,"loadEventStart":3382,"loadEventEnd":3384,"userAgent":"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)","marks":[{"name":"bigPipe.sidebar-id.start","time":1794.7000000476837},{"name":"bigPipe.sidebar-id.end","time":1795.6000001430511},{"name":"bigPipe.activity-panel-pipe-id.start","time":1795.7999999523163},{"name":"bigPipe.activity-panel-pipe-id.end","time":1798.5},{"name":"activityTabFullyLoaded","time":1957.2999999523163}],"measures":[],"correlationId":"75f2b52c0fd11c","effectiveType":"4g","downlink":9.8,"rtt":0,"serverDuration":92,"dbReadsTimeInMs":9,"dbConnsTimeInMs":17,"applicationHash":"9d11dbea5f4be3d4cc21f03a88dd11d8c8687422","experiments":[]}}
Major
