New and Improved 3.13 Beta. Highlights: Shareable filters and dashboards and lots of other goodies. Any feedback can be raised as JIRA issues in the JIRA project.
Issue Details (XML | Word | Printable)

Key: JRA-8417
Type: Bug Bug
Status: Resolved Resolved
Resolution: Fixed
Priority: Major Major
Assignee: Anton Mazkovoi [Atlassian]
Reporter: Anton Mazkovoi [Atlassian]
Votes: 0
Watchers: 1
Operations

If you were logged in you would be able to see more operations.
JIRA

Generating ids for database records causes WebSphere to report error

Created: 03/Nov/05 10:49 PM   Updated: 30/Jul/06 07:34 PM
Component/s: Backend / Domain Model
Affects Version/s: 3.3.3
Fix Version/s: 3.4

Time Tracking:
Not Specified

Environment: WebSphere
Issue Links:
Blocker
 

Participants: Ann-Sophie HOCQ, Anton Mazkovoi [Atlassian] and Nick Menere [Atlassian]
Since last comment: 2 years, 30 weeks, 4 days ago
Resolution Date: 03/Nov/05 11:08 PM
Labels:


 Description  « Hide
When generating ids for new database records OfBiz Entity Engine (database communication layer that JIRA uses) issues a SELECT SQL statement on a db connection after a transaction has been committed.

After issuing the SELECT statement, OfBiz returns the connection back to the database connection pool, but without committing a transaction (i.e. without calling comit() on the connection). This is OK as there is no transaction in progress. WebSphere complains about this with the following exception:

[11/2/05 22:32:57:330 CST] 5a310270 LocalTranCoor E WLTC0032E: One or more resources rolled back. An unresolved LocalTransactionContainment had an unresolved action of rollback.
                                                                                                                                                          
[11/2/05 22:32:57:330 CST] 5a310270 WebAppTransac E WTRN0043I: LocalTransaction rolled-back due to setRollbackOnly.
                                                                                                                                                          
[11/2/05 22:32:57:363 CST] 5a310270 WebGroup      E SRVE0026E: [Servlet Error]-[LocalTransaction rolled-back due to setRollbackOnly]: com.ibm.ws.LocalTransaction.RolledbackException
        at com.ibm.ws.LocalTransaction.LocalTranCoordImpl.cleanup(LocalTranCoordImpl.java(Compiled Code))
        at com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvoke(WebAppTransactionCollaborator.java(Compiled Code))
        at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java(Compiled Code))
        at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java(Compiled Code))
        at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java(Compiled Code))
        at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java(Compiled Code))
        at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java(Compiled Code))
        at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java(Compiled Code))
        at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java(Compiled Code))
        at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java(Compiled Code))
        at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java(Compiled Code))
        at com.ibm.ws.http.HttpConnection.run(HttpConnection.java(Compiled Code))
        at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:593)

Fixed by doing a SELECT in its own transaction and keeping WebSphere very happy.

 All   Comments   Work Log   Change History      Sort Order: Ascending order - Click to sort in descending order
[ Permlink | « Hide ]
Ann-Sophie HOCQ added a comment - 25/Jan/06 08:28 AM
Hi,
I think i have this problem (I use WAS 5.1) when I ask JIRA to check integrity on : "jira issues with null status"
See the error page :

System Error

A system error has occurred.

If this problem persists - please notify your JIRA administrator of this problem.

If you are an administrator, please try submitting this problem via the Support Request Page.

Else, please create a support issue on our support system at http://support.atlassian.com with the following information:

1. a description of your problem
2. cut & paste the error and system information found below
3. attach the application server log file

Cause:
javax.servlet.ServletException: LocalTransaction rolled-back due to setRollbackOnly

Stack Trace: [hide]

javax.servlet.ServletException: LocalTransaction rolled-back due to setRollbackOnly
at com.ibm.ws.webcontainer.webapp.WebAppTransactionCollaborator.postInvoke(WebAppTransactionCollaborator.java:267)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.dispatch(WebAppRequestDispatcher.java:794)
at com.ibm.ws.webcontainer.webapp.WebAppRequestDispatcher.forward(WebAppRequestDispatcher.java:201)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.doForward(WebAppInvoker.java:125)
at com.ibm.ws.webcontainer.srt.WebAppInvoker.handleInvocationHook(WebAppInvoker.java:286)
at com.ibm.ws.webcontainer.cache.invocation.CachedInvocation.handleInvocation(CachedInvocation.java:71)
at com.ibm.ws.webcontainer.cache.invocation.CacheableInvocationContext.invoke(CacheableInvocationContext.java:116)
at com.ibm.ws.webcontainer.srp.ServletRequestProcessor.dispatchByURI(ServletRequestProcessor.java:186)
at com.ibm.ws.webcontainer.oselistener.OSEListenerDispatcher.service(OSEListener.java:334)
at com.ibm.ws.webcontainer.http.HttpConnection.handleRequest(HttpConnection.java:56)
at com.ibm.ws.http.HttpConnection.readAndHandleRequest(HttpConnection.java:652)
at com.ibm.ws.http.HttpConnection.run(HttpConnection.java:458)
at com.ibm.ws.util.ThreadPool$Worker.run(ThreadPool.java:912)

Referer URL: http://www-jira.franfi.fr:8207/jiraent/secure/admin/jira/IntegrityChecker!default.jspa

Build Information:
Uptime: 12 heures, 11 minutes, 3 secondes
Edition: Enterprise
Version: 3.4.2
Build Number: 108

Server Information:
Application Server: IBM WebSphere Application Server/5.1
Servlet Version: 2.3

Memory Information:
Total Memory: 512 MB
Free Memory: 155 MB
Used Memory: 357 MB

System Information:
System Date: Wednesday, 25 Jan 2006
System Time: 15:20:49
Java Version: 1.4.2
Java Vendor: IBM Corporation
JVM Version: 1.0
JVM Vendor: Sun Microsystems Inc.
JVM Implementation Version: 1.4.2
Java Runtime: Java(TM) 2 Runtime Environment, Standard Edition
Java VM: Classic VM
User Name: wasservice
User Timezone: Europe/Paris
User Locale: English (United States)
System Encoding: Cp1252
Operating System: Windows 2000 5.0
OS Architecture: x86
Application Server Container: IBM WebSphere Application Server/5.1
Database type: oracle
Database JNDI address: java:comp/env/jdbc/JiraDS

Request Information:
Request URL: http://www-jira.franfi.fr:8207/jiraent/500page.jsp

  • Scheme: http
  • Server: www-jira.franfi.fr
  • Port: 8207
  • URI: /jiraent/500page.jsp
  • - Context Path: /jiraent
  • - Servlet Path: /500page.jsp
  • - Path Info: null
  • - Query String:
    Request Attributes:
  • javax.servlet.error.exception : com.ibm.ws.LocalTransaction.RolledbackException
  • javax.servlet.error.message : LocalTransaction rolled-back due to setRollbackOnly
  • ErrorReport : com.ibm.ws.webcontainer.webapp.WebAppErrorReport: LocalTransaction rolled-back due to setRollbackOnly
  • os_securityfilter_already_filtered : true
  • com.atlassian.jira.web.filters.ActionCleanupDelayFilter : true
  • com.atlassian.johnson.filters.JohnsonFilter_already_filtered : true
  • com.ibm.servlet.engine.webapp.dispatch_nested : true
  • javax.servlet.error.request_uri : /jiraent/secure/admin/jira/IntegrityChecker.jspa
  • javax.servlet.error.status_code : 500
  • _sitemesh_filterapplied : true
  • os_authstatus : null
  • jira.webwork.cleanup : false
  • javax.servlet.error.servlet_name : action
  • com.atlassian.jira.web.filters.gzip.GzipFilter_already_filtered : true
  • javax.servlet.error.exception_type : class com.ibm.ws.LocalTransaction.RolledbackException
  • atlassian.core.seraph.original.url : /secure/admin/jira/IntegrityChecker.jspa
  • loginfilter.already.filtered : true
  • javax.servlet.jsp.jspException : com.ibm.ws.webcontainer.webapp.WebAppErrorReport: LocalTransaction rolled-back due to setRollbackOnly
  • webwork.result : Value stack =========== ===========
  • com.ibm.servlet.engine.webapp.dispatch_type : forward

[ Permlink | « Hide ]
Nick Menere [Atlassian] added a comment - 26/Jan/06 10:27 PM
Ann-Sophie,
Please see me comments on JRA-9146 as to why this is occuring for you. It is to do with Oracle 8's weird join syntax.

Cheers,
Nick
Powered by Atlassian JIRA the Professional Issue Tracker. (Enterprise Edition, Version: 3.13_beta1-#328) - Bug/feature request - Atlassian news - Contact Administrators