GET /v{version}/diagnosis/mysql/deadlock/latest?appId=appId&nodeId=nodeId HTTP/1.1
Host: dbsc.bj.baidubce.com
Authorization: authorization string

GET /v1/diagnosis/mysql/deadlock/latest?appId=rds-0mxm0cTI&nodeId=rds-0mxm0cTI HTTP/1.1
Host: dbsc.bj.baidubce.com
Content-Type: application/json
Authorization: bce-auth-v1/f81d3b34e48048fbb2634dc7882d7e21/2023-07-11T11:17:29Z/3600/host/74c506f68c65e26c633bfa104c863fffac5190fdec1ec24b7c03eb5d67d2e1de

HTTP/1.1 200 OK
Content-Type: application/json;charset=UTF-8
x-bce-request-id: d8752367-38e8-45e4-b4c7-e53be3137ce5
{
    "transactionLocks": [
        {
            "trxSeq": 1,
            "trxId": "1536028",
            "trxTime": "2024-10-18T02:54:12Z",
            "duration": 86,
            "ip": "",
            "hostname": "localhost",
            "threadID": 5537930,
            "user": "_root",
            "query": "select * from deadlock where id=2 for update",
            "victim": 0,
            "locks": [
                {
                    "lockType": "RECORD",
                    "lockMode": "X",
                    "database": "db1",
                    "table": "deadlock",
                    "index": "PRIMARY",
                    "recordLockType": "LOCK_REC_NOT_GAP",
                    "spaceId": 2256,
                    "pageNo": 3,
                    "heapNo": 3,
                    "waitHold": "WAIT",
                    "isPrediction": false
                },
                {
                    "lockType": "RECORD",
                    "lockMode": "X",
                    "database": "db1",
                    "table": "deadlock",
                    "index": "PRIMARY",
                    "recordLockType": "LOCK_REC_NOT_GAP",
                    "spaceId": 2256,
                    "pageNo": 3,
                    "heapNo": 2,
                    "waitHold": "HOLD",
                    "isPrediction": true
                }
            ]
        },
        {
            "trxSeq": 2,
            "trxId": "1536052",
            "trxTime": "2024-10-18T02:55:21Z",
            "duration": 17,
            "ip": "",
            "hostname": "localhost",
            "threadID": 5538800,
            "user": "_root",
            "query": "select * from deadlock where id=1 for update",
            "victim": 1,
            "locks": [
                {
                    "lockType": "RECORD",
                    "lockMode": "X",
                    "database": "db1",
                    "table": "deadlock",
                    "index": "PRIMARY",
                    "recordLockType": "LOCK_REC_NOT_GAP",
                    "spaceId": 2256,
                    "pageNo": 3,
                    "heapNo": 3,
                    "waitHold": "HOLD",
                    "isPrediction": false
                },
                {
                    "lockType": "RECORD",
                    "lockMode": "X",
                    "database": "db1",
                    "table": "deadlock",
                    "index": "PRIMARY",
                    "recordLockType": "LOCK_REC_NOT_GAP",
                    "spaceId": 2256,
                    "pageNo": 3,
                    "heapNo": 2,
                    "waitHold": "WAIT",
                    "isPrediction": false
                }
            ]
        }
    ],
    "metaInfo": {
        "timestamp": "2024-10-18T02:55:38Z",
        "deadLockId": "7fa0d07a5700"
    },
    "rawContent": "------------------------\nLATEST DETECTED DEADLOCK\n------------------------\n2024-10-18 10:55:38 7fa0d07a5700\n*** (1) TRANSACTION:\nTRANSACTION 1536028, ACTIVE 86 sec starting index read\nmysql tables in use 1, locked 1\nLOCK WAIT 3 lock struct(s), heap size 360, 2 row lock(s)\nMySQL thread id 5537930, OS thread handle 0x7fa0d1c6d700, query id 39824554 localhost _root statistics\nselect * from deadlock where id=2 for update\n*** (1) WAITING FOR THIS LOCK TO BE GRANTED:\nRECORD LOCKS space id 2256 page no 3 n bits 72 index `PRIMARY` of table `db1`.`deadlock` trx id 1536028 lock_mode X locks rec but not gap waiting\nRecord lock, heap no 3 PHYSICAL RECORD: n_fields 5; compact format; info bits 0\n 0: len 4; hex 80000002; asc     ;;\n 1: len 6; hex 00000017700d; asc     p ;;\n 2: len 7; hex e5000001e20110; asc        ;;\n 3: len 4; hex 80000016; asc     ;;\n 4: len 4; hex 800000de; asc     ;;\n\n*** (2) TRANSACTION:\nTRANSACTION 1536052, ACTIVE 17 sec starting index read\nmysql tables in use 1, locked 1\n3 lock struct(s), heap size 360, 2 row lock(s)\nMySQL thread id 5538800, OS thread handle 0x7fa0d07a5700, query id 39824639 localhost _root statistics\nselect * from deadlock where id=1 for update\n*** (2) HOLDS THE LOCK(S):\nRECORD LOCKS space id 2256 page no 3 n bits 72 index `PRIMARY` of table `db1`.`deadlock` trx id 1536052 lock_mode X locks rec but not gap\nRecord lock, heap no 3 PHYSICAL RECORD: n_fields 5; compact format; info bits 0\n 0: len 4; hex 80000002; asc     ;;\n 1: len 6; hex 00000017700d; asc     p ;;\n 2: len 7; hex e5000001e20110; asc        ;;\n 3: len 4; hex 80000016; asc     ;;\n 4: len 4; hex 800000de; asc     ;;\n\n*** (2) WAITING FOR THIS LOCK TO BE GRANTED:\nRECORD LOCKS space id 2256 page no 3 n bits 72 index `PRIMARY` of table `db1`.`deadlock` trx id 1536052 lock_mode X locks rec but not gap waiting\nRecord lock, heap no 2 PHYSICAL RECORD: n_fields 5; compact format; info bits 0\n 0: len 4; hex 80000001; asc     ;;\n 1: len 6; hex 00000017700c; asc     p ;;\n 2: len 7; hex e4000001e10110; asc        ;;\n 3: len 4; hex 8000000b; asc     ;;\n 4: len 4; hex 8000006f; asc    o;;\n\n*** WE ROLL BACK TRANSACTION (2)\n------------"
}