org.apache.derby.client.am.SqlException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message

hadoop-hive-user | Zheng Shao | 7 years ago
  1. 0

    RE: javax.jdo.JDODataStoreException

    hadoop-hive-user | 7 years ago | Nathan Rasch
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
  2. 0

    Re: javax.jdo.JDODataStoreException

    hadoop-hive-user | 7 years ago | Zheng Shao
    org.apache.derby.client.am.SqlException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
  3. 0

    RE: javax.jdo.JDODataStoreException

    hadoop-hive-user | 7 years ago | Nathan Rasch
    org.apache.derby.client.am.SqlException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Derby out of memory

    Stack Overflow | 3 years ago | user3001676
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message (additional information may be available in the derby.log file on the server)
  6. 0

    The issue arrives when multiple XA transactions are done in parallel and there is either a lock timeout or a lock deadlock detected. When this happens the connection is leaked in the Glassfish connection pool and the client thread hangs in "org.apache.derby.client.netReply.fill(Reply.java:172)". Shutting down the app server fails because the thread has a lock in "org.apache.derby.client.net.NetConnection40" and another task is calling "org.apache.derby.client.ClientPooledConnection.close(ClientPooledConnection.java:214)" which is waiting for the lock. Killing the appsever using "kill" and then attempting to shutdown Derby network server causes the Network Server to hang. One of the threads hangs waiting for a lock at "org.apache.derby.impl.drda.NeworkServerControlImpl.removeFromSessionTable(NetworkServerControlImpl.java:1525)" and the "main" thread has this locked at "org.apache.derby.impl.drda.NetworkServerControlImpl.executeWork(NetworkServerControlImpl.java:2242)" and it itself is waiting for a lock which belongs to a thread that is stuck at "org.apache.derby.impl.services.locks.ActiveLock.waitForGrant(ActiveLock.java:118) which is in the TIMED_WAITING state. Only by killing the Network Server using "kill" is possible at this point. There are transactions left even though all clients have been removed.

    Apache's JIRA Issue Tracker | 5 years ago | Brett Bergquist
    java.sql.SQLNonTransientConnectionException: A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific conditio n for which there was no architected message (additional information may be available in the derby.log file on the serve r)

    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. org.apache.derby.client.am.SqlException

      A network protocol error was encountered and the connection has been terminated: the requested command encountered an unarchitected and implementation-specific condition for which there was no architected message

      at org.apache.derby.client.am.SqlException.copyAsUnchainedSQLException()
    2. Apache Derby Client JDBC Driver
      DatabaseMetaData.getIndexInfo
      1. org.apache.derby.client.am.SqlException.copyAsUnchainedSQLException(Unknown Source)
      2. org.apache.derby.client.am.Sqlca.chainDeferredExceptionsToAgentOrAsConnectionWarnings(Unknown Source)
      3. org.apache.derby.client.am.Sqlca.getJDBCMessage(Unknown Source)
      4. org.apache.derby.client.am.SqlException.getMessage(Unknown Source)
      5. org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      6. org.apache.derby.client.am.DatabaseMetaData.getIndexInfo(Unknown Source)
      6 frames
    3. DataNucleus RDBMS plugin
      AbstractSchemaTransaction.execute
      1. org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:616)
      2. org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getRDBMSTableIndexInfoForTable(RDBMSSchemaHandler.java:585)
      3. org.datanucleus.store.rdbms.schema.RDBMSSchemaHandler.getSchemaData(RDBMSSchemaHandler.java:202)
      4. org.datanucleus.store.rdbms.table.TableImpl.getExistingCandidateKeys(TableImpl.java:1093)
      5. org.datanucleus.store.rdbms.table.TableImpl.validateCandidateKeys(TableImpl.java:696)
      6. org.datanucleus.store.rdbms.table.TableImpl.validateConstraints(TableImpl.java:398)
      7. org.datanucleus.store.rdbms.table.ClassTable.validateConstraints(ClassTable.java:3214)
      8. org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.performTablesValidation(RDBMSManager.java:2865)
      9. org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.addClassTablesAndValidate(RDBMSManager.java:2595)
      10. org.datanucleus.store.rdbms.RDBMSManager$ClassAdder.run(RDBMSManager.java:2241)
      11. org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:113)
      11 frames