Parallel Query hangs due to "PX Deq: Join ACK" on RAC
Last updated on JANUARY 18, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 11.2]
Oracle Database - Enterprise Edition - Version 184.108.40.206 to 220.127.116.11 [Release 12.1]
Microsoft Windows x64 (64-bit)
Parallel Query may not complete, and Query Cordinator(QC) process waits for "PX Deq: Join ACK" when following all conditions are met.
- RAC env on Windows 2012R2
- Interconnect of RAC is configured by Teaming of Windows and Active-Active
- Windows Update program KB：3137691 is not applied
And following messages appear in event log of MsLbfoProvider when this problem happens.
NONE Failing NBL send on TeamNic 0xffffe0014dbd6010
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms