Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-2853

HTAP - Replication workflow dependency on the metadata

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • None
    • N/A
    • N/A
    • GKE

    Description

      Replication workflow dependency on the metadata

      Replication workflow dependency on the metadata is causing overruling of mysql statements,
      as a result are received internal Errors causing replication to stop

      Client Side:

      MariaDB [(none)]> insert into ins.a values(1),(2),(3) ;
      Query OK, 3 rows affected (0.005 sec)
      Records: 3  Duplicates: 0  Warnings: 0
      

      HTAP Side:

        Last_SQL_Error: Error 'You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'collectert into collect.a values(1),(2),(3)' at line 1' on query. Default database: ''. Query: 'collectert into collect.a values(1),(2),(3)'
      

      Target replication Side:

      MariaDB [(none)]> select * from collect.a ;
      Empty set (0.011 sec)
      
      

      how to repeat:

      MariaDB [(none)]> create database ins ;
       
      MariaDB [(none)]> create database collect ;
      Query OK, 1 row affected (0.003 sec)
      MariaDB [(none)]> create table collect.a ( a int) engine columnstore ;
      Query OK, 0 rows affected (0.257 sec)
      MariaDB [(none)]>  create table ins.a ( a int) ;
      Query OK, 0 rows affected (0.015 sec)
      
      

      MariaDB [(none)]> select set_replications('a', 'ins', 'collect');
      +-----------------------------------------+
      | set_replications('a', 'ins', 'collect') |
      +-----------------------------------------+
      | Success.                                |
      +-----------------------------------------+
      1 row in set (0.017 sec)
       
      MariaDB [(none)]> insert into ins.a values(1),(2),(3) ;
      Query OK, 3 rows affected (0.005 sec)
      Records: 3  Duplicates: 0  Warnings: 0
      

      MariaDB [(none)]> select list_replications();
      +------------------------------------------------------------------------------------------+
      | list_replications()                                                                      |
      +------------------------------------------------------------------------------------------+
      |
              === replication_filter ===
              table: a
              source database: ins
              target database: collect
       
       |
      +------------------------------------------------------------------------------------------+
      1 row in set (0.002 sec)
      
      

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              winstone Zdravelina Sokolovska (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.