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

Load infile not working on Schemarouter

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 2.0.1, 2.0.4, 2.1.0
    • Fix Version/s: 2.2.0
    • Component/s: schemarouter
    • Labels:
      None
    • Environment:
      Linux 2.6.32-642.6.2.el6.x86_64, CentOS release 6.8 (Final)
    • Sprint:
      2017-30, 2017-31

      Description

      Load Infile is not working when used with SchemaRouter. ERROR 2013 (HY000): Lost connection to MySQL server during query

      On MaxScale log, we see the following:

      2017-03-03 09:32:15 error : [qc_sqlite] The query could not be parsed. Response not valid.
      2017-03-03 09:32:15 error : [qc_sqlite] The provided buffer does not contain a COM_QUERY, but a UNKNOWN MYSQL PA
      CKET TYPE. (subsequent similar messages suppressed for 10000 milliseconds)
      2017-03-03 09:32:15 error : [qc_sqlite] The query could not be parsed. Response not valid. (subsequent similar m
      essages suppressed for 10000 milliseconds)
      2017-03-03 09:32:15 error : [schemarouter] Failed to execute

      Works perfectly when the same operation is used with ReadWriteSplit router.

      It seems similar to MXS-365 (https://mariadb.atlassian.net/browse/MXS-365)

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                markus makela markus makela
                Reporter:
                Sarmento Marcelo
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: