Edit: I’ve modified the original post to include the below error.
I’ll note that the following error can also be a symptom of the same issue:
ERROR: Database concurrency problems: The path
'Z:\projects\SpaceRocks\shots\ABC_0059' is already associated with
Shotgun entity {'type': 'Shot', 'id': 1809, 'name': 'ABC_0059'}. Please re-run
folder creation to try again.
I’m not sure how the db ends up in this state, but above “How To Fix” steps, save for the first one about roots.yml, should also apply to this error.