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-issue-importer opened this issue Jan 17, 2008 · 7 comments
Closed

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

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

Comments

@firebird-issue-importer

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-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 17, 2008

Commented by: @romansimakov

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 28, 2008

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 23, 2008

Modified by: @romansimakov

timeestimate: 86400 [ 86400 ] =>

timeoriginalestimate: 86400 [ 86400 ] =>

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 16, 2009

Modified by: @romansimakov

assignee: Roman Simakov [ roman-simakov ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Mar 17, 2009

Modified by: @romansimakov

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

resolution: Fixed [ 1 ]

Fix Version: 2.5 Beta 1 [ 10251 ]

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Nov 8, 2009

Modified by: @pcisar

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

@firebird-issue-importer
Copy link
Author

@firebird-issue-importer firebird-issue-importer commented Jan 19, 2016

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
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
2 participants