Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Not a Bug
-
Affects Version/s: 10.0.20
-
Fix Version/s: N/A
-
Component/s: Storage Engine - Federated
-
Labels:
-
Environment:Red Hat Enterprise Linux Server release 6.7 (Santiago) / MariaDB 10.0.20
Description
I create some federated tables like below command.
CREATE SERVER 'remote' FOREIGN DATA WRAPPER 'mysql' OPTIONS |
(HOST 'IP address', |
DATABASE 'dbname', |
USER 'root', |
PASSWORD 'password', |
PORT 3306,
|
SOCKET '', |
OWNER 'root'); |
|
CREATE TABLE "table_name" ( |
....
|
) ENGINE=FEDERATED DEFAULT CHARSET=utf8 CONNECTION='remote'; |
Already I created 266 tables, I want to create some more tables.
But I got a error message.
##############################################
|
Lookup Error - MySQL Database Error: Can't create federated table. Foreign data src error: database: 'dbname' username: 'root' hostname: 'ip address'
|
##############################################
|
Already created tables are useable but the new create table command is error.
What's wrong?