[MDEV-19492] Mariabackup hangs if table populated with INSERT... SELECT while it runs Created: 2019-05-16 Updated: 2023-10-12 |
|
| Status: | Stalled |
| Project: | MariaDB Server |
| Component/s: | mariabackup |
| Affects Version/s: | 10.2.24, 10.4.14 |
| Fix Version/s: | 10.4 |
| Type: | Bug | Priority: | Major |
| Reporter: | Rick Pizzi | Assignee: | Vladislav Lesin |
| Resolution: | Unresolved | Votes: | 3 |
| Labels: | None | ||
| Attachments: |
|
||||||||||||||||||||||||||||||||||||
| Issue Links: |
|
||||||||||||||||||||||||||||||||||||
| Description |
|
Mariabackup consistently hangs when you load data into a table from another table while a full backup is running. It hangs in the following phase:
Before that, the following errors appear:
This is regularly happening at a customer of ours. 1. start a full backup Command line used for backup:
Isolation level: default (REPEATABLE-READ) |
| Comments |
| Comment by suresh ramagiri [ 2020-07-27 ] |
|
One of the customers reported this issue. Locally on the MariaDB 1O.3.22, I can reproduce the issue. 1. Created two partition tables as below and had some data in the sbtest4 table d1 partition. full backup logs attached - https://jira.mariadb.org/secure/attachment/52967/mariabackup_logs.log CREATE TABLE `sbtest3` ( CREATE TABLE `sbtest4` ( backup logs [00] 2020-07-27 21:50:04 Retrying read of log at LSN=30622709760 |
| Comment by Vladislav Lesin [ 2020-08-17 ] |
|
rpizzi, this looks like a duplicate of |
| Comment by Rick Pizzi [ 2020-08-19 ] |
|
I don't recall which customer was being hit by this bug - this was over one year ago! |
| Comment by Rick Pizzi [ 2020-09-18 ] |
|
vlad.lesin I am not convinced that this bug is a duplicate of |
| Comment by Rick Pizzi [ 2020-09-18 ] |
|
vlad.lesin we retried with 16 GB of redo logs, on this replica with single SQL thread . It still failed So this has become a critical bug as the customer is unable to perform a full backup of its dataset. |
| Comment by Vladislav Lesin [ 2020-09-21 ] |
|
rpizzi yes it will go in 10.4 too. I hope it will be in the next 10.4 upcoming release. And yes, we can create special build for the customer. We need to know customer's platform and the version of MariaDB they use. But for 10.4 the steps to detect the problem, I mentioned above, must work without I.e. if their backup log: (does not contain "Invalid log block checksum." or "xtrabackup_copy_logfile() failed: corrupt log.") and then this is indeed the duplicate of |
| Comment by Julien Fritsch [ 2020-09-24 ] |
|
rpizzi please follow the instructions to create the needed Jira ticket and assign Vlad. https://docs.google.com/document/d/1flTIbF8vJQ7vB2FGHLiECo2DrzhUdgq4UgiKpqEXTjY/edit#heading=h.l24n0d50js1p |
| Comment by Julien Fritsch [ 2020-09-29 ] |
| Comment by Marko Mäkelä [ 2022-05-04 ] |
|
In MDEV-14992 I wrote:
Making the server stream its ib_logfile0 to the backup should be much easier after the format change |