Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.12
-
None
Description
We have been trying to test the critical reads that are enabled by 'wsrep_sync_wait' parameter but seems like the results are not deterministic.
Here is the test script:
https://github.com/sjangra-git/galera-tests/blob/master/scripts/test.sh
This test script based out of the following test-case:
https://github.com/MariaDB/server/blob/2783fc7d14bc8ad16acfeb509d3b19615023f47a/mysql-test/suite/galera/t/mysql-wsrep%23201.test#L5
Here is the version info:
MariaDB [(none)]> show variables like 'version%';
|
+-------------------------+---------------------------------+
|
| Variable_name | Value |
|
+-------------------------+---------------------------------+
|
| version | 10.1.12-MariaDB |
|
| version_comment | MariaDB Server |
|
| version_compile_machine | x86_64 |
|
| version_compile_os | Linux |
|
| version_malloc_library | system jemalloc |
|
| version_ssl_library | OpenSSL 1.0.1e-fips 11 Feb 2013 |
|
+-------------------------+---------------------------------+
|
The errors are more prominent when we run the following java test where the connection is persisted, so the queries are being attempted faster:
https://github.com/sjangra-git/galera-tests
Auto-commit is OFF on the servers in the cluster:
MariaDB [(none)]> show global variables like 'autocommit';
|
+---------------+-------+
|
| Variable_name | Value |
|
+---------------+-------+
|
| autocommit | OFF |
|
+---------------+-------+
|
Few runs failed, few passed for the same test:
-bash-4.1$ ./test.sh 10.226.76.38 10.226.76.32
|
val1=5735 val2=5732
|
syn_wait FAILED
|
-bash-4.1$ ./test.sh 10.226.76.38 10.226.76.32
|
-bash-4.1$ ./test.sh 10.226.76.38 10.226.76.32
|
-bash-4.1$ ./test.sh 10.226.76.38 10.226.76.32
|
-bash-4.1$ ./test.sh 10.226.76.38 10.226.76.32
|
-bash-4.1$ ./test.sh 10.226.76.38 10.226.76.32
|
Attachments
Issue Links
- links to