Updated on 2026-08-25 GMT+08:00
Obtaining Raw Deadlock Data
Function
This API is used to obtain raw deadlock data.
Authorization Information
Each account has all the permissions required to call all APIs, but IAM users must be assigned the required permissions.
- If you are using role/policy-based authorization, see Permissions and Supported Actions for details on the required permissions.
- If you are using identity policy-based authorization, the permission listed below is required.
Action
Access Level
Resource Type (*: required)
Condition Key
Alias
Dependencies
das::showCloudDBAInfo
read
-
-
-
-
URI
GET /v3/{project_id}/instances/{instance_id}/dead-lock/get-dead-lock-origin-data
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| project_id | Yes | String | Definition Project ID of a tenant in a region. To obtain the value, see Obtaining a Project ID. Constraints N/A Range The value can contain 32 characters. Only letters and digits are allowed. Default Value N/A |
| instance_id | Yes | String | Definition Instance ID, which uniquely identifies an instance. Constraints N/A Range The value can contain 32 characters. Only letters and digits are allowed. Default Value N/A |
Request Parameters
| Parameter | Mandatory | Type | Description |
|---|---|---|---|
| dead_lock_id | Yes | String | Definition Deadlock ID. Constraints N/A Range N/A Default Value N/A |
| start_time | Yes | Long | Definition Start timestamp (ms). Constraints N/A Range N/A Default Value N/A |
| end_time | Yes | Long | Definition End timestamp (ms). Constraints N/A Range N/A Default Value N/A |
Response Parameters
Status code: 200
| Parameter | Type | Description |
|---|---|---|
| origin_data | String | Definition Raw XML data. Range N/A |
Example Requests
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
Example Responses
Status code: 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>"
} Status Codes
| Status Code | Description |
|---|---|
| 200 | Success. |
| 400 | Client error. |
| 500 | Server error. |
Error Codes
See Error Codes.
Parent topic: Intelligent O&M
What is your overall rating for this page?
0
1
2
3
4
5
6
7
8
9
10
Very dissatisfiedVery satisfied
Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot
