Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
1.2.1
-
None
Description
Using mxs_adapter with -z option
MAxScale 2.3.2
mxs_adapter 1.2.2
ColumnStore 1.2.1
mxs_adapter -c /etc/Columnstore.xml -u cdcuser -p cdc -h ec2-3-16-150-134.us-east-2.compute.amazonaws.com -P 4001 -r 50 -d -n -z -f bank.lst |
The perform insert on source MariaDB Server:
MySQL [bank]> insert into account values (0,1,"test", "0000-00-02") |
-> ;
|
Query OK, 1 row affected (0.035 sec) |
Here is MXS_ADAPTER log
2018-11-29 16:04:56 [bank.client] Read timeout |
2018-11-29 16:04:59 [bank.account] INSERT INTO `bank`.`account` (`account_id`,`district_id`,`frequency`,`a_d`) VALUES (0,1,'test','0-00-02') |
2018-11-29 16:04:59 [bank.account] DML average: 24ms |
2018-11-29 16:05:06 [bank.loan] Read timeout |
Here is the data as it shows on source database, after the insert
MySQL [bank]> insert into account values (0,1,"test", "0000-00-02") |
-> ;
|
Query OK, 1 row affected (0.035 sec) |
MySQL [bank]> select * from account where account_id=0 and a_d = "0000-00-02"; |
+------------+-------------+-----------+------------+
|
| account_id | district_id | frequency | a_d |
|
+------------+-------------+-----------+------------+
|
| 0 | 1 | test | 0000-00-02 | |
+------------+-------------+-----------+------------+
|
1 row in set (0.036 sec) |
Here is how the data shows up on target columnstore database after mxs_adapter has streamed this insert
MariaDB [bank]> select * from account where account_id=0 and a_d = "0000-00-02"; |
+------------+-------------+-----------+------------+
|
| account_id | district_id | frequency | a_d |
|
+------------+-------------+-----------+------------+
|
| 0 | 1 | _CpNoTf_ | 0000-00-02 | |
+------------+-------------+-----------+------------+
|
1 row in set (0.024 sec) |
Notice the column "frequency" in source DB Server is "test" vs "CpNoTf" in columnstore