Database option to quell long-term blocking locks?

[Former Member]

Hello,

I have an application that uses a Jaguar EAServer in front of SQL Anywhere 12.

I'm getting long-term exclusive blocking locks a few times a week, which locks up all of the users running the client.

Is there a blocking timeout option of some kind for SQL Anywhere that could automatically release a lock if it blocks other transactions for too long?

[Former Member]

There is the Blocking_Timeout option, but you would need access to the source code for the application logic since the way you interact with data changes when you set that.

It is usually better to determine you blocking scenario and see if you can address that in some fashion.

It does sound like you could have a long-lived transaction, and if that is the case you should probably investigate what is the source of that and maybe modify that part of the application to complete work in smaller chunks; allowing more opportunity for other work to unblock and increase throughput that way.