Comments - Migrating from InfiniDB 4.x to MariaDB ColumnStore
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
We have moved the data1 directory of columnstore 1.0.6 to /tmp instead of removing it.
The data directories(data, data1) of the old and new are the same(after migration).
Actually, we setup two new instance: one is InfiniDB 4.6.6(single mode), the other is columnstore 1.0.6. For the purpose of testing, we just create one table(say, mydb. t192_168_3_215_if011_generic_s_app_host_flow_1hour) in these two instance.
It's OK to create database &table, and can enter mcsmysql console. But can not fetch data from this table after migration( use the old data1).
[root@localhost columnstore]# mcsmysql
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 4
Server version: 10.1.19-MariaDB Columnstore 1.0.6-1
Copyright © 2000, 2016, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
MariaDB [(none)]> use mydb;
Database changed
MariaDB [mydb]> show tables;
+----------------------------------------------------+
+----------------------------------------------------+
+----------------------------------------------------+
1 row in set (0.00 sec)
MariaDB [mydb]> show create table t192_168_3_215_if011_generic_s_app_host_flow_1hour;
`start_time` int(10) unsigned DEFAULT NULL,
`end_time` int(10) unsigned DEFAULT NULL,
`host_value` int(10) unsigned DEFAULT NULL,
`input_octets` int(10) unsigned DEFAULT NULL,
`output_octets` int(10) unsigned DEFAULT NULL,
`total_octets` int(10) unsigned DEFAULT NULL
) ENGINE=Columnstore DEFAULT CHARSET=utf8 COMMENT='schema sync only' |
1 row in set (0.00 sec)
MariaDB [mydb]> select * from t192_168_3_215_if011_generic_s_app_host_flow_1hour;
ERROR 1815 (HY000): Internal error: IDB-2033: Error occurred when calling system catalog.
MariaDB [myb]>
Bugs can be reported in MariaDB Jira: https://jira.mariadb.org (see Reporting Bugs). Please file bugs under the MCOL project.
Please open a BUG in JIRA and you will be able to get support from there. This area is for comments on the document only.
Thanks, David Hill
I retested and could reproduce, there was some missing steps fixing a dbrm file so this was a doc bug. kaifengchen - can you verify?
It's OK now. Thanks.