Find the root cause behind the CNPG replication sync issue (keycloak, kunai)

As discussed, we need to find the root cause behind the CNPG replication sync issue.

@feleouet May you please share your thoughts on which we need to look on to deal with this issue.

cc @marc.bailly1 @satyawanj @matrohon