 |
SoftTree Technologies
Technical Support Forums
|
|
| Author |
Message |
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
 [SA 9.1.261 Pro] - SQL Editor freezing |
 |
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 |
  |
 |
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
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 |
|
|
SysOp
Site Admin
Joined: 26 Nov 2006
Posts: 7948
|
|
| |
|
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 |
|
|
gemisigo
Joined: 11 Mar 2010
Posts: 2165
|
|
| |
|
Thanks. I modified them to 10s and now the freeze is gone.
|
|
| Thu Apr 27, 2017 4:38 am |
|
|
|
|
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
|
|
|
