| +++ |
| 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 | |
| |-----------|-------------|-------------------------------------------------------------------------------------| |
| | HY000 | 10000 | Can not support 3-tier structure for actual data node '%s' with JDBC '%s'. | |
| | HY004 | 10001 | Invalid format for actual data node '%s'. | |
| | 42S02 | 10002 | Schema '%s' does not exist. | |
| | 42S02 | 10003 | Table or view '%s' does not exist. | |
| | 42S02 | 10004 | Unknown column '%s' in '%s'. | |
| | HY000 | 10100 | Can not %s storage units '%s'. | |
| | 42S02 | 10101 | There is no storage unit in database '%s'. | |
| | 44000 | 10102 | Storage units '%s' do not exist in database '%s'. | |
| | 44000 | 10103 | Storage unit '%s' still used by '%s'. | |
| | 42S01 | 10104 | Duplicate storage unit names '%s'. | |
| | 08000 | 10110 | Storage units can not connect, error messages are: %s. | |
| | 0A000 | 10111 | Can not alter connection info in storage units: '%s'. | |
| | 44000 | 10120 | Invalid storage unit status, error message is: %s. | |
| | 44000 | 10200 | Invalid '%s' rule '%s', error message is: %s | |
| | 42S02 | 10201 | There is no rule in database '%s'. | |
| | 42S02 | 10202 | %s rules '%s' do not exist in database '%s'. | |
| | 44000 | 10203 | %s rules '%s' in database '%s' are still in used. | |
| | 42S01 | 10204 | Duplicate %s rule names '%s' in database '%s'. | |
| | 44000 | 10300 | Algorithm '%s.'%s' initialization failed, reason is: %s. | |
| | 44000 | 10301 | '%s' algorithm on %s is required. | |
| | 42S02 | 10302 | '%s' algorithm '%s' on %s is unregistered. | |
| | 44000 | 10303 | %s algorithms '%s' in database '%s' are still in used. | |
| | 44000 | 10304 | Invalid %s algorithm configuration '%s'. | |
| | HY000 | 10350 | Algorithm '%s.%s' execute failed, reason is: %s. | |
| | 44000 | 10400 | Invalid single rule configuration, reason is: %s. | |
| | 42S02 | 10401 | Single table '%s' does not exist. | |
| | HY000 | 10402 | Can not load table with database name '%s' and data source name '%s', reason is: %s | |
| | 0A000 | 10403 | Can not drop schema '%s' because of contains tables. | |
| |
| ### Data |
| |
| | SQL State | Vendor Code | Reason | |
| |-----------|-------------|-------------------------------------------------------| |
| | HY004 | 11000 | Unsupported conversion data type '%s' for value '%s'. | |
| | HY004 | 11001 | 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. | |
| | HY000 | 12021 | Column '%s' in %s is ambiguous. | |
| | 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 | |
| | 08000 | 13002 | The URL '%s' is not recognized, please refer to the pattern '%s'. | |
| | 0A000 | 13003 | Unsupported storage type of URL '%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. | |
| |
| ### 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 | |
| |
| ### DistSQL |
| |
| | SQL State | Vendor Code | Reason | |
| |-----------|-------------|------------------------------------------------------------| |
| | 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 | 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. | |
| |
| ### 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\.` | |
| | 44000 | 20296 | Read storage unit '%s' does not exist in rule '%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 | 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 | |
| | 0A000 | 30004 | Server exception: %s | |
