Details
-
Bug
-
Status: Needs Feedback (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
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?
If you can configure innodb_encrypt_log=ON, in this
MDEV-14425log 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.