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

Replay queries with partially returned results

    XMLWordPrintable

Details

    • MXS-SPRINT-183

    Description

      If a result has been partially sent to the client and the connection is either lost in the middle of it or it ends in a deadlock, the replay is not possible. In certain cases a replay would be possible if the failing result was re-executed and spliced into the existing one.

      A simple byte offset into the latest resultset would be a simple but effective method of detecting which parts have been sent to the client and which parts need to match in order for the replay to be safe.


      Original description:
      SkySQL2 cluster is called customer777-xpand2
      Domain Name is dbswf33330813.syss0001.stage1.skysql.net
      Database is travel

      1. Created database with travel.sql
      2. Added primary key with addPrimaryKey.sql
      3. In session 1 ran sql script t3a.sql to create a stored procedure
      4. In session 1 ran sql script t3arun.sql to run t3a.sql stored procedure
      5. In session 2 ran t4.sql to create a stored procedure and run it

      The following error was displayed in session 1 after a few minutes

      ERROR 1205 (40000) at line 1 in file: 't3arun.sql': [30720] MVCC serializable conflict: This transaction conflicted with a serializable transaction: `travel`.`flights` Primary key: (66773); try restarting transaction

      Attachments

        1. addPrimaryKey.sql
          0.1 kB
          Michael Malgeri
        2. alterTest.py
          0.9 kB
          Michael Malgeri
        3. MXS-4549-apr05-logs.txt
          889 kB
          J Kyle Turner
        4. MXS-4549-log-info.txt
          586 kB
          J Kyle Turner
        5. MXS-4549-mar17-logs.txt
          263 kB
          J Kyle Turner
        6. MXS-4549-no-log-info.txt
          8 kB
          J Kyle Turner
        7. t3a.sql
          0.4 kB
          Michael Malgeri
        8. t3arun.sql
          0.0 kB
          Michael Malgeri
        9. t4.sql
          0.5 kB
          Michael Malgeri
        10. travel.sql
          9.45 MB
          Michael Malgeri
        11. xactionsTest.py
          2 kB
          Michael Malgeri

        Issue Links

          Activity

            People

              markus makela markus makela
              mmalgeri Michael Malgeri (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              6 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.