Loading...

XML

Word

Printable

Details

Type: Suggestion
Resolution: Won't Fix
Fix Version/s: None
Component/s: None
Labels:
- affects-server
Environment:

Hide
Sybase version: Adaptive Server Enterprise/12.5.3/EBF 13324 ESD#7/P/Sun_svr4/OS 5.8/ase1253/1951/32-bit/FBO/Fri Mar 24 09:06:38 2006
Character Set = 1, iso_1: ISO 8859-1 (Latin-1) - Western European 8-bit character set.
JIRA running on Sol10/x86.

Show
Sybase version: Adaptive Server Enterprise/12.5.3/EBF 13324 ESD#7/P/Sun_svr4/OS 5.8/ase1253/1951/32-bit/FBO/Fri Mar 24 09:06:38 2006 Character Set = 1, iso_1: ISO 8859-1 (Latin-1) - Western European 8-bit character set. JIRA running on Sol10/x86.

Feedback Policy:

We collect Jira feedback from various sources, and we evaluate what we've collected when planning our product roadmap. To understand how this piece of feedback will be reviewed, see our Implementation of New Features Policy.

Description

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

Attachments

Activity

People

Assignee:: Unassigned

Reporter:: Jeff Turner

Votes:: 0 Vote for this issue

Watchers:: 0 Start watching this issue

Dates

Created:: 10/Jan/2007 10:51 PM

Updated:: 19/Sep/2019 6:03 AM

Resolved:: 10/Jan/2007 10:52 PM