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

MEDIUMBLOB column update issues

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 1.2.1, 1.3.0
    • 1.4.0
    • readconnroute
    • None

    Description

      I am experiencing issues when doing update to mediumblobs in the database using MaxScale. Issues might also occur when doing inserts, however I am not able to reliably test it at the moment.
      The blobs are about 600KB in size.

      I verified that the blobs are saved to the database properly. But the application gets weird exceptions on a random basis. Sometimes there can be no exceptions at all.

      Issues do not occur when the application is connecting directly to the master database. Reads are working fine regardless of the connection method.

      I am attaching snips from application and MaxScale logs. It seems that the blob outputs are truncated.

      I am also attaching the database and MaxScale configs. Nothing relevant appears in the database error log.

      MariaDB version is 10.1.10.
      MaxScale version is 1.2.1.
      MaxScale is running on Centos 7, Linux 3.10.0-327.4.5.el7.x86_64 #1 SMP.

      Could it be that those issues are somehow connected to the "LONGBLOB are currently not supported" limitation?

      Please let me know if there is any more info I could provide to shed more light on this issue.

      Attachments

        1. server.cnf
          1 kB
        2. maxscale.cnf
          0.9 kB
        3. maxscale_trace.log
          6 kB
        4. maxscale_error.log
          0.8 kB
        5. maxscale_debug.log
          45 kB
        6. maxscale_1_3_beta.zip
          146 kB
        7. application.log
          22 kB

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. MXS-477 readconnroute misinterprets data as COM_CHANGE_USER

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              pawel.wysokinski Pawel Wysokinski
              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.