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

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

Loading...

MariaDB Error Codes 1400 to 1499

Error 1413: Duplicate handler declared in the same block

Error Code
SQLSTATE
Error
Description

1413

42000

ER_SP_DUP_HANDLER

Duplicate handler declared in the same block

Possible Causes and Solutions

Error 1400: XAER_OUTSIDE: Some work is done outside global transaction

Error Code
SQLSTATE
Error
Description

1400

XAE09

ER_XAER_OUTSIDE

XAER_OUTSIDE: Some work is done outside global transaction

Possible Causes and Solutions

Error 1406: Data too long for column at row

Error Code
SQLSTATE
Error
Description

1406

22001

ER_DATA_TOO_LONG

Data too long for column '%s' at row %ld

Possible Causes and Solutions

Error 1401: XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consist

Error Code
SQLSTATE
Error
Description

1401

XAE03

ER_XAER_RMERR

XAER_RMERR: Fatal error occurred in the transaction branch - check your data for consistency

Possible Causes and Solutions

Error 1410: You are not allowed to create a user with GRANT

Error Code
SQLSTATE
Error
Description

1410

42000

ER_CANT_CREATE_USER_WITH_GRANT

You are not allowed to create a user with GRANT

Possible Causes and Solutions

Error 1420: You can't execute a prepared statement which has an open cursor associated with it

Error Code
SQLSTATE
Error
Description

1420

HY000

ER_EXEC_STMT_WITH_OPEN_CURSOR

You can't execute a prepared statement which has an open cursor associated with it. Reset the statement to re-execute it.

Possible Causes and Solutions

Error 1402: XA_RBROLLBACK: Transaction branch was rolled back

Error Code
SQLSTATE
Error
Description

1402

XA100

ER_XA_RBROLLBACK

XA_RBROLLBACK: Transaction branch was rolled back

Possible Causes and Solutions

Error 1421: The statement has no open cursor

Error Code
SQLSTATE
Error
Description

1421

HY000

ER_STMT_HAS_NO_OPEN_CURSOR

The statement (%lu) has no open cursor.

Possible Causes and Solutions

Error 1405: Failed to revoke all privileges to dropped routine

Error Code
SQLSTATE
Error
Description

1405

HY000

ER_PROC_AUTO_REVOKE_FAIL

Failed to revoke all privileges to dropped routine

Possible Causes and Solutions

Error 1411: Incorrect value for function

Error Code
SQLSTATE
Error
Description

1411

HY000

ER_WRONG_VALUE_FOR_TYPE

Incorrect %s value: '%s' for function %s

Possible Causes and Solutions

Error 1409: Can't load value from file with fixed size rows to variable

Error Code
SQLSTATE
Error
Description

1409

HY000

ER_LOAD_FROM_FIXED_SIZE_ROWS_TO_VAR

Can't load value from file with fixed size rows to variable

Possible Causes and Solutions

Error 1408: ready for connections. Version: socket: port:

Error Code
SQLSTATE
Error
Description

1408

HY000

ER_STARTUP

%s: ready for connections. Version: '%s' socket: '%s' port: %d %s

Possible Causes and Solutions

Error 1427: For float(M,D, double(M,D or decimal(M,D, M must be >= D

Error Code
SQLSTATE
Error
Description

1427

42000

ER_M_BIGGER_THAN_D

For float(M,D, double(M,D or decimal(M,D, M must be >= D (column '%s').

Possible Causes and Solutions

Error 1403: There is no such grant defined for user on host on routine

Error Code
SQLSTATE
Error
Description

1403

42000

ER_NONEXISTING_PROC_GRANT

There is no such grant defined for user '%s' on host '%s' on routine '%s'

Possible Causes and Solutions

Error 1407: Bad SQLSTATE

Error Code
SQLSTATE
Error
Description

1407

42000

ER_SP_BAD_SQLSTATE

Bad SQLSTATE: '%s'

Possible Causes and Solutions

Error 1429: Unable to connect to foreign data source

Error Code
SQLSTATE
Error
Description

Error 1412: Table definition has changed, please retry transaction

Error Code
SQLSTATE
Error
Description

Error 1432: Can't create federated table. The data source connection string is not in the correct fo

Error Code
SQLSTATE
Error
Description

Error 1426: Too big precision specified for column

Error Code
SQLSTATE
Error
Description

Error 1437: Routine body is too long

Error Code
SQLSTATE
Error
Description

Error 1428: You can't combine write-locking of system tables with other tables or lock types

Error Code
SQLSTATE
Error
Description

Error 1418: This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration an

Error Code
SQLSTATE
Error
Description

Error 1422: Explicit or implicit commit is not allowed in stored function or trigger

Error Code
SQLSTATE
Error
Description

Error 1430: There was a problem processing the query on the foreign data source

Error Code
SQLSTATE
Error
Description

Error 1451: Cannot delete or update a parent row: a foreign key constraint fails

Error Code
SQLSTATE
Error
Description

Error 1455: has an old format, you should re-create the object(s)

Error Code
SQLSTATE
Error
Description

Possible Causes and Solutions

1429

HY000

ER_CONNECT_TO_FOREIGN_DATA_SOURCE

Unable to connect to foreign data source: %s

Possible Causes and Solutions

1412

HY000

ER_TABLE_DEF_CHANGED

Table definition has changed, please retry transaction

Possible Causes and Solutions

1432

HY000

ER_FOREIGN_DATA_STRING_INVALID_CANT_CREATE

Can't create federated table. The data source connection string '%s' is not in the correct format

Possible Causes and Solutions

1426

42000

ER_TOO_BIG_PRECISION

Too big precision %d specified for column '%s'. Maximum is %lu.

Possible Causes and Solutions

1437

42000

ER_TOO_LONG_BODY

Routine body for '%s' is too long

Possible Causes and Solutions

1428

HY000

ER_WRONG_LOCK_OF_SYSTEM_TABLE

You can't combine write-locking of system tables with other tables or lock types

Possible Causes and Solutions

1418

HY000

ER_BINLOG_UNSAFE_ROUTINE

This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

Possible Causes and Solutions

1422

HY000

ER_COMMIT_NOT_ALLOWED_IN_SF_OR_TRG

Explicit or implicit commit is not allowed in stored function or trigger.

Possible Causes and Solutions

1430

HY000

ER_QUERY_ON_FOREIGN_DATA_SOURCE

There was a problem processing the query on the foreign data source. Data source error: %s

Possible Causes and Solutions

1451

23000

ER_ROW_IS_REFERENCED_2

Cannot delete or update a parent row: a foreign key constraint fails (%s)

Possible Causes and Solutions

1455

HY000

ER_OLD_FILE_FORMAT

'%s' has an old format, you should re-create the '%s' object(s)

Error 1439: Display width out of range for column

Error Code
SQLSTATE
Error
Description

1439

42000

ER_TOO_BIG_DISPLAYWIDTH

Display width out of range for column '%s' (max = %lu)

Possible Causes and Solutions

Error 1433: The data source connection string is not in the correct format

Error Code
SQLSTATE
Error
Description

1433

HY000

ER_FOREIGN_DATA_STRING_INVALID

The data source connection string '%s' is not in the correct format

Possible Causes and Solutions

Error 1443: The definition of table prevents operation on table

Error Code
SQLSTATE
Error
Description

1443

HY000

ER_VIEW_PREVENT_UPDATE

The definition of table '%s' prevents operation %s on table '%s'.

Possible Causes and Solutions

Error 1445: Not allowed to set autocommit from a stored function or trigger

Error Code
SQLSTATE
Error
Description

1445

HY000

ER_SP_CANT_SET_AUTOCOMMIT

Not allowed to set autocommit from a stored function or trigger

Possible Causes and Solutions

Error 1457: Failed to load routine

Error Code
SQLSTATE
Error
Description

1457

HY000

ER_SP_PROC_TABLE_CORRUPT

Failed to load routine %s. The table mysql.proc is missing, corrupt, or contains bad data (internal code %d)

Possible Causes and Solutions

Error 1440: XAER_DUPID: The XID already exists

Error Code
SQLSTATE
Error
Description

1440

XAE08

ER_XAER_DUPID

XAER_DUPID: The XID already exists

Possible Causes and Solutions

Error 1441: Datetime function: field overflow

Error Code
SQLSTATE
Error
Description

1441

22008

ER_DATETIME_FUNCTION_OVERFLOW

Datetime function: %s field overflow

Possible Causes and Solutions

Error 1465: Triggers can not be created on system tables

Error Code
SQLSTATE
Error
Description

1465

HY000

ER_NO_TRIGGERS_ON_SYSTEM_SCHEMA

Triggers can not be created on system tables

Possible Causes and Solutions

Error 1453: Variable must be quoted with ..., or renamed

Error Code
SQLSTATE
Error
Description

1453

42000

ER_SP_BAD_VAR_SHADOW

Variable '%s' must be quoted with ..., or renamed

Possible Causes and Solutions

Error 1446: Definer is not fully qualified

Error Code
SQLSTATE
Error
Description

1446

HY000

ER_MALFORMED_DEFINER

Definer is not fully qualified

Possible Causes and Solutions

Error 1466: Leading spaces are removed from name

Error Code
SQLSTATE
Error
Description

1466

HY000

ER_REMOVED_SPACES

Leading spaces are removed from name '%s'

Possible Causes and Solutions

Error 1419: You do not have the SUPER privilege and binary logging is enabled

Error Code
SQLSTATE
Error
Description

1419

HY000

ER_BINLOG_CREATE_ROUTINE_NEED_SUPER

You do not have the SUPER privilege and binary logging is enabled (you might want to use the less safe log_bin_trust_function_creators variable)

Possible Causes and Solutions

Error 1470: String is too long for (should be no longer than )

Error Code
SQLSTATE
Error
Description

1470

HY000

ER_WRONG_STRING_LENGTH

String '%s' is too long for %s (should be no longer than %d)

Possible Causes and Solutions

Error 1434: Can't create federated table. Foreign data src error

Error Code
SQLSTATE
Error
Description

1434

HY000

ER_CANT_CREATE_FEDERATED_TABLE

Can't create federated table. Foreign data src error: %s

Possible Causes and Solutions

Error 1438: Cannot drop default keycache

Error Code
SQLSTATE
Error
Description

1438

HY000

ER_WARN_CANT_DROP_DEFAULT_KEYCACHE

Cannot drop default keycache

Possible Causes and Solutions

Error 1459: Table upgrade required. Please do "REPAIR TABLE" or dump/reload to fix it!

Error Code
SQLSTATE
Error
Description

1459

HY000

ER_TABLE_NEEDS_UPGRADE

Table upgrade required. Please do "REPAIR TABLE %s" or dump/reload to fix it!

Possible Causes and Solutions

Error 1404: Failed to grant EXECUTE and ALTER ROUTINE privileges

Error Code
SQLSTATE
Error
Description

1404

HY000

ER_PROC_AUTO_GRANT_FAIL

Failed to grant EXECUTE and ALTER ROUTINE privileges

Possible Causes and Solutions

Error 1416: Cannot get geometry object from data you send to the GEOMETRY field

Error Code
SQLSTATE
Error
Description

1416

22003

ER_CANT_CREATE_GEOMETRY_OBJECT

Cannot get geometry object from data you send to the GEOMETRY field

Possible Causes and Solutions

Error 1494: VALUES value must be of same type as partition function

Error Code
SQLSTATE
Error
Description

1494

HY000

ER_INCONSISTENT_TYPE_OF_FUNCTIONS_ERROR

VALUES value must be of same type as partition function

Possible Causes and Solutions

Error 1485: Wrong number of subpartitions defined, mismatch with previous setting

Error Code
SQLSTATE
Error
Description

1485

HY000

ER_PARTITION_WRONG_NO_SUBPART_ERROR

Wrong number of subpartitions defined, mismatch with previous setting

Possible Causes and Solutions

Error 1458: Incorrect routine name

Error Code
SQLSTATE
Error
Description

1458

42000

ER_SP_WRONG_NAME

Incorrect routine name '%s'

Possible Causes and Solutions

Error 1449: The user specified as a definer does not exist

Error Code
SQLSTATE
Error
Description

1449

HY000

ER_NO_SUCH_USER

The user specified as a definer ('%s'@'%s') does not exist

Possible Causes and Solutions

Error 1460: AGGREGATE is not supported for stored functions

Error Code
SQLSTATE
Error
Description

1460

42000

ER_SP_NO_AGGREGATE

AGGREGATE is not supported for stored functions

Possible Causes and Solutions

Error 1456: Recursive limit (as set by the max_sp_recursion_depth variable) was exceeded for routine

Error Code
SQLSTATE
Error
Description

1456

HY000

ER_SP_RECURSION_LIMIT

Recursive limit %d (as set by the max_sp_recursion_depth variable) was exceeded for routine %s

Possible Causes and Solutions

Error 1476: The foreign server you are trying to create already exists

Error Code
SQLSTATE
Error
Description

1476

HY000

ER_FOREIGN_SERVER_EXISTS

The foreign server, %s, you are trying to create already exists.

Possible Causes and Solutions

Error 1472: Table is differently defined or of non-MyISAM type or doesn't exist

Error Code
SQLSTATE
Error
Description

1472

HY000

ER_ADMIN_WRONG_MRG_TABLE

Table '%s' is differently defined or of non-MyISAM type or doesn't exist

Possible Causes and Solutions

Error 1425: Too big scale specified for column

Error Code
SQLSTATE
Error
Description

1425

42000

ER_TOO_BIG_SCALE

Too big scale %d specified for column '%s'. Maximum is %lu.

Possible Causes and Solutions

Error 1414: OUT or INOUT argument for routine is not a variable or NEW pseudo-variable in BEFORE tri

Error Code
SQLSTATE
Error
Description

1414

42000

ER_SP_NOT_VAR_ARG

OUT or INOUT argument %d for routine %s is not a variable or NEW pseudo-variable in BEFORE trigger

Possible Causes and Solutions

Error 1435: Trigger in wrong schema

Error Code
SQLSTATE
Error
Description

1435

HY000

ER_TRG_IN_WRONG_SCHEMA

Trigger in wrong schema

Possible Causes and Solutions

Error 1492: For partitions each partition must be defined

Error Code
SQLSTATE
Error
Description

1492

HY000

ER_PARTITIONS_MUST_BE_DEFINED_ERROR

For %s partitions each partition must be defined

Possible Causes and Solutions

Error 1461: Can't create more than max_prepared_stmt_count statements

Error Code
SQLSTATE
Error
Description

1461

42000

ER_MAX_PREPARED_STMT_COUNT_REACHED

Can't create more than max_prepared_stmt_count statements (current value: %lu)

Possible Causes and Solutions

Error 1454: No definer attribute for trigger

Error Code
SQLSTATE
Error
Description

1454

HY000

ER_TRG_NO_DEFINER

No definer attribute for trigger '%s'.'%s'. The trigger will be activated under the authorization of the invoker, which may have insufficient privileges. Please recreate the trigger.

Possible Causes and Solutions

Error 1486: Constant/Random expression in (sub)partitioning function is not allowed

Error Code
SQLSTATE
Error
Description

1486

HY000

ER_CONST_EXPR_IN_PARTITION_FUNC_ERROR

Constant/Random expression in (sub)partitioning function is not allowed

Possible Causes and Solutions

Error 1481: MAXVALUE can only be used in last partition definition

Error Code
SQLSTATE
Error
Description

1481

HY000

ER_PARTITION_MAXVALUE_ERROR

MAXVALUE can only be used in last partition definition

Possible Causes and Solutions

Error 1469: host name

Error Code
SQLSTATE
Error
Description

1469

HY000

ER_HOSTNAME

host name

Possible Causes and Solutions

Error 1495: Multiple definition of same constant in list partitioning

Error Code
SQLSTATE
Error
Description

1495

HY000

ER_MULTIPLE_DEF_CONST_IN_LIST_PART_ERROR

Multiple definition of same constant in list partitioning

Possible Causes and Solutions

Error 1424: Recursive stored functions and triggers are not allowed.

Error Code
SQLSTATE
Error
Description

1424

HY000

ER_SP_NO_RECURSION

Recursive stored functions and triggers are not allowed.

Possible Causes and Solutions

Error 1468: user name

Error Code
SQLSTATE
Error
Description

1468

HY000

ER_USERNAME

user name

Possible Causes and Solutions

Error 1488: Field in list of fields for partition function not found in table

Error Code
SQLSTATE
Error
Description

1488

HY000

ER_FIELD_NOT_FOUND_PART_ERROR

Field in list of fields for partition function not found in table

Possible Causes and Solutions

Error 1452: Cannot add or update a child row: a foreign key constraint fails

Error Code
SQLSTATE
Error
Description

1452

23000

ER_NO_REFERENCED_ROW_2

Cannot add or update a child row: a foreign key constraint fails (%s)

Possible Causes and Solutions

Error 1493: VALUES LESS THAN value must be strictly increasing for each partition

Error Code
SQLSTATE
Error
Description

1493

HY000

ER_RANGE_NOT_INCREASING_ERROR

VALUES LESS THAN value must be strictly increasing for each partition

Possible Causes and Solutions

Error 1467: Failed to read auto-increment value from storage engine

Error Code
SQLSTATE
Error
Description

1467

HY000

ER_AUTOINC_READ_FAILED

Failed to read auto-increment value from storage engine

Possible Causes and Solutions

Error 1487: Expression in RANGE/LIST VALUES must be constant

Error Code
SQLSTATE
Error
Description

1487

HY000

ER_NO_CONST_EXPR_IN_RANGE_OR_LIST_ERROR

Expression in RANGE/LIST VALUES must be constant

Possible Causes and Solutions

Error 1431: The foreign data source you are trying to reference does not exist

Error Code
SQLSTATE
Error
Description

Error 1415: Not allowed to return a result set from

Error Code
SQLSTATE
Error
Description

Error 1448: You need the SUPER privilege for creation view with definer

MariaDB starting with

Error Code
SQLSTATE
Error
Description

MariaDB until

Error 1464: The used table type doesn't support SPATIAL indexes

Error Code
SQLSTATE
Error
Description

Error 1417: A routine failed and has neither NO SQL nor READS SQL DATA in its declaration

Error Code
SQLSTATE
Error
Description

Error 1463: Non-grouping field is used in clause

Error Code
SQLSTATE
Error
Description

Error 1462: contains view recursion

Error Code
SQLSTATE
Error
Description

Error 1471: The target table of the is not insertable-into

Error Code
SQLSTATE
Error
Description

Error 1483: Must define subpartitions on all partitions if on one partition

Error Code
SQLSTATE
Error
Description

Error 1473: Too high level of nesting for select

Error Code
SQLSTATE
Error
Description

Error 1482: Subpartitions can only be hash partitions and by key

Error Code
SQLSTATE
Error
Description

Error 1444: The prepared statement contains a stored routine call that refers to that same statement

Error Code
SQLSTATE
Error
Description

Error 1474: Name has become ''

Error Code
SQLSTATE
Error
Description

Error 1496: Partitioning can not be used stand-alone in query

Error Code
SQLSTATE
Error
Description

Error 1479: Syntax error: PARTITIONING requires definition of VALUES for each partition

Error Code
SQLSTATE
Error
Description

Error 1489: List of fields is only allowed in KEY partitions

Error Code
SQLSTATE
Error
Description

Error 1475: First character of the FIELDS TERMINATED string is ambiguous

Error Code
SQLSTATE
Error
Description

Error 1490: The partition info in the frm file is not consistent with what can be written into the f

Error Code
SQLSTATE
Error
Description

Error 1477: The foreign server name you are trying to reference does not exist. Data source error

Error Code
SQLSTATE
Error
Description

Error 1484: Wrong number of partitions defined, mismatch with previous setting

Error Code
SQLSTATE
Error
Description

Error 1491: The function returns the wrong type

Error Code
SQLSTATE
Error
Description

Error 1447: View has no definer information (old table format)

Error Code
SQLSTATE
Error
Description

Error 1480: Only PARTITIONING can use VALUES in partition definition

Error Code
SQLSTATE
Error
Description

Possible Causes and Solutions

1431

HY000

ER_FOREIGN_DATA_SOURCE_DOESNT_EXIST

The foreign data source you are trying to reference does not exist. Data source error: %s

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

Possible Causes and Solutions

1415

0A000

ER_SP_NO_RETSET

Not allowed to return a result set from a %s

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

Error Code
SQLSTATE
Error
Description

1448

HY000

ER_VIEW_OTHER_USER

You need the SUPER privilege for creation view with '%s'@'%s' definer

Possible Causes and Solutions

1931

ER_UNUSED_30

You should never see it.

10.11

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

Possible Causes and Solutions

1464

HY000

ER_TABLE_CANT_HANDLE_SPKEYS

The used table type doesn't support SPATIAL indexes

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

Possible Causes and Solutions

1417

HY000

ER_FAILED_ROUTINE_BREAK_BINLOG

A routine failed and has neither NO SQL nor READS SQL DATA in its declaration and binary logging is enabled; if non-transactional tables were updated, the binary log will miss their changes

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

Possible Causes and Solutions

1463

42000

ER_NON_GROUPING_FIELD_USED

Non-grouping field '%s' is used in %s clause

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

Possible Causes and Solutions

1462

HY000

ER_VIEW_RECURSIVE

%s.%s contains view recursion

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

Possible Causes and Solutions

1471

HY000

ER_NON_INSERTABLE_TABLE

The target table %s of the %s is not insertable-into

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

Possible Causes and Solutions

1483

HY000

ER_PARTITION_SUBPART_MIX_ERROR

Must define subpartitions on all partitions if on one partition

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

Possible Causes and Solutions

1473

HY000

ER_TOO_HIGH_LEVEL_OF_NESTING_FOR_SELECT

Too high level of nesting for select

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

Possible Causes and Solutions

1482

HY000

ER_PARTITION_SUBPARTITION_ERROR

Subpartitions can only be hash partitions and by key

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

Possible Causes and Solutions

1444

HY000

ER_PS_NO_RECURSION

The prepared statement contains a stored routine call that refers to that same statement. It's not allowed to execute a prepared statement in such a recursive manner

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

Possible Causes and Solutions

1474

HY000

ER_NAME_BECOMES_EMPTY

Name '%s' has become ''

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

Possible Causes and Solutions

1496

HY000

ER_PARTITION_ENTRY_ERROR

Partitioning can not be used stand-alone in query

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

Possible Causes and Solutions

1479

HY000

ER_PARTITION_REQUIRES_VALUES_ERROR

Syntax error: %s PARTITIONING requires definition of VALUES %s for each partition

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

Possible Causes and Solutions

1489

HY000

ER_LIST_OF_FIELDS_ONLY_IN_HASH_ERROR

List of fields is only allowed in KEY partitions

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

Possible Causes and Solutions

1475

HY000

ER_AMBIGUOUS_FIELD_TERM

First character of the FIELDS TERMINATED string is ambiguous; please use non-optional and non-empty FIELDS ENCLOSED BY

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

Possible Causes and Solutions

1490

HY000

ER_INCONSISTENT_PARTITION_INFO_ERROR

The partition info in the frm file is not consistent with what can be written into the frm file

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

Possible Causes and Solutions

1477

HY000

ER_FOREIGN_SERVER_DOESNT_EXIST

The foreign server name you are trying to reference does not exist. Data source error: %s

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

Possible Causes and Solutions

1484

HY000

ER_PARTITION_WRONG_NO_PART_ERROR

Wrong number of partitions defined, mismatch with previous setting

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

Possible Causes and Solutions

1491

HY000

ER_PARTITION_FUNC_NOT_ALLOWED_ERROR

The %s function returns the wrong type

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

Possible Causes and Solutions

1447

HY000

ER_VIEW_FRM_NO_USER

View '%s'.'%s' has no definer information (old table format). Current user is used as definer. Please recreate the view!

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

Possible Causes and Solutions

1480

HY000

ER_PARTITION_WRONG_VALUES_ERROR

Only %s PARTITIONING can use VALUES %s in partition definition

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

Error 1450: Changing schema from is not allowed.

Error Code
SQLSTATE
Error
Description

1450

HY000

ER_FORBID_SCHEMA_CHANGE

Changing schema from '%s' to '%s' is not allowed.

Possible Causes and Solutions

Error 1478: Table storage engine does not support the create option

Error Code
SQLSTATE
Error
Description

1478

HY000

ER_ILLEGAL_HA_CREATE_OPTION

Table storage engine '%s' does not support the create option '%s'

Possible Causes and Solutions

Error 1497: The mix of handlers in the partitions is not allowed in this version of MariaDB

Error Code
SQLSTATE
Error
Description

Error 1498: For the partitioned engine it is necessary to define all

Error Code
SQLSTATE
Error
Description

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Possible Causes and Solutions

1497

HY000

ER_MIX_HANDLER_ERROR

The mix of handlers in the partitions is not allowed in this version of MariaDB

Possible Causes and Solutions

1498

HY000

ER_PARTITION_NOT_DEFINED_ERROR

For the partitioned engine it is necessary to define all %s

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

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

This article doesn't currently contain any content.

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

This article doesn't currently contain any content.

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

Error 1442: Can't update table in stored function/trigger because it is already used by statement wh

Error Code
SQLSTATE
Error
Description

1442

HY000

ER_CANT_UPDATE_USED_TABLE_IN_SF_OR_TRG

Can't update table '%s' in stored function/trigger because it is already used by statement which invoked this stored function/trigger.

Possible Causes and Solutions

This article doesn't currently contain any content.

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

Error 1436: Thread stack overrun

Error Code
SQLSTATE
Error
Description

1436

HY000

ER_STACK_OVERRUN_NEED_MORE

Thread stack overrun: %ld bytes used of a %ld byte stack, and %ld bytes needed. Use 'mysqld --thread_stack=#' to specify a bigger stack.

Possible Causes and Solutions

This article doesn't currently contain any content.

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

Error 1423: Field of view underlying table doesn't have a default value

Error Code
SQLSTATE
Error
Description

1423

HY000

ER_NO_DEFAULT_FOR_VIEW_FIELD

Field of view '%s.%s' underlying table doesn't have a default value

Possible Causes and Solutions

This article doesn't currently contain any content.

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

You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
You can help!
11.0