Oracle APPARENT DEADLOCK warnings

Description

We have an Idempiere 4.1 install, running with Oracle DB 11.

Our idempiere logs registered many times the error:

-----------> StatementUtils.log: Statement close FAILED. [8405]
java.sql.SQLRecoverableException: Closed Connection; State=08003; ErrorCode=17008

Searching in the web, found a solution in c3p0 documentation with a not mapped by Idempiere param: statementCacheNumDeferredCloseThreads

You can get more information about this at:
http://www.mchange.com/projects/c3p0/#statementCacheNumDeferredCloseThreads

So, as discussed with Carlos on skype, we added the treatment to this parameter in the class org.compiere.db.DB_Oracle, and generate a patch with the c3p0 recomendation.

But, in our case, the log continue to write the warning. We obtain the best results with the combination with the patch and changing the properties (IdleConnectionTestPeriod, MaxIdleTimeExcessConnections and MaxIdleTime) in pool.properties file to lower values.

Environment

Idempiere 4.1
Oracle 11

Status

Assignee

Eduardo Moreira

Reporter

Eduardo Moreira

Labels

None

Tested By

None

Components

Affects versions

Due date

2017/12/31

Priority

Major
Configure