Aikesheng Open Source Community

May 23, 2024 · Databases

Troubleshooting SQL Exception Retries in OceanBase Using Logs and gv$sql_audit

This article demonstrates how to diagnose and resolve repeated UPDATE failures in OceanBase by extracting information from Top SQL, log files, and the gv$sql_audit view, identifying error codes such as 6005, 6003, and 6212, and applying corrective actions like adjusting timeout settings, killing lock‑holding sessions, and checking lock statistics.