All pages
Powered by GitBook
1 of 62

MariaDB Error Codes 3000 to 3099

Error 3000: File is corrupted

Error Code
SQLSTATE
Error
Description

3000

ER_FILE_CORRUPT

File %s is corrupted

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3001: Query partially completed on the master (error on master) and was aborted

Error 3001: 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 Code
SQLSTATE
Error
Description

3001

ER_ERROR_ON_MASTER

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'"

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3002: Query caused different errors on master and slave

Error Code
SQLSTATE
Error
Description

3002

ER_INCONSISTENT_ERROR

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'

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3003: Storage engine for table is not loaded

Error Code
SQLSTATE
Error
Description

3003

ER_STORAGE_ENGINE_NOT_LOADED

Storage engine for table '%s'.'%s' is not loaded.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3004: GET STACKED DIAGNOSTICS when handler not active

Error Code
SQLSTATE
Error
Description

3004

ER_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER 0Z002

GET STACKED DIAGNOSTICS when handler not active

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3005: is no longer supported. The statement was converted to

Error Code
SQLSTATE
Error
Description

3005

ER_WARN_LEGACY_SYNTAX_CONVERTED

%s is no longer supported. The statement was converted to %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3006: Statement is unsafe because it uses a fulltext parser plugin which may not return the sa

Error Code
SQLSTATE
Error
Description

3006

ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN

Statement is unsafe because it uses a fulltext parser plugin which may not return the same value on the slave.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3007: Cannot DISCARD/IMPORT tablespace associated with temporary table

Error Code
SQLSTATE
Error
Description

3007

ER_CANNOT_DISCARD_TEMPORARY_TABLE

Cannot DISCARD/IMPORT tablespace associated with temporary table

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3008: Foreign key cascade delete/update exceeds max depth of

Error Code
SQLSTATE
Error
Description

3008

ER_FK_DEPTH_EXCEEDED

Foreign key cascade delete/update exceeds max depth of %d.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3009: Column count of is wrong

Error Code
SQLSTATE
Error
Description

3009

ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2

Column count of %s.%s is wrong. Expected %d, found %d. Created with MariaDB %d, now running %d. Please use mysql_upgrade to fix this error.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3010: Trigger does not have CREATED attribute

Error Code
SQLSTATE
Error
Description

3010

ER_WARN_TRIGGER_DOESNT_HAVE_CREATED

Trigger %s.%s.%s does not have CREATED attribute.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3011: Referenced trigger for the given action time and event type does not exist

Error Code
SQLSTATE
Error
Description

3011

ER_REFERENCED_TRG_DOES_NOT_EXIST_MYSQL

Referenced trigger '%s' for the given action time and event type does not exist.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3012: EXPLAIN FOR CONNECTION command is supported only for SELECT/UPDATE/INSERT/DELETE/REPLACE

Error Code
SQLSTATE
Error
Description

3012

ER_EXPLAIN_NOT_SUPPORTED

EXPLAIN FOR CONNECTION command is supported only for SELECT/UPDATE/INSERT/DELETE/REPLACE

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3013: Invalid size for column

Error Code
SQLSTATE
Error
Description

3013

ER_INVALID_FIELD_SIZE

Invalid size for column '%-.192s'.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3014: Table storage engine found required create option missing

Error Code
SQLSTATE
Error
Description

3014

ER_MISSING_HA_CREATE_OPTION

Table storage engine '%-.64s' found required create option missing

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3015: Out of memory in storage engine

Error Code
SQLSTATE
Error
Description

3015

ER_ENGINE_OUT_OF_MEMORY

Out of memory in storage engine '%-.64s'.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3016: The password for anonymous user cannot be expired

Error Code
SQLSTATE
Error
Description

3016

ER_PASSWORD_EXPIRE_ANONYMOUS_USER

The password for anonymous user cannot be expired.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3017: This operation cannot be performed with a running slave sql thread

Error Code
SQLSTATE
Error
Description

3017

ER_SLAVE_SQL_THREAD_MUST_STOP

This operation cannot be performed with a running slave sql thread; run STOP SLAVE SQL_THREAD first

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3018: Cannot create FULLTEXT index on materialized subquery

Error Code
SQLSTATE
Error
Description

3018

ER_NO_FT_MATERIALIZED_SUBQUERY

Cannot create FULLTEXT index on materialized subquery

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3019: Undo Log error

Error Code
SQLSTATE
Error
Description

3019

ER_INNODB_UNDO_LOG_FULL

Undo Log error: %s

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3020: Invalid argument for logarithm

Error Code
SQLSTATE
Error
Description

3020

ER_INVALID_ARGUMENT_FOR_LOGARITHM

Invalid argument for logarithm

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3021: This operation cannot be performed with a running slave io thread

Error Code
SQLSTATE
Error
Description

3021

ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP

This operation cannot be performed with a running slave io thread; run STOP SLAVE IO_THREAD FOR CHANNEL '%s' first.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3022: This operation may not be safe when the slave has temporary tables

Error Code
SQLSTATE
Error
Description

3022

ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3023: CHANGE MASTER TO with a MASTER_LOG_FILE clause but no MASTER_LOG_POS clause may not be s

Error Code
SQLSTATE
Error
Description

3023

ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3024: Query execution was interrupted, maximum statement execution time exceeded

Error Code
SQLSTATE
Error
Description

3024

ER_QUERY_TIMEOUT

Query execution was interrupted, maximum statement execution time exceeded

Possible Causes and Solutions

The cause is that the executing statement took more than max_statement_time (primary) or slave_max_statement_time (replica) to execute.

To fix this, you have to either increase the value of max_statement_time or find out why the query is slow. Start by doing an EXPLAIN or ANALYZE on the query to find out how the query is executed.

See Also

  • Aborting Statements that Exceed a Certain Time to Execute

This page is licensed: CC BY-SA / Gnu FDL

Error 3025: Select is not a read only statement, disabling timer

Error Code
SQLSTATE
Error
Description

3025

ER_NON_RO_SELECT_DISABLE_TIMER

Select is not a read only statement, disabling timer

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3026: Duplicate entry

Error Code
SQLSTATE
Error
Description

3026

ER_DUP_LIST_ENTRY

Duplicate entry '%-.192s'.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3027: mode no longer has any effect. Use STRICT_ALL_TABLES or STRICT_TRANS_TABLES instead.

Error Code
SQLSTATE
Error
Description

3027

ER_SQL_MODE_NO_EFFECT

'%s' mode no longer has any effect. Use STRICT_ALL_TABLES or STRICT_TRANS_TABLES instead.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3028: Expression of ORDER BY contains aggregate function and applies to a UNION

Error Code
SQLSTATE
Error
Description

3028

ER_AGGREGATE_ORDER_FOR_UNION

Expression #%u of ORDER BY contains aggregate function and applies to a UNION

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3029: Expression of ORDER BY contains aggregate function and applies to the result of a non-ag

Error Code
SQLSTATE
Error
Description

3029

ER_AGGREGATE_ORDER_NON_AGG_QUERY

Expression #%u of ORDER BY contains aggregate function and applies to the result of a non-aggregated query

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3030: Slave worker has stopped after at least one previous worker encountered an error when sl

Error Code
SQLSTATE
Error
Description

3030

ER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR

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.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3031: slave_preserve_commit_order is not supported

Error Code
SQLSTATE
Error
Description

3031

ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER

slave_preserve_commit_order is not supported %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3032: The server is currently in offline mode

Error Code
SQLSTATE
Error
Description

3032

ER_SERVER_OFFLINE_MODE

The server is currently in offline mode

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3033: Binary geometry function given two geometries of different srids

Error Code
SQLSTATE
Error
Description

3033

ER_GIS_DIFFERENT_SRIDS

Binary geometry function %s given two geometries of different srids: %u and %u, which should have been identical.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3034: Calling geometry function with unsupported types of arguments

Error Code
SQLSTATE
Error
Description

3034

ER_GIS_UNSUPPORTED_ARGUMENT

Calling geometry function %s with unsupported types of arguments.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3035: Unknown GIS error occurred in function

Error Code
SQLSTATE
Error
Description

3035

ER_GIS_UNKNOWN_ERROR

Unknown GIS error occurred in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3036: Unknown exception caught in GIS function

Error Code
SQLSTATE
Error
Description

3036

ER_GIS_UNKNOWN_EXCEPTION

Unknown exception caught in GIS function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3037: Invalid GIS data provided to function

Error Code
SQLSTATE
Error
Description

3037

ER_GIS_INVALID_DATA

Invalid GIS data provided to function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3038: The geometry has no data in function

Error Code
SQLSTATE
Error
Description

3038

ER_BOOST_GEOMETRY_EMPTY_INPUT_EXCEPTION

The geometry has no data in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3039: Unable to calculate centroid because geometry is empty in function

Error Code
SQLSTATE
Error
Description

3039

ER_BOOST_GEOMETRY_CENTROID_EXCEPTION

Unable to calculate centroid because geometry is empty in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3040: Geometry overlay calculation error: geometry data is invalid in function

Error Code
SQLSTATE
Error
Description

3040

ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION

Geometry overlay calculation error: geometry data is invalid in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3041: Geometry turn info calculation error: geometry data is invalid in function

Error Code
SQLSTATE
Error
Description

3041

ER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION

Geometry turn info calculation error: geometry data is invalid in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3042: Analysis procedures of intersection points interrupted unexpectedly in function

Error Code
SQLSTATE
Error
Description

3042

ER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION

Analysis procedures of intersection points interrupted unexpectedly in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3043: Unknown exception thrown in function

Error Code
SQLSTATE
Error
Description

3043

ER_BOOST_GEOMETRY_UNKNOWN_EXCEPTION

Unknown exception thrown in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3044: Memory allocation error

Error Code
SQLSTATE
Error
Description

3044

ER_STD_BAD_ALLOC_ERROR

Memory allocation error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3045: Domain error

Error Code
SQLSTATE
Error
Description

3045

ER_STD_DOMAIN_ERROR

Domain error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3046: Length error

Error Code
SQLSTATE
Error
Description

3046

ER_STD_LENGTH_ERROR

Length error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3047: Invalid argument error

Error Code
SQLSTATE
Error
Description

3047

ER_STD_INVALID_ARGUMENT

Invalid argument error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3048: Out of range error

Error Code
SQLSTATE
Error
Description

3048

ER_STD_OUT_OF_RANGE_ERROR

Out of range error: %-.256s in function %s.

Possible Causes and Solutions

Function Arguments Outside the Expected Bounds

Functions arguments have an expected range, and this error is returned if this range is exceeded. Follow the documentation for the specific function indicated in the error message. For example, the ST_GeoHash function expects the longitude and latitude parameters to be between -180 and 180. In this case, the longitude argument is invalid:

SELECT ST_GeoHash(181,30,15);                    
ERROR 3048 (HY000): Out of range error: Longitude should be [-180,180] in function ST_GeoHash.

By providing a longitude argument within the expected range, the error is no longer returned:

SELECT ST_GeoHash(180,30,15);
+-----------------------+
| ST_GeoHash(180,30,15) |
+-----------------------+
| xvrfxvrfxvrfxvr       |
+-----------------------+

This page is licensed: CC BY-SA / Gnu FDL

Error 3049: Overflow error error

Error Code
SQLSTATE
Error
Description

3049

ER_STD_OVERFLOW_ERROR

Overflow error error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3050: Range error

Error Code
SQLSTATE
Error
Description

3050

ER_STD_RANGE_ERROR

Range error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3051: Underflow error

Error Code
SQLSTATE
Error
Description

3051

ER_STD_UNDERFLOW_ERROR

Underflow error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3052: Logic error

Error Code
SQLSTATE
Error
Description

3052

ER_STD_LOGIC_ERROR

Logic error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3053: Runtime error

Error Code
SQLSTATE
Error
Description

3053

ER_STD_RUNTIME_ERROR

Runtime error: %-.256s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3054: Unknown exception

Error Code
SQLSTATE
Error
Description

3054

ER_STD_UNKNOWN_EXCEPTION

Unknown exception: %-.384s in function %s.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3055: Geometry byte string must be little endian

Error Code
SQLSTATE
Error
Description

3055

ER_GIS_DATA_WRONG_ENDIANESS

Geometry byte string must be little endian.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3056: The password provided for the replication user exceeds the maximum length of 32 characte

Error Code
SQLSTATE
Error
Description

3056

ER_CHANGE_MASTER_PASSWORD_LENGTH

The password provided for the replication user exceeds the maximum length of 32 characters

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3057: Incorrect user-level lock name

Error Code
SQLSTATE
Error
Description

3057

42000

ER_USER_LOCK_WRONG_NAME

Incorrect user-level lock name '%-.192s'.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3058: Deadlock found when trying to get user-level lock

Error Code
SQLSTATE
Error
Description

3058

ER_USER_LOCK_DEADLOCK

Deadlock found when trying to get user-level lock; try rolling back transaction/releasing locks and restarting lock acquisition.

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3059: REPLACE cannot be executed as it requires deleting rows that are not in the view

Error Code
SQLSTATE
Error
Description

3059

ER_REPLACE_INACCESSIBLE_ROWS

REPLACE cannot be executed as it requires deleting rows that are not in the view

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL

Error 3060: Do not support online operation on table with GIS index

Error Code
SQLSTATE
Error
Description

3060

ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS

Do not support online operation on table with GIS index

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

This page is licensed: CC BY-SA / Gnu FDL