Can't delete smime certificate - ERROR: duplicate key value violates unique constraint

[rolfschmidt]

Infos:

• Used Zammad version: 5.1
• Installation method (source, package, ..): all
• Operating system: all
• Database + version: all
• Elasticsearch version: all
• Browser + version: all
• Ticket: #10104475

Expected behavior:

• No errors

Actual behavior:

2.7.4 :013 > SMIMECertificate.find(3).destroy
Traceback (most recent call last):
        4: from (irb):13
        3: from app/models/application_model/has_recent_views.rb:20:in `recent_view_destroy'
        2: from app/models/recent_view.rb:31:in `log_destroy'
        1: from app/models/object_lookup.rb:21:in `by_name'
ActiveRecord::RecordNotUnique (PG::UniqueViolation: ERROR:  duplicate key value violates unique constraint "index_object_lookups_on_name")
DETAIL:  Key (lower(name::text))=(smimecertificate) already exists.

Steps to reproduce the behavior:

• Have an old instance
• Try to delete an smime certificate

Yes I'm sure this is a bug and no feature request or a general question.