support

Often support customers want to see what you do on their databases. For this screen is the ideal tool.

Screen commands typically look like this:

screen> Ctrl+a ?

This means press Ctrl+a, release Ctrl+a, press ? and NOT press Ctrl+a+? together. Often you can find Ctrl+A which is wrong. It is a lower case a!

Start first screen

Start and leave a screen:

Sehr geehrte MySQL-Nutzerinnen und -Nutzer,

Mit diesem Newsletter bringen wir Sie auf den neuesten Stand was das Produkt MySQL und unsere Dienstleistungen betrifft.

Dear MySQL User,

With this newsletter we bring you up to date about MySQL and our Services.

If you are not interested in this newsletter or if you are the wrong recipient, you can unsubscribe here or even better send this newsletter to the right person.

Was sie erhalten

• 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

• Error: 2000 (CR_UNKNOWN_ERROR)

  Message: Unknown MySQL error

• Error: 2001 (CR_SOCKET_CREATE_ERROR)

• Error: 1700 SQLSTATE: HY000 (ER_GRANT_PLUGIN_USER_EXISTS)

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

• 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: 1600 SQLSTATE: HY000 (ER_VIEW_INVALID_CREATION_CTX)

  Message: Creation context of view `%s`.`%s' is invalid

• Error: 1550 SQLSTATE: HY000 (ER_EVENT_COMPILE_ERROR)

  Message: Error during compilation of event's body

• Error: 1500 SQLSTATE: HY000 (ER_SUBPARTITION_ERROR)

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

• Error: 1450 SQLSTATE: HY000 (ER_FORBID_SCHEMA_CHANGE)

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

• Error: 1400 SQLSTATE: XAE09 (ER_XAER_OUTSIDE)

  Message: XAER_OUTSIDE: Some work is done outside global transaction

• Error: 1401 SQLSTATE: XAE03 (ER_XAER_RMERR)

• Error: 1350 SQLSTATE: HY000 (ER_VIEW_SELECT_CLAUSE)

  Message: View's SELECT contains a '%s' clause

• Error: 1300 SQLSTATE: HY000 (ER_INVALID_CHARACTER_STRING)

  Message: Invalid %s character string: '%s'

• Error: 1250 SQLSTATE: 42000 (ER_TABLENAME_NOT_ALLOWED_HERE)

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

• Error: 1200 SQLSTATE: HY000 (ER_BAD_SLAVE)

  Message: The server is not configured as slave; fix in config file or with CHANGE MASTER TO

• Error: 1150 SQLSTATE: HY000 (ER_DELAYED_CANT_CHANGE_LOCK)

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

• Error: 1100 SQLSTATE: HY000 (ER_TABLE_NOT_LOCKED)

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

• ---

  Error: 1050 SQLSTATE: 42S01 (ER_TABLE_EXISTS_ERROR)

  Message: Table '%s' already exists

• Error: 1000 SQLSTATE: HY000 (ER_HASHCHK)

  Message: hashchk

• Error: 1001 SQLSTATE: HY000 (ER_NISAMCHK)

  Message: isamchk

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: