Skip to content

[Bug report] force drop catalog failed for model table not exists #6157

Closed
@FANNG1

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

Metadata

Assignees

No one assigned

    Labels

    bugSomething isn't working

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions