Skip to content

Instantly share code, notes, and snippets.

@danbev
Created July 15, 2015 13:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save danbev/85143b7fdb3de1eea5ea to your computer and use it in GitHub Desktop.
Save danbev/85143b7fdb3de1eea5ea to your computer and use it in GitHub Desktop.
migrator gist
$ ./bin/ups-migrator --logLevel=DEBUG update
DEBUG 7/15/15 3:15 PM: liquibase: Connected to unifiedpush@jdbc:postgresql://localhost:5432/unifiedpush
DEBUG 7/15/15 3:15 PM: liquibase: Setting auto commit to false from true
DEBUG 7/15/15 3:15 PM: liquibase: Computed checksum for 1436966129931 as 2cb45cf4f1f5fc50f43682d6b5d6e3aa
DEBUG 7/15/15 3:15 PM: liquibase: Executing QUERY database command: select count(*) from public.ups_db_changeloglock
DEBUG 7/15/15 3:15 PM: liquibase: Executing QUERY database command: SELECT LOCKED FROM public.ups_db_changeloglock WHERE ID=1
DEBUG 7/15/15 3:15 PM: liquibase: Lock Database
DEBUG 7/15/15 3:15 PM: liquibase: Executing UPDATE database command: UPDATE public.ups_db_changeloglock SET LOCKED = TRUE, LOCKEDBY = 'Daniels-MacBook-Pro.local (fe80:0:0:0:9ca3:94ff:fe2f:7410%awdl0)', LOCKGRANTED = '2015-07-15 15:15:29.993' WHERE ID = 1 AND LOCKED = FALSE
INFO 7/15/15 3:15 PM: liquibase: Successfully acquired change log lock
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Resolving XML entity name='null', publicId='null', baseURI='null', systemId='http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd'
DEBUG 7/15/15 3:15 PM: liquibase: Found namespace details class liquibase.parser.core.xml.StandardNamespaceDetails for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Local path for http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.1.xsd is liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Successfully loaded XSD from liquibase/parser/core/xml/dbchangelog-3.1.xsd
DEBUG 7/15/15 3:15 PM: liquibase: Executing QUERY database command: SELECT MD5SUM FROM public.ups_db_changelog WHERE MD5SUM IS NOT NULL
INFO 7/15/15 3:15 PM: liquibase: Reading from public.ups_db_changelog
DEBUG 7/15/15 3:15 PM: liquibase: Executing QUERY database command: SELECT FILENAME,AUTHOR,ID,MD5SUM,DATEEXECUTED,ORDEREXECUTED,EXECTYPE,DESCRIPTION,COMMENTS,TAG,LIQUIBASE FROM public.ups_db_changelog ORDER BY DATEEXECUTED ASC, ORDEREXECUTED ASC
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::001::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="googlekey"
type="VARCHAR(255)"
],
[
name="projectnumber"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
]
]
tableName="androidvariant"
] as 74f752339df39ad3dbfd9f2c36256002
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::001::generated: Computed checksum for 7:74f752339df39ad3dbfd9f2c36256002: as 5b061837544f5bd9194fc5c4e76ea578
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::002::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="clientid"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="clientsecret"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="refreshtoken"
type="VARCHAR(255)"
],
[
[
... [truncated in log] as 5ba70fd0cebaf707a9bf1d49cf831f42
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::002::generated: Computed checksum for 7:5ba70fd0cebaf707a9bf1d49cf831f42: as f78fa5ab0e562f0297a19e047b60bb05
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::003::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
name="alias"
type="VARCHAR(255)"
],
[
name="devicetoken"
type="VARCHAR(4096)"
],
[
name="devicetype"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="e... [truncated in log] as 7976655cd8b949809a33c162743a62b6
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::003::generated: Computed checksum for 7:7976655cd8b949809a33c162743a62b6: as 9237feff8f5702b0e8813bba9a2da6c4
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::004::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="installation_id"
type="VARCHAR(255)"
],
[
name="categories"
type="VARCHAR(255)"
]
]
tableName="installation_categories"
] as cd6923fcf7b57497fef4da35d06fc528
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::004::generated: Computed checksum for 7:cd6923fcf7b57497fef4da35d06fc528: as 3ba70e4cb4116c119cba94e653c0ddc7
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::005::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
name="description"
type="VARCHAR(255)"
],
[
name="developer"
type="VARCHAR(255)"
],
[
name="mastersecret"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
na... [truncated in log] as 0abeeb1fd6911ddace987a8b16d22099
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::005::generated: Computed checksum for 7:0abeeb1fd6911ddace987a8b16d22099: as 9b0a636fdec2e1378bfcaeab2c4f9337
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::006::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
name="clientidentifier"
type="VARCHAR(255)"
],
[
name="ipaddress"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="pushapplicationid"
type="VARCHAR(255)"
],
[
... [truncated in log] as 4b2bc8516ae7a1f7eb412431ebb6ee63
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::006::generated: Computed checksum for 7:4b2bc8516ae7a1f7eb412431ebb6ee63: as 097737c3f7b0f67e4ec7aef9a907f79e
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::007::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
]
]
tableName="simplepushvariant"
] as c952df464334fa0d308c651bebdf343c
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::007::generated: Computed checksum for 7:c952df464334fa0d308c651bebdf343c: as f780caa0cc2fb6ea871709483e3b8800
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::008::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="VARIANT_TYPE"
type="VARCHAR(31)"
],
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
name="description"
type="VARCHAR(255)"
],
[
name="developer"
type="VARCHAR(255)"
],
[
nam... [truncated in log] as 14ba91c7ed9d59ce41d035d66603024a
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::008::generated: Computed checksum for 7:14ba91c7ed9d59ce41d035d66603024a: as 594d0759e532c1296f412b27e7dd085d
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::009::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
name="deliverystatus"
type="BOOLEAN"
],
[
name="reason"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="receivers"
type="BIGINT"
],
[
[
... [truncated in log] as 235a8650731d9da7352a39873684f73e
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::009::generated: Computed checksum for 7:235a8650731d9da7352a39873684f73e: as 37814024374f7d6fbc1dc410add5e016
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::010::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="certificate"
type="OID"
],
[
[
nullable="false"
]
name="passphrase"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="production"
type="BOOLEAN"
],
[
[
nullable="fal... [truncated in log] as 1ff95da3c9bb92dec5c4191062b599b4
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::010::generated: Computed checksum for 7:1ff95da3c9bb92dec5c4191062b599b4: as 2d9cf917690f7394bbce4c5cccc00276
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::011::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="androidvariant_pkey"
tableName="androidvariant"
] as 140cab5cc77dbdc61a53592a9b2a8acb
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::011::generated: Computed checksum for 7:140cab5cc77dbdc61a53592a9b2a8acb: as 8da54c3df0644261d1f5b19686066746
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::012::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="chromepackagedappvariant_pkey"
tableName="chromepackagedappvariant"
] as aff58868ff5e6908ea65af61541bd3b8
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::012::generated: Computed checksum for 7:aff58868ff5e6908ea65af61541bd3b8: as f21afbd5273118c415ba88f67a3410cc
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::013::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="installation_pkey"
tableName="installation"
] as dc416d303aae26890f96bf9ec13fbd4f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::013::generated: Computed checksum for 7:dc416d303aae26890f96bf9ec13fbd4f: as 7d3b3f89d22f08d9b064d4b378ccd17d
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::014::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="pushapplication_pkey"
tableName="pushapplication"
] as a5abd935c04b219fbd09c2cf475a2ae7
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::014::generated: Computed checksum for 7:a5abd935c04b219fbd09c2cf475a2ae7: as b29ae2d89b720707d3e5cdd68a44c80a
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::015::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="pushmessageinformation_pkey"
tableName="pushmessageinformation"
] as 164b6fc2d6a68e405af172877689aca8
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::015::generated: Computed checksum for 7:164b6fc2d6a68e405af172877689aca8: as 58a8be1b0929f6285fa8730d37f34ecb
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::016::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="simplepushvariant_pkey"
tableName="simplepushvariant"
] as 7c0d6d6a61d0657b0de00b2e6d61f3c6
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::016::generated: Computed checksum for 7:7c0d6d6a61d0657b0de00b2e6d61f3c6: as f04bdfebb1400a65e5fb564c9fda1090
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::017::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="variant_pkey"
tableName="variant"
] as ec4d5b83af17c24a357e27f2f738d1f9
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::017::generated: Computed checksum for 7:ec4d5b83af17c24a357e27f2f738d1f9: as e593ac5f075b5ba3ba18dd1bfddfd8de
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::018::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="variantmetricinformation_pkey"
tableName="variantmetricinformation"
] as 61a96d28b1370429809f40d95c73be18
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::018::generated: Computed checksum for 7:61a96d28b1370429809f40d95c73be18: as eceea0f1736474a4418b3f201d9ba03c
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::019::generated: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="iosvariant_pkey"
tableName="iosvariant"
] as be85c73f48da849361584534a0095bfc
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::019::generated: Computed checksum for 7:be85c73f48da849361584534a0095bfc: as 74a4dc6e1a4da1e7489faa7c919992c6
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::020::generated: Computed checksum for addUniqueConstraint:[
columnNames="variantid"
constraintName="uk_jlpkx1qkcjaps25wqhp4nkfel"
deferrable="false"
disabled="false"
initiallyDeferred="false"
tableName="variant"
] as 672506de8142b618a7590e8c26e04c51
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::020::generated: Computed checksum for 7:672506de8142b618a7590e8c26e04c51: as 6a26f4740b2b25ebd4fcdffafeb2f515
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::021::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="installation_id"
baseTableName="installation_categories"
constraintName="fk_7jk4ols9cel7xo5bi10yk1gvl"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="installation"
] as 6af90151fa4ed307592a34911b54e983
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::021::generated: Computed checksum for 7:6af90151fa4ed307592a34911b54e983: as 8cf2670c804e3b110c12be9a1c99868b
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::022::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="variants_id"
baseTableName="variant"
constraintName="fk_7vjqh1lbqvlh4ni98qnh8hxkr"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="pushapplication"
] as 10617fda7a2393e1385b2edc940c78a9
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::022::generated: Computed checksum for 7:10617fda7a2393e1385b2edc940c78a9: as 53bf85770ba432af6952f3954fc8bca2
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::023::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="id"
baseTableName="iosvariant"
constraintName="fk_a7ndfcxa9m4wt4m2x2mxajr56"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="variant"
] as 0d8afc0d9cc542698774f537052e31bb
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::023::generated: Computed checksum for 7:0d8afc0d9cc542698774f537052e31bb: as 2af061d028434c87e720247aab7223f1
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::024::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="id"
baseTableName="androidvariant"
constraintName="fk_abna7p5c0p8ju2pf4ucqv5cby"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="variant"
] as b2dd32034d6e28e011a8d6a3b1b3ab2d
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::024::generated: Computed checksum for 7:b2dd32034d6e28e011a8d6a3b1b3ab2d: as e49245011909ef7d549d482786f1153f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::025::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="variantinformations_id"
baseTableName="variantmetricinformation"
constraintName="fk_ci9sa3eevtel9l172w9b0musj"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="pushmessageinformation"
] as 364ec3c6a2cf18bc224d160e266804fb
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::025::generated: Computed checksum for 7:364ec3c6a2cf18bc224d160e266804fb: as 5793c635c55b546abbf0023083ddcfa2
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::026::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="id"
baseTableName="chromepackagedappvariant"
constraintName="fk_craam2a14eghbd6ohlnbbe7bq"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="variant"
] as 0ff94257ab8867c8b7dceef056d4c04f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::026::generated: Computed checksum for 7:0ff94257ab8867c8b7dceef056d4c04f: as aed2d8febfb16c2ec4d4d469303744f8
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::027::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="id"
baseTableName="simplepushvariant"
constraintName="fk_hombuwogx5wv7hnup407gnwpg"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="variant"
] as 07a5df255a3a3ef54656bd6283a1d6b2
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::027::generated: Computed checksum for 7:07a5df255a3a3ef54656bd6283a1d6b2: as af6c115209ce029e022e15cc08afd957
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::028::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="variantid"
baseTableName="installation"
constraintName="fk_se07q3nt9pb7v949p4ia77uvc"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="variantid"
referencedTableName="variant"
] as 5d2901f9dd9bf3dcd2a9f7b58e3942ed
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.0.Final/initial-pgsql.xml::028::generated: Computed checksum for 7:5d2901f9dd9bf3dcd2a9f7b58e3942ed: as 75fa70e83c1df08281177760d376f6b2
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.2/2014-12-17-keycloak-fixes.xml::001::generated: Computed checksum for renameTable:[
newTableName="REALM_EVENTS_LISTENERS"
oldTableName="REALM_AUDIT_LISTENERS"
] as 3e10854a9c86d4cb10f4c03805f66261
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.2/2014-12-17-keycloak-fixes.xml::001::generated: Computed checksum for 7:3e10854a9c86d4cb10f4c03805f66261: as 9745afa3151bdd7c13212990642e4966
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.2/2014-12-17-keycloak-fixes.xml::002::generated: Computed checksum for renameColumn:[
columnDataType="BIT(1)"
newColumnName="EVENTS_ENABLED"
oldColumnName="AUDIT_ENABLED"
tableName="REALM"
] as 5d328fda3a0a460a901b25086cd12e23
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.2/2014-12-17-keycloak-fixes.xml::002::generated: Computed checksum for 7:5d328fda3a0a460a901b25086cd12e23: as 1af142bc49b25c88dfd58b469fe1bf18
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.2/2014-12-17-keycloak-fixes.xml::003::generated: Computed checksum for renameColumn:[
columnDataType="BIGINT(20)"
newColumnName="EVENTS_EXPIRATION"
oldColumnName="AUDIT_EXPIRATION"
tableName="REALM"
] as f3e53af6706c8c3ab44f4a8ef00496bc
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.2/2014-12-17-keycloak-fixes.xml::003::generated: Computed checksum for 7:f3e53af6706c8c3ab44f4a8ef00496bc: as 25fcfa730e75d1391cbcae6e594503fe
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-02-27-normalize_installations_table.xml::002p::qmx: Computed checksum for dropForeignKeyConstraint:[
baseTableName="installation"
constraintName="fk_se07q3nt9pb7v949p4ia77uvc"
] as 5ab5e299a8bdb2cebb1b4064506ac3ac
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-02-27-normalize_installations_table.xml::002p::qmx: Computed checksum for 7:5ab5e299a8bdb2cebb1b4064506ac3ac: as fcc85ade54617a80b8fbdede7398f6ae
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-02-27-normalize_installations_table.xml::003p::qmx: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="variantid"
baseTableName="installation"
constraintName="fk_na86cvm4h3gytxsyqdugc2o74"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="variantid"
referencedTableName="variant"
] as 11562ff1fd16b9336c34b8e64783055e
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-02-27-normalize_installations_table.xml::003p::qmx: Computed checksum for 7:11562ff1fd16b9336c34b8e64783055e: as fef196bab1af40c24421f4b6cb20a91b
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::001::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
primaryKey="true"
primaryKeyName="category_pkey"
]
name="id"
type="BIGINT"
],
[
name="name"
type="VARCHAR(255)"
]
]
tableName="category"
] as 99576ded8c061edeee0b534c4573155c
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::001::generated: Computed checksum for 7:99576ded8c061edeee0b534c4573155c: as bc007ca8397c01c3b2c27d782b6657be
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::002p::generated: Computed checksum for inputStream as b99f3390e7250ac1d9d31bb21809d5bf
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::002p::generated: Computed checksum for 7:b99f3390e7250ac1d9d31bb21809d5bf: as 2a00e8386f133e161d1122a0cd62a1ab
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::003p::generated: Computed checksum for createSequence:[
sequenceName="category_seq"
] as 5f8cb6a5816ac22ce47d0a5242ec2642
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::003p::generated: Computed checksum for 7:5f8cb6a5816ac22ce47d0a5242ec2642: as 2c71c4b11cddad3a47650e72a187716d
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::004::generated: Computed checksum for customChange:[
class="org.jboss.aerogear.unifiedpush.migrator.CategoriesMigration"
param=[]
] as 0b5016276de768b858950c58669a7917
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::004::generated: Computed checksum for 7:0b5016276de768b858950c58669a7917: as fba59a75e13e2d554c854e461468ccb3
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::004a::generated: Computed checksum for renameColumn:[
columnDataType="BIGINT"
newColumnName="category_id"
oldColumnName="categories_id"
tableName="installation_category"
] as fa5b054d0bff3596a5f9a7ab2afb9776
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::004a::generated: Computed checksum for 7:fa5b054d0bff3596a5f9a7ab2afb9776: as 198dcb6d67e4e95ad4858a61dabd31dd
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::005::generated: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="installation_id"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="category_id"
type="BIGINT"
]
]
tableName="installation_category"
] as 3bfb20096a7264a1d275a9787c5c75a3
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::005::generated: Computed checksum for addPrimaryKey:[
columnNames="installation_id, category_id"
constraintName="installation_category_pkey"
tableName="installation_category"
] as e186fee9adb3c5c76e46371d66b49834
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::005::generated: Computed checksum for 7:3bfb20096a7264a1d275a9787c5c75a3:7:e186fee9adb3c5c76e46371d66b49834: as 094e6b5e7676e4384d5bb8ac275d08b3
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::006p::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="installation_id"
baseTableName="installation_category"
constraintName="fk_dttushnsf13kdwywyba8njqv7"
referencedColumnNames="id"
referencedTableName="installation"
] as 1f428111b00cf5f17eedb6d09bc2358f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::006p::generated: Computed checksum for 7:1f428111b00cf5f17eedb6d09bc2358f: as 63063353fcd6332f09973f40ac394a62
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::007p::generated: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="category_id"
baseTableName="installation_category"
constraintName="fk_ox56uwmry1x6kfoi3dkw1to8o"
referencedColumnNames="id"
referencedTableName="category"
] as 55d8e0e2c5f45b8e455bc1ace3c599cd
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::007p::generated: Computed checksum for 7:55d8e0e2c5f45b8e455bc1ace3c599cd: as bcb60741ef574d75dec1f7ab2f4ac14f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::008::generated: Computed checksum for inputStream as 2f0a1d792e24f0ffcce7254117493147
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::008::generated: Computed checksum for 7:2f0a1d792e24f0ffcce7254117493147: as 6984bf6f963a2f6a97ca881172343343
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::009p::generated: Computed checksum for dropTable:[
tableName="installation_categories"
] as 918c74ef31ea161de8c2a2229f085917
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2014-10-16-add-category-entity.xml::009p::generated: Computed checksum for 7:918c74ef31ea161de8c2a2229f085917: as 2cdcaf9196e6eb930ebd2d0714b87b09
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::001p::qmx: Computed checksum for renameTable:[
newTableName="ios_variant"
oldTableName="iosvariant"
] as 6024fcdecda96d21773c0308eedd474b
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::001p::qmx: Computed checksum for 7:6024fcdecda96d21773c0308eedd474b: as 2f581ea408cd9bb8caa776152d4352ba
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::002::qmx: Computed checksum for addColumn:[
columns=[
[
name="cert_data"
type="TEXT"
]
]
tableName="ios_variant"
] as 9b48e1a15560def4aa63d9e4c0419b87
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::002::qmx: Computed checksum for 7:9b48e1a15560def4aa63d9e4c0419b87: as e569b0516623d0e6aa82febced80b27a
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::003::qmx: Computed checksum for customChange:[
class="org.jboss.aerogear.unifiedpush.migrator.CertificateBlobToBase64"
param=[]
] as f2ec4505730450b81cd87db01c29869b
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::003::qmx: Computed checksum for addNotNullConstraint:[
columnDataType="TEXT"
columnName="cert_data"
tableName="ios_variant"
] as 9a4e5f2806bef8fc1c59d10b3392d2c7
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::003::qmx: Computed checksum for 7:f2ec4505730450b81cd87db01c29869b:7:9a4e5f2806bef8fc1c59d10b3392d2c7: as 87871c38ed94247c25c7efe6992880c0
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::004::qmx: Computed checksum for dropColumn:[
columnName="certificate"
tableName="ios_variant"
] as fb951b4a0103b90061fe237d7e513489
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::004::qmx: Computed checksum for 7:fb951b4a0103b90061fe237d7e513489: as 176902f1158ec92cdeae10c7285b1e32
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::005::qmx: Computed checksum for addDefaultValue:[
columnName="production"
defaultValueBoolean="false"
tableName="ios_variant"
] as 1e6cd1f22b7cd04b4fec2130ad7ebd9f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.0.3/2015-01-22-change-blob-into-a-base64-string.xml::005::qmx: Computed checksum for 7:1e6cd1f22b7cd04b4fec2130ad7ebd9f: as f7f00d846a86684ac83ad7e690587929
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::2::qmx: Computed checksum for renameTable:[
newTableName="android_variant"
oldTableName="androidvariant"
] as 402ae9677f9bbaa3394ca6118ed192b5
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::2::qmx: Computed checksum for 7:402ae9677f9bbaa3394ca6118ed192b5: as cd3b0cc8451f9cbf23b6d03644491d31
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::4::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="google_key"
oldColumnName="googlekey"
tableName="android_variant"
] as 1a39e5f794356cc80b5a117f3ccdb6cf
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::4::qmx: Computed checksum for 7:1a39e5f794356cc80b5a117f3ccdb6cf: as 54e6f7e471a5d44cca69350800a0c631
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::6::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="project_number"
oldColumnName="projectnumber"
tableName="android_variant"
] as 04c19c5ab4fc1b09722639c76e9a719d
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::6::qmx: Computed checksum for 7:04c19c5ab4fc1b09722639c76e9a719d: as e78cd18a6c620185e3752dde1ab0730d
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::7::qmx: Computed checksum for addNotNullConstraint:[
columnDataType="varchar(255)"
columnName="google_key"
tableName="android_variant"
] as 4d92c2642a14c5be21c996c9228cd785
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-android-variant.xml::7::qmx: Computed checksum for 7:4d92c2642a14c5be21c996c9228cd785: as c86cb451ce931d234615640c096ff7b9
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-simplepush-variant.xml::2::qmx: Computed checksum for renameTable:[
newTableName="simple_push_variant"
oldTableName="simplepushvariant"
] as cec19c7bd0960be63e946f583eccf419
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-simplepush-variant.xml::2::qmx: Computed checksum for 7:cec19c7bd0960be63e946f583eccf419: as a0c03d18db1fd0cc914cb53e9e5d8d87
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-adm-variant-entity.xml::1::qmx: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="client_id"
type="VARCHAR(255)"
],
[
name="client_secret"
type="VARCHAR(255)"
]
]
tableName="adm_variant"
] as 8095217afdd8df15a22db630fed89ff2
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-adm-variant-entity.xml::1::qmx: Computed checksum for 7:8095217afdd8df15a22db630fed89ff2: as ca933e97d437fc0802859838157db50a
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-adm-variant-entity.xml::2::qmx: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="adm_variant_pkey"
tableName="adm_variant"
] as c7ea9b92ffba5805af428051056662fb
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-adm-variant-entity.xml::2::qmx: Computed checksum for 7:c7ea9b92ffba5805af428051056662fb: as cfea3742f8f85170daca501c2f0761f3
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-variant.xml::2::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="push_application_id"
oldColumnName="variants_id"
tableName="variant"
] as c36c3a07c34e7dea54b67a3de807dbc3
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-variant.xml::2::qmx: Computed checksum for 7:c36c3a07c34e7dea54b67a3de807dbc3: as a3139bb8002e520c65f120d0cf8970a4
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-variant.xml::4::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="api_key"
oldColumnName="variantid"
tableName="variant"
] as bb59afcc9d8dbd42e1479ba66165cc68
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-variant.xml::4::qmx: Computed checksum for 7:bb59afcc9d8dbd42e1479ba66165cc68: as f8d0a8e5c27fe64fdec93fb58ce7132e
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-push-application.xml::2::qmx: Computed checksum for renameTable:[
newTableName="push_application"
oldTableName="pushapplication"
] as 10918927864b37a81e24c8fefb76cbc1
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-push-application.xml::2::qmx: Computed checksum for 7:10918927864b37a81e24c8fefb76cbc1: as 35e0ca67471730cf9b3c622976ba2565
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-push-application.xml::4::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="master_secret"
oldColumnName="mastersecret"
tableName="push_application"
] as 5a0529acc2bd572990f3e372a103f4a3
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-push-application.xml::4::qmx: Computed checksum for 7:5a0529acc2bd572990f3e372a103f4a3: as afeb3a85d6b0c1394436883cf9917ba9
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-push-application.xml::6::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="api_key"
oldColumnName="pushapplicationid"
tableName="push_application"
] as 8ff1ecb431f9a2142d60fff9c57dbf32
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-push-application.xml::6::qmx: Computed checksum for 7:8ff1ecb431f9a2142d60fff9c57dbf32: as f2e40d0c3cb4b49b73adb553c506aa0f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::1::qmx: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
]
]
tableName="windows_mpns_variant"
] as f3b4db7dc020aef57ef35f2ecad11122
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::1::qmx: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="windows_mpns_variant_pkey"
tableName="windows_mpns_variant"
] as db32a144ee47d5ce6ca370ff959dc6c0
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::1::qmx: Computed checksum for 7:f3b4db7dc020aef57ef35f2ecad11122:7:db32a144ee47d5ce6ca370ff959dc6c0: as b9475cdb03f15df5f5e502f4591b26c7
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::2::qmx: Computed checksum for createTable:[
columns=[
[
[
nullable="false"
]
name="id"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="client_secret"
type="VARCHAR(255)"
],
[
[
nullable="false"
]
name="sid"
type="VARCHAR(255)"
]
]
tableName="windows_wns_variant"
] as 0ce73b315bf7651f181bc9f20f04edb4
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::2::qmx: Computed checksum for addPrimaryKey:[
columnNames="id"
constraintName="windows_wns_variant_pkey"
tableName="windows_wns_variant"
] as 7618b281ec914d0c62a2a88a194c8711
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::2::qmx: Computed checksum for 7:0ce73b315bf7651f181bc9f20f04edb4:7:7618b281ec914d0c62a2a88a194c8711: as d59b0dd54785c0203724051edf275fe4
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::3::qmx: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="id"
baseTableName="windows_mpns_variant"
constraintName="fk_649wp2ys69m1jxb33tl3trjig"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="variant"
] as 8c717dd5ad6dfd589391fb5b09f65f5b
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::3::qmx: Computed checksum for 7:8c717dd5ad6dfd589391fb5b09f65f5b: as 8e8bce6c39a0c284f28ee9a9d9edde75
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::4::qmx: Computed checksum for addForeignKeyConstraint:[
baseColumnNames="id"
baseTableName="windows_wns_variant"
constraintName="fk_omslx9kb1rm4p2s8t5qvf4wrp"
deferrable="false"
initiallyDeferred="false"
onDelete="NO ACTION"
onUpdate="NO ACTION"
referencedColumnNames="id"
referencedTableName="variant"
] as 629a20ff4b5db4f06add7574e8269b9f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-add-windows-variant-entities.xml::4::qmx: Computed checksum for 7:629a20ff4b5db4f06add7574e8269b9f: as a437f880957c294a50a5ed0d258afa35
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::02::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(4096)"
newColumnName="device_token"
oldColumnName="devicetoken"
tableName="installation"
] as a1b33392901786a0a445d5112c525260
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::02::qmx: Computed checksum for 7:a1b33392901786a0a445d5112c525260: as 283db871758b49779d5c2c97c2b7bcf0
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::04::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="device_type"
oldColumnName="devicetype"
tableName="installation"
] as f6003f2b9a50a545422498e03e0b61ff
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::04::qmx: Computed checksum for 7:f6003f2b9a50a545422498e03e0b61ff: as 5ba7ff63d6a5cb5e8b657a6334c31f50
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::06::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="operating_system"
oldColumnName="operatingsystem"
tableName="installation"
] as a39a13706efeff435a300c69545e9919
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::06::qmx: Computed checksum for 7:a39a13706efeff435a300c69545e9919: as 5059da86c1d783a2366fbf19a260d80e
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::08::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="os_version"
oldColumnName="osversion"
tableName="installation"
] as 97c7ccf521001be549ce38c9090a8baa
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::08::qmx: Computed checksum for 7:97c7ccf521001be549ce38c9090a8baa: as 4b658ff4662e61b3ff10255e8128fc8c
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::10::qmx: Computed checksum for renameColumn:[
columnDataType="VARCHAR(255)"
newColumnName="variant_id"
oldColumnName="variantid"
tableName="installation"
] as 544a9f25fd473863f3e0a9e575edb278
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::10::qmx: Computed checksum for 7:544a9f25fd473863f3e0a9e575edb278: as a4293f49276ca228a5c686dc1702836f
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Running Changeset:liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Changeset liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='fed_providers' and const.constraint_name='uk_dccirjlipu1478vqc89did88c'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='realm' and const.constraint_name='uk_orvsdmla56612eaefiq6wl5oi'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='client' and const.constraint_name='uk_b71cjlbenv945rb6gcon438at'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='variant' and const.constraint_name='uk_jlpkx1qkcjaps25wqhp4nkfel'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='realm_default_roles' and const.constraint_name='uk_h4wpd7w4hsoolni3h0sw7btje'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='keycloak_role' and const.constraint_name='uk_j3rwuvd56ontgsuhogm184ww2'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='user_entity' and const.constraint_name='uk_ru8tt6t700s9v50bu18ws5ha6'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='user_entity' and const.constraint_name='uk_dykn684sl8up1crfei6eckhd7'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='application_default_roles' and const.constraint_name='uk_8aelwnibji49avxsrtuf6xjow'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing QUERY database command: select const.CONSTRAINT_NAME, COLUMN_NAME from information_schema.table_constraints const join information_schema.key_column_usage col on const.constraint_schema=col.constraint_schema and const.table_name=col.table_name and const.constraint_name=col.constraint_name where const.constraint_catalog='unifiedpush' and const.constraint_schema='public' and const.table_name='realm_application' and const.constraint_name='uk_l5qga3rfme47335jy8jxyxh3i'order by ordinal_position
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Reading ChangeSet: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing Statement: liquibase.statement.core.AddForeignKeyConstraintStatement@398dada8
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing EXECUTE database command: ALTER TABLE public.installation ADD CONSTRAINT fk_q1c2n4kjui158w3t1llg99koq FOREIGN KEY (variant_id) REFERENCES public.variant (id) ON UPDATE NO ACTION ON DELETE NO ACTION
SEVERE 7/15/15 3:15 PM: liquibase: liquibase/master.xml: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Change Set liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx failed. Error: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
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.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
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.integration.commandline.Main.doMigration(Main.java:1044)
at liquibase.integration.commandline.Main.run(Main.java:175)
at liquibase.integration.commandline.Main.main(Main.java:94)
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
... 11 more
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Release Database Lock
DEBUG 7/15/15 3:15 PM: liquibase: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Executing UPDATE database command: UPDATE public.ups_db_changeloglock SET LOCKED = FALSE, LOCKEDBY = NULL, LOCKGRANTED = NULL WHERE ID = 1
INFO 7/15/15 3:15 PM: liquibase: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: Successfully released change log lock
Unexpected error running Liquibase: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
SEVERE 7/15/15 3:15 PM: liquibase: liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
liquibase.exception.MigrationFailedException: Migration failed for change set liquibase/1.1.0-Final/2015-07-08-normalize-installation.xml::11::qmx:
Reason: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
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.integration.commandline.Main.doMigration(Main.java:1044)
at liquibase.integration.commandline.Main.run(Main.java:175)
at liquibase.integration.commandline.Main.main(Main.java:94)
Caused by: liquibase.exception.DatabaseException: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
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.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1227)
at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1210)
at liquibase.changelog.ChangeSet.execute(ChangeSet.java:550)
... 6 more
Caused by: org.postgresql.util.PSQLException: ERROR: insert or update on table "installation" violates foreign key constraint "fk_q1c2n4kjui158w3t1llg99koq"
Detail: Key (variant_id)=(3d6497f3-4480-4962-8444-296347be2600) is not present in table "variant".
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2157)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1886)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:255)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:559)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:403)
at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:395)
at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:314)
... 11 more
For more information, use the --logLevel flag
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment