Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Cannot Reproduce
-
2.5.5
-
MXS-SPRINT-121
Description
From Customer
testing MaxScale 10.5.6 and the campaigns table still failed to load. I looked at the columnstore logs and it looked like it imported 0 rows, but it failed somewhere. Couldn't tell where.
I changed the ETL to change text columns to varchar(100) like we do on ColumnStore 1.2.4 and tried again. This worked, the campaigns table data imported without issue. So it seems there is an issue with the implementation of the text data type.
Attachments
Activity
- Can you provide a simple test case that reproduces the problem?
- Does this happen with MaxScale is bypassed and the LOAD DATA LOCAL INFILE is done directly on the server?
1. Here is my test setup. 1 maxscale server over 1 columnstore server. This is just to test this issue.
2. On columnstore server, create table:
3. show create table campaigns_biu;
-------------------------------------------------------------------------------------------------------------------------+
| Table | Create Table |
-------------------------------------------------------------------------------------------------------------------------+
| campaigns_biu | CREATE TABLE `campaigns_biu` ( `description` text DEFAULT NULL ) ENGINE=Columnstore DEFAULT CHARSET=utf8 |
-------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.000 sec)
3. Successfully ran cpimport and LDI from the Columnstore server.
4. Issue reported is its not working when its sent through maxscale server, a table with text data type.
5. But Im having issues when I try to access or send sql statements from the columnstore server to the maxscale server
6. I did add the following to maxscale.cnf enable_root_user=1 and restart maxscale
7 But Im getting this issue when I try to connect to maxscale via mariadb.
mariadb -h 172.30.0.93
ERROR 1045 (28000): Access denied for user 'root'@'::ffff:172.30.0.5' (using password: NO)
So my setup I guess isnt right and could use some help. I didn't located anything in the Docs about how to setup and send sql statments through maxscale.
Does this happen with the latest ColumnStore from 10.5? I tried to reproduce this but I ran into a problem where it crashes with a currently unknown bug.
I cannot reproduce this with the latest MaxScale and ColumnStore releases and since there was a bug that affected older ColumnStore versions, it's likely that this isn't a MaxScale bug. Until we can find a way to reproduce this with the latest versions, I'll resolve this as Cannot Reproduce.
Does this happen when going past MaxScale directly to the database? MaxScale processes the load identically in both cases.
In addition, is this LOAD DATA INFILE or LOAD DATA LOCAL INFILE? The former is processed by the database and MaxScale just routes the query to the current master.
Please also update the issue with what version of MaxScale this happens with.