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

LOAD DATA LOCAL INFILE and changing autocomit causing stuck

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 6.4.2, 6.4.3, 22.08.2
    • 6.4.4, 22.08.3
    • Core
    • None
    • Oracle Linux 8.6 x86_64
    • MXS-SPRINT-171

    Description

      After updating maxscale from 2.5.21 to 6.4.2 some of queries started getting stuck. After reducing queries inside session for purpose of isolating problem we find out that disabling autocommit executing LOAD DATA LOCAL INFILE and enbling again at least twice in single session causing stuck.
      Session is eventually killed after MariaDB backend timeout is reached and returning error code 1927.

      Maxscale configuration, full log at info level and example query added to attachment.

      Attachments

        1. maxscale.cnf
          1 kB
          Jozef Kováč
        2. maxscale.log
          1.58 MB
          Jozef Kováč
        3. test.sql
          0.4 kB
          Jozef Kováč

        Activity

          People

            markus makela markus makela
            lathander Jozef Kováč
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.