Documentation for JIRA 4.1. Documentation for other versions of JIRA is available too.

Skip to end of metadata
Go to start of metadata
2007-09-26 08:14:31,033 INFO  [STDOUT] 08:14:31,030 ERROR
[SimpleWorkflowManager] An exception occurred
org.ofbiz.core.entity.GenericTransactionException: Error occurred
while starting transaction. (Cannot change transaction isolation level in the middle of a transaction.)
       at org.ofbiz.core.entity.TransactionUtil.beginLocalTransaction(
       at com.atlassian.core.ofbiz.util.CoreTransactionUtil.begin(
       at com.atlassian.jira.workflow.SimpleWorkflowManager.doWorkflowAction(
       at com.atlassian.jira.workflow.WorkflowTransitionUtilImpl.progress(
       at com.atlassian.jira.web.action.workflow.SimpleWorkflowAction.doExecute(
       at webwork.action.ActionSupport.execute(
caused by: org.postgresql.util.PSQLException: Cannot change transaction isolation level in the middle of a transaction.
       at org.postgresql.jdbc2.AbstractJdbc2Connection.setTransactionIsolation(
       at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcTransactionIsolation(
       at org.jboss.resource.adapter.jdbc.WrappedConnection.setTransactionIsolation(
       at org.ofbiz.core.entity.TransactionUtil.beginLocalTransaction(
       at com.atlassian.core.ofbiz.util.CoreTransactionUtil.begin(

After much pain it appears that the datasource configuration had the following:

<new-connection-sql>select 1</new-connection-sql>
<check-valid-connection-sql>select 1</check-valid-connection-sql>

Which for some reason seems to be being run within the same transaction as the client code - "fixing" the isolation level.

I tried to raise a bug at or comment on this one (that was the only one I could find that seemed to be similar) but after a long and drawn out fight with the registration system was unable to log in to it.

Status: has not been reproduced and tested internally but has fixed problem for two customers.
Noticed with:
JIRA 3.8.1 Enterprise: compiled as an ear with plugins for SVN and SVN-commit
JBoss 4.0.5 GA installed with JEMS for EJB3
PostgreSQL 8.1.8
References: this forum post - this JBoss bug
Support Ref: JSP-14364

  • No labels