tokudb Startup failed

[王星宇]

Some machines turn on tokudb_directio parameters，can startup ，but other Startup failed

2017-10-17 13:44:00 34884 [ERROR] TokuDB: Cant open rollback

2017-10-17 13:44:00 34884 [ERROR] TokuDB unknown error 22
2017-10-17 13:44:00 34884 [ERROR] Plugin 'TokuDB' init function returned error.
2017-10-17 13:44:00 34884 [ERROR] Plugin 'TokuDB' registration as a STORAGE ENGINE failed.
2017-10-17 13:44:00 34884 [ERROR] Unknown/unsupported storage engine: TokuDB
2017-10-17 13:44:00 34884 [ERROR] Aborting

Specific reference

http://imysql.cn/2014/06/24/migrate-zabbix-db-to-tokudb.shtml

叶总 在my.cnf 里面加上tokudb_directio = 1，就报错… 注释了之后是没问题的，我是直接用的 5.5.40-tokudb-7.5.3-MariaDB 这个版本，剩下的参数都没问题。

[(none)]>show global variables like ‘%tokudb_directio%’
-> ;
+—————–+——-+
| Variable_name | Value |
+—————–+——-+
| tokudb_directio | OFF |
+—————–+——-+
1 row in set (0.00 sec)

17:04:43 [(none)]>set global tokudb_directio=1;
ERROR 1238 (HY000): Variable ‘tokudb_directio’ is a read only variable
[(none)]>

启动时候报错如下：
150105 0:42:16 [Note] /usr/local/mysql/bin/mysqld: Normal shutdown

150105 0:42:16 [Note] Event Scheduler: Purging the queue. 0 events
150105 0:42:16 InnoDB: Starting shutdown…
150105 0:42:17 InnoDB: Shutdown completed; log sequence number 1597939
150105 0:42:17 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

150105 00:42:17 mysqld_safe mysqld from pid file /data/mysql/mysql_3306/data/mysql.pid ended
150105 00:42:18 mysqld_safe Starting mysqld daemon with databases from /data/mysql/mysql_3306/data
150105 0:42:18 InnoDB: The InnoDB memory heap is disabled
150105 0:42:18 InnoDB: Mutexes and rw_locks use GCC atomic builtins
150105 0:42:18 InnoDB: Compressed tables use zlib 1.2.3
150105 0:42:18 InnoDB: Using Linux native AIO
150105 0:42:18 InnoDB: Initializing buffer pool, size = 1.0G
150105 0:42:18 InnoDB: Completed initialization of buffer pool
150105 0:42:18 InnoDB: highest supported file format is Barracuda.
150105 0:42:19 InnoDB: Waiting for the background threads to start
150105 0:42:20 Percona XtraDB (http://www.percona.com) 5.5.40-MariaDB-36.1 started; log sequence number 1597939
150105 0:42:20 [Note] Plugin ‘FEEDBACK’ is disabled.
150105 0:42:20 [ERROR] TokuDB: Cant open rollback

150105 0:42:20 [ERROR] TokuDB unknown error 22
150105 0:42:20 [ERROR] Plugin ‘TokuDB’ init function returned error.
150105 0:42:20 [ERROR] Plugin ‘TokuDB’ registration as a STORAGE ENGINE failed.
150105 0:42:20 [ERROR] Unknown/unsupported storage engine: TokuDB
150105 0:42:20 [ERROR] Aborting

150105 0:42:20 InnoDB: Starting shutdown…
150105 0:42:21 InnoDB: Shutdown completed; log sequence number 1597939
150105 0:42:21 [Note] /usr/local/mysql/bin/mysqld: Shutdown complete

150105 00:42:21 mysqld_safe mysqld from pid file /data/mysql/mysql_3306/data/mysql.pid ended

[王星宇 (wangxingyu03)]

谁来给看看

[Sveta Smirnova (svetasmirnova)]

Thank you for the report.

Which filesystem do you use?

[王星宇 (wangxingyu03)]

After the test, open the tokudb_directio option. SSD can start normally, but PCIE can't start normally

SSD：

Disk /dev/sdb: 2398.6 GB, 2398605017088 bytes
255 heads, 63 sectors/track, 291613 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Sector size (logical/physical): 512 bytes / 512 bytes
I/O size (minimum/optimal): 512 bytes / 512 bytes
Disk identifier: 0x00000000

PCIE：

Disk /dev/dfa1: 3195.9 GB, 3195903410176 bytes
32 heads, 32 sectors/track, 6095702 cylinders
Units = cylinders of 1024 * 512 = 524288 bytes
Sector size (logical/physical): 512 bytes / 4096 bytes
I/O size (minimum/optimal): 4096 bytes / 32768 bytes
Disk identifier: 0x00000000

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PS-3750