search

FirebirdSQL / firebird

Firebird server, client and tools
https://www.firebirdsql.org/
1.23k stars 212 forks source link

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

Open firebird-automations opened 6 years ago

firebird-automations commented 6 years ago

Submitted by: Sorien (sorien)

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)

firebird-automations commented 6 years ago

Commented by: Sorien (sorien)

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

firebird-automations commented 6 years ago
Modified by: Sorien (sorien) security: Developers \[ 10012 \] =\>
firebird-automations commented 6 years ago
Modified by: Sorien (sorien) Version: 3\.0\.2 \[ 10785 \]
firebird-automations commented 6 years ago
Modified by: Sorien (sorien) Version: 3\.0\.3 \[ 10810 \] Version: 3\.0\.2 \[ 10785 \] =\>