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

MEDIUMBLOB column update issues

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 1.2.1, 1.3.0
    • Fix Version/s: 1.4.0
    • Component/s: readconnroute
    • Labels:
      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. application.log
          22 kB
        2. maxscale_1_3_beta.zip
          146 kB
        3. maxscale_debug.log
          45 kB
        4. maxscale_error.log
          0.8 kB
        5. maxscale_trace.log
          6 kB
        6. maxscale.cnf
          0.9 kB
        7. server.cnf
          1 kB

          Issue Links

            Activity

              People

              Assignee:
              Unassigned
              Reporter:
              pawel.wysokinski Pawel Wysokinski
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved: