Comunication error with MYSQL database

[hgpedro]

I changed the database communication from postgres to mysql in apiman, and I get some errors. Below are some errors that I have in communication with the database because checking locally my database already has these tables.

My docker-compose:

version: '3.9'

services:
  mysql:
    image: mysql:8.0
    container_name: mysql-test-apiman-db
    environment:
      MYSQL_ROOT_PASSWORD: pedro123
    volumes:
      - ./common/:/docker-entrypoint-initdb.d/
    ports:
      - "3306:3306"
    restart: always
  
  apiman-manager:
    image: apiman/wildfly-manager:3.1.3.Final
    depends_on:
      - keycloak
      - mysql
    environment:
      # Keycloak SSO config
      - "APIMAN_AUTH_URL=${KEYCLOAK_PRIVATE_ENDPOINT}"
      - "APIMAN_AUTH_PUBLIC_URL=${KEYCLOAK_PUBLIC_ENDPOINT}"
      - "APIMAN_AUTH_REALM=${KEYCLOAK_REALM}"
      - "APIMAN_AUTH_API_SECRET=${KEYCLOAK_APIMAN_API_SECRET}"
      - "APIMAN_AUTH_UI_SECRET=${KEYCLOAK_APIMAN_UI_SECRET}"
      # Apiman Manager database config
      - "APIMAN_DB_DRIVER=mysql8"
      - "APIMAN_DB_URL=jdbc:mysql://mysql:3306/apiman?useSSL=false&serverTimezone=UTC"
      - "APIMAN_DB_USERNAME=${MYSQL_USERNAME}"
      - "APIMAN_DB_PASSWORD=${MYSQL_PASSWORD}"
      # Apiman Elasticsearch metrics config
      - "APIMAN_ES_PROTOCOL=${ELASTICSEARCH_PROTOCOL}"
      - "APIMAN_ES_HOST=${ELASTICSEARCH_HOST}"
      - "APIMAN_ES_PORT=${ELASTICSEARCH_PORT}"
      - "APIMAN_ES_ALLOW_SELF_SIGNED=true"
      - "APIMAN_ES_ALLOW_ANY_HOST=true"
      - "APIMAN_ES_TRUST_ALL=true"
      # General Apiman config
      - "ALLOW_ANY_HOST=${SELF_SIGNED}"
      - "APIMAN_MANAGER_UI_ENDPOINT=${APIMAN_MANAGER_UI_ENDPOINT}"
      - "APIMAN_MANAGER_API_ENDPOINT=${APIMAN_MANAGER_API_ENDPOINT}"
    volumes:
      - type: bind
        source: "$PWD/data/apiman.properties"
        target: /opt/jboss/wildfly/standalone/configuration/apiman.properties
      - type: bind
        source: "$PWD/data/default-gateway.json"
        target: /opt/jboss/wildfly/standalone/data/bootstrap/default-gateway.json
    logging:
      driver: "json-file"
      options:
        max-size: "10m"
        max-file: "10"
        mode: non-blocking
    labels:
      - traefik.http.routers.apimanui-router.entrypoints=http
      - traefik.http.routers.apimanui-router.rule=Host(`apiman.${APIMAN_HOSTNAME}`)
      - traefik.http.routers.apimanui-router.rule=PathPrefix(`/apiman`, `/apimanui`, `/portal`)
      - traefik.http.routers.apimanui-router.service=apimanui-service
      - traefik.http.services.apimanui-service.loadbalancer.server.port=8080

    restart: unless-stopped
    healthcheck:
      test: curl -s -f http://apiman-manager:8080/apiman/system/status &>/dev/null; if [[ $$? == 0 ]]; then echo 0; else echo 1; fi

  apiman-gateway:
    image: apiman/vertx-gateway:3.1.3.Final
    depends_on:
      - mysql
    environment:
      - >-
        APIMAN_GATEWAY_OPTS=-Dapiman.gateway.public-endpoint=${APIMAN_GATEWAY_PUBLIC_ENDPOINT}
        -Dapiman.es.host=${ELASTICSEARCH_HOST}
        -Dapiman.es.protocol=${ELASTICSEARCH_PROTOCOL}
        -Dapiman.es.port=${ELASTICSEARCH_PORT}
        -Dapiman.es.username=
        -Dapiman.es.password=
        -Dapiman.es.timeout=10000
        -Dapiman.auth.url=${KEYCLOAK_PRIVATE_ENDPOINT}
        -Dapiman.auth.realm=${KEYCLOAK_REALM}
        -Dapiman.auth.gateway.secret=${KEYCLOAK_GATEWAY_SECRET}
        -Dapiman.auth.public-endpoint=${KEYCLOAK_PUBLIC_ENDPOINT:-}
        -Dapiman.auth.private-endpoint=${KEYCLOAK_PRIVATE_ENDPOINT:-}
        -DallowSelfSigned=${SELF_SIGNED}
        -DallowAnyHost=${SELF_SIGNED}
        -DcachingPolicy.maxCacheSize=${MAX_CACHE_SIZE_IN_MB}
        -Dapiman.gateway-allowedProtocols=${TLS_ALLOWED_PROTOCOLS:-}
        -Dapiman.es.keystore=${GATEWAY_ES_KEYSTORE:-}
        -Dapiman.es.keystore.password=${GATEWAY_ES_KEYSTORE_PASSWORD:-}
        -Dapiman.es.truststore=${GATEWAY_ES_TRUSTSTORE:-}
        -Dapiman.es.truststore.password=${GATEWAY_ES_TRUSTSTORE_PASSWORD:-}
        -Dapiman.keycloak.keystore=${GATEWAY_KEYCLOAK_KEYSTORE:-}
        -Dapiman.keycloak.keystore.password=${GATEWAY_KEYCLOAK_KEYSTORE_PASSWORD:-}
        -Dapiman.keycloak.truststore=${GATEWAY_KEYCLOAK_TRUSTSTORE:-}
        -Dapiman.keycloak.truststore.password=${GATEWAY_KEYCLOAK_TRUSTSTORE_PASSWORD:-}
        -Dapiman.gateway.client-keystore=${GATEWAY_CLIENT_KEYSTORE:-}
        -Dapiman.gateway.client-keystore.password=${GATEWAY_CLIENT_KEYSTORE_PASSWORD:-}
        -Dapiman.gateway.client-truststore=${GATEWAY_CLIENT_TRUSTSTORE:-}
        -Dapiman.gateway.client-truststore.password=${GATEWAY_CLIENT_TRUSTSTORE_PASSWORD:-}
        -Dapiman.gateway.backend-keystore=${GATEWAY_BACKEND_KEYSTORE:-}
        -Dapiman.gateway.backend-keystore.password=${GATEWAY_BACKEND_KEYSTORE_PASSWORD:-}
        -Dapiman.gateway.backend-truststore=${GATEWAY_BACKEND_TRUSTSTORE:-}
        -Dapiman.gateway.backend-truststore.password=${GATEWAY_BACKEND_TRUSTSTORE_PASSWORD:-}
    volumes:
      - type: bind
        source: "$PWD/data/conf-es.json"
        target: /opt/apiman/configs/conf-es.json
      - type: volume
        source: gateway_logs
        target: /usr/src/apiman/apiman-distro-vertx/logs

    logging:
      driver: "json-file"
      options:
        max-size: "10m"
        max-file: "10"
        mode: non-blocking
    restart: unless-stopped
    labels:
      - traefik.http.routers.gateway-router.entrypoints=http
      - traefik.http.routers.gateway-router.rule=Host(`gateway.${APIMAN_HOSTNAME}`)
      - traefik.http.routers.gateway-router.service=gateway-service
      - traefik.http.services.gateway-service.loadbalancer.server.port=8080

  elasticsearch:
    image: elasticsearch:7.17.10
    environment:
      - discovery.type=single-node
      - bootstrap.memory_lock=true
      - ES_JAVA_OPTS=-Xms${ELASTICSEARCH_JAVA_MEMORY} -Xmx${ELASTICSEARCH_JAVA_MEMORY}
      - xpack.security.enabled=false
    ulimits:
      memlock:
        soft: -1
        hard: -1
      nofile:
        soft: 65536
        hard: 65536
      nproc:
        soft: 4096
        hard: 4096
    volumes:
      - type: volume
        source: elasticsearch_data
        target: /usr/share/elasticsearch/data
    logging:
      driver: "json-file"
      options:
        max-size: "10m"
        max-file: "10"
        mode: non-blocking
    healthcheck:
      test: curl -s http://elasticsearch:9200 >/dev/null; if [[ $$? == 52 ]]; then echo 0; else echo 1; fi
      interval: 30s
      timeout: 10s
      retries: 5
    restart: unless-stopped

  keycloak:
    image: quay.io/keycloak/keycloak:21.1.2
    entrypoint: [ '/bin/bash', '-c' ]
    command:
      - |
        cd /opt/keycloak
        ./bin/kc.sh build
        ./bin/kc.sh start-dev --import-realm --log=console --spi-login-protocol-openid-connect-legacy-logout-redirect-uri=true
    environment:
      # Import realm with these secrets at first startup
      - 'KEYCLOAK_REALM=${KEYCLOAK_REALM}'
      - 'KEYCLOAK_APIMAN_API_SECRET=${KEYCLOAK_APIMAN_API_SECRET}'
      - 'KEYCLOAK_APIMAN_UI_SECRET=${KEYCLOAK_APIMAN_UI_SECRET}'
      - 'KEYCLOAK_GATEWAY_SECRET=${KEYCLOAK_GATEWAY_SECRET}'
      - 'KEYCLOAK_REALM_CERTIFICATE=${KEYCLOAK_REALM_CERTIFICATE}'
      - 'KEYCLOAK_REALM_PRIVATE_KEY=${KEYCLOAK_REALM_PRIVATE_KEY}'
      # Keycloak default admin username and password
      - 'KEYCLOAK_ADMIN=${KEYCLOAK_ADMIN_USERNAME}'
      - 'KEYCLOAK_ADMIN_PASSWORD=${KEYCLOAK_ADMIN_PASSWORD}'
      # Keycloak networking config
      - 'KC_HOSTNAME=auth.${APIMAN_HOSTNAME}'
      - 'KC_HOSTNAME_STRICT=false'
      - 'KC_HTTP_ENABLED=true'
      - 'KC_HTTP_PORT=8080'
      - 'KC_HOSTNAME_PORT=8080'
      - 'KC_PROXY=edge'
      # KC Database config
      - 'KC_DB=mysql'
      - 'KC_DB_URL=jdbc:mysql://mysql:3306/keycloak?useSSL=false&serverTimezone=UTC'
      - 'KC_DB_USERNAME=${MYSQL_USERNAME}'
      - 'KC_DB_PASSWORD=${MYSQL_PASSWORD}'
      # General KC config
      - 'KC_HEALTH_ENABLED=true'
    volumes:
      - type: bind
        source: "$PWD/data/apiman-realm-for-keycloak.json"
        target: /opt/keycloak/data/import/apiman-realm-for-keycloak.json
      - type: bind
        source: "$PWD/data/apiman-keycloak-theme.jar"
        target: /opt/keycloak/providers/apiman-keycloak-theme.jar
    logging:
      driver: "json-file"
      options:
        max-size: "10m"
        max-file: "10"
        mode: non-blocking
    restart: unless-stopped
    labels:
      #- traefik.http.routers.keycloak-router.tls=true
      - traefik.http.routers.keycloak-router.entrypoints=http
      - traefik.http.routers.keycloak-router.rule=Host(`auth.${APIMAN_HOSTNAME}`)
      - traefik.http.routers.keycloak-router.service=keycloak-service
      - traefik.http.services.keycloak-service.loadbalancer.server.port=8080



  reverse-proxy:
    image: traefik:v2.10.3
    command:
      - --entrypoints.http.address=:8080
      - --entrypoints.https.address=:8443
      - --providers.docker
    ports:
      - "8080:8080"
      - "8443:8443"
    volumes:
      - /var/run/docker.sock:/var/run/docker.sock


volumes:
  ui_logs:
    driver: local
  elasticsearch_data:
    driver: local
  keycloak_logs:
    driver: local
  manager_logs:
    driver: local
  gateway_logs:
    driver: local

#networks:
#

My docker-compose logs:

apiman-manager-1      | 18:09:07,979 WARN  [io.apiman.manager.api.war.wildfly8.ApimanTransactionalInterceptor] (default task-4) Transaction has been set as rollback only because of io.apiman.manager.api.core.exceptions.StorageException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist [statement:"SELECT * FROM ORGANIZATIONS org WHERE org.ID IN (:__orgIds_0) ORDER BY org.id ASC", arguments:{positional:{}, named:{__orgIds_0:ELENA}, finder:[]}]. (This can occur accidentally if you are using exceptions for control-flow, which can caused the TX to be marked rollback only)
apiman-manager-1      | 18:09:07,979 WARN  [io.apiman.manager.api.war.wildfly8.ApimanTransactionalInterceptor] (default task-4) Transaction has been set as rollback only because of io.apiman.manager.api.rest.exceptions.SystemErrorException: io.apiman.manager.api.core.exceptions.StorageException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist [statement:"SELECT * FROM ORGANIZATIONS org WHERE org.ID IN (:__orgIds_0) ORDER BY org.id ASC", arguments:{positional:{}, named:{__orgIds_0:ELENA}, finder:[]}]. (This can occur accidentally if you are using exceptions for control-flow, which can caused the TX to be marked rollback only)
apiman-manager-1      | 18:09:07,980 ERROR [io.apiman.manager.api.rest.exceptions.mappers.RestExceptionMapper] (default task-4) io.apiman.manager.api.core.exceptions.StorageException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist [statement:"SELECT * FROM ORGANIZATIONS org WHERE org.ID IN (:__orgIds_0) ORDER BY org.id ASC", arguments:{positional:{}, named:{__orgIds_0:ELENA}, finder:[]}]: io.apiman.manager.api.rest.exceptions.SystemErrorException: io.apiman.manager.api.core.exceptions.StorageException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist [statement:"SELECT * FROM ORGANIZATIONS org WHERE org.ID IN (:__orgIds_0) ORDER BY org.id ASC", arguments:{positional:{}, named:{__orgIds_0:ELENA}, finder:[]}]
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.util.DataAccessUtilMixin.tryAction(DataAccessUtilMixin.java:20)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl$Proxy$_$$_WeldSubclass.tryAction$$super(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.util.reflection.Reflections.invokeAndUnwrap(Reflections.java:410)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.CombinedInterceptorAndDecoratorStackMethodHandler.invoke(CombinedInterceptorAndDecoratorStackMethodHandler.java:99)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.CombinedInterceptorAndDecoratorStackMethodHandler.invoke(CombinedInterceptorAndDecoratorStackMethodHandler.java:68)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl$Proxy$_$$_WeldSubclass.tryAction(Unknown Source)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl.getOrganizationsInternal(UserResourceImpl.java:361)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl.getApiOrganizations(UserResourceImpl.java:337)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl$Proxy$_$$_WeldSubclass.getApiOrganizations$$super(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.TerminalAroundInvokeInvocationContext.proceedInternal(TerminalAroundInvokeInvocationContext.java:51)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:78)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.war.wildfly8.ApimanTransactionalInterceptor.invokeInOurTx(ApimanTransactionalInterceptor.java:50)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.war.wildfly8.ApimanTransactionalInterceptor.intercept(ApimanTransactionalInterceptor.java:40)
apiman-manager-1      |         at jdk.internal.reflect.GeneratedMethodAccessor176.invoke(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.reader.SimpleInterceptorInvocation$SimpleMethodInvocation.invoke(SimpleInterceptorInvocation.java:73)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.InterceptorMethodHandler.executeAroundInvoke(InterceptorMethodHandler.java:84)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.InterceptorMethodHandler.executeInterception(InterceptorMethodHandler.java:72)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.InterceptorMethodHandler.invoke(InterceptorMethodHandler.java:56)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.CombinedInterceptorAndDecoratorStackMethodHandler.invoke(CombinedInterceptorAndDecoratorStackMethodHandler.java:79)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.CombinedInterceptorAndDecoratorStackMethodHandler.invoke(CombinedInterceptorAndDecoratorStackMethodHandler.java:68)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl$Proxy$_$$_WeldSubclass.getApiOrganizations(Unknown Source)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl$Proxy$_$$_WeldClientProxy.getApiOrganizations(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:138)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceMethodInvoker.internalInvokeOnTarget(ResourceMethodInvoker.java:546)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTargetAfterFilter(ResourceMethodInvoker.java:435)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceMethodInvoker.lambda$invokeOnTarget$0(ResourceMethodInvoker.java:396)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.interception.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:358)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invokeOnTarget(ResourceMethodInvoker.java:398)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:365)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.ResourceMethodInvoker.invoke(ResourceMethodInvoker.java:338)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:440)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.SynchronousDispatcher.lambda$invoke$4(SynchronousDispatcher.java:229)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.SynchronousDispatcher.lambda$preprocess$0(SynchronousDispatcher.java:135)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.interception.PreMatchContainerRequestContext.filter(PreMatchContainerRequestContext.java:358)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.SynchronousDispatcher.preprocess(SynchronousDispatcher.java:138)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:215)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:245)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:61)
apiman-manager-1      |         at org.jboss.resteasy.resteasy-jaxrs@3.15.1.Final//org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:56)
apiman-manager-1      |         at javax.servlet.api@2.0.0.Final//javax.servlet.http.HttpServlet.service(HttpServlet.java:590)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletHandler.handleRequest(ServletHandler.java:74)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:129)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.common.servlet.RootResourceFilter.doFilter(RootResourceFilter.java:59)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.security.impl.DefaultSecurityContextFilter.doFilter(DefaultSecurityContextFilter.java:55)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.war.TransactionWatchdogFilter.doFilter(TransactionWatchdogFilter.java:55)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.common.servlet.DisableCachingFilter.doFilter(DisableCachingFilter.java:52)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.common.servlet.ApimanCorsFilter.doFilter(ApimanCorsFilter.java:94)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.common.servlet.LocaleFilter.doFilter(LocaleFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ManagedFilter.doFilter(ManagedFilter.java:61)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler$FilterChainImpl.doFilter(FilterHandler.java:131)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.FilterHandler.handleRequest(FilterHandler.java:84)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.security.ServletSecurityRoleHandler.handleRequest(ServletSecurityRoleHandler.java:62)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletChain$1.handleRequest(ServletChain.java:68)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletDispatchingHandler.handleRequest(ServletDispatchingHandler.java:36)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.security.SecurityContextAssociationHandler.handleRequest(SecurityContextAssociationHandler.java:78)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
apiman-manager-1      |         at org.keycloak.keycloak-undertow-adapter@18.0.2//org.keycloak.adapters.undertow.UndertowAuthenticatedActionsHandler.handleRequest(UndertowAuthenticatedActionsHandler.java:66)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.RedirectDirHandler.handleRequest(RedirectDirHandler.java:68)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.security.SSLInformationAssociationHandler.handleRequest(SSLInformationAssociationHandler.java:117)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.security.ServletAuthenticationCallHandler.handleRequest(ServletAuthenticationCallHandler.java:57)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.handlers.DisableCacheHandler.handleRequest(DisableCacheHandler.java:33)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.security.handlers.AuthenticationConstraintHandler.handleRequest(AuthenticationConstraintHandler.java:53)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.security.handlers.AbstractConfidentialityHandler.handleRequest(AbstractConfidentialityHandler.java:46)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.security.ServletConfidentialityConstraintHandler.handleRequest(ServletConfidentialityConstraintHandler.java:64)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.security.ServletSecurityConstraintHandler.handleRequest(ServletSecurityConstraintHandler.java:59)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.security.handlers.AuthenticationMechanismsHandler.handleRequest(AuthenticationMechanismsHandler.java:60)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.security.CachedAuthenticatedSessionHandler.handleRequest(CachedAuthenticatedSessionHandler.java:77)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.security.handlers.NotificationReceiverHandler.handleRequest(NotificationReceiverHandler.java:50)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.security.handlers.AbstractSecurityContextAssociationHandler.handleRequest(AbstractSecurityContextAssociationHandler.java:43)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.security.jacc.JACCContextIdHandler.handleRequest(JACCContextIdHandler.java:61)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.deployment.GlobalRequestControllerHandler.handleRequest(GlobalRequestControllerHandler.java:68)
apiman-manager-1      |         at org.keycloak.keycloak-undertow-adapter@18.0.2//org.keycloak.adapters.undertow.ServletPreAuthActionsHandler.handleRequest(ServletPreAuthActionsHandler.java:69)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.SendErrorPageHandler.handleRequest(SendErrorPageHandler.java:52)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.handlers.PredicateHandler.handleRequest(PredicateHandler.java:43)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.handleFirstRequest(ServletInitialHandler.java:269)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$100(ServletInitialHandler.java:78)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:133)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$2.call(ServletInitialHandler.java:130)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:48)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.security.SecurityContextThreadSetupAction.lambda$create$0(SecurityContextThreadSetupAction.java:105)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
apiman-manager-1      |         at org.wildfly.extension.undertow@23.0.2.Final//org.wildfly.extension.undertow.deployment.UndertowDeploymentInfoService$UndertowThreadSetupAction.lambda$create$0(UndertowDeploymentInfoService.java:1530)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.dispatchRequest(ServletInitialHandler.java:249)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler.access$000(ServletInitialHandler.java:78)
apiman-manager-1      |         at io.undertow.servlet@2.2.5.Final//io.undertow.servlet.handlers.ServletInitialHandler$1.handleRequest(ServletInitialHandler.java:99)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.Connectors.executeRootHandler(Connectors.java:387)
apiman-manager-1      |         at io.undertow.core@2.2.5.Final//io.undertow.server.HttpServerExchange$1.run(HttpServerExchange.java:841)
apiman-manager-1      |         at org.jboss.threads@2.4.0.Final//org.jboss.threads.ContextClassLoaderSavingRunnable.run(ContextClassLoaderSavingRunnable.java:35)
apiman-manager-1      |         at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor.safeRun(EnhancedQueueExecutor.java:1990)
apiman-manager-1      |         at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.doRunTask(EnhancedQueueExecutor.java:1486)
apiman-manager-1      |         at org.jboss.threads@2.4.0.Final//org.jboss.threads.EnhancedQueueExecutor$ThreadBody.run(EnhancedQueueExecutor.java:1377)
apiman-manager-1      |         at org.jboss.xnio@3.8.4.Final//org.xnio.XnioWorker$WorkerThreadFactory$1$1.run(XnioWorker.java:1280)
apiman-manager-1      |         at java.base/java.lang.Thread.run(Thread.java:834)
apiman-manager-1      | Caused by: io.apiman.manager.api.core.exceptions.StorageException: org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist [statement:"SELECT * FROM ORGANIZATIONS org WHERE org.ID IN (:__orgIds_0) ORDER BY org.id ASC", arguments:{positional:{}, named:{__orgIds_0:ELENA}, finder:[]}]
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.jpa.JpaStorage.getOrgs(JpaStorage.java:1077)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.jpa.JpaStorage$Proxy$_$$_WeldSubclass.getOrgs$$super(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.TerminalAroundInvokeInvocationContext.proceedInternal(TerminalAroundInvokeInvocationContext.java:51)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.AroundInvokeInvocationContext.proceed(AroundInvokeInvocationContext.java:78)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.war.wildfly8.ApimanTransactionalInterceptor.invokeInCallerTx(ApimanTransactionalInterceptor.java:90)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.war.wildfly8.ApimanTransactionalInterceptor.intercept(ApimanTransactionalInterceptor.java:42)
apiman-manager-1      |         at jdk.internal.reflect.GeneratedMethodAccessor176.invoke(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.reader.SimpleInterceptorInvocation$SimpleMethodInvocation.invoke(SimpleInterceptorInvocation.java:73)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.InterceptorMethodHandler.executeAroundInvoke(InterceptorMethodHandler.java:84)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.InterceptorMethodHandler.executeInterception(InterceptorMethodHandler.java:72)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.interceptor.proxy.InterceptorMethodHandler.invoke(InterceptorMethodHandler.java:56)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.CombinedInterceptorAndDecoratorStackMethodHandler.invoke(CombinedInterceptorAndDecoratorStackMethodHandler.java:79)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.CombinedInterceptorAndDecoratorStackMethodHandler.invoke(CombinedInterceptorAndDecoratorStackMethodHandler.java:68)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.jpa.JpaStorage$Proxy$_$$_WeldSubclass.getOrgs(Unknown Source)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
apiman-manager-1      |         at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
apiman-manager-1      |         at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
apiman-manager-1      |         at java.base/java.lang.reflect.Method.invoke(Method.java:566)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.AbstractBeanInstance.invoke(AbstractBeanInstance.java:38)
apiman-manager-1      |         at org.jboss.weld.core@3.1.6.Final//org.jboss.weld.bean.proxy.ProxyMethodHandler.invoke(ProxyMethodHandler.java:106)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.core.IStorageQuery1436035428$Proxy$_$$_WeldClientProxy.getOrgs(Unknown Source)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.UserResourceImpl.lambda$getOrganizationsInternal$5(UserResourceImpl.java:361)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.rest.impl.util.DataAccessUtilMixin.tryAction(DataAccessUtilMixin.java:16)
apiman-manager-1      |         ... 123 more
apiman-manager-1      | Caused by: org.jdbi.v3.core.statement.UnableToExecuteStatementException: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist [statement:"SELECT * FROM ORGANIZATIONS org WHERE org.ID IN (:__orgIds_0) ORDER BY org.id ASC", arguments:{positional:{}, named:{__orgIds_0:ELENA}, finder:[]}]
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1789)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.result.ResultProducers.lambda$createResultBearing$3(ResultProducers.java:94)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.result.ResultIterable.lambda$of$0(ResultIterable.java:58)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.result.ResultIterable.stream(ResultIterable.java:269)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.result.ResultIterable.collect(ResultIterable.java:325)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.result.ResultIterable.list(ResultIterable.java:314)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.jpa.JpaStorage.lambda$getOrgs$10(JpaStorage.java:1073)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.Jdbi.withHandle(Jdbi.java:367)
apiman-manager-1      |         at deployment.apiman.war//io.apiman.manager.api.jpa.JpaStorage.getOrgs(JpaStorage.java:1069)
apiman-manager-1      |         ... 151 more
apiman-manager-1      | Caused by: java.sql.SQLSyntaxErrorException: Table 'apiman.ORGANIZATIONS' doesn't exist
apiman-manager-1      |         at com.mysql@8.0.33//com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:121)
apiman-manager-1      |         at com.mysql@8.0.33//com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
apiman-manager-1      |         at com.mysql@8.0.33//com.mysql.cj.jdbc.ClientPreparedStatement.executeInternal(ClientPreparedStatement.java:916)
apiman-manager-1      |         at com.mysql@8.0.33//com.mysql.cj.jdbc.ClientPreparedStatement.execute(ClientPreparedStatement.java:354)
apiman-manager-1      |         at org.jboss.ironjacamar.jdbcadapters@1.4.27.Final//org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.execute(WrappedPreparedStatement.java:442)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.statement.SqlLoggerUtil.wrap(SqlLoggerUtil.java:31)
apiman-manager-1      |         at deployment.apiman.war//org.jdbi.v3.core.statement.SqlStatement.internalExecute(SqlStatement.java:1787)
apiman-manager-1      |         ... 159 more

And the main error in APIMANUI:

[msavy]

For the community/upstream, I think it's best to stick to Postgres for now.

For Apiman 4, it should be resolved, but I can't promise anything.

If you are a paying support customer of BPL, feel free to reach out. For example, if you want to use Microsoft SQL server, we've successfully worked that out for a client already.