Error org.ofbiz.core.entity.GenericTransactionException when trying to reopen any issue

[Detlef Plotzky]

Hello everyone,

Since two days now we get the error message 

"org.ofbiz.core.entity.GenericTransactionException: Commit failed, rollback previously requested by nested transaction."

when anyone tries to reopen an issue. We tested it with several user account on several different issue types. I also restarted jira and the database. No change.

atlassian-jira.log shows:

2019-12-17 06:54:15,982 http-nio-8080-exec-14 ERROR cal 414x233x1 1j21gfr 217.5.151.48,217.5.151.235 /secure/CommentAssignIssue.jspa [c.a.jira.workflow.OSWorkflowManager] Caught exception while attempting to perform action 3 from workflow 51912 on issue 'SVK-3283'
com.atlassian.jira.transaction.TransactionRuntimeException: org.ofbiz.core.entity.GenericTransactionException: Commit failed, rollback previously requested by nested transaction.
at com.atlassian.jira.transaction.TransactionSupportImpl$TransactionImpl.commit(TransactionSupportImpl.java:91)
at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowActionInsideTxn(OSWorkflowManager.java:837)
at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowAction(OSWorkflowManager.java:787)
at com.atlassian.jira.bc.issue.DefaultIssueService.transition(DefaultIssueService.java:492)
at com.atlassian.jira.web.action.issue.CommentAssignIssue.doExecute(CommentAssignIssue.java:161)
... 1 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
... 48 filtered
at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)
... 12 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 58 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 39 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 10 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 26 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 25 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.ofbiz.core.entity.GenericTransactionException: Commit failed, rollback previously requested by nested transaction.
at org.ofbiz.core.entity.TransactionUtil.commitLocalTransaction(TransactionUtil.java:345)
at com.atlassian.core.ofbiz.util.CoreTransactionUtil.commit(CoreTransactionUtil.java:62)
at com.atlassian.jira.transaction.TransactionSupportImpl$TransactionImpl.commit(TransactionSupportImpl.java:86)
... 249 more

Any help is appreciated. 

Thank you in advance.

Sincerely,

Marco

[David Fischer]

Hi Marco,

you need to check if you have any post-function on the Reopen transition. It's likely that you have a post-function that triggers another transition (e.g. transitioning linked issues) and that other transition is failing because of a condition, validator or post-function that fails.

[Detlef Plotzky]

Hi David,

Thank you very much for the hint. We checked our workflow diagrams and introduced a temporary transition from "resolved" to "open" which we adjusted step by step to resemble the existing reopen-issue transition.

The result was:

- When the transition includes the post-function "start new event common issue, which can be edited by listeners" (Startet ein Ereignis  Allgemeines Ereignis, das von Listenern bearbeitet werden kann.) everything works fine.

- When the transition includes the post-function "start new event issue reopened, which can be edited by listeners" (Startet ein Ereignis Vorgang erneut geöffnet, das von Listenern bearbeitet werden kann.) it fails with the error message "org.ofbiz.core.entity.GenericTransactionException: Commit failed, rollback previously requested by nested transaction"

-When the transition includes any postfunktion of the type "start new event....,which can be edited by listeners" other than the one mentioned before it works and shows no error.

Have you any further suggestion where to look for the error? We haven't done any updates or new plugin installations for the last few weeks, so I cannot retrace the cause for this malfunction.

Thank you.

Marco

[David Fischer]

My guess is that you have an event listener for the event that makes the transition fail. Check your event listeners (ScriptRunner for example)

[Marco Caliaro]

Hi David,

I have checked the listeners in our jira and deleted a Gnatt listener (which also showed errors in the log file) but deleting the listener did not change anything concerning the issue.  The other listeners are only internal listeners which cannot be edited.

Here another entry from our atlassian-jira.log when trying to reopen an issue:

2019-12-19 13:05:35,858 http-nio-8080-exec-15 ERROR cal 785x50210x1 1bphn7j 217.5.151.48,217.5.151.235 /secure/CommentAssignIssue.jspa [c.a.jira.workflow.OSWorkflowManager] Caught exception while attempting to perform action 3 from workflow 51405 on issue 'SVK-3239'
com.atlassian.jira.transaction.TransactionRuntimeException: org.ofbiz.core.entity.GenericTransactionException: Commit failed, rollback previously requested by nested transaction.
at com.atlassian.jira.transaction.TransactionSupportImpl$TransactionImpl.commit(TransactionSupportImpl.java:91)
at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowActionInsideTxn(OSWorkflowManager.java:837)
at com.atlassian.jira.workflow.OSWorkflowManager.doWorkflowAction(OSWorkflowManager.java:787)
at com.atlassian.jira.bc.issue.DefaultIssueService.transition(DefaultIssueService.java:492)
at com.atlassian.jira.web.action.issue.CommentAssignIssue.doExecute(CommentAssignIssue.java:161)
... 1 filtered
at com.atlassian.jira.action.JiraActionSupport.execute(JiraActionSupport.java:63)
... 7 filtered
at javax.servlet.http.HttpServlet.service(HttpServlet.java:742)
... 48 filtered
at com.atlassian.greenhopper.jira.filters.ClassicBoardRouter.doFilter(ClassicBoardRouter.java:62)
... 12 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 58 filtered
at com.atlassian.jira.security.JiraSecurityFilter.lambda$doFilter$0(JiraSecurityFilter.java:66)
... 1 filtered
at com.atlassian.jira.security.JiraSecurityFilter.doFilter(JiraSecurityFilter.java:64)
... 39 filtered
at com.atlassian.jira.servermetrics.CorrelationIdPopulatorFilter.doFilter(CorrelationIdPopulatorFilter.java:30)
... 10 filtered
at com.atlassian.web.servlet.plugin.request.RedirectInterceptingFilter.doFilter(RedirectInterceptingFilter.java:21)
... 4 filtered
at com.atlassian.web.servlet.plugin.LocationCleanerFilter.doFilter(LocationCleanerFilter.java:36)
... 26 filtered
at com.atlassian.jira.servermetrics.MetricsCollectorFilter.doFilter(MetricsCollectorFilter.java:25)
... 25 filtered
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624)
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61)
at java.lang.Thread.run(Thread.java:748)
Caused by: org.ofbiz.core.entity.GenericTransactionException: Commit failed, rollback previously requested by nested transaction.
at org.ofbiz.core.entity.TransactionUtil.commitLocalTransaction(TransactionUtil.java:345)
at com.atlassian.core.ofbiz.util.CoreTransactionUtil.commit(CoreTransactionUtil.java:62)
at com.atlassian.jira.transaction.TransactionSupportImpl$TransactionImpl.commit(TransactionSupportImpl.java:86)
... 249 more

We guess it has something to do with this CommentAssignIssue, but unfortunately we do not know how to go on from here.

Thank you,

Marco

[David Fischer]

I guess your next step is Atlassian Support... They might be able to see more in the logs. The error you posted is a consequence of a previous error, they'll be able to look for that.

[Marco Caliaro]

The issue was resolved by deactivation the plugin "Issue Reminders for Jira". After hours of going through the log files , with the help of the support, we just looked for everything which was somehow related to issues. I am not aware of any installations or updates during the last weeks, so I cannot tell how it came to this situation.

Thank you very much,

Marco

[rowusu]

Hej David,

My ofbiz application freezes and hangs after 5-6 when it is started.  Could you please help me solve these bugs. I am running ofbiz 16.11 version

I am having these errors when my ofbiz application is running. 

Error 1

2023-01-05 08:46:11,378 |0:0:0:0-8009-exec-19 |ControlServlet |E| An error occurred, going to the errorPage: /error/error.jsp
2023-01-05 08:46:11,379 |0:0:0:0-8009-exec-19 |TransactionUtil |W| In setTransactionBeginStack a stack placeholder was already in place, here is where the transaction began:
java.lang.Exception: Tx Stack Placeholder
at org.apache.ofbiz.entity.transaction.TransactionUtil.setTransactionBeginStack(TransactionUtil.java:720) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:156) ~[ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.TransactionUtil.begin(TransactionUtil.java:111) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:156) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) ~[ofbiz.jar:?]
at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:984) ~[ofbiz.jar:?]
at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:648) ~[ofbiz.jar:?]
at org.apache.ofbiz.webapp.control.ControlServlet.doGet(ControlServlet.java:210) [ofbiz.jar:?]
at org.apache.ofbiz.product.category.SeoControlServlet.doGet(SeoControlServlet.java:88) [ofbiz.jar:?]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:686) [javax.servlet-api-4.0.0.jar:4.0.0]
at javax.servlet.http.HttpServlet.service(HttpServlet.java:791) [javax.servlet-api-4.0.0.jar:4.0.0]
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:227) [tomcat-catalina-9.0.54.jar:9.0.54]
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:162) [

Error 2

023-01-05 08:47:22,049 |:0:0:0:0-8009-exec-9 |StackTraceElement;@7d39a7a4 |W| deprecated method, please replace as suggested in API Java Doc, and link to OFBIZ-6651
2023-01-05 08:47:22,056 |:0:0:0:0-8009-exec-9 |TransactionUtil |W| In getSetRollbackOnlyCause no stack placeholder was in place, here is the current location:
java.lang.Exception: Current Stack Trace
at org.apache.ofbiz.entity.transaction.TransactionUtil.getSetRollbackOnlyCause(TransactionUtil.java:841) [ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:262) [ofbiz.jar:?]
at org.apache.ofbiz.entity.transaction.TransactionUtil.commit(TransactionUtil.java:235) [ofbiz.jar:?]
at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:165) [ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) [ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) [ofbiz.jar:?]

Error 3

at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) [tomcat-util-9.0.54.jar:9.0.54]
at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) [tomcat-util-9.0.54.jar:9.0.54]
at java.lang.Thread.run(Thread.java:750) [?:1.8.0_333]
2023-01-05 08:47:22,056 |:0:0:0:0-8009-exec-9 |ModelScreen |E| Error rendering screen [component://calis/widget/CalisScreens.xml#HomeScreen]: org.apache.ofbiz.entity.transaction.Generic>
2023-01-05 08:47:22,056 |:0:0:0:0-8009-exec-9 |TransactionUtil |W| Transaction not rolled back, status is STATUS_NO_TRANSACTION
2023-01-05 08:47:22,057 |:0:0:0:0-8009-exec-9 |ControlServlet |E| Error in request handler:
org.apache.ofbiz.widget.renderer.ScreenRenderException: Error rendering screen [component://calis/widget/CalisScreens.xml#HomeScreen]: org.apache.ofbiz.entity.transaction.GenericTransactionException: Rol>
at org.apache.ofbiz.widget.model.ModelScreen.renderScreenString(ModelScreen.java:179) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:136) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.ScreenRenderer.render(ScreenRenderer.java:98) ~[ofbiz.jar:?]
at org.apache.ofbiz.widget.renderer.macro.MacroScreenViewHandler.render(MacroScreenViewHandler.java:157) ~[ofbiz.jar:?]
at org.apache.ofbiz.webapp.control.RequestHandler.renderView(RequestHandler.java:984) ~[ofbiz.jar:?]
at org.apache.ofbiz.webapp.control.RequestHandler.doRequest(RequestHandler.java:648) ~[ofbiz.jar:?]