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

wsrep_sync_wait_upto_gtid not affecting the existing client session

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.4.10
    • 10.4(EOL)
    • Galera
    • None
    • Galera Cluster

    Description

      Hi ,

      I have tested the function wsrep_sync_wait_upto_gtid with MariaDB version 10.4.11 . The function wsrep_sync_wait_upto_gtid is not affecting the existing client session . But, it is working as expected with the new sessions . Is that the expected behaviour . I have attached the screen shot for the better understanding .

      MariaDB [test_fun]> insert into fun_gtid (id) values (26); 
      Query OK, 1 row affected (0.241 sec)
       
      MariaDB [test_fun]> select * from fun_gtid limit 1;
      +------+
      | id   |
      +------+
      |    1 |
      +------+
      1 row in set (0.624 sec)
       
      MariaDB [test_fun]> pager grep -i 'update\|select'
      PAGER set to 'grep -i 'update\|select''
      MariaDB [test_fun]> show processlist;
      | 14 | root        | localhost | test_fun | Query   |   28 | Executing                | select wsrep_sync_wait_upto_gtid('42e8c139-209a-11ea-a359-2bbb061b8859:2767',500) |    0.000 |
      8 rows in set (0.187 sec)
       
      MariaDB [test_fun]> show processlist;
      | 14 | root        | localhost | test_fun | Query   |   32 | Executing                                  | select wsrep_sync_wait_upto_gtid('42e8c139-209a-11ea-a359-2bbb061b8859:2767',500) |    0.000 |
      | 34 | system user |           | NULL     | Sleep   |    0 | Update_rows_log_event::ha_update_row(2767) | update sbtest1 set k = 10                                                         |    0.000 |
      8 rows in set (0.170 sec)
       
      MariaDB [test_fun]> \q  
      Bye
      [root@mydbopslabs22 mysql]# mysql
      uWelcome to the MariaDB monitor.  Commands end with ; or \g.
      Your MariaDB connection id is 37
      Server version: 10.4.11-MariaDB-log MariaDB Server
       
      Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.
       
      sType 'help;' or '\h' for help. Type '\c' to clear the current input statement.
       
      MariaDB [(none)]> use test_fun
      ^[[AReading table information for completion of table and column names
      You can turn off this feature to get a quicker startup with -A
       
      Database changed
      MariaDB [test_fun]> insert into fun_gtid (id) values (26); 
      ERROR 1047 (08S01): WSREP has not yet prepared node for application use
      MariaDB [test_fun]> select * from fun_gtid limit 1;
      ERROR 1047 (08S01): WSREP has not yet prepared node for application use
      MariaDB [test_fun]> 
      

      Attachments

        Activity

          People

            seppo Seppo Jaakola
            hercules7sakthi Sri sakthivel
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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