|
Приветствую a33ik
Вот насколько я понимаю это относиться именно к моей проблеме в логах.
Решение не успеваю найти, с утра уезжаю на длительное время.
По возможности отпишусь об остальном.
Заранее благодарю за Ваши отклики.
SET DEADLOCK_PRIORITY LOW
BEGIN TRANSACTION
DECLARE @res INT
EXEC @res = sp_getapplock
@Resource = 'AsyncService_app_lock',
@LockMode = 'Exclusive'
IF @res NOT IN (0, 1)
BEGIN
RAISERROR ( 'Unable to acquire App Lock', 16, 1 )
END
ELSE
BEGIN
With TopSuspendedAsyncOperations(AsyncOperationId)
AS
(
Select Top(2000) AsyncOperationId
from AsyncOperationBase o1
where
StateCode = 1
and ((PostponeUntil is NULL) or (PostponeUntil <= '06/29/2012 23:07:17'))
and ((DependencyToken is NULL) or (not exists (
select AsyncOperationId
from AsyncOperationBase o2
where
o2.Sequence < o1.Sequence
and o2.DependencyToken = o1.DependencyToken
and o2.RecurrencePattern is null
and o2.StateCode in (0,2,1))))
)
update AsyncOperationBase
set
StateCode = 0,
StatusCode = 0,
ModifiedOn = '06/29/2012 23:07:17',
ModifiedBy = CreatedBy
From AsyncOperationBase join TopSuspendedAsyncOperations on
AsyncOperationBase.AsyncOperationId = TopSuspendedAsyncOperations.AsyncOperationId
EXEC @res = sp_releaseapplock
@Resource = 'AsyncService_app_lock'
END
|