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

JDBC connection dropping transaction when connecting to MaxScale directly

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 2.0.4
    • 2.2.0
    • readwritesplit
    • None
    • JDBC Version 1.5.5
      10.1.21-MariaDB-enterprise galera cluster on Linux Ubuntu 14.04.4 LTS
    • 2017-29, 2017-30, 2017-31, 2017-32, 2017-33

    Description

      For an unknown reason, the statement aborts down suddenly with error message (attached in exception.txt)

      On the node associated with the MaxScale there is following error entry:
      Feb 23 12:04:32 mariadbcluster2 mysqld: 2017-02-23 12:04:32
      140255419796224 [warning] aborted connection 11242 to db: 'E2_MC_XX'
      user: 'E2_USER_MC_XX' host: '192.168.22.181' (got error reading
      communication packets)

      In MaxScale log no error messages are written.

      The statements copy PDF documents and images (as a BLOBs) into the corresponding table in a database.

      This PreparedStatement is used:
      INSERT INTO DOCUMENTS
      (DOCUMENT_ID,FILENAME,REMARKS,PARENT_FOLDER_ID,PREVIEW,DOCUMENT,IS_FOLDER,BUZZWORD1,BUZZWORD2,BUZZWORD3,BUZZWORD4,BUZZWORD5,BUZZWORD6,BUZZWORD7,BUZZWORD8,BUZZWORD9,BUZZWORD10,DOCUMENT_TYPE,WAS_EXPORTED,CLIENT_ID,DOCUMENT_BYTE_SIZE,PREVIEW_BYTE_SIZE,IS_SIGNED,DOCUMENTDATE)
      VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)

      The problem occurs randomly, only when this statement is executed. Sometime after 100 inserts, other time after more than 4000 inserts.

      Connects directly to one of the three nodes are running without problems.
      So it seems to be MaxScale problem only.

      Cannot setup MaxScale as readwritesplit since read and write operation would be one transaction (application side!)

      Attachments

        Issue Links

          Activity

            People

              markus makela markus makela
              bruno Bruno Šimić (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 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.