mirromutth/r2dbc-mysql

Error when working with Alicloud RDS MySQL read/write proxy

qiulin opened this issue · 2 comments

I got such error when working with Alicloud RDS MySQL read/write proxy.

io.r2dbc.spi.R2dbcNonTransientResourceException: Unknown message header 0xe and readable bytes is 46 on command phase

r2dbc-mysql: 0.8.2.RELEASE
mysql: 5.6

Error MySql packet:

         +-------------------------------------------------+
         |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
+--------+-------------------------------------------------+----------------+
|00000000| 01 00 00 01 04 17 00 00 02 03 64 65 66 00 00 00 |..........def...|
|00000010| 01 69 00 0c 2d 00 38 00 00 00 fd 00 00 1f 00 00 |.i..-.8.........|
|00000020| 17 00 00 03 03 64 65 66 00 00 00 01 76 00 0c 2d |.....def....v..-|
|00000030| 00 4c 00 00 00 fd 00 00 1f 00 00 17 00 00 04 03 |.L..............|
|00000040| 64 65 66 00 00 00 01 73 00 0c 2d 00 0c 00 00 00 |def....s..-.....|
|00000050| fd 00 00 1f 00 00 17 00 00 05 03 64 65 66 00 00 |...........def..|
|00000060| 00 01 74 00 0c 2d 00 18 00 00 00 fd 00 00 1f 00 |..t..-..........|
|00000070| 00 05 00 00 06 fe 00 00 02 00 2e 00 00 07 0e 52 |...............R|
|00000080| 45 41 44 2d 43 4f 4d 4d 49 54 54 45 44 13 53 6f |EAD-COMMITTED.So|
|00000090| 75 72 63 65 20 64 69 73 74 72 69 62 75 74 69 6f |urce distributio|
|000000a0| 6e 03 43 53 54 06 53 59 53 54 45 4d 05 00 00 08 |n.CST.SYSTEM....|
|000000b0| fe 00 00 02 00                                  |.....           |
+--------+-------------------------------------------------+----------------+

Query:

         +-------------------------------------------------+
         |  0  1  2  3  4  5  6  7  8  9  a  b  c  d  e  f |
+--------+-------------------------------------------------+----------------+
|00000000| 03 53 45 4c 45 43 54 20 40 40 74 78 5f 69 73 6f |.SELECT @@tx_iso|
|00000010| 6c 61 74 69 6f 6e 20 41 53 20 69 2c 20 40 40 76 |lation AS i, @@v|
|00000020| 65 72 73 69 6f 6e 5f 63 6f 6d 6d 65 6e 74 20 41 |ersion_comment A|
|00000030| 53 20 76 2c 20 40 40 73 79 73 74 65 6d 5f 74 69 |S v, @@system_ti|
|00000040| 6d 65 5f 7a 6f 6e 65 20 41 53 20 73 2c 20 40 40 |me_zone AS s, @@|
|00000050| 74 69 6d 65 5f 7a 6f 6e 65 20 41 53 20 74       |time_zone AS t  |
+--------+-------------------------------------------------+----------------+

It maybe a bug of aliyun RDS proxy, and reported to them. Close this issue.