[MXS-593] Load data local infile returns before completion Created: 2016-02-29  Updated: 2016-03-02  Resolved: 2016-03-02

Status: Closed
Project: MariaDB MaxScale
Component/s: galeramon, mariadbbackend, readwritesplit
Affects Version/s: 1.3.0
Fix Version/s: 1.3.0

Type: Bug Priority: Major
Reporter: ThomasStrang Assignee: Timofey Turenko
Resolution: Not a Bug Votes: 0
Labels: None
Environment:

3.10.0-327.10.1.el7.x86_64 #1 SMP Tue Feb 16 17:03:50 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux

Attachments: File Appearances.csv     File testing.sql    
Issue Links:
Relates
relates to MXS-365 Load data local infile connection abo... Closed

 Description   

Hello,

I believe this is related to previous bug listed @ mxs-365.

Upon using load data local in file the statement returns before the operation has actually completed, please find attached a small sql file testing.sql which demonstrates the problem along with a csv used for testing.

This behaviour is not observed when using a Galera node directly.
Setup is the same as in mxs-365
Please let me know if you need any more info,

Kind Regards,
Thomas Strang

 Comments   
Comment by markus makela [ 2016-03-01 ]

The SQL in question does not necessarily execute on the same node unless done inside a transaction. Please do it inside a transaction or configure only one server into the configuration file. This should rule out node lag as a possible cause.

Comment by ThomasStrang [ 2016-03-01 ]

Hi Markus,

I've done some further testing based on your recommendations and it appears you are right.
For anyone wondering:
works as expected set up with a single node,
works as expected inside a transaction,
and also works as expected using SET SESSION wsrep_sync_wait = 1

seems it's my bad, I think you can close this one, thank you for your time,

Kind Regards
Thomas Strang

Generated at Thu Feb 08 04:00:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.