[MXS-3459] Malformed packet SQL=LOAD DATA LOCAL INFILE... ERROR 2027 Created: 2021-03-25 Updated: 2021-04-01 Resolved: 2021-04-01 |
|
| Status: | Closed |
| Project: | MariaDB MaxScale |
| Component/s: | readwritesplit |
| Affects Version/s: | 2.5.9 |
| Fix Version/s: | 2.5.11 |
| Type: | Bug | Priority: | Major |
| Reporter: | Jozef Kováč | Assignee: | markus makela |
| Resolution: | Fixed | Votes: | 0 |
| Labels: | None | ||
| Environment: |
UBUNTU 18.04.5 & RHEL 8.3, MariaDB 10.4.18 |
||
| Attachments: |
|
| Description |
|
LOAD DATA LOCAL INFILE causing error 2027 Malformed packet for one of ours php application. I tryed disable use_sql_variables_in=master or route all queries directly to master using Hintfilter and Consistent Critical Read Filter but with same result. I also run in same issue with maxscale 2.4.17 Log entries(at same time): conf: [master] [slave-1] [Monitor] [Splitter-Service] [ReadWrite-Listener] |
| Comments |
| Comment by markus makela [ 2021-03-25 ] |
|
Can you give us some example SQL that reproduces the problem? With the same table and some dummy data I wasn't able to reproduce the problem. |
| Comment by Jozef Kováč [ 2021-03-26 ] |
|
It happens only for some files, independent of file size or LOAD time, looks similar to https://jira.mariadb.org/browse/MXS-3214 but always for same problematic file. |
| Comment by markus makela [ 2021-03-26 ] |
|
I think that means some of the data in the LOAD DATA LOCAL INFILE is interpreted as a command when it should be interpreted as data. |
| Comment by markus makela [ 2021-03-26 ] |
|
I managed to reproduce this by using a binary file with a certain pattern of bytes. Looking at the code it's clear that the query classifier will process the data even during the LOAD DATA LOCAL INFILE which causes the binary data to be treated as a command instead of just data. This is relatively simple to fix as only parts of the code need to be moved around. From what I can see, there is no current workaround for this apart from loading the data files with a direct connection. |