Clone region copies page tree id instead of assigning a new one

[svenseeberg]

Describe the Bug

After duplicating a region, the page tree is copied but the tree_id for the new region is keeping the same value as the original tree.

integreat=# SELECT * FROM cms_page WHERE tree_id=221;
  id  |         created_date          | explicitly_archived | lft | rgt | tree_id | depth | mirrored_page_first | icon_id | mirrored_page_id | organization_id | parent_id | region_id 
------+-------------------------------+---------------------+-----+-----+---------+-------+---------------------+---------+------------------+-----------------+-----------+-----------
 2681 | 2022-02-21 19:52:46+00        | f                   |   2 |   7 |     221 |     2 | t                   |    5041 |                  |                 |      2680 |       160
 2682 | 2022-02-21 19:52:46+00        | f                   |   3 |   4 |     221 |     3 | t                   |         |                  |                 |      2681 |       160
 2683 | 2022-02-21 19:52:46+00        | f                   |   5 |   6 |     221 |     3 | t                   |         |                  |                 |      2681 |       160
 2757 | 2022-03-03 15:14:11.79442+00  | f                   |  12 |  17 |     221 |     2 | t                   |   18036 |                  |                 |      2680 |       136
 2680 | 2022-02-21 19:52:46+00        | f                   |   1 |  18 |     221 |     1 | t                   |    5251 |                  |                 |           |       160
 2758 | 2022-03-03 15:16:46.809255+00 | f                   |  15 |  16 |     221 |     3 | t                   |         |                  |                 |      2757 |       136
 2756 | 2022-03-03 14:57:47.883672+00 | f                   |  13 |  14 |     221 |     3 | t                   |         |                  |                 |      2757 |       136
 2684 | 2022-02-21 19:52:46+00        | f                   |   8 |   9 |     221 |     2 | t                   |    5054 |                  |                 |      2680 |       160
 2685 | 2022-02-21 19:52:46+00        | f                   |  10 |  11 |     221 |     2 | t                   |    5345 |                  |                 |      2680 |       160
  994 | 2022-02-21 19:52:46+00        | f                   |   5 |   6 |     221 |     3 | t                   |         |                  |                 |       990 |       136
  993 | 2022-02-21 19:52:46+00        | f                   |   3 |   4 |     221 |     3 | t                   |         |                  |                 |       990 |       136
  992 | 2022-02-21 19:52:46+00        | f                   |  10 |  11 |     221 |     2 | t                   |    5345 |                  |                 |       989 |       136
  991 | 2022-02-21 19:52:46+00        | f                   |   8 |   9 |     221 |     2 | t                   |    5054 |                  |                 |       989 |       136
  989 | 2022-02-21 19:52:46+00        | f                   |   1 |  18 |     221 |     1 | t                   |    5251 |                  |                 |           |       136
  990 | 2022-02-21 19:52:46+00        | f                   |   2 |   7 |     221 |     2 | t                   |    5041 |                  |                 |       989 |       136

Other tree IDs with 2 root pages: 236, 230, 238, 234

Expected Behavior

Only one root page per tree.

Additional Information

This is a remant of the migration.

[svenseeberg]

It seems that all translations are fully redundant for the duplicate pages. That means we can probably just delete one page and all of its translations.

The same is happening in the test CMS with the following tree IDs: 160, 357, 358, 165, 168, 163, 158, 165

[svenseeberg]

Moved to https://issues.tuerantuer.org/browse/INFRA-169

[timobrembeck]

I could reproduce this locally on develop. Duplicating a region causes duplicate tree ids for different trees of different regions, because the pages are just copied without the value of the tree_id field changed.