Hi again,
There are several ocassions that we are getting exceptions coming out of Olympia that usually ended up on having to restart services with direct connection to it.
These are the exceptions:
06-03-2020 12:45:56.508 [EXCEPT] [ThreadId: 9756] [PID: 8044] MessageBroker exception for session {0311AA1F-C5BF-4A5C-A940-7E42AA63A23D}.: Exception EROUnregisteredServerException in module GX.Cerberus.exe at 000000000087C511.
An exception was raised on the server: Violation of PRIMARY KEY constraint ‘PK__EVENTSUB’. Cannot insert duplicate key in object ‘dbo.EVENTSUBSCRIPTIONS’. The duplicate key value is (3652fafa-598e-41a0-a392-8066817e588a, *).
The statement has been terminated.
06-03-2020 12:51:26.749 [EXCEPT] [ThreadId: 4404] [PID: 8044] MessageBroker exception for session {0311AA1F-C5BF-4A5C-A940-7E42AA63A23D}.: Exception EROUnregisteredServerException in module GX.Cerberus.exe at 000000000087C511.
An exception was raised on the server: Violation of PRIMARY KEY constraint ‘PK__EVENTSUB’. Cannot insert duplicate key in object ‘dbo.EVENTSUBSCRIPTIONS’. The duplicate key value is (e1e0849c-e131-40b4-8e92-9e3707956260, *).
The statement has been terminated.
06-03-2020 13:01:40.055 [EXCEPT] [ThreadId: 3568] [PID: 8044] MessageBroker exception for session {0311AA1F-C5BF-4A5C-A940-7E42AA63A23D}.: Exception EROUnregisteredServerException in module GX.Cerberus.exe at 000000000087C511.
An exception was raised on the server: Violation of PRIMARY KEY constraint ‘PK__EVENTSUB’. Cannot insert duplicate key in object ‘dbo.EVENTSUBSCRIPTIONS’. The duplicate key value is (733b63d5-fce0-4c4b-958c-76b63c92b186, *).
The statement has been terminated.
Those are messages coming directly from Olympia and trigger on the Olympia OnException event.
Shortly after that, service will stop responding and die.
No idea how internally the possibility of duplicates its being managed by Olympia or if it eventually leads to a catastrophic failure of some kind, dropping a client, a connection or some like that.