provider-sql icon indicating copy to clipboard operation
provider-sql copied to clipboard

Deleting a MySQL User resource and then deleting a MySQL Grant resource linked to it causes the Grant deletion to hang

Open danports opened this issue 2 years ago • 8 comments

Grant deletion never occurs, and this warning repeats endlessly:

Warning  CannotObserveExternalResource  managed/grant.mysql.sql.crossplane.io  cannot show current grants: Error 1141: There is no such grant defined for user 'test-app' on host '%!'(MISSING)

This is on Crossplane 1.3.0 and MySQL 5.7. Can work on a repro case a bit later. The issue can be worked around by manually editing the Grant resource and removing the Crossplane finalizer.

danports avatar Jul 19 '21 02:07 danports