We have some customers that have been reporting "phantom users". When they look at connected users they see people that have not only closed the software app, but have also shut down their computer.

We are using SQLA version 11.01 We start the ddsrv11.exe with the following parameters... -x tcpip -ti 0 -tl 0

Could these parameters cause connections to remain open even when people have shut down their computer?

TIA, Mike

asked 04 Apr '13, 10:01

ksitech's gravatar image

ksitech
16112
accept rate: 0%


Yes, I believe this is certainly a possibility. -ti 0 disables the Idle Timeout check (which normally engages after 240 minutes if we haven't heard from a client to automatically disconnect the client), and -tl 0 disables the Liveness check (which is the only mechanism available to the server to check the active client connectivity).

If you do not explicitly close the database connection (e.g. the network drops off, do not explicitly 'close' a connection in your program, etc.), then this could be the behaviour you're seeing.

You should be able to drop the connections using the DROP CONNECTION statement.


We have also had previous problems with "[Exchange]" workers, from intra-query parallelization queries and we left 'phantom' users connected that could not be dropped. This was fixed in a later patch (11.0.1.2786 and above).

permanent link

answered 04 Apr '13, 10:10

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

edited 05 Apr '13, 07:31

Ian%20McHardy's gravatar image

Ian McHardy
3.0k23152

Thanks for the reply. We will change these values.

(04 Apr '13, 10:20) ksitech
Your answer
toggle preview

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

Question tags:

×127

question asked: 04 Apr '13, 10:01

question was seen: 574 times

last updated: 05 Apr '13, 07:31