'Waiting for copy thread to read lsn (Mariabackup infinite, loop, innodb)

I have a problem only in remote backups (local backups run perfectly!)

I search information about this and i dont find much information or solutions!

There are no problems when the remote backup starts, until the infinite loop arrives !

I use Debian 11 and the mysql version is this:

mysql Ver 15.1 Distrib 10.5.15-MariaDB, for debian-linux-gnu (x86_64)

I run this script for remote backup in my machine to the other machine (i use vitualbox for testing):

mariabackup --backup --host=10.0.0.158 --port=3306 --target-dir=/home/martinezta/mariabackup/backup_remoto1 --user=root --password=P@ssw0rd

Beggining

The infinite Loop

I stopped because its infinite...

Configuration

[MYSQL / MARIADB]

`mysql -u root –password=P@ssw0rd

CREATE USER [email protected] IDENTIFIED BY ‘P@ssw0rd’ ;

GRANT ALL PRIVILEGES ON * .* TO [email protected];

FLUSH PRIVILEGES ;`

`nano /etc/mysql/mariadb.cnf/ [or] nano /etc/mysql/my.cnf

port = 3306`

`nano /etc/mysql/mariadb.conf.d/50-server.cnf

bind-address = 0.0.0.0`

testing configuration

I try with this configuration, and more combinations, i can't resolve my problem with this :(

nano /etc/mysql/mariadb.conf.d/50-server.cnf

`[mysqld]

innodb_io_capacity = 3000

innodb_buffer_pool_size = 3G

innodb_buffer_pool_instances = 3

innodb_flush_method = O_DIRECT

Logs

log-error = /var/log/mysql/error.log

slow_query_log = 1

slow_query_log_file = /var/log/mysql/mysql-slow.log

long_query_time = 5`

MYSQL ENGINE INNODB STATUS

Show engine innodb srtatus;

LOG

If anyone can resolve my problem, thanks!



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source