April 18, 2013 at 6:56 pm
One of the system in my company was not available on the 9th Apr. As the application team in my company check in the log.. they found this error
2013/04/09 15:39:05:391 ERRORservices.ib101_access.register.IBRegisterSecurityImageServices: Error details :org.hibernate.exception.SQLGrammarException: could not insert:[net.penril.ibss.core.hibernate.IbUser]
Caused by:com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
2013/04/09 15:39:17:559 ERRORenterprise.services.ib101_access.IBGenericLoginServices: Error details :org.hibernate.exception.SQLGrammarException: could not update:[net.penril.ibss.core.hibernate.IbCustProfile#4737
Caused by:com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded.
2013/04/09 15:39:43:487 ERRORenterprise.services.ib101_access.IBGenericLoginServices: Error details :org.hibernate.exception.SQLGrammarException: could not update:[net.penril.ibss.core.hibernate.IbCustProfile#2951]
Caused by:com.microsoft.sqlserver.jdbc.SQLServerException: Lock request time out period exceeded
its suspected because of deadlock. But i have no idea where to check on this issue. Im very new in this. Please help.
April 19, 2013 at 2:09 am
Lock request timeout will not be caused by a deadlock.
You can look in the system health extended events session to see if you have had any deadlocks, but I suspect you should be directing your investigation elsewhere.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply