500 Internal Server Error while publishing selected content from workspace

While publishing selected content from one workspace to another, I am getting this. But While publishing all there is no issue. I am getting this issue quite often.
Can somebody please help me to understand the exact issue or circumstances?

An exception occurred while executing 'UPDATE neos_contentrepository_domain_model_nodedata SET pathhash = ?, path = ?, parentpathhash = ?, parentpath = ?, lastmodificationdatetime = ?, version = version + 1 WHERE persistence_object_identifier = ?

AND version = ?’ with params [“a78e4a3077fb5493f501de9014e3aaf1”, “/sites/schrack4students/node-hrc66zim8wc5r/node-e0667dri9kejm/node-ij921t29rswzx/node-ibcb63kxkauns/node-hxsajgbiu8kg2/main/node-xq45ksg13t657”, “9fa14ed4cca6610481cd8e11a6059b94”, “/sites/schrack4students/node-hrc66zim8wc5r/node-e0667dri9kejm/node-ij921t29rswzx/node-ibcb63kxkauns/node-hxsajgbiu8kg2/main”, “2021-02-01 13:05:24”, “d3eb41e9-d31e-4891-8823-66d84f6e3d0f”, 3]:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘a78e4a3077fb5493f501de9014e3aaf1-editing-s8d4q-fb11fdde869d0a8fc’ for key ‘UNIQ_CE6515692DBEC7578D94001992F8FB01’
Exception Code 0
Exception Type Doctrine\DBAL\Exception\UniqueConstraintViolationException
Thrown in File Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php
Line 74

Nested Exception
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘a78e4a3077fb5493f501de9014e3aaf1-editing-s8d4q-fb11fdde869d0a8fc’ for key ‘UNIQ_CE6515692DBEC7578D94001992F8FB01’
Exception Code 23000
Exception Type Doctrine\DBAL\Driver\PDOException
Thrown in File Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
Line 143

Nested Exception
SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry ‘a78e4a3077fb5493f501de9014e3aaf1-editing-s8d4q-fb11fdde869d0a8fc’ for key ‘UNIQ_CE6515692DBEC7578D94001992F8FB01’
Exception Code 23000
Exception Type PDOException
Thrown in File Packages/Libraries/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php
Line 141

Thanks in advance!

Hi Anurag :wave:

Did you upgrade your Neos CMS version?

It seems like a missing ./flow node:repair in a upgrade process

1 Like

Thanks for quick response.

I am using Neos 4.x from Last 1 year we did not migrated CMS version since last.
Yes Soren, I did this ./flow node:repair twice but still facing same issue.

Your suggestion for the solution help me a lot.

There are cases where selective publishing doesn’t work currently when certain conditions are met.

F.e. you move a node from one place to another. Then a shadow node exists in the place where the node has been and the node is in the new place.
Now this can happen in several workspaces including live at the same time.

When you do partial publishing this can create errors as another node now wants to be in the place of the shadow node.

I’m currently investigating cases like this for a customer.

It would be great if you could do some research for the node identifiers which cause the problem and verify if it’s a similar issue with moved/deleted nodes.

1 Like

Thank you for your suggestion, I will debug and try to find the route cause node element.
If you find something please share it with me.