enterprise-support team mailing list archive

[Ben Mildren <ben.mildren@xxxxxxxxxxx>]

Public bug reported:

if (mysql_get_server_version(conn)) {
		mysql_query(conn, "CREATE TABLE IF NOT EXISTS mysql.mydumperdummy (a INT) ENGINE=INNODB");
		need_dummy_read=1;
	}

Looking at the comments on why this code is included it probably should
be:

if (mysql_get_server_version(conn)  < 40108) {
		mysql_query(conn, "CREATE TABLE IF NOT EXISTS mysql.mydumperdummy (a INT) ENGINE=INNODB");
		need_dummy_read=1;
	}


On most installs the CREATE TABLE... will fail as a ftwrl is acquired just before, but on the current version of Galera (current PXC binaries are  5.5.34 / 5.6.14), the combination of DDL on the same thread that acquired the ftwrl caused the node to go down (https://bugs.launchpad.net/galera/+bug/1265656).  Although this was due to a bug that will be fixed, probably best to restrict the CREATE TABLE to only when required.

** Affects: mydumper
     Importance: Undecided
         Status: New

-- 
You received this bug notification because you are a member of Ubuntu
Server/Client Support Team, which is subscribed to MySQL.
Matching subscriptions: Ubuntu Server/Client Support Team
https://bugs.launchpad.net/bugs/1267501

Title:
  mydumper erroneously always attempts a dummy read

To manage notifications about this bug go to:
https://bugs.launchpad.net/mydumper/+bug/1267501/+subscriptions