[MDEV-15708] rocksdb.mariadb_plugin fails on winx64, Cannot enable tc-log at run-time Created: 2018-03-28  Updated: 2018-03-28  Resolved: 2018-03-28

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - RocksDB
Affects Version/s: None
Fix Version/s: 10.2.14

Type: Bug Priority: Major
Reporter: Sergei Petrunia Assignee: Sergei Petrunia
Resolution: Fixed Votes: 0
Labels: None


 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,,;



 Comments   
Comment by Sergei Petrunia [ 2018-03-28 ]

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)�

Comment by Sergei Petrunia [ 2018-03-28 ]

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

Comment by Sergei Petrunia [ 2018-03-28 ]

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

Generated at Thu Feb 08 08:23:25 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.