[keycloak-user] Upgrade error - 1.8.0 to 1.8.1

Marek Posolda mposolda at redhat.com
Tue Mar 1 09:17:38 EST 2016 

Thanks. Strange as I couldn't see it.

Few questions:

- Do you see it during startup of 1.9.0 against clean DB too? Or just 
during migration from 1.8.0 ?

- Could you try with datasource settings like this? [1]

- Could you try with JDBC driver 5.1.29 ?

[1]

             <datasource
jndi-name="java:jboss/datasources/KeycloakDS"
                            pool-name="KeycloakDS"
                            enabled="true"
                            use-java-context="true">
<connection-url>jdbc:mysql://localhost/keycloak</connection-url>
                <driver>mysql</driver>
                <security>
                   <user-name>keycloak</user-name>
                   <password>keycloak</password>
                </security>
             </datasource>
             <drivers>
                <driver name="h2" module="com.h2database.h2">
<xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                </driver>
                <driver name="mysql" module="com.mysql">
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
                </driver>
             </drivers>
          </datasources>


Marek

On 29/02/16 14:57, Darcy Welsh wrote:
> Hey Marek,
>
> I am using MySQL 5.6.23 with JDBC driver version 5.1.33.
>
> Darcy
>
>
>> On Feb 29, 2016, at 2:16 AM, Marek Posolda <mposolda at redhat.com 
>> <mailto:mposolda at redhat.com>> wrote:
>>
>> Which JDBC driver and DB version are you using? Just found this 
>> thread during googling: 
>> http://liquibase-user.narkive.com/njIDqyEC/incorrect-database-name-on-generatechangelog 
>> . Wonder if it can be related to your issue...
>>
>> I am testing MySQL with JDBC driver version 5.1.29 and never saw the 
>> issue like this.
>>
>> Marek
>>
>> On 28/02/16 06:00, Darcy Welsh wrote:
>>> Hi,
>>>
>>> I successfully upgraded from 1.7.0 to 1.8.0, however, seeing the 
>>> following error when attempting to upgrade from 1.8.0 to either 
>>> 1.8.1 or 1.9.0:
>>>
>>> 22:45:48,803 ERROR 
>>> [org.keycloak.services.resources.KeycloakApplication] (ServerService 
>>> Thread Pool -- 51) Failed to migrate datamodel: 
>>> java.lang.RuntimeException: Failed to update database
>>> at 
>>> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:87)
>>> at 
>>> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:153)
>>> at 
>>> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:42)
>>> at 
>>> org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:30)
>>> at 
>>> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:103)
>>> at 
>>> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34)
>>> at 
>>> org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16)
>>> at 
>>> org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:103)
>>> at 
>>> org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:61)
>>> at 
>>> org.keycloak.models.cache.infinispan.DefaultCacheRealmProvider.getMigrationModel(DefaultCacheRealmProvider.java:43)
>>> at 
>>> org.keycloak.migration.MigrationModelManager.migrate(MigrationModelManager.java:21)
>>> at 
>>> org.keycloak.services.resources.KeycloakApplication.migrateModel(KeycloakApplication.java:139)
>>> at 
>>> org.keycloak.services.resources.KeycloakApplication.<init>(KeycloakApplication.java:82)
>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>> at 
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>> at 
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
>>> at 
>>> org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:150)
>>> at 
>>> org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2209)
>>> at 
>>> org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:299)
>>> at 
>>> org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:240)
>>> at 
>>> org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:113)
>>> at 
>>> org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36)
>>> at 
>>> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:117)
>>> at 
>>> org.wildfly.extension.undertow.security.RunAsLifecycleInterceptor.init(RunAsLifecycleInterceptor.java:78)
>>> at 
>>> io.undertow.servlet.core.LifecyleInterceptorInvocation.proceed(LifecyleInterceptorInvocation.java:103)
>>> at 
>>> io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:231)
>>> at 
>>> io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:132)
>>> at 
>>> io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:526)
>>> at 
>>> org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:101)
>>> at 
>>> org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)
>>> at 
>>> java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)
>>> at java.util.concurrent.FutureTask.run(FutureTask.java:266)
>>> at 
>>> java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
>>> at 
>>> java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
>>> at java.lang.Thread.run(Thread.java:745)
>>> at org.jboss.threads.JBossThread.run(JBossThread.java:320)
>>> Caused by: liquibase.exception.DatabaseException: Incorrect database 
>>> name '' [Failed SQL: CREATE TABLE ``.DATABASECHANGELOG (ID 
>>> VARCHAR(255) NOT NULL, AUTHOR VARCHAR(255) NOT NULL, FILENAME 
>>> VARCHAR(255) NOT NULL, DATEEXECUTED datetime NOT NULL, ORDEREXECUTED 
>>> INT NOT NULL, EXECTYPE VARCHAR(10) NOT NULL, MD5SUM VARCHAR(35) 
>>> NULL, DESCRIPTION VARCHAR(255) NULL, COMMENTS VARCHAR(255) NULL, TAG 
>>> VARCHAR(255) NULL, LIQUIBASE VARCHAR(20) NULL, CONTEXTS VARCHAR(255) 
>>> NULL, LABELS VARCHAR(255) NULL)]
>>> at 
>>> liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:316)
>>> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:55)
>>> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:122)
>>> at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:112)
>>> at 
>>> liquibase.changelog.StandardChangeLogHistoryService.init(StandardChangeLogHistoryService.java:214)
>>> at liquibase.Liquibase.checkLiquibaseTables(Liquibase.java:1074)
>>> at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1136)
>>> at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1126)
>>> at liquibase.Liquibase.listUnrunChangeSets(Liquibase.java:1122)
>>> at 
>>> org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:63)
>>> ... 36 more
>>> Caused by: 
>>> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Incorrect 
>>> database name ''
>>> at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>>> at 
>>> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>>> at 
>>> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>>> at java.lang.reflect.Constructor.newInstance(Constructor.java:408)
>>> at com.mysql.jdbc.Util.handleNewInstance(Util.java:377)
>>> at com.mysql.jdbc.Util.getInstance(Util.java:360)
>>> at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:978)
>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3887)
>>> at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3823)
>>> at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2435)
>>> at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2582)
>>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2526)
>>> at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2484)
>>> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:848)
>>> at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:742)
>>> at 
>>> org.jboss.jca.adapters.jdbc.WrappedStatement.execute(WrappedStatement.java:198)
>>> at 
>>> liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
>>> ... 45 more
>>>
>>> Any ideas as to the potential cause/resolution?
>>>
>>> The MySQL datasource is configured as follows:
>>>
>>>   <datasource jta="true" 
>>> jndi-name="java:jboss/datasources/KeycloakDS" pool-name="KeycloakDS" 
>>> enabled="true" use-java-context="true">
>>> <connection-url>jdbc:mysql://localhost:3306/keycloak</connection-url>
>>>       <connection-property name="defaultFetchSize">
>>>           1000
>>>       </connection-property>
>>>       <driver>mysql</driver>
>>>       <pool>
>>> <max-pool-size>20</max-pool-size>
>>>       </pool>
>>>       <security>
>>> <user-name>keycloak</user-name>
>>> <password>keycloakrocks!</password>
>>>       </security>
>>>       <timeout>
>>> <set-tx-query-timeout>true</set-tx-query-timeout>
>>>       </timeout>
>>>       <statement>
>>> <prepared-statement-cache-size>100</prepared-statement-cache-size>
>>> <share-prepared-statements>true</share-prepared-statements>
>>>       </statement>
>>>   </datasource>
>>>                 <drivers>
>>>       <driver name="mysql" module="com.mysql.jdbc">
>>> <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
>>> <datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlDataSource</datasource-class>
>>>       </driver>
>>>       .
>>>       .
>>>       .
>>>   </drivers>
>>>
>>>
>>>
>>> Any help would be much appreciated.
>>>
>>> Thank-you in advance,
>>> Darcy Welsh
>>>
>>>
>>>
>>> _______________________________________________
>>> keycloak-user mailing list
>>> keycloak-user at lists.jboss.org
>>> https://lists.jboss.org/mailman/listinfo/keycloak-user
>>
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/keycloak-user/attachments/20160301/d6916e2e/attachment-0001.html

More information about the keycloak-user mailing list