+++
title = "SQL Error Code"
weight = 1
chapter = true
+++

SQL error codes provide by standard `SQL State`, `Vendor Code` and `Reason`, which return to client when SQL execute error.

**the error codes are draft, still need to be adjusted.**

## Kernel Exception

### Meta data

| SQL State | Vendor Code | Reason                                                                         |
|-----------|-------------|--------------------------------------------------------------------------------|
| 42000     | 10000       | There is no storage unit in database \`%s\`.                                   |
| 08000     | 10001       | The URL \`%s\` is not recognized, please refer to the pattern \`%s\`.          |
| 42000     | 10002       | Can not support 3-tier structure for actual data node \`%s\` with JDBC \`%s\`. |
| HY004     | 10003       | Invalid format for actual data node \`%s\`.                                    |
| HY000     | 10005       | Column '%s' in %s is ambiguous.                                                |
| 42S02     | 10006       | Unknown column '%s' in '%s'.                                                   |
| 42S02     | 10007       | Table or view \`%s\` does not exist.                                           |
| 42000     | 10010       | Rule does not exist.                                                           |
| 44000     | 10011       | Algorithm '%s.'%s' initialization failed, reason is: %s.                       |
| 44000     | 10012       | '%s' algorithm on database.table.column: '%s'.'%s'.'%s' is required.           |
| 42S02     | 10013       | '%s' algorithm '%s' on database.table.column: '%s'.'%s'.'%s' is unregistered.  |
| HY000     | 10015       | Algorithm '%s.%s' execute failed, reason is: %s.                               |
| 42S02     | 10020       | Schema \`%s\` does not exist.                                                  |
| 42S02     | 10021       | Single table \`%s\` does not exist.                                            |
| HY000     | 10022       | Can not load table with database name \`%s\` and data source name \`%s\`.      |
| 0A000     | 10030       | Can not drop schema \`%s\` because of contains tables.                         |
| 0A000     | 10040       | Unsupported storage type of \`%s.%s\`.                                         |

### Data

| SQL State | Vendor Code | Reason                                                    |
|-----------|-------------|-----------------------------------------------------------|
| HY004     | 11000       | Invalid value \`%s\`.                                     |
| HY004     | 11001       | Unsupported conversion data type \`%s\` for value \`%s\`. |
| HY004     | 11010       | Unsupported conversion stream charset \`%s\`.             |

### Syntax

| SQL State | Vendor Code | Reason                                   |
|-----------|-------------|------------------------------------------|
| 42000     | 12000       | You have an error in your SQL syntax: %s |
| 42000     | 12001       | Can not accept SQL type \`%s\`.          |
| 42000     | 12002       | SQL String can not be NULL or empty.     |
| 42000     | 12010       | Can not support variable \`%s\`.         |
| 42S02     | 12011       | Can not find column label \`%s\`.        |
| 42S02     | 12012       | Can not find url provider for \`%s`\.    |
| HV008     | 12020       | Column index \`%d\` is out of range.     |
| 0A000     | 12100       | DROP TABLE ... CASCADE is not supported. |

### Connection

| SQL State | Vendor Code | Reason                                                                                                                                                                                                                      |
|-----------|-------------|-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------|
| 08000     | 13000       | Can not register driver, reason is: %s                                                                                                                                                                                      |
| 08000     | 13001       | Can not register SQL federation driver, reason is: %s                                                                                                                                                                       |
| 01000     | 13010       | Circuit break open, the request has been ignored.                                                                                                                                                                           |
| 01000     | 13011       | The cluster status is read-only.                                                                                                                                                                                            |
| 01000     | 13012       | The cluster status is unavailable.                                                                                                                                                                                          |
| 08000     | 13020       | Can not get %d connections one time, partition succeed connection(%d) have released. Please consider increasing the \`maxPoolSize\` of the data sources or decreasing the \`max-connections-size-per-query\` in properties. |
| 08000     | 13030       | Connection has been closed.                                                                                                                                                                                                 |
| 08000     | 13031       | Result set has been closed.                                                                                                                                                                                                 |
| 08000     | 13032       | SQL execution has been interrupted.                                                                                                                                                                                         |
| HY000     | 13090       | Load datetime from database failed, reason: %s                                                                                                                                                                              |

### Transaction

| SQL State | Vendor Code | Reason                                                                             |
|-----------|-------------|------------------------------------------------------------------------------------|
| 25000     | 14000       | Switch transaction type failed, please terminate the current transaction.          |
| 25000     | 14001       | Can not find transaction manager of \`%s\`.                                        |
| 25000     | 14002       | Transaction timeout should more than 0s.                                           |
| 25000     | 14200       | Can not start new XA transaction in a active transaction.                          |
| 25000     | 14201       | Failed to create \`%s\` XA data source.                                            |
| 25000     | 14202       | Max length of xa unique resource name \`%s\` exceeded: should be less than 45.     |
| 25000     | 14203       | Check privileges failed on data source, reason is: \`%s\`                          |
| 25000     | 14204       | Failed to create XA transaction manager, requires \`%s\` privileges                |
| 25000     | 14205       | Close transaction manager failed, \`%s\`                                           |
| 25000     | 14301       | ShardingSphere Seata-AT transaction has been disabled.                             |
| 25000     | 14302       | Please config application id within seata.conf file.                               |

### Lock

| SQL State | Vendor Code | Reason                                                                               |
|-----------|-------------|--------------------------------------------------------------------------------------|
| HY000     | 15000       | The table \`%s\` of schema \`%s\` is locked.                                         |
| HY000     | 15001       | The table \`%s\` of schema \`%s\` lock wait timeout of \`%s\` milliseconds exceeded. |

### Audit

| SQL State | Vendor Code | Reason                               |
|-----------|-------------|--------------------------------------|
| 44000     | 16000       | SQL audit failed, error message: %s. |
| 44000     | 16001       | Hint datasource: %s is not exist.    |

### Authority

| SQL State | Vendor Code | Reason                            |
|-----------|-------------|-----------------------------------|

### Cluster

| SQL State | Vendor Code | Reason                                              |
|-----------|-------------|-----------------------------------------------------|
| HY000     | 17000       | Work ID assigned failed, which can not exceed 1024. |
| HY000     | 17002       | File access failed, file is: %s                     |
| HY000     | 17010       | Cluster persist repository error, reason is: %s     |

### Migration

| SQL State | Vendor Code | Reason                                                                            |
|-----------|-------------|-----------------------------------------------------------------------------------|
| 42S02     | 18002       | There is no rule in database \`%s\`.                                              |
| 44000     | 18003       | Mode configuration does not exist.                                                |
| 44000     | 18004       | Target database \`%s\` isn't exist.                                               |
| 22023     | 18005       | There is invalid parameter value: \`%s\`.                                         |
| HY000     | 18020       | Failed to get DDL for table \`%s\`.                                               |
| 42S01     | 18030       | Duplicate storage unit names \`%s\`.                                              |
| 42S02     | 18031       | Storage units names \`%s\` do not exist.                                          |
| HY000     | 18050       | Before data record is \`%s\`, after data record is \`%s\`.                        |
| 08000     | 18051       | Data check table \`%s\` failed.                                                   |
| 0A000     | 18052       | Unsupported pipeline database type \`%s\`.                                        |
| 0A000     | 18053       | Unsupported CRC32 data consistency calculate algorithm with database type \`%s\`. |
| 0A000     | 18054       | Unsupported mode type \`%s\`.                                                     |
| HY000     | 18080       | Can not find pipeline job \`%s\`.                                                 |
| HY000     | 18082       | Sharding count of job \`%s\` is 0.                                                |
| HY000     | 18083       | Can not split by range for table \`%s\`, reason is: %s                            |
| HY000     | 18084       | Can not split by unique key \`%s\` for table \`%s\`, reason is: %s                |
| HY000     | 18085       | Target table \`%s\` is not empty.                                                 |
| 01007     | 18086       | Source data source lacks %s privilege(s).                                         |
| HY000     | 18087       | Source data source required \`%s = %s\`, now is \`%s\`.                           |
| HY000     | 18088       | User \`%s\` does exist.                                                           |
| 08000     | 18089       | Check privileges failed on source data source, reason is: %s                      |
| 08000     | 18090       | Data sources can not connect, reason is: %s                                       |
| HY000     | 18091       | Importer job write data failed.                                                   |
| 08000     | 18092       | Get binlog position failed by job \`%s\`, reason is: %s                           |
| HY000     | 18095       | Can not find consistency check job of \`%s\`.                                     |
| HY000     | 18096       | Uncompleted consistency check job \`%s\` exists.                                  |
| HY000     | 18200       | Not find stream data source table.                                                |
| HY000     | 18201       | CDC server exception, reason is: %s.                                              |
| HY000     | 18202       | CDC login failed, reason is: %s                                                   |

### Resource Definition

| SQL State | Vendor Code | Reason                                                      |
|-----------|-------------|-------------------------------------------------------------|
| 44000     | 19000       | Can not process invalid storage units, error message is: %s |
| 44000     | 19001       | Storage units \`%s\` do not exist in database \`%s\`.       |
| 44000     | 19002       | There is no storage unit in the database \`%s\`.            |
| 44000     | 19003       | Storage units \`%s\` is still used by \`%s\`.               |
| 44000     | 19004       | Duplicate storage unit names \`%s\`.                        |
| 44000     | 19005       | Invalid storage unit status, error message is: %s.          |
| 44000     | 19006       | Read storage unit \`%s\` does not exist in rule \`%s\`.     |

### Rule Definition

| SQL State | Vendor Code | Reason                                                |
|-----------|-------------|-------------------------------------------------------|
| 44000     | 19100       | Invalid \`%s\` rule \`%s\`, error message is: %s      |
| 44000     | 19101       | %s rules \`%s\` do not exist in database \`%s\`.      |
| 44000     | 19102       | %s rules \`%s\` in database \`%s\` are still in used. |
| 44000     | 19105       | Duplicate %s rule names \`%s\` in database \`%s\`.    |
| 44000     | 19110       | There is no rule in database '%s'.                    |

### DistSQL

| SQL State | Vendor Code | Reason                                                     |
|-----------|-------------|------------------------------------------------------------|
| 44000     | 19150       | Invalid %s algorithm(s) \`%s\`.                            |
| 44000     | 19151       | %s algorithm(s) \`%s\` do not exist in database \`%s\`.    |
| 44000     | 19152       | %s algorithms \`%s\` in database \`%s\` are still in used. |
| 44000     | 19153       | Duplicate %s algorithms \`%s\` in database \`%s\`.         |
| 44000     | 19154       | Invalid mode, error message is: \`%s\`.                    |
| 44000     | 19155       | Plugin class \`%s\` not found..                            |

## Feature Exception

### Data Sharding

| SQL State | Vendor Code | Reason                                                                                                                           |
|-----------|-------------|----------------------------------------------------------------------------------------------------------------------------------|
| 44000     | 20000       | Can not find table rule with logic tables \`%s\`.                                                                                |
| 44000     | 20001       | Can not get uniformed table structure for logic table \`%s\`, it has different meta data of actual tables are as follows: %s     |
| 42S02     | 20002       | Can not find data source in sharding rule, invalid actual data node \`%s\`.                                                      |
| 44000     | 20003       | Data nodes must be configured for sharding table \`%s\`.                                                                         |
| 44000     | 20004       | Actual table \`%s.%s\` is not in table rule configuration.                                                                       |
| 44000     | 20005       | Can not find binding actual table, data source is \`%s\`, logic table is \`%s\`, other actual table is \`%s\`.                   |
| 44000     | 20006       | Actual tables \`%s\` are in use.                                                                                                 |
| 42S01     | 20007       | Index \`%s\` already exists.                                                                                                     |
| 42S02     | 20008       | Index \`%s\` does not exist.                                                                                                     |
| 42S01     | 20009       | View name has to bind to %s tables.                                                                                              |
| 44000     | 20010       | \`%s\` algorithm does not exist in database \`%s\`.                                                                              |
| 44000     | 20011       | \`%s\` configuration does not exist in database \`%s\`.                                                                          |
| 44000     | 20012       | Invalid binding table configuration in ShardingRuleConfiguration.                                                                |
| 44000     | 20013       | Can not find sharding rule.                                                                                                      |
| 44000     | 20014       | Only allowed 0 or 1 sharding strategy configuration.                                                                             |
| 44000     | 20020       | Sharding value can't be null in sql statement.                                                                                   |
| HY004     | 20021       | Found different types for sharding value \`%s\`.                                                                                 |
| HY004     | 20022       | Invalid %s, datetime pattern should be \`%s\`, value is \`%s\`.                                                                  |
| 44000     | 20023       | Sharding value %s subtract stop offset %d can not be less than start offset %d.                                                  |
| 44000     | 20024       | %s value \`%s\` must implements Comparable.                                                                                      |
| 0A000     | 20040       | Can not support operation \`%s\` with sharding table \`%s\`.                                                                     |
| 44000     | 20041       | Can not update sharding value for table \`%s\`.                                                                                  |
| 0A000     | 20042       | The CREATE VIEW statement contains unsupported query statement.                                                                  |
| 44000     | 20043       | PREPARE statement can not support sharding tables route to same data sources.                                                    |
| 44000     | 20044       | The table inserted and the table selected must be the same or bind tables.                                                       |
| 0A000     | 20045       | Can not support DML operation with multiple tables \`%s\`.                                                                       |
| 42000     | 20046       | %s ... LIMIT can not support route to multiple data nodes.                                                                       |
| 44000     | 20047       | Can not find actual data source intersection for logic tables \`%s\`.                                                            |
| 42000     | 20048       | INSERT INTO ... SELECT can not support applying key generator with absent generate key column.                                   |
| 0A000     | 20049       | Alter view rename .. to .. statement should have same config for \`%s\` and \`%s\`.                                              |
| HY000     | 20060       | \`%s %s\` can not route correctly for %s \`%s\`.                                                                                 |
| 42S02     | 20061       | Can not get route result, please check your sharding rule configuration.                                                         |
| 34000     | 20062       | Can not get cursor name from fetch statement.                                                                                    |
| HY000     | 20080       | Sharding algorithm class \`%s\` should be implement \`%s\`.                                                                      |
| HY000     | 20081       | Routed target \`%s\` does not exist, available targets are \`%s\`.                                                               |
| 44000     | 20082       | Inline sharding algorithms expression \`%s\` and sharding column \`%s\` do not match.                                            |
| 44000     | 20084       | Complex inline algorithm need %d sharing columns, but only found %d.                                                             |
| 44000     | 20085       | No sharding database route info.                                                                                                 |
| 44000     | 20086       | Some routed data sources do not belong to configured data sources. routed data sources: \`%s\`, configured data sources: \`%s\`. |
| 44000     | 20087       | Please check your sharding conditions \`%s\` to avoid same record in table \`%s\` routing to multiple data nodes.                |
| 44000     | 20088       | Cannot found routing table factor, data source: %s, actual table: %s.                                                            |
| HY000     | 20099       | Sharding plugin error, reason is: %s                                                                                             |

### Readwrite-splitting

| SQL State | Vendor Code | Reason                                                                                      |
|-----------|-------------|---------------------------------------------------------------------------------------------|
| 44000     | 20270       | Inline expression %s names size error.                                                      |
| HY004     | 20280       | Invalid read database weight \`%s\`.                                                        |
| 44000     | 20290       | Data source name is required in database \`%s\.`                                            |
| 44000     | 20291       | Write data source name is required in database `\`%s\.`                                     |
| 44000     | 20292       | Read data source names is required in database `\`%s\.`                                     |
| 44000     | 20293       | Can not config duplicate %s data source \`%s\` in database \`%s\.`                          |
| 42S02     | 20294       | %s data source name \`%s\` not in database \`%s\.`                                          |
| 44000     | 20295       | Auto aware data source name is required in database \`%s\.`                                 |
| 42S02     | 20296       | Not found load balance type in database \`%s\.`                                             |

### Database HA

| SQL State | Vendor Code | Reason                                                                       |
|-----------|-------------|------------------------------------------------------------------------------|
| 44000     | 20300       | No available database discovery rule configuration in database \`%s\`.       |
| 44000     | 20301       | Group name is required.                                                      |
| 44000     | 20302       | Data source names are required.                                              |
| 44000     | 20303       | Can not found database discovery data source rule in database \`%s\`.        |
| HY000     | 20380       | MGR plugin is not active in database \`%s\`.                                 |
| 44000     | 20381       | MGR is not in single primary mode in database \`%s\`.                        |
| 44000     | 20382       | \`%s\` is not in MGR replication group member in database \`%s\`.            |
| 44000     | 20383       | Group name in MGR is not same with configured one \`%s\` in database \`%s\`. |
| 42S01     | 20390       | MySQL Duplicate primary data source in database \`%s\`.                      |
| 42S02     | 20391       | Primary data source not found in database \`%s\`.                            |

### SQL Dialect Translator

| SQL State | Vendor Code | Reason                                              |
|-----------|-------------|-----------------------------------------------------|
| 42000     | 20440       | Can not support database \`%s\` in SQL translation. |
| 42000     | 20441       | Translation error, SQL is: %s                       |

### Traffic Management

| SQL State | Vendor Code | Reason                              |
|-----------|-------------|-------------------------------------|
| 42S02     | 20500       | Can not get traffic execution unit. |

### Data Encrypt

| SQL State | Vendor Code | Reason                                                                                                |
|-----------|-------------|-------------------------------------------------------------------------------------------------------|
| 44000     | 20700       | Can not find logic encrypt column by \`%s\`.                                                          |
| 44000     | 20701       | Fail to find encrypt column \`%s\` from table \`%s\`.                                                 |
| 44000     | 20702       | Altered column \`%s\` must use same encrypt algorithm with previous column \`%s\` in table \`%s\`.    |
| 42000     | 20740       | Insert value of index \`%s\` can not support for encrypt.                                             |
| 0A000     | 20741       | The SQL clause \`%s\` is unsupported in encrypt rule.                                                 |
| HY004     | 20781       | \`%s\` column's encryptor name \`%s\` does not match encrypt algorithm type \`%s\ in database \`%s\`. |
| 44000     | 20703       | Cipher column of \`%s\` can not be null in database \`%s\`.                                           |
| 44000     | 20704       | Can not find (STANDARD\|ASSIST_QUERY\|LIKE_QUERY) encryptor in table \`%s\` and column \`%s\`.        |
| 44000     | 20705       | Assisted query column of \`%s\` can not be null in database \`%s\`.                                   |
| 44000     | 20707       | Like query column of \`%s\` can not be null in database \`%s\`.                                       |
| 44000     | 20709       | Can not find encrypt table: \`%s\`.                                                                   |

### Shadow Database

| SQL State | Vendor Code | Reason                                                                                            |
|-----------|-------------|---------------------------------------------------------------------------------------------------|
| 44000     | 20800       | \`%s\` algorithm does not exist in database \`%s\`.                                               |
| 44000     | 20801       | \`%s\` configuration does not exist in database \`%s\`.                                           |
| 44000     | 20802       | No available shadow data sources mappings in shadow table \`%s\`.                                 |
| 44000     | 20803       | Column shadow algorithm \`%s\` operation only supports one column mapping in shadow table \`%s\`. |
| HY004     | 20820       | Shadow column \`%s\` of table \`%s\` does not support \`%s\` type.                                |
| 42000     | 20840       | Insert value of index \`%s\` can not support for shadow.                                          |
| 44000     | 20881       | Default shadow algorithm class should be implement HintShadowAlgorithm.                           |

### SQL Federation

| SQL State | Vendor Code | Reason                                                    |
|-----------|-------------|-----------------------------------------------------------|
| 42000     | 22040       | Unsupported SQL node conversion for SQL statement \`%s\`. |
| 42000     | 22041       | SQL federation doesn't support SQL \`%s\` execution.      |

## Other Exception

| SQL State | Vendor Code | Reason                          |
|-----------|-------------|---------------------------------|
| HY004     | 30000       | Unknown exception: %s           |
| 0A000     | 30001       | Unsupported SQL operation: %s   |
| 0A000     | 30002       | Database protocol exception: %s |
| 0A000     | 30003       | Unsupported command: %s         |