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

The upgrade to ODBC version 3.2.2 has resulted in issues with migration scripts that transfer data from SQL Server to MariaDB.

    XMLWordPrintable

Details

    • Bug
    • Status: Needs Feedback (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.2.2
    • None
    • General
    • None

    Description

      As MariaDB ODBC 3.1 reaches end of life, we have transitioned to version 3.2.2. Subsequently, most of our scripts began failing with the error "A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 0 - The specified network name is no longer available.)"
      The affected scripts are those migrating data from SQL Server to MariaDB via a linked server. The following insert operation fails when executed from SQL Server with a transport level error during the processing of multiple records in a loop, though it succeeds for a single record.

      INSERT INTO MARIADEV.EpmMigrations..RefreshContentIntroduction (CourseId, Purpose, Notice, LegalNotice, LessonMapping, Copyright, Abstract, Objectives, Author, Test, Logo, CustomSectionXML, TransferDte, TransferBy, LoadStatus)
      SELECT ContentId, Purpose, Notice, LegalNotice, LessonMapping, Copyright, Abstract, Objectives, Author, Test, Logo, CAST(CustomSectionXML as nvarchar(max)), GETUTCDATE(), @RunBy, 0
      FROM MARIADEV.EpmMigrations..RefreshPartnerCourses c
      INNER JOIN ContentMaster.dbo.ContentIntroduction i ON (i.ContentId = c.CourseCode OR i.ContentId = c.StandardsCourseCode)
      WHERE c.StandardsCourseCode = @StandardsCourseCode;

      Column data type details:
      ContentMaster.dbo.ContentIntroduction - SQL Server table with all columns as NVARCHAR(MAX), except CustomSectionXML which is of type XML.

      MARIADEV.EpmMigrations..RefreshContentIntroduction - MariaDB table with CourseId as VARCHAR(200), Purpose, Notice, LegalNotice, LessonMapping, Copyright, Abstract, Objectives, Author, Test as TEXT, Logo as VARCHAR(400), CustomSectionXML as LONGTEXT, TransferDte as DATETIME, TransferBy as VARCHAR(11), and Loadstatus as INT.

      Could the issue be due to the driver's overhead when joining MariaDB and SQL Server tables with large data types?

      Attachments

        Activity

          People

            Lawrin Lawrin Novitsky
            Mounika Poosa Mounika Poosa
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

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