Forum Stats

  • 3,855,210 Users
  • 2,264,475 Discussions
  • 7,905,930 Comments

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 baseline_update.sh.

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(C3P0PooledConnectionPool.java:196)

    at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1.refurbishIdleResource(C3P0PooledConnectionPool.java:136)

    at com.mchange.v2.resourcepool.BasicResourcePool$AsyncTestIdleResourceTask.run(BasicResourcePool.java:1394)

    at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:368)


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