The below has happened ad hoc since go live in similar scenarios.
I just changed the page description on this page and when hitting ‘publish’ got the below error
Exception Occurred: /var/www/vhosts/royalfree.nhs.uk/htdocs/concrete/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:74 An exception occurred while executing ‘INSERT INTO CollectionAttributeValues (cID, cvID, akID, avID) VALUES (?, ?, ?, ?)’ with params [756, 23, 21, 1112162]:
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘756-23-21’ for key ‘CollectionAttributeValues.PRIMARY’ (0)
It made the change when I cleared the error, and prompted me to approve the new version of the page.
Thank you