FromDual TechFeed (de)

1650 - 1699 2000 - 2049

• Error: 1700 SQLSTATE: HY000 (ER_GRANT_PLUGIN_USER_EXISTS)

  Message: GRANT with IDENTIFIED WITH is illegal because the user %-.
  *s already exists

• Error: 1701 SQLSTATE: 42000 (ER_TRUNCATE_ILLEGAL_FK)

  Message: Cannot truncate a table referenced in a foreign key constraint (%s)

• Error: 1702 SQLSTATE: HY000 (ER_PLUGIN_IS_PERMANENT)

  Message: Plugin ‘%s’ is force_plus_permanent and can not be unloaded

• Error: 1703 SQLSTATE: HY000 ( …

1600 - 1649 1700 - 1749

• Error: 1650 SQLSTATE: HY000 (ER_SLAVE_IGNORE_SERVER_IDS)

  Message: The requested server id %d clashes with the slave startup option –replicate-same-server-id

• Error: 1651 SQLSTATE: HY000 (ER_QUERY_CACHE_DISABLED)

  Message: Query cache is disabled; restart the server with query_cache_type=1 to enable it

• Error: 1652 SQLSTATE: HY000 (ER_SAME_NAME_PARTITION_FIELD)

  Message: Duplicate partition field name ‘%s’

• Error: 1653 SQLSTATE: HY000 ( …

1550 - 1599 1650 - 1699

• Error: 1600 SQLSTATE: HY000 (ER_VIEW_INVALID_CREATION_CTX)

  Message: Creation context of view
  %s<br>.
  `%s’ is invalid

• Error: 1601 SQLSTATE: HY000 (ER_SR_INVALID_CREATION_CTX)

  Message: Creation context of stored routine
  %s<br>.
  %s<br> is invalid

• Error: 1602 SQLSTATE: HY000 (ER_TRG_CORRUPTED_FILE)

  Message: Corrupted TRG file for table
  %s<br>.
  %s<br>

• Error: 1603 SQLSTATE: HY000 (ER_TRG_NO_CREATION_CTX)

  Message: Triggers for table
  %s<br>. …

1500 - 1549 1600 - 1649

• Error: 1550 SQLSTATE: HY000 (ER_EVENT_COMPILE_ERROR)

  Message: Error during compilation of event’s body

• Error: 1551 SQLSTATE: HY000 (ER_EVENT_SAME_NAME)

  Message: Same old and new event name

• Error: 1552 SQLSTATE: HY000 (ER_EVENT_DATA_TOO_LONG)

  Message: Data for column ‘%s’ too long

• Error: 1553 SQLSTATE: HY000 (ER_DROP_INDEX_FK)

  Message: Cannot drop index ‘%s’: needed in a foreign key constraint

• Error: 1554 SQLSTATE: HY000 ( …

1450 - 1499 1550 - 1599

• 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 …

1400 - 1449 1500 - 1549

• Error: 1450 SQLSTATE: HY000 (ER_FORBID_SCHEMA_CHANGE)

  Message: Changing schema from ‘%s’ to ‘%s’ is not allowed.

• Error: 1451 SQLSTATE: 23000 (ER_ROW_IS_REFERENCED_2)

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

• Error: 1452 SQLSTATE: 23000 (ER_NO_REFERENCED_ROW_2)

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

• Error: 1453 SQLSTATE: 42000 (ER_SP_BAD_VAR_SHADOW)

  Message: Variable …

1350 - 1399 1450 - 1499

• Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE)

  Message: XAER_OUTSIDE: Some work is done outside global transaction

• Error: 1401 SQLSTATE: XAE03 (ER_XAER_RMERR)

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

• Error: 1402 SQLSTATE: XA100 (ER_XA_RBROLLBACK)

  Message: XA_RBROLLBACK: Transaction branch was rolled back

• Error: 1403 SQLSTATE: 42000 (ER_NONEXISTING_PROC_GRANT)

  Message: There is no such grant defined for user …

1300 - 1349 1400 - 1449

• Error: 1350 SQLSTATE: HY000 (ER_VIEW_SELECT_CLAUSE)

  Message: View’s SELECT contains a ‘%s’ clause

• Error: 1351 SQLSTATE: HY000 (ER_VIEW_SELECT_VARIABLE)

  Message: View’s SELECT contains a variable or parameter

• Error: 1352 SQLSTATE: HY000 (ER_VIEW_SELECT_TMPTABLE)

  Message: View’s SELECT refers to a temporary table ‘%s’

• Error: 1353 SQLSTATE: HY000 (ER_VIEW_WRONG_LIST)

  Message: View’s SELECT and view’s field list have …

1250 - 1299 1350 - 1399

• Error: 1300 SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING)

  Message: Invalid %s character string: ‘%s’

• Error: 1301 SQLSTATE: HY000 (ER_WARN_ALLOWED_PACKET_OVERFLOWED)

  Message: Result of %s() was larger than max_allowed_packet (%ld) - truncated

• Error: 1302 SQLSTATE: HY000 (ER_CONFLICTING_DECLARATIONS)

  Message: Conflicting declarations: ‘%s%s’ and ‘%s%s’

• Error: 1303 SQLSTATE: 2F003 (ER_SP_NO_RECURSIVE_CREATE)

  Message: Can’t create a …

1200 - 1249 1300 - 1349

• Error: 1250 SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE)

  Message: Table ‘%s’ from one of the SELECTs cannot be used in %s

• Error: 1251 SQLSTATE: 08004 (ER_NOT_SUPPORTED_AUTH_MODE)

  Message: Client does not support authentication protocol requested by server; consider upgrading MySQL client

• Error: 1252 SQLSTATE: 42000 (ER_SPATIAL_CANT_HAVE_NULL)

  Message: All parts of a SPATIAL index must be NOT NULL

• Error: 1253 SQLSTATE: 42000 (ER_COLLATION_CHARSET_MISMATCH) …

1150 - 1199 1250 - 1299

  Error: 1200 SQLSTATE: HY000 (ER_BAD_SLAVE)
  Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

How does the MySQL error message look like?

  Error: 1201 SQLSTATE: HY000 (ER_MASTER_INFO)
  Message: Could not initialize master info structure; more error messages can be found in the MySQL error log

How does the MySQL error message look like?

  Error: 1202 SQLSTATE: HY000 (ER_SLAVE_THREAD)
  Message: Could not create slave thread; …

1100 - 1149 1200 - 1249

• Error: 1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK)

  Message: Delayed insert thread couldn’t get requested lock for table %s

• Error: 1151 SQLSTATE: HY000 (ER_TOO_MANY_DELAYED_THREADS)

  Message: Too many delayed threads in use

• Error: 1152 SQLSTATE: 08S01 (ER_ABORTING_CONNECTION)

  Message: Aborted connection %ld to db: ‘%s’ user: ‘%s’ (%s)

  Error: 1153 SQLSTATE: 08S01 (ER_NET_PACKET_TOO_LARGE)
  Message: Got a packet bigger than …

1050 - 1099 1150 - 1199

• Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

  Message: Table ‘%s’ was not locked with LOCK TABLES

• Error: 1101 SQLSTATE: 42000 (ER_BLOB_CANT_HAVE_DEFAULT)

  Message: BLOB/TEXT column ‘%s’ can’t have a default value

• Error: 1102 SQLSTATE: 42000 (ER_WRONG_DB_NAME)

  Message: Incorrect database name ‘%s’

• Error: 1103 SQLSTATE: 42000 (ER_WRONG_TABLE_NAME)

  Message: Incorrect table name ‘%s’

• Error: 1104 SQLSTATE: 42000 ( …

1000 - 1049 1100 - 1149

Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)

Message: Table ‘%s’ already exists

• Error: 1051 SQLSTATE: 42S02 (ER_BAD_TABLE_ERROR)

  Message: Unknown table ‘%s’

• Error: 1052 SQLSTATE: 23000 (ER_NON_UNIQ_ERROR)

  Message: Column ‘%s’ in %s is ambiguous

• Error: 1053 SQLSTATE: 08S01 (ER_SERVER_SHUTDOWN)

  Message: Server shutdown in progress

• Error: 1054 SQLSTATE: 42S22 (ER_BAD_FIELD_ERROR)

  Message: Unknown column ‘%s’ in …

1050 - 1099

• Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

  Message: hashchk

• Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)

  Message: isamchk

• Error: 1002 SQLSTATE: HY000 (ER_NO)

  Message: NO

• Error: 1003 SQLSTATE: HY000 (ER_YES)

  Message: YES

• Error: 1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE)

  Message: Can’t create file ‘%s’ (errno: %d)

• Error: 1005 SQLSTATE: HY000 (ER_CANT_CREATE_TABLE)

  Message: Can’t create table ‘%s’ (errno: %d)

  Error: 1006 SQLSTATE: HY000 …

Just a general rule with error messages: Usually they are not as good as they could be. But nevertheless read them carefully. Most of the time they tell you what you need to know…

And an other wisdom: Errors are really errors and they have to be solved. Warnings are warnings and you should investigate if they appear. Do not ignore both of them unless you have clearly understood what you are doing.

With MySQL:

mysql> SHOW WARNINGS

is often your friend! Further sources to find the problems are: …

FromDual is a support partner of MariaDB plc, Codership Oy and Oracle Corporation. This gives us the opportunity to offer you customized enterprise support subscriptions for your mission-critical MariaDB, Galera or MySQL databases for all three vendors.

Alternatively, we can offer you our remote DBA services (without SLA) or our MariaDB, Galera and MySQL trainings.

MariaDB and MariaDB Cluster Support Subscriptions

• MariaDB Enterprise support subscription: 7x24 support subscription, duration: 1 to 3 years, …

We dug some further with this problem of too big rows. The results you can find below.

Further discussion we had about PBXT MEMORY tables partitioned:

Q: Is there a good case where partitioned PBXT MEMORY tables could make sense?

A: To have some partitions on disk and other in memory could be useful.

Unfortunately MySQL (up to 5.6.1) and MariaDB (up to 5.2.3) do not support mixing different Storage Engines for a partitioned table yet:

ERROR 1497 (HY000): The mix of handlers in the partitions is not allowed in this version of MySQL

Lit: CREATE TABLE

Hi Stewart,

Thanks for your comment. Paul made some similar conclusions:

The problem could be that the fixed length record component is too large. PBXT tries to estimate the average row length of a table when it is created. It then sets the fixed length record component to the estimated average row length value.

If the estimate is not good, you can set it explicitly by setting AVG_ROW_LENGTH.

Optimizing the average row length is explained in my talk.

For the moment you can just try AVG_ROW_LENGTH = 12. …