LOAD DATA LOCAL INFILE "tmp20131.txt.001" REPLACE INTO TABLE point_obs.metar_nc
(date_time,stn,lat,lon,data_source,temp_F,dewpt_F,dir,vrb_wind,speed_mps,gust_mps,slp_mb,altim_mb,visib_m,cld_cover,cavok,precip_type,tmin6_F,tmax6_F,tmin24_F,tmax24_F,snow_mm,snow24_mm,precip_1hr_mm,precip_24hr_mm,weather,waveht_m,wavedir,waveper,sst_F,sensor_status,auto_indicator,raw_metar
in a repeatable way?
b) Are there more than one LOAD DATA INFILE running (the RQG does more than one
in concurrently).
c) Do you have wsrep-load-data-splitting ON or OFF?
@Mark,
a)
Is this reproducible with
LOAD DATA LOCAL INFILE "tmp20131.txt.001" REPLACE INTO TABLE point_obs.metar_nc stn,lat, lon,data_ source, temp_F, dewpt_F, dir,vrb_ wind,speed_ mps,gust_ mps,slp_ mb,altim_ mb,visib_ m,cld_cover, cavok,precip_ type,tmin6_ F,tmax6_ F,tmin24_ F,tmax24_ F,snow_ mm,snow24_ mm,precip_ 1hr_mm, precip_ 24hr_mm, weather, waveht_ m,wavedir, waveper, sst_F,sensor_ status, auto_indicator, raw_metar
(date_time,
in a repeatable way?
b) Are there more than one LOAD DATA INFILE running (the RQG does more than one
in concurrently).
c) Do you have wsrep-load- data-splitting ON or OFF?
d) Can you also share your my.cnf/error log etc.