All threads are blocked - Proble

Server ASA 11.0.1.2324 (latest official EBF) on Windows 2003

I have a very strange problem since I use extended stored procedures
written in C#:

After a couple of updates I receive the following error:

"ERROR [40001] [Sybase][ODBC Driver][SQL Anywhere]All threads are blocked"


The operation is a little complex: The update fires a couple triggers.
They use calls to external functions written in C#. I cannot see any
deadlocks in Central. I start the server with the following options:

-x tcpip
-cl 1536m
-cm 2048m
-gd all
-gn 100

Before the last EBF I had a server crash with out of memory exceptions
due to a memory leak. This was fixed with 2324. But the new problem I
have now is the 'all thread are blocked' message. It appears no matter
how big I set the -gn parameter. The default is 20 and I set it to 100
but the result is the same!

Any idea what the problem could be??

Many thanks in advance

Tom

Sounds like a bug that is specific to the CLR external environment
rather than external environments in general. Can you give some more
information that would help us reproduce the problem.

Karim
at wrote:

Server ASA 11.0.1.2324 (latest official EBF) on Windows 2003

I have a very strange problem since I use extended stored procedures
written in C#:

After a couple of updates I receive the following error:

"ERROR [40001] [Sybase][ODBC Driver][SQL Anywhere]All threads are blocked"


The operation is a little complex: The update fires a couple triggers.
They use calls to external functions written in C#. I cannot see any
deadlocks in Central. I start the server with the following options:

-x tcpip
-cl 1536m
-cm 2048m
-gd all
-gn 100

Before the last EBF I had a server crash with out of memory exceptions
due to a memory leak. This was fixed with 2324. But the new problem I
have now is the 'all thread are blocked' message. It appears no matter
how big I set the -gn parameter. The default is 20 and I set it to 100
but the result is the same!

Any idea what the problem could be??

Many thanks in advance

Tom

Hi Karim,

Yes, I can send your further information. E.g. the code of my external
functions in C# (I just use things like Regex.Replace(....)
I can also send you SQL Code from triggers etc. I don't like to publish
this over the newsgroup but I can send it to your Sybase address.

Regards

Tom

Karim Khamis [Sybase iAnywhere] schrieb:

Sounds like a bug that is specific to the CLR external environment
rather than external environments in general. Can you give some more
information that would help us reproduce the problem.

Karim
at wrote:
Server ASA 11.0.1.2324 (latest official EBF) on Windows 2003

I have a very strange problem since I use extended stored procedures
written in C#:

After a couple of updates I receive the following error:

"ERROR [40001] [Sybase][ODBC Driver][SQL Anywhere]All threads are
blocked"


The operation is a little complex: The update fires a couple triggers.
They use calls to external functions written in C#. I cannot see any
deadlocks in Central. I start the server with the following options:

-x tcpip
-cl 1536m
-cm 2048m
-gd all
-gn 100

Before the last EBF I had a server crash with out of memory exceptions
due to a memory leak. This was fixed with 2324. But the new problem I
have now is the 'all thread are blocked' message. It appears no matter
how big I set the -gn parameter. The default is 20 and I set it to 100
but the result is the same!

Any idea what the problem could be??

Many thanks in advance

Tom

You're experiencing thread deadlock, which is different from (normal)
deadlock. You may find the following description useful:

http://iablog.sybase.com/paulley/200...read-deadlock/

Glenn

at wrote:

Server ASA 11.0.1.2324 (latest official EBF) on Windows 2003

I have a very strange problem since I use extended stored procedures
written in C#:

After a couple of updates I receive the following error:

"ERROR [40001] [Sybase][ODBC Driver][SQL Anywhere]All threads are blocked"


The operation is a little complex: The update fires a couple triggers.
They use calls to external functions written in C#. I cannot see any
deadlocks in Central. I start the server with the following options:

-x tcpip
-cl 1536m
-cm 2048m
-gd all
-gn 100

Before the last EBF I had a server crash with out of memory exceptions
due to a memory leak. This was fixed with 2324. But the new problem I
have now is the 'all thread are blocked' message. It appears no matter
how big I set the -gn parameter. The default is 20 and I set it to 100
but the result is the same!

Any idea what the problem could be??

Many thanks in advance

Tom

--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport