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

Galera test failure on galera_var_dirty_reads

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.6
    • 10.6
    • Galera, Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-deb-groovy-amd64/builds/1052/steps/mtr-galera/logs/stdio

      galera.galera_var_dirty_reads 'innodb'   w1 [ fail ]
              Test ended at 2021-05-06 16:48:01
       
      CURRENT_TEST: galera.galera_var_dirty_reads
      mysqltest: In included file "./include/galera_wait_ready.inc": 
      included from ./include/wait_wsrep_ready.inc at line 14:
      included from ./include/wait_until_connected_again.inc at line 27:
      included from /usr/share/mysql/mysql-test/suite/galera/t/galera_var_dirty_reads.test at line 65:
      At line 28: "Server did not transition to READY state"
       
      The result from queries just before the failure was:
      < snip >
      1
      SELECT 1 FROM t1;
      1
      1
      SELECT i, variable_name, variable_value FROM t1, information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads" AND i = 1;
      i	variable_name	variable_value
      1	WSREP_DIRTY_READS	ON
      SET @@session.wsrep_dirty_reads=OFF;
      SELECT i, variable_name, variable_value FROM t1, information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads" AND i = 1;
      Got one of the listed errors
      SELECT 1;
      1
      1
      USE information_schema;
      SELECT * FROM information_schema.session_variables WHERE variable_name LIKE "wsrep_dirty_reads";
      VARIABLE_NAME	VARIABLE_VALUE
      WSREP_DIRTY_READS	OFF
      SELECT COUNT(*) >= 10 FROM performance_schema.events_statements_history;
      COUNT(*) >= 10
      1
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            jplindst Jan Lindström (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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