Jump to content
uniGUI Discussion Forums
Sign in to follow this  
mika

Database locks when application crashes

Recommended Posts

When user is waiting fairly time consuming SQL query to finish and application crashes (halts without a trace but that's a another problem) for some reason, database connection might leave table(s) locked. This will cause said table to be unreadable (without dirty read) until database server is restarted.

 

I thought that any and all database connections will be disconnected and any possible locks will be released when application crashes but that doesn't seem to be case.

 

Do any of you have any suggestions how to track down and solve this problem?

 

Database backend is Microsoft SQL Server 2014 Express and I use FireDAC access it. uniGUI version is 1.0.0.1406 (Complete).

 

// Mika

Share this post


Link to post
Share on other sites

Yes. I totally agree. It shouldn't be possible.

 

I'm pretty sure I must be overlooking something. I'll keep investigating.

 

// Mika

Share this post


Link to post
Share on other sites

SET XACT_ABORT ON

 

By default lost connection to SQL server does NOT considered an error to rollback open transactions and so affected tables stay locked.

  • Upvote 1

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×