Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Not a Bug
-
2.5.3
-
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
- relates to
-
CONJ-771 enablePacketDebug reset stack when reconnecting
-
- Closed
-