Hello,
I Have an issue with a Firebird exception that the IBDAC Component cannot handle quite right.
Iam using IBDAC 5.7.24 for Rad Studio 10 Seattle and a Firebird 3.0 Database.
Sometimes it happens that the Attachment to the Database gets Shutting down by the Database.
This can be reproduced by going to the Database Monitoring Tables and "Shutdown Attachment".
On the Next SQL-Statement of our Application we get an EIBCError with ErrNumber 335544856 and ErrorCode -902 Message "connection shutdown".
So far so good, but iam not able to handle this Exception.
It doesn't matter if i trying to call IBCQuery.free or IBCConnection.Disconnect.
After the Attachment was closed down every SQL-Statement cannot start a new transaction. Even after reconnect.
I get always the Message: "Exception: 30961408 Can't perform operation on inactive transaction"
The only option at the Moment is to restart the hole Application. Can you help me out?
09.09.2016 11:44:22|INFO |Start:
09.09.2016 11:44:22|INFO |Select * from BE_SUCHE_AUFTRAG_EXPORT(666)
09.09.2016 11:44:22|INFO |Commit:
09.09.2016 11:44:32|INFO |Start:
09.09.2016 11:44:32|INFO |Select * from BE_SUCHE_AUFTRAG_EXPORT(666)
09.09.2016 11:44:32|INFO |Commit:
09.09.2016 11:44:43|INFO |Start:
09.09.2016 11:44:43|ERROR |Error: connection shutdown
09.09.2016 11:44:45|INFO |Disconnect: [email protected]
09.09.2016 11:44:57|INFO |Connect: [email protected]
09.09.2016 11:44:57|INFO |Select * from BE_SUCHE_AUFTRAG_EXPORT(666)
09.09.2016 11:44:59|ERROR |Exception: 30961408 Can't perform operation on inactive transaction
09.09.2016 11:45:09|INFO |Select * from BE_SUCHE_AUFTRAG_EXPORT(666)
09.09.2016 11:45:09|ERROR |Exception: 30961408 Can't perform operation on inactive transaction
IBDAC Attachment Shutdown
Re: IBDAC Attachment Shutdown
Unfortunately, we could not reproduce the problem.
Please compose a small sample demonstrating the described behavior and send it to viktorv*devart*com, including scripts creating database objects in order to get a detailed answer.
Please compose a small sample demonstrating the described behavior and send it to viktorv*devart*com, including scripts creating database objects in order to get a detailed answer.
Re: IBDAC Attachment Shutdown
Thank you for the information. We have reproduced the issue and investigation is in progress. We will inform you when we have any results.
Re: IBDAC Attachment Shutdown
Are there any more Informations about a fix?
Re: IBDAC Attachment Shutdown
We will continue investigation of the behavior of IBDAC and inform you as soon as we get any results, but we can't tell any timeframe at the moment.
Re: IBDAC Attachment Shutdown
The new IBDAC 5.7.26 with a fix for bug with handling the "Connection shutdown" error is available for download now.