Acquia Cohesion renames to Site Studio from version 6.2. Tell me more.

Why is my cohesion_layout_revision table so large?

Cohesion layout revisions are created at the same time as node revisions, but not always deleted at the same time.

Cohesion Layout revisions are being created and deleted whenever a node revision is created or deleted. This means that for each revision of the node with Layout Canvas there will be a Cohesion Layout Revision entity. This is normal behaviour for revisionable content entities in Drupal, however in specific scenarios it can become problematic if regularly updated nodes have a long lifespan (Homepage Node, for example).

There is an unresolved issue in Drupal Core about entity reference field items not being removed when the referenced entity is deleted. This applies to Cohesion Layout Revision entities. This means that if a node is deleted, the deletion process removes the node and its revisions, but not composite entities referenced by the node. In the case of Site Studio, this means that Cohesion Layout Revisions for deleted nodes are being left in the database as orphaned entities.
For more information, see Managing revisions.

DX8 knowledge base icon

Frequently asked questions

Get instant answers to common questions. Available online 24/7.

Find answers

Raise a ticket icon

Raise a support ticket

To raise a ticket, sign into Acquia Cloud and select Help in the top menu.

Raise support ticket


Copyright © 2020 Acquia, Inc. All Rights Reserved. Drupal is a registered trademark of Dries Buytaert.