Hello @Dimitrios Gkiokas,
Thank you for your response and for sharing additional details about the task you are performing.
The scenario you are facing is an expected one, as there is a replication delay between the nodes. It's challenging to provide a guaranteed timeframe for this, as it largely depends on network connectivity and other contributing factors.
For more information, please refer to the following developer blog post, which explains this issue in detail with a flow diagram and provides workarounds for such situations:
I hope this information is helpful. Please feel free to reach out if you have any further questions.
If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Thanks,
Raja Pothuraju.