In PDB-4312, we discovered that the unique constraint on the resource_events table didn't work as desired, since one of the columns allowed null.
Look through the schema and find any unique constraints that have columns that allow nulls and address accordingly (via migrations, etc)