[Bug report] force drop catalog failed for model table not exists #6157
Closed
Description
Version
main branch
Describe what's wrong
force drop catalog failed
Error message and/or stacktrace
"Caused by: org.apache.ibatis.exceptions.PersistenceException: ",
"### Error updating database. Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table \"MODEL_VERSION_ALIAS_REL\" not found; SQL statement:",
"UPDATE model_version_alias_rel SET deleted_at = (UNIX_TIMESTAMP() * 1000.0) + EXTRACT(MICROSECOND FROM CURRENT_TIMESTAMP(3)) / 1000 WHERE model_id IN ( SELECT model_id FROM model_meta WHERE schema_id = ? AND deleted_at = 0) AND deleted_at = 0 [42102-200]",
"### The error may exist in org/apache/gravitino/storage/relational/mapper/ModelVersionAliasRelMapper.java (best guess)",
"### The error may involve org.apache.gravitino.storage.relational.mapper.ModelVersionAliasRelMapper.softDeleteModelVersionAliasRelsBySchemaId",
"### The error occurred while executing an update",
"### SQL: UPDATE model_version_alias_rel SET deleted_at = (UNIX_TIMESTAMP() * 1000.0) + EXTRACT(MICROSECOND FROM CURRENT_TIMESTAMP(3)) / 1000 WHERE model_id IN ( SELECT model_id FROM model_meta WHERE schema_id = ? AND deleted_at = 0) AND deleted_at = 0",
"### Cause: org.h2.jdbc.JdbcSQLSyntaxErrorException: Table \"MODEL_VERSION_ALIAS_REL\" not found; SQL statement:",
"UPDATE model_version_alias_rel SET deleted_at = (UNIX_TIMESTAMP() * 1000.0) + EXTRACT(MICROSECOND FROM CURRENT_TIMESTAMP(3)) / 1000 WHERE model_id IN ( SELECT model_id FROM model_meta WHERE schema_id = ? AND deleted_at = 0) AND deleted_at = 0 [42102-200]",
How to reproduce
In my local enviroment, I had setup some catalogs in old Gravitino versions, when I try to force drop the catalog, the error happens.
Additional context
No response