Duplicate stable IDs found

[davidgamez]

Describe the bug

The following feeds have duplicated stable ids:

• mdb-2345
• ntd-30019
• ntd-30030
• ntd-30112
• ntd-40
• ntd-66343
• ntd-80006
• ntd-90164

Steps/Code to Reproduce

• Execute the following query:

SELECT distinct feed_stable_id
FROM feedsearch
WHERE 
  feed_stable_id IN (
    SELECT feed_stable_id
    FROM feedsearch
    GROUP BY feed_stable_id
    HAVING COUNT(*) > 1
  )
 order by feed_stable_id

Expected Results

No duplicate feeds must appear in the result. Add unique to the DB to avoid duplicate stable IDs.

Actual Results

Multiple feeds contain the same stable_id.

Screenshots

No response

Files used

No response

Additional notes

Only one feed by stable_id has operational_status equal to published. This may be a side effect of the retool update or old data that was not properly ingested.

[qcdyx]

I can create and run a script to clean up the database by deleting the duplicate feeds that are not in a "published" state. Then merge #1363 after cleanup. Does this sound good to you? @davidgamez

[davidgamez]

Updated duplicates, adding {feed_id}-{number} for all feeds that were in wip status.