• State Not Answered
  • Replies reply
    1
  • Subscribers subscribers
    19
  • Views views
    304
  • Users 0 members are here

IO Error: Socket read interrupted Global Search FSSC 23.2

Alejo Hernandez

We have recently update Fortify SSC 23.1 to 23.2 and once the server is restarted, it is triggered a mass indexing process to enable global search. Nevertheless this process fails because of the following error () and the global search is disabled: 

  • 2024-04-30 13:38:12,244   [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 17002, SQLState: 08006,
  • 2024-04-30 13:38:12,245   [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - IO Error: Socket read interrupted,
  • 2024-04-30 13:38:12,264   [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null,
  • 2024-04-30 13:38:12,264   [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Cannot close connection (invalidating pooled object failed).

 Database and JDBC driver 

  • Database Version: 12c
  • Oracle JDBC Driver Version: 23.3.0.23.09

Log

2024-04-30 13:38:12,231   [ERROR] org.hibernate.search.engine.reporting.impl.LogFailureHandler - HSEARCH000058: Exception occurred org.hibernate.InstantiationException: Cannot instantiate abstract class or interface:  : com.fortify.manager.DAO.ApplicationEntity\nFailing operation:\nLoading and extracting entity data for entity 'ProjectVersionLite' during mass indexing\n
org.hibernate.InstantiationException: Cannot instantiate abstract class or interface:  : com.fortify.manager.DAO.ApplicationEntity
	at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:79) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.tuple.PojoInstantiator.instantiate(PojoInstantiator.java:105) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.tuple.entity.AbstractEntityTuplizer.instantiate(AbstractEntityTuplizer.java:718) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.persister.entity.AbstractEntityPersister.instantiate(AbstractEntityPersister.java:5324) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1643) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.SessionImpl.instantiate(SessionImpl.java:1627) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.plan.exec.process.internal.EntityReferenceInitializerImpl.hydrateEntityState(EntityReferenceInitializerImpl.java:255) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.plan.exec.process.internal.AbstractRowReader.readRow(AbstractRowReader.java:80) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.plan.exec.internal.EntityLoadQueryDetails$EntityLoaderRowReader.readRow(EntityLoadQueryDetails.java:288) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractRows(ResultSetProcessorImpl.java:157) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.plan.exec.process.internal.ResultSetProcessorImpl.extractResults(ResultSetProcessorImpl.java:94) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.plan.exec.internal.AbstractLoadPlanBasedLoader.executeLoad(AbstractLoadPlanBasedLoader.java:105) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.loadEntityBatch(AbstractLoadPlanBasedEntityLoader.java:233) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.loadEntityBatch(AbstractLoadPlanBasedEntityLoader.java:202) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.entity.plan.AbstractLoadPlanBasedEntityLoader.loadEntityBatch(AbstractLoadPlanBasedEntityLoader.java:176) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.entity.plan.MultiEntityLoadingSupport.performOrderedBatchLoad(MultiEntityLoadingSupport.java:172) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.entity.plan.MultiEntityLoadingSupport.performOrderedMultiLoad(MultiEntityLoadingSupport.java:139) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.loader.entity.plan.MultiEntityLoadingSupport.multiLoad(MultiEntityLoadingSupport.java:42) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.persister.entity.AbstractEntityPersister.multiLoad(AbstractEntityPersister.java:4620) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.SessionImpl$MultiIdentifierLoadAccessImpl.lambda$multiLoad$1(SessionImpl.java:3032) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.SessionImpl$MultiIdentifierLoadAccessImpl.perform(SessionImpl.java:3013) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.SessionImpl$MultiIdentifierLoadAccessImpl.multiLoad(SessionImpl.java:3032) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.search.mapper.orm.loading.impl.HibernateOrmMassEntityLoader.multiLoad(HibernateOrmMassEntityLoader.java:65) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.mapper.orm.loading.impl.HibernateOrmMassEntityLoader.load(HibernateOrmMassEntityLoader.java:50) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingEntityLoadingRunnable.runWithFailureHandler(PojoMassIndexingEntityLoadingRunnable.java:60) ~[hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingFailureHandledRunnable.run(PojoMassIndexingFailureHandledRunnable.java:32) [hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.util.common.impl.CancellableExecutionCompletableFuture$CompletingRunnable.run(CancellableExecutionCompletableFuture.java:70) [hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
2024-04-30 13:38:12,244   [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 17002, SQLState: 08006
2024-04-30 13:38:12,245   [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - IO Error: Socket read interrupted
2024-04-30 13:38:12,264   [WARN] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 0, SQLState: null
2024-04-30 13:38:12,264   [ERROR] org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Cannot close connection (invalidating pooled object failed)
2024-04-30 13:38:12,267   [ERROR] org.hibernate.search.engine.reporting.impl.LogFailureHandler - HSEARCH000058: Exception occurred org.hibernate.exception.JDBCConnectionException: could not advance using next()\nFailing operation:\nFetching identifiers of entities to index for entity 'ProjectVersionLite' during mass indexing\n
org.hibernate.exception.JDBCConnectionException: could not advance using next()
	at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:112) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:37) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.ScrollableResultsImpl.convert(ScrollableResultsImpl.java:71) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.internal.ScrollableResultsImpl.next(ScrollableResultsImpl.java:106) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	at org.hibernate.search.mapper.orm.loading.impl.HibernateOrmMassIdentifierLoader.loadNext(HibernateOrmMassIdentifierLoader.java:90) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingEntityIdentifierLoadingRunnable.runWithFailureHandler(PojoMassIndexingEntityIdentifierLoadingRunnable.java:49) ~[hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingFailureHandledRunnable.run(PojoMassIndexingFailureHandledRunnable.java:32) [hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
	at org.hibernate.search.util.common.impl.CancellableExecutionCompletableFuture$CompletingRunnable.run(CancellableExecutionCompletableFuture.java:70) [hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
	at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
	at java.lang.Thread.run(Thread.java:829) [?:?]
	Suppressed: org.hibernate.TransactionException: Unable to commit against JDBC Connection
		at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:92) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
		at org.hibernate.resource.transaction.backend.jdbc.internal.JdbcResourceLocalTransactionCoordinatorImpl$TransactionDriverControlImpl.commit(JdbcResourceLocalTransactionCoordinatorImpl.java:282) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
		at org.hibernate.engine.transaction.internal.TransactionImpl.commit(TransactionImpl.java:101) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
		at org.hibernate.search.mapper.orm.common.spi.TransactionHelper.commit(TransactionHelper.java:102) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.mapper.orm.loading.impl.HibernateOrmMassIdentifierLoader.lambda$close$0(HibernateOrmMassIdentifierLoader.java:76) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.util.common.impl.AbstractCloser.push(AbstractCloser.java:53) ~[hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.util.common.impl.AbstractCloser.push(AbstractCloser.java:33) ~[hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.mapper.orm.loading.impl.HibernateOrmMassIdentifierLoader.close(HibernateOrmMassIdentifierLoader.java:76) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingEntityIdentifierLoadingRunnable.runWithFailureHandler(PojoMassIndexingEntityIdentifierLoadingRunnable.java:45) ~[hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingFailureHandledRunnable.run(PojoMassIndexingFailureHandledRunnable.java:32) [hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
		at org.hibernate.search.util.common.impl.CancellableExecutionCompletableFuture$CompletingRunnable.run(CancellableExecutionCompletableFuture.java:70) [hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
		at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
		at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
		at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
		at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
		at java.lang.Thread.run(Thread.java:829) [?:?]
		Suppressed: org.hibernate.exception.GenericJDBCException: Unable to release JDBC Connection
			at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:223) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.close(LogicalConnectionManagedImpl.java:261) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:175) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.internal.AbstractSharedSessionContract.close(AbstractSharedSessionContract.java:374) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			at org.hibernate.search.util.common.impl.AbstractCloser.push(AbstractCloser.java:53) ~[hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
			at org.hibernate.search.util.common.impl.AbstractCloser.push(AbstractCloser.java:33) ~[hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
			at org.hibernate.search.mapper.orm.loading.impl.HibernateOrmMassIdentifierLoader.close(HibernateOrmMassIdentifierLoader.java:77) ~[hibernate-search-mapper-orm-6.1.8.Final.jar:6.1.8.Final]
			at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingEntityIdentifierLoadingRunnable.runWithFailureHandler(PojoMassIndexingEntityIdentifierLoadingRunnable.java:45) ~[hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
			at org.hibernate.search.mapper.pojo.massindexing.impl.PojoMassIndexingFailureHandledRunnable.run(PojoMassIndexingFailureHandledRunnable.java:32) [hibernate-search-mapper-pojo-base-6.1.8.Final.jar:6.1.8.Final]
			at org.hibernate.search.util.common.impl.CancellableExecutionCompletableFuture$CompletingRunnable.run(CancellableExecutionCompletableFuture.java:70) [hibernate-search-util-common-6.1.8.Final.jar:6.1.8.Final]
			at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
			at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
			at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
			at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
			at java.lang.Thread.run(Thread.java:829) [?:?]
		Caused by: java.sql.SQLException: Cannot close connection (invalidating pooled object failed)
			at org.apache.commons.dbcp2.PoolableConnection.close(PoolableConnection.java:178) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.isClosed(PoolableConnection.java:236) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.isClosed(DelegatingConnection.java:562) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolingDataSource$PoolGuardConnectionWrapper.isClosed(PoolingDataSource.java:81) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:214) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			... 14 more
		Caused by: org.apache.commons.dbcp2.SQLExceptionList: 1 exceptions: [org.apache.commons.dbcp2.SQLExceptionList: 1 exceptions: [java.sql.SQLRecoverableException: Closed Connection]]
			at org.apache.commons.dbcp2.DelegatingConnection.passivate(DelegatingConnection.java:645) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.passivate(PoolableConnection.java:284) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.closeInternal(DelegatingConnection.java:161) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.reallyClose(PoolableConnection.java:304) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:151) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.pool2.impl.GenericObjectPool.destroy(GenericObjectPool.java:611) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.pool2.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:941) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.pool2.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:914) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.dbcp2.PoolableConnection.close(PoolableConnection.java:172) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.isClosed(PoolableConnection.java:236) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.isClosed(DelegatingConnection.java:562) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolingDataSource$PoolGuardConnectionWrapper.isClosed(PoolingDataSource.java:81) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:214) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			... 14 more
		Caused by: org.apache.commons.dbcp2.SQLExceptionList: 1 exceptions: [java.sql.SQLRecoverableException: Closed Connection]
			at org.apache.commons.dbcp2.DelegatingStatement.close(DelegatingStatement.java:173) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.passivate(DelegatingConnection.java:629) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.passivate(PoolableConnection.java:284) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.closeInternal(DelegatingConnection.java:161) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.reallyClose(PoolableConnection.java:304) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:151) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.pool2.impl.GenericObjectPool.destroy(GenericObjectPool.java:611) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.pool2.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:941) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.pool2.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:914) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.dbcp2.PoolableConnection.close(PoolableConnection.java:172) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.isClosed(PoolableConnection.java:236) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.isClosed(DelegatingConnection.java:562) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolingDataSource$PoolGuardConnectionWrapper.isClosed(PoolingDataSource.java:81) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:214) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			... 14 more
		Caused by: java.sql.SQLRecoverableException: Closed Connection
			at oracle.jdbc.driver.PhysicalConnection.requireOpenConnection(PhysicalConnection.java:11812) ~[ojdbc11-21.11.0.0.jar:?]
			at oracle.jdbc.driver.PhysicalConnection.needLine(PhysicalConnection.java:4268) ~[ojdbc11-21.11.0.0.jar:?]
			at oracle.jdbc.driver.OracleStatement.closeOrCache(OracleStatement.java:2171) ~[ojdbc11-21.11.0.0.jar:?]
			at oracle.jdbc.driver.OracleStatement.close(OracleStatement.java:2154) ~[ojdbc11-21.11.0.0.jar:?]
			at oracle.jdbc.driver.OracleStatementWrapper.close(OracleStatementWrapper.java:147) ~[ojdbc11-21.11.0.0.jar:?]
			at oracle.jdbc.driver.OraclePreparedStatementWrapper.close(OraclePreparedStatementWrapper.java:115) ~[ojdbc11-21.11.0.0.jar:?]
			at org.apache.commons.dbcp2.DelegatingStatement.close(DelegatingStatement.java:160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.passivate(DelegatingConnection.java:629) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.passivate(PoolableConnection.java:284) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.closeInternal(DelegatingConnection.java:161) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.reallyClose(PoolableConnection.java:304) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnectionFactory.destroyObject(PoolableConnectionFactory.java:151) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.pool2.impl.GenericObjectPool.destroy(GenericObjectPool.java:611) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.pool2.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:941) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.pool2.impl.GenericObjectPool.invalidateObject(GenericObjectPool.java:914) ~[commons-pool2-2.11.1.jar:2.11.1]
			at org.apache.commons.dbcp2.PoolableConnection.close(PoolableConnection.java:172) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolableConnection.isClosed(PoolableConnection.java:236) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.DelegatingConnection.isClosed(DelegatingConnection.java:562) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.apache.commons.dbcp2.PoolingDataSource$PoolGuardConnectionWrapper.isClosed(PoolingDataSource.java:81) ~[commons-dbcp2-2.9.0.jar:2.9.0]
			at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.releaseConnection(LogicalConnectionManagedImpl.java:214) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
			... 14 more
	Caused by: java.sql.SQLRecoverableException: Closed Connection
		at oracle.jdbc.driver.PhysicalConnection.requireOpenConnection(PhysicalConnection.java:11812) ~[ojdbc11-21.11.0.0.jar:?]
		at oracle.jdbc.driver.PhysicalConnection.getAutoCommit(PhysicalConnection.java:2627) ~[ojdbc11-21.11.0.0.jar:?]
		at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2705) ~[ojdbc11-21.11.0.0.jar:?]
		at oracle.jdbc.driver.PhysicalConnection.commit(PhysicalConnection.java:2775) ~[ojdbc11-21.11.0.0.jar:?]
		at org.apache.commons.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:191) ~[commons-dbcp2-2.9.0.jar:2.9.0]
		at org.apache.commons.dbcp2.DelegatingConnection.commit(DelegatingConnection.java:191) ~[commons-dbcp2-2.9.0.jar:2.9.0]
		at org.hibernate.resource.jdbc.internal.AbstractLogicalConnectionImplementor.commit(AbstractLogicalConnectionImplementor.java:86) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
		... 15 more
Caused by: java.sql.SQLRecoverableException: IO Error: Socket read interrupted
	at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1472) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:4127) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:924) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchNextRows(InsensitiveScrollableResultSet.java:831) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:803) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:504) ~[ojdbc11-21.11.0.0.jar:?]
	at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
	at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
	at org.hibernate.internal.ScrollableResultsImpl.next(ScrollableResultsImpl.java:101) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	... 9 more
Caused by: java.io.InterruptedIOException: Socket read interrupted
	at oracle.net.nt.TimeoutSocketChannel.handleInterrupt(TimeoutSocketChannel.java:550) ~[ojdbc11-21.11.0.0.jar:21.11.0.0.0]
	at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:421) ~[ojdbc11-21.11.0.0.jar:21.11.0.0.0]
	at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:1136) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:268) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:200) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:142) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:115) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:98) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:834) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:487) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:623) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:299) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:512) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:163) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1467) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.OracleStatement.fetchMoreRows(OracleStatement.java:4127) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchMoreRows(InsensitiveScrollableResultSet.java:924) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.fetchNextRows(InsensitiveScrollableResultSet.java:831) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.absoluteInternal(InsensitiveScrollableResultSet.java:803) ~[ojdbc11-21.11.0.0.jar:?]
	at oracle.jdbc.driver.InsensitiveScrollableResultSet.next(InsensitiveScrollableResultSet.java:504) ~[ojdbc11-21.11.0.0.jar:?]
	at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
	at org.apache.commons.dbcp2.DelegatingResultSet.next(DelegatingResultSet.java:1160) ~[commons-dbcp2-2.9.0.jar:2.9.0]
	at org.hibernate.internal.ScrollableResultsImpl.next(ScrollableResultsImpl.java:101) ~[hibernate-core-5.6.15.Final.jar:5.6.15.Final]
	... 9 more
2024-04-30 13:38:13,132   [WARN] com.fortify.manager.service.scheduler.SchedulerManagerImpl - Job JOB_FULL_REINDEX$b98b9e69-a6a8-4931-8880-49e8f891c193 failed: Failed to rebuild fulltext

Do you have any hint related to this issue?

Before this issue there was another one related to "AuditCommentIndex" but was fixed as indicated in this post.

Resources

Support
Documentation
Learning Services
Partner Programs
Privacy
Compliance
Help
Company
Privacy Policy
Terms of Use
Cookies Preferences
Accessibility
Anti-Slavery Statement
Support
Contact Us
Careers
Code of Business Conduct and Ethics
The opinions expressed above are the personal opinions of the authors, not of OpenText. By using this site, you accept the Terms of Use. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.), Hewlett Packard Enterprise Company, or Micro Focus. As of January 31, 2023, the Material is now offered by OpenText, a separately owned and operated company. Any reference to the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks is historical in nature and the HP, Hewlett Packard Enterprise/HPE, and Micro Focus marks are the property of their respective owners.