Issue Details (XML | Word | Printable)

Key: CORE-5867
Type: Bug Bug
Status: Open Open
Priority: Major Major
Assignee: Unassigned
Reporter: Sorien
Votes: 0
Watchers: 0
Operations

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

Other, Error: invalid BLOB ID, Code: -901 (Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements)

Created: 09/Jul/18 11:24 AM   Updated: 09/Jul/18 01:54 PM
Component/s: API / Client Library
Affects Version/s: 3.0.3, 3.0.4
Fix Version/s: None

Environment: win 32/64

QA Status: No test


 Description  « Hide
probably from commit https://github.com/FirebirdSQL/firebird/commit/c916203cb693abf48016dc0f18d9b3565395986f im getting this error Other, Error: invalid BLOB ID, Code: -901 (Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements)


 All   Comments   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Sorien added a comment - 09/Jul/18 12:36 PM - edited
we are using ZeosLib 7.2.4, FB 3.0.3 is also affected and returns invalid BLOB ID or some random data

db calls that leads to this error

isc_start_multiple(tran: 4)
isc_dsql_prepare(stmt: 73, tran: 4)
isc_dsql_execute(stmt: 73, tran: 4)
isc_dsql_fetch(stmt: 73)
isc_open_blob2(db: 4, tran: 4, handle: 0 -> 1165, id: 6013 0) ...
isc_open_blob2(db: 4, tran: 4, handle: 0 -> 1479, id: 6046 0)

isc_dsql_prepare(stmt: 85, tran: 4)
isc_dsql_execute(stmt: 85, tran: 4)
isc_dsql_fetch(stmt: 85)
isc_open_blob2(db: 4, tran: 4, handle: 0 -> 1480, id: 6013 0) ...
isc_open_blob2(db: 4, tran: 4, handle: 0 -> 1528, id: 6046 0)
isc_commit_transaction(tran: 4)

isc_start_multiple(tran: 8)
isc_dsql_prepare(stmt: 87, tran: 8)
isc_dsql_execute(stmt: 87, tran: 8)
isc_commit_retaining(tran: 8)

isc_start_multiple(tran: 9)
isc_dsql_prepare(stmt: 88, tran: 9)
isc_dsql_execute(stmt: 88, tran: 9)
isc_dsql_fetch(stmt: 88)

isc_open_blob2(db: 4, tran: 9, handle: 0 -> 0, id: 6013 0)
Other, Error: invalid BLOB ID, Code: -901 (Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements)
EZSQLException: SQL Error: invalid BLOB ID. Error Code: -901. Unsuccessful execution caused by system error that does not preclude successful execution of subsequent statements