org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.)

Atlassian JIRA | Jeff Turner | 10 years ago
  1. 0

    [JRA-11910] Sybase error closing connection: "infected with 10" - Atlassian JIRA

    atlassian.com | 1 year ago
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.)
  2. 0

    A user reports a problem with Sybase, where JIRA starts up correctly, creating the tables, but breaks on the first actual database update, with errors: {noformat} 2007-01-10 08:50:35,994 http-8080-Processor25 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: I/O Error: DB server closed connection. 2007-01-10 08:50:35,995 http-8080-Processor25 ERROR [module.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153) at org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:291) at org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182) .... {noformat} In the Sybase logs one sees: {noformat} 02:00000:00649:2007/01/09 09:26:56.79 kernel current process (0x565c01f4) infected with 10 02:00000:00649:2007/01/09 09:26:56.85 kernel Address 0x004c49e8 (s_retparams+0xbc), siginfo (code, address) = (1, 0x00000027) 02:00000:00649:2007/01/09 09:26:56.86 kernel ************************************ 02:00000:00649:2007/01/09 09:26:56.86 kernel SQL causing error : UPDATE propertystring SET propertyvalue= @P0 WHERE ID= @P1 ì^V 02:00000:00649:2007/01/09 09:26:56.86 kernel ************************************ 02:00000:00649:2007/01/09 09:26:56.86 server SQL Text: UPDATE propertystring SET propertyvalue= @P0 WHERE ID= @P1 ì^V 02:00000:00649:2007/01/09 09:26:56.86 kernel curdb = 70 tempdb = 2 pstat = 0x10000 02:00000:00649:2007/01/09 09:26:56.86 kernel lasterror = 0 preverror = 0 transtate = 0 02:00000:00649:2007/01/09 09:26:56.86 kernel curcmd = 197 program = jTDS {noformat}

    Atlassian JIRA | 10 years ago | Jeff Turner
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.)
  3. 0

    A user reports a problem with Sybase, where JIRA starts up correctly, creating the tables, but breaks on the first actual database update, with errors: {noformat} 2007-01-10 08:50:35,994 http-8080-Processor25 WARN [NoModule] [SQLProcessor.commit]: SQL Exception occurred on commit. Error was:java.sql.SQLException: I/O Error: DB server closed connection. 2007-01-10 08:50:35,995 http-8080-Processor25 ERROR [module.propertyset.ofbiz.OFBizPropertySet] Error setting value in PropertySet org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153) at org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:291) at org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482) at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428) at com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182) .... {noformat} In the Sybase logs one sees: {noformat} 02:00000:00649:2007/01/09 09:26:56.79 kernel current process (0x565c01f4) infected with 10 02:00000:00649:2007/01/09 09:26:56.85 kernel Address 0x004c49e8 (s_retparams+0xbc), siginfo (code, address) = (1, 0x00000027) 02:00000:00649:2007/01/09 09:26:56.86 kernel ************************************ 02:00000:00649:2007/01/09 09:26:56.86 kernel SQL causing error : UPDATE propertystring SET propertyvalue= @P0 WHERE ID= @P1 ì^V 02:00000:00649:2007/01/09 09:26:56.86 kernel ************************************ 02:00000:00649:2007/01/09 09:26:56.86 server SQL Text: UPDATE propertystring SET propertyvalue= @P0 WHERE ID= @P1 ì^V 02:00000:00649:2007/01/09 09:26:56.86 kernel curdb = 70 tempdb = 2 pstat = 0x10000 02:00000:00649:2007/01/09 09:26:56.86 kernel lasterror = 0 preverror = 0 transtate = 0 02:00000:00649:2007/01/09 09:26:56.86 kernel curcmd = 197 program = jTDS {noformat}

    Atlassian JIRA | 10 years ago | Jeff Turner
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: DB server closed connection.)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    When creating an issue, JIRA hangs. The last message in the logs is: [INFO] StoreFactory - -Initializing WorkflowStore: com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore^M After a log time, the following exception may print in the logs: org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OS_HISTORYSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-00001: unique constraint (JIRA.PK_OS_HISTORYSTEP) violated^M )^M at org.ofbiz.core.entity.jdbc.SQLProcessor.executeUpdate(SQLProcessor.java:341)^M at org.ofbiz.core.entity.GenericDAO.singleInsert(GenericDAO.java:115)^M at org.ofbiz.core.entity.GenericDAO.singleStore(GenericDAO.java:242)^M at org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:285)^M at org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221)^M at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1472)^M at org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1418)^M at com.opensymphony.workflow.spi.ofbiz.OfbizWorkflowStore.moveToHistory(OfbizWorkflowStore.java:283)^M at com.opensymphony.workflow.AbstractWorkflow.createNewCurrentStep(AbstractWorkflow.java:1016)^M at com.opensymphony.workflow.AbstractWorkflow.transitionWorkflow(AbstractWorkflow.java:1327)^M at com.opensymphony.workflow.AbstractWorkflow.doAction(AbstractWorkflow.java:502)^M at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowAction(OSWorkflowManager.java:150)^M at com.atlassian.jira.web.action.workflow.SimpleWorkflowAction.doExecute(SimpleWorkflowAction.java:23)^M at webwork.action.ActionSupport.execute(ActionSupport.java:151)^M

    Atlassian JIRA | 1 decade ago | Jeff Turner
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception while executing the following:INSERT INTO OS_HISTORYSTEP (ID, ENTRY_ID, STEP_ID, ACTION_ID, OWNER, START_DATE, DUE_DATE, FINISH_DATE, STATUS, CALLER) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?) (ORA-00001: unique constraint (JIRA.PK_OS_HISTORYSTEP) violated )
  6. 0

    After 15 days of up time, JIRA hung on us. The login page could be accessed, but nothing else. In the stdout.log were 7 instances of the following exception. I am hypothesizing that there is an issue with the database connection pool (pool configuration is at the bottom of the description). There was little else of note in the logs. Do you have any recommendations for additional DBCP settings, e.g. setting maxWait or tweaking eviction or abandoned settings? 2005-05-24 14:44:58,089 WARN [core.entity.jdbc.SQLProcessor] [SQLProcessor.rollback]: SQL Exception while rolling back insert. Error was:java.sql.SQLException: Invalid state, the Connection object is closed. 2005-05-24 14:44:58,089 WARN [NoModule] org.ofbiz.core.entity.jdbc.SQLProcessor java.sql.SQLException: Invalid state, the Connection object is closed. at net.sourceforge.jtds.jdbc.ConnectionJDBC2.checkOpen(ConnectionJDBC2.java:1164) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.rollback(ConnectionJDBC2.java:1492) at org.apache.commons.dbcp.DelegatingConnection.rollback(DelegatingConnection.java:265) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.rollback(PoolingDataSource.java:333) at org.ofbiz.core.entity.jdbc.SQLProcessor.rollback(SQLProcessor.java:128) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:112) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) at java.lang.ref.Finalizer.access$100(Finalizer.java:14) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) 2005-05-24 14:44:58,089 ERROR [NoModule] Error closing the result, connection, etc in finalize EntityListIterator org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: Socket closed) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:113) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) at java.lang.ref.Finalizer.access$100(Finalizer.java:14) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) java.sql.SQLException: I/O Error: Socket closed at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:1004) at net.sourceforge.jtds.jdbc.TdsCore.submitSQL(TdsCore.java:848) at net.sourceforge.jtds.jdbc.ConnectionJDBC2.commit(ConnectionJDBC2.java:1486) at org.apache.commons.dbcp.DelegatingConnection.commit(DelegatingConnection.java:248) at org.apache.commons.dbcp.PoolingDataSource$PoolGuardConnectionWrapper.commit(PoolingDataSource.java:244) at org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:110) at org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:150) at org.ofbiz.core.entity.jdbc.SQLProcessor.finalize(SQLProcessor.java:668) at java.lang.ref.Finalizer.invokeFinalizeMethod(Native Method) at java.lang.ref.Finalizer.runFinalizer(Finalizer.java:83) at java.lang.ref.Finalizer.access$100(Finalizer.java:14) at java.lang.ref.Finalizer$FinalizerThread.run(Finalizer.java:160) Caused by: java.net.SocketException: Socket closed at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99) at java.net.SocketOutputStream.write(SocketOutputStream.java:136) at java.io.DataOutputStream.write(DataOutputStream.java:85) at net.sourceforge.jtds.jdbc.SharedSocket.sendNetPacket(SharedSocket.java:588) at net.sourceforge.jtds.jdbc.RequestStream.putPacket(RequestStream.java:556) at net.sourceforge.jtds.jdbc.RequestStream.flush(RequestStream.java:504) at net.sourceforge.jtds.jdbc.TdsCore.executeSQL(TdsCore.java:991) ... 11 more DBCP configuration from server.xml: <Resource name="jdbc/JiraDS" auth="Container" type="javax.sql.DataSource"/> <ResourceParams name="jdbc/JiraDS"> <parameter> <name>driverClassName</name> <!-- NOTE: if you change the database type, you will need to change it in atlassian-jira/WEB-INF/classes/entityengine.xml --> <value>net.sourceforge.jtds.jdbc.Driver</value> </parameter> <parameter> <name>url</name> <value>jdbc:jtds:sqlserver://localhost:1433/jiradb</value> </parameter> <parameter> <name>username</name> <value>jira</value> </parameter> <parameter> <name>password</name> <value>jira</value> </parameter> <!-- NOTE: If NOT using hsqldb, comment next two parameters out --> <!-- Give unused connections 4 secs before eviction. --> <!-- <parameter> <name>minEvictableIdleTimeMillis</name> <value>4000</value> </parameter> --> <!-- Check for evictions every 5 secs. --> <!-- <parameter> <name>timeBetweenEvictionRunsMillis</name> <value>5000</value> </parameter> --> <parameter> <name>factory</name> <value>org.apache.commons.dbcp.BasicDataSourceFactory</value> </parameter> </ResourceParams>

    Atlassian JIRA | 1 decade ago | Joshua Spiewak
    org.ofbiz.core.entity.GenericDataSourceException: SQL Exception occurred on commit (I/O Error: Socket closed)

    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.ofbiz.core.entity.GenericDataSourceException

      SQL Exception occurred on commit (I/O Error: DB server closed connection.)

      at org.ofbiz.core.entity.jdbc.SQLProcessor.commit()
    2. org.ofbiz.core
      GenericDelegator.storeAll
      1. org.ofbiz.core.entity.jdbc.SQLProcessor.commit(SQLProcessor.java:116)
      2. org.ofbiz.core.entity.jdbc.SQLProcessor.close(SQLProcessor.java:153)
      3. org.ofbiz.core.entity.GenericDAO.storeAll(GenericDAO.java:291)
      4. org.ofbiz.core.entity.GenericHelperDAO.storeAll(GenericHelperDAO.java:221)
      5. org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1482)
      6. org.ofbiz.core.entity.GenericDelegator.storeAll(GenericDelegator.java:1428)
      6 frames
    3. com.opensymphony.module
      OFBizPropertySet.setImpl
      1. com.opensymphony.module.propertyset.ofbiz.OFBizPropertySet.setImpl(OFBizPropertySet.java:182)
      1 frame