Sign InTry Free

Error Codes and Troubleshooting

This document describes the problems encountered during the use of TiDB and provides the solutions.

Error codes

TiDB is compatible with the error codes in MySQL, and in most cases returns the same error code as MySQL. In addition, TiDB has the following unique error codes:

Error codeDescriptionSolution
8001The memory used by the request exceeds the threshold limit for the TiDB memory usage.Increase the value of the system variable with the tidb_mem_quota prefix.
8002To guarantee consistency, a transaction with the SELECT FOR UPDATE statement cannot be retried when it encounters a commit conflict. TiDB rolls back the transaction and returns this error.Retry the failed transaction.
8003If the data in a row is not consistent with the index when executing the ADMIN CHECK TABLE command, TiDB returns this error.
8004A single transaction is too large.See the error message transaction too large for the cause and solution.
8005Transactions in TiDB encounter write conflicts.See the Troubleshoot section for the cause and solution.
9001The PD request timed out.Check the state/monitor/log of the PD server and the network between the TiDB server and the PD server.
9002The TiKV request timed out.Check the state/monitor/log of the TiKV server and the network between the TiDB server and the TiKV server.
9003The TiKV server is busy and this usually occurs when the workload is too high.Check the state/monitor/log of the TiKV server.
9004This error occurs when a large number of transactional conflicts exist in the database.Check the code of application.
9005A certain Raft Group is not available, such as the number of replicas is not enough. This error usually occurs when the TiKV server is busy or the TiKV node is down.Check the state/monitor/log of the TiKV server.
9006The interval of GC Life Time is too short and the data that should be read by the long transactions might be cleared.Extend the interval of GC Life Time.
9500A single transaction is too large.See the error message transaction too large for the solution.
9007Transactions in TiKV encounter write conflicts.See the Troubleshoot section for the cause and solution.

Troubleshooting

See the troubleshooting and FAQ documents.

Download PDF
Playground
New
One-stop & interactive experience of TiDB's capabilities WITHOUT registration.
Products
TiDB
TiDB Dedicated
TiDB Serverless
Pricing
Get Demo
Get Started
© 2024 PingCAP. All Rights Reserved.
Privacy Policy.