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

WSREP has not yet prepared node for application use error

Details

    Description

      Contains following Galera fixes:

      • MW-405 Make sure wsrep is ready in wait_until_connected_again.inc
        • wait_until_connected_again issues 'SHOW STATUS' query repeatedlyuntil mysqld replies without errors. However, SHOW STATUS is treated specially by wsrep in that it is allowed to proceed even if wsrep is not yet in ready state. As a consequence, after returning from wait_until_connected_again, wsrep may not be ready yet and subsequent queries may fail with error "1047 WSREP has not yet prepared node for application use". To avoid those errors, the patch includes wait_wsrep_ready.inc at the end of the wait_until_connected_again.inc
        • kill_galera.inc can no longer rely on wait_until_connected_again.inc. This is because wait_until_connected_again now tries to make sure that the server it is connected eventually transition to ready state. Whereas some tests may need to kill galera while the server is in a non-primary view.
      • MW-408 Fix 'WSREP error while trying to determine node state'
        • mysql-test-run.pl sporadically reports 'WSREP error while trying to determine node state' right after starting servers for test execution. This happens because we try to execute a SELECT statement that queries the current value of status variable wsrep_ready. If this statement fails, the above message is reported. The failure is due to fact that wsrep may return error ER_LOCK_WAIT_TIMEOUT (on any SELECT statement) if it is not ready and wsrep_sync_wait enabled for SELECTs. The fix is to disable wsrep_sync_wait for the session that issues those SELECT statements.

      Attachments

        Issue Links

          Activity

            jplindst Jan Lindström (Inactive) added a comment - https://github.com/MariaDB/server/commit/de43b0ef6af04e672a1f2cb72e0fa4ad32d43e33 Branch: bb-10.0-galera

            Latest known failure in galera.wan like

            galera.galera_wan 'xtradb'               w4 [ fail ]
                    Test ended at 2017-12-09 07:51:24
             
            CURRENT_TEST: galera.galera_wan
             
             
            Could not execute 'check-testcase' before testcase 'galera.galera_wan' (res: 1):
            mysqltest: Logging to '/dev/shm/var/4/tmp/check-mysqld_3.log'.
            mysqltest: Results saved in '/dev/shm/var/4/tmp/check-mysqld_3.result'.
            mysqltest: Connecting to server localhost:16062 (socket /dev/shm/var/tmp/4/mysqld.3.sock) as 'root', connection 'default', attempt 0 ...
            mysqltest: ... Connected.
            mysqltest: Start processing test commands from './include/check-testcase.test' ...
            mysqltest: At line 78: query 'call mtr.check_testcase()' failed: 1047: WSREP has not yet prepared node for application use
            not ok
            mysqltest failed but provided no output
            

            See http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/3375/steps/mtr/logs/stdio

            jplindst Jan Lindström (Inactive) added a comment - Latest known failure in galera.wan like galera.galera_wan 'xtradb' w4 [ fail ] Test ended at 2017-12-09 07:51:24   CURRENT_TEST: galera.galera_wan     Could not execute 'check-testcase' before testcase 'galera.galera_wan' (res: 1): mysqltest: Logging to '/dev/shm/var/4/tmp/check-mysqld_3.log'. mysqltest: Results saved in '/dev/shm/var/4/tmp/check-mysqld_3.result'. mysqltest: Connecting to server localhost:16062 (socket /dev/shm/var/tmp/4/mysqld.3.sock) as 'root', connection 'default', attempt 0 ... mysqltest: ... Connected. mysqltest: Start processing test commands from './include/check-testcase.test' ... mysqltest: At line 78: query 'call mtr.check_testcase()' failed: 1047: WSREP has not yet prepared node for application use not ok mysqltest failed but provided no output See http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-x86/builds/3375/steps/mtr/logs/stdio

            serg,

            I've added some notes to the patch, and am now assigning it to you as discussed. If you don't want to look at it until the notes are addressed, please just give it straight back to jplindst.

            elenst Elena Stepanova added a comment - serg , I've added some notes to the patch, and am now assigning it to you as discussed. If you don't want to look at it until the notes are addressed, please just give it straight back to jplindst .
            jplindst Jan Lindström (Inactive) added a comment - https://github.com/MariaDB/server/commit/4dfd2a9adbf26b12c828ec2616a36ae1fd8d3e69

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.