Selvaganesan Govindarajan created TRAFODION-2653: ----------------------------------------------------
Summary: Sort operator loops at times Key: TRAFODION-2653 URL: https://issues.apache.org/jira/browse/TRAFODION-2653 Project: Apache Trafodion Issue Type: Bug Components: sql-exe Affects Versions: 2.2-incubating Reporter: Selvaganesan Govindarajan This issue was observed in Esgyn internal testing. When the system is heavily loaded, the scratch IOs can return EAGAIN that translates to OPERATION_NOT_COMPLETE in Sort scratch IO handling. This condition is not being handled correctly. Scratch IO doesn't use asynchronous IOs though the scratch file is opened in non-blocking mode. EAGAIN is returned from these IO operations very rarely. It should be fine to open the scratch file in blocking mode to avoid this problem -- This message was sent by Atlassian JIRA (v6.4.14#64029)