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

the innodb transaction use the gtid_domin_id in galera cluster not wsrep_gtid_domin_id

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Critical
    • Resolution: Duplicate
    • Affects Version/s: 10.4.7
    • Fix Version/s: N/A
    • Component/s: Galera, wsrep
    • Labels:
    • Environment:
      mariadb 10.4.7 galera 26.4.2

      Description

      i create two table jian is innodb ,jianm is myisam

      (root@localhost) [sbdb] 11:38:22> show create table jian;
      +-------+----------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                         |
      +-------+----------------------------------------------------------------------------------------------------------------------+
      | jian  | CREATE TABLE `jian` (
        `id` int(11) DEFAULT NULL
      ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
      +-------+----------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
       
      (root@localhost) [sbdb] 11:42:39> show create table jianm;
      +-------+-----------------------------------------------------------------------------------------------------------------------+
      | Table | Create Table                                                                                                          |
      +-------+-----------------------------------------------------------------------------------------------------------------------+
      | jianm | CREATE TABLE `jianm` (
        `id` int(11) DEFAULT NULL
      ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci |
      +-------+-----------------------------------------------------------------------------------------------------------------------+
      1 row in set (0.00 sec)
      

      do the insert into the tables

      (root@localhost) [sbdb] 11:42:45> show variables like '%gtid%';
      +-------------------------+---------------+
      | Variable_name           | Value         |
      +-------------------------+---------------+
      | gtid_binlog_pos         | 1-1-7,101-1-9 |
      | gtid_binlog_state       | 1-1-7,101-1-9 |
      | gtid_cleanup_batch_size | 64            |
      | gtid_current_pos        | 1-1-7,101-1-9 |
      | gtid_domain_id          | 101           |
      | gtid_ignore_duplicates  | ON            |
      | gtid_pos_auto_engines   |               |
      | gtid_seq_no             | 0             |
      | gtid_slave_pos          |               |
      | gtid_strict_mode        | ON            |
      | last_gtid               | 101-1-9       |
      | wsrep_gtid_domain_id    | 1             |
      | wsrep_gtid_mode         | ON            |
      +-------------------------+---------------+
      13 rows in set (0.00 sec)
       
      (root@localhost) [sbdb] 11:43:31> insert into jianm values(1);
      Query OK, 1 row affected (0.00 sec)
       
      (root@localhost) [sbdb] 11:43:43> show variables like '%gtid%';
      +-------------------------+----------------+
      | Variable_name           | Value          |
      +-------------------------+----------------+
      | gtid_binlog_pos         | 1-1-7,101-1-10 |
      | gtid_binlog_state       | 1-1-7,101-1-10 |
      | gtid_cleanup_batch_size | 64             |
      | gtid_current_pos        | 1-1-7,101-1-10 |
      | gtid_domain_id          | 101            |
      | gtid_ignore_duplicates  | ON             |
      | gtid_pos_auto_engines   |                |
      | gtid_seq_no             | 0              |
      | gtid_slave_pos          |                |
      | gtid_strict_mode        | ON             |
      | last_gtid               | 101-1-10       |
      | wsrep_gtid_domain_id    | 1              |
      | wsrep_gtid_mode         | ON             |
      +-------------------------+----------------+
      13 rows in set (0.00 sec)
       
      (root@localhost) [sbdb] 11:43:44> insert into jian values(1);
      Query OK, 1 row affected (0.00 sec)
       
      (root@localhost) [sbdb] 11:43:50> show variables like '%gtid%';
      +-------------------------+----------------+
      | Variable_name           | Value          |
      +-------------------------+----------------+
      | gtid_binlog_pos         | 1-1-7,101-1-11 |
      | gtid_binlog_state       | 1-1-7,101-1-11 |
      | gtid_cleanup_batch_size | 64             |
      | gtid_current_pos        | 1-1-7,101-1-11 |
      | gtid_domain_id          | 101            |
      | gtid_ignore_duplicates  | ON             |
      | gtid_pos_auto_engines   |                |
      | gtid_seq_no             | 0              |
      | gtid_slave_pos          |                |
      | gtid_strict_mode        | ON             |
      | last_gtid               | 101-1-11       |
      | wsrep_gtid_domain_id    | 1              |
      | wsrep_gtid_mode         | ON             |
      +-------------------------+----------------+
      13 rows in set (0.00 sec)
      

      This is a galera env
      my question is i think it it right the gtid_domain_id transaction sequence increase when i insert into the myisam table ,but why when i insert into the innodb table the gtid_domain_id transaction sequence increase also ,i think when insert into the innodb table the wsrep_gtid_domain_id transaction sequence shoud be increase

        Attachments

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            yongjian.wu yongjian.wu
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: