Issue Details (XML | Word | Printable)

Key: CORE-5307
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Dmitry Yemanov
Reporter: Boltik Evgeny
Votes: 0
Watchers: 2

If you were logged in you would be able to see more operations.
Firebird Core

Random "invalid transaction handle" errors are returned from the engine

Created: 12/Jul/16 07:36 PM   Updated: 30/Jul/16 04:57 AM
Component/s: API / Client Library, Engine
Affects Version/s: 4.0 Initial, 3.0.0
Fix Version/s: 3.0.1, 4.0 Alpha 1

QA Status: Not enough information

 Description  « Hide
Sometimes (almost randomly) DML statement running in a valid transaction context may fail with "invalid transaction handle" error. All subsequent usage of the same transaction handle (including attempt to rollback) raise the same error. The issue manifests itself only when user-defined temporary blobs are involved in DML operations.

 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Boltik Evgeny added a comment - 29/Jul/16 06:48 PM
I tested from 15 to 21 June on the test server.
From 22 June to 3 working servers is no problem.

Pavel Zotov added a comment - 29/Jul/16 07:21 PM
Simple test case will be greatly appreciated.

BTW: number of attachments ? FB architecture and other config settings ?

Boltik Evgeny added a comment - 30/Jul/16 04:57 AM
Basically the problem was manifested in PHP with pconnect and write blobs. In normal operation, the error appeared rarely and we could not understand why.
Mini test example no.
For playback, I connected the database DY and he caught the error.