[MDEV-29631] Mariabackup blocks connections until it ends Created: 2022-09-25  Updated: 2022-09-26  Resolved: 2022-09-26

Status: Closed
Project: MariaDB Server
Component/s: N/A
Affects Version/s: 10.8.5
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: acsfer Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: None

Issue Links:
Duplicate
duplicates MDEV-28772 Mariabackup locks database for minute... Closed

 Description   

Once backup reaches the "Waiting for copy thread to read lsn" step (it can take several minutes to complete this step) connections can't reach the server, resulting in application downtime until backups ends.

Command:

mariabackup --backup --user=root --no-version-check --socket=/run/mysqld/mysqld.sock --open-files-limit=65536 --throttle=50000 --parallel=1 --ftwrl-wait-timeout=300 --ftwrl-wait-threshold=86400 --ftwrl-wait-query-type=update --target-dir=/dev/shm/backup

When the script runs, it CTRL+C is hit, connections are immediately accepted again on MariaDB 10.8.5 server. By connections I mean READ and/or WRITE, as from application point of view, it looks like MariaDB server hangs.

Happy to help debug this (nothing is logged on MariaDB server logs).



 Comments   
Comment by acsfer [ 2022-09-25 ]

Please close as duplicate of MDEV-28772

Generated at Thu Feb 08 10:10:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.