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

DML commands are not replicating to PXC-8.0 nodes through MySQL shell

    Details

    • Type: Bug
    • Status: In Progress
    • Priority: High
    • Resolution: Unresolved
    • Affects Version/s: 8.0.18-internal
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Testcase MySQL Shell JS

      Connection to node1
      -------------------
       MySQL  JS > shell.connect('mysqlx://admin@localhost:33060')
      Creating an X protocol session to 'admin@localhost:33060'
      Please provide the password for 'admin@localhost:33060': ****
      Fetching schema names for autocompletion... Press ^C to stop.
      Your MySQL connection id is 37 (X protocol)
      Server version: 8.0.18-9 Percona XtraDB Cluster (GPL), Release rel9, Revision 94ca2ae, WSREP version 26.4.3
      No default schema selected; type \use <schema> to set one.
      <Session:admin@localhost:33060>
       MySQL  localhost:33060+ ssl  JS >
      
       MySQL  localhost:33060+ ssl  test  JS > \sql use test
      Fetching table and column names from `test` for auto-completion... Press ^C to stop.
      Query OK, 0 rows affected (0.0005 sec)
       MySQL  localhost:33060+ ssl  test  JS >
       MySQL  localhost:33060+ ssl  test  JS >
       MySQL  localhost:33060+ ssl  test  JS > db.createCollection('foo');
      <Collection:foo>
       MySQL  localhost:33060+ ssl  test  JS >
       MySQL  localhost:33060+ ssl  test  JS > db.foo.add({name : 'ram', age : 35 })
      Query OK, 1 item affected (0.0088 sec)
       MySQL  localhost:33060+ ssl  test  JS >
       MySQL  localhost:33060+ ssl  test  JS > \sql select * from foo;
      +-------------------------------------------------------------------+------------------------------+
      | doc                                                               | _id                          |
      +-------------------------------------------------------------------+------------------------------+
      | {"_id": "00005e4f57e30000000000000003", "age": 35, "name": "ram"} | 00005e4f57e30000000000000003 |
      +-------------------------------------------------------------------+------------------------------+
      1 row in set (0.0013 sec)
       MySQL  localhost:33060+ ssl  test  JS > 
       MySQL  localhost:33060+ ssl  test  JS > db.foo.add({name : 'king', age : 30 })
      Query OK, 1 item affected (0.0073 sec)
       MySQL  localhost:33060+ ssl  test  JS > \sql select * from foo;
      +--------------------------------------------------------------------+------------------------------+
      | doc                                                                | _id                          |
      +--------------------------------------------------------------------+------------------------------+
      | {"_id": "00005e4f57e30000000000000003", "age": 35, "name": "ram"}  | 00005e4f57e30000000000000003 |
      | {"_id": "00005e4f57e30000000000000006", "age": 30, "name": "king"} | 00005e4f57e30000000000000006 |
      +--------------------------------------------------------------------+------------------------------+
      2 rows in set (0.0013 sec)
       MySQL  localhost:33060+ ssl  test  JS >
       MySQL  localhost:33060+ ssl  test  JS >
       
       
       Connection to node2
       -------------------
       
       
       MySQL  localhost:33060+ ssl  test  JS > shell.connect('mysqlx://admin@192.168.100.20:33060')
      Creating an X protocol session to 'admin@192.168.100.20:33060'
      Please provide the password for 'admin@192.168.100.20:33060': ****
      Fetching schema names for autocompletion... Press ^C to stop.
      Closing old connection...
      Your MySQL connection id is 27 (X protocol)
      Server version: 8.0.18-9 Percona XtraDB Cluster (GPL), Release rel9, Revision 94ca2ae, WSREP version 26.4.3
      No default schema selected; type \use <schema> to set one.
      <Session:admin@192.168.100.20:33060>
       MySQL  192.168.100.20:33060+ ssl  JS > \sql use test
      Query OK, 0 rows affected (0.0014 sec)
       MySQL  192.168.100.20:33060+ ssl  test  JS > \sql select * from foo;
      Empty set (0.0020 sec)
       MySQL  192.168.100.20:33060+ ssl  test  JS >
      
      

      Testcase MySQL Shell SQL

       MySQL  localhost:33060+ ssl  test  SQL > create table t1(id int, name varchar(20), primary key (id));
      Query OK, 0 rows affected (0.1047 sec)
       MySQL  localhost:33060+ ssl  test  SQL >
       MySQL  localhost:33060+ ssl  test  SQL > insert into t1 values(1, 'jack');
      Query OK, 1 row affected (0.0070 sec)
       MySQL  localhost:33060+ ssl  test  SQL > select * from t1;
      +----+------+
      | id | name |
      +----+------+
      |  1 | jack |
      +----+------+
      1 row in set (0.0014 sec)
       MySQL  localhost:33060+ ssl  test  SQL > 
      
      
       MySQL  localhost:33060+ ssl  test  SQL > \js
      Switching to JavaScript mode...
       MySQL  localhost:33060+ ssl  test  JS > shell.connect('mysqlx://admin@192.168.100.20:33060')
      Creating an X protocol session to 'admin@192.168.100.20:33060'
      Please provide the password for 'admin@192.168.100.20:33060': ****
      Fetching schema names for autocompletion... Press ^C to stop.
      Closing old connection...
      Your MySQL connection id is 30 (X protocol)
      Server version: 8.0.18-9 Percona XtraDB Cluster (GPL), Release rel9, Revision 94ca2ae, WSREP version 26.4.3
      No default schema selected; type \use <schema> to set one.
      <Session:admin@192.168.100.20:33060>
       MySQL  192.168.100.20:33060+ ssl  JS > \sql
      Switching to SQL mode... Commands end with ;
       MySQL  192.168.100.20:33060+ ssl  SQL > \use test
      Default schema set to `test`.
      Fetching table and column names from `test` for auto-completion... Press ^C to stop.
       MySQL  192.168.100.20:33060+ ssl  test  SQL > select * from t1;
      Empty set (0.0016 sec)
       MySQL  192.168.100.20:33060+ ssl  test  SQL >
      

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  kenn.takara Kenn Takara
                  Reporter:
                  ramesh.sivaraman Ramesh Sivaraman
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  2 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 6 hours
                    6h