Andrew Sherman created IMPALA-13277:
---------------------------------------
Summary: test_create_cache_many_tables fails with
'InvalidOperationException: Alter table in REMOTE database is not allowed'
Key: IMPALA-13277
URL: https://issues.apache.org/jira/browse/IMPALA-13277
Project: IMPALA
Issue Type: Bug
Reporter: Andrew Sherman
This is weird as the client side errors do not show up in Impala logs.
h3. Error Message
{code}
/data/jenkins/workspace/impala-cdw-master-staging-exhaustive-redhat8-shard2/repos/Impala/tests/stress/test_ddl_stress.py:83:
in test_create_cache_many_tables self.client.execute("alter table %s set
cached in 'testPool'" % tbl_name) common/impala_connection.py:220: in execute
fetch_profile_after_close=fetch_profile_after_close)
beeswax/impala_beeswax.py:191: in execute handle =
self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:384: in __execute_query
self.wait_for_finished(handle) beeswax/impala_beeswax.py:405: in
wait_for_finished raise ImpalaBeeswaxException("Query aborted:" + error_log,
None) E ImpalaBeeswaxException: ImpalaBeeswaxException: E Query
aborted:ImpalaRuntimeException: Error making 'alter_table' RPC to Hive
Metastore: E CAUSED BY: InvalidOperationException: Alter table in REMOTE
database is not allowed
{code}
h3. Stacktrace
{code}
/data/jenkins/workspace/impala-cdw-master-staging-exhaustive-redhat8-shard2/repos/Impala/tests/stress/test_ddl_stress.py:83:
in test_create_cache_many_tables self.client.execute("alter table %s set
cached in 'testPool'" % tbl_name) common/impala_connection.py:220: in execute
fetch_profile_after_close=fetch_profile_after_close)
beeswax/impala_beeswax.py:191: in execute handle =
self.__execute_query(query_string.strip(), user=user)
beeswax/impala_beeswax.py:384: in __execute_query
self.wait_for_finished(handle) beeswax/impala_beeswax.py:405: in
wait_for_finished raise ImpalaBeeswaxException("Query aborted:" + error_log,
None) E ImpalaBeeswaxException: ImpalaBeeswaxException: E Query
aborted:ImpalaRuntimeException: Error making 'alter_table' RPC to Hive
Metastore: E CAUSED BY: InvalidOperationException: Alter table in REMOTE
database is not allowed
{code}
h3. Standard Error
{code}
SET
client_identifier=stress/test_ddl_stress.py::TestDdlStress::()::test_create_cache_many_tables[protocol:beeswax|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_thr;
-- connecting to: localhost:21000 -- 2024-08-04 18:43:00,007 INFO MainThread:
Could not connect to ('::1', 21000, 0, 0) Traceback (most recent call last):
File
"/data/jenkins/workspace/impala-cdw-master-staging-exhaustive-redhat8-shard2/repos/Impala/infra/python/env-gcc10.4.0/lib/python2.7/site-packages/thrift/transport/TSocket.py",
line 137, in open handle.connect(sockaddr) File
"/data/jenkins/workspace/impala-cdw-master-staging-exhaustive-redhat8-shard2/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 -- 2024-08-04
18:43:00,008 INFO MainThread: Could not connect to ('::1', 21050, 0, 0)
Traceback (most recent call last): File
"/data/jenkins/workspace/impala-cdw-master-staging-exhaustive-redhat8-shard2/repos/Impala/infra/python/env-gcc10.4.0/lib/python2.7/site-packages/thrift/transport/TSocket.py",
line 137, in open handle.connect(sockaddr) File
"/data/jenkins/workspace/impala-cdw-master-staging-exhaustive-redhat8-shard2/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 -- 2024-08-04 18:43:00,063 INFO MainThread: Closing active
operation -- connecting to localhost:28000 with impyla -- 2024-08-04
18:43:00,124 INFO MainThread: Closing active operation -- connecting to
localhost:11050 with impyla SET
client_identifier=stress/test_ddl_stress.py::TestDdlStress::()::test_create_cache_many_tables[protocol:beeswax|exec_option:{'test_replan':1;'batch_size':0;'num_nodes':0;'disable_codegen_rows_threshold':0;'disable_codegen':False;'abort_on_error':1;'exec_single_node_rows_thr;
SET test_replan=1; SET batch_size=0; SET num_nodes=0; SET
disable_codegen_rows_threshold=0; SET disable_codegen=False; SET
abort_on_error=1; SET exec_single_node_rows_threshold=0; -- executing against
localhost:21000 create database if not exists test_ddl_stress_db; -- 2024-08-04
18:43:00,211 INFO MainThread: Started query f14af7ee53c2341d:70d9cb0800000000
-- executing against localhost:21000 drop table if exists
test_ddl_stress_db.test_256da409_0; -- 2024-08-04 18:43:00,264 INFO MainThread:
Started query a844dd28ea288ff0:f8b2fbb700000000 -- executing against
localhost:21000 drop table if exists test_ddl_stress_db.test_256da409_0_part;
-- 2024-08-04 18:43:00,317 INFO MainThread: Started query
7f481d60aa5b4765:233bcdb900000000 -- executing against localhost:21000 create
table test_ddl_stress_db.test_256da409_0 (i int); -- 2024-08-04 18:43:00,369
INFO MainThread: Started query 8645b931286dd1fa:5d30c54f00000000 -- executing
against localhost:21000 create table test_ddl_stress_db.test_256da409_0_part (i
int) partitioned by (j int); -- 2024-08-04 18:43:00,472 INFO MainThread:
Started query 71499a290e05d245:674852ae00000000 -- executing against
localhost:21000 insert overwrite table test_ddl_stress_db.test_256da409_0
select int_col from functional.alltypestiny; -- 2024-08-04 18:43:04,659 INFO
MainThread: Started query 9446c240b6a02509:f5e640ab00000000 -- executing
against localhost:21000 insert overwrite table
test_ddl_stress_db.test_256da409_0_part partition(j) values (1, 1), (2, 2), (3,
3), (4, 4), (4, 4); -- 2024-08-04 18:43:10,674 INFO MainThread: Started query
4b409c71a4da4d7e:b2aa597b00000000 -- executing against localhost:21000 alter
table test_ddl_stress_db.test_256da409_0 set cached in 'testPool'; --
2024-08-04 18:43:11,689 INFO MainThread: Started query
464e2738f8d0ced3:06ef54ba00000000
{code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
