Charts: [stable/keycloak] Getting miss formatted postgres connection URL

Created on 27 Nov 2018  路  13Comments  路  Source: helm/charts

Is this a BUG REPORT or FEATURE REQUEST? (choose one):
Bug. An exception is thrown during start up on wrongly formatted postgress connection URL.

Version of Helm and Kubernetes:
minikube 0.30.0
kubernetes: 1.10.0
helm: sever / client v2.8.2

Which chart:
Keycloak

What happened:
An exception is thrown during start up on wrongly formatted postgress connection URL.
[31m01:35:50,698 SEVERE [org.postgresql.Driver] (ServerService Thread Pool -- 58) Error in url: jdbc:postgresql://postgres:tcp://10.96.241.80:5432/identity

What you expected to happen:
Start successfully.
Expecting the url to be:
jdbc:postgresql://10.96.241.80:5432/identity

How to reproduce it (as minimally and precisely as possible):
Deploy a postgres db service call it "postgres" with default ports

Deploy Keycloak chart with these settings:

  keycloak:
    username: root
    # Note: this password is only used for first-start of Keycloak
    # future updates are not reflected here.
    password: root
    persistence:
      # We want to use our existing Postgres setup
      deployPostgres: false
      dbVendor: postgres
      dbName: identity
      dbHost: postgres
      dbPort: 5432
      dbUser: postgres
      dbPassword: postgres

The pod should crash with error like this:

0m01:35:50,287 INFO  [org.keycloak.connections.infinispan.DefaultInfinispanConnectionProviderFactory] (ServerService Thread Pool -- 58) Node name: keycloak-0, Site name: null
01:35:50,698 SEVERE [org.postgresql.Driver] (ServerService Thread Pool -- 58) Error in url: jdbc:postgresql://postgres:tcp://10.96.241.80:5432/identity
01:35:50,702 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 58) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: IJ031084: Unable to create connection
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:345)
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:352)
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:287)
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.createConnectionEventListener(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:1326)
    at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreConcurrentLinkedDequeManagedConnectionPool.getConnection(SemaphoreConcurrentLinkedDequeManagedConnectionPool.java:499)
    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:632)
    at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:604)
    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:624)
    at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:430)
    at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:789)
    at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:138)
    at org.jboss.as.connector.subsystems.datasources.WildFlyDataSource.getConnection(WildFlyDataSource.java:64)
    at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.getConnection(DefaultJpaConnectionProviderFactory.java:367)
    at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lazyInit(LiquibaseDBLockProvider.java:65)
    at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda$waitForLock$0(LiquibaseDBLockProvider.java:97)
    at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:611)
    at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.waitForLock(LiquibaseDBLockProvider.java:95)
    at org.keycloak.services.resources.KeycloakApplication$1.run(KeycloakApplication.java:143)
    at org.keycloak.models.utils.KeycloakModelUtils.runJobInTransaction(KeycloakModelUtils.java:227)
    at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:136)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
    at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
    at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
    at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
    at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2676)
    at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:361)
    at org.jboss.resteasy.spi.ResteasyDeployment.startInternal(ResteasyDeployment.java:274)
    at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:86)
    at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:119)
    at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
    at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
    at org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
    at io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
    at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:300)
    at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:140)
    at io.undertow.servlet.core.DeploymentManagerImpl$2.call(DeploymentManagerImpl.java:584)
    at io.undertow.servlet.core.DeploymentManagerImpl$2.call(DeploymentManagerImpl.java:555)
    at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)
    at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
    at org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1514)
    at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:597)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:97)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:78)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
    at java.util.concurrent.FutureTask.run(FutureTask.java:266)
    at org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
    at org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1985)
    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1487)
    at org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1378)
    at java.lang.Thread.run(Thread.java:748)
    at org.jboss.threads.JBossThread.run(JBossThread.java:485)
Caused by: javax.resource.ResourceException: IJ031083: Wrong driver class [org.postgresql.Driver] for this connection URL [jdbc:postgresql://postgres:tcp://10.96.241.80:5432/identity]
    at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createLocalManagedConnection(LocalManagedConnectionFactory.java:323)
    ... 55 more

Anything else we need to know:
Let me know if that is a Keycloak bug.

lifecyclstale
Source
picture Anakin-Hao
👍3

Most helpful comment

Putting this in values.yaml solves the problem for me:

  extraEnv: |
    - name: POSTGRES_PORT
      value: "5432"
picture xabufr on 9 Jan 2019
👍7

All 13 comments

I am experiencing the same issue with a cluster running in Azure by using AKS.

goekhancimsir picture goekhancimsir on 29 Nov 2018
👍2

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Any further update will cause the issue/pull request to no longer be considered stale. Thank you for your contributions.

stale[bot] picture stale[bot] on 30 Dec 2018

@unguiculus any update on this?

Anakin-Hao picture Anakin-Hao on 3 Jan 2019

Same problem here, I think this is related to env var POSTGRES_PORT set by kubernetes to "tcp://10.96.98.33:5432" for me.

xabufr picture xabufr on 9 Jan 2019

The chart doesn't use the POSTGRES_PORT env var at all. I would need more details regarding the configuration to diagnose this. DB_PORT is used as env var which is set here: https://github.com/helm/charts/blob/master/stable/keycloak/templates/_helpers.tpl#L93-L94

unguiculus picture unguiculus on 9 Jan 2019

Putting this in values.yaml solves the problem for me:

  extraEnv: |
    - name: POSTGRES_PORT
      value: "5432"
xabufr picture xabufr on 9 Jan 2019
👍7

This is because variable DB_PORT is overwriten by ${VENDOR}_PORT by the entrypoint here: https://github.com/jboss-dockerfiles/keycloak/blob/2ad45600ab38f15fda294f90cb5aeeb7f31556db/server/tools/docker-entrypoint.sh#L112

I think $POSTGRES_PORT is set by kubernetes because I have a service POSTGRES in the same namespace.

xabufr picture xabufr on 9 Jan 2019
👍4

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Any further update will cause the issue/pull request to no longer be considered stale. Thank you for your contributions.

stale[bot] picture stale[bot] on 8 Feb 2019

This issue is being automatically closed due to inactivity.

stale[bot] picture stale[bot] on 23 Feb 2019

Still a bug.

instantlinux picture instantlinux on 13 Apr 2019
👍4

Still not work for me as well

groovenarula picture groovenarula on 2 May 2019
👍1

Same here using Keycloak 6.0.1

Looks like with the deprecated methods is working

            - name: KEYCLOAK_USER
              value: "admin"
            - name: KEYCLOAK_PASSWORD
              value: "admin"
            - name: DB_VENDOR
              value: "postgres"
            - name: POSTGRES_ADDR
              value: "keycloak-postgres"
            - name: POSTGRES_PORT
              value: "5432"
            - name: POSTGRES_DB
              value: "keycloak"
            - name: POSTGRES_USER
              value: "keycloak"
            - name: POSTGRES_PASSWORD
              value: "keycloak_password"
marinflorin picture marinflorin on 6 May 2019
👍3

_Workaround_: add below docker container Entrypoint in Kubernetes yml.

command: ["/bin/sh","-c"] args: ["export POSTGRES_PORT=5432; /opt/jboss/tools/docker-entrypoint.sh; -b "0.0.0.0"]

Hrushi-kesh picture Hrushi-kesh on 19 Jun 2019
Was this page helpful?
0 / 5 - 0 ratings

Related issues

tyg03485 picture tyg03485  路  3Comments
mluedke picture mluedke  路  3Comments
paskal picture paskal  路  3Comments
kminehart picture kminehart  路  3Comments
gajus picture gajus  路  3Comments