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

hadoop-hive-user | Nathan Rasch | 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
    4. Apache Derby Client JDBC Driver
      Connection.getAutoCommit
      1. org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      2. org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      3. org.apache.derby.client.am.Connection.getAutoCommit(Unknown Source)
      3 frames
    5. DataNucleus RDBMS plugin
      RDBMSManager.addClasses
      1. org.datanucleus.store.rdbms.AbstractSchemaTransaction.execute(AbstractSchemaTransaction.java:122)
      2. org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:994)
      3. org.datanucleus.store.rdbms.RDBMSManager.addClasses(RDBMSManager.java:960)
      3 frames
    6. DataNucleus Core
      AbstractStoreManager.addClass
      1. org.datanucleus.store.AbstractStoreManager.addClass(AbstractStoreManager.java:691)
      1 frame
    7. org.datanucleus.store
      MappedStoreManager.getDatastoreClass
      1. org.datanucleus.store.mapped.MappedStoreManager.getDatastoreClass(MappedStoreManager.java:358)
      1 frame
    8. DataNucleus RDBMS plugin
      RDBMSManager.getExtent
      1. org.datanucleus.store.rdbms.RDBMSManager.getExtent(RDBMSManager.java:1344)
      1 frame
    9. DataNucleus Core
      ObjectManagerImpl.getExtent
      1. org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3736)
      1 frame
    10. DataNucleus Enhancer
      NucleusJDOHelper.getJDOExceptionForNucleusException
      1. org.datanucleus.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:289)
      1 frame
    11. DataNucleus Core
      ObjectManagerImpl.getExtent
      1. org.datanucleus.ObjectManagerImpl.getExtent(ObjectManagerImpl.java:3741)
      1 frame
    12. DataNucleus RDBMS plugin
      JDOQLQuery.compileInternal
      1. org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compileCandidates(JDOQLQueryCompiler.java:411)
      2. org.datanucleus.store.rdbms.query.QueryCompiler.executionCompile(QueryCompiler.java:312)
      3. org.datanucleus.store.rdbms.query.JDOQLQueryCompiler.compile(JDOQLQueryCompiler.java:225)
      4. org.datanucleus.store.rdbms.query.JDOQLQuery.compileInternal(JDOQLQuery.java:174)
      4 frames
    13. DataNucleus Core
      Query.executeQuery
      1. org.datanucleus.store.query.Query.executeQuery(Query.java:1443)
      1 frame
    14. DataNucleus RDBMS plugin
      JDOQLQuery.executeQuery
      1. org.datanucleus.store.rdbms.query.JDOQLQuery.executeQuery(JDOQLQuery.java:244)
      1 frame
    15. DataNucleus Core
      Query.executeWithArray
      1. org.datanucleus.store.query.Query.executeWithArray(Query.java:1357)
      1 frame
    16. DataNucleus Enhancer
      JDOQuery.execute
      1. org.datanucleus.jdo.JDOQuery.execute(JDOQuery.java:242)
      1 frame
    17. Hive Metastore
      HiveMetaStoreClient.<init>
      1. org.apache.hadoop.hive.metastore.ObjectStore.getMDatabase(ObjectStore.java:283)
      2. org.apache.hadoop.hive.metastore.ObjectStore.getDatabase(ObjectStore.java:301)
      3. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.createDefaultDB(HiveMetaStore.java:147)
      4. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.init(HiveMetaStore.java:119)
      5. org.apache.hadoop.hive.metastore.HiveMetaStore$HMSHandler.<init>(HiveMetaStore.java:101)
      6. org.apache.hadoop.hive.metastore.HiveMetaStoreClient.<init>(HiveMetaStoreClient.java:74)
      6 frames
    18. Hive Query Language
      Hive.getTablesForDb
      1. org.apache.hadoop.hive.ql.metadata.Hive.createMetaStoreClient(Hive.java:828)
      2. org.apache.hadoop.hive.ql.metadata.Hive.getMSC(Hive.java:838)
      3. org.apache.hadoop.hive.ql.metadata.Hive.getTablesForDb(Hive.java:439)
      3 frames