You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues-all@impala.apache.org by "Riza Suminto (Jira)" <ji...@apache.org> on 2025/01/28 02:38:00 UTC
[jira] [Resolved] (IMPALA-13277) test_create_cache_many_tables fails with 'InvalidOperationException: Alter table in REMOTE database is not allowed'
[ https://issues.apache.org/jira/browse/IMPALA-13277?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Riza Suminto resolved IMPALA-13277.
-----------------------------------
Fix Version/s: Impala 4.5.0
Assignee: Riza Suminto
Resolution: Fixed
This should be fixed by IMPALA-13620 and IMPALA-13664.
> 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
> Assignee: Riza Suminto
> Priority: Critical
> Fix For: Impala 4.5.0
>
> Attachments: hive-metastore.log
>
>
> 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)
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-all-unsubscribe@impala.apache.org
For additional commands, e-mail: issues-all-help@impala.apache.org