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

Unspecific errors occur in some installations

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Incomplete
    • 3.0.5, 3.0.8
    • N/A
    • 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.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            torsten.liermann Torsten Liermann
            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.