Hi,
We are sometimes facing this warning when fetching the search results. Currently using version 6.0.0.Beta7. Attaching the relevant stacktrace as well:
java.lang.Exception: Apparent connection leak detected
at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:128) ~[HikariCP-3.4.1.jar!/:?]
at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.internal.NonContextualJdbcConnectionAccess.obtainConnection(NonContextualJdbcConnectionAccess.java:38) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.acquireConnectionIfNeeded(LogicalConnectionManagedImpl.java:104) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.resource.jdbc.internal.LogicalConnectionManagedImpl.getPhysicalConnection(LogicalConnectionManagedImpl.java:134) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.connection(StatementPreparerImpl.java:50) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$5.doPrepare(StatementPreparerImpl.java:149) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl$StatementPreparationTemplate.prepareStatement(StatementPreparerImpl.java:176) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.engine.jdbc.internal.StatementPreparerImpl.prepareQueryStatement(StatementPreparerImpl.java:151) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:2104) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2034) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.entity.DynamicBatchingEntityLoaderBuilder$DynamicEntityLoader.doTheLoad(DynamicBatchingEntityLoaderBuilder.java:564) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.entity.DynamicBatchingEntityLoaderBuilder$DynamicEntityLoader.doEntityBatchFetch(DynamicBatchingEntityLoaderBuilder.java:530) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.entity.DynamicBatchingEntityLoaderBuilder.performOrderedBatchLoad(DynamicBatchingEntityLoaderBuilder.java:200) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.entity.DynamicBatchingEntityLoaderBuilder.performOrderedMultiLoad(DynamicBatchingEntityLoaderBuilder.java:160) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.loader.entity.DynamicBatchingEntityLoaderBuilder.multiLoad(DynamicBatchingEntityLoaderBuilder.java:64) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.persister.entity.AbstractEntityPersister.multiLoad(AbstractEntityPersister.java:4411) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.internal.SessionImpl$MultiIdentifierLoadAccessImpl.lambda$multiLoad$1(SessionImpl.java:2950) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.internal.SessionImpl$MultiIdentifierLoadAccessImpl.perform(SessionImpl.java:2931) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.internal.SessionImpl$MultiIdentifierLoadAccessImpl.multiLoad(SessionImpl.java:2950) ~[hibernate-core-5.4.8.Final.jar!/:5.4.8.Final]
at org.hibernate.search.mapper.orm.search.loading.impl.HibernateOrmByIdEntityLoader.loadEntities(HibernateOrmByIdEntityLoader.java:121) ~[hibernate-search-mapper-orm-6.0.0.Beta7.jar!/:6.0.0.Beta7]
at org.hibernate.search.mapper.orm.search.loading.impl.HibernateOrmByIdEntityLoader.loadBlocking(HibernateOrmByIdEntityLoader.java:53) ~[hibernate-search-mapper-orm-6.0.0.Beta7.jar!/:6.0.0.Beta7]
at org.hibernate.search.engine.search.loading.spi.DefaultProjectionHitMapper.loadBlocking(DefaultProjectionHitMapper.java:42) ~[hibernate-search-engine-6.0.0.Beta7.jar!/:6.0.0.Beta7]
at org.hibernate.search.backend.elasticsearch.search.query.impl.ElasticsearchLoadableSearchResult.loadBlocking(ElasticsearchLoadableSearchResult.java:60) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta7.jar!/:6.0.0.Beta7]
at org.hibernate.search.backend.elasticsearch.search.query.impl.ElasticsearchSearchQueryImpl.fetch(ElasticsearchSearchQueryImpl.java:127) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta7.jar!/:6.0.0.Beta7]
at org.hibernate.search.backend.elasticsearch.search.query.impl.ElasticsearchSearchQueryImpl.fetch(ElasticsearchSearchQueryImpl.java:41) ~[hibernate-search-backend-elasticsearch-6.0.0.Beta7.jar!/:6.0.0.Beta7]
at org.hibernate.search.engine.search.query.dsl.spi.AbstractSearchQueryOptionsStep.fetch(AbstractSearchQueryOptionsStep.java:168) ~[hibernate-search-engine-6.0.0.Beta7.jar!/:6.0.0.Beta7]
What are the possible scenarios for this to trigger?