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

Load data local infile connection abort when loading certain files

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.2.0, 1.2.1
    • 1.3.0
    • None

    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

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.