MySQL Server Error Codes and Messages 1500 - 1549

Error: 1500 SQLSTATE: HY000 (ER_SUBPARTITION_ERROR)

Message: It is only possible to mix RANGE/LIST partitioning with HASH/KEY partitioning for subpartitioning

Error: 1501 SQLSTATE: HY000 (ER_CANT_CREATE_HANDLER_FILE)

Message: Failed to create specific handler file

Error: 1502 SQLSTATE: HY000 (ER_BLOB_FIELD_IN_PART_FUNC_ERROR)

Message: A BLOB field is not allowed in partition function

Error: 1503 SQLSTATE: HY000 (ER_UNIQUE_KEY_NEED_ALL_FIELDS_IN_PF)

Message: A %s must include all columns in the table's partitioning function

Error: 1504 SQLSTATE: HY000 (ER_NO_PARTS_ERROR)

Message: Number of %s = 0 is not an allowed value

Error: 1505 SQLSTATE: HY000 (ER_PARTITION_MGMT_ON_NONPARTITIONED)

Message: Partition management on a not partitioned table is not possible

Error: 1506 SQLSTATE: HY000 (ER_FOREIGN_KEY_ON_PARTITIONED)

Message: Foreign key clause is not yet supported in conjunction with partitioning

Error: 1507 SQLSTATE: HY000 (ER_DROP_PARTITION_NON_EXISTENT)

Message: Error in list of partitions to %s

Error: 1508 SQLSTATE: HY000 (ER_DROP_LAST_PARTITION)

Message: Cannot remove all partitions, use DROP TABLE instead

Error: 1509 SQLSTATE: HY000 (ER_COALESCE_ONLY_ON_HASH_PARTITION)

Message: COALESCE PARTITION can only be used on HASH/KEY partitions

Error: 1510 SQLSTATE: HY000 (ER_REORG_HASH_ONLY_ON_SAME_NO)

Message: REORGANIZE PARTITION can only be used to reorganize partitions not to change their numbers

Error: 1511 SQLSTATE: HY000 (ER_REORG_NO_PARAM_ERROR)

Message: REORGANIZE PARTITION without parameters can only be used on auto-partitioned tables using HASH PARTITIONs

Error: 1512 SQLSTATE: HY000 (ER_ONLY_ON_RANGE_LIST_PARTITION)

Message: %s PARTITION can only be used on RANGE/LIST partitions

Error: 1513 SQLSTATE: HY000 (ER_ADD_PARTITION_SUBPART_ERROR)

Message: Trying to Add partition(s) with wrong number of subpartitions

Error: 1514 SQLSTATE: HY000 (ER_ADD_PARTITION_NO_NEW_PARTITION)

Message: At least one partition must be added

Error: 1515 SQLSTATE: HY000 (ER_COALESCE_PARTITION_NO_PARTITION)

Message: At least one partition must be coalesced

Error: 1516 SQLSTATE: HY000 (ER_REORG_PARTITION_NOT_EXIST)

Message: More partitions to reorganize than there are partitions

Error: 1517 SQLSTATE: HY000 (ER_SAME_NAME_PARTITION)

Message: Duplicate partition name %s

Error: 1518 SQLSTATE: HY000 (ER_NO_BINLOG_ERROR)

Message: It is not allowed to shut off binlog on this command

Error: 1519 SQLSTATE: HY000 (ER_CONSECUTIVE_REORG_PARTITIONS)

Message: When reorganizing a set of partitions they must be in consecutive order

Error: 1520 SQLSTATE: HY000 (ER_REORG_OUTSIDE_RANGE)

Message: Reorganize of range partitions cannot change total ranges except for last partition where it can extend the range

Error: 1521 SQLSTATE: HY000 (ER_PARTITION_FUNCTION_FAILURE)

Message: Partition function not supported in this version for this handler

Error: 1522 SQLSTATE: HY000 (ER_PART_STATE_ERROR)

Message: Partition state cannot be defined from CREATE/ALTER TABLE

Error: 1523 SQLSTATE: HY000 (ER_LIMITED_PART_RANGE)

Message: The %s handler only supports 32 bit integers in VALUES

Error: 1524 SQLSTATE: HY000 (ER_PLUGIN_IS_NOT_LOADED)

Message: Plugin '%s' is not loaded

Error: 1525 SQLSTATE: HY000 (ER_WRONG_VALUE)

Message: Incorrect %s value: '%s'

Error: 1526 SQLSTATE: HY000 (ER_NO_PARTITION_FOR_GIVEN_VALUE)

Message: Table has no partition for value %s

Error: 1527 SQLSTATE: HY000 (ER_FILEGROUP_OPTION_ONLY_ONCE)

Message: It is not allowed to specify %s more than once

Error: 1528 SQLSTATE: HY000 (ER_CREATE_FILEGROUP_FAILED)

Message: Failed to create %s

Error: 1529 SQLSTATE: HY000 (ER_DROP_FILEGROUP_FAILED)

Message: Failed to drop %s

Error: 1530 SQLSTATE: HY000 (ER_TABLESPACE_AUTO_EXTEND_ERROR)

Message: The handler doesn't support autoextend of tablespaces

Error: 1531 SQLSTATE: HY000 (ER_WRONG_SIZE_NUMBER)

Message: A size parameter was incorrectly specified, either number or on the form 10M

Error: 1532 SQLSTATE: HY000 (ER_SIZE_OVERFLOW_ERROR)

Message: The size number was correct but we don't allow the digit part to be more than 2 billion

Error: 1533 SQLSTATE: HY000 (ER_ALTER_FILEGROUP_FAILED)

Message: Failed to alter: %s

Error: 1534 SQLSTATE: HY000 (ER_BINLOG_ROW_LOGGING_FAILED)

Message: Writing one row to the row-based binary log failed

Error: 1535 SQLSTATE: HY000 (ER_BINLOG_ROW_WRONG_TABLE_DEF)

Message: Table definition on master and slave does not match: %s

Error: 1536 SQLSTATE: HY000 (ER_BINLOG_ROW_RBR_TO_SBR)

Message: Slave running with --log-slave-updates must use row-based binary logging to be able to replicate row-based binary log events

Error: 1537 SQLSTATE: HY000 (ER_EVENT_ALREADY_EXISTS)

Message: Event '%s' already exists

Error: 1538 SQLSTATE: HY000 (ER_EVENT_STORE_FAILED)

Message: Failed to store event %s. Error code %d from storage engine.

Error: 1539 SQLSTATE: HY000 (ER_EVENT_DOES_NOT_EXIST)

Message: Unknown event '%s'

Error: 1540 SQLSTATE: HY000 (ER_EVENT_CANT_ALTER)

Message: Failed to alter event '%s'

Error: 1541 SQLSTATE: HY000 (ER_EVENT_DROP_FAILED)

Message: Failed to drop %s

Error: 1542 SQLSTATE: HY000 (ER_EVENT_INTERVAL_NOT_POSITIVE_OR_TOO_BIG)

Message: INTERVAL is either not positive or too big

Error: 1543 SQLSTATE: HY000 (ER_EVENT_ENDS_BEFORE_STARTS)

Message: ENDS is either invalid or before STARTS

Error: 1544 SQLSTATE: HY000 (ER_EVENT_EXEC_TIME_IN_THE_PAST)

Message: Event execution time is in the past. Event has been disabled

Error: 1545 SQLSTATE: HY000 (ER_EVENT_OPEN_TABLE_FAILED)

Message: Failed to open mysql.event

Error: 1546 SQLSTATE: HY000 (ER_EVENT_NEITHER_M_EXPR_NOR_M_AT)

Message: No datetime expression provided

Error: 1547 SQLSTATE: HY000 (ER_COL_COUNT_DOESNT_MATCH_CORRUPTED)

Message: Column count of mysql.%s is wrong. Expected %d, found %d. The table is probably corrupted

Error: 1548 SQLSTATE: HY000 (ER_CANNOT_LOAD_FROM_TABLE)

Message: Cannot load from mysql.%s. The table is probably corrupted

Error: 1549 SQLSTATE: HY000 (ER_EVENT_CANNOT_DELETE)

Message: Failed to delete the event from mysql.event