oli's blog

1650 - 1699 2000 - 2049

• Error: 1700 SQLSTATE: HY000 (ER_GRANT_PLUGIN_USER_EXISTS)

1600 - 1649 1700 - 1749

• Error: 1650 SQLSTATE: HY000 (ER_SLAVE_IGNORE_SERVER_IDS)

1550 - 1599 1650 - 1699

• Error: 1600 SQLSTATE: HY000 (ER_VIEW_INVALID_CREATION_CTX)

1500 - 1549 1600 - 1649

• Error: 1550 SQLSTATE: HY000 (ER_EVENT_COMPILE_ERROR)

1450 - 1499 1550 - 1599

• Error: 1500 SQLSTATE: HY000 (ER_SUBPARTITION_ERROR)

1400 - 1449 1500 - 1549

• Error: 1450 SQLSTATE: HY000 (ER_FORBID_SCHEMA_CHANGE)

1350 - 1399 1450 - 1499

• Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE)

1300 - 1349 1400 - 1449

• Error: 1350 SQLSTATE: HY000 (ER_VIEW_SELECT_CLAUSE)

1250 - 1299 1350 - 1399

• Error: 1300 SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING)

1200 - 1249 1300 - 1349

• Error: 1250 SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE)

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?

1100 - 1149 1200 - 1249

• Error: 1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK)

1050 - 1099 1150 - 1199

• Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

1000 - 1049 1100 - 1149

Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)

1050 - 1099

• Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

  Message: hashchk

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…

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.

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?

Hi Stewart,

Thanks for your comment. Paul made some similar conclusions: