[
https://issues.apache.org/jira/browse/IMPALA-11267?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17527465#comment-17527465
]
Tamas Mate commented on IMPALA-11267:
-------------------------------------
Pasting some snippets from the attached HMS logs, to help locating this Jira if
the issue reccurs:
{code:none}
2022-04-23T02:20:24,980 ERROR [pool-7-thread-148] metastore.RetryingHMSHandler:
Retrying HMSHandler after 2000 ms (attempt 3 of 10) with error:
javax.jdo.JDODataStoreException: Iteration request failed : SELECT
'org.apache.hadoop.hive.metastore.model.MMVSource' AS
"NUCLEUS_TYPE","A0"."MV_CREATION_METADATA_ID","A0"."DELETED_COUNT","A0"."INSERTED_COUNT","A0"."TBL_ID","A0"."UPDATED_COUNT"
FROM "MV_TABLES_USED" "A0" WHERE "A0"."MV_CREATION_METADATA_ID" = ?
at
org.datanucleus.api.jdo.NucleusJDOHelper.getJDOExceptionForNucleusException(NucleusJDOHelper.java:543)
at
org.datanucleus.api.jdo.JDOPersistenceManager.jdoRetrieve(JDOPersistenceManager.java:625)
at
org.datanucleus.api.jdo.JDOPersistenceManager.retrieve(JDOPersistenceManager.java:637)
at
org.datanucleus.api.jdo.JDOPersistenceManager.retrieve(JDOPersistenceManager.java:646)
at
org.apache.hadoop.hive.metastore.ObjectStore.getCreationMetadata(ObjectStore.java:2157)
at
org.apache.hadoop.hive.metastore.ObjectStore.getTableObjectsByName(ObjectStore.java:2268)
...
{code}
Looks like some backend schema issue:
{code:none}
NestedThrowablesStackTrace:
org.postgresql.util.PSQLException: ERROR: column A0.DELETED_COUNT does not exist
Position: 108
at
org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2675)
at
org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2365)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:355)
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:490)
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:408)
{code}
> Flaky TestMetastoreService.test_passthrough_apis
> ------------------------------------------------
>
> Key: IMPALA-11267
> URL: https://issues.apache.org/jira/browse/IMPALA-11267
> Project: IMPALA
> Issue Type: Bug
> Components: Infrastructure
> Affects Versions: Impala 4.0.0
> Reporter: Tamas Mate
> Priority: Blocker
> Fix For: Impala 4.0.0
>
> Attachments: hive-metastore.log.tar.gz
>
>
> TestMetastoreService.test_passthrough_apis failed during one of our internal
> S3 tests.
> {code:none}
> custom_cluster/test_metastore_service.py:120: in test_passthrough_apis
> catalog_hms_client.drop_database(db_name, True, True)
> /data/jenkins/workspace/impala-cdpd-master-core-s3/repos/Impala/shell/gen-py/hive_metastore/ThriftHiveMetastore.py:2334:
> in drop_database
> self.recv_drop_database()
> /data/jenkins/workspace/impala-cdpd-master-core-s3/repos/Impala/shell/gen-py/hive_metastore/ThriftHiveMetastore.py:2358:
> in recv_drop_database
> raise result.o1
> E NoSuchObjectException:
> NoSuchObjectException(_message='test_passthrough_apis_dbntlif')
> {code}
> Seems like some hiccup caused by HMS.
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
