获取死锁原始数据 - GetDeadLockOriginData

功能介绍

获取死锁原始数据。

授权信息

账号具备所有API的调用权限，如果使用账号下的IAM用户调用当前API，该IAM用户需具备调用API所需的权限。

• 如果使用角色与策略授权，具体权限要求请参见权限和授权项。
• 如果使用身份策略授权，需具备如下身份策略权限。

  授权项	访问级别	资源类型（*为必须）	条件键	别名	依赖的授权项
  das::showCloudDBAInfo	read	-	-	-	-

URI

GET /v3/{project_id}/instances/{instance_id}/dead-lock/get-dead-lock-origin-data

请求参数

响应参数

状态码： 200

请求示例

GET https://das.cn-north-1.myhuaweicloud.com/v3/052041494800d57c2f02c00275b4c247/instances/47d0524891964dc48cee42c371928777in04/dead-lock/get-dead-lock-origin-data?dead_lock_id=40DB3062B1662DE9&start_time=1761460179597&end_time=1764052179597 
 

响应示例

状态码： 200

Success.

{
    "origin_data": "<deadlock> <victim-list>  <victimProcess id=\"process1ec8b6a04e8\"/> </victim-list> <process-list>  <process id=\"process1ec8b6a04e8\" taskpriority=\"0\" logused=\"252\" waitresource=\"KEY: 6:72057594045792256 (8194443284a0)\" waittime=\"6719\" ownerId=\"212808843\" transactionname=\"user_transaction\" lasttranstarted=\"2025-11-25T11:42:15.827\" XDES=\"0x1ec5b8f8040\" lockMode=\"X\" schedulerid=\"1\" kpid=\"1856\" status=\"suspended\" spid=\"59\" sbid=\"0\" ecid=\"0\" priority=\"0\" trancount=\"3\" lastbatchstarted=\"2025-11-25T11:42:40.963\" lastbatchcompleted=\"2025-11-25T11:42:40.960\" lastattention=\"1900-01-01T00:00:00.960\" clientapp=\"Microsoft JDBC Driver for SQL Server\" hostname=\"dbs_das_service2\" hostpid=\"0\" loginname=\"rdsuser\" isolationlevel=\"read committed (2)\" xactid=\"212808843\" currentdb=\"6\" currentdbname=\"test\" lockTimeout=\"4294967295\" clientoption1=\"671088928\" clientoption2=\"128056\">   <stackFrames>      <frame id=\"00\" address=\"0x7FFE49B035A4\" pdb=\"ntdll.pdb\" age=\"1\" guid=\"DF7C6172-B6E3-7B68-CAFD-FFFE738D73FE\" module=\"ntdll\" rva=\"0xA35A4\"/><frame id=\"01\" address=\"0x7FFE4600A69F\" pdb=\"kernelbase.pdb\" age=\"1\" guid=\"944E4C6E-3A63-C6DD-3D02-46CB16FE5608\" module=\"kernelbase\" rva=\"0xFA69F\"/><frame id=\"02\" address=\"0x7FFE2C696747\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x6747\"/><frame id=\"03\" address=\"0x7FFE2C69666B\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x666B\"/><frame id=\"04\" address=\"0x7FFE2C691B2B\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x1B2B\"/><frame id=\"05\" address=\"0x7FFE2C693A07\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x3A07\"/><frame id=\"06\" address=\"0x7FFE27B328C9\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x928C9\"/><frame id=\"07\" address=\"0x7FFE27B326D4\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x926D4\"/><frame id=\"08\" address=\"0x7FFE27AB04D4\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x104D4\"/><frame id=\"09\" address=\"0x7FFE27AB9EE8\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x19EE8\"/><frame id=\"10\" address=\"0x7FFE27ABDAE3\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1DAE3\"/><frame id=\"11\" address=\"0x7FFE27ABE63A\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1E63A\"/><frame id=\"12\" address=\"0x7FFE27ABF04F\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1F04F\"/><frame id=\"13\" address=\"0x7FFE27ABF133\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1F133\"/><frame id=\"14\" address=\"0x7FFE27ACF359\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x2F359\"/><frame id=\"15\" address=\"0x7FFE31801BA7\" pdb=\"SqlTsEs.pdb\" age=\"2\" guid=\"B87B35EA-D9A0-4DD3-B8FB-56AAEB9DEA87\" module=\"SqlTsEs\" rva=\"0x1BA7\"/><frame id=\"16\" address=\"0x7FFE27B01401\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x61401\"/><frame id=\"17\" address=\"0x7FFE27ACB099\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x2B099\"/><frame id=\"18\" address=\"0x7FFE27B16F5F\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x76F5F\"/><frame id=\"19\" address=\"0x7FFE23E2AF28\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x1AF28\"/><frame id=\"20\" address=\"0x7FFE23E3A78C\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x2A78C\"/><frame id=\"21\" address=\"0x7FFE23E3A4EA\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x2A4EA\"/><frame id=\"22\" address=\"0x7FFE23E265DF\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x165DF\"/><frame id=\"23\" address=\"0x7FFE24BC1F03\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0xDB1F03\"/><frame id=\"24\" address=\"0x7FFE24BAADE2\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0xD9ADE2\"/><frame id=\"25\" address=\"0x7FFE23E25E1C\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x15E1C\"/><frame id=\"26\" address=\"0x740\"/>      </stackFrames>   <executionStack>    <frame procname=\"adhoc\" line=\"6\" stmtstart=\"58\" stmtend=\"176\" sqlhandle=\"0x020000008902b6141ee31ae1865c893c9823c9cf5d55fafb0000000000000000000000000000000000000000\">unknown    </frame>    <frame procname=\"adhoc\" line=\"6\" stmtstart=\"138\" stmtend=\"244\" sqlhandle=\"0x0200000092f64a0871e49fa174afd3d4abe705d8ac0555d50000000000000000000000000000000000000000\">unknown    </frame>   </executionStack>   <inputbuf>\n\nBEGIN TRAN \nUPDATE dbo.test_deadlock2\nSET name = 'CC'\nWHERE id = 1\n;\nUPDATE dbo.test_deadlock1\nSET name = 'CC'\nWHERE id = 1\n;\nCOMMIT   </inputbuf>  </process>  <process id=\"process1ec4a079468\" taskpriority=\"0\" logused=\"252\" waitresource=\"KEY: 6:72057594045857792 (8194443284a0)\" waittime=\"2937\" ownerId=\"212808764\" transactionname=\"user_transaction\" lasttranstarted=\"2025-11-25T11:42:14.277\" XDES=\"0x1ec5b8d0040\" lockMode=\"X\" schedulerid=\"1\" kpid=\"3500\" status=\"suspended\" spid=\"58\" sbid=\"0\" ecid=\"0\" priority=\"0\" trancount=\"3\" lastbatchstarted=\"2025-11-25T11:42:39.743\" lastbatchcompleted=\"2025-11-25T11:42:39.740\" lastattention=\"1900-01-01T00:00:00.740\" clientapp=\"Microsoft JDBC Driver for SQL Server\" hostname=\"dbs_das_service2\" hostpid=\"0\" loginname=\"rdsuser\" isolationlevel=\"read committed (2)\" xactid=\"212808764\" currentdb=\"6\" currentdbname=\"test\" lockTimeout=\"4294967295\" clientoption1=\"671088928\" clientoption2=\"128056\">   <stackFrames>      <frame id=\"00\" address=\"0x7FFE49B035A4\" pdb=\"ntdll.pdb\" age=\"1\" guid=\"DF7C6172-B6E3-7B68-CAFD-FFFE738D73FE\" module=\"ntdll\" rva=\"0xA35A4\"/><frame id=\"01\" address=\"0x7FFE4600A69F\" pdb=\"kernelbase.pdb\" age=\"1\" guid=\"944E4C6E-3A63-C6DD-3D02-46CB16FE5608\" module=\"kernelbase\" rva=\"0xFA69F\"/><frame id=\"02\" address=\"0x7FFE2C696747\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x6747\"/><frame id=\"03\" address=\"0x7FFE2C69666B\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x666B\"/><frame id=\"04\" address=\"0x7FFE2C691B2B\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x1B2B\"/><frame id=\"05\" address=\"0x7FFE2C693A07\" pdb=\"SqlDK.pdb\" age=\"2\" guid=\"7A015988-BA7A-4BCC-AAC9-0FA6496D4D79\" module=\"SqlDK\" rva=\"0x3A07\"/><frame id=\"06\" address=\"0x7FFE27B328C9\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x928C9\"/><frame id=\"07\" address=\"0x7FFE27B326D4\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x926D4\"/><frame id=\"08\" address=\"0x7FFE27AB04D4\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x104D4\"/><frame id=\"09\" address=\"0x7FFE27AB9EE8\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x19EE8\"/><frame id=\"10\" address=\"0x7FFE27ABDAE3\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1DAE3\"/><frame id=\"11\" address=\"0x7FFE27ABE63A\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1E63A\"/><frame id=\"12\" address=\"0x7FFE27ABF04F\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1F04F\"/><frame id=\"13\" address=\"0x7FFE27ABF133\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x1F133\"/><frame id=\"14\" address=\"0x7FFE27ACF359\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x2F359\"/><frame id=\"15\" address=\"0x7FFE31801BA7\" pdb=\"SqlTsEs.pdb\" age=\"2\" guid=\"B87B35EA-D9A0-4DD3-B8FB-56AAEB9DEA87\" module=\"SqlTsEs\" rva=\"0x1BA7\"/><frame id=\"16\" address=\"0x7FFE27B01401\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x61401\"/><frame id=\"17\" address=\"0x7FFE27ACB099\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x2B099\"/><frame id=\"18\" address=\"0x7FFE27B16F5F\" pdb=\"sqlmin.pdb\" age=\"2\" guid=\"FA28D090-6D0F-402A-B557-0C7B2D60C0EA\" module=\"sqlmin\" rva=\"0x76F5F\"/><frame id=\"19\" address=\"0x7FFE23E2AF28\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x1AF28\"/><frame id=\"20\" address=\"0x7FFE23E3A78C\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x2A78C\"/><frame id=\"21\" address=\"0x7FFE23E3A4EA\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x2A4EA\"/><frame id=\"22\" address=\"0x7FFE23E265DF\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x165DF\"/><frame id=\"23\" address=\"0x7FFE24BC1F03\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0xDB1F03\"/><frame id=\"24\" address=\"0x7FFE24BAADE2\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0xD9ADE2\"/><frame id=\"25\" address=\"0x7FFE23E25E1C\" pdb=\"sqllang.pdb\" age=\"2\" guid=\"C5C49A87-EFA6-476C-B4D2-5F40CC4CFCB2\" module=\"sqllang\" rva=\"0x15E1C\"/><frame id=\"26\" address=\"0xDAC\"/>      </stackFrames>   <executionStack>    <frame procname=\"adhoc\" line=\"7\" stmtstart=\"58\" stmtend=\"176\" sqlhandle=\"0x0200000070cad20bef4ae5ada9481eea2eb28415cd7e0c040000000000000000000000000000000000000000\">unknown    </frame>    <frame procname=\"adhoc\" line=\"7\" stmtstart=\"188\" stmtend=\"294\" sqlhandle=\"0x020000009b3b0b3aa1246daa2ff51a54d4e636d02b8559d40000000000000000000000000000000000000000\">unknown    </frame>   </executionStack>   <inputbuf>\n\nBEGIN TRAN \nUPDATE dbo.test_deadlock1\nSET name = 'CC'\nWHERE id = 1\n;\nWAITFOR DELAY '00:00:05'\nUPDATE dbo.test_deadlock2\nSET name = 'CC'\nWHERE id = 1\n;\nROLLBACK\n    </inputbuf>  </process> </process-list> <resource-list>  <keylock hobtid=\"72057594045792256\" dbid=\"6\" objectname=\"test.dbo.test_deadlock1\" indexname=\"PK__test_dea__3213E83FF9793901\" id=\"lock1eca4b68a80\" mode=\"X\" associatedObjectId=\"72057594045792256\">   <owner-list>    <owner id=\"process1ec4a079468\" mode=\"X\"/>   </owner-list>   <waiter-list>    <waiter id=\"process1ec8b6a04e8\" mode=\"X\" requestType=\"wait\"/>   </waiter-list>  </keylock>  <keylock hobtid=\"72057594045857792\" dbid=\"6\" objectname=\"test.dbo.test_deadlock2\" indexname=\"PK__test_dea__3213E83F09D7C5A8\" id=\"lock1eca4b2f480\" mode=\"X\" associatedObjectId=\"72057594045857792\">   <owner-list>    <owner id=\"process1ec8b6a04e8\" mode=\"X\"/>   </owner-list>   <waiter-list>    <waiter id=\"process1ec4a079468\" mode=\"X\" requestType=\"wait\"/>   </waiter-list>  </keylock> </resource-list></deadlock>"
}

状态码

错误码

请参见错误码。