Skip to content
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

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 this issue Jul 9, 2018 · 4 comments

Comments

@firebird-automations
Copy link
Collaborator

Submitted by: Sorien (sorien)

probably from commit c916203 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
Copy link
Collaborator Author

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
Copy link
Collaborator Author

Modified by: Sorien (sorien)

security: Developers [ 10012 ] =>

@firebird-automations
Copy link
Collaborator Author

Modified by: Sorien (sorien)

Version: 3.0.2 [ 10785 ]

@firebird-automations
Copy link
Collaborator Author

Modified by: Sorien (sorien)

Version: 3.0.3 [ 10810 ]

Version: 3.0.2 [ 10785 ] =>

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

1 participant