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

Engine could hang up if auto-sweep is starting while database is shutting down [CORE5417] #5690

Closed
firebird-automations opened this issue Dec 11, 2016 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: @hvlad

The issue was reported by Jiří Činčura at fb-devel (26 Sep 2016, " Stuck transaction in 2.5.6") :

https://sourceforge.net/p/firebird/mailman/message/35391555/

Commits: 0c520b8 51cb2c9 d4e6436

====== Test Details ======

Quote from https://sourceforge.net/p/firebird/mailman/message/35391555/

Sending link privately. When that happens again I'll try to take the
dump early.

> PS Stack shows that EXECUTE STATEMENT is used, probably with autonomous
> transactions - it could block itself if used not correctly (for example:
> update record and then update it again in autonomus tx with "wait"
> option)

Any suggestion how to implement test for this ticket ?

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

assignee: Vlad Khorsun [ hvlad ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

Fix Version: 3.0.2 [ 10785 ]

Fix Version: 4.0 Alpha 1 [ 10731 ]

Fix Version: 2.5.7 [ 10770 ]

summary: Engine could hang up if auto-sweep is starting while database is shuttign down => Engine could hang up if auto-sweep is starting while database is shutting down

@firebird-automations
Copy link
Collaborator Author

Modified by: @hvlad

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

resolution: Fixed [ 1 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: @pavel-zotov

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

QA Status: No test => Not enough information

Test Details: Quote from https://sourceforge.net/p/firebird/mailman/message/35391555/

Sending link privately. When that happens again I'll try to take the
dump early.

> PS Stack shows that EXECUTE STATEMENT is used, probably with autonomous
> transactions - it could block itself if used not correctly (for example:
> update record and then update it again in autonomus tx with "wait"
> option)

Any suggestion how to implement test for this ticket ?

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