Uploaded image for project: 'MariaDB MaxScale'
  1. MariaDB MaxScale
  2. MXS-365

Load data local infile connection abort when loading certain files

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 1.2.0, 1.2.1
    • Fix Version/s: 1.3.0
    • Labels:
      None
    • Environment:

      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:===================================

        Attachments

        1. Appearances.csv
          5.62 MB
        2. Appearances00-116
          64 kB
        3. Appearances00-117
          64 kB
        4. Appearances00-117-all
          66 kB
        5. debug-log-anon.log
          36 kB
        6. trace-log-anon.log
          41 kB

          Issue Links

            Activity

              People

              • Assignee:
                markus makela markus makela
                Reporter:
                ThomasStrang ThomasStrang
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: