[MDEV-30144] Incremental prepare fails when innodb_undo_tablespaces > 0 Created: 2022-12-02  Updated: 2022-12-05  Resolved: 2022-12-02

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - InnoDB
Affects Version/s: 10.5, 10.6, 10.7, 10.8, 10.9, 10.10, 10.11
Fix Version/s: 10.11.2, 10.5.19, 10.6.12, 10.7.8, 10.8.7, 10.9.5, 10.10.3

Type: Bug Priority: Critical
Reporter: Thirunarayanan Balathandayuthapani Assignee: Thirunarayanan Balathandayuthapani
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Blocks
blocks MDEV-29986 Set innodb_undo_tablespaces=3 by default Closed

 Description   

In windows, Mariabackup incremental prepare fails to open undo tablespaces while applying
the delta file. It leads to failure of incremental prepare.

Scenario:
========

perl mysql-test-run.pl mariabackup.incremental_encrypted --mysqld=--innodb_undo_tablespaces=0

Problem is that backup opens the undo tablespaces in srv_undo_tablespaces_init() and it tries
to open again while applying the delta, but later is in conflicting mode and it leads to
the failure. we found out while testing MDEV-29986. Thanks to wlad for debugging the windows failure.

 Comments   
Comment by Thirunarayanan Balathandayuthapani [ 2022-12-02 ]

Patch is in bb-10.5-MDEV-30114

Comment by Marko Mäkelä [ 2022-12-02 ]

Thank you. I suspect that this was broken between 10.5.6 and 10.5.7 by MDEV-23855 or MDEV-23399.

Comment by Thirunarayanan Balathandayuthapani [ 2022-12-02 ]

It is broken from 10.5.4. Sorry, this issue has been pushed wrongly as different MDEV-30114.

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