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]>
|