Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-770

[AURORA] - Seeing seemingly random connection resets when using aurora read/write cluster

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Not a Bug
    • 2.5.3
    • N/A
    • aurora
    • None

    Description

      We have recently switched to the MariaDB Java Client for our Aurora RDS cluster to utilize the read/write balancing. However, we occasionally (roughly once a day) see connection reset errors. We enabled `enablePacketDebug` to see if we can find what is causing this, and it seems to be a transition from write to read only. The following are 3 examples of what was executed according to `enablePacketDebug` before the connection reset errors occurred:

      send at -exchange:15913- 2020-03-10T06:45:14.811Z (compressed protocol - packet not compressed)
      3D 00 00 00 00 00 00                                 =......
      39 00 00 00                                          9...
      03 53 45 54 20 53 45 53  53 49 4F 4E 20 54 52 41     .SET SESSION TRA
      4E 53 41 43 54 49 4F 4E  20 49 53 4F 4C 41 54 49     NSACTION ISOLATI
      4F 4E 20 4C 45 56 45 4C  20 52 45 41 44 20 55 4E     ON LEVEL READ UN
      43 4F 4D 4D 49 54 54 45  44                          COMMITTED
       
      read at -exchange:15914- 2020-03-10T06:45:14.812Z (compressed protocol - packet not compressed)
      2C 00 00 01 00 00 00                                 ,......
      28 00 00 01 00 00 00 02  40 00 00 00 1F 00 1D 0C     (.......@.......
      74 78 5F 69 73 6F 6C 61  74 69 6F 6E 0F 52 45 50     tx_isolation.REP
      45 41 54 41 42 4C 45 2D  52 45 41 44                 EATABLE-READ
      

      send at -exchange:279198- 2020-03-10T08:36:38.608Z (compressed protocol - packet not compressed)
      3D 00 00 00 00 00 00                                 =......
      39 00 00 00                                          9...
      03 53 45 54 20 53 45 53  53 49 4F 4E 20 54 52 41     .SET SESSION TRA
      4E 53 41 43 54 49 4F 4E  20 49 53 4F 4C 41 54 49     NSACTION ISOLATI
      4F 4E 20 4C 45 56 45 4C  20 52 45 41 44 20 55 4E     ON LEVEL READ UN
      43 4F 4D 4D 49 54 54 45  44                          COMMITTED
       
      read at -exchange:279199- 2020-03-10T08:36:38.609Z (compressed protocol - packet not compressed)
      2C 00 00 01 00 00 00                                 ,......
      28 00 00 01 00 00 00 02  40 00 00 00 1F 00 1D 0C     (.......@.......
      74 78 5F 69 73 6F 6C 61  74 69 6F 6E 0F 52 45 50     tx_isolation.REP
      45 41 54 41 42 4C 45 2D  52 45 41 44                 EATABLE-READ
      

      send at -exchange:115923- 2020-03-10T08:37:50.187Z (compressed protocol - packet not compressed)
      3D 00 00 00 00 00 00                                 =......
      39 00 00 00                                          9...
      03 53 45 54 20 53 45 53  53 49 4F 4E 20 54 52 41     .SET SESSION TRA
      4E 53 41 43 54 49 4F 4E  20 49 53 4F 4C 41 54 49     NSACTION ISOLATI
      4F 4E 20 4C 45 56 45 4C  20 52 45 41 44 20 55 4E     ON LEVEL READ UN
      43 4F 4D 4D 49 54 54 45  44                          COMMITTED
       
      read at -exchange:115924- 2020-03-10T08:37:50.190Z (compressed protocol - packet not compressed)
      2C 00 00 01 00 00 00                                 ,......
      28 00 00 01 00 00 00 02  40 00 00 00 1F 00 1D 0C     (.......@.......
      74 78 5F 69 73 6F 6C 61  74 69 6F 6E 0F 52 45 50     tx_isolation.REP
      45 41 54 41 42 4C 45 2D  52 45 41 44                 EATABLE-READ
      

      any help with this would be highly appreciated.

      Attachments

        Issue Links

          Activity

            People

              diego dupin Diego Dupin
              kartoffelsup M Z
              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.