topic Re: Frequent Io exception: Connection reset in Alfresco Archive

Frequent Io exception: Connection reset

mathewvimal — Fri, 09 Aug 2013 16:02:40 GMT

We are seeing the following exception when activiti runs continuously (for about more than 8 hours). Restart would resolve this issue. Has anyone seen similar issues? Is there any DB configuration that could resolve this issue?2013-08-09 10:24:10,196 DEBUG [com.srn.workflow.processinstance.ProcessIn

Re: Frequent Io exception: Connection reset

frederikherema1 — Mon, 12 Aug 2013 13:02:13 GMT

What connection-pool are you using? Look into the parameters of that or use one that is proven in production that has all kind of internal connection checking built in…

Re: Frequent Io exception: Connection reset

mathewvimal — Mon, 12 Aug 2013 21:33:40 GMT

I guess we should be adjusting jdbc.maxActive value correct? Following is the DB conf we use:

db=oracle
jdbc.driver=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbcracle:thin:@sc.db.com:1521:EDAMP
jdbc.username=
jdbc.password=
jdbc.maxActive=30
jdbc.minIdle=10
jdbc.maxWait=0

Re: Frequent Io exception: Connection reset

jbarrez — Wed, 14 Aug 2013 10:06:53 GMT

You could do that - but you rather should use a 'real' connection pool (DBCP, c3p0, BoneCP, …) since those are way better