Sybase error closing connection: "infected with 10"

XMLWordPrintable

    • Type: Suggestion
    • Resolution: Won't Fix
    • None
    • Component/s: None
    • Environment:

      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:

      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)
....

      In the Sybase logs one sees:

      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

            Assignee:
            Unassigned
            Reporter:
            Jeff Turner
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: