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

encryption.innodb-remove-encryption failed in buildbot with with timeout in wait condition

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.1, 10.2, 10.3, 10.4, 10.5
    • 10.4, 10.5
    • Tests
    • None

    Description

      http://buildbot.askmonty.org/buildbot/builders/kvm-rpm-centos6-x86/builds/7254

      10.1 26be5072429082e634b8fc1026093709

      encryption.innodb-remove-encryption 'innodb_plugin' w1 [ fail ]
              Test ended at 2018-06-12 11:01:11
       
      CURRENT_TEST: encryption.innodb-remove-encryption
      --- /usr/share/mysql-test/suite/encryption/r/innodb-remove-encryption.result	2018-06-12 09:45:03.000000000 +0300
      +++ /dev/shm/var/1/log/innodb-remove-encryption.reject	2018-06-12 11:01:11.794981207 +0300
      @@ -7,23 +7,23 @@
       
       # Restart server with encryption
       # Wait until encryption threads have encrypted all tablespaces
      +Timeout in wait_condition.inc for SELECT COUNT(*) = 3 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0 AND ROTATING_OR_FLUSHING = 0;
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +2	root	localhost	test	Query	0	init	show full processlist	0.000
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
       NAME
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
       NAME
      -mysql/innodb_table_stats
      -mysql/innodb_index_stats
      -./ibdata1
       # Success!
       SELECT * from t1;
       a	b
       # Now turn off encryption and wait for threads to decrypt all tablespaces
       SET GLOBAL innodb_encrypt_tables = off;
      +Timeout in wait_condition.inc for SELECT COUNT(*) = 3 FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0 AND ROTATING_OR_FLUSHING = 0;
      +Id	User	Host	db	Command	Time	State	Info	Progress
      +2	root	localhost	test	Query	0	init	show full processlist	0.000
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
       NAME
      -mysql/innodb_table_stats
      -mysql/innodb_index_stats
      -./ibdata1
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
       NAME
       # Success!
      @@ -31,9 +31,6 @@
       # Restart server with no encryption setup, there should be no crashes
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION = 0;
       NAME
      -mysql/innodb_table_stats
      -mysql/innodb_index_stats
      -./ibdata1
       SELECT NAME FROM INFORMATION_SCHEMA.INNODB_TABLESPACES_ENCRYPTION WHERE MIN_KEY_VERSION <> 0;
       NAME
       SELECT * from t1;
       
      mysqltest: Result length mismatch
      

      Attachments

        Activity

          People

            thiru Thirunarayanan Balathandayuthapani
            elenst Elena Stepanova
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.