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

Deadlock in LM by using nbackup utility [CORE1696] #2121

Closed
firebird-automations opened this issue Jan 17, 2008 · 7 comments
Closed

Deadlock in LM by using nbackup utility [CORE1696] #2121

firebird-automations opened this issue Jan 17, 2008 · 7 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @romansimakov

Deadlock description: Process A inserts records into a table. It keeps LCK_read lock on LCK_backup_database and can fetch other pages since NBackupState use recursive locks. So process A calls FETCH_LOCK for a page (for example PP) and waits it if a process B already uses this page. On the other hand process B can have called FETCH_LOCK and must read the page from disk. To do this it must request LCK_backup_database with LCK_read level for status receiving. In this case process B have to wait if third process N already request LCK_backup_database with LCK_write level.

Commits: 1a49498

@firebird-automations
Copy link
Collaborator Author

Commented by: @romansimakov

To resolve the problem nbackup must have an order of lock requesting for LCK_bdb and LCK_backup_database.

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

Workflow: jira [ 13831 ] => Firebird [ 14128 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @romansimakov

timeestimate: 86400 [ 86400 ] =>

timeoriginalestimate: 86400 [ 86400 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: @romansimakov

assignee: Roman Simakov [ roman-simakov ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @romansimakov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pcisar

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

@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
Projects
None yet
Development

No branches or pull requests

2 participants