We are getting the below error from our spring boot (version 3.x) code while fetching detail from Postgresql and Oracle Database through hibernate 6.5 with java 21. This issue occurs only if more than 20 users access the endpoint concurrently.
We are getting the error at this line in the code
final Long productCategoryId = productCategory.getId();
Here productCategory is the Entity class mapped to a table in DB and getId method belongs to that same class to fetch the ID and return.
Unexpected exception: java.lang.IllegalStateException: Illegal pop() with non-matching JdbcValuesSourceProcessingState at org.hibernate.sql.results.spi.LoadContexts.deregister(LoadContexts.java:45)_ at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:230)_ at org.hibernate.sql.results.spi.ListResultsConsumer.consume(ListResultsConsumer.java:33)_ at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.doExecuteQuery(JdbcSelectExecutorStandardImpl.java:211)_ at org.hibernate.sql.exec.internal.JdbcSelectExecutorStandardImpl.executeQuery(JdbcSelectExecutorStandardImpl.java:83)_ at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:76)_ at org.hibernate.sql.exec.spi.JdbcSelectExecutor.list(JdbcSelectExecutor.java:65)_ at org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:145)_ at org.hibernate.loader.ast.internal.SingleIdLoadPlan.load(SingleIdLoadPlan.java:117)_ at org.hibernate.loader.ast.internal.SingleIdEntityLoaderStandardImpl.load(SingleIdEntityLoaderStandardImpl.java:75)_ at org.hibernate.persister.entity.AbstractEntityPersister.doLoad(AbstractEntityPersister.java:3726)_ at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:3715)_ at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:604)_ at org.hibernate.event.internal.DefaultLoadEventListener.loadFromCacheOrDatasource(DefaultLoadEventListener.java:590)_ at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:560)_ at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:544)_ at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:207)_ at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:106)_ at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:68)_ at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:138)_ at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1225)_ at org.hibernate.internal.SessionImpl.immediateLoad(SessionImpl.java:1044)_ at org.hibernate.proxy.AbstractLazyInitializer.initialize(AbstractLazyInitializer.java:174)_ at org.hibernate.proxy.AbstractLazyInitializer.getImplementation(AbstractLazyInitializer.java:314)_ at org.hibernate.proxy.pojo.bytebuddy.ByteBuddyInterceptor.intercept(ByteBuddyInterceptor.java:44)_ at org.hibernate.proxy.ProxyConfiguration$InterceptorDispatcher.intercept(ProxyConfiguration.java:102)