2015-05-20 12:01:49,415 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Starting database update 2015-05-20 12:01:52,770 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Reading from [dbo].[DATABASECHANGELOG] 2015-05-20 12:01:53,132 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Updating database from 1.1.0.Final to 1.2.0.Final 2015-05-20 12:01:53,195 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Successfully acquired change log lock 2015-05-20 12:01:53,427 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from CLIENT_SESSION_ROLE 2015-05-20 12:01:53,436 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from CLIENT_SESSION_NOTE 2015-05-20 12:01:53,441 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from CLIENT_SESSION 2015-05-20 12:01:53,445 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from USER_SESSION 2015-05-20 12:01:53,454 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table PROTOCOL_MAPPER created 2015-05-20 12:01:53,458 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table PROTOCOL_MAPPER_CONFIG created 2015-05-20 12:01:53,460 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table FEDERATED_IDENTITY created 2015-05-20 12:01:53,464 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table IDENTITY_PROVIDER created 2015-05-20 12:01:53,466 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table IDENTITY_PROVIDER_CONFIG created 2015-05-20 12:01:53,469 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table CLIENT_IDENTITY_PROV_MAPPING created 2015-05-20 12:01:53,471 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table REALM_SUPPORTED_LOCALES created 2015-05-20 12:01:53,473 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table USER_SESSION_NOTE created 2015-05-20 12:01:53,485 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Columns FRONTCHANNEL_LOGOUT(BOOLEAN) added to CLIENT 2015-05-20 12:01:53,490 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Columns USER_SESSION_STATE(INT),BROKER_SESSION_ID(VARCHAR(255)),BROKER_USER_ID(VARCHAR(255)) added to USER_SESSION 2015-05-20 12:01:53,495 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to PROTOCOL_MAPPER (ID) 2015-05-20 12:01:53,497 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to IDENTITY_PROVIDER (INTERNAL_ID) 2015-05-20 12:01:53,504 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to FEDERATED_IDENTITY (IDENTITY_PROVIDER, USER_ID) 2015-05-20 12:01:53,507 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to IDENTITY_PROVIDER_CONFIG (IDENTITY_PROVIDER_ID, NAME) 2015-05-20 12:01:53,509 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to PROTOCOL_MAPPER_CONFIG (PROTOCOL_MAPPER_ID, NAME) 2015-05-20 12:01:53,512 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to USER_SESSION_NOTE (USER_SESSION, NAME) 2015-05-20 12:01:53,517 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to IDENTITY_PROVIDER (REALM_ID) 2015-05-20 12:01:53,519 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to PROTOCOL_MAPPER (CLIENT_ID) 2015-05-20 12:01:53,521 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to FEDERATED_IDENTITY (USER_ID) 2015-05-20 12:01:53,522 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to IDENTITY_PROVIDER_CONFIG (IDENTITY_PROVIDER_ID) 2015-05-20 12:01:53,524 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to PROTOCOL_MAPPER_CONFIG (PROTOCOL_MAPPER_ID) 2015-05-20 12:01:53,526 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to CLIENT_IDENTITY_PROV_MAPPING (IDENTITY_PROVIDER_ID) 2015-05-20 12:01:53,528 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to CLIENT_IDENTITY_PROV_MAPPING (CLIENT_ID) 2015-05-20 12:01:53,530 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to REALM_SUPPORTED_LOCALES (REALM_ID) 2015-05-20 12:01:53,533 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to USER_SESSION_NOTE (USER_SESSION) 2015-05-20 12:01:53,535 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint added to IDENTITY_PROVIDER(PROVIDER_ALIAS, REALM_ID) 2015-05-20 12:01:53,537 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint added to CLIENT_IDENTITY_PROV_MAPPING(IDENTITY_PROVIDER_ID,CLIENT_ID) 2015-05-20 12:01:53,550 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Columns LOGIN_LIFESPAN(INT),INTERNATIONALIZATION_ENABLED(BOOLEAN),DEFAULT_LOCALE(VARCHAR(255)),REG_EMAIL_AS_USERNAME(BOOLEAN) added to REALM 2015-05-20 12:01:53,553 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_71S3P0DIUXAWWQQSA528UBY2Q dropped 2015-05-20 12:01:53,556 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_L5QGA3RFME47335JY8JXYXH3I dropped 2015-05-20 12:01:53,561 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint UK_L5QGA3RFME47335JY8JXYXH3I dropped from REALM_APPLICATION 2015-05-20 12:01:53,711 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column REALM_APPLICATION.APPLICATION_ID renamed to APPLICATION_ID_TMP 2015-05-20 12:01:53,714 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column REALM_APPLICATION.REALM_ID renamed to APPLICATION_ID 2015-05-20 12:01:53,717 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column REALM_APPLICATION.APPLICATION_ID_TMP renamed to REALM_ID 2015-05-20 12:01:53,738 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint added to REALM_APPLICATION(APPLICATION_ID) 2015-05-20 12:01:53,745 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to REALM_APPLICATION (APPLICATION_ID) 2015-05-20 12:01:53,749 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to REALM_APPLICATION (REALM_ID) 2015-05-20 12:01:54,199 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Update 1.2.0.Beta1: Updating 0 social links to federated identities. Updated LOGIN_LIFESPAN of all realms to 1800 seconds. Adding new admin roles. Migrating claimsMask to protocol mappers for clients: security-admin-console, realm-management, master-realm, account, hvac-realm, account, security-admin-console, DMIS, . 2015-05-20 12:01:54,202 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_68CJYS5UWM55UY823Y75XG4OM dropped 2015-05-20 12:01:54,202 WARN [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Database does not support drop with cascade 2015-05-20 12:01:54,210 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table USER_SOCIAL_LINK dropped 2015-05-20 12:01:54,212 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_SV5I3C2TI7G0G922FGE683SOV dropped 2015-05-20 12:01:54,212 WARN [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Database does not support drop with cascade 2015-05-20 12:01:54,214 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table REALM_SOCIAL_CONFIG dropped 2015-05-20 12:01:54,220 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column CLIENT.ALLOWED_CLAIMS_MASK dropped 2015-05-20 12:01:54,223 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table REALM_ENABLED_EVENT_TYPES created 2015-05-20 12:01:54,225 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to REALM_ENABLED_EVENT_TYPES (REALM_ID) 2015-05-20 12:01:54,232 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) ChangeSet META-INF/jpa-changelog-1.2.0.Beta1.xml::1.2.0.Beta1::psilva@redhat.com ran successfully in 828ms 2015-05-20 12:01:54,285 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from CLIENT_SESSION_ROLE 2015-05-20 12:01:54,287 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from CLIENT_SESSION_NOTE 2015-05-20 12:01:54,288 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from CLIENT_SESSION 2015-05-20 12:01:54,289 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from USER_SESSION_NOTE 2015-05-20 12:01:54,293 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data deleted from USER_SESSION 2015-05-20 12:01:54,295 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table MIGRATION_MODEL created 2015-05-20 12:01:54,298 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table IDENTITY_PROVIDER_MAPPER created 2015-05-20 12:01:54,300 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table IDP_MAPPER_CONFIG created 2015-05-20 12:01:54,303 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Columns CREATED_DATE(BIGINT) added to CREDENTIAL 2015-05-20 12:01:54,305 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table USER_CONSENT created 2015-05-20 12:01:54,307 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table USER_CONSENT_ROLE created 2015-05-20 12:01:54,309 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table USER_CONSENT_PROT_MAPPER created 2015-05-20 12:01:54,311 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table CLIENT_SESSION_PROT_MAPPER created 2015-05-20 12:01:54,313 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to MIGRATION_MODEL (ID) 2015-05-20 12:01:54,315 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to IDENTITY_PROVIDER_MAPPER (ID) 2015-05-20 12:01:54,318 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to IDP_MAPPER_CONFIG (IDP_MAPPER_ID, NAME) 2015-05-20 12:01:54,321 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to USER_CONSENT (ID) 2015-05-20 12:01:54,324 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to USER_CONSENT_ROLE (USER_CONSENT_ID, ROLE_ID) 2015-05-20 12:01:54,326 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to USER_CONSENT_PROT_MAPPER (USER_CONSENT_ID, PROTOCOL_MAPPER_ID) 2015-05-20 12:01:54,328 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Primary key added to CLIENT_SESSION_PROT_MAPPER (CLIENT_SESSION, PROTOCOL_MAPPER_ID) 2015-05-20 12:01:54,330 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to IDENTITY_PROVIDER_MAPPER (REALM_ID) 2015-05-20 12:01:54,333 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to IDP_MAPPER_CONFIG (IDP_MAPPER_ID) 2015-05-20 12:01:54,334 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to USER_CONSENT (USER_ID) 2015-05-20 12:01:54,337 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to USER_CONSENT_ROLE (USER_CONSENT_ID) 2015-05-20 12:01:54,339 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to USER_CONSENT_PROT_MAPPER (USER_CONSENT_ID) 2015-05-20 12:01:54,341 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to CLIENT_SESSION_PROT_MAPPER (CLIENT_SESSION) 2015-05-20 12:01:54,344 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column CLIENT.NAME renamed to CLIENT_ID 2015-05-20 12:01:54,351 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Columns CONSENT_REQUIRED(BOOLEAN),NAME(VARCHAR(255)) added to CLIENT 2015-05-20 12:01:54,353 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Columns ADD_TOKEN_ROLE(BOOLEAN) added to IDENTITY_PROVIDER 2015-05-20 12:01:54,357 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Data updated in CLIENT 2015-05-20 12:01:54,360 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column CLIENT.DTYPE dropped 2015-05-20 12:01:54,362 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_RSAF444KK6QRKMS7N56AIWQ5Y dropped 2015-05-20 12:01:54,365 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column REALM.MASTER_ADMIN_APP renamed to MASTER_ADMIN_CLIENT 2015-05-20 12:01:54,370 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to REALM (MASTER_ADMIN_CLIENT) 2015-05-20 12:01:54,373 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_82S3P0DIUXAWWQQSA528UBY2Q dropped 2015-05-20 12:01:54,376 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table REALM_APPLICATION renamed to REALM_CLIENT 2015-05-20 12:01:54,378 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column REALM_CLIENT.APPLICATION_ID renamed to CLIENT_ID 2015-05-20 12:01:54,384 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to REALM_CLIENT (CLIENT_ID) 2015-05-20 12:01:54,386 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_MAYLTS7KLWQW2H8M2B5JOYTKY dropped 2015-05-20 12:01:54,388 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table APPLICATION_DEFAULT_ROLES renamed to CLIENT_DEFAULT_ROLES 2015-05-20 12:01:54,391 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column CLIENT_DEFAULT_ROLES.APPLICATION_ID renamed to CLIENT_ID 2015-05-20 12:01:54,395 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to CLIENT_DEFAULT_ROLES (CLIENT_ID) 2015-05-20 12:01:54,398 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK8454723BA992F594 dropped 2015-05-20 12:01:54,402 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Table APP_NODE_REGISTRATIONS renamed to CLIENT_NODE_REGISTRATIONS 2015-05-20 12:01:54,406 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column CLIENT_NODE_REGISTRATIONS.APPLICATION_ID renamed to CLIENT_ID 2015-05-20 12:01:54,410 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to CLIENT_NODE_REGISTRATIONS (CLIENT_ID) 2015-05-20 12:01:54,412 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key FK_PIMO5LE2C0RAL09FL8CM9WFW9 dropped 2015-05-20 12:01:54,414 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column KEYCLOAK_ROLE.APPLICATION renamed to CLIENT 2015-05-20 12:01:54,417 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column KEYCLOAK_ROLE.APPLICATION_ROLE renamed to CLIENT_ROLE 2015-05-20 12:01:54,419 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Column KEYCLOAK_ROLE.APP_REALM_CONSTRAINT renamed to CLIENT_REALM_CONSTRAINT 2015-05-20 12:01:54,425 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Foreign key contraint added to KEYCLOAK_ROLE (CLIENT) 2015-05-20 12:01:54,429 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint UK_J3RWUVD56ONTGSUHOGM184WW2 dropped from KEYCLOAK_ROLE 2015-05-20 12:01:54,434 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint added to KEYCLOAK_ROLE(NAME,CLIENT_REALM_CONSTRAINT) 2015-05-20 12:01:54,437 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Unique constraint added to USER_CONSENT(CLIENT_ID, USER_ID) 2015-05-20 12:01:54,479 ERROR [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Change Set META-INF/jpa-changelog-1.2.0.CR1.xml::1.2.0.RC1::bburke@redhat.com failed. Error: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:185) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1208) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.Liquibase.update(Liquibase.java:181) at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84) [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.lazyInit(DefaultJpaConnectionProviderFactory.java:143) [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35) [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25) [keycloak-connections-jpa-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99) [keycloak-services-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:34) [keycloak-model-jpa-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.models.jpa.JpaRealmProviderFactory.create(JpaRealmProviderFactory.java:16) [keycloak-model-jpa-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99) [keycloak-services-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70) [keycloak-invalidation-cache-model-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163) [keycloak-invalidation-cache-model-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40) [keycloak-services-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31) [keycloak-services-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:155) [keycloak-services-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.services.resources.KeycloakApplication.(KeycloakApplication.java:86) [keycloak-services-1.2.0.Final.jar:1.2.0.Final] 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:148) [resteasy-jaxrs-3.0.8.Final.jar:] at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2175) [resteasy-jaxrs-3.0.8.Final.jar:] at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:295) [resteasy-jaxrs-3.0.8.Final.jar:] at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:236) [resteasy-jaxrs-3.0.8.Final.jar:] at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:112) [resteasy-jaxrs-3.0.8.Final.jar:] at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36) [resteasy-jaxrs-3.0.8.Final.jar:] at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:214) [undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:119) [undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:505) [undertow-servlet-1.0.15.Final.jar:1.0.15.Final] at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:88) at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72) at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) 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] Caused by: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version at org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_CR1.generateStatementsImpl(JpaUpdate1_2_0_CR1.java:42) [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final] at org.keycloak.connections.jpa.updater.liquibase.custom.CustomKeycloakTask.generateStatements(CustomKeycloakTask.java:79) [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final] at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178) ... 40 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'true'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) at org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_CR1.generateStatementsImpl(JpaUpdate1_2_0_CR1.java:22) [keycloak-connections-jpa-liquibase-1.2.0.Final.jar:1.2.0.Final] ... 42 more 2015-05-20 12:01:54,535 DEBUG [org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider] (MSC service thread 1-1) Successfully released change log lock 2015-05-20 12:01:54,544 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./auth: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: Failed to start service at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1904) [jboss-msc-1.2.2.Final.jar:1.2.2.Final] 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] Caused by: java.lang.RuntimeException: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher) at org.jboss.resteasy.core.ConstructorInjectorImpl.construct(ConstructorInjectorImpl.java:160) at org.jboss.resteasy.spi.ResteasyProviderFactory.createProviderInstance(ResteasyProviderFactory.java:2175) at org.jboss.resteasy.spi.ResteasyDeployment.createApplication(ResteasyDeployment.java:295) at org.jboss.resteasy.spi.ResteasyDeployment.start(ResteasyDeployment.java:236) at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.init(ServletContainerDispatcher.java:112) at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.init(HttpServletDispatcher.java:36) at io.undertow.servlet.core.ManagedServlet$DefaultInstanceStrategy.start(ManagedServlet.java:214) at io.undertow.servlet.core.ManagedServlet.createServlet(ManagedServlet.java:119) at io.undertow.servlet.core.DeploymentManagerImpl.start(DeploymentManagerImpl.java:505) at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:88) at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72) at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) [jboss-msc-1.2.2.Final.jar:1.2.2.Final] at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) [jboss-msc-1.2.2.Final.jar:1.2.2.Final] ... 3 more Caused by: 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:143) at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:35) at org.keycloak.connections.jpa.DefaultJpaConnectionProviderFactory.create(DefaultJpaConnectionProviderFactory.java:25) at org.keycloak.services.DefaultKeycloakSession.getProvider(DefaultKeycloakSession.java:99) 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:99) at org.keycloak.models.cache.DefaultCacheRealmProvider.getDelegate(DefaultCacheRealmProvider.java:70) at org.keycloak.models.cache.DefaultCacheRealmProvider.getRealm(DefaultCacheRealmProvider.java:163) at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:40) at org.keycloak.services.managers.ApplianceBootstrap.bootstrap(ApplianceBootstrap.java:31) at org.keycloak.services.resources.KeycloakApplication.setupDefaultRealm(KeycloakApplication.java:155) at org.keycloak.services.resources.KeycloakApplication.(KeycloakApplication.java:86) 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:148) ... 15 more Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.2.0.CR1.xml::1.2.0.RC1::bburke@redhat.com: Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version at liquibase.changelog.ChangeSet.execute(ChangeSet.java:586) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:43) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:73) at liquibase.Liquibase.update(Liquibase.java:200) at liquibase.Liquibase.update(Liquibase.java:181) at org.keycloak.connections.jpa.updater.liquibase.LiquibaseJpaUpdaterProvider.update(LiquibaseJpaUpdaterProvider.java:84) ... 33 more Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:185) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1208) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550) ... 38 more Caused by: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version at org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_CR1.generateStatementsImpl(JpaUpdate1_2_0_CR1.java:42) at org.keycloak.connections.jpa.updater.liquibase.custom.CustomKeycloakTask.generateStatements(CustomKeycloakTask.java:79) at liquibase.change.custom.CustomChangeWrapper.generateStatements(CustomChangeWrapper.java:178) ... 40 more Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'true'. at com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(SQLServerException.java:216) at com.microsoft.sqlserver.jdbc.SQLServerStatement.getNextResult(SQLServerStatement.java:1522) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.doExecutePreparedStatement(SQLServerPreparedStatement.java:404) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement$PrepStmtExecCmd.doExecute(SQLServerPreparedStatement.java:350) at com.microsoft.sqlserver.jdbc.TDSCommand.execute(IOBuffer.java:5696) at com.microsoft.sqlserver.jdbc.SQLServerConnection.executeCommand(SQLServerConnection.java:1716) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeCommand(SQLServerStatement.java:180) at com.microsoft.sqlserver.jdbc.SQLServerStatement.executeStatement(SQLServerStatement.java:155) at com.microsoft.sqlserver.jdbc.SQLServerPreparedStatement.executeQuery(SQLServerPreparedStatement.java:285) at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462) at org.keycloak.connections.jpa.updater.liquibase.custom.JpaUpdate1_2_0_CR1.generateStatementsImpl(JpaUpdate1_2_0_CR1.java:22) ... 42 more 2015-05-20 12:01:54,571 ERROR [org.jboss.as.controller.management-operation] (Controller Boot Thread) JBAS014613: Operation ("add") failed - address: ([("deployment" => "keycloak-1.war")]) - failure description: {"JBAS014671: Failed services" => {"jboss.undertow.deployment.default-server.default-host./auth" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: Failed to start service Caused by: java.lang.RuntimeException: Failed to construct public org.keycloak.services.resources.KeycloakApplication(javax.servlet.ServletContext,org.jboss.resteasy.core.Dispatcher) Caused by: java.lang.RuntimeException: Failed to update database Caused by: liquibase.exception.MigrationFailedException: Migration failed for change set META-INF/jpa-changelog-1.2.0.CR1.xml::1.2.0.RC1::bburke@redhat.com: Reason: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version Caused by: liquibase.exception.UnexpectedLiquibaseException: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version Caused by: liquibase.exception.CustomChangeException: Update 1.2.0.CR1: Exception when updating data from previous version Caused by: com.microsoft.sqlserver.jdbc.SQLServerException: Invalid column name 'true'."}} 2015-05-20 12:01:54,664 INFO [org.jboss.as.controller] (Controller Boot Thread) JBAS014774: Service status report JBAS014777: Services which failed to start: service jboss.undertow.deployment.default-server.default-host./auth: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./auth: Failed to start service 2015-05-20 12:01:54,672 ERROR [org.jboss.as] (Controller Boot Thread) JBAS015875: WildFly 8.1.0.Final "Kenny" started (with errors) in 24752ms - Started 429 of 611 services (2 services failed or missing dependencies, 247 services are lazy, passive or on-demand)