Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.2.12
-
None
-
Red Hat Enterprise Linux Server release 6.8 (Santiago)
Description
Create table errors while using CONNECT engine. Below are screenshot of CREATE table, SHOW engine and show plugins
------------------------------------------------------
|
mysql> use AUDIT
|
Database changed
|
mysql> CREATE TABLE audit_trail(
|
-> `timestamp` VARCHAR(255),
|
-> `serverhost` VARCHAR(255),
|
-> `username` VARCHAR(255),
|
-> `host` VARCHAR(255),
|
-> `connectionid` VARCHAR(255),
|
-> `queryid` VARCHAR(255),
|
-> `operation` VARCHAR(255),
|
-> `database` VARCHAR(255),
|
-> `object` VARCHAR(255),
|
-> `retcode` VARCHAR(255))
|
-> engine=CONNECT table_type=CSV file_name='/usr/local/mysql2/mariadb-audit.log'
|
-> sep_char=',' quoted=1;
|
ERROR 1286 (42000): Unknown storage engine 'CONNECT'
|
mysql>
|
|
|
mysql> 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 |
|
...
|
..
|
..
|
| SEQUENCE | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| user_variables | ACTIVE | INFORMATION SCHEMA | NULL | GPL |
|
| FEEDBACK | DISABLED | INFORMATION SCHEMA | NULL | GPL |
|
| partition | ACTIVE | STORAGE ENGINE | NULL | GPL |
|
| SERVER_AUDIT | ACTIVE | AUDIT | server_audit.so | GPL |
|
| CONNECT | ACTIVE | STORAGE ENGINE | ha_connect.so | GPL |
|
+-------------------------------+----------+--------------------+-----------------+---------+
|
54 rows in set (0.00 sec)
|
|
|
mysql>
|
|
|
mysql> show engines;
|
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
|
| Engine | Support | Comment | Transactions | XA | Savepoints |
|
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
|
| CSV | YES | CSV storage engine | NO | NO | NO |
|
| MRG_MyISAM | YES | Collection of identical MyISAM tables | NO | NO | NO |
|
| MyISAM | YES | MyISAM storage engine | NO | NO | NO |
|
| SEQUENCE | YES | Generated tables filled with sequential values | YES | NO | YES |
|
| CONNECT | YES | Management of External Data (SQL/NOSQL/MED), including many file formats | NO | NO | NO |
|
| PERFORMANCE_SCHEMA | YES | Performance Schema | NO | NO | NO |
|
| MEMORY | YES | Hash based, stored in memory, useful for temporary tables | NO | NO | NO |
|
| Aria | YES | Crash-safe tables with MyISAM heritage | NO | NO | NO |
|
| InnoDB | DEFAULT | Supports transactions, row-level locking, foreign keys and encryption for tables | YES | YES | YES |
|
+--------------------+---------+----------------------------------------------------------------------------------+--------------+------+------------+
|
9 rows in set (0.00 sec)
|
|
|
mysql>
|
------------------------------------------------------
|
|
Please take a look and let us know if this is issue with MariaDB Server. Installation was done with MariaDB tarball "mariadb-10.2.12-linux-x86_64.tar.gz"
Thank you
Mahalingesh Daddi
mahalingesh.daddi@sabre.com
ph: +91 99454 11991
Can not reproduce it with ubuntu 16.04 and docker image centos 6.8.
Please provide your .cnf file(s) and error.log
MariaDB [AUDIT]> select version();}+-----------------+| version() |+-----------------+| 10.2.12-MariaDB |+-----------------+1 row in set (0.00 sec)MariaDB [AUDIT]> CREATE TABLE audit_trail(-> `timestamp` VARCHAR(255),-> `serverhost` VARCHAR(255),-> `username` VARCHAR(255),-> `host` VARCHAR(255),-> `connectionid` VARCHAR(255),-> `queryid` VARCHAR(255),-> `operation` VARCHAR(255),-> `database` VARCHAR(255),-> `object` VARCHAR(255),-> `retcode` VARCHAR(255))-> engine=CONNECT table_type=CSV file_name='/usr/local/mysql2/mariadb-audit.log'-> sep_char=',' quoted=1;Query OK, 0 rows affected (0.06 sec)