Uploaded image for project: 'AeroGear'
  1. AeroGear
  2. AEROGEAR-6011

MySQL 5.5 Error with EAP 6.3.x

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • None
    • None
    • None
    • None
    • JBoss EAP 6.3.0.Beta1 (AS 7.4.0.Final-redhat-11)
      Keycloak BETA4 (master branch)

    Description

      Deploying the auth-server from the UPS to EAP 6.3.Beta, I am getting this:

      13:21:30,650 WARN  [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (ServerService Thread Pool -- 57) IJ000604: Throwable while attempting to get a new connection: null: javax.resource.ResourceException: Could not create connection
      	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:324)
      	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:281)
      	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.createConnectionEventListener(SemaphoreArrayListManagedConnectionPool.java:842)
      	at org.jboss.jca.core.connectionmanager.pool.mcp.SemaphoreArrayListManagedConnectionPool.getConnection(SemaphoreArrayListManagedConnectionPool.java:386)
      	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getSimpleConnection(AbstractPool.java:404)
      	at org.jboss.jca.core.connectionmanager.pool.AbstractPool.getConnection(AbstractPool.java:372)
      	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.getManagedConnection(AbstractConnectionManager.java:353)
      	at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:368)
      	at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:488)
      	at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:143)
      	at org.hibernate.service.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:141) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcServicesImpl.java:242) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:117) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:85) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:184) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:156) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1825) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1783) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) [hibernate-jpa-2.0-api-1.0.1.Final-redhat-2.jar:1.0.1.Final-redhat-2]
      	at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:96) [keycloak-connections-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25) [keycloak-connections-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:17) [keycloak-connections-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:88) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:28) [keycloak-model-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:15) [keycloak-model-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:88) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:68) [keycloak-invalidation-cache-model-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:172) [keycloak-invalidation-cache-model-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:42) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:33) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:135) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.setupDefaultRealm(UpsKeycloakApplication.java:40) [classes:]
      	at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:84) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.<init>(UpsKeycloakApplication.java:35) [classes:]
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_65]
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_65]
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_65]
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_65]
      	at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:132) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.spi.ResteasyDeployment.createFromInjectorFactory(ResteasyDeployment.java:290) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:267) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:228) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:67) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:154) [jboss-as-web-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]
      	at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:58) [jboss-as-web-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]
      	at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:91) [jboss-as-web-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_65]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_65]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_65]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65]
      	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
      Caused by: java.lang.StringIndexOutOfBoundsException: String index out of range: -1
      	at java.lang.String.substring(String.java:1911) [rt.jar:1.7.0_65]
      	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getDriver(LocalManagedConnectionFactory.java:598)
      	at org.jboss.jca.adapters.jdbc.local.LocalManagedConnectionFactory.getLocalManagedConnection(LocalManagedConnectionFactory.java:295)
      	... 60 more
       
      13:21:30,657 WARN  [org.hibernate.engine.jdbc.internal.JdbcServicesImpl] (ServerService Thread Pool -- 57) HHH000342: Could not obtain connection to query metadata : javax.resource.ResourceException: IJ000453: Unable to get managed connection for java:jboss/datasources/UnifiedPushDS
      13:21:30,666 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[default-host].[/auth]] (ServerService Thread Pool -- 57) JBWEB000289: Servlet Keycloak REST Interface threw load() exception: org.hibernate.HibernateException: Connection cannot be null when 'hibernate.dialect' not set
      	at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.determineDialect(DialectFactoryImpl.java:98) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.jdbc.dialect.internal.DialectFactoryImpl.buildDialect(DialectFactoryImpl.java:68) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.engine.jdbc.internal.JdbcServicesImpl.configure(JdbcServicesImpl.java:170) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.internal.StandardServiceRegistryImpl.configureService(StandardServiceRegistryImpl.java:85) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService(AbstractServiceRegistryImpl.java:184) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService(AbstractServiceRegistryImpl.java:156) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.cfg.Configuration.buildTypeRegistrations(Configuration.java:1825) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1783) [hibernate-core-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.EntityManagerFactoryImpl.<init>(EntityManagerFactoryImpl.java:96) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:914) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:899) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:59) [hibernate-entitymanager-4.2.12.Final-redhat-1.jar:4.2.12.Final-redhat-1]
      	at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:63) [hibernate-jpa-2.0-api-1.0.1.Final-redhat-2.jar:1.0.1.Final-redhat-2]
      	at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:96) [keycloak-connections-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25) [keycloak-connections-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:17) [keycloak-connections-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:88) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:28) [keycloak-model-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:15) [keycloak-model-jpa-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:88) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:68) [keycloak-invalidation-cache-model-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:172) [keycloak-invalidation-cache-model-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:42) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:33) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:135) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.setupDefaultRealm(UpsKeycloakApplication.java:40) [classes:]
      	at org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:84) [keycloak-services-1.0-beta-4-SNAPSHOT.jar:]
      	at org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.<init>(UpsKeycloakApplication.java:35) [classes:]
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) [rt.jar:1.7.0_65]
      	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57) [rt.jar:1.7.0_65]
      	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) [rt.jar:1.7.0_65]
      	at java.lang.reflect.Constructor.newInstance(Constructor.java:526) [rt.jar:1.7.0_65]
      	at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:132) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.spi.ResteasyDeployment.createFromInjectorFactory(ResteasyDeployment.java:290) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:267) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:228) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:67) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36) [resteasy-jaxrs-2.3.8.Final-redhat-3.jar:]
      	at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3591) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.apache.catalina.core.StandardContext.start(StandardContext.java:3798) [jbossweb-7.4.2.Final-redhat-1.jar:7.4.2.Final-redhat-1]
      	at org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:154) [jboss-as-web-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]
      	at org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:58) [jboss-as-web-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]
      	at org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:91) [jboss-as-web-7.4.0.Final-redhat-11.jar:7.4.0.Final-redhat-11]
      	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471) [rt.jar:1.7.0_65]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:262) [rt.jar:1.7.0_65]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [rt.jar:1.7.0_65]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [rt.jar:1.7.0_65]
      	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.7.0_65]
      	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
      

      Attachments

        Activity

          People

            mposolda@redhat.com Marek Posolda
            mwessend@redhat.com Matthias Wessendorf
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: