Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

NBackup: Page-level deadlock (bugcheck 215) when attempting to lock/backup a database under load [CORE1121] #1542

Closed
firebird-automations opened this issue Feb 6, 2007 · 7 comments
Closed

NBackup: Page-level deadlock (bugcheck 215) when attempting to lock/backup a database under load [CORE1121] #1542

firebird-automations opened this issue Feb 6, 2007 · 7 comments
Assignees
@dyemanov
Labels
affect-version: 2.0.0 component: engine component: nbackup fix-version: 2.0.1 fix-version: 2.1 Alpha 1 priority: major type: bug

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @dyemanov

Is related to QA34

It's easy to reproduce with a stored procedure inserting many rows while nbackup -L is being issued. NBAK owns an EX-lock for the header page and waits for all pages being flushed to disk, but new pages are being marked in parallel and such a long waiting finally becomes a deadlock when the next transaction is going to start (as it also requests an EX-lock for the header page).

Commits: f042dc9 fa80ab8
@firebird-automations
Copy link
Collaborator Author

Modified by: @dyemanov

status: Open [ 1 ] => Resolved [ 5 ]

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Fix Version: 2.1 Alpha 1 [ 10150 ]

Fix Version: 2.1.0 [ 10041 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Link: This issue is related to QA34 [ QA34 ]

@firebird-automations
Copy link
Collaborator Author

Commented by: @pcisar

Fix verified.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

status: Resolved [ 5 ] => Closed [ 6 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 11570 ] => Firebird [ 15100 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

QA Status: No test

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@dyemanov dyemanov

Labels
affect-version: 2.0.0 component: engine component: nbackup fix-version: 2.0.1 fix-version: 2.1 Alpha 1 priority: major type: bug
Projects
None yet
Milestone
No milestone
Development

No branches or pull requests
2 participants
@dyemanov @firebird-automations