You are here

error

MariaDB SQL Error Log Plugin

Taxonomy upgrade extras: 

When you are for too long in business you think you know already everything and you are getting lazy. This happened to me again a few weeks ago. A customer asked me about the SQL Error Log Plugin. First I though he was talking about the MariaDB Error Log or the General Query Log. But then I have learned that there is something "new" I did not know yet...

Stupid Error Messages

Taxonomy upgrade extras: 

Very often I see some stupid error messages as a (power-)user. I do not know if this is because of lazy developers or managers not having enough focus on more useful error messages.

If the error messages would be more clear it would help me as a power-user to fix my problems faster and fix it possibly myself instead of asking questions or even open support cases.

That would also safe costs on the support service side if end-users would be enabled to fix their problems themself. If this is what software vendors really want...

Dropped Tables with FromDual Backup Manager

Taxonomy upgrade extras: 

Some applications have the bad behaviour to CREATE or DROP tables while our FromDual Backup Manager (bman) backup is running.

This leads to the following bman error message:

Logging Galera Cluster conflicts

We typically suggest our customers to use our MySQL/Galera Cluster my.cnf configuration template to avoid MySQL configuration and performance problems.

And we are paranoid as well. Thus we enable all useful logging:

wsrep_log_conflicts = 1

But this has also some consequences of more visibility...

MySQL Client Error Codes and Messages 2050 - 2099

2000 - 2049
  • Error: 2050 (CR_FETCH_CANCELED)

    Message: Row retrieval was canceled by mysql_stmt_close() call

  • Error: 2051 (CR_NO_DATA)

    Message: Attempt to read column without prior row fetch

Undefined

MySQL Server Error Codes and Messages 1700 - 1749

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

Undefined

MySQL Server Error Codes and Messages 1650 - 1699

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

Undefined

MySQL Server Error Codes and Messages 1600 - 1649

1550 - 1599 1650 - 1699
Undefined

MySQL Server Error Codes and Messages 1550 - 1599

1500 - 1549 1600 - 1649
Undefined

MySQL Server Error Codes and Messages 1500 - 1549

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

Undefined

MySQL Server Error Codes and Messages 1450 - 1499

1400 - 1449 1500 - 1549
Undefined

MySQL Server Error Codes and Messages 1400 - 1449

1350 - 1399 1450 - 1499
  • Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE)

    Message: XAER_OUTSIDE: Some work is done outside global transaction

Undefined

MySQL Server Error Codes and Messages 1250 - 1299

1200 - 1249 1300 - 1349
Undefined

MySQL Server Error Codes and Messages 1200 - 1249

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?

Undefined

MySQL Server Error Codes and Messages 1150 - 1199

1100 - 1149 1200 - 1249
Undefined

MySQL Server Error Codes and Messages 1100 - 1149

1050 - 1099 1150 - 1199
  • Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

    Message: Table '%s' was not locked with LOCK TABLES

Undefined

MySQL Server Error Codes and Messages 1000 - 1049

1050 - 1099
  • Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

    Message: hashchk

  • Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)

    Message: isamchk

Undefined

MySQL Error codes and messages

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:

Undefined
Subscribe to RSS - error