FANNG1 opened a new issue, #6157:
URL: https://github.com/apache/gravitino/issues/6157
### 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_
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
