[00] 2025-08-28 02:54:37 Connecting to MariaDB server host: localhost, user: my_db_user, password: set, port: not set, socket: /run/mysqld/mysqld.sock
[00] 2025-08-28 02:54:37 Using server version 11.8.3-MariaDB-ubu2404
mariadb-backup based on MariaDB server 11.8.3-MariaDB debian-linux-gnu (x86_64)
[00] 2025-08-28 02:54:37 uses posix_fadvise().
[00] 2025-08-28 02:54:37 cd to /var/lib/mysql/
[00] 2025-08-28 02:54:37 open files limit requested 0, set to 1024
[00] 2025-08-28 02:54:37 mariabackup: using the following InnoDB configuration:
[00] 2025-08-28 02:54:37 innodb_data_home_dir =
[00] 2025-08-28 02:54:37 innodb_data_file_path = ibdata1:12M:autoextend
[00] 2025-08-28 02:54:37 innodb_log_group_home_dir = ./
2025-08-28  2:54:37 0 [Note] InnoDB: Number of transaction pools: 1
2025-08-28  2:54:37 0 [Note] InnoDB: Using io_uring
2025-08-28  2:54:37 0 [Note] InnoDB: Memory-mapped log (block size=4096 bytes)
[00] 2025-08-28 02:54:37 mariabackup: Generating a list of tablespaces
Skipping db: ./mysql
Skipping db: ./sys
Skipping db: ./test_1
Skipping db: ./test_three
Skipping db: ./performance_schema
Skipping db: ./app1_second
Skipping db: ./app1_first
Skipping db: ./test_2
[00] 2025-08-28 02:54:37 Connecting to MariaDB server host: localhost, user: my_db_user, password: set, port: not set, socket: /run/mysqld/mysqld.sock
[00] 2025-08-28 02:54:37 Retrying read of log at LSN=47763
[00] 2025-08-28 02:54:37 Connecting to MariaDB server host: localhost, user: my_db_user, password: set, port: not set, socket: /run/mysqld/mysqld.sock
[00] 2025-08-28 02:54:37 Starting BACKUP STAGE START
[00] 2025-08-28 02:54:37 Acquiring BACKUP LOCKS...
[00] 2025-08-28 02:54:37 Acquired locks for BACKUP STAGE START
[00] 2025-08-28 02:54:37 Copying /var/lib/mysql//aria_log_control to /home/myuser/mariadb_backup_test/aria_log_control
[00] 2025-08-28 02:54:37         ...done
[00] 2025-08-28 02:54:37 Loading aria_log_control.
[00] 2025-08-28 02:54:37 aria_log_control: last_log_number: 1
[00] 2025-08-28 02:54:37 Start scanning aria tables.
[00] 2025-08-28 02:54:37 Skipping db: ./mysql
[00] 2025-08-28 02:54:37 Skipping db: ./sys
[00] 2025-08-28 02:54:37 Skipping db: ./test_1
[00] 2025-08-28 02:54:37 Skipping db: ./test_three
[00] 2025-08-28 02:54:37 Skipping db: ./performance_schema
[00] 2025-08-28 02:54:37 Skipping db: ./app1_second
[00] 2025-08-28 02:54:37 Skipping db: ./app1_first
[00] 2025-08-28 02:54:37 Skipping db: ./test_2
[00] 2025-08-28 02:54:37 Start scanning aria log files.
[00] 2025-08-28 02:54:37 Found 1 aria log files, minimum log number 1, maximum log number 1
[00] 2025-08-28 02:54:37 Stop scanning aria tables.
[00] 2025-08-28 02:54:37 Copying .//undo001 to /home/myuser/mariadb_backup_test/undo001
[00] 2025-08-28 02:54:37         ...done
[00] 2025-08-28 02:54:37 Copying .//undo002 to /home/myuser/mariadb_backup_test/undo002
[00] 2025-08-28 02:54:37         ...done
[00] 2025-08-28 02:54:37 Copying .//undo003 to /home/myuser/mariadb_backup_test/undo003
[00] 2025-08-28 02:54:37         ...done
[00] 2025-08-28 02:54:37 Copying ibdata1 to /home/myuser/mariadb_backup_test/ibdata1
[00] 2025-08-28 02:54:38         ...done
[00] 2025-08-28 02:54:38 Start copying aria log file tail: /var/lib/mysql//aria_log.00000001
[00] 2025-08-28 02:54:38 Stop copying aria log file tail: /var/lib/mysql//aria_log.00000001, copied 409600 bytes
[00] 2025-08-28 02:54:38 Finished BACKUP STAGE START
[00] 2025-08-28 02:54:38 Starting BACKUP STAGE FLUSH
[00] 2025-08-28 02:54:38 Acquired locks for BACKUP STAGE FLUSH
[00] 2025-08-28 02:54:38 Start scanning common engine tables, need backup locks: 0, collect log and stat tables: 1
[00] 2025-08-28 02:54:38 Skipping db: ./mysql
[00] 2025-08-28 02:54:38 Skipping db: ./sys
[00] 2025-08-28 02:54:38 Skipping db: ./test_1
[00] 2025-08-28 02:54:38 Skipping db: ./test_three
[00] 2025-08-28 02:54:38 Skipping db: ./performance_schema
[00] 2025-08-28 02:54:38 Skipping db: ./app1_second
[00] 2025-08-28 02:54:38 Skipping db: ./app1_first
[00] 2025-08-28 02:54:38 Skipping db: ./test_2
[00] 2025-08-28 02:54:38 Stop scanning common engine tables
[00] 2025-08-28 02:54:38 Start copying aria log file tail: /var/lib/mysql//aria_log.00000001
[00] 2025-08-28 02:54:38 Stop copying aria log file tail: /var/lib/mysql//aria_log.00000001, copied 0 bytes
[00] 2025-08-28 02:54:38 Finished BACKUP STAGE FLUSH
[00] 2025-08-28 02:54:38 Started BACKUP STAGE BLOCK_DDL
[00] 2025-08-28 02:54:38 Acquired locks for BACKUP STAGE BLOCK_DDL
[00] 2025-08-28 02:54:38 Start scanning common engine tables, need backup locks: 1, collect log and stat tables: 0
[00] 2025-08-28 02:54:38 Skipping db: ./mysql
[00] 2025-08-28 02:54:38 Skipping db: ./sys
[00] 2025-08-28 02:54:38 Skipping db: ./test_1
[00] 2025-08-28 02:54:38 Skipping db: ./test_three
[00] 2025-08-28 02:54:38 Skipping db: ./performance_schema
[00] 2025-08-28 02:54:38 Skipping db: ./app1_second
[00] 2025-08-28 02:54:38 Skipping db: ./app1_first
[00] 2025-08-28 02:54:38 Skipping db: ./test_2
[00] 2025-08-28 02:54:38 Stop scanning common engine tables
[00] 2025-08-28 02:54:38 Starting to backup non-InnoDB tables and files
[00] 2025-08-28 02:54:38 Skipping db: ./mysql
[00] 2025-08-28 02:54:38 Skipping db: ./sys
[00] 2025-08-28 02:54:38 Skipping db: ./test_1
[00] 2025-08-28 02:54:38 Skipping db: ./test_three
[00] 2025-08-28 02:54:38 Skipping db: ./performance_schema
[00] 2025-08-28 02:54:38 Skipping db: ./app1_second
[00] 2025-08-28 02:54:38 Skipping db: ./app1_first
[00] 2025-08-28 02:54:38 Skipping db: ./test_2
[00] 2025-08-28 02:54:38 Finished backing up non-InnoDB tables and files
[00] 2025-08-28 02:54:38 Start copying aria log file tail: /var/lib/mysql//aria_log.00000001
[00] 2025-08-28 02:54:38 Stop copying aria log file tail: /var/lib/mysql//aria_log.00000001, copied 0 bytes
[00] 2025-08-28 02:54:38 Finished BACKUP STAGE BLOCK_DDL
[00] 2025-08-28 02:54:38 Starting BACKUP STAGE BLOCK_COMMIT
[00] 2025-08-28 02:54:38 Acquired locks for BACKUP STAGE BLOCK_COMMIT
[00] 2025-08-28 02:54:38 mariabackup: The latest check point (for incremental): '47747'
[00] 2025-08-28 02:54:38 Waiting for log copy thread to read lsn 18446744073709551615
[00] 2025-08-28 02:54:43 Start copying statistics aria tables.
[00] 2025-08-28 02:54:43 Stop copying statistics aria tables.
[00] 2025-08-28 02:54:43 Start copying aria log file tail: /var/lib/mysql//aria_log.00000001
[00] 2025-08-28 02:54:43 Stop copying aria log file tail: /var/lib/mysql//aria_log.00000001, copied 8192 bytes
[00] 2025-08-28 02:54:43 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
[00] 2025-08-28 02:54:43 Finishing BACKUP STAGE BLOCK_COMMIT
[00] 2025-08-28 02:54:43 Starting BACKUP STAGE END
[00] 2025-08-28 02:54:43 Executing BACKUP STAGE END
[00] 2025-08-28 02:54:43 All tables unlocked
[00] 2025-08-28 02:54:43 Backup created in directory '/home/myuser/mariadb_backup_test/'
[00] 2025-08-28 02:54:43 Writing backup-my.cnf
[00] 2025-08-28 02:54:43         ...done
[00] 2025-08-28 02:54:43 Writing mariadb_backup_info
[00] 2025-08-28 02:54:43         ...done
[00] 2025-08-28 02:54:43 Redo log (from LSN 47747 to 47763) was copied.
[00] 2025-08-28 02:54:43 completed OK!