|
ASTC cordinator in SYBASE
|
|||
---|---|---|---|
#18+
Добрый день всем Какая то зависящая (?) Транзакция в 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. ... |
|||
:
Нравится:
Не нравится:
|
|||
06.12.2019, 14:14 |
|
ASTC cordinator in SYBASE
|
|||
---|---|---|---|
#18+
Remote transaction coordinated using the Adaptive Server transaction coordination services. Что известно о распределенных транзакциях в вашей системе? ... |
|||
:
Нравится:
Не нравится:
|
|||
18.12.2019, 06:36 |
|
|
Start [/forum/topic.php?fid=55&tid=2009574]: |
0ms |
get settings: |
24ms |
get forum list: |
11ms |
check forum access: |
5ms |
check topic access: |
5ms |
track hit: |
66ms |
get topic data: |
15ms |
get forum data: |
4ms |
get page messages: |
256ms |
get tp. blocked users: |
2ms |
others: | 190ms |
total: | 578ms |
0 / 0 |