Hi.
We have encountered a very bad problem: it is common situation when the client unexpectedly looses connection to the database server while transaction is opened, for instance client's computer suddenly lost the power or internet provider broke the connection. Unfortunatelly, it seems that Firebird server doesn't handle such situation correctly. Firebird keeps thinking that the client connection and transaction are still opened, this could be easily checked in MON$TRANSACTIONS. Therefore it sets the dead lock on the record which the client were modifing before connection break and there is no other way to unlock the record except restarting Firebird service. We use Firebird 2.5 and ado net provider for our client program, about 100 connections are opened simultaneously, Firebird server installed on Windows Server 2012 and run as a service. This problems occurs on classic sever as well as on superserver configurations. On classic server configuration we find a bunch of Firebird processes belonging to the "dead" connections with uncommited trunsactions. So here is the question: is it a Firebird bug or something wrong with the windows server? Unfortunatelly we have not found any usefull sollution on the web.
Best regards,
Evgeny
__._,_.___
Posted by: =?utf-8?B?0K/QutGD0YjQtdCyINCV0LLQs9C10L3QuNC5?= <annino.ru@yandex.ru>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (1) |
Have you tried the highest rated email app?
With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
Visit http://www.firebirdsql.org and click the Documentation item
on the main (top) menu. Try FAQ and other links from the left-side menu there.
Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
.
__,_._,___
No comments:
Post a Comment