Uploaded image for project: 'MariaDB Connector/ODBC'
  1. MariaDB Connector/ODBC
  2. ODBC-68

[ma-2.0.13][5.6.10]MySQL server has gone away error with larger data sets

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 2.0.12
    • 3.0.1, 2.0.15
    • None
    • Windows 64-bit and 32-bit, but only from a VM

    Description

      We've a table with about 41 columns in Aurora database with varieties of data types. There are only 12 rows in the table; however row-size in few of the row is really large (500MB+). Total data-size is roughly about 1.7GB here (12 rows X 41 columns).

      Same application works fine if I switch to MySQL ODBC driver (any latest version); however with MariaDB ODBC driver I see "MySQL server has gone away" error. Sometime we had also seen "Connection is lost" message in the same case.

      I'm attaching table schema and ODBC traces of both failing MariaDB ODBC driver as well passing MySQL ODBC driver for your reference.

      Attachments

        1. StandAloneRepro.out
          5 kB
        2. StandAloneRepro.cpp
          9 kB
        3. SQL01.txt
          13 kB
        4. screenshot-1.png
          screenshot-1.png
          63 kB
        5. mariadb-connector-odbc-2.0.15-win64.msi
          4.05 MB
        6. mariadb-connector-odbc-2.0.15-win32.msi
          3.95 MB
        7. MariaDB_MySQLServerGoneAway.7z
          25 kB

        Issue Links

          Activity

            People

              Lawrin Lawrin Novitsky
              rdhuvad Rahul Dhuvad
              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.