Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-9854

Update to InnoDB table with WSREP enabled doesn't get GTID in wsrep_gtid_domain_id domain

    XMLWordPrintable

    Details

      Description

      See the following:

      MariaDB [db1]> show global variables where variable_name in ('wsrep_on', 'wsrep_gtid_domain_id');
      +----------------------+-------+
      | Variable_name        | Value |
      +----------------------+-------+
      | wsrep_gtid_domain_id | 3     |
      | wsrep_on             | ON    |
      +----------------------+-------+
      2 rows in set (0.00 sec)
       
      MariaDB [db1]> show master status;
      +--------------------+----------+--------------+------------------+
      | File               | Position | Binlog_Do_DB | Binlog_Ignore_DB |
      +--------------------+----------+--------------+------------------+
      | mariadb-bin.000016 |      591 |              |                  |
      +--------------------+----------+--------------+------------------+
      1 row in set (0.00 sec)
       
      MariaDB [db1]> show create table tab1;
      +-------+----------------------------------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                                                 |
      +-------+----------------------------------------------------------------------------------------------------------------------------------------------+
      | tab1  | CREATE TABLE `tab1` (
        `id` int(11) NOT NULL,
        `str` varchar(10) DEFAULT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1 |
      +-------+----------------------------------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
       
      MariaDB [db1]> insert into tab1 values (2, 'str2');
      Query OK, 1 row affected (0.01 sec)
       
      MariaDB [db1]> show binlog events in 'mariadb-bin.000016' from 591;
      +--------------------+-----+---------------+-----------+-------------+--------------------------------+
      | Log_name           | Pos | Event_type    | Server_id | End_log_pos | Info                           |
      +--------------------+-----+---------------+-----------+-------------+--------------------------------+
      | mariadb-bin.000016 | 591 | Gtid          |         1 |         629 | BEGIN GTID 0-1-3               |
      | mariadb-bin.000016 | 629 | Table_map     |         1 |         674 | table_id: 19 (db1.tab1)        |
      | mariadb-bin.000016 | 674 | Write_rows_v1 |         1 |         713 | table_id: 19 flags: STMT_END_F |
      | mariadb-bin.000016 | 713 | Xid           |         1 |         740 | COMMIT /* xid=5 */             |
      +--------------------+-----+---------------+-----------+-------------+--------------------------------+
      4 rows in set (0.00 sec)
      

        Attachments

          Activity

            People

            Assignee:
            Unassigned
            Reporter:
            GeoffMontee Geoff Montee
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: