Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.2.0, 1.2.1
-
None
-
Load Balancer:
Centos 7
3.10.0-229.11.1.el7.x86_64 #1 SMP Thu Aug 6 01:06:18 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
DB Servers:
Mariadb 10.0.21-MariaDB-wsrep-log 3 node galera cluster wsrep_25.10.r4144
3.10.0-229.11.1.el7.x86_64 #1 SMP Thu Aug 6 01:06:18 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux
Using readwritesplit router
Load Balancer: Centos 7 3.10.0-229.11.1.el7.x86_64 #1 SMP Thu Aug 6 01:06:18 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux DB Servers: Mariadb 10.0.21-MariaDB-wsrep-log 3 node galera cluster wsrep_25.10.r4144 3.10.0-229.11.1.el7.x86_64 #1 SMP Thu Aug 6 01:06:18 UTC 2015 x86_64 x86_64 x86_64 GNU/Linux Using readwritesplit router
Description
Hello,
When Using Load Data Local to load certain csv files the connection is dropped on both the client and server side and without any data being inserted, I guess it fails before even the first transaction auto commit.
The client receives:
ERROR 2013 (HY000): Lost connection to MySQL server during query
And the server Logs:
150915 14:55:29 [Warning] Aborted connection 566976 to db: 'thomas' user: 'linuxtest' host: '10.98.1.216' (Unknown error)
When issuing the same Load Data Local statement against one of the galera nodes directly all rows are inserted as expected (with expected warnings):
Query OK, 99466 rows affected, 65535 warnings (1.29 sec)
Records: 99466 Deleted: 0 Skipped: 0 Warnings: 213769
Sample CSV file Attached as Appearances.csv (sampled from http://seanlahman.com/baseball-archive/statistics/),
Table Create Statement (innodb):
CREATE TABLE BaseBallTest (id INT(5) PRIMARY KEY AUTO_INCREMENT, yearID INT(5),teamID VARCHAR(10),lgID VARCHAR(10),playerID VARCHAR(15),G_all INT(5),GS INT(5),G_batting INT(5),G_defense INT(5),G_p INT(5),G_c INT(5),G_1b INT(5),G_2b INT(5),G_3b INT(5),G_ss INT(5),G_lf INT(5),G_cf INT(5),G_rf INT(5),G_of INT(5),G_dh INT(5),G_ph INT(5),G_pr INT(5) );
CSV Loaded with:
LOAD DATA LOCAL INFILE 'Appearances.csv' INTO TABLE BaseBallTest FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' IGNORE 1 ROWS (yearID,teamID,lgID,playerID,G_all,GS,G_batting,G_defense,G_p,G_c,G_1b,G_2b,G_3b,G_ss,G_lf,G_cf,G_rf,G_of,G_dh,G_ph,G_pr);
Interestingly I have also tested with a larger csv (about 9MB) consisting of the first 50 or so rows repeating with all values included which completed successfully.
BEGIN Maxscale Config:===================================
[maxscale]
threads=1
[Splitter Service]
type=service
router=readwritesplit
router_options=disable_sescmd_history=true,disable_slave_recovery=true,master_accept_reads=true
servers=server-db1,server-db2,server-db3
user=maxscale-lb
passwd=SCRUBBED
[Splitter Listener]
type=listener
service=Splitter Service
protocol=MySQLClient
port=3306
socket=/tmp/ClusterMaster
[server-db1]
type=server
address=10.98.1.221
port=3306
protocol=MySQLBackend
[server-db2]
type=server
address=10.98.1.222
port=3306
protocol=MySQLBackend
[server-db3]
type=server
address=10.98.1.223
port=3306
protocol=MySQLBackend
[Galera Monitor]
type=monitor
module=galeramon
disable_master_failback=1
monitor_interval=2500
servers=server-db1,server-db2,server-db3
user=maxscale-lb
passwd=SCRUBBED
[CLI]
type=service
router=cli
[CLI Listener]
type=listener
service=CLI
protocol=maxscaled
address=localhost
port=6603
END Maxscale Config:===================================