[keycloak-user] COMPOSITE_ROLE table duplicate rows issue

[Stian Thorgersen]

Strange. If you can provide steps to reproduce it we can look into it.
Ideally a testcase within our existing testsuite.

On 27 December 2016 at 15:53, Haim Vana <haimv at perfectomobile.com> wrote:

> Hi,
>
> We found an issue with the COMPOSITE_ROLE DB table, the issue might have
> occurred when creating multiple realms in parallel.
>
> We noticed that create realm API fails on timeout and DB showed locks on
> table COMPOSITE_ROLE.
> Further investigation revealed that the COMPOSITE_ROLE table contains a
> lot of duplicate rows, instead of about 4000 rows there were over a million
> rows.
> Deleting the duplicate rows solved the issue.
>
> Any idea what might have caused the duplicated rows ? or how to prevent it
> ?
>
> Also we have about 4000 rows in the COMPOSITE_ROLE row, does it make sense
> for about 160 realms ? (maybe we need to do some cleanup)
>
>
> Thanks,
> Haim.
> The information contained in this message is proprietary to the sender,
> protected from disclosure, and may be privileged. The information is
> intended to be conveyed only to the designated recipient(s) of the message.
> If the reader of this message is not the intended recipient, you are hereby
> notified that any dissemination, use, distribution or copying of this
> communication is strictly prohibited and may be unlawful. If you have
> received this communication in error, please notify us immediately by
> replying to the message and deleting it from your computer. Thank you.
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user
>