You are here

mysql

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 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 1400 - 1449

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)

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 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 never the less 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

MyEnv für Multi-Datenbank Set-ups

Vor ein paar Wochen haben wir einem unserer Kunden unser MyEnv gezeigt. Er war sehr interessiert daran und hat uns geraten MyEnv einer breiten Öffentlichkeit bekannter zu machen. In Tat und Wahrheit ist das MyEnv bereits seit mehreren Jahren verfügbar und kann frei heruntergeladen werden...

MyEnv for MySQL Multi-Database set-ups

This week I showed one of my customers our MyEnv. He was very interested in it and suggested to make it known in public. In fact MyEnv is available for download already several years...

But I did not have the heart yet to announce it more publicly because it was not end user ready at all. So I used the weekend to make it nicer, consolidated some of the code, dropped old stuff etc. Now I think it is acceptable to use for public but not perfect.

FromDual plans Advanced MySQL DBA Workshop

Taxonomy upgrade extras: 
With one of its partners FromDual plans to offer an Advanced MySQL DBA Workshop. The first workshop should run in November 2010. To offer the best possible contents to the participants we want your feedback about the proposed topics, about the missing topics and what you think in general about such a workshop. Please let us know your opinion. Either as comment on our web-site or for our eyes only at Feedback. Thank you for your participation.

FromDual plant einen MySQL DBA Workshop für Fortgeschrittene

Taxonomy upgrade extras: 
FromDual plant, mit einem seiner Partner, einen MySQL DBA Workshop für Fortgeschrittene anzubieten. Die erste Durchführung soll im November 2010 erfolgen. Um den Teilnehmern den bestmöglichen Inhalt anbieten zu können, würden wir gerne Ihre Meinung über den geplanten Inhalt, fehlende Punkte und was Sie im allgemeinen über diesen Workshop denken, hören.

Advanced MySQL DBA Workshop - draft

With a partner we are planning and Advanced MySQL DBA workshop. As the name says it should be a workshop. Its planned duration is 2 days. So within 2 days we can cover 4 to 8 topics more deeply.

Requirements: VirtualBox, VMware, own Laptop?

Undefined

MySQL Performance Monitor

FromDual launches its database Performance Monitoring solution for MySQL, Percona Server and MariaDB. This solution provides monitoring capabilities for most MySQL Storage Engines (Aria, InnoDB, MyISAM, NDB, PBXT and XtraDB). Further you can monitor MySQL Master - Slave replication set-ups, UNIX processes (mysqld, ndbd) and MySQL specific information.

More details you can find on the page Performance Monitor for MySQL.

MySQL Performance Monitor

FromDual veröffentlicht seine Datenbank Performance Monitoring Lösung für MySQL, Percona Server und MariaDB. Diese Lösung verfügt über Monitoringmöglichkeiten für die meisten MySQL Storage Engines (Aria, InnoDB, MyISAM, NDB, PBXT und XtraDB). Im Weiteren können MySQL Master - Slave Replikationen, UNIX Prozesse (mysqld, ndbd) und MySQL spezifische Informationen überwacht werden.

Mehr Informationen finden sie auf der Seite Performance Monitor für MySQL.

Performance Monitor for MySQL and MariaDB (fpmmm)

What is the FromDual Performance Monitor for MySQL and MariaDB (fpmmm)?

The FromDual Performance Monitor (fpmmm) for MySQL, Galera Cluster, MariaDB and Percona Server is a monitoring solution based on the enterprise class open source monitor Zabbix.

It provides all the necessary modules to monitor your MySQL/MariaDB performance metrics in detail an let you display them graphically.

Undefined

Pages

Subscribe to RSS - mysql