Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.5.9, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5, 10.6
-
CentOS 7
Description
Hi,
I do a daily "snapshot" restore of my daily backup performed by MariaBackup.
I've just noticed that I see *LOADS* of messages like:
Ignoring data file 'database1/table1.ibd' with space ID 25508, since the redo log references database1/table1.ibd with space ID 25506.
On tables that some jobs perform a "RENAME TABLE", to swap with a new version of them.
I've been seeing this since very long ago, but became more noticeable now that there is a job that does "RENAME TABLE" every 5 minutes.
Is this normal?
Does this mean anything bad to the database or backups? Or to the 'restored' database?
Is there any risk of corruption because of this, or loss of data/tables?
Thank you.
Attachments
Issue Links
- relates to
-
-
- Open
-
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
Hi,
I do a daily "snapshot" restore of my daily backup performed by MariaBackup. I've just noticed that I see **LOADS** of messages like: > Ignoring data file 'database1/table1.ibd' with space ID 25508, since the redo log references database1/table1.ibd with space ID 25506. On tables that some jobs perform a "RENAME TABLE", to swap with a new version of them. I've been seeing this since very long ago, but became more noticeable now that there is a job that does "RENAME TABLE" every 5 minutes. Is this normal? Does this mean anything bad to the database or backups? Or to the 'restored' database? Is there any risk of corruption because of this, or loss of data/tables? Thank you. |
Hi,
I do a daily "snapshot" restore of my daily backup performed by MariaBackup. I've just noticed that I see **LOADS** of messages like: {quote}Ignoring data file 'database1/table1.ibd' with space ID 25508, since the redo log references database1/table1.ibd with space ID 25506.{quote} On tables that some jobs perform a "RENAME TABLE", to swap with a new version of them. I've been seeing this since very long ago, but became more noticeable now that there is a job that does "RENAME TABLE" every 5 minutes. Is this normal? Does this mean anything bad to the database or backups? Or to the 'restored' database? Is there any risk of corruption because of this, or loss of data/tables? Thank you. |
| Component/s | mariabackup [ 14500 ] |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Affects Version/s | 10.2 [ 14601 ] | |
| Affects Version/s | 10.3 [ 22126 ] | |
| Affects Version/s | 10.4 [ 22408 ] | |
| Affects Version/s | 10.5 [ 23123 ] | |
| Affects Version/s | 10.6 [ 24028 ] | |
| Assignee | Marko Mäkelä [ marko ] | |
| Labels | upstream |
| issue.field.resolutiondate | 2021-04-30 07:03:02.0 | 2021-04-30 07:03:02.479 |
| Fix Version/s | 10.2.38 [ 25207 ] | |
| Fix Version/s | 10.3.29 [ 25206 ] | |
| Fix Version/s | 10.4.19 [ 25205 ] | |
| Fix Version/s | 10.5.10 [ 25204 ] | |
| Fix Version/s | 10.6.1 [ 24437 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.3 [ 22126 ] | |
| Fix Version/s | 10.4 [ 22408 ] | |
| Fix Version/s | 10.5 [ 23123 ] | |
| Fix Version/s | 10.6 [ 24028 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | Open [ 1 ] | Closed [ 6 ] |
| Link | This issue relates to MDEV-25909 [ MDEV-25909 ] |
| Workflow | MariaDB v3 [ 121546 ] | MariaDB v4 [ 159226 ] |