topic Alfresco losing unable to open hiberbate session for transaction in Alfresco Archive

Alfresco losing unable to open hiberbate session for transaction

hsturner — Thu, 08 Dec 2016 19:07:26 GMT

Alfresco runs fun for a couple of weeks to months with no issues then everyone once in a while Alfresco loses the ability to open a connection to its database on the SQL server we have set up for it. Using alfresco community 2016.04 GA, MySQL 5.5, MySQL connector MySQL-connector-java-5.1.32-bin.jar

Re: Alfresco losing unable to open hiberbate session for transaction

kaynezhang — Fri, 09 Dec 2016 02:32:52 GMT

You can try to update MySQL max connections setting .

please refer to MySQL :: MySQL 5.5 Reference Manual :: B.5.2.7 Too many connections

Re: Alfresco losing unable to open hiberbate session for transaction

hsturner — Fri, 09 Dec 2016 15:12:12 GMT

Hi Kayne,

I've already tired that and it still have the issue. The errror actually isn't too many it's it cant open a hibernated database session. So I'm guessing the database connection is going to sleep and alfresco can't wake it up. I'm also looking at it from the MySQL server and network side, trying to eliminate possible causes. So far it is pointing to alfresco or something in alfresco that is causing the issue.

Re: Alfresco losing unable to open hiberbate session for transaction

kaynezhang — Fri, 09 Dec 2016 17:58:27 GMT

Have you tried to change your MySQL connector java to newer version?

Re: Alfresco losing unable to open hiberbate session for transaction

hsturner — Fri, 09 Dec 2016 18:49:23 GMT

I just updated to the MySQL-connector-java-5.1.32-bin.jar which is the one recommended of community 5.1 but will try the mysql-connector-java-5.1.40-bin.jar connector which I think is the most recent. We are scheduling time to update the MySQL server to 5.6 as well. Will let you know if that fixes the problem.