We are experiencing the same problem: we see duplicate listings for some of our tables in the “Select a table” dropdown, for one of our linked databases.
Here’s what we have tried:
- We checked our linked postgres database and for views or tables with the same name in another schema. We did not find anything.
- We tried going to
/admin/databases/1 and hitting “Sync databases now” and “Re-scan field values now”. We also tried using “Discard saved field values”. None of these made a difference, even after multiple attempts.
We have not tried using the “Remove this database” button on
/admin/databases/1 because we are concerned that we would lose all of our existing “Questions”.
We have not tried to use psql to investigate the database used by our metabase instance.
Thanks for any guidance on how we might investigate further.