Details
- 
    Bug 
- 
    Status: Open (View Workflow)
- 
    Major 
- 
    Resolution: Unresolved
- 
    10.4.10
- 
    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]> 
 |