Details
-
Bug
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
10.3.5, 10.6
-
None
Description
my engine switched automatically on SPIDER from RocksDB
from the start we have :
show create table ts_value_general_int\G
|
*************************** 1. row *************************** |
Table: ts_value_general_int
|
Create Table: CREATE TABLE `ts_value_general_int` (
|
`id_mysql_server` int(11) NOT NULL, |
`id_ts_variable` int(11) NOT NULL, |
`date` datetime NOT NULL,
|
`value` bigint(20) unsigned NOT NULL, |
PRIMARY KEY (`date`,`id_mysql_server`,`id_ts_variable`)
|
) ENGINE=ROCKSDB DEFAULT CHARSET=latin1
|
PARTITION BY RANGE (to_days(`date`))
|
SUBPARTITION BY HASH (`id_ts_variable`)
|
SUBPARTITIONS 10 |
(PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = ROCKSDB, |
PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = ROCKSDB) |
1 row in set, 40 warnings (0.001 sec) |
at begining i would to add to my my.cnf
esysteme1.replicate-rewrite-db="wiki->esysteme1_wiki" |
esysteme1.replicate-rewrite-db="mantis->esysteme1_mantis" |
esysteme1.replicate-do-db="esysteme1_wiki" |
esysteme1.replicate-do-db="esysteme1_mantis" |
esysteme1.replicate-ignore-db="mysql" |
I was lazy to export / import so I switched off mysql and changed name of directory : (ok it's was a bad idea)
wiki => esysteme1_wiki
mantis => esysteme1_mantis
i reboot blablabla and :
in my error.log :
2018-02-28 21:34:01 36 [Warning] Access denied for user ''@'localhost' (using password: NO) |
2018-02-28 21:34:01 37 [Warning] Access denied for user ''@'localhost' (using password: NO) |
2018-02-28 21:34:01 38 [Warning] Access denied for user ''@'localhost' (using password: NO) |
2018-02-28 21:34:01 39 [Warning] Access denied for user ''@'localhost' (using password: NO) |
2018-02-28 21:34:01 40 [Warning] Access denied for user ''@'localhost' (using password: NO) |
from my application :
Unable to connect to foreign data source: localhost
i look what i have in my table :
select * from ts_value_general_int;
ERROR 1429 (HY000): Unable to connect to foreign data source: localhost
show create table ts_value_general_int\G
|
*************************** 1. row *************************** |
Table: ts_value_general_int
|
Create Table: CREATE TABLE `ts_value_general_int` (
|
`id_mysql_server` int(11) NOT NULL, |
`id_ts_variable` int(11) NOT NULL, |
`date` datetime NOT NULL,
|
`value` bigint(20) unsigned NOT NULL, |
PRIMARY KEY (`date`,`id_mysql_server`,`id_ts_variable`)
|
) ENGINE=SPIDER DEFAULT CHARSET=latin1
|
PARTITION BY RANGE (to_days(`date`))
|
SUBPARTITION BY HASH (`id_ts_variable`)
|
SUBPARTITIONS 10 |
(PARTITION `p737119` VALUES LESS THAN (737119) ENGINE = ROCKSDB, |
PARTITION `p737120` VALUES LESS THAN (737120) ENGINE = ROCKSDB) |
1 row in set, 40 warnings (0.001 sec) |
my engine switched automatically on SPIDER from RocksDB xD
the more strange bug I saw
normally if you try to create this table you get :
ERROR 1497 (HY000): The mix of handlers in the partitions is not allowed in this version of MariaDB