Error Codes and Troubleshooting

本文档描述了d遇到的问题uring 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, seeMySQL 5.7 Error Message Reference. In addition, TiDB has the following unique error codes:

Note

Some error codes stand for internal errors. Normally, TiDB handles the error rather than return it to the user, so some error codes are not listed here.

If you encounter an error code that is not listed here,get supportfrom PingCAP or the community.

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 the system variabletidb_mem_quota_query.
Error Number: 8002
To guarantee consistency, a transaction with theSELECT FOR UPDATEstatement 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 theADMIN CHECK TABLEcommand, TiDB returns this error. This error is commonly seen when you check the data corruption in the table.
You canget supportfrom PingCAP or the community.
Error Number: 8004
A single transaction is too large.
Seethe error messagetransaction too largefor the cause and solution.
Error Number: 8005
The complete error message:ERROR 8005 (HY000): Write Conflict, txnStartTS is stale
Transactions in TiDB encounter write conflicts. Check your application logic and retry the write operation.
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,get supportfrom PingCAP or the community.
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 thetxn-entry-size-limitconfiguration 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
Since v6.3.0, TiDB introduces theMetadata lockfeature. When the metadata lock is disabled and a transaction is executed, the transaction cannot recognize the table schema changes. Therefore, when the transaction is committed, TiDB checks the table schema related to the transaction. If the related table schema has been changed during the execution, the transaction commit fails with this error. At this time, the application can safely retry the whole transaction.
When the metadata lock is enabled not in the Read Committed isolation level, if a lossy column type change occurs on a table (for example, changing fromINTtoCHARis lossy, and changing fromTINYINTtoINTis not lossy because overwriting data is not required) from a transaction start to access the table for the first time, then the query fails while the transaction will not roll back automatically. You can continue to execute other statements and decide whether to roll back or commit the transaction.
Error Number: 8029
这个错误发生在数字转换在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
Invalidyearformat is used.yearonly accepts 1, 2 or 4 digits.
Error Number: 8033
Invalidyearvalue is used. The valid range ofyearis (1901, 2155).
Error Number: 8037
Invalidmodeformat is used in theweekfunction.modemust 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

一个不受支持的数据库隔离级别设置。

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


                
                 set@@tidb_skip_isolation_level_check=
                 1;

Error Number: 8050
An unsupported privilege type is set.
SeePrivileges required for TiDB operationsfor 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,get supportfrom PingCAP or the community.
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,get supportfrom PingCAP or the community.
Error Number: 8055
The current snapshot is too old. The data may have been garbage collected. You can increase the value oftidb_gc_life_timeto avoid this problem. TiDB automatically reserves data for long-running transactions. Usually this error does not occur.
Seegarbage collection overviewandgarbage collection configuration.
Error Number: 8059
auto-random ID是筋疲力尽,不能紧密相联的cated. 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.
Seeauto randomfor reference.
Error Number: 8060
Invalid auto-incrementing offset. Check the values ofauto_increment_incrementandauto_increment_offset.
Error Number: 8061
Unsupported SQL Hint.
SeeOptimizer Hintsto 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.
SeeOptimizer Hintsto 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.
SeeOptimizer Hintsto check and modify the SQL Hint.
Error Number: 8064
It fails to parse SQL Hint.
SeeOptimizer Hintsto check and modify the SQL Hint.
Error Number: 8065
An invalid integer is used in SQL Hint.
SeeOptimizer Hintsto check and modify the SQL Hint.
Error Number: 8066
The second parameter in theJSON_OBJECTAGGfunction is invalid.
Error Number: 8101
The format of plugin ID is incorrect.
The correct format is[name]-[version], and no-is allowed innameandversion.
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.
有限公司ntact the developer of the plugin to modify, orget supportfrom PingCAP or the community.
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,get supportfrom PingCAP or the community.
Error Number: 8109
The specified index cannot be found when the index is analyzed.
Error Number: 8110
The Cartesian product operation cannot be executed.
Setcross-joinin the configuration totrue.
Error Number: 8111
When executing theEXECUTEstatement, the correspondingPreparestatement cannot be found.
Error Number: 8112
The number of parameters in theEXECUTEstatement is not consistent with thePreparestatement.
Error Number: 8113
The table schema related in theEXECUTEstatement has changed after thePreparestatement 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
Thestart tsoof 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
一个SQL查询与聚合函数返回非aggregated columns, which violates theonly_full_group_bymode.
Modify the SQL statement or disable theonly_full_group_bymode.
Error Number: 8129
TiDB does not yet support JSON objects with the key length >= 65536.
Error Number: 8130
The complete error message:ERROR 8130 (HY000): client has multi-statement capability disabled
This error might occur after you upgrade from an earlier version of TiDB. To reduce the impact of SQL injection attacks, TiDB now prevents multiple queries from being executed in the sameCOM_QUERYcall by default.
The system variabletidb_multi_statement_modecan be used to control this behavior.
Error Number: 8138
The transaction attempts to write an incorrect row value. For more information, seeTroubleshoot Inconsistency Between Data and Indexes.
Error Number: 8139
The transaction attempts to write a row whose handle is inconsistent with that in the index. For more information, seeTroubleshoot Inconsistency Between Data and Indexes.
Error Number: 8140
The transaction attempts to write a row whose data is inconsistent with the index data. For more information, seeTroubleshoot Inconsistency Between Data and Indexes.
Error Number: 8141
When a transaction is being committed, the existence assertion of a key fails. For more information,seeTroubleshoot Inconsistency Between Data and Indexes.
Error Number: 8143
During the execution of a non-transactional DML statement, if a batch fails, the statement is stopped. For more information, seeNon-transactional DML statements.
Error Number: 8147
Whentidb_constraint_check_in_place_pessimisticis set toOFF, to ensure the correctness of transactions, any errors in the SQL statement execution might cause TiDB to return this8147error and abort the current transaction. For specific causes of the error, refer to the error message. For more information, see有限公司nstraints.
Error Number: 8154
CurrentlyLOAD DATAdoes not support importing data locally from TiDB server. You can specifyLOCALto import from client, or upload data to S3 or GCS and then import it. SeeLOAD DATA.
Error Number: 8156
The file path of theLOAD DATAstatement cannot be empty. You need to set the correct path before importing. SeeLOAD DATA.
Error Number: 8158
The S3 or GCS path is invalid. Seeexternal storageto set a valid path.
Error Number: 8159
TiDB cannot access the S3 or GCS path provided in theLOAD DATAstatement. Make sure that the S3 or GCS bucket exists, and that you have used the correct access key and secret access key to let TiDB access the bucket.
Error Number: 8160
LOAD DATAfails to read the data file. Refer to the specific error message for action.
Error Number: 8162
There is an error in theLOAD DATAstatement. SeeLOAD DATAfor supported features.
Error Number: 8200
The DDL syntax is not yet supported.
Seecompatibility of MySQL DDLfor reference.
Error Number: 8214
The DDL operation is terminated by theadmin canceloperation.
Error Number: 8215
ADMIN REPAIR TABLEfails.
If you encounter this error,get supportfrom PingCAP or the community.
Error Number: 8216
The usage of automatic random columns is incorrect.
Seeauto randomto modify.
Error Number: 8223
This error occurs when detecting that the data is not consistent with the index.
If you encounter this error,get supportfrom PingCAP or the community.
Error Number: 8224
The DDL job cannot be found.
Check whether the job id specified by therestoreoperation 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.
SeeSequence documentationto find the list of the supported options.
Error Number: 8228
Unsupported types are specified when usingsetvalon Sequence.
SeeSequence documentationto find the example of the function.
Error Number: 8229
The transaction exceeds the survival time.
有限公司mmit 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: 8248
The resource group already exists. This error is returned when a resource group is repeatedly created.
Error Number: 8249
The resource group does not exist. This error is returned when you modify or bind a resource group that does not exist. SeeCreate a resource group.
Error Number: 8250
The complete error message is as follows:
ERROR 8250 (HY000) : Resource control feature is disabled. Run "SET GLOBAL tidb_enable_resource_control='on'" to enable the feature
This error is returned when you try to use the resource control feature but it is not enabled. You can turn on the global variabletidb_enable_resource_controlto enable resource control.
Error Number: 8251
TheResource Controlcomponent is initialized upon TiDB startup. The associated configuration is fetched from theResource Manageron the server side ofResource Control. This error is returned if there is an error during this process.
Error Number: 8252
The complete error message is as follows:
ERROR 8252 (HY000) : Exceeded resource group quota limitation
This error is returned when the attempted consumption exceeds the resource group limit. This error is usually caused by a single transaction that is too large or too many concurrent transactions. You need to adjust the transaction size or reduce the number of concurrent clients.
Error Number: 9001
The complete error message:ERROR 9001 (HY000): PD Server Timeout
The PD request timed out.
Check the status, monitoring data and log of the PD server, and the network between the TiDB server and the PD server.
Error Number: 9002
The complete error message:ERROR 9002 (HY000): TiKV Server Timeout
The TiKV request timed out.
Check the status, monitoring data and log of the TiKV server, and the network between the TiDB server and the TiKV server.
Error Number: 9003
The complete error message:ERROR 9003 (HY000): TiKV Server is Busy
The TiKV server is busy and this usually occurs when the workload is too high.
Check the status, monitoring data, and log of the TiKV server.
Error Number: 9004
The complete error message:ERROR 9004 (HY000): Resolve Lock Timeout
A lock resolving timeout. This error occurs when a large number of transactional conflicts exist in the database.
Check the application code to see whether lock contention exists in the database.
Error Number: 9005
The complete error message:ERROR 9005 (HY000): Region is unavailable
The accessed Region or a certain Raft Group is not available, with possible reasons such as insufficient replicas. This error usually occurs when the TiKV server is busy or the TiKV node is down.
Check the status, monitoring data and log of the TiKV server.
Error Number: 9006
The complete error message:ERROR 9006 (HY000): GC life time is shorter than transaction duration
The interval ofGC Life Timeis too short. The data that should have been read by long transactions might be deleted. You can adjusttidb_gc_life_timeusing the following command:
```
                
                 SET
                 GLOBALtidb_gc_life_time=
                 '30m';
```
Note

"30m" means only cleaning up the data generated 30 minutes ago, which might consume some extra storage space.
Error Number: 9500
A single transaction is too large.
Seethe error messagetransaction too largefor the solution.
Error Number: 9007
The error message starts withERROR 9007 (HY000): Write conflict.
If the error message containsreason=LazyUniquenessCheck, it means that the transaction is pessimistic,@@tidb_constraint_check_in_place_pessimistic=OFFis set, and a write conflict occurs on a unique index for the application. In this case, successful execution of the pessimistic transaction is not guaranteed. You can retry the transaction from the application, or set the variable toONto avoid the error.
Error Number: 9008
Too many requests are sent to TiKV at the same time. The number exceeds limit.
Increasetidb_store_limitor set it to0to 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.

MySQL native error messages

Error Number: 2013 (HY000)
The complete error message:ERROR 2013 (HY000): Lost connection to MySQL server during query
You can handle this error as follows:
- Check whether panic is in the log.
- Check whether OOM exists in dmesg usingdmesg -T | grep -i oom.
- A long time of no access might also lead to this error. It is usually caused by TCP timeout. If TCP is not used for a long time, the operating system kills it.
Error Number: 1105 (HY000)
The complete error message:ERROR 1105 (HY000): other error: unknown error Wire Error(InvalidEnumValue(4004))
This error usually occurs when the version of TiDB does not match with that of TiKV. To avoid version mismatch, upgrade all components when you upgrade the version.
Error Number: 1148 (42000)
The complete error message:ERROR 1148 (42000): the used command is not allowed with this TiDB version
When you execute theLOAD DATA LOCALstatement but the MySQL client does not allow executing this statement (the value of thelocal_infileoption is 0), this error occurs.
The solution is to use the--local-infile=1option when you start the MySQL client. For example, run the commandmysql --local-infile=1 -u root -h 127.0.0.1 -P 4000. The default value oflocal-infilevaries in different versions of the MySQL client. Therefore, you need to configure it in specific MySQL clients.
Error Number: 9001 (HY000)
The complete error message:ERROR 9001 (HY000): PD server timeout start timestamp may fall behind safe point
This error occurs when TiDB fails to access PD. A worker in the TiDB background continuously queries the safepoint from PD and reports this error if it fails to query within 100s. Generally, it is because the disk on PD is slow and busy or the network failed between TiDB and PD. For the details of common errors, seeError Number and Fault Diagnosis.
TiDB log error message: EOF error
When the client or proxy disconnects from TiDB, TiDB does not immediately notice the disconnection. Instead, TiDB notices the disconnection only when it begins to return data to the connection. At this time, the log prints an EOF error.

Troubleshooting

See thetroubleshootingandFAQdocuments.