[IMPALA-12148] Create table as select (CTAS) tests time out

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: Impala 4.3.0
• Fix Version/s: Impala 4.3.0
• Epic Color: ghx-label-4
• Assignee: Joe McDonnell
• Reporter: Laszlo Gaal
• Created: 18/May/23 16:52
• Updated: 16/Jul/23 21:32
• Resolved: 16/Jul/23 21:32

Description

This is quite similar to the earlier IMPALA-11633; however there is the additional symptom of connection failures in the captured stderror of the tests:

SET client_identifier=metadata/test_ddl.py::TestAsyncDDLTiming::()::test_ctas[enable_async_ddl_execution:True|protocol:beeswax|exec_option:{'sync_ddl':0;'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;';
-- connecting to: localhost:21000
-- 2023-05-15 22:16:39,043 INFO     MainThread: Could not connect to ('::1', 21000, 0, 0)
Traceback (most recent call last):
  File "/data/jenkins/workspace/impala-asf-master-core-asan/Impala-Toolchain/toolchain-packages-gcc10.4.0/thrift-0.16.0-p3/python/lib/python2.7/site-packages/thrift/transport/TSocket.py", line 137, in open
    handle.connect(sockaddr)
  File "/data/jenkins/workspace/impala-asf-master-core-asan/Impala-Toolchain/toolchain-packages-gcc10.4.0/python-2.7.16/lib/python2.7/socket.py", line 228, in meth
    return getattr(self._sock,name)(*args)
error: [Errno 111] Connection refused
-- connecting to localhost:21050 with impyla
-- 2023-05-15 22:16:39,043 INFO     MainThread: Could not connect to ('::1', 21050, 0, 0)
Traceback (most recent call last):
  File "/data/jenkins/workspace/impala-asf-master-core-asan/Impala-Toolchain/toolchain-packages-gcc10.4.0/thrift-0.16.0-p3/python/lib/python2.7/site-packages/thrift/transport/TSocket.py", line 137, in open
    handle.connect(sockaddr)
  File "/data/jenkins/workspace/impala-asf-master-core-asan/Impala-Toolchain/toolchain-packages-gcc10.4.0/python-2.7.16/lib/python2.7/socket.py", line 228, in meth
    return getattr(self._sock,name)(*args)
error: [Errno 111] Connection refused
-- 2023-05-15 22:16:39,057 INFO     MainThread: Closing active operation
-- connecting to localhost:28000 with impyla
-- 2023-05-15 22:16:39,074 INFO     MainThread: Closing active operation

or later:

SET client_identifier=metadata/test_ddl.py::TestAsyncDDLTiming::()::test_ctas[enable_async_ddl_execution:True|protocol:beeswax|exec_option:{'sync_ddl':0;'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;';
-- connecting to: localhost:21000
-- 2023-05-15 22:16:44,429 INFO     MainThread: Could not connect to ('::1', 21000, 0, 0)
Traceback (most recent call last):
  File "/data/jenkins/workspace/impala-asf-master-core-asan/Impala-Toolchain/toolchain-packages-gcc10.4.0/thrift-0.16.0-p3/python/lib/python2.7/site-packages/thrift/transport/TSocket.py", line 137, in open
    handle.connect(sockaddr)
  File "/data/jenkins/workspace/impala-asf-master-core-asan/Impala-Toolchain/toolchain-packages-gcc10.4.0/python-2.7.16/lib/python2.7/socket.py", line 228, in meth
    return getattr(self._sock,name)(*args)
error: [Errno 111] Connection refused
-- executing against localhost:21000

Issue Links

• is related to: IMPALA-11633 Create table as select (CTAS) tests occasionally timeout for S3, Ozone