Support

MySQL Enterprise Backup (MEB) is a bit limited related to support of older MySQL versions. So you should consider the following release matrix:

* MySQL Enterprise Backup 8.0.15 only supports MySQL 8.0.15. For earlier versions of MySQL 8.0, use the MySQL Enterprise Backup version with the same version number as the server.

MySQL Enterprise Backup is available for …

See also Byobu.

See also our older article: Using screen for support and/or surveillance.

First simple steps

The command tmux starts a tmux server and opens a new session with a (pseudo) terminal:

shell> tmux

To leave a tmux session again just type Ctrl+d inside your tmux session or:

tmux> exit

If you want to give a tmux session a specific name you can start tmux as follows to created a named session:

shell> tmux new -s mariadb

or if you are already inside tmux:

tmux> Ctrl+b $

followed by a …

Table of Contents

• MariaDB Lifetime Support Matrix for MariaDB Releases
• MariaDB Corp Enterprise Support Subscriptions
• MySQL Lifetime Support Matrix for MySQL Releases
• Oracle Corp Enterprise Support Subscriptions for MySQL

Lifetime Support Matrix for MariaDB Releases

Will you be at a loss having a MySQL or MariaDB database problem? Will you need urgently help from experienced FromDual staff when your production MySQL or MariaDB database stops working? Or do you need a third party opinion for one of your MySQL or MariaDB solutions?

FromDual offers you vendor independent database support for MySQL (community and enterprise edition), MariaDB (community and enterprise edition) and Percona Server for all versions starting with 4.0.

How we provide support?

Our FromDual …

Hello,

there are companies which earn tens of thousands of Euros per hour with their MySQL databases. Other companies operate their ERP system on MySQL, to which 1000 employees are attached to. Is the database down 1000 people are not working any more until the system is working again! Downtime costs starting at EUR 30'000.- per hour upwards.

Support through the MySQL specialists?

These companies have properly planned operations of their MySQL databases, designed their production systems redundantly and …

If you are not operating MySQL databases yourself, but you develop MySQL based software, our MySQL development support is exactly fitting to your needs!

Are your developers hitting technical MySQL problems from time to time or have they a technical MySQL question, our support team is pleased to answer your questions after having talked to the FromDual consulting team.

This support contract is ticket- and not server-based and thus ideally fitting to your software development team. Any number of your MySQL …

See also Byobu.

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:

shell> screen
screen> exit

or k for kill

screen> Ctrl+a k

Comment: Does not work if done with sudo, typically used with ssh.

A …

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.

There are some news about the following topics:

• High-Availability(HA) with Galera Cluster for MySQL
• MySQL Performance Monitoring (MPM)
• MySQL Training in Essen and Berlin (Germany)
• 3^rd Level Support for MySQL
• Security holes in MySQL
• Technical information …

Helsinki, Finland, Uster, Switzerland – February 18, 2012 – Codership, the provider of Galera Cluster for MySQL, and FromDual, a MySQL consulting company, today announced collaboration to offer Galera Cluster technology and related support and consulting services for Galera users all over the world, especially in German speaking countries Germany, Austria and Switzerland (DACH). Galera Cluster is a synchronous, true multi-master replication cluster for MySQL using the well known InnoDB storage engine. …

From the Cooperation of these two companies arises the biggest independent service provider for MySQL and MariaDB in Europe.

Hamburg, Uster – February 28, 2011 - The Hamburg based PrimeBase Technologies and the near Zürich located FromDual are forming a Cooperation for MySQL products and services, starting March 1st, 2011.

This Cooperation enables both companies to offer a complete set of services for all MySQL and MariaDB customers.

The customers of both parties now have he possibility to demand a …

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

• Error: 2052 (CR_NO_STMT_METADATA)

  Message: Prepared statement contains no metadata

• Error: 2053 (CR_NO_RESULT_SET)

  Message: Attempt to read a row while there is no result set associated with the statement

• Error: 2054 (CR_NOT_IMPLEMENTED)

  Message: This feature is not implemented yet

• Error: 2055 ( …

1700 - 1749 2050 - 2099

• Error: 2000 (CR_UNKNOWN_ERROR)

  Message: Unknown MySQL error

• Error: 2001 (CR_SOCKET_CREATE_ERROR)

  Message: Can’t create UNIX socket (%d)

  ---

• Error: 2002 (CR_CONNECTION_ERROR) Message: Can’t connect to local MySQL server through socket ‘%s’

  How does the MySQL error message look like?

  shell> mysql --user=root --socket=/tmp/mysql.sock
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
  

  What does the MySQL error …

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

Neutral and vendor independent
MariaDB, Galera Cluster, MySQL and Percona Server
Consulting and Services!

MariaDB/MySQL Consulting

You get neutral and vendor independent on-site Consulting for MariaDB, MySQL, Galera Cluster and Percona Server without the need of a support contract or a subscription. Our consultants recommend you the best solutions fitting to your needs.

Learn more about our MariaDB/MySQL Consulting…

Training for MySQL and MariaDB

When you need a Training for MariaDB or MySQL, we …