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?

asked 04 Sep '15, 15:22

ttblum's gravatar image

ttblum
31223
accept rate: 0%


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.

permanent link

answered 04 Sep '15, 15:37

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 32%

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:

×21

question asked: 04 Sep '15, 15:22

question was seen: 11,854 times

last updated: 04 Sep '15, 15:37