查询死锁日志

1. 接口描述

接口请求域名： dbbrain.tencentcloudapi.com 。

查询实例的死锁事件列表

默认接口请求频率限制：20次/秒。

2. 输入参数

以下请求参数列表仅列出了接口请求参数和部分公共参数，完整公共参数列表见 公共请求参数。

3. 输出参数

4. 示例

示例1 查询死锁日志

输入示例

POST / HTTP/1.1
Host: dbbrain.tencentcloudapi.com
Content-Type: application/json
X-TC-Action: DescribeDeadLockLogs
<公共请求参数>

{
    "Product": "sqlserver",
    "InstanceId": "mssql-15rso1sb",
    "StartTime": "2026-09-18 14:50:00",
    "EndTime": "2026-09-18 23:59:59"
}

输出示例

{
    "Response": {
        "HasMore": false,
        "TotalCount": 8,
        "Items": [
            {
                "InstanceId": "mssql-15rso1sb",
                "TimestampSource": "OBSERVED_LOG",
                "PartialReasonCode": "XML_NOT_AVAILABLE",
                "VictimProcessIds": [],
                "PayloadTruncated": false,
                "SourceUuids": [
                    "7ebe128e-fb90-4f2b-af4c-abc62336e478"
                ],
                "ObservedTransactionCount": 2,
                "GraphStatus": "MISSING",
                "XmlIncluded": false,
                "ProcessCount": 2,
                "Transactions": [
                    {
                        "Status": "Unknown",
                        "Sessions": [
                            {
                                "SqlFingerprint": null,
                                "LoginName": "sa",
                                "Frames": [],
                                "IsolationLevel": null,
                                "ProcessStatus": null,
                                "ClientApp": null,
                                "Priority": null,
                                "DatabaseName": null,
                                "LockHold": [],
                                "SqlText": null,
                                "Host": "30.101.245.168",
                                "DatabaseId": 11,
                                "IsVictim": null,
                                "WaitTimeMs": null,
                                "ExecutionContextId": null,
                                "LastTransStarted": null,
                                "ProcessId": null,
                                "ClientAppNormalized": null,
                                "LockRequest": [],
                                "SessionId": 61
                            }
                        ],
                        "IsVictim": null,
                        "TransactionId": "170329108"
                    }
                ],
                "DeadlockId": "75789",
                "XmlReport": "",
                "OriginalXmlBytes": null,
                "EventTimestamp": "2026-09-18T09:43:41.5434049+00:00",
                "VictimSessionIds": [
                    83
                ],
                "IsPartial": true,
                "DatabaseNames": [
                    "test_lock"
                ],
                "EventId": "partial:7ebe128e-fb90-4f2b-af4c-abc62336e478",
                "DeadlockSignature": "",
                "Resources": [],
                "AssociationStatus": "UNMATCHED",
                "TransactionCount": 2
            }
        ],
        "ResultVersion": "8cc6fd1f70a2dfbdaa69b590f5daab353a98c959fb24a9d342df483b550ec796",
        "RequestId": "13890fe3-ff26-419e-8b11-78b829cfa9c5"
    }
}

5. 开发者资源

腾讯云 API 平台

腾讯云 API 平台 是综合 API 文档、错误码、API Explorer 及 SDK 等资源的统一查询平台，方便您从同一入口查询及使用腾讯云提供的所有 API 服务。

API Inspector

用户可通过 API Inspector 查看控制台每一步操作关联的 API 调用情况，并自动生成各语言版本的 API 代码，也可前往 API Explorer 进行在线调试。

SDK

云 API 3.0 提供了配套的开发工具集（SDK），支持多种编程语言，能更方便的调用 API。

• Tencent Cloud SDK 3.0 for Python: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for Java: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for PHP: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for Go: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for Node.js: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for .NET: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for C++: CNB, GitHub, Gitee
• Tencent Cloud SDK 3.0 for Ruby: CNB, GitHub, Gitee

命令行工具

• Tencent Cloud CLI 3.0

6. 错误码

以下仅列出了接口业务逻辑相关的错误码，其他错误码详见 公共错误码。