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
Activity
Project list is replaced by explore page in 4.0. For this bug, I will disable the sort feature in the project list.
This seems to be missing from the release notes.
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.
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
Reporter
Labels
Tested Version/s
Time tracking
Sprint
Fix versions
Affects versions
Priority
