Chapter 3 Client Error Message Reference

Client error messages originate from within the MySQL client library. Here is an example client error message, as displayed by the mysql client:

$> mysql -h no-such-host
ERROR 2005 (HY000): Unknown MySQL server host 'no-such-host' (0)

Each client error message includes an error code, SQLSTATE value, and message string, as described in Error Message Sources and Elements. These elements are available as described in Error Information Interfaces. For client errors, the SQLSTATE value is always 'HY000' (general error), so it is not meaningful for distinguishing one client error from another.

The client library also makes available to host client programs any errors that originate on the server side and are recieved by the client from the server. For a list of server-side errors, see Chapter 2, Server Error Message Reference.

In addition to the errors in the following list, the client library can also produce error messages that have error codes in the range from 1 to 999. See Chapter 4, Global Error Message Reference

• Error number: 2000; Symbol: CR_UNKNOWN_ERROR;

  Message: Unknown MySQL error

• Error number: 2001; Symbol: CR_SOCKET_CREATE_ERROR;

  Message: Can't create UNIX socket (%d)

• Error number: 2002; Symbol: CR_CONNECTION_ERROR;

  Message: Can't connect to local MySQL server through socket '%s' (%d)

• Error number: 2003; Symbol: CR_CONN_HOST_ERROR;

  Message: Can't connect to MySQL server on '%s:%u' (%d)

• Error number: 2004; Symbol: CR_IPSOCK_ERROR;

  Message: Can't create TCP/IP socket (%d)

• Error number: 2005; Symbol: CR_UNKNOWN_HOST;

  Message: Unknown MySQL server host '%s' (%d)

• Error number: 2006; Symbol: CR_SERVER_GONE_ERROR;

  Message: MySQL server has gone away

• Error number: 2007; Symbol: CR_VERSION_ERROR;

  Message: Protocol mismatch; server version = %d, client version = %d

• Error number: 2008; Symbol: CR_OUT_OF_MEMORY;

  Message: MySQL client ran out of memory

• Error number: 2009; Symbol: CR_WRONG_HOST_INFO;

  Message: Wrong host info

• Error number: 2010; Symbol: CR_LOCALHOST_CONNECTION;

  Message: Localhost via UNIX socket

• Error number: 2011; Symbol: CR_TCP_CONNECTION;

  Message: %s via TCP/IP

• Error number: 2012; Symbol: CR_SERVER_HANDSHAKE_ERR;

  Message: Error in server handshake

• Error number: 2013; Symbol: CR_SERVER_LOST;

  Message: Lost connection to MySQL server during query

• Error number: 2014; Symbol: CR_COMMANDS_OUT_OF_SYNC;

  Message: Commands out of sync; you can't run this command now

  Commands were executed in an improper order. This error occurs when a function is called that is not appropriate for the current state of the connection. For example, if mysql_stmt_fetch() is not called enough times to read an entire result set (that is, enough times to return MYSQL_NO_DATA), this error may occur for the following C API call.

• Error number: 2015; Symbol: CR_NAMEDPIPE_CONNECTION;

  Message: Named pipe: %s

• Error number: 2016; Symbol: CR_NAMEDPIPEWAIT_ERROR;

  Message: Can't wait for named pipe to host: %s pipe: %s (%lu)

• Error number: 2017; Symbol: CR_NAMEDPIPEOPEN_ERROR;

  Message: Can't open named pipe to host: %s pipe: %s (%lu)

• Error number: 2018; Symbol: CR_NAMEDPIPESETSTATE_ERROR;

  Message: Can't set state of named pipe to host: %s pipe: %s (%lu)

• Error number: 2019; Symbol: CR_CANT_READ_CHARSET;

  Message: Can't initialize character set %s (path: %s)

• Error number: 2020; Symbol: CR_NET_PACKET_TOO_LARGE;

  Message: Got packet bigger than 'max_allowed_packet' bytes

• Error number: 2021; Symbol: CR_EMBEDDED_CONNECTION;

  Message: Embedded server

• Error number: 2022; Symbol: CR_PROBE_SLAVE_STATUS;

  Message: Error on SHOW SLAVE STATUS:

  CR_PROBE_SLAVE_STATUS was removed after 8.0.32.

• Error number: 2022; Symbol: CR_PROBE_REPLICA_STATUS;

  Message: Error on SHOW REPLICA STATUS:

  CR_PROBE_REPLICA_STATUS was added in 8.0.33.

• Error number: 2023; Symbol: CR_PROBE_SLAVE_HOSTS;

  Message: Error on SHOW SLAVE HOSTS:

  CR_PROBE_SLAVE_HOSTS was removed after 8.0.32.

• Error number: 2023; Symbol: CR_PROBE_REPLICA_HOSTS;

  Message: Error on SHOW REPLICA HOSTS:

  CR_PROBE_REPLICA_HOSTS was added in 8.0.33.

• Error number: 2024; Symbol: CR_PROBE_SLAVE_CONNECT;

  Message: Error connecting to slave:

  CR_PROBE_SLAVE_CONNECT was removed after 8.0.32.

• Error number: 2024; Symbol: CR_PROBE_REPLICA_CONNECT;

  Message: Error connecting to replica:

  CR_PROBE_REPLICA_CONNECT was added in 8.0.33.

• Error number: 2025; Symbol: CR_PROBE_MASTER_CONNECT;

  Message: Error connecting to master:

  CR_PROBE_MASTER_CONNECT was removed after 8.0.32.

• Error number: 2025; Symbol: CR_PROBE_SOURCE_CONNECT;

  Message: Error connecting to source:

  CR_PROBE_SOURCE_CONNECT was added in 8.0.33.

• Error number: 2026; Symbol: CR_SSL_CONNECTION_ERROR;

  Message: SSL connection error: %s

• Error number: 2027; Symbol: CR_MALFORMED_PACKET;

  Message: Malformed packet

• Error number: 2028; Symbol: CR_WRONG_LICENSE;

  Message: This client library is licensed only for use with MySQL servers having '%s' license

• Error number: 2029; Symbol: CR_NULL_POINTER;

  Message: Invalid use of null pointer

• Error number: 2030; Symbol: CR_NO_PREPARE_STMT;

  Message: Statement not prepared

• Error number: 2031; Symbol: CR_PARAMS_NOT_BOUND;

  Message: No data supplied for parameters in prepared statement

• Error number: 2032; Symbol: CR_DATA_TRUNCATED;

  Message: Data truncated

• Error number: 2033; Symbol: CR_NO_PARAMETERS_EXISTS;

  Message: No parameters exist in the statement

• Error number: 2034; Symbol: CR_INVALID_PARAMETER_NO;

  Message: Invalid parameter number

  The column number for mysql_stmt_fetch_column() was invalid.

  The parameter number for mysql_stmt_send_long_data() was invalid.

  A key name was empty or the amount of connection attribute data for mysql_options4() exceeds the 64KB limit.

• Error number: 2035; Symbol: CR_INVALID_BUFFER_USE;

  Message: Can't send long data for non-string/non-binary data types (parameter: %d)

• Error number: 2036; Symbol: CR_UNSUPPORTED_PARAM_TYPE;

  Message: Using unsupported buffer type: %d (parameter: %d)

• Error number: 2037; Symbol: CR_SHARED_MEMORY_CONNECTION;

  Message: Shared memory: %s

• Error number: 2038; Symbol: CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR;

  Message: Can't open shared memory; client could not create request event (%lu)

• Error number: 2039; Symbol: CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR;

  Message: Can't open shared memory; no answer event received from server (%lu)

• Error number: 2040; Symbol: CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR;

  Message: Can't open shared memory; server could not allocate file mapping (%lu)

• Error number: 2041; Symbol: CR_SHARED_MEMORY_CONNECT_MAP_ERROR;

  Message: Can't open shared memory; server could not get pointer to file mapping (%lu)

• Error number: 2042; Symbol: CR_SHARED_MEMORY_FILE_MAP_ERROR;

  Message: Can't open shared memory; client could not allocate file mapping (%lu)

• Error number: 2043; Symbol: CR_SHARED_MEMORY_MAP_ERROR;

  Message: Can't open shared memory; client could not get pointer to file mapping (%lu)

• Error number: 2044; Symbol: CR_SHARED_MEMORY_EVENT_ERROR;

  Message: Can't open shared memory; client could not create %s event (%lu)

• Error number: 2045; Symbol: CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR;

  Message: Can't open shared memory; no answer from server (%lu)

• Error number: 2046; Symbol: CR_SHARED_MEMORY_CONNECT_SET_ERROR;

  Message: Can't open shared memory; cannot send request event to server (%lu)

• Error number: 2047; Symbol: CR_CONN_UNKNOW_PROTOCOL;

  Message: Wrong or unknown protocol

• Error number: 2048; Symbol: CR_INVALID_CONN_HANDLE;

  Message: Invalid connection handle

• Error number: 2049; Symbol: CR_UNUSED_1;

  Message: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

• Error number: 2050; Symbol: CR_FETCH_CANCELED;

  Message: Row retrieval was canceled by mysql_stmt_close() call

• Error number: 2051; Symbol: CR_NO_DATA;

  Message: Attempt to read column without prior row fetch

• Error number: 2052; Symbol: CR_NO_STMT_METADATA;

  Message: Prepared statement contains no metadata

• Error number: 2053; Symbol: CR_NO_RESULT_SET;

  Message: Attempt to read a row while there is no result set associated with the statement

• Error number: 2054; Symbol: CR_NOT_IMPLEMENTED;

  Message: This feature is not implemented yet

• Error number: 2055; Symbol: CR_SERVER_LOST_EXTENDED;

  Message: Lost connection to MySQL server at '%s', system error: %d

• Error number: 2056; Symbol: CR_STMT_CLOSED;

  Message: Statement closed indirectly because of a preceding %s() call

• Error number: 2057; Symbol: CR_NEW_STMT_METADATA;

  Message: The number of columns in the result set differs from the number of bound buffers. You must reset the statement, rebind the result set columns, and execute the statement again

• Error number: 2058; Symbol: CR_ALREADY_CONNECTED;

  Message: This handle is already connected. Use a separate handle for each connection.

• Error number: 2059; Symbol: CR_AUTH_PLUGIN_CANNOT_LOAD;

  Message: Authentication plugin '%s' cannot be loaded: %s

• Error number: 2060; Symbol: CR_DUPLICATE_CONNECTION_ATTR;

  Message: There is an attribute with the same name already

  A duplicate connection attribute name was specified for mysql_options4().

• Error number: 2061; Symbol: CR_AUTH_PLUGIN_ERR;

  Message: Authentication plugin '%s' reported error: %s

• Error number: 2062; Symbol: CR_INSECURE_API_ERR;

  Message: Insecure API function call: '%s' Use instead: '%s'

  An insecure function call was detected. Modify the application to use the suggested alternative function instead.

• Error number: 2063; Symbol: CR_FILE_NAME_TOO_LONG;

  Message: File name is too long

  CR_FILE_NAME_TOO_LONG was added in 8.0.1.

• Error number: 2064; Symbol: CR_SSL_FIPS_MODE_ERR;

  Message: Set FIPS mode ON/STRICT failed

  CR_SSL_FIPS_MODE_ERR was added in 8.0.11.

• Error number: 2065; Symbol: CR_COMPRESSION_NOT_SUPPORTED;

  Message: Compression protocol not supported with asynchronous protocol

  CR_COMPRESSION_NOT_SUPPORTED was added in 8.0.16, removed after 8.0.20.

• Error number: 2065; Symbol: CR_DEPRECATED_COMPRESSION_NOT_SUPPORTED;

  Message: Compression protocol not supported with asynchronous protocol

  CR_DEPRECATED_COMPRESSION_NOT_SUPPORTED was added in 8.0.21.

• Error number: 2066; Symbol: CR_COMPRESSION_WRONGLY_CONFIGURED;

  Message: Connection failed due to wrongly configured compression algorithm

  CR_COMPRESSION_WRONGLY_CONFIGURED was added in 8.0.18.

• Error number: 2067; Symbol: CR_KERBEROS_USER_NOT_FOUND;

  Message: SSO user not found, Please perform SSO authentication using kerberos.

  CR_KERBEROS_USER_NOT_FOUND was added in 8.0.20.

• Error number: 2068; Symbol: CR_LOAD_DATA_LOCAL_INFILE_REJECTED;

  Message: LOAD DATA LOCAL INFILE file request rejected due to restrictions on access.

  CR_LOAD_DATA_LOCAL_INFILE_REJECTED was added in 8.0.21.

• Error number: 2069; Symbol: CR_LOAD_DATA_LOCAL_INFILE_REALPATH_FAIL;

  Message: Determining the real path for '%s' failed with error (%d): %s

  CR_LOAD_DATA_LOCAL_INFILE_REALPATH_FAIL was added in 8.0.21.

• Error number: 2070; Symbol: CR_DNS_SRV_LOOKUP_FAILED;

  Message: DNS SRV lookup failed with error : %d

  CR_DNS_SRV_LOOKUP_FAILED was added in 8.0.22.

• Error number: 2071; Symbol: CR_MANDATORY_TRACKER_NOT_FOUND;

  Message: Client does not recognise tracker type %d marked as mandatory by server.

  CR_MANDATORY_TRACKER_NOT_FOUND was added in 8.0.27.

• Error number: 2072; Symbol: CR_INVALID_FACTOR_NO;

  Message: Invalid first argument for MYSQL_OPT_USER_PASSWORD option. Valid value should be between 1 and 3 inclusive.

  CR_INVALID_FACTOR_NO was added in 8.0.27.

• Error number: 2073; Symbol: CR_CANT_GET_SESSION_DATA;

  Message: Can't get session data: %s

  CR_CANT_GET_SESSION_DATA was added in 8.0.29.

• Error number: 2074; Symbol: CR_INVALID_CLIENT_CHARSET;

  Message: '%s' character set is having more than 1 byte minimum character length, which cannot be used as a client character set. Please use any of the single byte minimum ones, e.g. utf8mb4, latin1 etc.

  CR_INVALID_CLIENT_CHARSET was added in 8.0.33.