PDO Exception
PDOException extends RuntimeException {
/* Properties */
public array $errorInfo ;
protected string $code ;
/* Inherited properties */
protected string $message ;
protected int $code ;
final public string Exception::getMessage ( void )
final public mixed Exception::getCode ( void ))
}
http://php.net/manual/en/class.pdoexception.php
errorInfo
Corresponds to PDO::errorInfo() or PDOStatement::errorInfo()
code
SQLSTATE error code. Use Exception::getCode() to access it.
PDO::errorInfo — Fetch extended error information associated with the last operation on the database handle
Description ¶
public array PDO::errorInfo ( void )
Return Values ¶
PDO::errorInfo() returns an array of error information about the last operation performed by this database handle. The array consists of the following fields:
Element Information
0 SQLSTATE error code (a five characters alphanumeric identifier defined in the ANSI SQL standard).
1 Driver-specific error code.
2 Driver-specific error message.
Note:
If the SQLSTATE error code is not set or there is no driver-specific error, the elements following element 0 will be set to NULL.
PDO::errorInfo() only retrieves error information for operations performed directly on the database handle. If you create a PDOStatement object through PDO::prepare() or PDO::query() and invoke an error on the statement handle, PDO::errorInfo() will not reflect the error from the statement handle. You must call PDOStatement::errorInfo() to return the error information for an operation performed on a particular statement handle.
PDO::errorCode
(PHP 5 >= 5.1.0, PECL pdo >= 0.1.0)
PDO::errorCode — Fetch the SQLSTATE associated with the last operation on the database handle
Description ¶
public mixed PDO::errorCode ( void )
Return Values ¶
Returns an SQLSTATE, a five characters alphanumeric identifier defined in the ANSI SQL-92 standard. Briefly, an SQLSTATE consists of a two characters class value followed by a three characters subclass value. A class value of 01 indicates a warning and is accompanied by a return code of SQL_SUCCESS_WITH_INFO. Class values other than '01', except for the class 'IM', indicate an error. The class 'IM' is specific to warnings and errors that derive from the implementation of PDO (or perhaps ODBC, if you're using the ODBC driver) itself. The subclass value '000' in any class indicates that there is no subclass for that SQLSTATE.
PDO::errorCode() only retrieves error codes for operations performed directly on the database handle. If you create a PDOStatement object through PDO::prepare() or PDO::query() and invoke an error on the statement handle, PDO::errorCode() will not reflect that error. You must call PDOStatement::errorCode() to return the error code for an operation performed on a particular statement handle.
Returns NULL if no operation has been run on the database handle.
Examples ¶
Example #1 Retrieving an SQLSTATE code
<?php
/* Provoke an error -- the BONES table does not exist */
$dbh->exec("INSERT INTO bones(skull) VALUES ('lucy')");
echo "\nPDO::errorCode(): ", $dbh->errorCode();
?>
The above example will output:
PDO::errorCode(): 42S02
http://docstore.mik.ua/orelly/java-ent/jenut/ch08_06.htm
SQL-92 SQLSTATE Return Codes
Class | Class Definition | Subclass | Subclass Definition |
---|---|---|---|
00 | Successful completion | 000 | None |
01 | Warning | 000 | None |
001 | Cursor operation conflict | ||
002 | Disconnect error | ||
003 | Null value eliminated in set function | ||
004 | String data, right truncation | ||
005 | Insufficient item descriptor areas | ||
006 | Privilege not revoked | ||
007 | Privilege not granted | ||
008 | Implicit zero-bit padding | ||
009 | Search expression too long for information schema | ||
00A | Query expression too long for information schema | ||
02 | No data | 000 | None |
07 | Dynamic SQL error | 000 | None |
001 | Using clause doesn't match dynamic parameters | ||
002 | Using clause doesn't match target specifications | ||
003 | Cursor specification can't be executed | ||
004 | Using clause required for dynamic parameters | ||
005 | Prepared statement not a cursor specification | ||
006 | Restricted data type attribute violation | ||
007 | Using clause required for result fields | ||
008 | Invalid descriptor count | ||
009 | Invalid descriptor index | ||
08 | Connection Exception | 000 | None |
001 | SQL-client unable to establish SQL-connection | ||
002 | Connection name in use | ||
003 | Connection doesn't exist | ||
004 | SQL-server rejected establishment of SQL-connection | ||
006 | Connection failure | ||
007 | Transaction resolution unknown | ||
0A | Feature not supported | 000 | None |
001 | Multiple server transactions | ||
21 | Cardinality violation | 000 | None |
22 | Data exception | 000 | None |
001 | String data, right truncation | ||
002 | Null value, no indicator | ||
003 | Numeric value out of range | ||
005 | Error in assignment | ||
007 | Invalid date-time format | ||
008 | Date-time field overflow | ||
009 | Invalid time zone displacement value | ||
011 | Substring error | ||
012 | Division by zero | ||
015 | Internal field overflow | ||
018 | Invalid character value for cast | ||
019 | Invalid escape character | ||
021 | Character not in repertoire | ||
022 | Indicator overflow | ||
023 | Invalid parameter value | ||
024 | Unterminated C string | ||
025 | Invalid escape sequence | ||
026 | String data, length mismatch | ||
027 | Trim error | ||
23 | Integrity constraint violation | 000 | None |
24 | Invalid cursor state | 000 | None |
25 | Invalid transaction state | 000 | None |
26 | Invalid SQL statement name | 000 | None |
27 | Triggered data change violation | 000 | None |
28 | Invalid authorization specification | 000 | None |
2A | Syntax error or access rule violation in direct SQL statement | 000 | None |
2B | Dependent privilege descriptors still exist | 000 | None |
2C | Invalid character set name | 000 | None |
2D | Invalid transaction termination | 000 | None |
2E | Invalid connection name | 000 | None |
33 | Invalid SQL descriptor name | 000 | None |
34 | Invalid cursor name | 000 | None |
35 | Invalid condition number | 000 | None |
37 | Syntax error or access rule violation in dynamic SQL statement | 000 | None |
3C | Ambiguous cursor name | 000 | None |
3F | Invalid schema name | 000 | None |
40 | Transaction rollback | 000 | None |
001 | Serialization failure | ||
002 | Integrity constraint violation | ||
003 | Statement completion unknown | ||
42 | Syntax error or access rule violation | 000 | None |
44 | With check option violation | 000 | None |
Server Error Codes and Messages
https://dev.mysql.com/doc/refman/5.7/en/error-messages-server.html
-
(
ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON
)Message: @@GLOBAL.GTID_MODE = ON or UPGRADE_STEP_2 requires @@GLOBAL.ENFORCE_GTID_CONSISTENCY = 1.
ER_GTID_MODE_2_OR_3_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON
was removed after 5.7.5. -
Error:
1779
SQLSTATE:HY000
(ER_GTID_MODE_ON_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON
)Message: GTID_MODE = ON requires ENFORCE_GTID_CONSISTENCY = ON.
ER_GTID_MODE_ON_REQUIRES_ENFORCE_GTID_CONSISTENCY_ON
was added in 5.7.6. -
Error:
1780
SQLSTATE:HY000
(ER_GTID_MODE_REQUIRES_BINLOG
)Message: @@GLOBAL.GTID_MODE = ON or ON_PERMISSIVE or OFF_PERMISSIVE requires --log-bin and --log-slave-updates.
-
Error:
1781
SQLSTATE:HY000
(ER_CANT_SET_GTID_NEXT_TO_GTID_WHEN_GTID_MODE_IS_OFF
)Message: @@SESSION.GTID_NEXT cannot be set to UUID:NUMBER when @@GLOBAL.GTID_MODE = OFF.
-
Error:
1782
SQLSTATE:HY000
(ER_CANT_SET_GTID_NEXT_TO_ANONYMOUS_WHEN_GTID_MODE_IS_ON
)Message: @@SESSION.GTID_NEXT cannot be set to ANONYMOUS when @@GLOBAL.GTID_MODE = ON.
-
Error:
1783
SQLSTATE:HY000
(ER_CANT_SET_GTID_NEXT_LIST_TO_NON_NULL_WHEN_GTID_MODE_IS_OFF
)Message: @@SESSION.GTID_NEXT_LIST cannot be set to a non-NULL value when @@GLOBAL.GTID_MODE = OFF.
-
Error:
1784
SQLSTATE:HY000
(ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF
)Message: Found a Gtid_log_event or Previous_gtids_log_event when @@GLOBAL.GTID_MODE = OFF.
ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF
was removed after 5.7.5. -
Error:
1784
SQLSTATE:HY000
(ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF__UNUSED
)Message: Found a Gtid_log_event when @@GLOBAL.GTID_MODE = OFF.
ER_FOUND_GTID_EVENT_WHEN_GTID_MODE_IS_OFF__UNUSED
was added in 5.7.6. -
Error:
1785
SQLSTATE:HY000
(ER_GTID_UNSAFE_NON_TRANSACTIONAL_TABLE
)Message: Statement violates GTID consistency: Updates to non-transactional tables can only be done in either autocommitted statements or single-statement transactions, and never in the same statement as updates to transactional tables.
-
Error:
1786
SQLSTATE:HY000
(ER_GTID_UNSAFE_CREATE_SELECT
)Message: Statement violates GTID consistency: CREATE TABLE ... SELECT.
-
Error:
1787
SQLSTATE:HY000
(ER_GTID_UNSAFE_CREATE_DROP_TEMPORARY_TABLE_IN_TRANSACTION
)Message: Statement violates GTID consistency: CREATE TEMPORARY TABLE and DROP TEMPORARY TABLE can only be executed outside transactional context.
-
Error:
1788
SQLSTATE:HY000
(ER_GTID_MODE_CAN_ONLY_CHANGE_ONE_STEP_AT_A_TIME
)Message: The value of @@GLOBAL.GTID_MODE can only be changed one step at a time: OFF <-> OFF_PERMISSIVE <-> ON_PERMISSIVE <-> ON. Also note that this value must be stepped up or down simultaneously on all servers. See the Manual for instructions.
-
Error:
1789
SQLSTATE:HY000
(ER_MASTER_HAS_PURGED_REQUIRED_GTIDS
)Message: The slave is connecting using CHANGE MASTER TO MASTER_AUTO_POSITION = 1, but the master has purged binary logs containing GTIDs that the slave requires.
-
Error:
1790
SQLSTATE:HY000
(ER_CANT_SET_GTID_NEXT_WHEN_OWNING_GTID
)Message: @@SESSION.GTID_NEXT cannot be changed by a client that owns a GTID. The client owns %s. Ownership is released on COMMIT or ROLLBACK.
-
Error:
1791
SQLSTATE:HY000
(ER_UNKNOWN_EXPLAIN_FORMAT
)Message: Unknown EXPLAIN format name: '%s'
-
Error:
1792
SQLSTATE:25006
(ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION
)Message: Cannot execute statement in a READ ONLY transaction.
-
Error:
1793
SQLSTATE:HY000
(ER_TOO_LONG_TABLE_PARTITION_COMMENT
)Message: Comment for table partition '%s' is too long (max = %lu)
-
Error:
1794
SQLSTATE:HY000
(ER_SLAVE_CONFIGURATION
)Message: Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave. Additional error messages can be found in the MySQL error log.
-
Error:
1795
SQLSTATE:HY000
(ER_INNODB_FT_LIMIT
)Message: InnoDB presently supports one FULLTEXT index creation at a time
-
Error:
1796
SQLSTATE:HY000
(ER_INNODB_NO_FT_TEMP_TABLE
)Message: Cannot create FULLTEXT index on temporary InnoDB table
-
Error:
1797
SQLSTATE:HY000
(ER_INNODB_FT_WRONG_DOCID_COLUMN
)Message: Column '%s' is of wrong type for an InnoDB FULLTEXT index
-
Error:
1798
SQLSTATE:HY000
(ER_INNODB_FT_WRONG_DOCID_INDEX
)Message: Index '%s' is of wrong type for an InnoDB FULLTEXT index
-
Error:
1799
SQLSTATE:HY000
(ER_INNODB_ONLINE_LOG_TOO_BIG
)Message: Creating index '%s' required more than 'innodb_online_alter_log_max_size' bytes of modification log. Please try again.
-
Error:
1800
SQLSTATE:HY000
(ER_UNKNOWN_ALTER_ALGORITHM
)Message: Unknown ALGORITHM '%s'
-
Error:
1801
SQLSTATE:HY000
(ER_UNKNOWN_ALTER_LOCK
)Message: Unknown LOCK type '%s'
-
Error:
1802
SQLSTATE:HY000
(ER_MTS_CHANGE_MASTER_CANT_RUN_WITH_GAPS
)Message: CHANGE MASTER cannot be executed when the slave was stopped with an error or killed in MTS mode. Consider using RESET SLAVE or START SLAVE UNTIL.
-
Error:
1803
SQLSTATE:HY000
(ER_MTS_RECOVERY_FAILURE
)Message: Cannot recover after SLAVE errored out in parallel execution mode. Additional error messages can be found in the MySQL error log.
-
Error:
1804
SQLSTATE:HY000
(ER_MTS_RESET_WORKERS
)Message: Cannot clean up worker info tables. Additional error messages can be found in the MySQL error log.
-
Error:
1805
SQLSTATE:HY000
(ER_COL_COUNT_DOESNT_MATCH_CORRUPTED_V2
)Message: Column count of %s.%s is wrong. Expected %d, found %d. The table is probably corrupted
-
Error:
1806
SQLSTATE:HY000
(ER_SLAVE_SILENT_RETRY_TRANSACTION
)Message: Slave must silently retry current transaction
-
Error:
1807
SQLSTATE:HY000
(ER_DISCARD_FK_CHECKS_RUNNING
)Message: There is a foreign key check running on table '%s'. Cannot discard the table.
-
Error:
1808
SQLSTATE:HY000
(ER_TABLE_SCHEMA_MISMATCH
)Message: Schema mismatch (%s)
-
Error:
1809
SQLSTATE:HY000
(ER_TABLE_IN_SYSTEM_TABLESPACE
)Message: Table '%s' in system tablespace
-
Error:
1810
SQLSTATE:HY000
(ER_IO_READ_ERROR
)Message: IO Read error: (%lu, %s) %s
-
Error:
1811
SQLSTATE:HY000
(ER_IO_WRITE_ERROR
)Message: IO Write error: (%lu, %s) %s
-
Error:
1812
SQLSTATE:HY000
(ER_TABLESPACE_MISSING
)Message: Tablespace is missing for table %s.
-
Error:
1813
SQLSTATE:HY000
(ER_TABLESPACE_EXISTS
)Message: Tablespace '%s' exists.
-
Error:
1814
SQLSTATE:HY000
(ER_TABLESPACE_DISCARDED
)Message: Tablespace has been discarded for table '%s'
-
Error:
1815
SQLSTATE:HY000
(ER_INTERNAL_ERROR
)Message: Internal error: %s
-
Error:
1816
SQLSTATE:HY000
(ER_INNODB_IMPORT_ERROR
)Message: ALTER TABLE %s IMPORT TABLESPACE failed with error %lu : '%s'
-
Error:
1817
SQLSTATE:HY000
(ER_INNODB_INDEX_CORRUPT
)Message: Index corrupt: %s
-
Error:
1818
SQLSTATE:HY000
(ER_INVALID_YEAR_COLUMN_LENGTH
)Message: Supports only YEAR or YEAR(4) column.
-
Error:
1819
SQLSTATE:HY000
(ER_NOT_VALID_PASSWORD
)Message: Your password does not satisfy the current policy requirements
-
Error:
1820
SQLSTATE:HY000
(ER_MUST_CHANGE_PASSWORD
)Message: You must reset your password using ALTER USER statement before executing this statement.
-
Error:
1821
SQLSTATE:HY000
(ER_FK_NO_INDEX_CHILD
)Message: Failed to add the foreign key constaint. Missing index for constraint '%s' in the foreign table '%s'
-
Error:
1822
SQLSTATE:HY000
(ER_FK_NO_INDEX_PARENT
)Message: Failed to add the foreign key constaint. Missing index for constraint '%s' in the referenced table '%s'
-
Error:
1823
SQLSTATE:HY000
(ER_FK_FAIL_ADD_SYSTEM
)Message: Failed to add the foreign key constraint '%s' to system tables
-
Error:
1824
SQLSTATE:HY000
(ER_FK_CANNOT_OPEN_PARENT
)Message: Failed to open the referenced table '%s'
-
Error:
1825
SQLSTATE:HY000
(ER_FK_INCORRECT_OPTION
)Message: Failed to add the foreign key constraint on table '%s'. Incorrect options in FOREIGN KEY constraint '%s'
-
Error:
1826
SQLSTATE:HY000
(ER_FK_DUP_NAME
)Message: Duplicate foreign key constraint name '%s'
-
Error:
1827
SQLSTATE:HY000
(ER_PASSWORD_FORMAT
)Message: The password hash doesn't have the expected format. Check if the correct password algorithm is being used with the PASSWORD() function.
-
Error:
1828
SQLSTATE:HY000
(ER_FK_COLUMN_CANNOT_DROP
)Message: Cannot drop column '%s': needed in a foreign key constraint '%s'
-
Error:
1829
SQLSTATE:HY000
(ER_FK_COLUMN_CANNOT_DROP_CHILD
)Message: Cannot drop column '%s': needed in a foreign key constraint '%s' of table '%s'
-
Error:
1830
SQLSTATE:HY000
(ER_FK_COLUMN_NOT_NULL
)Message: Column '%s' cannot be NOT NULL: needed in a foreign key constraint '%s' SET NULL
-
Error:
1831
SQLSTATE:HY000
(ER_DUP_INDEX
)Message: Duplicate index '%s' defined on the table '%s.%s'. This is deprecated and will be disallowed in a future release.
-
Error:
1832
SQLSTATE:HY000
(ER_FK_COLUMN_CANNOT_CHANGE
)Message: Cannot change column '%s': used in a foreign key constraint '%s'
-
Error:
1833
SQLSTATE:HY000
(ER_FK_COLUMN_CANNOT_CHANGE_CHILD
)Message: Cannot change column '%s': used in a foreign key constraint '%s' of table '%s'
-
Error:
1834
SQLSTATE:HY000
(ER_FK_CANNOT_DELETE_PARENT
)Message: Cannot delete rows from table which is parent in a foreign key constraint '%s' of table '%s'
ER_FK_CANNOT_DELETE_PARENT
was removed after 5.7.3. -
Error:
1834
SQLSTATE:HY000
(ER_UNUSED5
)Message: Cannot delete rows from table which is parent in a foreign key constraint '%s' of table '%s'
ER_UNUSED5
was added in 5.7.4. -
Error:
1835
SQLSTATE:HY000
(ER_MALFORMED_PACKET
)Message: Malformed communication packet.
-
Error:
1836
SQLSTATE:HY000
(ER_READ_ONLY_MODE
)Message: Running in read-only mode
-
Error:
1837
SQLSTATE:HY000
(ER_GTID_NEXT_TYPE_UNDEFINED_GROUP
)Message: When @@SESSION.GTID_NEXT is set to a GTID, you must explicitly set it to a different value after a COMMIT or ROLLBACK. Please check GTID_NEXT variable manual page for detailed explanation. Current @@SESSION.GTID_NEXT is '%s'.
-
Error:
1838
SQLSTATE:HY000
(ER_VARIABLE_NOT_SETTABLE_IN_SP
)Message: The system variable %s cannot be set in stored procedures.
-
Error:
1839
SQLSTATE:HY000
(ER_CANT_SET_GTID_PURGED_WHEN_GTID_MODE_IS_OFF
)Message: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_MODE = ON.
-
Error:
1840
SQLSTATE:HY000
(ER_CANT_SET_GTID_PURGED_WHEN_GTID_EXECUTED_IS_NOT_EMPTY
)Message: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty.
-
Error:
1841
SQLSTATE:HY000
(ER_CANT_SET_GTID_PURGED_WHEN_OWNED_GTIDS_IS_NOT_EMPTY
)Message: @@GLOBAL.GTID_PURGED can only be set when there are no ongoing transactions (not even in other clients).
-
Error:
1842
SQLSTATE:HY000
(ER_GTID_PURGED_WAS_CHANGED
)Message: @@GLOBAL.GTID_PURGED was changed from '%s' to '%s'.
-
Error:
1843
SQLSTATE:HY000
(ER_GTID_EXECUTED_WAS_CHANGED
)Message: @@GLOBAL.GTID_EXECUTED was changed from '%s' to '%s'.
-
Error:
1844
SQLSTATE:HY000
(ER_BINLOG_STMT_MODE_AND_NO_REPL_TABLES
)Message: Cannot execute statement: impossible to write to binary log since BINLOG_FORMAT = STATEMENT, and both replicated and non replicated tables are written to.
-
Error:
1845
SQLSTATE:0A000
(ER_ALTER_OPERATION_NOT_SUPPORTED
)Message: %s is not supported for this operation. Try %s.
ER_ALTER_OPERATION_NOT_SUPPORTED
was added in 5.7.1. -
Error:
1846
SQLSTATE:0A000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
)Message: %s is not supported. Reason: %s. Try %s.
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON
was added in 5.7.1. -
Error:
1847
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY
)Message: COPY algorithm requires a lock
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COPY
was added in 5.7.1. -
Error:
1848
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION
)Message: Partition specific operations do not yet support LOCK/ALGORITHM
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_PARTITION
was added in 5.7.1. -
Error:
1849
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME
)Message: Columns participating in a foreign key are renamed
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_RENAME
was added in 5.7.1. -
Error:
1850
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE
)Message: Cannot change column type INPLACE
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE
was added in 5.7.1. -
Error:
1851
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK
)Message: Adding foreign keys needs foreign_key_checks=OFF
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FK_CHECK
was added in 5.7.1. -
Error:
1852
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE
)Message: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_IGNORE
was added in 5.7.1, removed after 5.7.3. -
Error:
1852
SQLSTATE:HY000
(ER_UNUSED6
)Message: Creating unique indexes with IGNORE requires COPY algorithm to remove duplicate rows
ER_UNUSED6
was added in 5.7.4. -
Error:
1853
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK
)Message: Dropping a primary key is not allowed without also adding a new primary key
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOPK
was added in 5.7.1. -
Error:
1854
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC
)Message: Adding an auto-increment column requires a lock
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_AUTOINC
was added in 5.7.1. -
Error:
1855
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS
)Message: Cannot replace hidden FTS_DOC_ID with a user-visible one
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_HIDDEN_FTS
was added in 5.7.1. -
Error:
1856
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS
)Message: Cannot drop or rename FTS_DOC_ID
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_CHANGE_FTS
was added in 5.7.1. -
Error:
1857
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS
)Message: Fulltext index creation requires a lock
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_FTS
was added in 5.7.1. -
Error:
1858
SQLSTATE:HY000
(ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_GTID_MODE
)Message: sql_slave_skip_counter can not be set when the server is running with @@GLOBAL.GTID_MODE = ON. Instead, for each transaction that you want to skip, generate an empty transaction with the same GTID as the transaction
ER_SQL_SLAVE_SKIP_COUNTER_NOT_SETTABLE_IN_GTID_MODE
was added in 5.7.1. -
Error:
1859
SQLSTATE:23000
(ER_DUP_UNKNOWN_IN_INDEX
)Message: Duplicate entry for key '%s'
ER_DUP_UNKNOWN_IN_INDEX
was added in 5.7.1. -
Error:
1860
SQLSTATE:HY000
(ER_IDENT_CAUSES_TOO_LONG_PATH
)Message: Long database name and identifier for object resulted in path length exceeding %d characters. Path: '%s'.
ER_IDENT_CAUSES_TOO_LONG_PATH
was added in 5.7.1. -
Error:
1861
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL
)Message: cannot silently convert NULL values, as required in this SQL_MODE
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_NOT_NULL
was added in 5.7.1. -
Error:
1862
SQLSTATE:HY000
(ER_MUST_CHANGE_PASSWORD_LOGIN
)Message: Your password has expired. To log in you must change it using a client that supports expired passwords.
ER_MUST_CHANGE_PASSWORD_LOGIN
was added in 5.7.1. -
Error:
1863
SQLSTATE:HY000
(ER_ROW_IN_WRONG_PARTITION
)Message: Found a row in wrong partition %s
ER_ROW_IN_WRONG_PARTITION
was added in 5.7.1. -
Error:
1864
SQLSTATE:HY000
(ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX
)Message: Cannot schedule event %s, relay-log name %s, position %s to Worker thread because its size %lu exceeds %lu of slave_pending_jobs_size_max.
ER_MTS_EVENT_BIGGER_PENDING_JOBS_SIZE_MAX
was added in 5.7.2. -
Error:
1865
SQLSTATE:HY000
(ER_INNODB_NO_FT_USES_PARSER
)Message: Cannot CREATE FULLTEXT INDEX WITH PARSER on InnoDB table
ER_INNODB_NO_FT_USES_PARSER
was added in 5.7.2. -
Error:
1866
SQLSTATE:HY000
(ER_BINLOG_LOGICAL_CORRUPTION
)Message: The binary log file '%s' is logically corrupted: %s
ER_BINLOG_LOGICAL_CORRUPTION
was added in 5.7.2. -
Error:
1867
SQLSTATE:HY000
(ER_WARN_PURGE_LOG_IN_USE
)Message: file %s was not purged because it was being read by %d thread(s), purged only %d out of %d files.
ER_WARN_PURGE_LOG_IN_USE
was added in 5.7.2. -
Error:
1868
SQLSTATE:HY000
(ER_WARN_PURGE_LOG_IS_ACTIVE
)Message: file %s was not purged because it is the active log file.
ER_WARN_PURGE_LOG_IS_ACTIVE
was added in 5.7.2. -
Error:
1869
SQLSTATE:HY000
(ER_AUTO_INCREMENT_CONFLICT
)Message: Auto-increment value in UPDATE conflicts with internally generated values
ER_AUTO_INCREMENT_CONFLICT
was added in 5.7.2. -
Error:
1870
SQLSTATE:HY000
(WARN_ON_BLOCKHOLE_IN_RBR
)Message: Row events are not logged for %s statements that modify BLACKHOLE tables in row format. Table(s): '%s'
WARN_ON_BLOCKHOLE_IN_RBR
was added in 5.7.2. -
Error:
1871
SQLSTATE:HY000
(ER_SLAVE_MI_INIT_REPOSITORY
)Message: Slave failed to initialize master info structure from the repository
ER_SLAVE_MI_INIT_REPOSITORY
was added in 5.7.2. -
Error:
1872
SQLSTATE:HY000
(ER_SLAVE_RLI_INIT_REPOSITORY
)Message: Slave failed to initialize relay log info structure from the repository
ER_SLAVE_RLI_INIT_REPOSITORY
was added in 5.7.2. -
Error:
1873
SQLSTATE:28000
(ER_ACCESS_DENIED_CHANGE_USER_ERROR
)Message: Access denied trying to change to user '%s'@'%s' (using password: %s). Disconnecting.
ER_ACCESS_DENIED_CHANGE_USER_ERROR
was added in 5.7.2. -
Error:
1874
SQLSTATE:HY000
(ER_INNODB_READ_ONLY
)Message: InnoDB is in read only mode.
ER_INNODB_READ_ONLY
was added in 5.7.2. -
Error:
1875
SQLSTATE:HY000
(ER_STOP_SLAVE_SQL_THREAD_TIMEOUT
)Message: STOP SLAVE command execution is incomplete: Slave SQL thread got the stop signal, thread is busy, SQL thread will stop once the current task is complete.
ER_STOP_SLAVE_SQL_THREAD_TIMEOUT
was added in 5.7.2. -
Error:
1876
SQLSTATE:HY000
(ER_STOP_SLAVE_IO_THREAD_TIMEOUT
)Message: STOP SLAVE command execution is incomplete: Slave IO thread got the stop signal, thread is busy, IO thread will stop once the current task is complete.
ER_STOP_SLAVE_IO_THREAD_TIMEOUT
was added in 5.7.2. -
Error:
1877
SQLSTATE:HY000
(ER_TABLE_CORRUPT
)Message: Operation cannot be performed. The table '%s.%s' is missing, corrupt or contains bad data.
ER_TABLE_CORRUPT
was added in 5.7.2. -
Error:
1878
SQLSTATE:HY000
(ER_TEMP_FILE_WRITE_FAILURE
)Message: Temporary file write failure.
ER_TEMP_FILE_WRITE_FAILURE
was added in 5.7.3. -
Error:
1879
SQLSTATE:HY000
(ER_INNODB_FT_AUX_NOT_HEX_ID
)Message: Upgrade index name failed, please use create index(alter table) algorithm copy to rebuild index.
ER_INNODB_FT_AUX_NOT_HEX_ID
was added in 5.7.4. -
Error:
1880
SQLSTATE:HY000
(ER_OLD_TEMPORALS_UPGRADED
)Message: TIME/TIMESTAMP/DATETIME columns of old format have been upgraded to the new format.
ER_OLD_TEMPORALS_UPGRADED
was added in 5.7.4. -
Error:
1881
SQLSTATE:HY000
(ER_INNODB_FORCED_RECOVERY
)Message: Operation not allowed when innodb_forced_recovery > 0.
ER_INNODB_FORCED_RECOVERY
was added in 5.7.4. -
Error:
1882
SQLSTATE:HY000
(ER_AES_INVALID_IV
)Message: The initialization vector supplied to %s is too short. Must be at least %d bytes long
ER_AES_INVALID_IV
was added in 5.7.4. -
Error:
1883
SQLSTATE:HY000
(ER_PLUGIN_CANNOT_BE_UNINSTALLED
)Message: Plugin '%s' cannot be uninstalled now. %s
ER_PLUGIN_CANNOT_BE_UNINSTALLED
was added in 5.7.5. -
Error:
1884
SQLSTATE:HY000
(ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP
)Message: Cannot execute statement because it needs to be written to the binary log as multiple statements, and this is not allowed when @@SESSION.GTID_NEXT == 'UUID:NUMBER'.
ER_GTID_UNSAFE_BINLOG_SPLITTABLE_STATEMENT_AND_GTID_GROUP
was added in 5.7.5. -
Error:
1885
SQLSTATE:HY000
(ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER
)Message: Slave has more GTIDs than the master has, using the master's SERVER_UUID. This may indicate that the end of the binary log was truncated or that the last binary log file was lost, e.g., after a power or disk failure when sync_binlog != 1. The master may or may not have rolled back transactions that were already replicated to the slave. Suggest to replicate any transactions that master has rolled back from slave to master, and/or commit empty transactions on master to account for transactions that have been committed on master but are not included in GTID_EXECUTED.
ER_SLAVE_HAS_MORE_GTIDS_THAN_MASTER
was added in 5.7.6. -
Error:
1906
SQLSTATE:HY000
(ER_SLAVE_IO_THREAD_MUST_STOP
)Message: This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD first.
ER_SLAVE_IO_THREAD_MUST_STOP
was added in 5.7.4, removed after 5.7.5. -
Error:
3000
SQLSTATE:HY000
(ER_FILE_CORRUPT
)Message: File %s is corrupted
-
Error:
3001
SQLSTATE:HY000
(ER_ERROR_ON_MASTER
)Message: Query partially completed on the master (error on master: %d) and was aborted. There is a chance that your master is inconsistent at this point. If you are sure that your master is ok, run this query manually on the slave and then restart the slave with SET GLOBAL SQL_SLAVE_SKIP_COUNTER=1; START SLAVE;. Query:'%s'
-
Error:
3002
SQLSTATE:HY000
(ER_INCONSISTENT_ERROR
)Message: Query caused different errors on master and slave. Error on master: message (format)='%s' error code=%d; Error on slave:actual message='%s', error code=%d. Default database:'%s'. Query:'%s'
-
Error:
3003
SQLSTATE:HY000
(ER_STORAGE_ENGINE_NOT_LOADED
)Message: Storage engine for table '%s'.'%s' is not loaded.
-
Error:
3004
SQLSTATE:0Z002
(ER_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER
)Message: GET STACKED DIAGNOSTICS when handler not active
-
Error:
3005
SQLSTATE:HY000
(ER_WARN_LEGACY_SYNTAX_CONVERTED
)Message: %s is no longer supported. The statement was converted to %s.
-
Error:
3006
SQLSTATE:HY000
(ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN
)Message: Statement is unsafe because it uses a fulltext parser plugin which may not return the same value on the slave.
ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN
was added in 5.7.1. -
Error:
3007
SQLSTATE:HY000
(ER_CANNOT_DISCARD_TEMPORARY_TABLE
)Message: Cannot DISCARD/IMPORT tablespace associated with temporary table
ER_CANNOT_DISCARD_TEMPORARY_TABLE
was added in 5.7.1. -
Error:
3008
SQLSTATE:HY000
(ER_FK_DEPTH_EXCEEDED
)Message: Foreign key cascade delete/update exceeds max depth of %d.
ER_FK_DEPTH_EXCEEDED
was added in 5.7.2. -
Error:
3009
SQLSTATE:HY000
(ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2
)Message: Column count of %s.%s is wrong. Expected %d, found %d. Created with MySQL %d, now running %d. Please use mysql_upgrade to fix this error.
ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2
was added in 5.7.2. -
Error:
3010
SQLSTATE:HY000
(ER_WARN_TRIGGER_DOESNT_HAVE_CREATED
)Message: Trigger %s.%s.%s does not have CREATED attribute.
ER_WARN_TRIGGER_DOESNT_HAVE_CREATED
was added in 5.7.2. -
Error:
3011
SQLSTATE:HY000
(ER_REFERENCED_TRG_DOES_NOT_EXIST
)Message: Referenced trigger '%s' for the given action time and event type does not exist.
ER_REFERENCED_TRG_DOES_NOT_EXIST
was added in 5.7.2. -
Error:
3012
SQLSTATE:HY000
(ER_EXPLAIN_NOT_SUPPORTED
)Message: EXPLAIN FOR CONNECTION command is supported only for SELECT/UPDATE/INSERT/DELETE/REPLACE
ER_EXPLAIN_NOT_SUPPORTED
was added in 5.7.2. -
Error:
3013
SQLSTATE:HY000
(ER_INVALID_FIELD_SIZE
)Message: Invalid size for column '%s'.
ER_INVALID_FIELD_SIZE
was added in 5.7.2. -
Error:
3014
SQLSTATE:HY000
(ER_MISSING_HA_CREATE_OPTION
)Message: Table storage engine '%s' found required create option missing
ER_MISSING_HA_CREATE_OPTION
was added in 5.7.2. -
Error:
3015
SQLSTATE:HY000
(ER_ENGINE_OUT_OF_MEMORY
)Message: Out of memory in storage engine '%s'.
ER_ENGINE_OUT_OF_MEMORY
was added in 5.7.3. -
Error:
3016
SQLSTATE:HY000
(ER_PASSWORD_EXPIRE_ANONYMOUS_USER
)Message: The password for anonymous user cannot be expired.
ER_PASSWORD_EXPIRE_ANONYMOUS_USER
was added in 5.7.3. -
Error:
3017
SQLSTATE:HY000
(ER_SLAVE_SQL_THREAD_MUST_STOP
)Message: This operation cannot be performed with a running slave sql thread; run STOP SLAVE SQL_THREAD first
ER_SLAVE_SQL_THREAD_MUST_STOP
was added in 5.7.3. -
Error:
3018
SQLSTATE:HY000
(ER_NO_FT_MATERIALIZED_SUBQUERY
)Message: Cannot create FULLTEXT index on materialized subquery
ER_NO_FT_MATERIALIZED_SUBQUERY
was added in 5.7.4. -
Error:
3019
SQLSTATE:HY000
(ER_INNODB_UNDO_LOG_FULL
)Message: Undo Log error: %s
ER_INNODB_UNDO_LOG_FULL
was added in 5.7.4. -
Error:
3020
SQLSTATE:2201E
(ER_INVALID_ARGUMENT_FOR_LOGARITHM
)Message: Invalid argument for logarithm
ER_INVALID_ARGUMENT_FOR_LOGARITHM
was added in 5.7.4. -
Error:
3021
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP
)Message: This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '%s' first.
ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP
was added in 5.7.6. -
Error:
3022
SQLSTATE:HY000
(ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO
)Message: This operation may not be safe when the slave has temporary tables. The tables will be kept open until the server restarts or until the tables are deleted by any replicated DROP statement. Suggest to wait until slave_open_temp_tables = 0.
ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO
was added in 5.7.4. -
Error:
3023
SQLSTATE:HY000
(ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS
)Message: CHANGE MASTER TO with a MASTER_LOG_FILE clause but no MASTER_LOG_POS clause may not be safe. The old position value may not be valid for the new binary log file.
ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS
was added in 5.7.4. -
Error:
3024
SQLSTATE:HY000
(ER_QUERY_TIMEOUT
)Message: Query execution was interrupted, maximum statement execution time exceeded
ER_QUERY_TIMEOUT
was added in 5.7.4. -
Error:
3025
SQLSTATE:HY000
(ER_NON_RO_SELECT_DISABLE_TIMER
)Message: Select is not a read only statement, disabling timer
ER_NON_RO_SELECT_DISABLE_TIMER
was added in 5.7.4. -
Error:
3026
SQLSTATE:HY000
(ER_DUP_LIST_ENTRY
)Message: Duplicate entry '%s'.
ER_DUP_LIST_ENTRY
was added in 5.7.4. -
Error:
3027
SQLSTATE:HY000
(ER_SQL_MODE_NO_EFFECT
)Message: '%s' mode no longer has any effect. Use STRICT_ALL_TABLES or STRICT_TRANS_TABLES instead.
ER_SQL_MODE_NO_EFFECT
was added in 5.7.4. -
Error:
3028
SQLSTATE:HY000
(ER_AGGREGATE_ORDER_FOR_UNION
)Message: Expression #%u of ORDER BY contains aggregate function and applies to a UNION
ER_AGGREGATE_ORDER_FOR_UNION
was added in 5.7.5. -
Error:
3029
SQLSTATE:HY000
(ER_AGGREGATE_ORDER_NON_AGG_QUERY
)Message: Expression #%u of ORDER BY contains aggregate function and applies to the result of a non-aggregated query
ER_AGGREGATE_ORDER_NON_AGG_QUERY
was added in 5.7.5. -
Error:
3030
SQLSTATE:HY000
(ER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR
)Message: Slave worker has stopped after at least one previous worker encountered an error when slave-preserve-commit-order was enabled. To preserve commit order, the last transaction executed by this thread has not been committed. When restarting the slave after fixing any failed threads, you should fix this worker as well.
ER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR
was added in 5.7.5. -
Error:
3031
SQLSTATE:HY000
(ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER
)Message: slave_preserve_commit_order is not supported %s.
ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER
was added in 5.7.5. -
Error:
3032
SQLSTATE:HY000
(ER_SERVER_OFFLINE_MODE
)Message: The server is currently in offline mode
ER_SERVER_OFFLINE_MODE
was added in 5.7.5. -
Error:
3033
SQLSTATE:HY000
(ER_GIS_DIFFERENT_SRIDS
)Message: Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical.
Geometry values passed as arguments to spatial functions must have the same SRID value.
ER_GIS_DIFFERENT_SRIDS
was added in 5.7.5. -
Error:
3034
SQLSTATE:HY000
(ER_GIS_UNSUPPORTED_ARGUMENT
)Message: Calling geometry function %s with unsupported types of arguments.
A spatial function was called with a combination of argument types that the function does not support.
ER_GIS_UNSUPPORTED_ARGUMENT
was added in 5.7.5. -
Error:
3035
SQLSTATE:HY000
(ER_GIS_UNKNOWN_ERROR
)Message: Unknown GIS error occured in function %s.
ER_GIS_UNKNOWN_ERROR
was added in 5.7.5. -
Error:
3036
SQLSTATE:HY000
(ER_GIS_UNKNOWN_EXCEPTION
)Message: Unknown exception caught in GIS function %s.
ER_GIS_UNKNOWN_EXCEPTION
was added in 5.7.5. -
Error:
3037
SQLSTATE:22023
(ER_GIS_INVALID_DATA
)Message: Invalid GIS data provided to function %s.
A spatial function was called with an argument not recognized as a valid geometry value.
ER_GIS_INVALID_DATA
was added in 5.7.5. -
Error:
3038
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_EMPTY_INPUT_EXCEPTION
)Message: The geometry has no data in function %s.
ER_BOOST_GEOMETRY_EMPTY_INPUT_EXCEPTION
was added in 5.7.5. -
Error:
3039
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_CENTROID_EXCEPTION
)Message: Unable to calculate centroid because geometry is empty in function %s.
ER_BOOST_GEOMETRY_CENTROID_EXCEPTION
was added in 5.7.5. -
Error:
3040
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION
)Message: Geometry overlay calculation error: geometry data is invalid in function %s.
ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION
was added in 5.7.5. -
Error:
3041
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION
)Message: Geometry turn info calculation error: geometry data is invalid in function %s.
ER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION
was added in 5.7.5. -
Error:
3042
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION
)Message: Analysis procedures of intersection points interrupted unexpectedly in function %s.
ER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION
was added in 5.7.5. -
Error:
3043
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_UNKNOWN_EXCEPTION
)Message: Unknown exception thrown in function %s.
ER_BOOST_GEOMETRY_UNKNOWN_EXCEPTION
was added in 5.7.5. -
Error:
3044
SQLSTATE:HY000
(ER_STD_BAD_ALLOC_ERROR
)Message: Memory allocation error: %s in function %s.
ER_STD_BAD_ALLOC_ERROR
was added in 5.7.5. -
Error:
3045
SQLSTATE:HY000
(ER_STD_DOMAIN_ERROR
)Message: Domain error: %s in function %s.
ER_STD_DOMAIN_ERROR
was added in 5.7.5. -
Error:
3046
SQLSTATE:HY000
(ER_STD_LENGTH_ERROR
)Message: Length error: %s in function %s.
ER_STD_LENGTH_ERROR
was added in 5.7.5. -
Error:
3047
SQLSTATE:HY000
(ER_STD_INVALID_ARGUMENT
)Message: Invalid argument error: %s in function %s.
ER_STD_INVALID_ARGUMENT
was added in 5.7.5. -
Error:
3048
SQLSTATE:HY000
(ER_STD_OUT_OF_RANGE_ERROR
)Message: Out of range error: %s in function %s.
ER_STD_OUT_OF_RANGE_ERROR
was added in 5.7.5. -
Error:
3049
SQLSTATE:HY000
(ER_STD_OVERFLOW_ERROR
)Message: Overflow error error: %s in function %s.
ER_STD_OVERFLOW_ERROR
was added in 5.7.5. -
Error:
3050
SQLSTATE:HY000
(ER_STD_RANGE_ERROR
)Message: Range error: %s in function %s.
ER_STD_RANGE_ERROR
was added in 5.7.5. -
Error:
3051
SQLSTATE:HY000
(ER_STD_UNDERFLOW_ERROR
)Message: Underflow error: %s in function %s.
ER_STD_UNDERFLOW_ERROR
was added in 5.7.5. -
Error:
3052
SQLSTATE:HY000
(ER_STD_LOGIC_ERROR
)Message: Logic error: %s in function %s.
ER_STD_LOGIC_ERROR
was added in 5.7.5. -
Error:
3053
SQLSTATE:HY000
(ER_STD_RUNTIME_ERROR
)Message: Runtime error: %s in function %s.
ER_STD_RUNTIME_ERROR
was added in 5.7.5. -
Error:
3054
SQLSTATE:HY000
(ER_STD_UNKNOWN_EXCEPTION
)Message: Unknown exception: %s in function %s.
ER_STD_UNKNOWN_EXCEPTION
was added in 5.7.5. -
Error:
3055
SQLSTATE:HY000
(ER_GIS_DATA_WRONG_ENDIANESS
)Message: Geometry byte string must be little endian.
ER_GIS_DATA_WRONG_ENDIANESS
was added in 5.7.5. -
Error:
3056
SQLSTATE:HY000
(ER_CHANGE_MASTER_PASSWORD_LENGTH
)Message: The password provided for the replication user exceeds the maximum length of 32 characters
ER_CHANGE_MASTER_PASSWORD_LENGTH
was added in 5.7.5. -
Error:
3057
SQLSTATE:42000
(ER_USER_LOCK_WRONG_NAME
)Message: Incorrect user-level lock name '%s'.
ER_USER_LOCK_WRONG_NAME
was added in 5.7.5. -
Error:
3058
SQLSTATE:HY000
(ER_USER_LOCK_DEADLOCK
)Message: Deadlock found when trying to get user-level lock; try rolling back transaction/releasing locks and restarting lock acquisition.
This error is returned when the metdata locking subsystem detects a deadlock for an attempt to acquire a named lock with
GET_LOCK
.ER_USER_LOCK_DEADLOCK
was added in 5.7.5. -
Error:
3059
SQLSTATE:HY000
(ER_REPLACE_INACCESSIBLE_ROWS
)Message: REPLACE cannot be executed as it requires deleting rows that are not in the view
ER_REPLACE_INACCESSIBLE_ROWS
was added in 5.7.5. -
Error:
3060
SQLSTATE:HY000
(ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS
)Message: Do not support online operation on table with GIS index
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS
was added in 5.7.5. -
Error:
3061
SQLSTATE:42000
(ER_ILLEGAL_USER_VAR
)Message: User variable name '%s' is illegal
ER_ILLEGAL_USER_VAR
was added in 5.7.5. -
Error:
3062
SQLSTATE:HY000
(ER_GTID_MODE_OFF
)Message: Cannot %s when GTID_MODE = OFF.
ER_GTID_MODE_OFF
was added in 5.7.5. -
Error:
3063
SQLSTATE:HY000
(ER_UNSUPPORTED_BY_REPLICATION_THREAD
)Message: Cannot %s from a replication slave thread.
ER_UNSUPPORTED_BY_REPLICATION_THREAD
was added in 5.7.5. -
Error:
3064
SQLSTATE:HY000
(ER_INCORRECT_TYPE
)Message: Incorrect type for argument %s in function %s.
ER_INCORRECT_TYPE
was added in 5.7.5. -
Error:
3065
SQLSTATE:HY000
(ER_FIELD_IN_ORDER_NOT_SELECT
)Message: Expression #%u of ORDER BY clause is not in SELECT list, references column '%s' which is not in SELECT list; this is incompatible with %s
ER_FIELD_IN_ORDER_NOT_SELECT
was added in 5.7.5. -
Error:
3066
SQLSTATE:HY000
(ER_AGGREGATE_IN_ORDER_NOT_SELECT
)Message: Expression #%u of ORDER BY clause is not in SELECT list, contains aggregate function; this is incompatible with %s
ER_AGGREGATE_IN_ORDER_NOT_SELECT
was added in 5.7.5. -
Error:
3067
SQLSTATE:HY000
(ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN
)Message: Supplied filter list contains a value which is not in the required format 'db_pattern.table_pattern'
ER_INVALID_RPL_WILD_TABLE_FILTER_PATTERN
was added in 5.7.5. -
Error:
3068
SQLSTATE:08S01
(ER_NET_OK_PACKET_TOO_LARGE
)Message: OK packet too large
ER_NET_OK_PACKET_TOO_LARGE
was added in 5.7.5. -
Error:
3069
SQLSTATE:HY000
(ER_INVALID_JSON_DATA
)Message: Invalid JSON data provided to function %s: %s
ER_INVALID_JSON_DATA
was added in 5.7.5. -
Error:
3070
SQLSTATE:HY000
(ER_INVALID_GEOJSON_MISSING_MEMBER
)Message: Invalid GeoJSON data provided to function %s: Missing required member '%s'
ER_INVALID_GEOJSON_MISSING_MEMBER
was added in 5.7.5. -
Error:
3071
SQLSTATE:HY000
(ER_INVALID_GEOJSON_WRONG_TYPE
)Message: Invalid GeoJSON data provided to function %s: Member '%s' must be of type '%s'
ER_INVALID_GEOJSON_WRONG_TYPE
was added in 5.7.5. -
Error:
3072
SQLSTATE:HY000
(ER_INVALID_GEOJSON_UNSPECIFIED
)Message: Invalid GeoJSON data provided to function %s
ER_INVALID_GEOJSON_UNSPECIFIED
was added in 5.7.5. -
Error:
3073
SQLSTATE:HY000
(ER_DIMENSION_UNSUPPORTED
)Message: Unsupported number of coordinate dimensions in function %s: Found %u, expected %u
ER_DIMENSION_UNSUPPORTED
was added in 5.7.5. -
Error:
3074
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_DOES_NOT_EXIST
)Message: Slave channel '%s' does not exist.
ER_SLAVE_CHANNEL_DOES_NOT_EXIST
was added in 5.7.6. -
Error:
3075
SQLSTATE:HY000
(ER_SLAVE_MULTIPLE_CHANNELS_HOST_PORT
)Message: A slave channel '%s' already exists for the given host and port combination.
ER_SLAVE_MULTIPLE_CHANNELS_HOST_PORT
was added in 5.7.6. -
Error:
3076
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_NAME_INVALID_OR_TOO_LONG
)Message: Couldn't create channel: Channel name is either invalid or too long.
ER_SLAVE_CHANNEL_NAME_INVALID_OR_TOO_LONG
was added in 5.7.6. -
Error:
3077
SQLSTATE:HY000
(ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY
)Message: To have multiple channels, repository cannot be of type FILE; Please check the repository configuration and convert them to TABLE.
ER_SLAVE_NEW_CHANNEL_WRONG_REPOSITORY
was added in 5.7.6. -
Error:
3078
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_DELETE
)Message: Cannot delete slave info objects for channel '%s'.
ER_SLAVE_CHANNEL_DELETE
was added in 5.7.6. -
Error:
3079
SQLSTATE:HY000
(ER_SLAVE_MULTIPLE_CHANNELS_CMD
)Message: Multiple channels exist on the slave. Please provide channel name as an argument.
ER_SLAVE_MULTIPLE_CHANNELS_CMD
was added in 5.7.6. -
Error:
3080
SQLSTATE:HY000
(ER_SLAVE_MAX_CHANNELS_EXCEEDED
)Message: Maximum number of replication channels allowed exceeded.
ER_SLAVE_MAX_CHANNELS_EXCEEDED
was added in 5.7.6. -
Error:
3081
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_MUST_STOP
)Message: This operation cannot be performed with running replication threads; run STOP SLAVE FOR CHANNEL '%s' first
ER_SLAVE_CHANNEL_MUST_STOP
was added in 5.7.6. -
Error:
3082
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_NOT_RUNNING
)Message: This operation requires running replication threads; configure slave and run START SLAVE FOR CHANNEL '%s'
ER_SLAVE_CHANNEL_NOT_RUNNING
was added in 5.7.6. -
Error:
3083
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_WAS_RUNNING
)Message: Replication thread(s) for channel '%s' are already runnning.
ER_SLAVE_CHANNEL_WAS_RUNNING
was added in 5.7.6. -
Error:
3084
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_WAS_NOT_RUNNING
)Message: Replication thread(s) for channel '%s' are already stopped.
ER_SLAVE_CHANNEL_WAS_NOT_RUNNING
was added in 5.7.6. -
Error:
3085
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_SQL_THREAD_MUST_STOP
)Message: This operation cannot be performed with a running slave sql thread; run STOP SLAVE SQL_THREAD FOR CHANNEL '%s' first.
ER_SLAVE_CHANNEL_SQL_THREAD_MUST_STOP
was added in 5.7.6. -
Error:
3086
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_SQL_SKIP_COUNTER
)Message: When sql_slave_skip_counter > 0, it is not allowed to start more than one SQL thread by using 'START SLAVE [SQL_THREAD]'. Value of sql_slave_skip_counter can only be used by one SQL thread at a time. Please use 'START SLAVE [SQL_THREAD] FOR CHANNEL' to start the SQL thread which will use the value of sql_slave_skip_counter.
ER_SLAVE_CHANNEL_SQL_SKIP_COUNTER
was added in 5.7.6. -
Error:
3087
SQLSTATE:HY000
(ER_WRONG_FIELD_WITH_GROUP_V2
)Message: Expression #%u of %s is not in GROUP BY clause and contains nonaggregated column '%s' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
ER_WRONG_FIELD_WITH_GROUP_V2
was added in 5.7.6. -
Error:
3088
SQLSTATE:HY000
(ER_MIX_OF_GROUP_FUNC_AND_FIELDS_V2
)Message: In aggregated query without GROUP BY, expression #%u of %s contains nonaggregated column '%s'; this is incompatible with sql_mode=only_full_group_by
ER_MIX_OF_GROUP_FUNC_AND_FIELDS_V2
was added in 5.7.6. -
Error:
3089
SQLSTATE:HY000
(ER_WARN_DEPRECATED_SYSVAR_UPDATE
)Message: Updating '%s' is deprecated. It will be made read-only in a future release.
ER_WARN_DEPRECATED_SYSVAR_UPDATE
was added in 5.7.6. -
Error:
3090
SQLSTATE:HY000
(ER_WARN_DEPRECATED_SQLMODE
)Message: Changing sql mode '%s' is deprecated. It will be removed in a future release.
ER_WARN_DEPRECATED_SQLMODE
was added in 5.7.6. -
Error:
3091
SQLSTATE:HY000
(ER_CANNOT_LOG_PARTIAL_DROP_DATABASE_WITH_GTID
)Message: DROP DATABASE failed; some tables may have been dropped but the database directory remains. The GTID has not been added to GTID_EXECUTED and the statement was not written to the binary log. Fix this as follows: (1) remove all files from the database directory %s; (2) SET GTID_NEXT='%s'; (3) DROP DATABASE `%s`.
ER_CANNOT_LOG_PARTIAL_DROP_DATABASE_WITH_GTID
was added in 5.7.6. -
Error:
3092
SQLSTATE:HY000
(ER_GROUP_REPLICATION_CONFIGURATION
)Message: The server is not configured properly to be an active member of the group. Please see more details on error log.
This error is reserved for future use.
ER_GROUP_REPLICATION_CONFIGURATION
was added in 5.7.6. -
Error:
3093
SQLSTATE:HY000
(ER_GROUP_REPLICATION_RUNNING
)Message: The START GROUP_REPLICATION command failed since the group is already running.
This error is reserved for future use.
ER_GROUP_REPLICATION_RUNNING
was added in 5.7.6. -
Error:
3094
SQLSTATE:HY000
(ER_GROUP_REPLICATION_APPLIER_INIT_ERROR
)Message: The START GROUP_REPLICATION command failed as the applier module failed to start.
This error is reserved for future use.
ER_GROUP_REPLICATION_APPLIER_INIT_ERROR
was added in 5.7.6. -
Error:
3095
SQLSTATE:HY000
(ER_GROUP_REPLICATION_STOP_APPLIER_THREAD_TIMEOUT
)Message: The STOP GROUP_REPLICATION command execution is incomplete: The applier thread got the stop signal while it was busy. The applier thread will stop once the current task is complete.
This error is reserved for future use.
ER_GROUP_REPLICATION_STOP_APPLIER_THREAD_TIMEOUT
was added in 5.7.6. -
Error:
3096
SQLSTATE:HY000
(ER_GROUP_REPLICATION_COMMUNICATION_LAYER_SESSION_ERROR
)Message: The START GROUP_REPLICATION command failed as there was an error when initializing the group communication layer.
This error is reserved for future use.
ER_GROUP_REPLICATION_COMMUNICATION_LAYER_SESSION_ERROR
was added in 5.7.6. -
Error:
3097
SQLSTATE:HY000
(ER_GROUP_REPLICATION_COMMUNICATION_LAYER_JOIN_ERROR
)Message: The START GROUP_REPLICATION command failed as there was an error when joining the communication group.
This error is reserved for future use.
ER_GROUP_REPLICATION_COMMUNICATION_LAYER_JOIN_ERROR
was added in 5.7.6. -
Error:
3098
SQLSTATE:HY000
(ER_BEFORE_DML_VALIDATION_ERROR
)Message: The table does not comply with the requirements by an external plugin.
This error is reserved for future use.
ER_BEFORE_DML_VALIDATION_ERROR
was added in 5.7.6. -
Error:
3099
SQLSTATE:HY000
(ER_PREVENTS_VARIABLE_WITHOUT_RBR
)Message: Cannot change the value of variable %s without binary log format as ROW.
This error is reserved for future use.
ER_PREVENTS_VARIABLE_WITHOUT_RBR
was added in 5.7.6. -
Error:
3100
SQLSTATE:HY000
(ER_RUN_HOOK_ERROR
)Message: Error on observer while running replication hook '%s'.
This error is reserved for future use.
ER_RUN_HOOK_ERROR
was added in 5.7.6. -
Error:
3101
SQLSTATE:HY000
(ER_TRANSACTION_ROLLBACK_DURING_COMMIT
)Message: Plugin instructed the server to rollback the current transaction.
This error is reserved for future use.
ER_TRANSACTION_ROLLBACK_DURING_COMMIT
was added in 5.7.6. -
Error:
3102
SQLSTATE:HY000
(ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED
)Message: Expression of generated column '%s' contains a disallowed function.
ER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED
was added in 5.7.6. -
Error:
3103
SQLSTATE:HY000
(ER_KEY_BASED_ON_GENERATED_COLUMN
)Message: Key/Index cannot be defined on a virtual generated column.
ER_KEY_BASED_ON_GENERATED_COLUMN
was added in 5.7.6, removed after 5.7.7. -
Error:
3103
SQLSTATE:HY000
(ER_UNSUPPORTED_ALTER_INPLACE_ON_VIRTUAL_COLUMN
)Message: INPLACE ADD or DROP of virtual columns cannot be combined with other ALTER TABLE actions
ER_UNSUPPORTED_ALTER_INPLACE_ON_VIRTUAL_COLUMN
was added in 5.7.8. -
Error:
3104
SQLSTATE:HY000
(ER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN
)Message: Cannot define foreign key with %s clause on a generated column.
ER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN
was added in 5.7.6. -
Error:
3105
SQLSTATE:HY000
(ER_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN
)Message: The value specified for generated column '%s' in table '%s' is not allowed.
ER_NON_DEFAULT_VALUE_FOR_GENERATED_COLUMN
was added in 5.7.6. -
Error:
3106
SQLSTATE:HY000
(ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
)Message: '%s' is not supported for generated columns.
ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN
was added in 5.7.6. -
Error:
3107
SQLSTATE:HY000
(ER_GENERATED_COLUMN_NON_PRIOR
)Message: Generated column can refer only to generated columns defined prior to it.
To address this issue, change the table definition to define each generated column later than any generated columns to which it refers.
ER_GENERATED_COLUMN_NON_PRIOR
was added in 5.7.6. -
Error:
3108
SQLSTATE:HY000
(ER_DEPENDENT_BY_GENERATED_COLUMN
)Message: Column '%s' has a generated column dependency.
You cannot drop or rename a generated column if another column refers to it. You must either drop those columns as well, or redefine them not to refer to the generated column.
ER_DEPENDENT_BY_GENERATED_COLUMN
was added in 5.7.6. -
Error:
3109
SQLSTATE:HY000
(ER_GENERATED_COLUMN_REF_AUTO_INC
)Message: Generated column '%s' cannot refer to auto-increment column.
ER_GENERATED_COLUMN_REF_AUTO_INC
was added in 5.7.6. -
Error:
3110
SQLSTATE:HY000
(ER_FEATURE_NOT_AVAILABLE
)Message: The '%s' feature is not available; you need to remove '%s' or use MySQL built with '%s'
ER_FEATURE_NOT_AVAILABLE
was added in 5.7.6. -
Error:
3111
SQLSTATE:HY000
(ER_CANT_SET_GTID_MODE
)Message: SET @@GLOBAL.GTID_MODE = %s is not allowed because %s.
ER_CANT_SET_GTID_MODE
was added in 5.7.6. -
Error:
3112
SQLSTATE:HY000
(ER_CANT_USE_AUTO_POSITION_WITH_GTID_MODE_OFF
)Message: The replication receiver thread%s cannot start in AUTO_POSITION mode: this server uses @@GLOBAL.GTID_MODE = OFF.
ER_CANT_USE_AUTO_POSITION_WITH_GTID_MODE_OFF
was added in 5.7.6. -
Error:
3113
SQLSTATE:HY000
(ER_CANT_REPLICATE_ANONYMOUS_WITH_AUTO_POSITION
)Message: Cannot replicate anonymous transaction when AUTO_POSITION = 1, at file %s, position %lld.
ER_CANT_REPLICATE_ANONYMOUS_WITH_AUTO_POSITION
was added in 5.7.6. -
Error:
3114
SQLSTATE:HY000
(ER_CANT_REPLICATE_ANONYMOUS_WITH_GTID_MODE_ON
)Message: Cannot replicate anonymous transaction when @@GLOBAL.GTID_MODE = ON, at file %s, position %lld.
ER_CANT_REPLICATE_ANONYMOUS_WITH_GTID_MODE_ON
was added in 5.7.6. -
Error:
3115
SQLSTATE:HY000
(ER_CANT_REPLICATE_GTID_WITH_GTID_MODE_OFF
)Message: Cannot replicate GTID-transaction when @@GLOBAL.GTID_MODE = OFF, at file %s, position %lld.
ER_CANT_REPLICATE_GTID_WITH_GTID_MODE_OFF
was added in 5.7.6. -
Error:
3116
SQLSTATE:HY000
(ER_CANT_SET_ENFORCE_GTID_CONSISTENCY_ON_WITH_ONGOING_GTID_VIOLATING_TRANSACTIONS
)Message: Cannot set ENFORCE_GTID_CONSISTENCY = ON because there are ongoing transactions that violate GTID consistency.
ER_CANT_SET_ENFORCE_GTID_CONSISTENCY_ON_WITH_ONGOING_GTID_VIOLATING_TRANSACTIONS
was added in 5.7.6. -
Error:
3117
SQLSTATE:HY000
(ER_SET_ENFORCE_GTID_CONSISTENCY_WARN_WITH_ONGOING_GTID_VIOLATING_TRANSACTIONS
)Message: There are ongoing transactions that violate GTID consistency.
ER_SET_ENFORCE_GTID_CONSISTENCY_WARN_WITH_ONGOING_GTID_VIOLATING_TRANSACTIONS
was added in 5.7.6. -
Error:
3118
SQLSTATE:HY000
(ER_ACCOUNT_HAS_BEEN_LOCKED
)Message: Access denied for user '%s'@'%s'. Account is locked.
The account was locked with
CREATE USER ... ACCOUNT LOCK
orALTER USER ... ACCOUNT LOCK
. An administrator can unlock it withALTER USER ... ACCOUNT UNLOCK
.ER_ACCOUNT_HAS_BEEN_LOCKED
was added in 5.7.6. -
Error:
3119
SQLSTATE:42000
(ER_WRONG_TABLESPACE_NAME
)Message: Incorrect tablespace name `%s`
ER_WRONG_TABLESPACE_NAME
was added in 5.7.6. -
Error:
3120
SQLSTATE:HY000
(ER_TABLESPACE_IS_NOT_EMPTY
)Message: Tablespace `%s` is not empty.
ER_TABLESPACE_IS_NOT_EMPTY
was added in 5.7.6. -
Error:
3121
SQLSTATE:HY000
(ER_WRONG_FILE_NAME
)Message: Incorrect File Name '%s'.
ER_WRONG_FILE_NAME
was added in 5.7.6. -
Error:
3122
SQLSTATE:HY000
(ER_BOOST_GEOMETRY_INCONSISTENT_TURNS_EXCEPTION
)Message: Inconsistent intersection points.
ER_BOOST_GEOMETRY_INCONSISTENT_TURNS_EXCEPTION
was added in 5.7.7. -
Error:
3123
SQLSTATE:HY000
(ER_WARN_OPTIMIZER_HINT_SYNTAX_ERROR
)Message: Optimizer hint syntax error
ER_WARN_OPTIMIZER_HINT_SYNTAX_ERROR
was added in 5.7.7. -
Error:
3124
SQLSTATE:HY000
(ER_WARN_BAD_MAX_EXECUTION_TIME
)Message: Unsupported MAX_EXECUTION_TIME
ER_WARN_BAD_MAX_EXECUTION_TIME
was added in 5.7.7. -
Error:
3125
SQLSTATE:HY000
(ER_WARN_UNSUPPORTED_MAX_EXECUTION_TIME
)Message: MAX_EXECUTION_TIME hint is supported by top-level standalone SELECT statements only
The
MAX_EXECUTION_TIME()
optimizer hint is supported only forSELECT
statements.ER_WARN_UNSUPPORTED_MAX_EXECUTION_TIME
was added in 5.7.7. -
Error:
3126
SQLSTATE:HY000
(ER_WARN_CONFLICTING_HINT
)Message: Hint %s is ignored as conflicting/duplicated
ER_WARN_CONFLICTING_HINT
was added in 5.7.7. -
Error:
3127
SQLSTATE:HY000
(ER_WARN_UNKNOWN_QB_NAME
)Message: Query block name %s is not found for %s hint
ER_WARN_UNKNOWN_QB_NAME
was added in 5.7.7. -
Error:
3128
SQLSTATE:HY000
(ER_UNRESOLVED_HINT_NAME
)Message: Unresolved name %s for %s hint
ER_UNRESOLVED_HINT_NAME
was added in 5.7.7. -
Error:
3129
SQLSTATE:HY000
(ER_WARN_DEPRECATED_SQLMODE_UNSET
)Message: Unsetting sql mode '%s' is deprecated. It will be made read-only in a future release.
ER_WARN_DEPRECATED_SQLMODE_UNSET
was added in 5.7.7, removed after 5.7.7. -
Error:
3129
SQLSTATE:HY000
(ER_WARN_ON_MODIFYING_GTID_EXECUTED_TABLE
)Message: Please do not modify the %s table. This is a mysql internal system table to store GTIDs for committed transactions. Modifying it can lead to an inconsistent GTID state.
ER_WARN_ON_MODIFYING_GTID_EXECUTED_TABLE
was added in 5.7.8. -
Error:
3130
SQLSTATE:HY000
(ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
)Message: Command not supported by pluggable protocols
ER_PLUGGABLE_PROTOCOL_COMMAND_NOT_SUPPORTED
was added in 5.7.8. -
Error:
3131
SQLSTATE:42000
(ER_LOCKING_SERVICE_WRONG_NAME
)Message: Incorrect locking service lock name '%s'.
A locking service name was specified as
NULL
, the empty string, or a string longer than 64 characters. Namespace and lock names must be non-NULL
, nonempty, and no more than 64 characters long.ER_LOCKING_SERVICE_WRONG_NAME
was added in 5.7.8. -
Error:
3132
SQLSTATE:HY000
(ER_LOCKING_SERVICE_DEADLOCK
)Message: Deadlock found when trying to get locking service lock; try releasing locks and restarting lock acquisition.
ER_LOCKING_SERVICE_DEADLOCK
was added in 5.7.8. -
Error:
3133
SQLSTATE:HY000
(ER_LOCKING_SERVICE_TIMEOUT
)Message: Service lock wait timeout exceeded.
ER_LOCKING_SERVICE_TIMEOUT
was added in 5.7.8. -
Error:
3134
SQLSTATE:HY000
(ER_GIS_MAX_POINTS_IN_GEOMETRY_OVERFLOWED
)Message: Parameter %s exceeds the maximum number of points in a geometry (%lu) in function %s.
ER_GIS_MAX_POINTS_IN_GEOMETRY_OVERFLOWED
was added in 5.7.8. -
Error:
3135
SQLSTATE:HY000
(ER_SQL_MODE_MERGED
)Message: 'NO_ZERO_DATE', 'NO_ZERO_IN_DATE' and 'ERROR_FOR_DIVISION_BY_ZERO' sql modes should be used with strict mode. They will be merged with strict mode in a future release.
ER_SQL_MODE_MERGED
was added in 5.7.8. -
Error:
3136
SQLSTATE:HY000
(ER_VTOKEN_PLUGIN_TOKEN_MISMATCH
)Message: Version token mismatch for %.*s. Correct value %.*s
The client has set its
version_tokens_session
system variable to the list of tokens it requires the server to match, but the server token list has at least one matching token name that has a value different from what the client requires. See Section 5.1.8.4, “Version Tokens”.ER_VTOKEN_PLUGIN_TOKEN_MISMATCH
was added in 5.7.8. -
Error:
3137
SQLSTATE:HY000
(ER_VTOKEN_PLUGIN_TOKEN_NOT_FOUND
)Message: Version token %.*s not found.
The client has set its
version_tokens_session
system variable to the list of tokens it requires the server to match, but the server token list is missing at least one of those tokens. See Section 5.1.8.4, “Version Tokens”.ER_VTOKEN_PLUGIN_TOKEN_NOT_FOUND
was added in 5.7.8. -
Error:
3138
SQLSTATE:HY000
(ER_CANT_SET_VARIABLE_WHEN_OWNING_GTID
)Message: Variable %s cannot be changed by a client that owns a GTID. The client owns %s. Ownership is released on COMMIT or ROLLBACK.
ER_CANT_SET_VARIABLE_WHEN_OWNING_GTID
was added in 5.7.8. -
Error:
3139
SQLSTATE:HY000
(ER_SLAVE_CHANNEL_OPERATION_NOT_ALLOWED
)Message: %s cannot be performed on channel '%s'.
ER_SLAVE_CHANNEL_OPERATION_NOT_ALLOWED
was added in 5.7.8. -
Error:
3140
SQLSTATE:22032
(ER_INVALID_JSON_TEXT
)Message: Invalid JSON text: "%s" at position %u in value (or column) '%s'.
ER_INVALID_JSON_TEXT
was added in 5.7.8. -
Error:
3141
SQLSTATE:22032
(ER_INVALID_JSON_TEXT_IN_PARAM
)Message: Invalid JSON text in argument %u to function %s: "%s" at position %u in '%s'.
ER_INVALID_JSON_TEXT_IN_PARAM
was added in 5.7.8. -
Error:
3142
SQLSTATE:HY000
(ER_INVALID_JSON_BINARY_DATA
)Message: The JSON binary value contains invalid data.
ER_INVALID_JSON_BINARY_DATA
was added in 5.7.8. -
Error:
3143
SQLSTATE:42000
(ER_INVALID_JSON_PATH
)Message: Invalid JSON path expression. The error is around character position %u in '%s'.
ER_INVALID_JSON_PATH
was added in 5.7.8. -
Error:
3144
SQLSTATE:22032
(ER_INVALID_JSON_CHARSET
)Message: Cannot create a JSON value from a string with CHARACTER SET '%s'.
ER_INVALID_JSON_CHARSET
was added in 5.7.8. -
Error:
3145
SQLSTATE:22032
(ER_INVALID_JSON_CHARSET_IN_FUNCTION
)Message: Invalid JSON character data provided to function %s: '%s'; utf8 is required.
ER_INVALID_JSON_CHARSET_IN_FUNCTION
was added in 5.7.8. -
Error:
3146
SQLSTATE:22032
(ER_INVALID_TYPE_FOR_JSON
)Message: Invalid data type for JSON data in argument %u to function %s; a JSON string or JSON type is required.
ER_INVALID_TYPE_FOR_JSON
was added in 5.7.8. -
Error:
3147
SQLSTATE:22032
(ER_INVALID_CAST_TO_JSON
)Message: Cannot CAST value to JSON.
ER_INVALID_CAST_TO_JSON
was added in 5.7.8. -
Error:
3148
SQLSTATE:42000
(ER_INVALID_JSON_PATH_CHARSET
)Message: A path expression must be encoded in the utf8 character set. The path expression '%s' is encoded in character set '%s'.
ER_INVALID_JSON_PATH_CHARSET
was added in 5.7.8. -
Error:
3149
SQLSTATE:42000
(ER_INVALID_JSON_PATH_WILDCARD
)Message: In this situation, path expressions may not contain the * and ** tokens.
ER_INVALID_JSON_PATH_WILDCARD
was added in 5.7.8. -
Error:
3150
SQLSTATE:22032
(ER_JSON_VALUE_TOO_BIG
)Message: The JSON value is too big to be stored in a JSON column.
ER_JSON_VALUE_TOO_BIG
was added in 5.7.8. -
Error:
3151
SQLSTATE:22032
(ER_JSON_KEY_TOO_BIG
)Message: The JSON object contains a key name that is too long.
ER_JSON_KEY_TOO_BIG
was added in 5.7.8. -
Error:
3152
SQLSTATE:42000
(ER_JSON_USED_AS_KEY
)Message: JSON column '%s' cannot be used in key specification.
ER_JSON_USED_AS_KEY
was added in 5.7.8. -
Error:
3153
SQLSTATE:42000
(ER_JSON_VACUOUS_PATH
)Message: The path expression '$' is not allowed in this context.
ER_JSON_VACUOUS_PATH
was added in 5.7.8. -
Error:
3154
SQLSTATE:42000
(ER_JSON_BAD_ONE_OR_ALL_ARG
)Message: The oneOrAll argument to %s may take these values: 'one' or 'all'.
ER_JSON_BAD_ONE_OR_ALL_ARG
was added in 5.7.8. -
Error:
3155
SQLSTATE:22003
(ER_NUMERIC_JSON_VALUE_OUT_OF_RANGE
)Message: Out of range JSON value for CAST to %s: '%s' from %s at row %ld
ER_NUMERIC_JSON_VALUE_OUT_OF_RANGE
was added in 5.7.8. -
Error:
3156
SQLSTATE:22018
(ER_INVALID_JSON_VALUE_FOR_CAST
)Message: Invalid JSON value for CAST to %s: '%s' from %s at row %ld
ER_INVALID_JSON_VALUE_FOR_CAST
was added in 5.7.8. -
Error:
3157
SQLSTATE:22032
(ER_JSON_DOCUMENT_TOO_DEEP
)Message: The JSON document exceeds the maximum depth.
ER_JSON_DOCUMENT_TOO_DEEP
was added in 5.7.8. -
Error:
3158
SQLSTATE:22032
(ER_JSON_DOCUMENT_NULL_KEY
)Message: JSON documents may not contain NULL member names.
ER_JSON_DOCUMENT_NULL_KEY
was added in 5.7.8. -
Error:
3159
SQLSTATE:HY000
(ER_SECURE_TRANSPORT_REQUIRED
)Message: Connections using insecure transport are prohibited while --require_secure_transport=ON.
With the
require_secure_transport
system variable, clients can connect only using secure transports. Qualifying connections are those using SSL, a Unix socket file, or shared memory.ER_SECURE_TRANSPORT_REQUIRED
was added in 5.7.8. -
Error:
3160
SQLSTATE:HY000
(ER_NO_SECURE_TRANSPORTS_CONFIGURED
)Message: No secure transports (SSL or Shared Memory) are configured, unable to set --require_secure_transport=ON.
The
require_secure_transport
system variable cannot be enabled if the server does not support at least one secure transport. Configure the server with the required SSL keys/certificates to enable SSL connections, or enable theshared_memory
system variable to enable shared-memory connections.ER_NO_SECURE_TRANSPORTS_CONFIGURED
was added in 5.7.8. -
Error:
3161
SQLSTATE:HY000
(ER_DISABLED_STORAGE_ENGINE
)Message: Storage engine %s is disabled (Table creation is disallowed).
An attempt was made to create a table or tablespace using a storage engine listed in the value of the
disabled_storage_engines
system variable, or to change an existing table or tablespace to such an engine. Choose a different storage engine.ER_DISABLED_STORAGE_ENGINE
was added in 5.7.8. -
Error:
3162
SQLSTATE:HY000
(ER_USER_DOES_NOT_EXIST
)Message: User %s does not exist.
ER_USER_DOES_NOT_EXIST
was added in 5.7.8. -
Error:
3163
SQLSTATE:HY000
(ER_USER_ALREADY_EXISTS
)Message: User %s already exists.
ER_USER_ALREADY_EXISTS
was added in 5.7.8. -
Error:
3164
SQLSTATE:HY000
(ER_AUDIT_API_ABORT
)Message: Aborted by Audit API ('%s';%d).
This error indicates that an audit plugin terminated execution of an event. The message typically indicates the event subclass name and a numeric status value.
ER_AUDIT_API_ABORT
was added in 5.7.8. -
Error:
3165
SQLSTATE:42000
(ER_INVALID_JSON_PATH_ARRAY_CELL
)Message: A path expression is not a path to a cell in an array.
ER_INVALID_JSON_PATH_ARRAY_CELL
was added in 5.7.8. -
Error:
3166
SQLSTATE:HY000
(ER_BUFPOOL_RESIZE_INPROGRESS
)Message: Another buffer pool resize is already in progress.
ER_BUFPOOL_RESIZE_INPROGRESS
was added in 5.7.9. -
Error:
3167
SQLSTATE:HY000
(ER_FEATURE_DISABLED_SEE_DOC
)Message: The '%s' feature is disabled; see the documentation for '%s'
ER_FEATURE_DISABLED_SEE_DOC
was added in 5.7.9. -
Error:
3168
SQLSTATE:HY000
(ER_SERVER_ISNT_AVAILABLE
)Message: Server isn't available
ER_SERVER_ISNT_AVAILABLE
was added in 5.7.9. -
Error:
3169
SQLSTATE:HY000
(ER_SESSION_WAS_KILLED
)Message: Session was killed
ER_SESSION_WAS_KILLED
was added in 5.7.9. -
Error:
3170
SQLSTATE:HY000
(ER_CAPACITY_EXCEEDED
)Message: Memory capacity of %llu bytes for '%s' exceeded. %s
ER_CAPACITY_EXCEEDED
was added in 5.7.9. -
Error:
3171
SQLSTATE:HY000
(ER_CAPACITY_EXCEEDED_IN_RANGE_OPTIMIZER
)Message: Range optimization was not done for this query.
ER_CAPACITY_EXCEEDED_IN_RANGE_OPTIMIZER
was added in 5.7.9. -
Error:
3172
SQLSTATE:HY000
(ER_TABLE_NEEDS_UPG_PART
)Message: Partitioning upgrade required. Please dump/reload to fix it or do: ALTER TABLE `%s`.`%s` UPGRADE PARTITIONING
ER_TABLE_NEEDS_UPG_PART
was added in 5.7.9. -
Error:
3173
SQLSTATE:HY000
(ER_CANT_WAIT_FOR_EXECUTED_GTID_SET_WHILE_OWNING_A_GTID
)Message: The client holds ownership of the GTID %s. Therefore, WAIT_FOR_EXECUTED_GTID_SET cannot wait for this GTID.
ER_CANT_WAIT_FOR_EXECUTED_GTID_SET_WHILE_OWNING_A_GTID
was added in 5.7.9. -
Error:
3174
SQLSTATE:HY000
(ER_CANNOT_ADD_FOREIGN_BASE_COL_VIRTUAL
)Message: Cannot add foreign key on the base column of indexed virtual column.
ER_CANNOT_ADD_FOREIGN_BASE_COL_VIRTUAL
was added in 5.7.10. -
Error:
3175
SQLSTATE:HY000
(ER_CANNOT_CREATE_VIRTUAL_INDEX_CONSTRAINT
)Message: Cannot create index on virtual column whose base column has foreign constraint.
ER_CANNOT_CREATE_VIRTUAL_INDEX_CONSTRAINT
was added in 5.7.10. -