topic HibernateException after upgrade to 5.1: connnection proxy not usable after transaction in Alfresco Archive

HibernateException after upgrade to 5.1: connnection proxy not usable after transaction

rivarola — Wed, 20 Apr 2016 10:17:08 GMT

Hello,We have upgraded from Alfresco Community 4.2-b to 5.1-e and now some errors happen randomly :[font=Courier]2016-04-20 10:22:32,866 ERROR [org.springframework.extensions.webscripts.AbstractRuntime] [http-apr-8080-exec-8] Exception from executeScript - redirecting to status template error: 03200

Re: HibernateException after upgrade to 5.1: connnection proxy not usable after transaction

loftux — Tue, 03 Jan 2017 08:14:45 GMT

Did you ever get a solution for this issue?

I'm seeing the same with 5.2 201612 GA and filed this issue

Alfresco - Alfresco JIRA

Re: HibernateException after upgrade to 5.1: connnection proxy not usable after transaction

aowian — Wed, 15 Mar 2017 18:49:18 GMT

I restarted Alfresco, and the problem stopped temporarily... until it came back randomly.

Before the HibernateException referred to above, I found the following in the logs:
ERROR [repo.transaction.RetryingTransactionHelper] [http-apr-8080-exec-18] Rollback failure. Normal retry behaviour will resume.
java.lang.IllegalStateException: Already value [org.mybatis.spring.SqlSessionHolder@561071fc] for key [org.apache.ibatis.session.defaults.DefaultSqlSessionFactory@29ca37b2] bound to thread [http-apr-8080-exec-18]
...

I wonder if they are related.

Our DBA checked the database, and there were no errors.

This was the sql we think was running when the error occurred:

SELECT  acs.id             AS id            ,         acs.commit_time_ms AS commit_time_ms,         COUNT(acl_id)      AS acl_countFROM    alf_acl_change_set acs         JOIN alf_access_control_list acl         ON                (                         acl.acl_change_set = acs.id                )WHERE   EXISTS        (                 SELECT 1 FROM alf_node admnode WHERE admnode.acl_id = acl.id        )         AND acs.id >= :1        AND acs.id  < :2GROUP BY acs.commit_time_ms,         acs.idORDER BY acs.commit_time_ms ASC,         acs.id ASC

This link makes me think that it could be an Alfresco bug.

Re: HibernateException after upgrade to 5.1: connnection proxy not usable after transaction

anujs1986 — Mon, 11 Jun 2018 10:46:01 GMT

Does anyone got any solution?

Mostly, Its occurring during batch job run.