Details
-
Task
-
Status: Open (View Workflow)
-
Minor
-
Resolution: Unresolved
Description
Can we hide following [Info] logging understood that helpful if there is any issue with the DDL recovery.
Found with one use case of self-referencing foreign keys, logging as below with mariabackup at --prepare stage, which is confusing, though understand that such logging has not got any affect to the backup it captures.
[Note]InnoDB: At LSN: xxxx : unable to open file /xxx/xx.ibd for tablespace xx |
|
mariabackup log:
[root@sparenode4 ~]# mariabackup --prepare --target-dir=/backup/
|
mariabackup based on MariaDB server 10.11.9-MariaDB Linux (x86_64)
|
[00] 2024-09-10 13:26:49 cd to /backup/
|
[00] 2024-09-10 13:26:49 open files limit requested 0, set to 1024
|
[00] 2024-09-10 13:26:49 This target seems to be not prepared yet.
|
[00] 2024-09-10 13:26:49 mariabackup: using the following InnoDB configuration for recovery:
|
[00] 2024-09-10 13:26:49 innodb_data_home_dir = .
|
[00] 2024-09-10 13:26:49 innodb_data_file_path = ibdata1:12M:autoextend
|
[00] 2024-09-10 13:26:49 innodb_log_group_home_dir = .
|
[00] 2024-09-10 13:26:49 InnoDB: Using Linux native AIO
|
[00] 2024-09-10 13:26:49 Starting InnoDB instance for recovery.
|
[00] 2024-09-10 13:26:49 mariabackup: Using 104857600 bytes for buffer pool (set by --use-memory parameter)
|
2024-09-10 13:26:49 0 [Note] InnoDB: Compressed tables use zlib 1.2.7
|
2024-09-10 13:26:49 0 [Note] InnoDB: Number of transaction pools: 1
|
2024-09-10 13:26:49 0 [Note] InnoDB: Using crc32 + pclmulqdq instructions
|
2024-09-10 13:26:49 0 [Note] InnoDB: Using Linux native AIO
|
2024-09-10 13:26:49 0 [Note] InnoDB: Initializing buffer pool, total size = 100.000MiB, chunk size = 100.000MiB
|
2024-09-10 13:26:49 0 [Note] InnoDB: Completed initialization of buffer pool
|
2024-09-10 13:26:49 0 [Note] InnoDB: Buffered log writes (block size=512 bytes)
|
2024-09-10 13:26:49 0 [Note] InnoDB: Starting crash recovery from checkpoint LSN=124507
|
2024-09-10 13:26:49 0 [Note] InnoDB: At LSN: 125042: unable to open file ./TEST/t.ibd for tablespace 12
|
2024-09-10 13:26:49 0 [Note] InnoDB: At LSN: 126811: unable to open file ./TEST/#sql-alter-8b5-7.ibd for tablespace 13
|
2024-09-10 13:26:49 0 [Note] InnoDB: At LSN: 128944: unable to open file ./TEST/#sql-backup-8b5-7.ibd for tablespace 12
|
2024-09-10 13:26:49 0 [Note] InnoDB: At LSN: 130590: unable to open file ./TEST/t.ibd for tablespace 13
|
2024-09-10 13:26:49 0 [Note] InnoDB: End of log at LSN=134524
|
2024-09-10 13:26:49 0 [Note] InnoDB: To recover: 22 pages
|
[00] 2024-09-10 13:26:49 Last binlog file , position 0
|
[00] 2024-09-10 13:26:49 completed OK!
|
|