Forum Stats

  • 3,855,210 Users
  • 2,264,475 Discussions


BasicResourcePool: An idle resource is broken and will be purged.

I installed Endeca on Ubuntu according to official document. Everything is well until run

I checked the log in /opt/endeca/apps/MyApp/logs/forges/Forge and it is empty.

And then I checked /opt/endeca/PlatformServices/workspace/logs/main.1.log, there is a exception as follows :

WARNING: 04-29-2022 17:41:32.842  BasicResourcePool: An idle resource is broken and will be purged.

Caused by:

java.sql.SQLException: Connection is invalid

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.testPooledConnection(

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(

    at com.mchange.v2.resourcepool.BasicResourcePool$

    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$

I searched the related topic but didn't find the specific solution. Has anyone ever had this problem and know the solution? Deeply grateful!