All pages
Powered by GitBook
Couldn't generate the PDF for 101 pages, generation stopped at 100.
Extend with 50 more pages.
1 of 100

MariaDB Error Codes 4000 to 4099

Error 4000: COM_MULTI can't return a result set in the given context

Error Code
SQLSTATE
Error
Description

4000

0A000

ER_COMMULTI_BADCONTEXT

COM_MULTI can't return a result set in the given context

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 4001: Command is not allowed for COM_MULTI

Error Code
SQLSTATE
Error
Description

4001

ER_BAD_COMMAND_IN_MULTI

Command '%s' is not allowed for COM_MULTI

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 4002: WITH column list and SELECT field list have different column counts

Error Code
SQLSTATE
Error
Description

4002

ER_WITH_COL_WRONG_LIST

WITH column list and SELECT field list have different column counts

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 4003: Too many WITH elements in WITH clause

Error Code
SQLSTATE
Error
Description

4003

ER_TOO_MANY_DEFINITIONS_IN_WITH_CLAUSE

Too many WITH elements in WITH clause

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 4004: Duplicate query name in WITH clause

Error Code
SQLSTATE
Error
Description

4004

ER_DUP_QUERY_NAME

Duplicate query name %`-.64s in WITH clause

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 4005: No anchors for recursive WITH element

Error Code
SQLSTATE
Error
Description

4005

ER_RECURSIVE_WITHOUT_ANCHORS

No anchors for recursive WITH element '%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 4006: Unacceptable mutual recursion with anchored table

Error Code
SQLSTATE
Error
Description

4006

ER_UNACCEPTABLE_MUTUAL_RECURSION

Unacceptable mutual recursion with anchored table '%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 4007: Reference to recursive WITH table in materialized derived

Error Code
SQLSTATE
Error
Description

4007

ER_REF_TO_RECURSIVE_WITH_TABLE_IN_DERIVED

Reference to recursive WITH table '%s' in materialized derived

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 4008: Restrictions imposed on recursive definitions are violated for table

Error Code
SQLSTATE
Error
Description

4008

ER_NOT_STANDARD_COMPLIANT_RECURSIVE

Restrictions imposed on recursive definitions are violated for table '%s'"R_WRONG_WINDOW_SPEC_NAME

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 4009: Window specification with name is not defined

Error Code
SQLSTATE
Error
Description

4009

ER_WRONG_WINDOW_SPEC_NAME

Window specification with name '%s' is not defined

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 4010: Multiple window specifications with the same name

Error Code
SQLSTATE
Error
Description

4010

ER_DUP_WINDOW_NAME

Multiple window specifications with the same name '%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 4011: Window specification referencing another one cannot contain partition list

Error Code
SQLSTATE
Error
Description

4011

ER_PARTITION_LIST_IN_REFERENCING_WINDOW_SPEC

Window specification referencing another one '%s' cannot contain partition list

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 4012: Referenced window specification already contains order list

Error Code
SQLSTATE
Error
Description

4012

ER_ORDER_LIST_IN_REFERENCING_WINDOW_SPEC

Referenced window specification '%s' already contains order list

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 4013: Referenced window specification cannot contain window frame

Error Code
SQLSTATE
Error
Description

4013

ER_WINDOW_FRAME_IN_REFERENCED_WINDOW_SPEC

Referenced window specification '%s' cannot contain window frame

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 4014: Unacceptable combination of window frame bound specifications

Error Code
SQLSTATE
Error
Description

4014

ER_BAD_COMBINATION_OF_WINDOW_FRAME_BOUND_SPECS

Unacceptable combination of window frame bound specifications

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 4015: Window function is allowed only in SELECT list and ORDER BY clause

Error Code
SQLSTATE
Error
Description

4015

ER_WRONG_PLACEMENT_OF_WINDOW_FUNCTION

Window function is allowed only in SELECT list and ORDER BY clause

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 4016: Window function is not allowed in window specification

Error Code
SQLSTATE
Error
Description

4016

ER_WINDOW_FUNCTION_IN_WINDOW_SPEC

Window function is not allowed in window specification

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 4017: Window frame is not allowed with

Error Code
SQLSTATE
Error
Description

4017

ER_NOT_ALLOWED_WINDOW_FRAME

Window frame is not allowed with '%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 4018: No order list in window specification for

Error Code
SQLSTATE
Error
Description

4018

ER_NO_ORDER_LIST_IN_WINDOW_SPEC

No order list in window specification for '%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 4019: RANGE-type frame requires ORDER BY clause with single sort key

Error Code
SQLSTATE
Error
Description

4019

ER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY

RANGE-type frame requires ORDER BY clause with single sort key

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 4020: Integer is required for ROWS-type frame

Error Code
SQLSTATE
Error
Description

4020

ER_WRONG_TYPE_FOR_ROWS_FRAME

Integer is required for ROWS-type frame

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 4021: Numeric datatype is required for RANGE-type frame

Error Code
SQLSTATE
Error
Description

4021

ER_WRONG_TYPE_FOR_RANGE_FRAME

Numeric datatype is required for RANGE-type frame

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 4022: Frame exclusion is not supported yet

Error Code
SQLSTATE
Error
Description

4022

ER_FRAME_EXCLUSION_NOT_SUPPORTED

Frame exclusion is not supported yet

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 4023: This window function may not have a window frame

Error Code
SQLSTATE
Error
Description

4023

ER_WINDOW_FUNCTION_DONT_HAVE_FRAME

This window function may not have a window frame

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 4024: Argument of NTILE must be greater than 0

Error Code
SQLSTATE
Error
Description

4024

ER_INVALID_NTILE_ARGUMENT

Argument of NTILE must be greater than 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 4025: CONSTRAINT failed for

Error Code
SQLSTATE
Error
Description

4025

23000

ER_CONSTRAINT_FAILED

CONSTRAINT %s failed for %-.192s.%`-.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 4026: Expression in the clause is too big

Error Code
SQLSTATE
Error
Description

4026

ER_EXPRESSION_IS_TOO_BIG

Expression in the %s clause is too big

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 4027: Got an error evaluating stored expression

Error Code
SQLSTATE
Error
Description

4027

ER_ERROR_EVALUATING_EXPRESSION

Got an error evaluating stored expression %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 4028: Got an error when calculating default value for

Error Code
SQLSTATE
Error
Description

4028

ER_CALCULATING_DEFAULT_VALUE

Got an error when calculating default value for %`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 4029: Expression for field is referring to uninitialized field

Error Code
SQLSTATE
Error
Description

4029

ER_EXPRESSION_REFERS_TO_UNINIT_FIELD

Expression for field %-.64s is referring to uninitialized field %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 4030: Only one DEFAULT partition allowed

Error Code
SQLSTATE
Error
Description

4030

ER_PARTITION_DEFAULT_ERROR

Only one DEFAULT partition allowed

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 4031: Referenced trigger for the given action time and event type does not exist

Error Code
SQLSTATE
Error
Description

4031

ER_REFERENCED_TRG_DOES_NOT_EXIST

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 4032: Default/ignore value is not supported for such parameter usage

Error Code
SQLSTATE
Error
Description

4032

ER_INVALID_DEFAULT_PARAM

Default/ignore value is not supported for such parameter usage

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 4033: Only row based replication supported for bulk operations

Error Code
SQLSTATE
Error
Description

4033

ER_BINLOG_NON_SUPPORTED_BULK

Only row based replication supported for bulk operations

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 4034: Uncompress the compressed binlog failed

Error Code
SQLSTATE
Error
Description

4034

ER_BINLOG_UNCOMPRESS_ERROR

Uncompress the compressed binlog failed

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 4035: Broken JSON string in argument to function at position

Error Code
SQLSTATE
Error
Description

4035

ER_JSON_BAD_CHR

Broken JSON string in argument %d to function '%s' at position %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 4036: Character disallowed in JSON in argument to function at position

Error Code
SQLSTATE
Error
Description

4036

ER_JSON_NOT_JSON_CHR

Character disallowed in JSON in argument %d to function '%s' at position %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 4037: Unexpected end of JSON text in argument to function

Error Code
SQLSTATE
Error
Description

4037

ER_JSON_EOS

Unexpected end of JSON text in argument %d 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 4038: Syntax error in JSON text in argument to function at position

Error Code
SQLSTATE
Error
Description

4038

ER_JSON_SYNTAX

Syntax error in JSON text in argument %d to function '%s' at position %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 4039: Incorrect escaping in JSON text in argument to function at position

Error Code
SQLSTATE
Error
Description

4039

ER_JSON_ESCAPING

Incorrect escaping in JSON text in argument %d to function '%s' at position %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 4040: Limit on JSON nested strucures depth is reached in argument to function at position

Error Code
SQLSTATE
Error
Description

4040

ER_JSON_DEPTH

Limit of %d on JSON nested strucures depth is reached in argument %d to function '%s' at position %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 4041: Unexpected end of JSON path in argument to function

Error Code
SQLSTATE
Error
Description

4041

ER_JSON_PATH_EOS

Unexpected end of JSON path in argument %d 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 4042: Syntax error in JSON path in argument to function at position

Error Code
SQLSTATE
Error
Description

4042

ER_JSON_PATH_SYNTAX

Syntax error in JSON path in argument %d to function '%s' at position %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 4043: Limit on JSON path depth is reached in argument to function at position

Error Code
SQLSTATE
Error
Description

4043

ER_JSON_PATH_DEPTH

Limit of %d on JSON path depth is reached in argument %d to function '%s' at position %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 4044: Wildcards in JSON path not allowed in argument to function

Error Code
SQLSTATE
Error
Description

4044

ER_JSON_PATH_NO_WILDCARD

Wildcards in JSON path not allowed in argument %d 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 4045: JSON path should end with an array identifier in argument to function

Error Code
SQLSTATE
Error
Description

4045

ER_JSON_PATH_ARRAY

JSON path should end with an array identifier in argument %d 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 4046: Argument 2 to function must be "one" or "all".

Error Code
SQLSTATE
Error
Description

4046

ER_JSON_ONE_OR_ALL

Argument 2 to function '%s' must be "one" or "all".

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 4047: CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

Error Code
SQLSTATE
Error
Description

4047

ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE

CREATE TEMPORARY TABLE is not allowed with ROW_FORMAT=COMPRESSED or KEY_BLOCK_SIZE.

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 4048: Incorrect GeoJSON format specified for st_geomfromgeojson function

Error Code
SQLSTATE
Error
Description

4048

ER_GEOJSON_INCORRECT

Incorrect GeoJSON format specified for st_geomfromgeojson function.

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 4049: Incorrect GeoJSON format - too few points for linestring specified

Error Code
SQLSTATE
Error
Description

4049

ER_GEOJSON_TOO_FEW_POINTS

Incorrect GeoJSON format - too few points for linestring specified.

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 4050: Incorrect GeoJSON format - polygon not closed

Error Code
SQLSTATE
Error
Description

4050

ER_GEOJSON_NOT_CLOSED

Incorrect GeoJSON format - polygon not closed.

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 4051: Path expression '$' is not allowed in argument to function

Error Code
SQLSTATE
Error
Description

4051

ER_JSON_PATH_EMPTY

Path expression '$' is not allowed in argument %d 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 4052: A slave with the same server_uuid/server_id as this slave has connected to the master

Error Code
SQLSTATE
Error
Description

4052

ER_SLAVE_SAME_ID

A slave with the same server_uuid/server_id as this slave has connected to the master

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 4053: Flashback does not support

Error Code
SQLSTATE
Error
Description

4053

ER_FLASHBACK_NOT_SUPPORTED

Flashback does not support %s %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 4054: Keys are out order during bulk load

Error Code
SQLSTATE
Error
Description

4054

ER_KEYS_OUT_OF_ORDER

Keys are out order during bulk load

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 4055: Bulk load rows overlap existing rows

Error Code
SQLSTATE
Error
Description

4055

ER_OVERLAPPING_KEYS

Bulk load rows overlap existing rows

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 4056: Can't execute updates on master with binlog_format != ROW

Error Code
SQLSTATE
Error
Description

4056

ER_REQUIRE_ROW_BINLOG_FORMAT

Can't execute updates on master with binlog_format != ROW.

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 4057: MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels

Error Code
SQLSTATE
Error
Description

4057

ER_ISOLATION_MODE_NOT_SUPPORTED

MyRocks supports only READ COMMITTED and REPEATABLE READ isolation levels. Please change from current isolation level %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 4058: When unique checking is disabled in MyRocks, INSERT,UPDATE,LOAD statements with clauses

Error Code
SQLSTATE
Error
Description

4058

ER_ON_DUPLICATE_DISABLED

When unique checking is disabled in MyRocks, INSERT,UPDATE,LOAD statements with clauses that update or replace the key (i.e. INSERT ON DUPLICATE KEY UPDATE, REPLACE) are not allowed. 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 4059: Can't execute updates when you started a transaction with START TRANSACTION WITH CONSIST

Error Code
SQLSTATE
Error
Description

4059

ER_UPDATES_WITH_CONSISTENT_SNAPSHOT

Can't execute updates when you started a transaction with START TRANSACTION WITH CONSISTENT [ROCKSDB] SNAPSHOT.

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 4060: This transaction was rolled back and cannot be committed. Only supported operation is to

Error Code
SQLSTATE
Error
Description

4060

ER_ROLLBACK_ONLY

This transaction was rolled back and cannot be committed. Only supported operation is to roll it back, so all pending changes will be discarded. Please restart another transaction.

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 4061: MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows

Error Code
SQLSTATE
Error
Description

4061

ER_ROLLBACK_TO_SAVEPOINT

MyRocks currently does not support ROLLBACK TO SAVEPOINT if modifying rows.

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 4062: Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT

Error Code
SQLSTATE
Error
Description

4062

ER_ISOLATION_LEVEL_WITH_CONSISTENT_SNAPSHOT

Only REPEATABLE READ isolation level is supported for START TRANSACTION WITH CONSISTENT SNAPSHOT in RocksDB Storage Engine.

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 4063: Unsupported collation on string indexed column

Error Code
SQLSTATE
Error
Description

4063

ER_UNSUPPORTED_COLLATION

Unsupported collation on string indexed column %s.%s Use binary collation (%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 4064: Table '%s' does not exist, but metadata information exists inside MyRocks. This is a sig

Error Code
SQLSTATE
Error
Description

4064

ER_METADATA_INCONSISTENCY

Table '%s' does not exist, but metadata information exists inside MyRocks. This is a sign of data inconsistency. Please check if '%s.frm' exists, and try to restore it if it 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 4065: Column family flag is different from an existing flag

Error Code
SQLSTATE
Error
Description

4065

ER_CF_DIFFERENT

Column family ('%s') flag (%d) is different from an existing flag (%d). Assign a new CF flag, or do not change existing CF flag.

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 4066: TTL duration in MyRocks must be an unsigned non-null 64-bit integer

Error Code
SQLSTATE
Error
Description

4066

ER_RDB_TTL_DURATION_FORMAT

TTL duration (%s) in MyRocks must be an unsigned non-null 64-bit integer.

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 4067: Status error received from RocksDB

Error Code
SQLSTATE
Error
Description

4067

ER_RDB_STATUS_GENERAL

Status error %d received from RocksDB: %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 4068: Status error received from RocksDB

Error Code
SQLSTATE
Error
Description

4068

ER_RDB_STATUS_MSG

%s, Status error %d received from RocksDB: %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 4069: TTL support is currently disabled when table has a hidden PK

Error Code
SQLSTATE
Error
Description

4069

ER_RDB_TTL_UNSUPPORTED

TTL support is currently disabled when table has a hidden PK.

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 4070: TTL column in MyRocks must be an unsigned non-null 64-bit integer, exist inside the tabl

Error Code
SQLSTATE
Error
Description

4070

ER_RDB_TTL_COL_FORMAT

TTL column (%s) in MyRocks must be an unsigned non-null 64-bit integer, exist inside the table, and have an accompanying ttl duration.

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 4071: The per-index column family option has been deprecated

Error Code
SQLSTATE
Error
Description

4071

ER_PER_INDEX_CF_DEPRECATED

The per-index column family option has been deprecated

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 4072: MyRocks failed creating new key definitions during alter

Error Code
SQLSTATE
Error
Description

4072

ER_KEY_CREATE_DURING_ALTER

MyRocks failed creating new key definitions during alter.

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 4073: MyRocks failed populating secondary key during alter

Error Code
SQLSTATE
Error
Description

4073

ER_SK_POPULATE_DURING_ALTER

MyRocks failed populating secondary key during alter.

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 4074: Window functions can not be used as arguments to group functions

Error Code
SQLSTATE
Error
Description

4074

ER_SUM_FUNC_WITH_WINDOW_FUNC_AS_ARG

Window functions can not be used as arguments to group functions.

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 4075: OK packet too large

Error Code
SQLSTATE
Error
Description

4075

ER_NET_OK_PACKET_TOO_LARGE

OK packet too large

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 4076: Incorrect GeoJSON format - empty 'coordinates' array

Error Code
SQLSTATE
Error
Description

4076

ER_GEOJSON_EMPTY_COORDINATES

Incorrect GeoJSON format - empty 'coordinates' array.

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 4077: MyRocks doesn't currently support collations with "No pad" attribute

Error Code
SQLSTATE
Error
Description

4077

ER_MYROCKS_CANT_NOPAD_COLLATION

MyRocks doesn't currently support collations with "No pad" 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 4078: Illegal parameter data types for operation

Error Code
SQLSTATE
Error
Description

4078

ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION

Illegal parameter data types %s and %s for operation '%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 4079: Illegal parameter data type for operation

Error Code
SQLSTATE
Error
Description

4079

ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION

Illegal parameter data type %s for operation '%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 4080: Incorrect parameter count to cursor

Error Code
SQLSTATE
Error
Description

4080

ER_WRONG_PARAMCOUNT_TO_CURSOR

Incorrect parameter count to cursor '%-.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 4081: Unknown structured system variable or ROW routine variable

Error Code
SQLSTATE
Error
Description

4081

ER_UNKNOWN_STRUCTURED_VARIABLE

Unknown structured system variable or ROW routine variable '%-.*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 4082: Row variable does not have a field

Error Code
SQLSTATE
Error
Description

4082

ER_ROW_VARIABLE_DOES_NOT_HAVE_FIELD

Row variable '%-.192s' does not have a field '%-.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 4083: END identifier does not match

Error Code
SQLSTATE
Error
Description

4083

ER_END_IDENTIFIER_DOES_NOT_MATCH

END identifier '%-.192s' does not match '%-.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 4084: Sequence has run out

Error Code
SQLSTATE
Error
Description

4084

ER_SEQUENCE_RUN_OUT

Sequence '%-.64s.%-.64s' has run out

Possible Causes and Solutions

Sequence has Completed Normally

In a sequence, once the MAXVALUE has been reached, and the CYCLE argument has not been used, further attempts to set the next value will fail:

CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=2;

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          1 |
+------------+

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          2 |
+------------+

SELECT NEXTVAL(s);
ERROR 4084 (HY000): Sequence 'test.s' has run out

This is usually intended behaviour, but there are a number of ways to prevent this:

Choose a larger MAXVALUE

Prior to MariaDB 11.5, this defaulted to the maximum, BIGINT. From MariaDB 11.5, it can be BIGINT UNSIGNED

CREATE OR REPLACE SEQUENCE s AS BIGINT UNSIGNED START WITH 1 INCREMENT BY 1;

SELECT SEQUENCE_NAME,MAXIMUM_VALUE FROM INFORMATION_SCHEMA.SEQUENCES\G
*************************** 1. row ***************************
SEQUENCE_NAME: s
MAXIMUM_VALUE: 18446744073709551614

Cycling

If re-use sequence values is not a problem, you can cycle back to the start once the maximum value has been reached:

CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=2 CYCLE;

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          1 |
+------------+

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          2 |
+------------+

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          1 |
+------------+

Sequence has Completed Due to Cache

The underlying table is only updated with a new sequence value the first time the value is created, and then each time the cache expires. By default the cache is set to 1000. For example:

CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=10 CACHE=5;

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          1 |
+------------+

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          2 |
+------------+

FLUSH TABLES s;

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          6 |
+------------+

FLUSH TABLES s;

SELECT NEXTVAL(s);
ERROR 4084 (HY000): Sequence 'test.s' has run out

This behaviour can be prevented by setting the cache to zero, so that the value stored in the underlying table is written each time:

CREATE OR REPLACE SEQUENCE s START WITH 1 INCREMENT BY 1 MAXVALUE=10 CACHE=0;

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          1 |
+------------+

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          2 |
+------------+

FLUSH TABLES s;

SELECT NEXTVAL(s);
+------------+
| NEXTVAL(s) |
+------------+
|          3 |
+------------+

See Also

  • Sequence Overview

  • CREATE SEQUENCE

  • ALTER SEQUENCE

  • DROP SEQUENCE

  • NEXT VALUE FOR

  • PREVIOUS VALUE FOR

  • SETVAL(). Set next value for the sequence.

  • AUTO INCREMENT

  • SHOW CREATE SEQUENCE

  • Information Schema SEQUENCES Table

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

Error 4085: Sequence values are conflicting

Error Code
SQLSTATE
Error
Description

4085

ER_SEQUENCE_INVALID_DATA

Sequence '%-.64s.%-.64s' values are conflicting

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 4086: Sequence table structure is invalid

Error Code
SQLSTATE
Error
Description

4086

ER_SEQUENCE_INVALID_TABLE_STRUCTURE

Sequence '%-.64s.%-.64s' table structure is invalid (%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 4087: Sequence access error

Error Code
SQLSTATE
Error
Description

4087

ER_SEQUENCE_ACCESS_ERROR

Sequence '%-.64s.%-.64s' access 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 4088: Sequences requires binlog_format mixed or row

Error Code
SQLSTATE
Error
Description

4088

ER_SEQUENCE_BINLOG_FORMAT

Sequences requires binlog_format mixed or row

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 4089: is not a SEQUENCE

Error Code
SQLSTATE
Error
Description

4089

ER_NOT_SEQUENCE

'%-.64s.%-.64s' is not a SEQUENCE

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 4090: is not a SEQUENCE

Error Code
SQLSTATE
Error
Description

4090

ER_NOT_SEQUENCE2

'%-.192s' is not a SEQUENCE

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 4091: Unknown SEQUENCE

Error Code
SQLSTATE
Error
Description

4091

ER_UNKNOWN_SEQUENCES

Unknown SEQUENCE: '%-.300s'

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 4092: Unknown VIEW

Error Code
SQLSTATE
Error
Description

4092

ER_UNKNOWN_VIEW

Unknown VIEW: '%-.300s'

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 4093: Wrong INSERT into a SEQUENCE. One can only do single table INSERT into a sequence object

Error Code
SQLSTATE
Error
Description

4093

ER_WRONG_INSERT_INTO_SEQUENCE

Wrong INSERT into a SEQUENCE. One can only do single table INSERT into a sequence object (like with mysqldump). If you want to change the SEQUENCE, use ALTER SEQUENCE 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 4094: At line in

Error Code
SQLSTATE
Error
Description

4094

ER_SP_STACK_TRACE

At line %u in %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 4095: Subroutine is declared in the package specification but is not defined in the package bo

Error Code
SQLSTATE
Error
Description

4095

ER_PACKAGE_ROUTINE_IN_SPEC_NOT_DEFINED_IN_BODY

Subroutine '%-.192s' is declared in the package specification but is not defined in the package body

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 4096: Subroutine has a forward declaration but is not defined

Error Code
SQLSTATE
Error
Description

4096

ER_PACKAGE_ROUTINE_FORWARD_DECLARATION_NOT_DEFINED

Subroutine '%-.192s' has a forward declaration but is not defined

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 4097: Compressed column can't be used in key specification

Error Code
SQLSTATE
Error
Description

4097

ER_COMPRESSED_COLUMN_USED_AS_KEY

Compressed column '%-.192s' can't be used in key specification

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 4098: Unknown compression method

Error Code
SQLSTATE
Error
Description

4098

ER_UNKNOWN_COMPRESSION_METHOD

Unknown compression method: %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