SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
[SA 9.1.261 Pro] - SQL Editor freezing

 
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant View previous topic
View next topic
[SA 9.1.261 Pro] - SQL Editor freezing
Author Message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post [SA 9.1.261 Pro] - SQL Editor freezing Reply with quote
When I start SQL Editor and selected tabs to restore include tabs that were connected to servers that are no longer accessible (it's shut down) SQL Editor stops responding. If I start the server the editor comes back.
Wed Apr 26, 2017 3:55 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Would you please check that these connections have a reasonable connection timeout value set. Maybe set them to 10 seconds?
Wed Apr 26, 2017 2:29 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Funny. Now that you mentioned that I've checked my connections and found out that there were two of them having their Connect Timeout set to 0 (I guess that's for indefinitely). I'm pretty sure I've never tinkered those. What could possibly change them?
Wed Apr 26, 2017 2:36 pm View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 7840

Post Reply with quote
Some connection related settings and enhancements have been added in every new major version since at least version 7. I wonder if some past upgrade added zeroes as default Connection timeout values. Zero values basically allows the middleware connection driver to decide how long to wait. The actual behavior may very by driver type (ADO, ODBC, etc...) and its version.
Wed Apr 26, 2017 10:59 pm View user's profile Send private message
gemisigo



Joined: 11 Mar 2010
Posts: 2102

Post Reply with quote
Thanks. I modified them to 10s and now the freeze is gone.
Thu Apr 27, 2017 4:38 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » SQL Assistant All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.