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

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:

[ Permalink | « Hide ]

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