Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
3.0.5, 3.0.8
-
None
-
None
-
Server: Standalone 10.5.16 (standalone) on SUSE Linux Enterprise Server 12, or original docker image (10.5.2)
Client: Spring Boot 2.7.4, Java 17, docker image based on Alpine Linux
Description
At the moment I have no further idea how to get closer to the problem. That's why I'm asking here for more ideas.
I have described the problem on Zulip https://mariadb.zulipchat.com/#narrow/stream/118759-general/topic/Connector.2FJ.203.2E0.2E5.20-.20Got.20an.20error.20reading.20communication.20packe/near/304664479
Repeated:
After updating the JDBC driver from 2.7.5 to 3.0.5, I see a problem when updating a simple join table that I unfortunately cannot reproduce locally and on test stages.
The error code on the client side is SQLSTATE(08000), ErrorCode(1220)
Client side:
{{"org.hibernate.engine.jdbc.batch.internal.BatchingBatch","message":"HHH000315: Exception executing batch [java.sql.BatchUpdateException: java.sql.BatchUpdateException: java.sql.SQLNonTransientConnectionException: (conn=167) Socket error], SQL: insert into glaeubiger_gemeinde_bereich_relation (gemeinde_id, bereich_id) values (?, ?)","context":"default"
}}
root cause:
Caused by: java.sql.SQLNonTransientConnectionException: (conn=167) Socket error
at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:291)
at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:357)
at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:842)
at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:758)
at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:677)
at org.mariadb.jdbc.client.impl.StandardClient.executePipeline(StandardClient.java:554)
... 127 common frames omitted
Caused by: java.net.SocketException: Connection reset
at java.base/java.net.SocketInputStream.read(Unknown Source)
at java.base/java.net.SocketInputStream.read(Unknown Source)
at java.base/java.io.FilterInputStream.read(Unknown Source)
at org.mariadb.jdbc.client.socket.impl.ReadAheadBufferedStream.fillingBuffer(ReadAheadBufferedStream.java:93)
at org.mariadb.jdbc.client.socket.impl.ReadAheadBufferedStream.read(ReadAheadBufferedStream.java:66)
at org.mariadb.jdbc.client.socket.impl.PacketReader.readPacket(PacketReader.java:76)
at org.mariadb.jdbc.message.client.PreparePacket.readPacket(PreparePacket.java:63)
at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:819)
... 130 common frames omitted
server side:
[Warning] Aborted connection 167 to db: 'fis' user: 'fis' host: '172.31.148.80' (Got an error reading communication packets)
And today again a problem with the Maria JDBC Driver 3.0.8. Another app, another environment. So far I haven't been able to reproduce this error with a different environment either. The driver was released this year, but I'm surprised that there haven't been any problems with it so far.