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
        2. maxscale.log
          1.58 MB
        3. test.sql
          0.4 kB

        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:

              Time Tracking

                Estimated:
                Original Estimate - Not Specified
                Not Specified
                Remaining:
                Remaining Estimate - 0d
                0d
                Logged:
                Time Spent - 7h
                7h

                Git Integration

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