We are using Oracle 19C and Driver OJDBC 8 driver but we are seeing stuck thread while executing query in database. This is happening after our recent migration to 19C oracle database. This is stuck issue is not getting solved until we drop tables.
"task-scheduler-8" #2052 prio=5 os_prio=0 cpu=16735.92ms elapsed=91486.55s allocated=7923M defined_classes=10 tid=0x00007faae400a800 nid=0x2931 runnable [0x00007fa96d8d7000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.FileDispatcherImpl.read0(java.base@11.0.11/Native Method)
at sun.nio.ch.SocketDispatcher.read(java.base@11.0.11/Unknown Source)
at sun.nio.ch.IOUtil.readIntoNativeBuffer(java.base@11.0.11/Unknown Source)
at sun.nio.ch.IOUtil.read(java.base@11.0.11/Unknown Source)
at sun.nio.ch.IOUtil.read(java.base@11.0.11/Unknown Source)
at sun.nio.ch.SocketChannelImpl.read(java.base@11.0.11/Unknown Source)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:174)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:555)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:258)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:190)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:132)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:105)
at oracle.net.ns.NIONSDataChannel.readDataFromSocketChannel(NIONSDataChannel.java:91)
at oracle.jdbc.driver.T4CMAREngineNIO.prepareForUnmarshall(T4CMAREngineNIO.java:764)
at oracle.jdbc.driver.T4CMAREngineNIO.unmarshalUB1(T4CMAREngineNIO.java:429)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:407)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:268)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:655)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:270)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:91)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:807)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:983)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3666)
at oracle.jdbc.driver.T4CPreparedStatement.executeInternal(T4CPreparedStatement.java:1426)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3713)
- locked <0x000000032e251a88> (a oracle.jdbc.driver.T4CConnection)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1167)
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52)
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java)
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:60)
at org.hibernate.loader.Loader.getResultSet(Loader.java:2265)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2028)
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1990)
at org.hibernate.loader.Loader.doQuery(Loader.java:949)
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:351)
at org.hibernate.loader.Loader.doList(Loader.java:2787)
at org.hibernate.loader.Loader.doList(Loader.java:2770)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2604)
at org.hibernate.loader.Loader.list(Loader.java:2599)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:505)
at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:395)
at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:220)
at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1526)
at org.hibernate.query.internal.AbstractProducedQuery.doList(AbstractProducedQuery.java:1538)
at org.hibernate.query.internal.AbstractProducedQuery.list(AbstractProducedQuery.java:1506)
at org.hibernate.query.Query.getResultList(Query.java:132)
at com.querydsl.jpa.impl.AbstractJPAQuery.getResultList(AbstractJPAQuery.java:160)
at com.querydsl.jpa.impl.AbstractJPAQuery.fetch(AbstractJPAQuery.java:202)
at com.hybris.datahub.repository.jpa.impl.DefaultPublicationRetryJpaRepository.incrementRetryCount(DefaultPublicationRetryJpaRepository.java:207)
at jdk.internal.reflect.GeneratedMethodAccessor592.invoke(Unknown Source)
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(java.base@11.0.11/Unknown Source)
at java.lang.reflect.Method.invoke(java.base@11.0.11/Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1483/0x00000008013a0440.proceedWithInvocation(Unknown Source)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy119.incrementRetryCount(Unknown Source)
at com.hybris.datahub.service.publication.impl.DefaultPublicationRetryService.createRetriesForNotPublishedItems(DefaultPublicationRetryService.java:106)
at com.hybris.datahub.service.publication.impl.DefaultPublicationRetryService.manageRetriesForPublication(DefaultPublicationRetryService.java:72)
at com.hybris.datahub.service.impl.DefaultTargetSystemPublicationCompletionService.completeCompositeTargetSystemPublication(DefaultTargetSystemPublicationCompletionService.java:126)
at com.hybris.datahub.service.impl.DefaultTargetSystemPublicationCompletionService.completeCompositeTargetSystemPublication(DefaultTargetSystemPublicationCompletionService.java:450)
at com.hybris.datahub.service.impl.DefaultTargetSystemPublicationCompletionService.handleLastSubPublication(DefaultTargetSystemPublicationCompletionService.java:250)
at com.hybris.datahub.service.impl.DefaultTargetSystemPublicationCompletionService.completeTargetSystemPublication(DefaultTargetSystemPublicationCompletionService.java:118)
at jdk.internal.reflect.GeneratedMethodAccessor607.invoke(Unknown Source)
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(java.base@11.0.11/Unknown Source)
at java.lang.reflect.Method.invoke(java.base@11.0.11/Unknown Source)
at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344)
at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163)
at org.springframework.transaction.interceptor.TransactionInterceptor$$Lambda$1483/0x00000008013a0440.proceedWithInvocation(Unknown Source)
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:367)
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:118)
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy175.completeTargetSystemPublication(Unknown Source)
at com.hybris.datahub.service.impl.DefaultPublicationActionService.completeTargetSystemPublication(DefaultPublicationActionService.java:57)
at com.hybris.datahub.pubrecover.impl.DefaultPublicationMonitor.lambda$failPublication$5(DefaultPublicationMonitor.java:114)
at com.hybris.datahub.pubrecover.impl.DefaultPublicationMonitor$$Lambda$2204/0x00000008019abc40.accept(Unknown Source)
at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(java.base@11.0.11/Unknown Source)
at java.util.stream.ReferencePipeline$2$1.accept(java.base@11.0.11/Unknown Source)
at java.util.stream.ReferencePipeline$2$1.accept(java.base@11.0.11/Unknown Source)
at java.util.Iterator.forEachRemaining(java.base@11.0.11/Unknown Source)
at java.util.Spliterators$IteratorSpliterator.forEachRemaining(java.base@11.0.11/Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(java.base@11.0.11/Unknown Source)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(java.base@11.0.11/Unknown Source)
at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(java.base@11.0.11/Unknown Source)
at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(java.base@11.0.11/Unknown Source)
at java.util.stream.AbstractPipeline.evaluate(java.base@11.0.11/Unknown Source)
at java.util.stream.ReferencePipeline.forEach(java.base@11.0.11/Unknown Source)
at com.hybris.datahub.pubrecover.impl.DefaultPublicationMonitor.failPublication(DefaultPublicationMonitor.java:114)
at com.hybris.datahub.pubrecover.impl.DefaultPublicationMonitor$$Lambda$2148/0x0000000801946440.accept(Unknown Source)
at java.util.stream.ForEachOps$ForEachOp$OfRef.accept(java.base@11.0.11/Unknown Source)
at java.util.stream.ReferencePipeline$2$1.accept(java.base@11.0.11/Unknown Source)
at java.util.stream.ReferencePipeline$3$1.accept(java.base@11.0.11/Unknown Source)
at java.util.HashMap$EntrySpliterator.forEachRemaining(java.base@11.0.11/Unknown Source)
at java.util.stream.AbstractPipeline.copyInto(java.base@11.0.11/Unknown Source)
at java.util.stream.AbstractPipeline.wrapAndCopyInto(java.base@11.0.11/Unknown Source)
at java.util.stream.ForEachOps$ForEachOp.evaluateSequential(java.base@11.0.11/Unknown Source)
at java.util.stream.ForEachOps$ForEachOp$OfRef.evaluateSequential(java.base@11.0.11/Unknown Source)
at java.util.stream.AbstractPipeline.evaluate(java.base@11.0.11/Unknown Source)
at java.util.stream.ReferencePipeline.forEach(java.base@11.0.11/Unknown Source)
at com.hybris.datahub.pubrecover.impl.DefaultPublicationMonitor.checkPublicationStateAndRecover(DefaultPublicationMonitor.java:72)
at jdk.internal.reflect.GeneratedMethodAccessor618.invoke(Unknown Source)
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(java.base@11.0.11/Unknown Source)
at java.lang.reflect.Method.invoke(java.base@11.0.11/Unknown Source)
at org.springframework.scheduling.support.ScheduledMethodRunnable.run(ScheduledMethodRunnable.java:84)
at org.springframework.scheduling.support.DelegatingErrorHandlingRunnable.run(DelegatingErrorHandlingRunnable.java:54)
at java.util.concurrent.Executors$RunnableAdapter.call(java.base@11.0.11/Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(java.base@11.0.11/Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(java.base@11.0.11/Unknown Source)
at java.util.concurrent.ThreadPoolExecutor.runWorker(java.base@11.0.11/Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(java.base@11.0.11/Unknown Source)
at java.lang.Thread.run(java.base@11.0.11/Unknown Source)
Locked ownable synchronizers:
- <0x000000030a93cba0> (a java.util.concurrent.ThreadPoolExecutor$Worker)
- <0x000000032e257818> (a java.util.concurrent.locks.ReentrantLock$NonfairSync)