[Aerogear-users] Table 'client_attributes' already exists ERROR

falconea antonio.falcone at cg.tasgroup.it
Wed Nov 16 05:33:53 EST 2016


I'm installing AeroGear UnifiedPush on JBoss 6.4. 
I get this error Table 'client_attributes' already exists. How can i fix
that?


11:02:21,198 ERROR
[org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider]
(ServerService Thread Pool -- 66) Change Set
META-INF/jpa-changelog-1.1.0.Beta1.xml::1.1.0.Beta1::sthorger at redhat.com
failed.  Error: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
Table 'client_attributes' already exists:
liquibase.exception.DatabaseException:
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'client_attributes' already exists
	at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
[liquibase-core-3.3.5.jar:]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
[liquibase-core-3.3.5.jar:]
	at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
[liquibase-core-3.3.5.jar:]
	at
liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
[liquibase-core-3.3.5.jar:]
	at
liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
[liquibase-core-3.3.5.jar:]
	at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
[liquibase-core-3.3.5.jar:]
	at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43)
[liquibase-core-3.3.5.jar:]
	at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73)
[liquibase-core-3.3.5.jar:]
	at liquibase.Liquibase.update(Liquibase.java:200)
[liquibase-core-3.3.5.jar:]
	at liquibase.Liquibase.update(Liquibase.java:181)
[liquibase-core-3.3.5.jar:]
	at
org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84)
[keycloak-connections-jpa-liquibase-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:143)
[keycloak-connections-jpa-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35)
[keycloak-connections-jpa-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25)
[keycloak-connections-jpa-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
[keycloak-services-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)
[keycloak-model-jpa-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)
[keycloak-model-jpa-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99)
[keycloak-services-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70)
[keycloak-invalidation-cache-model-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163)
[keycloak-invalidation-cache-model-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40)
[keycloak-services-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31)
[keycloak-services-1.3.1.Final.jar:1.3.1.Final]
	at
org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:157)
[keycloak-services-1.3.1.Final.jar:1.3.1.Final]
	at
org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.setupDefaultRealm(UpsKeycloakApplication.java:40)
[classes:]
	at
org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:87)
[keycloak-services-1.3.1.Final.jar:1.3.1.Final]
	at
org.jboss.aerogear.unifiedpush.keycloak.UpsKeycloakApplication.<init>(UpsKeycloakApplication.java:35)
[classes:]
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[rt.jar:1.8.0_111]
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[rt.jar:1.8.0_111]
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[rt.jar:1.8.0_111]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[rt.jar:1.8.0_111]
	at
org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:133)
[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
	at
org.jboss.resteasy.spi.ResteasyDeployment.createFromInjectorFactory(ResteasyDeployment.java:293)
[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
	at
org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:270)
[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
	at
org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:228)
[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
	at
org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:67)
[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
	at
org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
[resteasy-jaxrs-2.3.10.Final-redhat-1.jar:]
	at
org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1194)
[jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:1100)
[jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at
org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3593)
[jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at
org.apache.catalina.core.StandardContext.start(StandardContext.java:3802)
[jbossweb-7.5.7.Final-redhat-1.jar:7.5.7.Final-redhat-1]
	at
org.jboss.as.web.deployment.WebDeploymentService.doStart(WebDeploymentService.java:163)
[jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at
org.jboss.as.web.deployment.WebDeploymentService.access$000(WebDeploymentService.java:61)
[jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at
org.jboss.as.web.deployment.WebDeploymentService$1.run(WebDeploymentService.java:96)
[jboss-as-web-7.5.0.Final-redhat-21.jar:7.5.0.Final-redhat-21]
	at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
[rt.jar:1.8.0_111]
	at java.util.concurrent.FutureTask.run(FutureTask.java:266)
[rt.jar:1.8.0_111]
	at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
[rt.jar:1.8.0_111]
	at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
[rt.jar:1.8.0_111]
	at java.lang.Thread.run(Thread.java:745) [rt.jar:1.8.0_111]
	at org.jboss.threads.JBossThread.run(JBossThread.java:122)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table
'client_attributes' already exists
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
[rt.jar:1.8.0_111]
	at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
[rt.jar:1.8.0_111]
	at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
[rt.jar:1.8.0_111]
	at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
[rt.jar:1.8.0_111]
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:842)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:681)
	at
org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:157)
	at
liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
[liquibase-core-3.3.5.jar:]
	... 48 more



--
View this message in context: http://aerogear-users.1116366.n5.nabble.com/Table-client-attributes-already-exists-ERROR-tp950.html
Sent from the aerogear-users mailing list archive at Nabble.com.


More information about the Aerogear-users mailing list