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
AV in Classic server after long idle period when using long running read committed readonly transaction [CORE911] #1310
Comments
Commented by: @hvlad Attached source of delphi console application demonstrated the bug To reproduce - compile, open command prompt, set ISC_USER and ISC_PASSWORD environment variables and run compiled binary. It have only parameter - connect string to database (which is about to be create). I.e : cmd WI-V6.3.2.4731 Firebird 1.5 |
Modified by: @hvladAttachment: Tip_AV.dpr [ 10124 ] |
Modified by: @hvladstatus: Open [ 1 ] => In Progress [ 3 ] |
Modified by: @hvladstatus: In Progress [ 3 ] => Open [ 1 ] |
Modified by: @hvladstatus: Open [ 1 ] => Resolved [ 5 ] resolution: Fixed [ 1 ] Fix Version: 2.0 RC5 [ 10071 ] |
Modified by: @dyemanovFix Version: 1.5.4 [ 10100 ] |
Commented by: @pmakowski Q/A tested ok |
Modified by: @pmakowskistatus: Resolved [ 5 ] => Closed [ 6 ] |
Commented by: @AlexPeshkoff Testcase using firebird public API. |
Modified by: @AlexPeshkoffAttachment: Tip_AV.cpp [ 10730 ] |
Modified by: @AlexPeshkoff |
Modified by: @pcisarWorkflow: jira [ 11179 ] => Firebird [ 15020 ] |
Modified by: @pavel-zotovQA Status: No test |
Submitted by: @hvlad
Relate to CORE1657
Attachments:
Tip_AV.cpp
Tip_AV.dpr
TIP cache used by read committed transactions can have an gaps in it if CS process have an long idle period and opened read committed readonly transaction. When process awakens and that transaction perform some operation AV can occurs
To make it happen we need 4 conditions to meet together:
1. Classic server.
2. Read committed readonly transactions.
3. Client which has long running read committed readonly transactions.
4. Idle period long enough to OIT can advanced by some TIP pages by another processes
Commits: e3962ab 99d7c71 b4b0488
The text was updated successfully, but these errors were encountered: