Skip to content

Conversation

@ahus1
Copy link
Contributor

@ahus1 ahus1 commented Sep 4, 2024

I tested using example data and explain plains that the index is not used on MariaDB, PostgreSQL and OracleDB. Also got confirmation from @sschu that MSSQL will not need it.

Closes #32583

@ahus1
Copy link
Contributor Author

ahus1 commented Sep 5, 2024

@mhajas - please review when you have the time. Thanks!

Copy link
Contributor

@mhajas mhajas left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

I checked the queries we are making against the client session table and I agree the index can be dropped. Thank you @ahus1 for the PR and analysis.

@mhajas mhajas merged commit ca951c3 into keycloak:main Sep 6, 2024
@koelle25
Copy link
Contributor

koelle25 commented Oct 10, 2024

This migration fails and therefore prohibits the Keycloak startup when the index is not existing in the first place. It should be checked and MARK_RAN like here: jpa-changelog-24.0.2.xml.

I will create an issue for it and try to make a corresponding PR.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Projects

None yet

Development

Successfully merging this pull request may close these issues.

Review the number indexes for offline session tables

3 participants