SQL Server JDBC - ServerException: Lock request time out

Author

ServerException: Lock request time out

Jordan Zimmerman

2005-09-24, 8:23 pm

We're seeing tons of these exceptions in the MSFT driver. Can you shed any
light on them?

Exception caught:

com.microsoft.sqlserver.jdbc.SQLServerException: Lock
request time out
period exceeded.
at
com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDataba
seError(Unknown Source)
at
com.microsoft.sqlserver.jdbc.IOBuffer. processPackets(Unkno
wn Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(
Unknown Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Un
known Source)
at
com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteUpdat
e(Unknown Source)
at
com.microsoft.sqlserver.jdbc. SQLServerPreparedSta
tement.execut
eUpdate(Unknown Source)
at
com.catalogcity.website. cc_jdbc_prepared_sta
tement.executeUpda
te(cc_jdbc_prepared_
statement.java:112)
at

--
Jordan Zimmerman
Senior Software Architect
SHOP.COM
http://www.shop.com

Joe Weinstein

2005-09-24, 8:23 pm

Jordan Zimmerman wrote:

> We're seeing tons of these exceptions in the MSFT driver. Can you shed any
> light on them?
>
> Exception caught:
>
> com.microsoft.sqlserver.jdbc.SQLServerException: Lock
> request time out
> period exceeded.
> at

It's just the driver reporting the problem in the DBMS.
If your update is trying to update data that is already
locked by another transaction, it will be blocked, and
eventually, according to the DBMS's lock request timeout
period, if the data you want to update has yet not become
free for you to update, the DBMS will abort your attempt,
and send you that message. The only concern I have is whether
the locks you're blocked on are particularly and specifically
for the data, or whether they may be broader, such as page
or index locks, which may be held by other transactions
that are not logically related to the data you want...
YOu may need some DBA help examining your application/
transaction architecture to minimize this blocking.

Joe Weinstein at BEA

> com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDataba
> seError(Unknown Source)
> at
> com.microsoft.sqlserver.jdbc.IOBuffer. processPackets(Unkno
wn Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(
> Unknown Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.sendExecute(Un
> known Source)
> at
> com.microsoft.sqlserver.jdbc.SQLServerStatement.doExecuteUpdat
> e(Unknown Source)
> at
> com.microsoft.sqlserver.jdbc. SQLServerPreparedSta
tement.execut
> eUpdate(Unknown Source)
> at
> com.catalogcity.website. cc_jdbc_prepared_sta
tement.executeUpda
> te(cc_jdbc_prepared_
statement.java:112)
> at
>
>

Jordan Zimmerman

2005-09-24, 8:23 pm

"Joe Weinstein" <joeNOSPAM@bea.com> wrote in message
news:4335CC9E.5030204@bea.com...
>
>
> It's just the driver reporting the problem in the DBMS.

We're suspicious about it because the error comes back almost immediately.
Also, we don't get this exception when using the Opta driver (we're testing
the MSFT driver as a replacement).

--
Jordan Zimmerman
Senior Software Architect
SHOP.COM
http://www.shop.com

Joe Weinstein

2005-09-25, 8:23 pm

Jordan Zimmerman wrote:

> "Joe Weinstein" <joeNOSPAM@bea.com> wrote in message
> news:4335CC9E.5030204@bea.com...
>
>
>
> We're suspicious about it because the error comes back almost immediately.
> Also, we don't get this exception when using the Opta driver (we're testing
> the MSFT driver as a replacement).

Interesting. I would search for info on that dbms error message. I would
also try the beta version of the new 2005 driver MS is offering...
Joe

Angel Saenz-Badillos[MS]

2005-10-01, 3:23 am

It would be interesting to understand what is causing the locking, could you
use sp_lock2 for example to help figure out what is getting locked and who
is locking it?

--
Angel Saenz-Badillos [MS] DataWorks
This posting is provided "AS IS", with no warranties, and confers no
rights.Please do not send email directly to this alias.
This alias is for newsgroup purposes only.
I am now blogging: http://weblogs.asp.net/angelsb/

"Jordan Zimmerman" < jordan@jordanzimmerm
an.com> wrote in message
news:u4IA4gWwFHA.1148@TK2MSFTNGP11.phx.gbl...
> "Joe Weinstein" <joeNOSPAM@bea.com> wrote in message
> news:4335CC9E.5030204@bea.com...
>
> We're suspicious about it because the error comes back almost immediately.
> Also, we don't get this exception when using the Opta driver (we're
> testing the MSFT driver as a replacement).
>
> --
> Jordan Zimmerman
> Senior Software Architect
> SHOP.COM
> http://www.shop.com
>
>

Sponsored Links