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. For a list of error codes for MySQL, see MySQL 5.7 Error Message Reference. In addition, TiDB has the following unique error codes:

• Error Number: 8001

  The memory used by the request exceeds the threshold limit for the TiDB memory usage.

  Increase the memory limit for a single SQL statement by configuring mem-quota-query.

• Error Number: 8002

  To 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.

  The application can safely retry the whole transaction.

• Error Number: 8003

  If the data in a row is not consistent with the index when executing the ADMIN CHECK TABLE command, TiDB returns this error. This error is commonly seen when you check the data corruption in the table.

  You can contact PingCAP for support.

• Error Number: 8004

  A single transaction is too large.

  See the error message transaction too large for the cause and solution.

• Error Number: 8005

  Transactions in TiDB encounter write conflicts.

  See the Troubleshoot section for the cause and solution.

• Error Number: 8018

  When you reload a plugin, if the plugin has not been loaded before, this error is returned.

  You can execute an initial load of the plugin.

• Error Number: 8019

  The version of the plugin that is being reloaded is different from the previous version. Therefore, the plugin cannot be reloaded, and this error is returned.

  You can reload the plugin by ensuring that the plugin version is the same as the previous one.

• Error Number: 8020

  When the table is locked, if you perform a write operation on the table, this error is returned.

  Unlock the table and retry the write operation.

• Error Number: 8021

  When the key to be read from TiKV does not exist, this error is returned. This error is used internally, and the external result is an empty read.

• Error Number: 8022

  The transaction commit fails and has been rolled back.

  The application can safely retry the whole transaction.

• Error Number: 8023

  If you set an empty value when writing the transaction cache, this error is returned. This error is used and dealt with internally, and is not returned to the application.

• Error Number: 8024

  Invalid transactions. If TiDB finds that no transaction ID (Start Timestamp) is obtained for the transaction that is being executed, which means this transaction is invalid, this error is returned.

  Usually this error does not occur. If you encounter this error, contact PingCAP for support.

• Error Number: 8025

  The single Key-Value pair being written is too large. The largest single Key-Value pair supported in TiDB is 6 MB by default.

  If a pair exceeds this limit, you need to properly adjust the txn-entry-size-limit configuration value to relax the limit.

• Error Number: 8026

  The interface function being used has not been implemented. This error is only used internally, and is not returned to the application.

• Error Number: 8027

  The table schema version is outdated. TiDB applies schema changes online. When the table schema version of the TiDB server is earlier than that of the entire system, this error is returned if you execute a SQL statement.

  When this error occurs, check the network between the TiDB server and the PD Leader.

• Error Number: 8028

  TiDB does not support table lock, which is called metadata lock in MySQL and might be called intention lock in other databases.

  When a transaction is executed, the transaction cannot recognize the table schema changes. Therefore, when committing a transaction, TiDB checks the table schema related the transaction. If the related table schema has changed during the execution, the transaction commit will fail and this error is returned.

  The application can safely retry the whole transaction.

• Error Number: 8029

  This error occurs when numeric conversion within the database encounters an error. This error is only used internally and is converted to a specific type of error for external applications.

• Error Number: 8030

  After an unsigned positive integer is converted to a signed integer, it exceeds the maximum value and displays as a negative integer. This error mostly occurs in the alert message.

• Error Number: 8031

  When being converted to an unsigned integer, a negative integer is converted to a positive integer. This error mostly occurs in the alert message.

• Error Number: 8032

  Invalid year format is used. year only accepts 1, 2 or 4 digits.

• Error Number: 8033

  Invalid year value is used. The valid range of year is (1901, 2155).

• Error Number: 8037

  Invalid mode format is used in the week function. mode must be 1 digit within [0, 7].

• Error Number: 8038

  The field fails to obtain the default value. This error is usually used internally, and is converted to a specific type of error for external applications.

• Error Number: 8040

  Unsupported operations are performed. For example, you perform a table locking operation on a view or a sequence.

• Error Number: 8047

  The value of the system variable is not supported. This error usually occurs in the alarm information when the user sets a variable value that is not supported in the database.

• Error Number: 8048

  An unsupported database isolation level is set.

  If you cannot modify the codes because you are using a third-party tool or framework, consider using tidb_skip_isolation_level_check to bypass this check.

  set @@tidb_skip_isolation_level_check = 1;
  

• Error Number: 8050

  An unsupported privilege type is set.

  See Privileges required for TiDB operations for the solution.

• Error Number: 8051

  Unknown data type is encountered when TiDB parses the Exec argument list sent by the client.

  If you encounter this error, check the client. If the client is normal, contact PingCAP for support.

• Error Number: 8052

  The serial number of the data packet from the client is incorrect.

  If you encounter this error, check the client. If the client is normal, contact PingCAP for support.

• Error Number: 8055

  The current snapshot is too old. The data may have been garbage collected. You can increase the value of tidb_gc_life_time to avoid this problem. TiDB automatically reserves data for long-running transactions. Usually this error does not occur.

  See garbage collection overview and garbage collection configuration.

• Error Number: 8059

  The auto-random ID is exhausted and cannot be allocated. There is no way to recover from such errors currently. It is recommended to use bigint when using the auto random feature to obtain the maximum number of assignment. And try to avoid manually assigning values to the auto random column.

  See auto random for reference.

• Error Number: 8060

  Invalid auto-incrementing offset. Check the values of auto_increment_increment and auto_increment_offset.

• Error Number: 8061

  Unsupported SQL Hint.

  See Optimizer Hints to check and modify the SQL Hint.

• Error Number: 8062

  An invalid token is used in SQL Hint. It conflicts with reserved words in SQL Hint.

  See Optimizer Hints to check and modify the SQL Hint.

• Error Number: 8063

  The limited memory usage set in SQL Hint exceeds the upper limit of the system. The setting in SQL Hint is ignored.

  See Optimizer Hints to check and modify the SQL Hint.

• Error Number: 8064

  It fails to parse SQL Hint.

  See Optimizer Hints to check and modify the SQL Hint.

• Error Number: 8065

  An invalid integer is used in SQL Hint.

  See Optimizer Hints to check and modify the SQL Hint.

• Error Number: 8066

  The second parameter in the JSON_OBJECTAGG function is invalid.

• Error Number: 8101

  The format of plugin ID is incorrect.

  The correct format is [name]-[version], and no - is allowed in name and version.

• Error Number: 8102

  Unable to read the plugin definition information.

  Check the configuration related to the plugin.

• Error Number: 8103

  The plugin name is incorrect.

  Check the configuration of the plugin.

• Error Number: 8104

  The plugin version does not match.

  Check the configuration of the plugin.

• Error Number: 8105

  The plugin is repeatedly loaded.

• Error Number: 8106

  The plugin defines a system variable whose name does not begin with the plugin name.

  Contact the developer of the plugin to modify.

• Error Number: 8107

  The loaded plugin does not specify a version, or the specified version is too low.

  Check the configuration of the plugin.

• Error Number: 8108

  Unsupported execution plan type. This error is an internal error.

  If you encounter this error, contact PingCAP for support.

• Error Number: 8109

  The specified index cannot be found when the index is analyzed.

• Error Number: 8110

  The Cartesian product operation cannot be executed.

  Set cross-join in the configuration to true.

• Error Number: 8111

  When executing the EXECUTE statement, the corresponding Prepare statement cannot be found.

• Error Number: 8112

  The number of parameters in the EXECUTE statement is not consistent with the Prepare statement.

• Error Number: 8113

  The table schema related in the EXECUTE statement has changed after the Prepare statement is executed.

• Error Number: 8115

  It is not supported to prepare multiple lines of statements.

• Error Number: 8116

  It is not supported to prepare DDL statements.

• Error Number: 8120

  The start tso of transactions cannot be obtained.

  Check the state/monitor/log of the PD server and the network between the TiDB server and the PD server.

• Error Number: 8121

  Privilege check fails.

  Check the privilege configuration of the database.

• Error Number: 8122

  No corresponding table name is found, given the specified wild cards.

• Error Number: 8123

  An SQL query with aggregate functions returns non-aggregated columns, which violates the only_full_group_by mode.

  Modify the SQL statement or disable the only_full_group_by mode.

• Error Number: 8129

  TiDB does not yet support JSON objects with the key length >= 65536.

• Error Number: 8200

  The DDL syntax is not yet supported.

  See compatibility of MySQL DDL for reference.

• Error Number: 8214

  The DDL operation is terminated by the admin cancel operation.

• Error Number: 8215

  ADMIN REPAIR TABLE fails.

  If you encounter this error, contact PingCAP for support.

• Error Number: 8216

  The usage of automatic random columns is incorrect.

  See auto random to modify.

• Error Number: 8223

  This error occurs when detecting that the data is not consistent with the index.

  If you encounter this error, contact PingCAP for support.

• Error Number: 8224

  The DDL job cannot be found.

  Check whether the job id specified by the restore operation exists.

• Error Number: 8225

  The DDL operation is completed and cannot be canceled.

• Error Number: 8226

  The DDL operation is almost completed and cannot be canceled.

• Error Number: 8227

  Unsupported options are used when creating Sequence.

  See Sequence documentation to find the list of the supported options.

• Error Number: 8228

  Unsupported types are specified when using setval on Sequence.

  See Sequence documentation to find the example of the function.

• Error Number: 8229

  The transaction exceeds the survival time.

  Commit or roll back the current transaction, and start a new transaction.

• Error Number: 8230

  TiDB currently does not support using Sequence as the default value on newly added columns, and reports this error if you use it.

• Error Number: 9001

  The PD request timed out.

  Check the state/monitor/log of the PD server and the network between the TiDB server and the PD server.

• Error Number: 9002

  The TiKV request timed out.

  Check the state/monitor/log of the TiKV server and the network between the TiDB server and the TiKV server.

• Error Number: 9003

  The TiKV server is busy and this usually occurs when the workload is too high.

  Check the state/monitor/log of the TiKV server.

• Error Number: 9004

  This error occurs when a large number of transactional conflicts exist in the database.

  Check the code of application.

• Error Number: 9005

  A 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.

• Error Number: 9006

  The 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.

• Error Number: 9500

  A single transaction is too large.

  See the error message transaction too large for the solution.

• Error Number: 9007

  Transactions in TiKV encounter write conflicts.

  See the Troubleshoot section for the cause and solution.

• Error Number: 9008

  Too many requests are sent to TiKV at the same time. The number exceeds limit.

  Increase tidb_store_limit or set it to 0 to remove the limit on the traffic of requests.

• Error Number: 9010

  TiKV cannot process this raft log.

  Check the state/monitor/log of the TiKV server.

• Error Number: 9012

  The TiFlash request timed out.

  Check the state/monitor/log of the TiFlash server and the network between the TiDB server and TiFlash server.

• Error Number: 9013

  The TiFlash server is busy and this usually occurs when the workload is too high.

  Check the state/monitor/log of the TiFlash server.

Troubleshooting

See the troubleshooting and FAQ documents.