Running keycloak and mysql, worked last week but not anymore

General Discussions General
1

Hello,

I am running Linux Mint 17.3 Rosa .
docker --version = Docker version 18.06.1-ce, build e68fc7a
docker-compose --version = docker-compose version 1.22.0, build f46880fe.

I have a setting where I am running keycloak ( version 4.5 ) and MySQL (version 5.7).
This is how my docker-compose.yml file looks like when I stripped away my services.
The problem right now, it seems that keycloak looses connection to mysql after it has created 91 tables ( 94 tables should be the final stage)
Running this on the PWD (https://labs.play-with-docker.com) works , 94 tables are created and everything is fine.

Could this be some kind of time-out issue after ‘some’ update on my host OS?

The error from the startup log is this " ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) WFLYCTL0190: Step handler org.jboss.as.server.DeployerChainAddHandler$FinalRuntimeStepHandler@553601e1 for operation add-deployer-chains at address failed handling operation rollback – java.util.concurrent.TimeoutException: java.util.concurrent.TimeoutException" .

I am getting some warnings in the keycloak-log previous to this, they are both on my laptop and in my PWD - so I guess they don’t make a difference:

  1. JGRP000015: the send buffer of socket MulticastSocket was set to 1.00MB, but the OS only allocated 212.99KB. This might lead to performance problems. Please set your max send buffer in the OS correctly (e.g. net.core.wmem_max on Linux)
  2. JGRP000015: the receive buffer of socket MulticastSocket was set to 20.00MB, but the OS only allocated 212.99KB. This might lead to performance problems. Please set your max receive buffer in the OS correctly (e.g. net.core.rmem_max on Linux
  3. JGRP000015: the send buffer of socket MulticastSocket was set to 1.00MB, but the OS only allocated 212.99KB. This might lead to performance problems. Please set your max send buffer in the OS correctly (e.g. net.core.wmem_max on Linux
  4. JGRP000015: the receive buffer of socket MulticastSocket was set to 25.00MB, but the OS only allocated 212.99KB. This might lead to performance problems. Please set your max receive buffer in the OS correctly (e.g. net.core.rmem_max on Linux

version: ‘3.3’
services:
keycloak:
image: jboss/keycloak:4.5.0.Final
container_name: keycloak
env_file: ./env/.keycloak
environment:
DB_VENDOR: MYSQL
DB_ADDR: mysql
ports:
- 8080:8080
depends_on:
- mysql

mysql:
image: mysql:5.7
container_name: keycloak-mysql
env_file: ./env/.mysql
volumes:
- testing:/var/lib/mysql

volumes:
testing

env/.keycloak

DB_DATABASE=keycloak
DB_PASSWORD=password
DB_USER=keycloak
KEYCLOAK_LOGLEVEL=DEBUG
KEYCLOAK_USER=admin
KEYCLOAK_PASSWORD=admin
NGINX_PORT=8080
PROXY_ADDRESS_FORWARDING=true
TZ=Europe/Stockholm

env/.mysql

MYSQL_ROOT_PASSWORD=root
MYSQL_DATABASE=keycloak
MYSQL_USER=keycloak
MYSQL_PASSWORD=password

best, Ingimar