When publishing in Sites 9.6 some transactions will sometimes fail with the below error in the deployer log:
ERROR [ProcessingAkkaSpringContext-akka.actor.default-dispatcher-1680] SqlExceptionHelper - Violation of PRIMARY KEY constraint 'PK_PAGE_COMPONENT_LINK'. Cannot insert duplicate key in object 'dbo.PAGE_COMPONENT_LINK'