1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50
|
2016-10-24 12:35:06.15 spid5s KEY: 9:72057598654545920 (f60231738f32) CleanCnt:2 Mode:X Flags: 0x0
2016-10-24 12:35:06.15 spid5s Grant List 1:
2016-10-24 12:35:06.15 spid5s Owner:0x0000000235C1A580 Mode: X Flg:0x0 Ref:0 Life:02000000 SPID:89 ECID:0 XactLockInfo: 0x0000000303CFAAC8
2016-10-24 12:35:06.15 spid5s SPID: 89 ECID: 0 Statement Type: SELECT Line #: 34
2016-10-24 12:35:06.15 spid5s Input Buf: Language Event: EXEC spSGM_InsMvtFabr @ni_num = 'RG629627030', @pt_num ='253550934F', @mf_trans ='WOB_VDSL', @mf_statut = 'NOGO', @mf_obs='8.TX_CALIBRATION _________'
2016-10-24 12:35:06.15 spid5s Requested By:
2016-10-24 12:35:06.15 spid5s ResType:LockOwner Stype:'OR'Xdes:0x0000000100B62370 Mode: S SPID:122 BatchID:0 ECID:0 TaskProxy:(0x00000000BCC56598) Value:0xd106cd80 Cost:(0/956)
2016-10-24 12:35:06.15 spid5s
2016-10-24 12:35:06.15 spid5s Victim Resource Owner:
2016-10-24 12:35:06.15 spid5s ResType:LockOwner Stype:'OR'Xdes:0x0000000100B62370 Mode: S SPID:122 BatchID:0 ECID:0 TaskProxy:(0x00000000BCC56598) Value:0xd106cd80 Cost:(0/956)
2016-10-24 12:35:06.15 spid20s deadlock-list
2016-10-24 12:35:06.15 spid20s deadlock victim=processc39588
2016-10-24 12:35:06.15 spid20s process-list
2016-10-24 12:35:06.15 spid20s process id=processbe1048 taskpriority=0 logused=984 waitresource=KEY: 9:72057598654545920 (390379358aa6) waittime=1482 ownerId=4275854822 transactionname=implicit_transaction lasttranstarted=2016-10-24T12:35:04.087 XDES=0x303cfaa90 lockMode=S schedulerid=4 kpid=4984 status=suspended spid=89 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2016-10-24T12:35:04.087 lastbatchcompleted=2016-10-24T12:35:04.087 clientapp= WOB_VDSL hostname=BNR-T019627 hostpid=3052 loginname=devtest isolationlevel=read committed (2) xactid=4275854822 currentdb=9 lockTimeout=4294967295 clientoption1=671219744 clientoption2=128058
2016-10-24 12:35:06.15 spid20s executionStack
2016-10-24 12:35:06.15 spid20s frame procname=suivi.dbo.tg_SGM_MvtFabr_Re line=34 stmtstart=1514 stmtend=2020 sqlhandle=0x030009005f3f1f4fb43c94003ba100000000000000000000
2016-10-24 12:35:06.15 spid20s SELECT @nbMvt = count(*) FROM mvtfabr WHERE ni_num = @ni_num AND pt_num = @pt_num and (mf_trans = @mf_trans or mf_trans = 're_'+@mf_trans )
2016-10-24 12:35:06.15 spid20s -- IF EXISTS(SELECT * FROM mvtfabr WHERE ni_num = @ni_num AND pt_num = @pt_num and mf_trans = @mf_trans)
2016-10-24 12:35:06.15 spid20s frame procname=suivi.dbo.spSGM_InsMvtfabr line=68 stmtstart=3662 stmtend=4150 sqlhandle=0x030009006c91bd0aab2f9300b09f00000100000000000000
2016-10-24 12:35:06.15 spid20s INSERT mvtfabr(pt_num, ni_num, mf_dmvtdeb, mf_trans, pr_num, mf_statut, mf_obs, mf_qte , pl_badge, mf_dmvtFin, qc_code)
2016-10-24 12:35:06.15 spid20s VALUES(@pt_num, @ni_num, getdate(), @mf_trans, @pr_num, @mf_statut, @mf_obs,@mf_qte , @pl_badge, @mf_dmvtFin, @qc_code)
2016-10-24 12:35:06.15 spid20s frame procname=adhoc line=1 sqlhandle=0x010009008e9a6721c02e36b2010000000000000000000000
2016-10-24 12:35:06.15 spid20s EXEC spSGM_InsMvtFabr @ni_num = 'xxxxxx', @pt_num ='xxxxxxxx', @mf_trans ='xxxxx', @mf_statut = 'NOGO', @mf_obs='8.TX_CALIBRATION _________'
2016-10-24 12:35:06.15 spid20s inputbuf
2016-10-24 12:35:06.15 spid20s EXEC spSGM_InsMvtFabr @ni_num = 'xxxxxx', @pt_num ='xxxxxx', @mf_trans ='xxxxxx', @mf_statut = 'NOGO', @mf_obs='8.TX_CALIBRATION _________'
2016-10-24 12:35:06.15 spid20s process id=processc39588 taskpriority=0 logused=956 waitresource=KEY: 9:72057598654545920 (f60231738f32) waittime=1263 ownerId=4275856170 transactionname=implicit_transaction lasttranstarted=2016-10-24T12:35:04.310 XDES=0x100b62370 lockMode=S schedulerid=8 kpid=2316 status=suspended spid=122 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2016-10-24T12:35:04.310 lastbatchcompleted=2016-10-24T12:35:04.310 clientapp= WOB_VDSL hostname=BNR-RGWI20024 hostpid=3592 loginname=devtest isolationlevel=read committed (2) xactid=4275856170 currentdb=9 lockTimeout=4294967295 clientoption1=671219744 clientoption2=128058
2016-10-24 12:35:06.15 spid20s executionStack
2016-10-24 12:35:06.15 spid20s frame procname=suivi.dbo.tg_SGM_MvtFabr_Re line=34 stmtstart=1514 stmtend=2020 sqlhandle=0x030009005f3f1f4fb43c94003ba100000000000000000000
2016-10-24 12:35:06.15 spid20s SELECT @nbMvt = count(*) FROM mvtfabr WHERE ni_num = @ni_num AND pt_num = @pt_num and (mf_trans = @mf_trans or mf_trans = 're_'+@mf_trans )
2016-10-24 12:35:06.15 spid20s -- IF EXISTS(SELECT * FROM mvtfabr WHERE ni_num = @ni_num AND pt_num = @pt_num and mf_trans = @mf_trans)
2016-10-24 12:35:06.15 spid20s frame procname=suivi.dbo.spSGM_InsMvtfabr line=68 stmtstart=3662 stmtend=4150 sqlhandle=0x030009006c91bd0aab2f9300b09f00000100000000000000
2016-10-24 12:35:06.15 spid20s INSERT mvtfabr(pt_num, ni_num, mf_dmvtdeb, mf_trans, pr_num, mf_statut, mf_obs, mf_qte , pl_badge, mf_dmvtFin, qc_code)
2016-10-24 12:35:06.15 spid20s VALUES(@pt_num, @ni_num, getdate(), @mf_trans, @pr_num, @mf_statut, @mf_obs,@mf_qte , @pl_badge, @mf_dmvtFin, @qc_code)
2016-10-24 12:35:06.15 spid20s frame procname=adhoc line=1 sqlhandle=0x01000900ea177c02d06a0a4d020000000000000000000000
2016-10-24 12:35:06.15 spid20s EXEC spSGM_InsMvtFabr @ni_num = 'xxxxxx', @pt_num ='xxxxxx', @mf_trans ='xxxxxx', @mf_statut = 'GO', @mf_obs='Calibration Ok'
2016-10-24 12:35:06.15 spid20s inputbuf
2016-10-24 12:35:06.15 spid20s EXEC spSGM_InsMvtFabr @ni_num = 'xxxxxx', @pt_num ='xxxxx', @mf_trans ='WOB_VDSL', @mf_statut = 'GO', @mf_obs='Calibration Ok'
2016-10-24 12:35:06.15 spid20s resource-list
2016-10-24 12:35:06.15 spid20s keylock hobtid=72057598654545920 dbid=9 objectname=suivi.dbo.mvtFabr indexname=missing_index_11001 id=lock2a57c6900 mode=X associatedObjectId=72057598654545920
2016-10-24 12:35:06.15 spid20s owner-list
2016-10-24 12:35:06.15 spid20s owner id=processc39588 mode=X
2016-10-24 12:35:06.15 spid20s waiter-list
2016-10-24 12:35:06.15 spid20s waiter id=processbe1048 mode=S requestType=wait
2016-10-24 12:35:06.15 spid20s keylock hobtid=72057598654545920 dbid=9 objectname=suivi.dbo.mvtFabr indexname=missing_index_11001 id=lock2a68e5400 mode=X associatedObjectId=72057598654545920
2016-10-24 12:35:06.15 spid20s owner-list
2016-10-24 12:35:06.15 spid20s owner id=processbe1048 mode=X
2016-10-24 12:35:06.15 spid20s waiter-list
2016-10-24 12:35:06.15 spid20s waiter id=processc39588 mode=S requestType=wait |
Partager