# Xtrabackup render the DB unreadable with locks even with no-lock option

**URL:** <https://forums.percona.com/t/xtrabackup-render-the-db-unreadable-with-locks-even-with-no-lock-option/21448>\
**Category:** Percona XtraBackup\
**Tags:** percona\
**Created:** [April 18, 2023, 3:48am UTC](https://forums.percona.com/t/xtrabackup-render-the-db-unreadable-with-locks-even-with-no-lock-option/21448 "2023-04-18T03:48:17Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Minh\_Duc\_Nguyen](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/minh_duc_nguyen/32/9968_2.png) [@Minh\_Duc\_Nguyen](https://forums.percona.com/u/Minh_Duc_Nguyen)\
**Post date:** [April 18, 2023, 3:48am UTC](https://forums.percona.com/t/xtrabackup-render-the-db-unreadable-with-locks-even-with-no-lock-option/21448/1 "2023-04-18T03:48:17Z")

</div>

I have a Percona MySQL 8.0.25 single instance DB.

I am storing an alert table where I insert and pool data from it every 10 seconds for new alerts.

I ran xtrabackup against it and my querier service hang, no query can complete. On the monitoring the Database Throughput drop to 0 and all query related stats drop to 0 indicating that while xtrabackup is running I cannot query the DB.

Xtrabackup version 8.0.32  
Percona version 8.0.25

I ran xtrabackup with no-lock, excluding all non-innodb tables and throttle 1 and it still block reading to the DB.

Why does backup has to block reading or impose any lock that block reading?

---

<div class="post-metadata">

**Author:** ![kedarpercona](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/kedarpercona/32/809_2.png) [@kedarpercona](https://forums.percona.com/u/kedarpercona)\
**Post date:** [April 18, 2023, 8:47am UTC](https://forums.percona.com/t/xtrabackup-render-the-db-unreadable-with-locks-even-with-no-lock-option/21448/2 "2023-04-18T08:47:18Z")

</div>

Can you post your command?

---

<div class="post-metadata">

**Author:** ![Michael\_Coburn](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/michael_coburn/32/18_2.png) [@Michael\_Coburn](https://forums.percona.com/u/Michael_Coburn)\
**Post date:** [April 18, 2023, 2:59pm UTC](https://forums.percona.com/t/xtrabackup-render-the-db-unreadable-with-locks-even-with-no-lock-option/21448/3 "2023-04-18T14:59:02Z")

</div>

Hi @Minh_Duc_Nguyen welcome to the Percona forums!

As @kedarpercona mentioned, we’d like to see your command line used to start the backup. Also can you give us a capture of `SHOW PROCESSLIST` while the backup is running? Thanks