quarkus: Quarkus version change from 2.10.1.Final to 2.11.1.Final has breaking changes with Percona SqlProxy
Describe the bug
Quarkus with hibernate reactive and mysql database configured with a version to 2.11.1 version of quarkus allowed data retrieval from Percona SqlProxy. It worked very well in fact. As of 2.11.1 I’m not able to retrieve data.
Expected behavior
Executing queries writen using hibernate reactive with panache should continue to function as they did in version 2.10.1
Actual behavior
a) on the client Failed to execute statement [select terminalen0_.TERMINAL_ID as terminal1_22_, terminalen0_.COMPANY_ID as company_2_22_, terminalen0_.NAME as name3_22_, terminalen0_.UUID as uuid4_22_ from TERMINAL terminalen0_ where TERMINAL_ID=?]: could not execute query: java.util.concurrent.CompletionException: io.vertx.core.impl.NoStackTraceThrowable: Pending requests failed to be sent due to connection has been closed.
b) on SqlProxy itself
2022-08-19 15:20:29 MySQL_Session.cpp:3364:handler___status_NONE_or_default(): [ERROR] Unexpected packet from client 127.0.0.1 . Session_status: 21 , client_status: 0 Disconnecting it 2022-08-19 15:20:29 MySQL_Session.cpp:149:kill_query_thread(): [WARNING] KILL CONNECTION 1254813 on 10.2.5.21:3306
How to Reproduce?
- configure a mysql cluster with a Percona SqlProxy
- configure a quarkus test to retrieve data via reactive hibernate panache
- use verstion 2.10.1 of quarkus to verify the data is returned.
- upgrade to version 2.11.1 and observer the test will error as above.
Output of uname -a
or ver
Linux locus-dev01 5.4.0-124-generic #140-Ubuntu SMP Thu Aug 4 02:23:37 UTC 2022 x86_64 x86_64 x86_64 GNU/Linux
Output of java -version
openjdk version “11.0.16” 2022-07-19 OpenJDK Runtime Environment (build 11.0.16+8-post-Ubuntu-0ubuntu120.04) OpenJDK 64-Bit Server VM (build 11.0.16+8-post-Ubuntu-0ubuntu120.04, mixed mode, sharing)
GraalVM version (if different from Java)
No response
Quarkus version or git rev
2.11.1
Build tool (ie. output of mvnw --version
or gradlew --version
)
No response
Additional information
Only breaks when going through the percona SqlProxy
About this issue
- Original URL
- State: closed
- Created 2 years ago
- Comments: 41 (22 by maintainers)
@geoand very soon, beginning of next week maybe, right @vietj?
@harpermj66 you’re welcome. Any news from your contacts at Percona? Are they still willing to talk about this?
This might be related to pipelining (https://github.com/eclipse-vertx/vertx-sql-client/pull/1168).
I am trying to reproduce atm