Getting unique constraint violation errors in the Foglight Management Server (FMS) database. In the alert.log of the FMS database the following error occurs:
The unique constraint violation is actually a "normal" condition in Foglight. This is likely caused by two CDT threads attempting to create to logically equivalent objects at the same time. Since the CDTs create two different objects there, it is not locking in the Foglight application itself. Both threads will attempt to insert an object into the database but one thread will encounter this error and then retry the operation, which will end up merging into the object created by the first thread.
