yuqi1129 opened a new issue, #13003: URL: https://github.com/apache/gravitino/issues/13003
### Describe the subtask The collector introduced by #12154 checks metadata_object_id/type liveness for generic metadata relations. It does not collect user_role_rel/group_role_rel or owner_meta rows whose owner User/Group was deleted while the owned object remains live. Write-side fencing alone will not repair rows already left by these races. Extend the existing GC framework to soft-delete active memberships with a missing/deleted User, Group, or Role endpoint, and ownership rows with a missing/deleted owner principal. Reuse existing scheduling, batching, retention, and failure-isolation conventions; do not introduce a second cleanup scheduler. Acceptance: - Cover soft-deleted and physically absent endpoints, live relations, stable-ID recreation, owner-type and metalake isolation, and repeated bounded runs. - Cover concurrent valid assignment and cleanup without deleting live relationships. - Preserve relation history and existing hard-delete retention; validate H2, MySQL, and PostgreSQL. This task repairs historical rows independently of the two write-fencing tasks. ### Parent issue https://github.com/apache/gravitino/issues/10238 -- 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]
