Docker Compose, MariaDB on Windows #19225

costerutilo · 2023-03-22T08:32:18Z

costerutilo
Mar 22, 2023

I'm trying to start Keycloak 21.0.1 with a MariaDB on a Windows system but I get a connection error.

compose.yml

version: '3.9'

services:
  mysql:
    image: docker.io/mariadb:10
    command: ['mysqld', '--innodb-flush-method=fsync', '--character-set-server=utf8mb4', '--collation-server=utf8mb4_unicode_ci']
    environment:
      MARIADB_DATABASE: ${KEYCLOAK_DB_NAME}
      MARIADB_ROOT_PASSWORD: ${MARIADB_ROOT_PASSWORD}
      MARIADB_PASSWORD: ${KEYCLOAK_DB_PASSWORD}
      MARIADB_USER: ${KEYCLOAK_DB_USER}
    volumes:
      # save mysql data on home folder:
      - 'C:\data:/var/lib/mysql'
    ports:
      - 3306:3306
    restart: always
    networks:
      - default

  keycloak:
    image: quay.io/keycloak/keycloak:21.0.1
    container_name: keycloak
    environment:
      KC_HOSTNAME: localhost
      KC_HOSTNAME_PORT: 8080
      KC_HOSTNAME_STRICT_BACKCHANNEL: "true"
      KC_DB: mariadb
      KC_DB_URL_HOST: mysql
      KC_DB_URL_PORT: 3306
      KC_DB_URL_DATABASE: ${KEYCLOAK_DB_NAME}
      KC_DB_USERNAME: ${KEYCLOAK_DB_USER}
      KC_DB_PASSWORD: ${KEYCLOAK_DB_PASSWORD}
      KEYCLOAK_ADMIN: admin
      KEYCLOAK_ADMIN_PASSWORD: ${KEYCLOAK_PASSWORD}
      #KC_HEALTH_ENABLED: "true"
      KC_LOG_LEVEL: info
    # In Keycloak 21 new micro base image is used , so 'curl' no longer included in Image so healthcheck will not work anymore.
    # healthcheck:
    #  test: [ "CMD", "curl", "-f", "http://localhost:8080/health/ready" ]
    #  interval: 15s
    #  timeout: 2s
    #  retries: 15
    command: start-dev
    ports:
      - 8080:8080
    depends_on:
      - mysql
    networks:
      - default

Logs:

2023-03-22 08:19:38,382 ERROR [org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService] (main) Database error during release lock: liquibase.exception.DatabaseException: java.sql.SQLNonTransientConnectionException: (conn=4) Socket error
        at liquibase.database.jvm.JdbcConnection.commit(JdbcConnection.java:275)
        at liquibase.database.AbstractJdbcDatabase.commit(AbstractJdbcDatabase.java:1167)
        at org.keycloak.connections.jpa.updater.liquibase.lock.CustomLockService.releaseLock(CustomLockService.java:271)
        at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.lambda$releaseLock$3(LiquibaseDBLockProvider.java:133)
        at org.keycloak.models.utils.KeycloakModelUtils.suspendJtaTransaction(KeycloakModelUtils.java:879)
        at org.keycloak.connections.jpa.updater.liquibase.lock.LiquibaseDBLockProvider.releaseLock(LiquibaseDBLockProvider.java:128)
        at org.keycloak.models.dblock.DBLockGlobalLockProvider.releaseLock(DBLockGlobalLockProvider.java:88)
        at org.keycloak.models.dblock.DBLockGlobalLockProvider.withLock(DBLockGlobalLockProvider.java:79)
        at org.keycloak.models.locking.GlobalLockProvider.withLock(GlobalLockProvider.java:45)
        at org.keycloak.quarkus.runtime.storage.legacy.database.LegacyJpaConnectionProviderFactory.update(LegacyJpaConnectionProviderFactory.java:292)
        at org.keycloak.quarkus.runtime.storage.legacy.database.LegacyJpaConnectionProviderFactory.createOrUpdateSchema(LegacyJpaConnectionProviderFactory.java:261)
        at org.keycloak.quarkus.runtime.storage.legacy.database.LegacyJpaConnectionProviderFactory.postInit(LegacyJpaConnectionProviderFactory.java:129)
        at org.keycloak.quarkus.runtime.integration.QuarkusKeycloakSessionFactory.init(QuarkusKeycloakSessionFactory.java:105)
        at org.keycloak.quarkus.runtime.integration.jaxrs.QuarkusKeycloakApplication.createSessionFactory(QuarkusKeycloakApplication.java:41)
        at org.keycloak.services.resources.KeycloakApplication.startup(KeycloakApplication.java:124)
        at org.keycloak.quarkus.runtime.integration.QuarkusLifecycleObserver.onStartupEvent(QuarkusLifecycleObserver.java:37)
        at org.keycloak.quarkus.runtime.integration.QuarkusLifecycleObserver_Observer_onStartupEvent_b0e82415b143738dc1f986a5fa4668e83d0a5dea.notify(Unknown Source)
        at io.quarkus.arc.impl.EventImpl$Notifier.notifyObservers(EventImpl.java:326)
        at io.quarkus.arc.impl.EventImpl$Notifier.notify(EventImpl.java:308)
        at io.quarkus.arc.impl.EventImpl.fire(EventImpl.java:76)
        at io.quarkus.arc.runtime.ArcRecorder.fireLifecycleEvent(ArcRecorder.java:131)
        at io.quarkus.arc.runtime.ArcRecorder.handleLifecycleEvents(ArcRecorder.java:100)
        at io.quarkus.deployment.steps.LifecycleEventsBuildStep$startupEvent1144526294.deploy_0(Unknown Source)
        at io.quarkus.deployment.steps.LifecycleEventsBuildStep$startupEvent1144526294.deploy(Unknown Source)
        at io.quarkus.runner.ApplicationImpl.doStart(Unknown Source)
        at io.quarkus.runtime.Application.start(Application.java:101)
        at io.quarkus.runtime.ApplicationLifecycleManager.run(ApplicationLifecycleManager.java:110)
        at io.quarkus.runtime.Quarkus.run(Quarkus.java:70)
        at org.keycloak.quarkus.runtime.KeycloakMain.start(KeycloakMain.java:102)
        at org.keycloak.quarkus.runtime.cli.command.AbstractStartCommand.run(AbstractStartCommand.java:37)
        at picocli.CommandLine.executeUserObject(CommandLine.java:1939)
        at picocli.CommandLine.access$1300(CommandLine.java:145)
        at picocli.CommandLine$RunLast.executeUserObjectOfLastSubcommandWithSameParent(CommandLine.java:2358)
        at picocli.CommandLine$RunLast.handle(CommandLine.java:2352)
        at picocli.CommandLine$RunLast.handle(CommandLine.java:2314)
        at picocli.CommandLine$AbstractParseResultHandler.execute(CommandLine.java:2179)
        at picocli.CommandLine$RunLast.execute(CommandLine.java:2316)
        at picocli.CommandLine.execute(CommandLine.java:2078)
        at org.keycloak.quarkus.runtime.cli.Picocli.parseAndRun(Picocli.java:93)
        at org.keycloak.quarkus.runtime.KeycloakMain.main(KeycloakMain.java:88)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
        at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
        at java.base/java.lang.reflect.Method.invoke(Method.java:568)
        at io.quarkus.bootstrap.runner.QuarkusEntryPoint.doRun(QuarkusEntryPoint.java:61)
        at io.quarkus.bootstrap.runner.QuarkusEntryPoint.main(QuarkusEntryPoint.java:32)
Caused by: java.sql.SQLNonTransientConnectionException: (conn=4) Socket error
        at org.mariadb.jdbc.export.ExceptionFactory.createException(ExceptionFactory.java:293)
        at org.mariadb.jdbc.export.ExceptionFactory.create(ExceptionFactory.java:359)
        at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:863)
        at org.mariadb.jdbc.client.impl.StandardClient.readResults(StandardClient.java:779)
        at org.mariadb.jdbc.client.impl.StandardClient.readResponse(StandardClient.java:698)
        at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:641)
        at org.mariadb.jdbc.client.impl.StandardClient.execute(StandardClient.java:515)
        at org.mariadb.jdbc.Connection.commit(Connection.java:209)
        at io.agroal.pool.wrapper.ConnectionWrapper.commit(ConnectionWrapper.java:203)
        at liquibase.database.jvm.JdbcConnection.commit(JdbcConnection.java:272)
        ... 45 more
Caused by: java.io.EOFException: unexpected end of stream, read 0 bytes from 4 (socket was closed by server)
        at org.mariadb.jdbc.client.socket.impl.PacketReader.readPacket(PacketReader.java:78)
        at org.mariadb.jdbc.message.ClientMessage.readPacket(ClientMessage.java:118)
        at org.mariadb.jdbc.client.impl.StandardClient.readPacket(StandardClient.java:840)
        ... 52 more

2023-03-22 08:19:38,385 WARN  [io.agroal.pool] (main) Datasource '<default>': (conn=4) Connection is closed
2023-03-22 08:19:38,386 WARN  [io.agroal.pool] (main) Datasource '<default>': (conn=3) Connection is closed
2023-03-22 08:19:38,532 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to start server in (development) mode
2023-03-22 08:19:38,532 ERROR [org.keycloak.quarkus.runtime.cli.ExecutionExceptionHandler] (main) ERROR: Failed to update database

Thank you for your help!

Navigation Menu

Repository navigation

Docker Compose, MariaDB on Windows #19225

Uh oh!

{{title}}

Uh oh!

Replies: 0 comments

Select a reply

Uh oh!

Docker Compose, MariaDB on Windows #19225

Uh oh!

costerutilo Mar 22, 2023

Replies: 0 comments

costerutilo
Mar 22, 2023