Allow users to remove composite revisions without parent id value in the manual cleanup process

mysql> select * from paragraphs_item_field_data where parent_id is NULL limit 10; +-----+-------------+------------------+----------+------+--------+------------+-----------+-------------+-------------------+------------------+-------------------+-------------------------------+ | id | revision_id | type | langcode | uid | status | created | parent_id | parent_type | parent_field_name | default_langcode | behavior_settings | revision_translation_affected | +-----+-------------+------------------+----------+------+--------+------------+-----------+-------------+-------------------+------------------+-------------------+-------------------------------+ | 551 | 551 | three_up_package | pt-br | 56 | 1 | 1498144196 | NULL | NULL | NULL | 1 | a:0:{} | 1 | | 556 | 556 | three_up_package | pt-br | 56 | 1 | 1498144352 | NULL | NULL | NULL | 1 | a:0:{} | 1 | | 561 | 561 | three_up_package | pt-br | 66 | 1 | 1498144486 | NULL | NULL | NULL | 1 | a:0:{} | 1 | ...

Comments & Activities

Not all content is available!

It's likely this issue predates Contrib.social: some issue and comment data are missing.

Comment 3 months ago →

🇪🇸Spain fjgarlin

In my case, I removed orphaned paragraphs via drush err:purge paragraph and it got rid of many, but there seems to be "leftovers". I deleted the fields with the paragraph reference completely and then ran the command afterwards.

When I know query the DB I get:

select type, count(*) as count
    -> from paragraphs_item
    -> where type in ('deleted_paragraph_type_1', 'deleted_paragraph_type_2', 'deleted_paragraph_type_3', 'deleted_paragraph_type_4')
    -> group by type
    -> order by count desc;
+--------------------------+-------+
| type                     | count |
+--------------------------+-------+
| deleted_paragraph_type_1 |  6060 |
| deleted_paragraph_type_2 |  4038 |
| deleted_paragraph_type_3 |  2799 |
| deleted_paragraph_type_4 |  1741 |
+--------------------------+-------+

Which match exactly with all the records that have no parent information here.

> select count(*) from paragraphs_item_field_data where parent_type is null and parent_id is null and parent_field_name is null;
+----------+
| count(*) |
+----------+
|    14638 |
+----------+

In my case, these are clearly orphaned, but I am unsure about the best way to clean them up as drush err:purge paragraph is not detecting them.

Allow users to remove composite revisions without parent id value in the manual cleanup process

Problem/Motivation

Proposed resolution

Remaining tasks

User interface changes

API changes

Data model changes

Release notes snippet

Comments & Activities