Uploaded image for project: 'Percona XtraDB Cluster'
  1. Percona XtraDB Cluster
  2. PXC-1766

LP #1391647: XtraDB: creation of MyISAM temporary table causes error messages in log

    Details

    • Type: Bug
    • Status: Done
    • Priority: Low
    • Resolution: Invalid
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Veshij last update 11-11-2014 22:35:31

      I have 3-nodes XtraDB cluster and i want to migrate applications to this cluster.
      Some code creates temporary MyISAM tables and it causes error messages in log on all cluster nodes.

      Testcase:

      root@db-x01f:~# mysql test
      Welcome to the MySQL monitor. Commands end with ; or \g.
      Your MySQL connection id is 1045801
      Server version: 5.6.20-68.0-56-log Percona XtraDB Cluster (GPL), Release 25.7, wsrep_25.7.r4126
      ...
      mysql> show variables like 'wsrep_replicate_myisam';
      -----------------------------+

      Variable_name Value

      -----------------------------+

      wsrep_replicate_myisam ON

      -----------------------------+
      1 row in set (0.00 sec)

      mysql> CREATE TEMPORARY TABLE `t` ( id int(8)) ENGINE=MYISAM;
      Query OK, 0 rows affected (0.00 sec)

      mysql> insert into t values(1);
      Query OK, 1 row affected (0.00 sec)

      mysql> select * from t;
      ------

      id

      ------

      1

      ------
      1 row in set (0.00 sec)

      Error message (appears on all other nodes in cluster):

      2014-11-11 23:57:16 18553 [ERROR] Slave SQL: Error 'Table 'test.t' doesn't exist' on query. Default database: 'test'. Query: 'insert into t values(1)', Error_code: 1146
      2014-11-11 23:57:16 18553 [Warning] WSREP: RBR event 1 Query apply warning: 1, 2102331
      2014-11-11 23:57:16 18553 [Warning] WSREP: Ignoring error for TO isolated action: source: f4057a94-69ba-11e4-a327-264938fa2dc9 version: 3 local: 0 state: APPLYING flags: 65 conn_id: 1045801 trx_id: -1 seqnos (l: 2127680, g: 2102331, s: 2102330, d: 2102330, ts: 1151432616722208)

      Versions:
      root@db-x01f:~# dpkg -l | grep percona
      ii percona-repo-config 1.2 all Configures Percona mirror repo
      ii percona-toolkit 2.2.11 all Advanced MySQL and system command-line tools
      ii percona-xtrabackup 2.2.5-5027-1.trusty amd64 Open source backup tool for InnoDB and XtraDB
      ii percona-xtradb-cluster-client-5.6 5.6.20-25.7-886.trusty amd64 Percona XtraDB Cluster database client binaries
      ii percona-xtradb-cluster-common-5.6 5.6.20-25.7-886.trusty amd64 Percona XtraDB Cluster database common files (e.g. /etc/mysql/my.cnf)
      ii percona-xtradb-cluster-galera-3.x 3.7.3256.trusty amd64 Galera components of Percona XtraDB Cluster
      ii percona-xtradb-cluster-server-5.6 5.6.20-25.7-886.trusty amd64 Percona XtraDB Cluster database server binaries
      root@mtacs-x01f:~#

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                krunal.bauskar Krunal Bauskar (Inactive)
                Reporter:
                lpjirasync lpjirasync (Inactive)
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated: