java.sql.SQLException: Connection is broken: Software caused connection abort: recv failed

Pentaho BI Platform Tracking | Jared Pshedesky | 9 years ago
  1. 0

    The server console sits around for a looooooong time and occasionally spews exceptions when you try to shut it down with the shutdown script. Looks like it's trying (and failing) to create connections, which it probably shouldn't be doing on the way down. First exception of many: 08:58:01,062 WARN [LocalManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: org.hsqldb.jdbc.jdbcConnection@6e740a java.sql.SQLException: Connection is broken: Software caused connection abort: recv failed at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:211) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:159) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553) at org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1211) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)

    Pentaho BI Platform Tracking | 9 years ago | Jared Pshedesky
    java.sql.SQLException: Connection is broken: Software caused connection abort: recv failed
  2. 0

    The server console sits around for a looooooong time and occasionally spews exceptions when you try to shut it down with the shutdown script. Looks like it's trying (and failing) to create connections, which it probably shouldn't be doing on the way down. First exception of many: 08:58:01,062 WARN [LocalManagedConnectionFactory] Destroying connection that is not valid, due to the following exception: org.hsqldb.jdbc.jdbcConnection@6e740a java.sql.SQLException: Connection is broken: Software caused connection abort: recv failed at org.hsqldb.jdbc.Util.sqlException(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source) at org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source) at org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435) at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231) at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200) at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:211) at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500) at org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341) at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315) at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396) at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842) at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88) at org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:159) at org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111) at org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553) at org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1211) at org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)

    Pentaho BI Platform Tracking | 9 years ago | Jared Pshedesky
    java.sql.SQLException: Connection is broken: Software caused connection abort: recv failed
  3. 0

    Got the following error on db start up.

    GitHub | 2 years ago | sztankatt
    java.sql.SQLException: Unexpected token: SEARCHNAME in statement [CREATE TABLE savedsearches ( id INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY searchName]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    How to set user classpath precedence when not a mapreduce job?

    Stack Overflow | 3 years ago | user2708246
    java.sql.SQLException: Unexpected token AS, requires ( in statement [create table click as]
  6. 0

    HSQL - Unexpected token: PROCEDURE in statement

    Stack Overflow | 2 years ago | emeraldjava
    org.springframework.jdbc.datasource.init.ScriptStatementFailedException: Failed to execute SQL script statement at line 19 of resource class path resource [hsql/attribution-hsqldb.sql]: CREATE PROCEDURE policy_Attribution(p_valDate Date) MODIFIES SQL DATA BEGIN ATOMIC CREATE TABLE #retvals ( Policy_ID INT, Attribution_Name CHAR(64), Attribution_Type CHAR(20), Risk CHAR(20), Revenue FLOAT, Claims FLOAT ) INSERT INTO #retvals VALUES (1, 'name', 'type', 'risk', 1.5, 1.6) INSERT INTO #retvals VALUES (2, 'name2', 'type2', 'risk2', 0.5, 0.6) INSERT INTO #retvals VALUES (3, 'name3', 'type3', 'risk3', 2.5, 2.6) SELECT * FROM #retvals END

    3 unregistered visitors
    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. java.sql.SQLException

      Connection is broken: Software caused connection abort: recv failed

      at org.hsqldb.jdbc.Util.sqlException()
    2. HSQLDB
      jdbcStatement.execute
      1. org.hsqldb.jdbc.Util.sqlException(Unknown Source)
      2. org.hsqldb.jdbc.jdbcStatement.fetchResult(Unknown Source)
      3. org.hsqldb.jdbc.jdbcStatement.execute(Unknown Source)
      3 frames
    3. JBoss Application Server Connector
      WrapperDataSource.getConnection
      1. org.jboss.resource.adapter.jdbc.CheckValidConnectionSQL.isValidConnection(CheckValidConnectionSQL.java:58)
      2. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnectionFactory.isValidConnection(BaseWrapperManagedConnectionFactory.java:435)
      3. org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkValid(BaseWrapperManagedConnection.java:231)
      4. org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.matchManagedConnections(LocalManagedConnectionFactory.java:200)
      5. org.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:211)
      6. org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:500)
      7. org.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)
      8. org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)
      9. org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
      10. org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
      11. org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
      11 frames
    4. quartz
      QuartzSchedulerThread.run
      1. org.quartz.utils.JNDIConnectionProvider.getConnection(JNDIConnectionProvider.java:159)
      2. org.quartz.utils.DBConnectionManager.getConnection(DBConnectionManager.java:111)
      3. org.quartz.impl.jdbcjobstore.JobStoreSupport.getConnection(JobStoreSupport.java:553)
      4. org.quartz.impl.jdbcjobstore.JobStoreTX.acquireNextTrigger(JobStoreTX.java:1211)
      5. org.quartz.core.QuartzSchedulerThread.run(QuartzSchedulerThread.java:233)
      5 frames