[
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)
