Memo not cleaned when user dropped

[crazycatdevs]

I noticed that when an user is dropped (ircop action or just account unregistered), the memo aren't deleted, even if both owner and sender doesn't exist anymore.
And AFAIK, there is no oper command to clean the memos

[sadiepowell]

What database backend are you using? There is a known issue where if Anope shuts down uncleanly it can duplicate SQL objects. I've added some workaround in 2.1 for NickCore/NickAlias/ChannelInfo but not for other types.

[crazycatdevs]

I'm using MariaDb 10.11.18 with Anope 2.0.20 and some memo are pretty old (2024).
And I just dropped an user, the recrord still exists in db (as owner or sender)