[System Test] Connection reset errors while running a query on an external dataset

2024-05-21T18:05:48.400+00:00 INFO CBAS.messaging.NCMessageBroker [Worker:8cf7d507172509090671132e585a7b5c] Received message: ExecuteStatementResponseMessage(id=152, uuid=13b12146-3736-4ecb-a1a3-47b018a98ee0, clientContextId=637219-0a82-ac43-0695-f5ec396065222e): 0 characters

2024-05-21T18:05:48.400+00:00 WARN CBAS.server.QueryServiceServlet [HttpExecutor(port:18095)-13] handleException: unexpected exception: {"host":"svc-da-node-001.mmbvoelwhg-otdos.sandbox.nonprod-project-avengers.com:18095","path":"/query/service","statement":"<ud>SELECT s.seller_name, p.product_name, p.avg_rating, CASE WHEN p.avg_rating = s.max_rating THEN 'Highest' WHEN p.avg_rating = s.min_rating THEN 'Lowest' END AS rating_type FROM `Database16zPWJuQZu`.`scope1egYMLXRg`.`tsvExternalDatasetXGEinOKsOR` p JOIN (SELECT seller_name, MAX(avg_rating) OVER (PARTITION BY seller_name) AS max_rating, MIN(avg_rating) OVER (PARTITION BY seller_name) AS min_rating FROM `Database16zPWJuQZu`.`scope1egYMLXRg`.`tsvExternalDatasetXGEinOKsOR`) s ON p.seller_name = s.seller_name WHERE p.avg_rating IN (s.max_rating, s.min_rating) ORDER BY s.seller_name, rating_type;</ud>","pretty":false,"mode":"immediate","clientContextID":"637219-0a82-ac43-0695-f5ec396065222e","clientType":"ASTERIX","dataverse":null,"format":"CLEAN_JSON","timeout":600000,"maxResultReads":1,"planFormat":"JSON","expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":false,"job":false,"profile":"counts","signature":true,"multiStatement":false,"parseOnly":false,"readOnly":false,"maxWarnings":0,"sqlCompat":false,"source":null,"scanConsistency":null,"scanWait":null}

org.apache.hyracks.api.exceptions.HyracksDataException: ASX1108: External source error. java.net.SocketException: Connection reset

	at org.apache.hyracks.api.exceptions.HyracksDataException.create(HyracksDataException.java:70) ~[hyracks-api.jar:1.0.0-2085]

	at org.apache.hyracks.api.util.ExceptionUtils.setNodeIds(ExceptionUtils.java:70) ~[hyracks-api.jar:1.0.0-2085]

	at org.apache.hyracks.control.nc.Task.run(Task.java:398) ~[hyracks-control-nc.jar:1.0.0-2085]

	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) [?:?]

	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) [?:?]

	at java.base/java.lang.Thread.run(Thread.java:840) [?:?]

Caused by: java.net.SocketException: Connection reset

	at java.base/sun.nio.ch.NioSocketImpl.implRead(NioSocketImpl.java:328) ~[?:?]

	at java.base/sun.nio.ch.NioSocketImpl.read(NioSocketImpl.java:355) ~[?:?]

	at java.base/sun.nio.ch.NioSocketImpl$1.read(NioSocketImpl.java:808) ~[?:?]

	at java.base/java.net.Socket$SocketInputStream.read(Socket.java:966) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketInputRecord.read(SSLSocketInputRecord.java:484) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketInputRecord.readFully(SSLSocketInputRecord.java:467) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketInputRecord.decodeInputRecord(SSLSocketInputRecord.java:243) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketInputRecord.decode(SSLSocketInputRecord.java:181) ~[?:?]

	at java.base/sun.security.ssl.SSLTransport.decode(SSLTransport.java:111) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketImpl.decode(SSLSocketImpl.java:1513) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketImpl.readApplicationRecord(SSLSocketImpl.java:1484) ~[?:?]

	at java.base/sun.security.ssl.SSLSocketImpl$AppInputStream.read(SSLSocketImpl.java:1069) ~[?:?]

	at org.apache.http.impl.io.SessionInputBufferImpl.streamRead(SessionInputBufferImpl.java:137) ~[httpcore-4.4.16.jar:4.4.16]

	at org.apache.http.impl.io.SessionInputBufferImpl.read(SessionInputBufferImpl.java:197) ~[httpcore-4.4.16.jar:4.4.16]

	at org.apache.http.impl.io.ContentLengthInputStream.read(ContentLengthInputStream.java:176) ~[httpcore-4.4.16.jar:4.4.16]

	at org.apache.http.conn.EofSensorInputStream.read(EofSensorInputStream.java:135) ~[httpclient-4.5.14.jar:4.5.14]

	at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) ~[?:?]

	at software.amazon.awssdk.services.s3.internal.checksums.S3ChecksumValidatingInputStream.read(S3ChecksumValidatingInputStream.java:112) ~[s3-2.24.9.jar:?]

	at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) ~[?:?]

	at software.amazon.awssdk.core.io.SdkFilterInputStream.read(SdkFilterInputStream.java:66) ~[sdk-core-2.24.9.jar:?]

	at software.amazon.awssdk.core.internal.metrics.BytesReadTrackingInputStream.read(BytesReadTrackingInputStream.java:49) ~[sdk-core-2.24.9.jar:?]

	at java.base/java.io.FilterInputStream.read(FilterInputStream.java:132) ~[?:?]

	at software.amazon.awssdk.core.io.SdkFilterInputStream.read(SdkFilterInputStream.java:66) ~[sdk-core-2.24.9.jar:?]

	at org.apache.asterix.external.input.stream.AbstractMultipleInputStream.read(AbstractMultipleInputStream.java:66) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.asterix.external.input.stream.AsterixInputStreamReader.read(AsterixInputStreamReader.java:99) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.asterix.external.input.stream.AsterixInputStreamReader.read(AsterixInputStreamReader.java:69) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.asterix.external.input.record.reader.stream.LineRecordReader.hasNext(LineRecordReader.java:115) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.asterix.external.dataflow.RecordDataFlowController.start(RecordDataFlowController.java:56) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.asterix.external.dataset.adapter.GenericAdapter.start(GenericAdapter.java:38) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.asterix.external.operators.ExternalScanOperatorDescriptor$1.initialize(ExternalScanOperatorDescriptor.java:80) ~[asterix-external-data.jar:1.0.0-2085]

	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$runInParallel$0(SuperActivityOperatorNodePushable.java:233) ~[hyracks-api.jar:1.0.0-2085]

	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]

	... 3 more