Howyd Ragul, > Hi team, > > I have facing a replication issue in my DB setup where we have a master-slave > server and replication is ON between > the servers. > > Environment: MariaDB 10.6.11 > DB size: approx. 1TB > > While taking mariabackup, at the stage of preparing backup I see some > interpretation in replication which I can see > in MySQL logs. Backup was successful but the replication is not catching up > with the master and able to see the > slave worker are getting stuck forever (as per Processlist). Even if we stop > the slave SQL thread or stop slave not > fixing the issue. (WIthout backup process the replication is working > fine without any delays)
By the show-processlist I could suspect MDEV-30780 optimistic parallel slave hangs after hit an error If you can reproduce it, could you please file a Jira https://jira.mariadb.org/ ticket to include 1. mysqlbinlog output of the replication events (you may need a master binlog for that) being executed by all workers at that time (find the last executed through Show-Slave-Status, or @@global.gtid_slave_pos). 2. slave error log 3. execute on slave gdb -ex 'set height 0' -ex 'thread apply all backtrace' -p "find yourself mariadb-pid" > | 704638 | system user | | NULL | Slave_worker | 113000 > | Waiting for prior transaction to commit | NULL | > 0.000 | > | 704639 | system user | | NULL | Slave_worker | 113000 > | closing tables | NULL | > 0.000 | > | 704641 | system user | | NULL | Slave_worker | 113000 > | Waiting for prior transaction to commit | NULL | > 0.000 | To > Replication as a Backup Solution - MariaDB Knowledge Base as per the page > "Running the backup from a slave has the > advantage of being able to shutdown or lock the slave and perform a backup > without any impact on the primary > server." > Does it mean running a backup in a slave might impact the replication? Not really. The sentance merely says the master server performance won't be affected when one takes backup on the slave. > If this is expected behavior, do we have any > proper way to achieve a backup on a daily basis in the replication server? > > Or The backup is not the problem and some other factor (like a deadlock) is > affecting the slave thread to lock? > I would think of deadlock. Cheers, Andrei _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
