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

rocksdb.mariadb_plugin fails on winx64, Cannot enable tc-log at run-time

Details

    Description

      After fix for MDEV-14843 Buildbot started to show a failure like this:
      http://buildbot.askmonty.org/buildbot/builders/winx64-packages/builds/7524

      rocksdb.mariadb_plugin                   w4 [ fail ]
              Test ended at 2018-03-27 18:23:22
       
      CURRENT_TEST: rocksdb.mariadb_plugin
      --- D:/winx64-packages/build/src/storage/rocksdb/mysql-test/rocksdb/r/mariadb_plugin.result	2018-03-27 17:39:12.000000000 +0000
      +++ D:\winx64-packages\build\src\storage\rocksdb\mysql-test\rocksdb\r\mariadb_plugin.reject	2018-03-27 18:23:22.677759000 +0000
      @@ -2,6 +2,8 @@
       # MDEV-14843: Assertion `s_tx_list.size() == 0' failed in myrocks::Rdb_transaction::term_mutex
       #
       INSTALL SONAME 'ha_rocksdb';
      +Warnings:
      +Warning	1105	Cannot enable tc-log at run-time. XA features of ROCKSDB are disabled
       CREATE TABLE t1 (i INT) ENGINE=RocksDB;
       insert into t1 values (1);
       connect  con1,localhost,root,,;
      

      Attachments

        Activity

          Investigation...
          Looking on Windows, the server that runs the testcase (added SELECT SLEEP(...) at start):

          MariaDB [(none)]> show plugins;
          +-------------------------------+----------+--------------------+---------+---------+
          | Name                          | Status   | Type               | Library | License |
          +-------------------------------+----------+--------------------+---------+---------+
          | binlog                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |
          | mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |
          | CSV                           | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
          | INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
          | TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
          | USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |
          | InnoDB                        | DISABLED | STORAGE ENGINE     | NULL    | GPL     |
          | INNODB_TRX                    | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_LOCKS                  | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_LOCK_WAITS             | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_CMP                    | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_CMP_RESET              | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_CMPMEM                 | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_CMPMEM_RESET           | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_CMP_PER_INDEX          | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_CMP_PER_INDEX_RESET    | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_BUFFER_PAGE            | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_BUFFER_PAGE_LRU        | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_BUFFER_POOL_STATS      | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_METRICS                | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_FT_DEFAULT_STOPWORD    | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_FT_DELETED             | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_FT_BEING_DELETED       | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_FT_CONFIG              | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_FT_INDEX_CACHE         | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_FT_INDEX_TABLE         | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_TABLES             | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_TABLESTATS         | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_INDEXES            | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_COLUMNS            | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_FIELDS             | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_FOREIGN            | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_FOREIGN_COLS       | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_TABLESPACES        | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_DATAFILES          | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_VIRTUAL            | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_MUTEXES                | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_SYS_SEMAPHORE_WAITS    | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | INNODB_TABLESPACES_ENCRYPTION | DISABLED | INFORMATION SCHEMA | NULL    | BSD     |
          | INNODB_TABLESPACES_SCRUBBING  | DISABLED | INFORMATION SCHEMA | NULL    | BSD     |
          | Aria                          | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |
          | SEQUENCE                      | DISABLED | STORAGE ENGINE     | NULL    | GPL     |
          | FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | user_variables                | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |
          | partition                     | DISABLED | STORAGE ENGINE     | NULL    | GPL     |
          +-------------------------------+----------+--------------------+---------+---------+
          51 rows in set (0.01 sec)
          

          psergei Sergei Petrunia added a comment - Investigation... Looking on Windows, the server that runs the testcase (added SELECT SLEEP(...) at start): MariaDB [(none)]> show plugins; +-------------------------------+----------+--------------------+---------+---------+ | Name | Status | Type | Library | License | +-------------------------------+----------+--------------------+---------+---------+ | binlog | ACTIVE | STORAGE ENGINE | NULL | GPL | | mysql_native_password | ACTIVE | AUTHENTICATION | NULL | GPL | | mysql_old_password | ACTIVE | AUTHENTICATION | NULL | GPL | | CSV | ACTIVE | STORAGE ENGINE | NULL | GPL | | MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL | | MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | MRG_MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL | | CLIENT_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | INDEX_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | TABLE_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | USER_STATISTICS | ACTIVE | INFORMATION SCHEMA | NULL | GPL | | InnoDB | DISABLED | STORAGE ENGINE | NULL | GPL | | INNODB_TRX | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_LOCKS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_LOCK_WAITS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP_RESET | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMPMEM | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMPMEM_RESET | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP_PER_INDEX | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_CMP_PER_INDEX_RESET | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_PAGE | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_PAGE_LRU | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_BUFFER_POOL_STATS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_METRICS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_DEFAULT_STOPWORD | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_DELETED | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_BEING_DELETED | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_CONFIG | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_INDEX_CACHE | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_FT_INDEX_TABLE | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_TABLES | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_TABLESTATS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_INDEXES | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_COLUMNS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_FIELDS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_FOREIGN | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_FOREIGN_COLS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_TABLESPACES | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_DATAFILES | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_VIRTUAL | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_MUTEXES | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_SYS_SEMAPHORE_WAITS | DISABLED | INFORMATION SCHEMA | NULL | GPL | | INNODB_TABLESPACES_ENCRYPTION | DISABLED | INFORMATION SCHEMA | NULL | BSD | | INNODB_TABLESPACES_SCRUBBING | DISABLED | INFORMATION SCHEMA | NULL | BSD | | Aria | ACTIVE | STORAGE ENGINE | NULL | GPL | | PERFORMANCE_SCHEMA | ACTIVE | STORAGE ENGINE | NULL | GPL | | SEQUENCE | DISABLED | STORAGE ENGINE | NULL | GPL | | FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL | | user_variables | DISABLED | INFORMATION SCHEMA | NULL | GPL | | partition | DISABLED | STORAGE ENGINE | NULL | GPL | +-------------------------------+----------+--------------------+---------+---------+ 51 rows in set (0.01 sec)

          On linux:

          +show plugins;
          +Name   Status  Type    Library License
          +binlog ACTIVE  STORAGE ENGINE  NULL    GPL
          +mysql_native_password  ACTIVE  AUTHENTICATION  NULL    GPL
          +mysql_old_password     ACTIVE  AUTHENTICATION  NULL    GPL
          +wsrep  ACTIVE  STORAGE ENGINE  NULL    GPL
          +MyISAM ACTIVE  STORAGE ENGINE  NULL    GPL
          +CSV    ACTIVE  STORAGE ENGINE  NULL    GPL
          +MRG_MyISAM     ACTIVE  STORAGE ENGINE  NULL    GPL
          +MEMORY ACTIVE  STORAGE ENGINE  NULL    GPL
          +CLIENT_STATISTICS      ACTIVE  INFORMATION SCHEMA      NULL    GPL
          +INDEX_STATISTICS       ACTIVE  INFORMATION SCHEMA      NULL    GPL
          +TABLE_STATISTICS       ACTIVE  INFORMATION SCHEMA      NULL    GPL
          +USER_STATISTICS        ACTIVE  INFORMATION SCHEMA      NULL    GPL
          +Aria   ACTIVE  STORAGE ENGINE  NULL    GPL
          +SEQUENCE       DISABLED        STORAGE ENGINE  NULL    GPL
          +PERFORMANCE_SCHEMA     ACTIVE  STORAGE ENGINE  NULL    GPL
          +InnoDB DISABLED        STORAGE ENGINE  NULL    GPL
          +INNODB_TRX     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_LOCKS   DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_LOCK_WAITS      DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_CMP     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_CMP_RESET       DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_CMPMEM  DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_CMPMEM_RESET    DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_CMP_PER_INDEX   DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_CMP_PER_INDEX_RESET     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_BUFFER_PAGE     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_BUFFER_PAGE_LRU DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_BUFFER_POOL_STATS       DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_METRICS DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_FT_DEFAULT_STOPWORD     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_FT_DELETED      DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_FT_BEING_DELETED        DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_FT_CONFIG       DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_FT_INDEX_CACHE  DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_FT_INDEX_TABLE  DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_TABLES      DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_TABLESTATS  DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_INDEXES     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_COLUMNS     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_FIELDS      DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_FOREIGN     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_FOREIGN_COLS        DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_TABLESPACES DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_DATAFILES   DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_VIRTUAL     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_MUTEXES DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_SYS_SEMAPHORE_WAITS     DISABLED        INFORMATION SCHEMA      NULL    GPL
          +INNODB_TABLESPACES_ENCRYPTION  DISABLED        INFORMATION SCHEMA      NULL    BSD
          +INNODB_TABLESPACES_SCRUBBING   DISABLED        INFORMATION SCHEMA      NULL    BSD
          +FEEDBACK       DISABLED        INFORMATION SCHEMA      NULL    GPL
          +user_variables DISABLED        INFORMATION SCHEMA      NULL    GPL
          +partition      DISABLED        STORAGE ENGINE  NULL    GPL
          

          psergei Sergei Petrunia added a comment - On linux: +show plugins; +Name Status Type Library License +binlog ACTIVE STORAGE ENGINE NULL GPL +mysql_native_password ACTIVE AUTHENTICATION NULL GPL +mysql_old_password ACTIVE AUTHENTICATION NULL GPL +wsrep ACTIVE STORAGE ENGINE NULL GPL +MyISAM ACTIVE STORAGE ENGINE NULL GPL +CSV ACTIVE STORAGE ENGINE NULL GPL +MRG_MyISAM ACTIVE STORAGE ENGINE NULL GPL +MEMORY ACTIVE STORAGE ENGINE NULL GPL +CLIENT_STATISTICS ACTIVE INFORMATION SCHEMA NULL GPL +INDEX_STATISTICS ACTIVE INFORMATION SCHEMA NULL GPL +TABLE_STATISTICS ACTIVE INFORMATION SCHEMA NULL GPL +USER_STATISTICS ACTIVE INFORMATION SCHEMA NULL GPL +Aria ACTIVE STORAGE ENGINE NULL GPL +SEQUENCE DISABLED STORAGE ENGINE NULL GPL +PERFORMANCE_SCHEMA ACTIVE STORAGE ENGINE NULL GPL +InnoDB DISABLED STORAGE ENGINE NULL GPL +INNODB_TRX DISABLED INFORMATION SCHEMA NULL GPL +INNODB_LOCKS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_LOCK_WAITS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_CMP DISABLED INFORMATION SCHEMA NULL GPL +INNODB_CMP_RESET DISABLED INFORMATION SCHEMA NULL GPL +INNODB_CMPMEM DISABLED INFORMATION SCHEMA NULL GPL +INNODB_CMPMEM_RESET DISABLED INFORMATION SCHEMA NULL GPL +INNODB_CMP_PER_INDEX DISABLED INFORMATION SCHEMA NULL GPL +INNODB_CMP_PER_INDEX_RESET DISABLED INFORMATION SCHEMA NULL GPL +INNODB_BUFFER_PAGE DISABLED INFORMATION SCHEMA NULL GPL +INNODB_BUFFER_PAGE_LRU DISABLED INFORMATION SCHEMA NULL GPL +INNODB_BUFFER_POOL_STATS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_METRICS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_FT_DEFAULT_STOPWORD DISABLED INFORMATION SCHEMA NULL GPL +INNODB_FT_DELETED DISABLED INFORMATION SCHEMA NULL GPL +INNODB_FT_BEING_DELETED DISABLED INFORMATION SCHEMA NULL GPL +INNODB_FT_CONFIG DISABLED INFORMATION SCHEMA NULL GPL +INNODB_FT_INDEX_CACHE DISABLED INFORMATION SCHEMA NULL GPL +INNODB_FT_INDEX_TABLE DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_TABLES DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_TABLESTATS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_INDEXES DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_COLUMNS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_FIELDS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_FOREIGN DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_FOREIGN_COLS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_TABLESPACES DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_DATAFILES DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_VIRTUAL DISABLED INFORMATION SCHEMA NULL GPL +INNODB_MUTEXES DISABLED INFORMATION SCHEMA NULL GPL +INNODB_SYS_SEMAPHORE_WAITS DISABLED INFORMATION SCHEMA NULL GPL +INNODB_TABLESPACES_ENCRYPTION DISABLED INFORMATION SCHEMA NULL BSD +INNODB_TABLESPACES_SCRUBBING DISABLED INFORMATION SCHEMA NULL BSD +FEEDBACK DISABLED INFORMATION SCHEMA NULL GPL +user_variables DISABLED INFORMATION SCHEMA NULL GPL +partition DISABLED STORAGE ENGINE NULL GPL

          and debugging, I see that when MyRocks plugin is loaded, total_ha_2pc changes from 3 to 4 on Linux, and is 1 on Windows.

          InnoDB is disabled in both cases. This plugin on Linux has no counterpart on Windows:

          +Name   Status  Type    Library License
          +wsrep  ACTIVE  STORAGE ENGINE  NULL    GPL
          

          psergei Sergei Petrunia added a comment - and debugging, I see that when MyRocks plugin is loaded, total_ha_2pc changes from 3 to 4 on Linux, and is 1 on Windows. InnoDB is disabled in both cases. This plugin on Linux has no counterpart on Windows: +Name Status Type Library License +wsrep ACTIVE STORAGE ENGINE NULL GPL

          People

            psergei Sergei Petrunia
            psergei Sergei Petrunia
            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.