topic Problem 'Connection is invalid.' on Activiti DB in Alfresco Archive

Problem 'Connection is invalid.' on Activiti DB

timo_rohrberg — Fri, 05 Aug 2016 14:14:57 GMT

Hello everybody,I'm addressing you guys today with a problem that we unfortunately cannot solve even though investigating and trying different configuration parameters to an unknow extent.When setting our system internally using the Activiti workflow engine under heavy load, we get the error "Connec

Re: Problem 'Connection is invalid.' on Activiti DB

trademak — Wed, 10 Aug 2016 19:18:10 GMT

Hi Timo,

Which connection pool are you using? The connection pool should be able to test the connection before it's provided to be used by the Activiti Engine.

Best regards,

Re: Problem 'Connection is invalid.' on Activiti DB

timo_rohrberg — Thu, 11 Aug 2016 06:55:17 GMT

Hello Tijs,

thank you for your reply. We are just using the built-in connection pool of the MyBatis 3.3.0 which is drawn-in via the dependencies of the Activiti Engine. From what our analysis of the log files so far revealed, we think that the connection is already provided to the Activiti Engine by the connection pool and then the Activiti thread holding that connection does not get to run early enough. When the OS scheduler make the thread executing, the connection is already invalid.

Do you have any idea what can be done in those situations? Or is that just a bottleneck in the execution performance that we need address in different ways?

We appreciate any hint…

Best regards
Timo Rohrberg