How to locate the origin of connection?

[former_member329524]

Hello, all

One of our clients recently started receiving errors of type "all threads are blocked"

When I go into Sybase Central to look at the connected users, I see dozens of strange connections. There is no user, no station IP, just the connection name "INT: Exchange".

Can anyone suggest how I find the origin of this connection?

Thank you,

Arcady

[Former Member · Accepted solution]

Hi.

First of all what version of SQL Anywhere are you using? Have you tried to see properties for one of those "strange" connections? If you right click on anyone and choose properties do you se a window with two tabs?

Also are you using mobilink, proxy tables - remote servers or anything like that?

Andreas.

[former_member329524 · Accepted solution]

Thank you, Andreas

I think that we are witnessing the known undroppable connection bug, the client is using a version 12.0.1.35xx

I will advise their IT to upgrade to the latest EBF.

Arcady

[former_member188493]

You are seeing internal child connections spawned by a parent connection that is using intra-query parallelism. See these blog posts...

Pssst! Wanna see some Intra-Query Parallelism?

Case Study: Intra-Query Parallelism