Stuck threads when fetching data from external datasource with many records (Doc ID 2866950.1)

Last updated on OCTOBER 05, 2023

Applies to:

Symptoms

Stuck threads observed when BEAM engine tries to build DO from a large external data source 

"[ACTIVE] ExecuteThread: '102' for queue: 'weblogic.kernel.Default (self-tuning)'" #228 daemon prio=5 os_prio=0 tid=0x00007f7e48007000 nid=0x17ffd1 runnable [0x00007f7cff494000]
java.lang.Thread.State: RUNNABLE
at sun.nio.ch.FileDispatcherImpl.read0(Native Method)
at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)
at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)
at sun.nio.ch.IOUtil.read(IOUtil.java:197)
at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:378)
- locked <0x000000055618d4c8> (a java.lang.Object)
at oracle.net.nt.TimeoutSocketChannel.read(TimeoutSocketChannel.java:175)
at oracle.net.ns.NSProtocolNIO.doSocketRead(NSProtocolNIO.java:571)
at oracle.net.ns.NIOPacket.readHeader(NIOPacket.java:259)
at oracle.net.ns.NIOPacket.readPacketFromSocketChannel(NIOPacket.java:191)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:133)
at oracle.net.ns.NIOPacket.readFromSocketChannel(NIOPacket.java:106)
- locked <0x000000055618de70> (a oracle.jdbc.driver.OracleDatabaseMetaData)
at weblogic.jdbc.wrapper.DatabaseMetaData_oracle_jdbc_driver_OracleDatabaseMetaData.getIndexInfo(Unknown Source)
at oracle.beam.composer.dataobject.support.ExternalDataObjectManager.buildExternalDataObject(ExternalDataObjectManager.java:433)

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.