when trying to perform rebuild from status report then it ended with an error.
The website encountered an unexpected error. Please try again later.Drupal\Core\Database\IntegrityConstraintViolationException: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '40956-40956-permissions_by_term-en' for key 'PRIMARY': INSERT INTO "node_access" ("nid", "langcode", "fallback", "realm", "gid", "grant_view", "grant_update", "grant_delete") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15); Array
(
[:db_insert_placeholder_0] => 40956
[:db_insert_placeholder_1] => en
[:db_insert_placeholder_2] => 1
[:db_insert_placeholder_3] => permissions_by_term
[:db_insert_placeholder_4] => 40956
[:db_insert_placeholder_5] => 1
[:db_insert_placeholder_6] => 0
[:db_insert_placeholder_7] => 0
[:db_insert_placeholder_8] => 40956
[:db_insert_placeholder_9] => en
[:db_insert_placeholder_10] => 1
[:db_insert_placeholder_11] => permissions_by_term
[:db_insert_placeholder_12] => 40956
[:db_insert_placeholder_13] => 1
[:db_insert_placeholder_14] => 0
[:db_insert_placeholder_15] => 0
)
in Drupal\Core\Database\Driver\mysql\ExceptionHandler->handleExecutionException() (line 50 of core\lib\Drupal\Core\Database\Driver\mysql\ExceptionHandler.php). Drupal\Core\Database\StatementWrapper->execute(Array, Array) (Line: 874)
Drupal\Core\Database\Connection->query('INSERT INTO {node_access} ("nid", "langcode", "fallback", "realm", "gid", "grant_view", "grant_update", "grant_delete") VALUES (:db_insert_placeholder_0, :db_insert_placeholder_1, :db_insert_placeholder_2, :db_insert_placeholder_3, :db_insert_placeholder_4, :db_insert_placeholder_5, :db_insert_placeholder_6, :db_insert_placeholder_7), (:db_insert_placeholder_8, :db_insert_placeholder_9, :db_insert_placeholder_10, :db_insert_placeholder_11, :db_insert_placeholder_12, :db_insert_placeholder_13, :db_insert_placeholder_14, :db_insert_placeholder_15)', Array, Array) (Line: 32)
Drupal\Core\Database\Driver\mysql\Insert->execute() (Line: 242)
Drupal\node\NodeGrantDatabaseStorage->write(Object, Array) (Line: 1137)
_node_access_rebuild_batch_operation(Array) (Line: 295)
_batch_process() (Line: 137)
_batch_do() (Line: 93)
_batch_page(Object) (Line: 55)
Drupal\system\Controller\BatchController->batchPage(Object)
call_user_func_array(Array, Array) (Line: 123)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 578)
Drupal\Core\Render\Renderer->executeInRenderContext(Object, Object) (Line: 124)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->wrapControllerExecutionInRenderContext(Array, Array) (Line: 97)
Drupal\Core\EventSubscriber\EarlyRenderingControllerWrapperSubscriber->Drupal\Core\EventSubscriber\{closure}() (Line: 158)
Symfony\Component\HttpKernel\HttpKernel->handleRaw(Object, 1) (Line: 80)
Symfony\Component\HttpKernel\HttpKernel->handle(Object, 1, 1) (Line: 57)
Drupal\Core\StackMiddleware\Session->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\KernelPreHandle->handle(Object, 1, 1) (Line: 106)
Drupal\page_cache\StackMiddleware\PageCache->pass(Object, 1, 1) (Line: 85)
Drupal\page_cache\StackMiddleware\PageCache->handle(Object, 1, 1) (Line: 47)
Drupal\Core\StackMiddleware\ReverseProxyMiddleware->handle(Object, 1, 1) (Line: 52)
Drupal\Core\StackMiddleware\NegotiationMiddleware->handle(Object, 1, 1) (Line: 23)
Stack\StackedHttpKernel->handle(Object, 1, 1) (Line: 717)
Drupal\Core\DrupalKernel->handle(Object) (Line: 19)
Any one, Do you why this occur like this?
| Comment | File | Size | Author |
|---|---|---|---|
| #3 | permission_by_term2.PNG | 12.68 KB | _prasanth_ |
| #3 | permission_by_term1.PNG | 45.46 KB | _prasanth_ |
| #2 | permission_by_term.PNG | 12.38 KB | _prasanth_ |
Comments
Comment #2
_prasanth_ commentedHii,
Any guess for this issue? My sites is in drupal version 8.9.9 .As part of D9 upgrade, now i upgraded to latest D8 version.
Then I found this issue.
Plz find the attached image. that is updated when upgraded to latest D8 version.
Is this cause of these issue?
Comment #3
_prasanth_ commentedComment #4
_prasanth_ commented