接口功能介绍

获取死锁信息列表

接口约束

存在用户实例并拿到实例ID

URI

GET /RDS2/v1/open-api/deadlock/detail

路径参数 无

Query参数

请求参数

请求头header参数

请求体body参数 无

响应参数

枚举参数

无

请求示例

请求url

/RDS2/v1/open-api/deadlock/count?outerProdInstId=abc13cf3d9ef4576b54d95e16b68a2f7&pageNow=1&pageSize=10

请求头header

无

请求体body

无

响应示例

{
  "returnObj": {
    "data": [
      {
        "lockMode": "X",
        "ip": "127.0.0.1",
        "query": "sql语句1",
        "thread": 2163676,
        "lockType": "RECORD",
        "resId": 516,
        "waitHold": "w",
        "hostname": "",
        "port": 6301,
        "createTime": "2025-04-17T11:20:02.000+08:00",
        "host": "33.2.48.1",
        "txnTime": 21,
        "prodInstId": 9427,
        "victim": 1,
        "id": 140385,
        "idx": "PRIMARY",
        "user": "root",
        "db": "test01",
        "ts": "2025-04-16T15:23:16.000+08:00",
        "txnId": 0,
        "tbl": "customers"
      },
      {
        "lockMode": "X",
        "ip": "127.0.0.1",
        "query": "sql语句2",
        "thread": 2172156,
        "lockType": "RECORD",
        "resId": 516,
        "waitHold": "w",
        "hostname": "",
        "port": 6301,
        "createTime": "2025-04-17T11:20:02.000+08:00",
        "host": "33.2.48.1",
        "txnTime": 32,
        "prodInstId": 9427,
        "victim": 0,
        "id": 140386,
        "idx": "PRIMARY",
        "user": "root",
        "db": "test01",
        "ts": "2025-04-16T15:23:16.000+08:00",
        "txnId": 0,
        "tbl": "customers"
      }
    ]
  },
  "statusCode": 0,
  "message": "success"
}

状态码

请参考 状态码

错误码

请参考 错误码