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

Atlassian JIRA | Jeff Turner | 1 decade ago
tip
Do you know that we can give you better hits? Get more relevant results from Samebug’s stack trace search.
  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 | 1 decade 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 | 1 decade 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 )

    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