"Ghost" published record

[liotf]

I deleted all "test" published records from the archive (both from the database and Elasticsearch).
However, the "test" published record "Test of resistivity of metal B" still appears in "My records". Other "test" published records that I owned do no longer appear, as expected.

[liotf]

I deleted Elasticsearch indexes, recreated indexes, then created documents from the database. The "ghost" record is still present, in particular in the rdmrecords-drafts-draft-v5.0.0-1669024912 index. Thus, the problem seems to come from the database, maybe from a table that stores metadata of draft records.

[liotf]

Idea: import a dump of the production database into a development database, try to delete the entry in the rdm_drafts_metadata table using a DELETE query, and then perform a few tests.