Sorting Projects list leads to "Transaction was rolled back in a different thread!" and many other errors

Description

On translate.zanata.org (which has a large number of projects), sorting the Projects table (by clicking on a column header) eventually leads to a transaction timeout and many varied errors on subsequent requests, all of which seem to have the same cause.

  • javax.persistence.TransactionRequiredException: No active JTA transaction on joinTransaction call

  • javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff0a196a24:731414b0:57a9f41b:54ed8 status: ActionStatus.ABORTED >

  • org.hibernate.HibernateException: Logical connection is closed

  • org.hibernate.HibernateException: Transaction was rolled back in a different thread!

  • javax.resource.ResourceException: IJ000460: Error checking for a transaction

I think this may be the most important stack trace, because it shows that a richfaces component triggered an in-memory merge sort, during which a database operation was invoked (very bad):

In the short term, I think we need to disable sorting on the projects list.

Environment

None

Activity

Show:
Alex Eng
August 12, 2016, 3:24 AM

Project list is replaced by explore page in 4.0. For this bug, I will disable the sort feature in the project list.

Sean Flanigan
September 3, 2016, 5:53 AM

This seems to be missing from the release notes.

Ding-Yi Chen
September 5, 2016, 12:42 AM

The title of the pull request does not contains ZNTA-1317, thus missed the release notes.

Note for release notes automation:
If the first line of first commit does not contain the Jira issue ID, search for other lines.

Sean Flanigan
September 5, 2016, 12:48 AM

That's true, but the branch name did contain `ZNTA-1317` (which is why JIRA shows it as linked), plus the JIRA issue had the status "Merged".

Assignee

Alex Eng

Reporter

Sean Flanigan

Labels

None

Tested Version/s

None

Time tracking

0m

Sprint

None

Fix versions

Affects versions

Priority

High
Configure