Duplicated and missing logs when deleting a page with children in certain conditions

Preconditions: User needs to be Advanced.

Steps to reproduce

1. Go to Sandbox.WebHome
2. Create 20 children under this page (Pag1, Pag2, etc), all with Sandbox.WebHome as parent
3. On Sandbox.WeBHome, click 'More Actions' > 'Delete'
4. Tick 'Affect children'
5. Click 'Delete'
6. Select the entire tree 'Pages that are not mandatory for any extension'
7. Click 'Confirm' button
8. Click 'Delete log'
9. Observe the logs

Expected results

The delete logs start with "Starting job of type [refactoring/delete]..." and end with "Finished job of type [refactoring/delete]..."

All deleted pages are displayed in the logs once.

Actual results

Under some conditions (in my tests I've noticed for ex. right after starting the instance or after some time passed without deleting pages), the deleted pages (Pag1 to Pag 20) are displayed twice (but not all the time, for ex. in the video attached Pag9 isn't duplicated) and the TestPage1, TestPage2 and TestPage3 with last log at the end "Finished job of type [refactoring/delete]..." are missing.

On Page Index though, the TestPage1, TestPage2 and TestPage3 are displayed in the list of deleted pages.

Please see the attached video with the issue that I was able to capture.

The issue could be reproduced on Jetty/HSQL demo package as well and also on XWiki 18.4.0 and was discovered while testing XWIKI-24145.