Добрый день всем
Какая то зависящая (?) Транзакция в systransaction. Где эта информация вообще хранится для ASTC? Dbcc complete/forget не помогает. Даже перегружал датасервер. Кто то использует ASTC?


1> select @@version
2> go
---------------------------------------------------------------------------------------------------
Adaptive Server Enterprise/15.7/EBF 28258 SMP SP140 /P/ia64/HP-UX B.11.31/ase157sp140x/4123/64-bit/FBO/Thu May 24 15:06:34 2018

1> sp_transactions
2> go
xactkey type coordinator starttime state connection dbid spid loid failover srvname namelen xactname
------------------------------ ----------- ----------- -------------------- ----------------- ---------- ------ ------ ----------- -------------------------- ------------------------------ ------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
0x0149b1e5001400007c229e380007 Dtx_State None Aug 1 2017 5:05AM In Abort Tran NA 7 0 0 Resident Tx NULL 4 $ins
0x0149b1e5001400007c229e380007 Remote ASTC Aug 1 2017 5:05AM Begun NA 0 0 0 Resident Tx DHT_TM09_2 110 0149b1e5001400007c229e380007-fc48c14265ae-0149b1e5001400007c229e380007-fc48c14265ae-DHT_TM09_3-DHT_TM09_3-001f

1> dbcc forget_xact("0149b1e5001400007c229e380007-fc48c14265ae-0149b1e5001400007c229e380007-fc48c14265ae-DHT_TM09_3-DHT_TM09_3-001f")
2> go
Msg 3947, Level 16, State 2:
Server 'DHT_TM09_3', Line 1:
A heuristic completion related operation failed. Please see errorlog for more details.
DBCC execution completed. If DBCC printed error messages, contact a user with System Administrator (SA) role.
1> !!tail -10 DHT_TM09_3.log
[sh:tail -10 DHT_TM09_3.log]
..
00:0007:00000:00059:2019/12/06 11:52:21.50 server DBCC TRACEON 3604, SPID 59
00:0006:00000:00059:2019/12/06 11:53:48.27 server Heuristic forget for '0149b1e5001400007c229e380007-fc48c14265ae-0149b1e5001400007c229e380007-fc48c14265ae-DHT_TM09_3-DHT_TM09_3-001f' failed as this transaction was not found in systransactions system table.

jimmers,

Распределёные не используются. Думаю была запущена по ошибке. Линкед серера есть.