What happened?

Description

Kind of a follow-up to #16740

Different project, but again, I have a multi-site with two sites and a matrix field inside another matrix field. I changed the propagation method of the nested matrix field from Save entries to all sites the owner element is saved in to Only save entries to the site they were created in. As expected, an ApplyNewPropagationMethod queue job is created and deduplicates the existing contents for all entries on both sites.

After the queue job has finished, the sort order of the entries in the matrix field is incorrect in one of the sites. All entries got mixed around seemingly randomly. This only happened in one of the sites. In the primary site, which is also the site where all entries were created initially, the order of the matrix entries is still correct. But on the second site, the matrix entries are shuffled around.

This time, this happened in my dev environment and I can reliably reproduce it.

Steps to reproduce

See above.

Craft CMS version

5.6.11

PHP version

8.3

Operating system and version

No response

Database type and version

No response

Image driver and version

No response

Installed plugins and versions

No response