Jump to content

Time-out when deleting folders


MichaelRyom

Recommended Posts

Hi

 

I'm trying to delete a folder with nested objects - password lists. But it times out with the following error msg in error console.

 

Is there anything the can be done to change the time-out timer? Passwordstate and mssql express is installed on the same server.

 

02/06/2018 19:53:18 General Error Error Code = Thread was being aborted., StackTrace = at System.Threading.Thread.AbortInternal() at System.Threading.Thread.Abort(Object stateInfo) at System.Web.HttpResponse.AbortCurrentThread() at System.Web.HttpResponse.Redirect(String url, Boolean endResponse, Boolean permanent) at Passwordstate.Common.AddDebugInfoData(String Category, String DebugInformation, String EventType) at Passwordstate.PasswordList.DeletePasswordList(Int32 intPasswordListID, String strPasswordList) at Passwordstate.PasswordList.DeleteFolderAndAllNestedItems(Int32 PasswordListID) event-error.png Error
02/06/2018 19:53:18 General Error Error Code = Query timeout expired, StackTrace = at System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method) at System.Data.OleDb.OleDbCommand.ExecuteNonQuery() at Passwordstate.PasswordList.DeletePasswordList(Int32 intPasswordListID, String strPasswordList) event-error.png Error
Link to comment
Share on other sites

Hi Michael,
 

This issue is a timeout with your SQL Server, and in the .NET Framework the default is set to 30 seconds for database connections. We're going to make a change in the next release as we've had a few customers run into this issue recently, as we've developed a more efficient script which should hopefully help with this.

 

For now, if you can contact us via our support page on our web site (https://www.clickstudios.com.au/support.aspx) I can provide the SQL script to you now so you can run this manually in SQL Server Management Studio.

Regards

Click Studios

Link to comment
Share on other sites

Hello Everyone.

As mentioned, we are making changes in the next build for this, and we've been doing some testing on performance here.
 

With this new script for mass deletion, we've been able to delete a parent folder which has 500 nested Folders, 2500 Password Lists and 12500 password records, in just under 3 minutes.
 

These times will obviously vary depending on the age of these records, and volume of related records in various tables, but at least this is an indication of performance.

Regards

Click Studios

Link to comment
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
×
×
  • Create New...