Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
11.4.5
-
None
-
None
-
mariadb from 11.4.5-MariaDB, client 15.2 for Linux (x86_64) using readline 5.1
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
Description
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)
|
Attachments
Issue Links
- relates to
-
-
- Closed
-
Activity
@marko thanks for the rapid reply.
The server logs show nothing except the reconnect in the master slave replication during the backup
2025-02-28 12:11:33 6607 [Note] Error reading relay log event: slave SQL thread was killed
|
2025-02-28 12:11:33 6607 [Note] Slave SQL thread exiting, replication stopped in log 'binlog.022928' at position 504628293, master: <masters_dns>:3306
|
2025-02-28 12:11:44 7329 [Note] Slave SQL thread initialized, starting replication in log 'binlog.022928' at position 504628293, relay log './mysql-relay-bin.001713' position: 504628589
|
There is indeed a difference in the filesize. The ib_logfile0 of the broken backup is about 0.28M smaller in size. In detail 9364676 bytes in the working backup and 9080460 bytes in the broken backup. The innodb_log_file_size is set to 100M, should this be increased?
Ill try forcing the checkpoint, i will give feedback.
@marko The Checkpoint cannot be forced as we dont currently have a debug build.
ERROR 1193 (HY000) at line 1: Unknown system variable 'innodb_log_checkpoint_now'
|
In any build, you can force a checkpoint by executing
SET GLOBAL innodb_max_dirty_pages_pct=0.0; |
and waiting for the following to return 0:
SELECT variable_value FROM information_schema.global_status |
WHERE variable_name = 'INNODB_BUFFER_POOL_PAGES_DIRTY'; |
It’s advisable to restore the original values of innodb_max_dirty_pages_pct and innodb_max_dirty_pages_pct_lwm after this exercise.
I see that your innodb_log_file_size on the server is much larger than what was copied by mariadb-backup. Sometimes, when the circular ib_logfile0 on the server is being overwritten multiple times during a backup of a busy server, I could imagine things to occasionally fail. But actually in that case, it should usually be the backup operation that fails.
Are there many DDL operations being executed on this server? Examples: CREATE TABLE, DROP TABLE, RENAME TABLE, ALTER TABLE, TRUNCATE, OPTIMIZE TABLE?
On the server that was being backed up and backup complained about tablespace 1299, can you find the table?
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE space=1299; |
There are no DLL Operations on the master server (the backup runs from the slave) during this time of day where the buckup will run.
I am able to select the table with tablespace 1299, see the output below (table name is redacted for reasons)
On a server that does not receive many writes, log checkpoints can be quite far apart from each other. I think that for this bug, it is relevant if there were any DDL operations between the latest log checkpoint and the time the backup was completed. Have there been any DDL operations on a table by this name?
The table in question (tablespace 1299) was created on 2024-11-07. The Schema was never altered, modified, truncated, ... since then. Rows are inserted, updated, read and removed permanently.
But the error does not only happen on this table. There are also other tablespaces affected, e.g. tablespace 3, which is a system table
[ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 3
|
|
|
SELECT * FROM INFORMATION_SCHEMA.INNODB_SYS_TABLES WHERE space=3;
|
> mysql/gtid_slave_pos
|
We tried manually forcing a checkpoint with your given instructions:
# initial values
|
innodb_max_dirty_pages_pct: 90.000000
|
innodb_max_dirty_pages_pct_lwm: 0.000000
|
# previous number of dirty pages
|
SELECT variable_value FROM information_schema.global_status WHERE variable_name = 'INNODB_BUFFER_POOL_PAGES_DIRTY';
|
> ranges between about 3500 .. 4900
|
|
|
SET GLOBAL innodb_max_dirty_pages_pct=0.0;
|
> ok
|
|
|
# modified values after query
|
innodb_max_dirty_pages_pct: 0.000000
|
innodb_max_dirty_pages_pct_lwm: 0.000000
|
# number of dirty pages after query
|
SELECT variable_value FROM information_schema.global_status WHERE variable_name = 'INNODB_BUFFER_POOL_PAGES_DIRTY';
|
> UNCHANGED, ranges between about 3500 .. 4900
|
Weve waited for about 15-30 mins, the query did never return 0.
What makes me wonder: These tables should never be part of the backup. (neither tablespace 1299 nor tablespace 3)
All modifications of any persistent InnoDB tables will be written to the ib_logfile0 of the server. The table mysql.gtid_slave_pos will be updated when the binlog or replication is enabled. Modifications of persistent InnoDB files or tablespaces are identified by a numeric tablespace identifier. At every log checkpoint (when the head of the log is logically discarded) the file names of all modified files should be listed in FILE_MODIFY records. In this way, crash recovery will not have to read all InnoDB data files in order to construct a mapping between file names and tablespace identifiers.
There appears to be some previously unknown bug in the checkpoint logic that prevents the file names from being found in the log. I would need a complete copy of the server’s ib_logfile0 as well as the complete output of the failing mariadb-backup --backup command in order to be able to analyze this. You should note that the ib_logfile0 contains all recent changes to the InnoDB tables, which may be confidential data. Our internal stress testing does cover crash recovery, but we haven’t observed this type of a failure for a long time.
I dont think that we are able to provide this information without any further screening of the acttual data contained in the file. Is there a way for us to read the data in ib_logfile0? Otherwise we may need to find the source of the error by try-and-error changing some server configurations or inserting example data.
If you can configure innodb_encrypt_log=ON, in this MDEV-14425 log format only the log record payload will be encrypted. All FILE_ records as well as all tablespace identifiers and page numbers in any log records will be in the clear text. Could you share such a file, along with the full output of mariadb-backup --backup?
The motivation for not encrypting the entire log is that the file names as well as the tablespace IDs are already in the clear even with innodb_encrypt_tables=ON; the first page of each file is not encrypted and will contain the tablespace ID.
Another alternative would be that you make and preserve a copy the server’s ib_logfile0 that is made right after the backup finishes, and save all output from the backup command as well. If the prepare fails as described, then I’d want to see the following output on both the backup’s ib_logfile0 (before running prepare) and the copy of the server’s ib_logfile0.
od -Ax -t x1 -N 0x3000 ib_logfile0
|
wc -c ib_logfile0
|
There is no application data in the redo log header. The header only identifies the latest checkpoint LSN as well as the mapping from LSN to file offsets. Based on this output, I would ask for some more output from the files.
Sorry for the long delay, this error did not happen in the last days!
But just now it failed again. Here ist the Output:
dockeruser@e82d6b321cdd:/bitnami/mariadb/backup_20250307_113818$ od -Ax -t x1 -N 0x3000 ib_logfile0
|
000000 50 68 79 73 00 00 00 00 00 00 44 3b 96 1a c3 c7
|
000010 42 61 63 6b 75 70 20 31 31 2e 34 2e 35 00 00 00
|
000020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
0001f0 00 00 00 00 00 00 00 00 00 00 00 00 de f6 95 30
|
000200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001000 00 00 44 3b 96 1a c3 c7 00 00 44 3b 98 2f 44 4f
|
001010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001030 00 00 00 00 00 00 00 00 00 00 00 00 ff 02 d5 89
|
001040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
003000
|
dockeruser@e82d6b321cdd:/bitnami/mariadb/backup_20250307_113818$ wc -c ib_logfile0
|
78129558 ib_logfile0
|
dockeruser@e82d6b321cdd:/bitnami/mariadb/backup_20250307_113818$ od -Ax -t x1 -N 0x3000 ib_logfile0_before_prepare
|
000000 50 68 79 73 00 00 00 00 00 00 44 3b 96 1a c3 c7
|
000010 42 61 63 6b 75 70 20 31 31 2e 34 2e 35 00 00 00
|
000020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
0001f0 00 00 00 00 00 00 00 00 00 00 00 00 de f6 95 30
|
000200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001000 00 00 44 3b 96 1a c3 c7 00 00 44 3b 98 2f 44 4f
|
001010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001030 00 00 00 00 00 00 00 00 00 00 00 00 ff 02 d5 89
|
001040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
003000
|
dockeruser@e82d6b321cdd:/bitnami/mariadb/backup_20250307_113818$ wc -c ib_logfile0_before_prepare
|
78129558 ib_logfile0_before_prepare
|
The ib_logfile0 if the file after the prepare. The ib_logfile0_before_prepare is the copy I created before the prepare step.
The Output of the backup command:
dockeruser@9e84a8302f58:/bitnami/mariadb$ mariadb-backup --backup --user=<user> --password=<password> --target-dir=/bitnami/mariadb/backup_20250307_113818 --tables="^database1.(backend_users)$"
|
[00] 2025-03-07 11:48:10 Connecting to MariaDB server host: localhost, user: <user>, password: set, port: 3306, socket: /opt/bitnami/mariadb/tmp/mysql.sock
|
[00] 2025-03-07 11:48:10 Using server version 11.4.5-MariaDB-log
|
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
|
[00] 2025-03-07 11:48:10 uses posix_fadvise().
|
[00] 2025-03-07 11:48:10 cd to /bitnami/mariadb/data/
|
[00] 2025-03-07 11:48:10 open files limit requested 0, set to 1073741816
|
[00] 2025-03-07 11:48:10 mariabackup: using the following InnoDB configuration:
|
[00] 2025-03-07 11:48:10 innodb_data_home_dir =
|
[00] 2025-03-07 11:48:10 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2025-03-07 11:48:10 innodb_log_group_home_dir = ./
|
[00] 2025-03-07 11:48:10 InnoDB: Using Linux native AIO
|
2025-03-07 11:48:10 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-03-07 11:48:10 0 [Note] InnoDB: Memory-mapped log (block size=512 bytes)
|
[00] 2025-03-07 11:48:10 mariabackup: Generating a list of tablespaces
|
[00] 2025-03-07 11:48:11 DDL tracking : create 6894494 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : create 6894495 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : delete 6894494 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : delete 6894495 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : create 6894496 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : delete 6894496 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : create 6894497 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : create 6894498 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : delete 6894498 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : delete 6894497 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : create 6894499 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 DDL tracking : delete 6894499 "./database1/<some_random_tablename>.ibd"
|
[00] 2025-03-07 11:48:11 Connecting to MariaDB server host: localhost, user: <user>, password: set, port: 3306, socket: /opt/bitnami/mariadb/tmp/mysql.sock
|
[00] 2025-03-07 11:48:11 Retrying read of log at LSN=75022346061169
|
[00] 2025-03-07 11:48:11 Connecting to MariaDB server host: localhost, user: <user>, password: set, port: 3306, socket: /opt/bitnami/mariadb/tmp/mysql.sock
|
[00] 2025-03-07 11:48:11 BACKUP STAGE START
|
[00] 2025-03-07 11:48:11 Acquiring BACKUP LOCKS...
|
[00] 2025-03-07 11:48:11 Copying /bitnami/mariadb/data//aria_log_control to /bitnami/mariadb/backup_20250307_113818/aria_log_control
|
[00] 2025-03-07 11:48:11 ...done
|
[00] 2025-03-07 11:48:11 Loading aria_log_control.
|
[00] 2025-03-07 11:48:11 aria_log_control: last_log_number: 1
|
[00] 2025-03-07 11:48:11 Start scanning aria tables.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
... muliple other tables that do not match the table filter
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/innodb_index_stats.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/innodb_table_stats.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_allowlist.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/transaction_registry.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_cluster.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_cluster_members.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_streaming_log.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/innodb_index_stats.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_leap_second.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/proxies_priv.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_keyword.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/procs_priv.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/table_stats.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/tables_priv.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/roles_mapping.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_topic.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/func.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/proc.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_transition.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/roles_mapping.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_transition_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/event.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/db.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_category.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_topic.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/event.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/index_stats.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/table_stats.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/table_stats.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/proc.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_leap_second.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/tables_priv.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_relation.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/tables_priv.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/db.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_transition.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/plugin.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/columns_priv.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/columns_priv.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/general_log.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/general_log.CSM.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/general_log.CSV.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/slow_log.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/slow_log.CSM.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/slow_log.CSV.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_leap_second.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/roles_mapping.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_relation.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/proc.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_category.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/index_stats.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/global_priv.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_topic.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/global_priv.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/global_priv.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/gtid_slave_pos.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_keyword.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_relation.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/innodb_table_stats.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/index_stats.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_category.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/columns_priv.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/procs_priv.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/func.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/transaction_registry.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/func.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/plugin.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/servers.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/servers.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/help_keyword.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_transition_type.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/servers.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_transition.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_name.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_cluster.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_cluster_members.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_streaming_log.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_allowlist.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/proxies_priv.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/plugin.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_name.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/db.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_transition_type.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/column_stats.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/column_stats.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/time_zone_name.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/event.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/procs_priv.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/column_stats.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/proxies_priv.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/user.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/gtid_slave_pos.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/session.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/version.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/sys_config.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/sys_config.MAI.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/sys_config.MAD.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/innodb_buffer_stats_by_schema.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_table_statistics.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024innodb_buffer_stats_by_schema.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024statements_with_sorting.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/innodb_buffer_stats_by_table.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024schema_table_statistics.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024innodb_buffer_stats_by_table.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/host_summary.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/innodb_lock_waits.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/host_summary_by_stages.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024innodb_lock_waits.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024host_summary.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_object_overview.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/user_summary_by_file_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_auto_increment_columns.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024statements_with_temp_tables.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024schema_flattened_keys.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/waits_by_user_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_redundant_indexes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/user_summary_by_file_io_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/ps_check_lost_instrumentation.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024processlist.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/latest_file_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/waits_by_host_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024latest_file_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/waits_global_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/io_by_thread_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024user_summary_by_file_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024io_by_thread_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/user_summary_by_statement_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/io_global_by_file_by_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024user_summary_by_stages.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024io_global_by_file_by_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/user_summary_by_statement_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/io_global_by_file_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_table_statistics_with_buffer.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024io_global_by_file_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/user_summary_by_stages.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/io_global_by_wait_by_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/user_summary.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024io_global_by_wait_by_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024user_summary.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/io_global_by_wait_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024schema_table_lock_waits.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024io_global_by_wait_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/host_summary_by_file_io_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/memory_by_user_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/statement_analysis.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024memory_by_user_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/host_summary_by_file_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/memory_by_host_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024statement_analysis.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024memory_by_host_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/statements_with_errors_or_warnings.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/memory_by_thread_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024statements_with_errors_or_warnings.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024memory_by_thread_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/host_summary_by_statement_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/memory_global_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/statements_with_full_table_scans.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024memory_global_by_current_bytes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/metrics.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/memory_global_total.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024host_summary_by_file_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024memory_global_total.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_index_statistics.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/host_summary_by_statement_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024schema_index_statistics.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024statements_with_full_table_scans.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024ps_schema_table_statistics_io.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_unused_indexes.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024schema_table_statistics_with_buffer.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024ps_digest_avg_latency_distribution.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_tables_with_full_table_scans.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/schema_table_lock_waits.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024schema_tables_with_full_table_scans.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/processlist.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/statements_with_sorting.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/statements_with_runtimes_in_95th_percentile.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024user_summary_by_file_io_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/db.opt.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/statements_with_temp_tables.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024user_summary_by_statement_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024user_summary_by_statement_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024host_summary_by_file_io_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024host_summary_by_statement_type.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024host_summary_by_statement_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024host_summary_by_stages.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/wait_classes_global_by_avg_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024wait_classes_global_by_avg_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/wait_classes_global_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024wait_classes_global_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024waits_by_user_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024waits_by_host_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024waits_global_by_latency.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/x@0024session.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./sys/session_ssl_status.frm.
|
[00] 2025-03-07 11:48:11 Skipping ./performance_schema/db.opt.
|
[00] 2025-03-07 11:48:11 Start scanning aria log files.
|
[00] 2025-03-07 11:48:11 Found 1 aria log files, minimum log number 1, maximum log number 1
|
[00] 2025-03-07 11:48:11 Stop scanning aria tables.
|
[00] 2025-03-07 11:48:11 Copying .//undo001 to /bitnami/mariadb/backup_20250307_113818/undo001
|
[00] 2025-03-07 11:48:11 ...done
|
[00] 2025-03-07 11:48:11 Copying .//undo002 to /bitnami/mariadb/backup_20250307_113818/undo002
|
[00] 2025-03-07 11:48:11 ...done
|
[00] 2025-03-07 11:48:11 Copying .//undo003 to /bitnami/mariadb/backup_20250307_113818/undo003
|
[00] 2025-03-07 11:48:11 ...done
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
... muliple other tables that do not match the table filter
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database4/<some_random_tablename>.ibd
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Copying ./database1/backend_users.ibd to /bitnami/mariadb/backup_20250307_113818/database1/backend_users.ibd
|
[00] 2025-03-07 11:48:11 ...done
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
... muliple other tables that do not match the table filter
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./database1/<some_random_tablename>.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/innodb_index_stats.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/innodb_table_stats.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_allowlist.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/transaction_registry.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_cluster.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_cluster_members.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/wsrep_streaming_log.ibd.
|
[00] 2025-03-07 11:48:11 Skipping ./mysql/gtid_slave_pos.ibd.
|
[00] 2025-03-07 11:48:11 Copying ibdata1 to /bitnami/mariadb/backup_20250307_113818/ibdata1
|
[00] 2025-03-07 11:48:13 Retrying read of log at LSN=75022346061366
|
[00] 2025-03-07 11:48:14 Retrying read of log at LSN=75022346061366
|
[00] 2025-03-07 11:48:15 ...done
|
[00] 2025-03-07 11:48:15 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-07 11:48:15 Retrying read of log at LSN=75022346061366
|
[00] 2025-03-07 11:48:15 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 960815104 bytes
|
[00] 2025-03-07 11:48:15 BACKUP STAGE FLUSH
|
[00] 2025-03-07 11:48:15 Start scanning common engine tables, need backup locks: 0, collect log and stat tables: 1
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_leap_second.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/proxies_priv.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_keyword.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/procs_priv.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/table_stats.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/tables_priv.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/roles_mapping.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_topic.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/func.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/proc.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/roles_mapping.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/db.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/event.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/index_stats.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/table_stats.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_relation.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/tables_priv.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/plugin.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/columns_priv.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/general_log.CSM.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/general_log.CSV.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.CSM.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.CSV.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_leap_second.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/proc.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_category.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/global_priv.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_topic.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/global_priv.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_relation.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/index_stats.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_category.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/columns_priv.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/procs_priv.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/func.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/plugin.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/servers.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/help_keyword.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition_type.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/servers.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_name.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/db.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition_type.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/column_stats.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/column_stats.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_name.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/event.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/proxies_priv.MAD.
|
[00] 2025-03-07 11:48:15 Skipping ./sys/sys_config.MAI.
|
[00] 2025-03-07 11:48:15 Skipping ./sys/sys_config.MAD.
|
[00] 2025-03-07 11:48:15 Stop scanning common engine tables
|
[00] 2025-03-07 11:48:15 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-07 11:48:15 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 0 bytes
|
[00] 2025-03-07 11:48:15 Start scanning common engine tables, need backup locks: 1, collect log and stat tables: 0
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/general_log.CSM.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/general_log.CSV.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.CSM.
|
[00] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.CSV.
|
[00] 2025-03-07 11:48:15 Stop scanning common engine tables
|
[00] 2025-03-07 11:48:15 Starting to backup non-InnoDB tables and files
|
[01] 2025-03-07 11:48:15 Skipping ./database4/<some_random_tablename>.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./database4/<some_random_tablename>.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./database4/<some_random_tablename>.ibd.
|
... muliple other tables that do not match the table filter
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
[01] 2025-03-07 11:48:15 Copying ./database1/backend_users.frm to /bitnami/mariadb/backup_20250307_113818/database1/backend_users.frm
|
[01] 2025-03-07 11:48:15 ...done
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
... muliple other tables that do not match the table filter
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./database1/<some_random_tablename>.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/innodb_index_stats.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/innodb_table_stats.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_allowlist.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/transaction_registry.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_cluster.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_cluster_members.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_streaming_log.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/innodb_index_stats.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_leap_second.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/proxies_priv.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_keyword.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/procs_priv.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/table_stats.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/tables_priv.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/roles_mapping.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_topic.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/func.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/proc.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/roles_mapping.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/event.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/db.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_category.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_topic.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/event.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/index_stats.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/table_stats.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/table_stats.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/proc.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_leap_second.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/tables_priv.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_relation.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/tables_priv.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/db.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/plugin.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/columns_priv.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/columns_priv.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/general_log.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/general_log.CSM.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/general_log.CSV.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.CSM.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/slow_log.CSV.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_leap_second.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/roles_mapping.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_relation.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/proc.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_category.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/index_stats.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/global_priv.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_topic.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/global_priv.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/global_priv.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/gtid_slave_pos.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_keyword.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_relation.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/innodb_table_stats.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/index_stats.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_category.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/columns_priv.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/procs_priv.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/func.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/transaction_registry.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/func.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/plugin.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/servers.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/servers.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/help_keyword.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition_type.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/servers.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_name.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_cluster.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_cluster_members.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_streaming_log.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/wsrep_allowlist.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/proxies_priv.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/plugin.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_name.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/db.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_transition_type.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/column_stats.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/column_stats.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/time_zone_name.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/event.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/procs_priv.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/column_stats.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/proxies_priv.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/user.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./mysql/gtid_slave_pos.ibd.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/session.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/version.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/sys_config.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/sys_config.MAI.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/sys_config.MAD.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/innodb_buffer_stats_by_schema.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_table_statistics.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024innodb_buffer_stats_by_schema.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024statements_with_sorting.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/innodb_buffer_stats_by_table.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024schema_table_statistics.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024innodb_buffer_stats_by_table.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/host_summary.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/innodb_lock_waits.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/host_summary_by_stages.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024innodb_lock_waits.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024host_summary.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_object_overview.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/user_summary_by_file_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_auto_increment_columns.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024statements_with_temp_tables.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024schema_flattened_keys.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/waits_by_user_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_redundant_indexes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/user_summary_by_file_io_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/ps_check_lost_instrumentation.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024processlist.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/latest_file_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/waits_by_host_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024latest_file_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/waits_global_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/io_by_thread_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024user_summary_by_file_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024io_by_thread_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/user_summary_by_statement_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/io_global_by_file_by_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024user_summary_by_stages.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024io_global_by_file_by_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/user_summary_by_statement_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/io_global_by_file_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_table_statistics_with_buffer.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024io_global_by_file_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/user_summary_by_stages.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/io_global_by_wait_by_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/user_summary.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024io_global_by_wait_by_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024user_summary.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/io_global_by_wait_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024schema_table_lock_waits.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024io_global_by_wait_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/host_summary_by_file_io_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/memory_by_user_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/statement_analysis.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024memory_by_user_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/host_summary_by_file_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/memory_by_host_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024statement_analysis.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024memory_by_host_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/statements_with_errors_or_warnings.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/memory_by_thread_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024statements_with_errors_or_warnings.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024memory_by_thread_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/host_summary_by_statement_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/memory_global_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/statements_with_full_table_scans.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024memory_global_by_current_bytes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/metrics.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/memory_global_total.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024host_summary_by_file_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024memory_global_total.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_index_statistics.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/host_summary_by_statement_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024schema_index_statistics.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024statements_with_full_table_scans.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024ps_schema_table_statistics_io.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_unused_indexes.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024schema_table_statistics_with_buffer.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024ps_digest_avg_latency_distribution.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_tables_with_full_table_scans.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/schema_table_lock_waits.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024schema_tables_with_full_table_scans.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/processlist.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/statements_with_sorting.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/statements_with_runtimes_in_95th_percentile.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024user_summary_by_file_io_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/db.opt.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/statements_with_temp_tables.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024user_summary_by_statement_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024user_summary_by_statement_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024host_summary_by_file_io_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024host_summary_by_statement_type.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024host_summary_by_statement_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024host_summary_by_stages.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/wait_classes_global_by_avg_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024wait_classes_global_by_avg_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/wait_classes_global_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024wait_classes_global_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024waits_by_user_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024waits_by_host_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024waits_global_by_latency.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/x@0024session.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./sys/session_ssl_status.frm.
|
[01] 2025-03-07 11:48:15 Skipping ./performance_schema/db.opt.
|
[00] 2025-03-07 11:48:15 Finished backing up non-InnoDB tables and files
|
[00] 2025-03-07 11:48:15 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-07 11:48:15 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 0 bytes
|
[00] 2025-03-07 11:48:15 BACKUP STAGE BLOCK_COMMIT
|
[00] 2025-03-07 11:48:15 mariabackup: The latest check point (for incremental): '75022276168075'
|
[00] 2025-03-07 11:48:15 Waiting for log copy thread to read lsn 18446744073709551615
|
[00] 2025-03-07 11:48:20 Start copying statistics aria tables.
|
[00] 2025-03-07 11:48:20 Stop copying statistics aria tables.
|
[00] 2025-03-07 11:48:20 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-07 11:48:20 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 8192 bytes
|
[00] 2025-03-07 11:48:20 Writing mariadb_backup_binlog_info
|
[00] 2025-03-07 11:48:20 ...done
|
[00] 2025-03-07 11:48:20 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
|
[00] 2025-03-07 11:48:20 BACKUP STAGE END
|
[00] 2025-03-07 11:48:20 Executing BACKUP STAGE END
|
[00] 2025-03-07 11:48:20 All tables unlocked
|
[00] 2025-03-07 11:48:20 Backup created in directory '/bitnami/mariadb/backup_20250307_113818/'
|
[00] 2025-03-07 11:48:20 MySQL binlog position: filename 'mysql-bin.000028', position '988230478', GTID of the last change '0-14-4970475594'
|
[00] 2025-03-07 11:48:20 Writing backup-my.cnf
|
[00] 2025-03-07 11:48:20 ...done
|
[00] 2025-03-07 11:48:20 Writing mariadb_backup_info
|
[00] 2025-03-07 11:48:20 ...done
|
[00] 2025-03-07 11:48:20 Redo log (from LSN 75022276168075 to 75022346061366) was copied.
|
[00] 2025-03-07 11:48:20 completed OK!
|
Thank you, tobias.bhn. Actually it looks like you dumped twice the data of the log file that was created by backup, and not the log file of the server shortly after the backup finished. The file size 78129558 is not a multiple of 4096; therefore I expect that the file was produced by mariadb-backup --backup. But, luckily the root cause of the problem can be identified based on the backed-up log file and the message output. That is, the server does not apparently have any race condition in its checkpoint logic, and the problem is entirely within the backup step, not affecting normal crash recovery.
The likely reason why we haven’t found this bug in our internal stress testing is that we are testing with much smaller data sets.
The message Redo log (from LSN 75022276168075 to 75022346061366) was copied does not seem to match the file size (75022346061366 - 75022276168075 + 12288 = 69905579, not 78129558). The end LSN in the backed up log file should actually be 75022276168075 - 12288 + 78129558 = 75022354285345 (0x443b80c70321).
The start LSN does match the log file header: the first LSN is the checkpoint LSN 0x443b7c1f098b, which is also the LSN when this log file was created (written at offset 8). Another interesting LSN in the checkpoint header block is 0x443b982f444f (75022746993743), which is the server’s LSN when it advanced to this checkpoint. The end LSN in the message (75022346061366 or 0x443b80498636) is actually 400,932,377 less than that, and the end LSN based on the length of the backed-up log file is 392,708,398 less than that. This would indicate that an insufficient amount of log had been copied by mariadb-backup --backup! We seem to be missing a consistency check for ensuring that the log up to the end LSN as of the latest checkpoint LSN will be included.
There is absolutely no doubt that the mariadb-backup --prepare will fail on this kind of a truncated log file. Can you please post the output of that step as well? I think that we need to improve the diagnostics in that step, and a sample of what we currently report could be helpful.
Thanks for the explanation, even though I probably don't fully understand the technicalities of what it all means. It sounds like the underlying problem has been pinpointed?
As for the log output you ask for:
I no longer have the output from the --prepare step, as I always clean up the failed backups. Here is a new, complete sequence with all the inputs and outputs. This time, I will store the complete log and the files, in case any further questions arise.
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$ mariadb-backup --backup --user=<user> --password=<password> --target-dir=/bitnami/mariadb/backup_20250313_142438 '--tables="^database2.(backend_users)$"'
|
[00] 2025-03-13 15:24:41 Connecting to MariaDB server host: localhost, user: <user>, password: set, port: 3306, socket: /opt/bitnami/mariadb/tmp/mysql.sock
|
[00] 2025-03-13 15:24:41 Using server version 11.4.5-MariaDB-log
|
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
|
[00] 2025-03-13 15:24:41 uses posix_fadvise().
|
[00] 2025-03-13 15:24:41 cd to /bitnami/mariadb/data/
|
[00] 2025-03-13 15:24:41 open files limit requested 0, set to 1073741816
|
[00] 2025-03-13 15:24:41 mariabackup: using the following InnoDB configuration:
|
[00] 2025-03-13 15:24:41 innodb_data_home_dir =
|
[00] 2025-03-13 15:24:41 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2025-03-13 15:24:41 innodb_log_group_home_dir = ./
|
[00] 2025-03-13 15:24:41 InnoDB: Using Linux native AIO
|
2025-03-13 15:24:41 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-03-13 15:24:41 0 [Note] InnoDB: Memory-mapped log (block size=512 bytes)
|
[00] 2025-03-13 15:24:41 mariabackup: Generating a list of tablespaces
|
[00] 2025-03-13 15:24:45 Connecting to MariaDB server host: localhost, user: <user>, password: set, port: 3306, socket: /opt/bitnami/mariadb/tmp/mysql.sock
|
[00] 2025-03-13 15:24:45 Retrying read of log at LSN=75328241449372
|
[00] 2025-03-13 15:24:45 Connecting to MariaDB server host: localhost, user: <user>, password: set, port: 3306, socket: /opt/bitnami/mariadb/tmp/mysql.sock
|
[00] 2025-03-13 15:24:45 BACKUP STAGE START
|
[00] 2025-03-13 15:24:45 Acquiring BACKUP LOCKS...
|
[00] 2025-03-13 15:24:45 Copying /bitnami/mariadb/data//aria_log_control to /bitnami/mariadb/backup_20250313_142438/aria_log_control
|
[00] 2025-03-13 15:24:45 ...done
|
[00] 2025-03-13 15:24:45 Loading aria_log_control.
|
[00] 2025-03-13 15:24:45 aria_log_control: last_log_number: 1
|
[00] 2025-03-13 15:24:45 Start scanning aria tables.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/db.opt.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.frm.
|
... other skipped tables
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/innodb_index_stats.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/innodb_table_stats.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_allowlist.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/transaction_registry.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_cluster.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_cluster_members.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_streaming_log.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/innodb_index_stats.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_leap_second.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/proxies_priv.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_keyword.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/procs_priv.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/table_stats.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/tables_priv.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/roles_mapping.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_topic.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/func.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/proc.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_transition.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/roles_mapping.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_transition_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/event.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/db.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_category.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_topic.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/event.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/index_stats.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/table_stats.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/table_stats.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/proc.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_leap_second.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/tables_priv.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_relation.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/tables_priv.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/db.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_transition.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/plugin.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/columns_priv.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/columns_priv.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/general_log.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/general_log.CSM.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/general_log.CSV.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/slow_log.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/slow_log.CSM.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/slow_log.CSV.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_leap_second.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/roles_mapping.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_relation.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/proc.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_category.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/index_stats.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/global_priv.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_topic.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/global_priv.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/global_priv.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/gtid_slave_pos.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_keyword.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_relation.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/innodb_table_stats.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/index_stats.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_category.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/columns_priv.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/procs_priv.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/func.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/transaction_registry.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/func.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/plugin.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/servers.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/servers.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/help_keyword.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_transition_type.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/servers.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_transition.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_name.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_cluster.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_cluster_members.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_streaming_log.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_allowlist.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/proxies_priv.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/plugin.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_name.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/db.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_transition_type.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/column_stats.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/column_stats.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/time_zone_name.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/event.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/procs_priv.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/column_stats.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/proxies_priv.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/user.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/gtid_slave_pos.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/session.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/version.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/sys_config.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/sys_config.MAI.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/sys_config.MAD.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/innodb_buffer_stats_by_schema.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_table_statistics.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024innodb_buffer_stats_by_schema.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024statements_with_sorting.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/innodb_buffer_stats_by_table.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024schema_table_statistics.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024innodb_buffer_stats_by_table.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/host_summary.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/innodb_lock_waits.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/host_summary_by_stages.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024innodb_lock_waits.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024host_summary.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_object_overview.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/user_summary_by_file_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_auto_increment_columns.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024statements_with_temp_tables.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024schema_flattened_keys.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/waits_by_user_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_redundant_indexes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/user_summary_by_file_io_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/ps_check_lost_instrumentation.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024processlist.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/latest_file_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/waits_by_host_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024latest_file_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/waits_global_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/io_by_thread_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024user_summary_by_file_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024io_by_thread_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/user_summary_by_statement_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/io_global_by_file_by_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024user_summary_by_stages.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024io_global_by_file_by_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/user_summary_by_statement_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/io_global_by_file_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_table_statistics_with_buffer.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024io_global_by_file_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/user_summary_by_stages.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/io_global_by_wait_by_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/user_summary.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024io_global_by_wait_by_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024user_summary.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/io_global_by_wait_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024schema_table_lock_waits.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024io_global_by_wait_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/host_summary_by_file_io_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/memory_by_user_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/statement_analysis.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024memory_by_user_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/host_summary_by_file_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/memory_by_host_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024statement_analysis.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024memory_by_host_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/statements_with_errors_or_warnings.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/memory_by_thread_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024statements_with_errors_or_warnings.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024memory_by_thread_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/host_summary_by_statement_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/memory_global_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/statements_with_full_table_scans.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024memory_global_by_current_bytes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/metrics.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/memory_global_total.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024host_summary_by_file_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024memory_global_total.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_index_statistics.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/host_summary_by_statement_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024schema_index_statistics.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024statements_with_full_table_scans.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024ps_schema_table_statistics_io.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_unused_indexes.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024schema_table_statistics_with_buffer.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024ps_digest_avg_latency_distribution.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_tables_with_full_table_scans.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/schema_table_lock_waits.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024schema_tables_with_full_table_scans.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/processlist.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/statements_with_sorting.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/statements_with_runtimes_in_95th_percentile.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024user_summary_by_file_io_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/db.opt.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/statements_with_temp_tables.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024user_summary_by_statement_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024user_summary_by_statement_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024host_summary_by_file_io_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024host_summary_by_statement_type.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024host_summary_by_statement_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024host_summary_by_stages.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/wait_classes_global_by_avg_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024wait_classes_global_by_avg_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/wait_classes_global_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024wait_classes_global_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024waits_by_user_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024waits_by_host_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024waits_global_by_latency.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/x@0024session.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./sys/session_ssl_status.frm.
|
[00] 2025-03-13 15:24:45 Skipping ./performance_schema/db.opt.
|
[00] 2025-03-13 15:24:45 Start scanning aria log files.
|
[00] 2025-03-13 15:24:45 Found 1 aria log files, minimum log number 1, maximum log number 1
|
[00] 2025-03-13 15:24:45 Stop scanning aria tables.
|
[00] 2025-03-13 15:24:45 Copying .//undo001 to /bitnami/mariadb/backup_20250313_142438/undo001
|
[00] 2025-03-13 15:24:45 ...done
|
[00] 2025-03-13 15:24:45 Copying .//undo002 to /bitnami/mariadb/backup_20250313_142438/undo002
|
[00] 2025-03-13 15:24:45 ...done
|
[00] 2025-03-13 15:24:45 Copying .//undo003 to /bitnami/mariadb/backup_20250313_142438/undo003
|
[00] 2025-03-13 15:24:45 ...done
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
... other skipped tables
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Copying ./database2/backend_users.ibd to /bitnami/mariadb/backup_20250313_142438/database2/backend_users.ibd
|
[00] 2025-03-13 15:24:45 ...done
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
... other skipped tables
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./database2/<tablename>.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/innodb_index_stats.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/innodb_table_stats.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_allowlist.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/transaction_registry.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_cluster.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_cluster_members.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/wsrep_streaming_log.ibd.
|
[00] 2025-03-13 15:24:45 Skipping ./mysql/gtid_slave_pos.ibd.
|
[00] 2025-03-13 15:24:45 Copying ibdata1 to /bitnami/mariadb/backup_20250313_142438/ibdata1
|
[00] 2025-03-13 15:24:46 Retrying read of log at LSN=75328241449372
|
[00] 2025-03-13 15:24:47 Retrying read of log at LSN=75328241449372
|
[00] 2025-03-13 15:24:48 Retrying read of log at LSN=75328241449372
|
[00] 2025-03-13 15:24:48 ...done
|
[00] 2025-03-13 15:24:48 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-13 15:24:49 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 966270976 bytes
|
[00] 2025-03-13 15:24:49 BACKUP STAGE FLUSH
|
[00] 2025-03-13 15:24:49 Start scanning common engine tables, need backup locks: 0, collect log and stat tables: 1
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_leap_second.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/proxies_priv.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_keyword.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/procs_priv.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/table_stats.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/tables_priv.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/roles_mapping.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_topic.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/func.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/proc.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/roles_mapping.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/db.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/event.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/index_stats.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/table_stats.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_relation.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/tables_priv.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/plugin.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/columns_priv.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/general_log.CSM.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/general_log.CSV.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.CSM.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.CSV.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_leap_second.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/proc.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_category.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/global_priv.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_topic.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/global_priv.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_relation.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/index_stats.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_category.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/columns_priv.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/procs_priv.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/func.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/plugin.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/servers.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/help_keyword.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition_type.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/servers.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_name.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/db.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition_type.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/column_stats.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/column_stats.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_name.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/event.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/proxies_priv.MAD.
|
[00] 2025-03-13 15:24:49 Skipping ./sys/sys_config.MAI.
|
[00] 2025-03-13 15:24:49 Skipping ./sys/sys_config.MAD.
|
[00] 2025-03-13 15:24:49 Stop scanning common engine tables
|
[00] 2025-03-13 15:24:49 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-13 15:24:49 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 0 bytes
|
[00] 2025-03-13 15:24:49 Start scanning common engine tables, need backup locks: 1, collect log and stat tables: 0
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/general_log.CSM.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/general_log.CSV.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.CSM.
|
[00] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.CSV.
|
[00] 2025-03-13 15:24:49 Stop scanning common engine tables
|
[00] 2025-03-13 15:24:49 Starting to backup non-InnoDB tables and files
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/db.opt.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
... other skipped tables
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Copying ./database2/backend_users.frm to /bitnami/mariadb/backup_20250313_142438/database2/backend_users.frm
|
[01] 2025-03-13 15:24:49 ...done
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
... other skipped tables
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./database2/<tablename>.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/innodb_index_stats.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/innodb_table_stats.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_allowlist.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/transaction_registry.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_cluster.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_cluster_members.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_streaming_log.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/innodb_index_stats.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_leap_second.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/proxies_priv.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_keyword.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/procs_priv.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/table_stats.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/tables_priv.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/roles_mapping.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_topic.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/func.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/proc.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/roles_mapping.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/event.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/db.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_category.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_topic.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/event.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/index_stats.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/table_stats.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/table_stats.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/proc.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_leap_second.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/tables_priv.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_relation.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/tables_priv.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/db.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/plugin.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/columns_priv.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/columns_priv.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/general_log.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/general_log.CSM.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/general_log.CSV.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.CSM.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/slow_log.CSV.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_leap_second.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/roles_mapping.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_relation.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/proc.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_category.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/index_stats.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/global_priv.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_topic.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/global_priv.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/global_priv.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/gtid_slave_pos.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_keyword.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_relation.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/innodb_table_stats.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/index_stats.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_category.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/columns_priv.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/procs_priv.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/func.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/transaction_registry.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/func.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/plugin.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/servers.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/servers.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/help_keyword.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition_type.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/servers.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_name.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_cluster.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_cluster_members.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_streaming_log.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/wsrep_allowlist.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/proxies_priv.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/plugin.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_name.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/db.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_transition_type.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/column_stats.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/column_stats.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/time_zone_name.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/event.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/procs_priv.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/column_stats.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/proxies_priv.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/user.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./mysql/gtid_slave_pos.ibd.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/session.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/version.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/sys_config.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/sys_config.MAI.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/sys_config.MAD.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/innodb_buffer_stats_by_schema.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_table_statistics.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024innodb_buffer_stats_by_schema.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024statements_with_sorting.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/innodb_buffer_stats_by_table.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024schema_table_statistics.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024innodb_buffer_stats_by_table.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/host_summary.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/innodb_lock_waits.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/host_summary_by_stages.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024innodb_lock_waits.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024host_summary.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_object_overview.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/user_summary_by_file_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_auto_increment_columns.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024statements_with_temp_tables.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024schema_flattened_keys.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/waits_by_user_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_redundant_indexes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/user_summary_by_file_io_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/ps_check_lost_instrumentation.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024processlist.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/latest_file_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/waits_by_host_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024latest_file_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/waits_global_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/io_by_thread_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024user_summary_by_file_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024io_by_thread_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/user_summary_by_statement_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/io_global_by_file_by_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024user_summary_by_stages.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024io_global_by_file_by_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/user_summary_by_statement_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/io_global_by_file_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_table_statistics_with_buffer.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024io_global_by_file_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/user_summary_by_stages.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/io_global_by_wait_by_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/user_summary.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024io_global_by_wait_by_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024user_summary.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/io_global_by_wait_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024schema_table_lock_waits.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024io_global_by_wait_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/host_summary_by_file_io_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/memory_by_user_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/statement_analysis.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024memory_by_user_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/host_summary_by_file_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/memory_by_host_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024statement_analysis.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024memory_by_host_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/statements_with_errors_or_warnings.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/memory_by_thread_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024statements_with_errors_or_warnings.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024memory_by_thread_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/host_summary_by_statement_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/memory_global_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/statements_with_full_table_scans.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024memory_global_by_current_bytes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/metrics.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/memory_global_total.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024host_summary_by_file_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024memory_global_total.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_index_statistics.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/host_summary_by_statement_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024schema_index_statistics.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024statements_with_full_table_scans.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024ps_schema_table_statistics_io.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_unused_indexes.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024schema_table_statistics_with_buffer.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024ps_digest_avg_latency_distribution.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_tables_with_full_table_scans.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/schema_table_lock_waits.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024schema_tables_with_full_table_scans.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/processlist.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/statements_with_sorting.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024ps_digest_95th_percentile_by_avg_us.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/statements_with_runtimes_in_95th_percentile.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024user_summary_by_file_io_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/db.opt.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/statements_with_temp_tables.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024statements_with_runtimes_in_95th_percentile.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024user_summary_by_statement_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024user_summary_by_statement_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024host_summary_by_file_io_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024host_summary_by_statement_type.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024host_summary_by_statement_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024host_summary_by_stages.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/wait_classes_global_by_avg_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024wait_classes_global_by_avg_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/wait_classes_global_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024wait_classes_global_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024waits_by_user_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024waits_by_host_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024waits_global_by_latency.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/x@0024session.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./sys/session_ssl_status.frm.
|
[01] 2025-03-13 15:24:49 Skipping ./performance_schema/db.opt.
|
[00] 2025-03-13 15:24:49 Finished backing up non-InnoDB tables and files
|
[00] 2025-03-13 15:24:49 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-13 15:24:49 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 0 bytes
|
[00] 2025-03-13 15:24:49 BACKUP STAGE BLOCK_COMMIT
|
[00] 2025-03-13 15:24:49 mariabackup: The latest check point (for incremental): '75328159389373'
|
[00] 2025-03-13 15:24:49 Waiting for log copy thread to read lsn 18446744073709551615
|
[00] 2025-03-13 15:24:54 Start copying statistics aria tables.
|
[00] 2025-03-13 15:24:54 Stop copying statistics aria tables.
|
[00] 2025-03-13 15:24:54 Start copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001
|
[00] 2025-03-13 15:24:54 Stop copying aria log file tail: /bitnami/mariadb/data//aria_log.00000001, copied 8192 bytes
|
[00] 2025-03-13 15:24:54 Writing mariadb_backup_binlog_info
|
[00] 2025-03-13 15:24:54 ...done
|
[00] 2025-03-13 15:24:54 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
|
[00] 2025-03-13 15:24:54 BACKUP STAGE END
|
[00] 2025-03-13 15:24:54 Executing BACKUP STAGE END
|
[00] 2025-03-13 15:24:54 All tables unlocked
|
[00] 2025-03-13 15:24:54 Backup created in directory '/bitnami/mariadb/backup_20250313_142438/'
|
[00] 2025-03-13 15:24:54 MySQL binlog position: filename 'mysql-bin.000110', position '87916611', GTID of the last change '0-15-4988138098'
|
[00] 2025-03-13 15:24:54 Writing backup-my.cnf
|
[00] 2025-03-13 15:24:54 ...done
|
[00] 2025-03-13 15:24:54 Writing mariadb_backup_info
|
[00] 2025-03-13 15:24:54 ...done
|
[00] 2025-03-13 15:24:54 Redo log (from LSN 75328159389373 to 75328241449372) was copied.
|
[00] 2025-03-13 15:24:54 completed OK!
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$ cp /bitnami/mariadb/backup_20250313_142438/ib_logfile0 /bitnami/mariadb/backup_20250313_142438/ib_logfile0_before_prepare
|
dockeruser@8098044b4c85:/bitnami/mariadb$ mariadb-backup --prepare --export --target-dir=/bitnami/mariadb/backup_20250313_142438
|
mariadb-backup based on MariaDB server 11.4.5-MariaDB Linux (x86_64)
|
[00] 2025-03-13 14:25:34 mariabackup: auto-enabling --innodb-file-per-table due to the --export option
|
[00] 2025-03-13 14:25:34 cd to /bitnami/mariadb/backup_20250313_142438/
|
[00] 2025-03-13 14:25:34 open files limit requested 0, set to 1048576
|
[00] 2025-03-13 14:25:34 This target seems to be not prepared yet.
|
[00] 2025-03-13 14:25:34 mariabackup: using the following InnoDB configuration for recovery:
|
[00] 2025-03-13 14:25:34 innodb_data_home_dir = .
|
[00] 2025-03-13 14:25:34 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2025-03-13 14:25:34 innodb_log_group_home_dir = .
|
[00] 2025-03-13 14:25:34 InnoDB: Using Linux native AIO
|
[00] 2025-03-13 14:25:34 Starting InnoDB instance for recovery.
|
[00] 2025-03-13 14:25:34 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
|
2025-03-13 14:25:34 0 [Note] InnoDB: Compressed tables use zlib 1.2.13
|
2025-03-13 14:25:34 0 [Note] InnoDB: Number of transaction pools: 1
|
2025-03-13 14:25:34 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2025-03-13 14:25:34 0 [Note] InnoDB: Using Linux native AIO
|
2025-03-13 14:25:34 0 [Note] InnoDB: Initializing buffer pool, total size = 100.000MiB, chunk size = 100.000MiB
|
2025-03-13 14:25:34 0 [Note] InnoDB: Completed initialization of buffer pool
|
2025-03-13 14:25:34 0 [Note] InnoDB: Memory-mapped log (block size=512 bytes)
|
2025-03-13 14:25:34 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=75328159389373
|
2025-03-13 14:25:34 0 [Note] InnoDB: Multi-batch recovery needed at LSN 75328213916536
|
2025-03-13 14:25:34 0 [Note] InnoDB: End of log at LSN=75328241449372
|
2025-03-13 14:25:34 0 [ERROR] InnoDB: Missing FILE_CREATE, FILE_DELETE or FILE_MODIFY before FILE_CHECKPOINT for tablespace 785882
|
[00] 2025-03-13 14:25:34 mariadb-backup: srv_start() returned 37 (Data structure corruption).
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$ od -Ax -t x1 -N 0x3000 backup_20250313_142438/ib_logfile0
|
000000 50 68 79 73 00 00 00 00 00 00 44 82 b4 2e 96 bd
|
000010 42 61 63 6b 75 70 20 31 31 2e 34 2e 35 00 00 00
|
000020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
0001f0 00 00 00 00 00 00 00 00 00 00 00 00 f3 53 67 4e
|
000200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001000 00 00 44 82 b4 2e 96 bd 00 00 44 82 b8 84 65 19
|
001010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001030 00 00 00 00 00 00 00 00 00 00 00 00 81 a0 dc b8
|
001040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
003000
|
dockeruser@8098044b4c85:/bitnami/mariadb$ wc -c backup_20250313_142438/ib_logfile0
|
82072287 backup_20250313_142438/ib_logfile0
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$ od -Ax -t x1 -N 0x3000 backup_20250313_142438/ib_logfile0_before_prepare
|
000000 50 68 79 73 00 00 00 00 00 00 44 82 b4 2e 96 bd
|
000010 42 61 63 6b 75 70 20 31 31 2e 34 2e 35 00 00 00
|
000020 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
0001f0 00 00 00 00 00 00 00 00 00 00 00 00 f3 53 67 4e
|
000200 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001000 00 00 44 82 b4 2e 96 bd 00 00 44 82 b8 84 65 19
|
001010 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
001030 00 00 00 00 00 00 00 00 00 00 00 00 81 a0 dc b8
|
001040 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
|
*
|
003000
|
dockeruser@8098044b4c85:/bitnami/mariadb$ wc -c backup_20250313_142438/ib_logfile0_before_prepare
|
82072287 backup_20250313_142438/ib_logfile0_before_prepare
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
dockeruser@8098044b4c85:/bitnami/mariadb$
|
Is there anything I can do to provide further support?
Thank you for the feedback.
The other day, thiru suspected that this might share a root cause with MDEV-36304. Related to that ticket, we identified a few problems:
- These messages can be misleading, because the log records may actually be present, but only the corresponding .ibd files cannot be found.
- When preparing a partial backup, the messages must be suppressed, because it is to be expected that some files are missing.
- The backup metadata only includes information that it was a partial backup, but not the file name exclusion or inclusion patterns. So, we won’t know if a missing file was supposed to be included. (I would not fix this, because it would require a change to the metadata format, which could break things when preparing or restoring backups with an older tool.)
Based on my previous analysis, I would not yet be ready to conclude that this report and MDEV-36304 are duplicating each other. In any case, I will let thiru analyze this deeper.
tobias.bhn, thank you for your report. I’m afraid that I would need a reproducible test case in order to diagnose and fix this. The reason for this failure could be anything, including currently unknown race condition in the log checkpoint logic, something similar to
MDEV-28043. Our internal stress tests cover crash recovery and backups, and I am not currently aware of any internally reproduced bugs like this.Are there any messages in the server error log? Is there any correlation between the size of the ib_logfile0 produced by --backup and a failure? What is the configured innodb_log_file_size on the server?
You could try if forcing a checkpoint before starting the backup (see
MDEV-30000for hints how to do that) makes this failure less frequent.Side note (to danblack): According to the above output, an invocation of mariadb-backup seems to wrongly complain about a deprecated program name mysqld. This seems to be something that would need to be fixed, possibly in extra/mariabackup/xtrabackup.cc.