Recovery process may hang when tablespaces are deleted during the recovery

Bug #589639 reported by Yasufumi Kinoshita
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona Server moved to https://jira.percona.com/projects/PS
Fix Released
High
Unassigned
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Fix Released
High
Unassigned
Percona-XtraDB
Fix Released
High
Unassigned

Bug Description

The previous bug
http://bugs.mysql.com/bug.php?id=43948
"recv_apply_hashed_log_recs() may hang up when meets DB_TABLESPACE_DELETED pages"
was already fixed.

But InnoDB Plugin/XtraDB should fix also the following part.
(xtrabackup should based on the fix)

buf0rea.c:
buf_read_recv_pages()

        zip_size = fil_space_get_zip_size(space);

        if (UNIV_UNLIKELY(zip_size == ULINT_UNDEFINED)) {
                /* It is a single table tablespace and the .ibd file is
                missing: do nothing */

                return;
        }

Related branches

Changed in percona-server:
importance: Undecided → Medium
importance: Medium → High
Changed in percona-xtrabackup:
importance: Undecided → High
Changed in percona-server:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
Changed in percona-xtrabackup:
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
Changed in percona-server:
status: New → Triaged
milestone: none → 5.1-11.1
Changed in percona-xtrabackup:
status: New → Triaged
milestone: none → 1.3
Changed in percona-server:
milestone: 5.1-11.1 → 5.1-11.0
Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

The previous XtraDB also should be fixed for xtrabackup (XtraDB-1.0.6 based version).

Changed in percona-xtradb:
importance: Undecided → High
assignee: nobody → Yasufumi Kinoshita (yasufumi-kinoshita)
Changed in percona-xtradb:
status: New → Fix Committed
Changed in percona-server:
status: Triaged → Fix Committed
Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :
Changed in percona-xtrabackup:
status: Triaged → Fix Committed
Revision history for this message
Yasufumi Kinoshita (yasufumi-kinoshita) wrote :

Don't forget to use the fixed lp:~percona-dev/percona-xtradb/extensions-1.0.6 , if you build with XtraDB-1.0.6

Changed in percona-server:
status: Fix Committed → Fix Released
Changed in percona-xtrabackup:
status: Fix Committed → Fix Released
Revision history for this message
Stewart Smith (stewart) wrote :

All development of XtraDB has moved under the Percona Server project - https://launchpad.net/percona-server - If this bug can be reproduced against current Percona Server, please file this bug against percona-server (you can simply do so by using the "Also affects project" link above).

Thanks,
Stewart Smith
Director of Server Development
Percona.

Changed in percona-xtradb:
status: Fix Committed → Fix Released
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-280

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-413

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.