Topic
2 replies Latest Post - ‏2012-12-06T09:31:00Z by mmalc
SystemAdmin
SystemAdmin
3556 Posts
ACCEPTED ANSWER

Pinned topic Lock request time out period exceeded

‏2012-11-23T14:11:42Z |
I am getting the below error in ffdc
com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.

and whenever I get this error, the CPU utilization is at 100% and results in OutofMemory error after 15/20 mins.
so I increased the JVM size and number of threads for the particular JDBC connection, now whenever I get this error CPU is reaching 100% for 2 mins. Can someone please help in understanding this behavior(any exception causing CPU to be 100% utilized) and any possible resolution for it?

Thanks in advance.
Updated on 2012-12-06T09:31:00Z at 2012-12-06T09:31:00Z by mmalc
  • SystemAdmin
    SystemAdmin
    3556 Posts
    ACCEPTED ANSWER

    Re: Lock request time out period exceeded

    ‏2012-11-27T23:34:08Z  in response to SystemAdmin
    Check the lockTimeOut custom property of the datasource. It is likely set to never timeout.
    
    The amount of time (in milliseconds) to wait 
    
    for a lock before timing out. -1 indicates the attempt to acquire a lock never times out. 0 indicates the attempt times out immediately.
    


    More importantly you might want to check why an attempt to get the lock takes longer than expected. Increasing the timeout or the threads or the heap size will likely just delay the issue but not fix it.
  • mmalc
    mmalc
    231 Posts
    ACCEPTED ANSWER

    Re: Lock request time out period exceeded

    ‏2012-12-06T09:31:00Z  in response to SystemAdmin
    See if this helps you

    http://www-01.ibm.com/support/docview.wss?uid=swg21516235

    Rgds
    Marvin