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

Thread stuck while executing an Alter table query while there was short network outage at mariaDB server and recovery

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Won't Do
    • 1.5.9
    • N/A
    • Failover
    • None

    Description

      Thread stuck while executing an Alter table query while there was short network outage at mariaDB server and recovered in few mins. While all other query execution failed with Connection reset and EOF stream exceptions, the Alter table(to add partitions) usually gets stuck(we noticed this usually happens with this query).

      runnable [0x00007f6e169ea000]
      java.lang.Thread.State: RUNNABLE
      at java.net.SocketInputStream.socketRead0(Native Method)
      at java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
      at java.net.SocketInputStream.read(SocketInputStream.java:171)
      at java.net.SocketInputStream.read(SocketInputStream.java:141)
      at java.io.BufferedInputStream.fill(BufferedInputStream.java:246)
      at java.io.BufferedInputStream.read1(BufferedInputStream.java:286)
      at java.io.BufferedInputStream.read(BufferedInputStream.java:345)

      • locked <0x000000008bb97930> (a org.mariadb.jdbc.internal.stream.MariaDbBufferedInputStream)
        at org.mariadb.jdbc.internal.packet.read.ReadPacketFetcher.getReusableBuffer(ReadPacketFetcher.java:176)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1051)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1031)
        at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:152)
        at org.mariadb.jdbc.MariaDbStatement.executeInternal(MariaDbStatement.java:246)
        at org.mariadb.jdbc.MariaDbStatement.execute(MariaDbStatement.java:302)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.apache.commons.dbcp.DelegatingStatement.execute(DelegatingStatement.java:264)
        at org.springframework.jdbc.core.JdbcTemplate$1ExecuteStatementCallback.doInStatement(JdbcTemplate.java:422)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:381)
        at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:431)

      Would like to know if this is expected?

      Few other info:
      There is only connectTimeout configured.
      We are considering configuring a socketTimeout and also upgrading the connector.

      Attachments

        Activity

          People

            diego dupin Diego Dupin
            mariadbuser Mohamed Ismail
            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.