Can't login as an admin "Unexpected error when handling authentication request to identity provider." / "Unable to acquire JDBC Connection" about keycloak

[ssilvert]

@DanielKucal So you were adding a User Profile attribute that has the same name as a realm attribute? Which name?

Since this is a server-side error, I'm going to switch this to the core team.

[pedroigor]

@DanielKucal I'm a bit confused about the steps to reproduce the issue. That error you are facing is kinda a weird one and I'm wondering if isn't the case of adjusting the database pool configuration according to your needs. See https://www.keycloak.org/server/db.

What is the attribute you are trying to add to a user?

[DanielKucal]

So you were adding a User Profile attribute that has the same name as a realm attribute? Which name?

What is the attribute you are trying to add to a user?

@pedroigor @ssilvert exactly, it was a custom name surely not used by Keycloak - "credits"

Here's the exact configuration of the attribute:

BTW is there a way to set default value?

See https://www.keycloak.org/server/db.

I've read that page, but it doesn't mention anything specific for MariaDB except that it was tested with v10.11. The database server I'm currently using is out of my control and has been recently updated from 10.6.16 to 10.6.17, but everything seems to work except this issue.

[pedroigor]

@DanielKucal It does not seem related to the attribute. If you can provide the exact steps to reproduce the problem with the arguments you are using to start the server it should help to continue the investigation.

Otherwise, we can't do much.

We do have tests creating attributes like you are doing and lots of them. Not sure what might be but something related to how your database connection pool is configured.

BTW is there a way to set default value?

Not yet. Please, create an issue/enhancement because I think it makes sense.

[keycloak-github-bot]

Thanks for reporting this issue, but there is insufficient information or lack of steps to reproduce.

Please provide additional details, otherwise this issue will be automatically closed within 14 days.

[keycloak-github-bot]

Due to lack of updates in the last 14 days this issue will be automatically closed.