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

wsrep_sync_wait does not seem to be working

    XMLWordPrintable

Details

    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

        1. my.cnf
          3 kB
          Sandeep Jangra

        Issue Links

          Activity

            People

              nirbhay_c Nirbhay Choubey (Inactive)
              sandeep Sandeep Jangra
              Votes:
              1 Vote for this issue
              Watchers:
              7 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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