node_access_rebuild_progressive: Integrity constraint violation

Created on 29 April 2025, about 1 month ago

I have about 2 million entries to recalculate, and after 700K I get following error in drush output:

SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1979389-3-nodeaccess_role-nl' for key node_access.PRIMARY

It's on a production system, as far as I know the database is in a correct state. I also ran it during the night so there's little chance someone was changing data manually.

🐛 Bug report
Status

Active

Version

2.0

Component

Code

Created by

Live updates comments and jobs are added and updated live.
Sign in to follow issues

Comments & Activities

Production build 0.71.5 2024