SQLANYWERE SERVER 10 - CONNECTIONS HANGS

Hi, I have a SqlAnyWhere 10 server running with appr. 37 databases on a Windows 2008R2 64bit server. The server runs nice for some days but then connections will not close even if the Client closes the application that holds the connection. Have anyone experienced and solved this?

Sten-Inge

connection

asked 26 Feb '14, 07:11

Sten Inge
1●1●1●1
accept rate: 0%

And then this happen i get "Communication error" when trying to connect to a database in Sybase Central.

(26 Feb '14, 07:51) Sten Inge

Hi Sten,

What is the exact version of SQL Anywhere? You can view this by runnning dbsrv10 -v from a command prompt or SELECT @@version from dbisql

(26 Feb '14, 09:44) Mikel Rychliski

Hi Mikel,

Version 10.0.1.3415

(26 Feb '14, 10:49) Sten Inge

flat view

One Answer:

active answers oldest answers newest answers popular answers

Yes. See this question.

Notably, not all known connection hanging problems may have been solved on 10.0.1 (as it was end-of-life'd), but applying the last applicable EBF for 10.0.1 is advisable.

Using a value of '1' for MAX_QUERY_TASKS is also a workaround for this issue - this will take effect for all new logins to the server. Existing logins will not be affected until they reconnect.

SET OPTION PUBLIC.MAX_QUERY_TASKS = 1;

permanent link

answered 26 Feb '14, 11:39

Jeff Albion
10.8k●1●71●175
accept rate: 25%

edited 26 Feb '14, 11:45

Hi Jeff,

I've downloaded the latest EBD (4310) and see if that solve my problem. If not I will try setting MAX_QUERY_TASKS option. I have to set that option on each database right?

Sten-Inge

(26 Feb '14, 12:55) Sten Inge

Replies hidden

Yes, sorry if that wasn't clear in my original response - the MAX_QUERY_TASKS setting is per-database, so you will have to enable the setting across all of your 37 databases for that server.

(26 Feb '14, 14:16) Jeff Albion

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "title")
image?![alt text](/path/img.jpg "title")
numbered list: 1. Foo 2. Bar
to add a line break simply add two spaces to where you would like the new line to be.
basic HTML tags are also supported

learn more about Markdown

Question tags:

connection ×159

question asked: 26 Feb '14, 07:11

question was seen: 1,258 times

last updated: 26 Feb '14, 14:16

SAP SQL Anywhere

SQLANYWERE SERVER 10 - CONNECTIONS HANGS

Follow this question

Related questions