# generateChangeLog fails to include columns in createTable commands **URL:** \ **Category:** General Discussion\ **Created:** [January 31, 2018, 1:04am UTC](https://forum.liquibase.org/t/generatechangelog-fails-to-include-columns-in-createtable-commands/3589 "2018-01-31T01:04:00Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![un1382561729492r88id](https://avatars.discourse-cdn.com/v4/letter/u/c4cdca/32.png) [@un1382561729492r88id](https://forum.liquibase.org/u/un1382561729492r88id)\ **Post date:** [January 31, 2018, 1:04am UTC](https://forum.liquibase.org/t/generatechangelog-fails-to-include-columns-in-createtable-commands/3589/1 "2018-01-31T01:04:00Z")
It sounds like you are doing reasonable steps and getting unexpected results. I see you have logLevel debug already set, can you share the logs? Steve Donie Principal Software Engineer Datical, Inc. [http://www.datical.com/](http://www.datical.com/) ---
**Author:** ![ErikLumpkin](https://avatars.discourse-cdn.com/v4/letter/e/5e9695/32.png) [@ErikLumpkin](https://forum.liquibase.org/u/ErikLumpkin)\ **Post date:** [January 31, 2018, 1:04am UTC](https://forum.liquibase.org/t/generatechangelog-fails-to-include-columns-in-createtable-commands/3589/2 "2018-01-31T01:04:00Z")
Hello, I’m new to Liquibase and am looking to see how it can be used on an already existing project.  I found the documentation on how to generate a changelog against our existing MySql DB.  But all of my attempts to do so have created changelogs which fail validation as part of a later update/changeLogSync command due to the fact that no column definitions are included in the create table commands. In case it illuminates a mistake I’m making, there’s the command I ran: \>java -jar c:\shortenedPath\liquibase-core-3.5.3.jar --driver=com.mysql.jdbc.Driver --classpath=c:\shortenedPath\mysql-connector-java-5.1.42.jar --changeLogFile=changelog.mysql.xml --url=jdbc:mysql://localhost/mySchema --username=root --password=password --logLevel=DEBUG --defaultSchemaName=mySchema generateChangeLog and here’s a snippet of the generated changelog: \ \](http://www.liquibase.org/xml/ns/dbchangelog/dbchangelog-3.5.xsd%22>)                                                     …   Lastly I’m running this against a local mysql DB which claims to be version 5.6.26-log running on Win7.  Hopefully I’m just doing something wrong/dumb and you can point me in the better direction.  Thanks! -Erik ---
**Author:** ![un35036584346218801r](https://avatars.discourse-cdn.com/v4/letter/u/67e7ee/32.png) [@un35036584346218801r](https://forum.liquibase.org/u/un35036584346218801r)\ **Post date:** [January 31, 2018, 1:04am UTC](https://forum.liquibase.org/t/generatechangelog-fails-to-include-columns-in-createtable-commands/3589/3 "2018-01-31T01:04:00Z")
Sure.  Sorry it’s a bit ugly (thanks terrible windows command line). C:\Users\elumpkin\Desktop\>java -jar c:\Users\elumpkin.gradle\caches\modules-2\f iles-2.1\org.liquibase\liquibase-core\3.5.3\f346404c3876c5bd0e07a7e10b7565bdcd35 dbab\liquibase-core-3.5.3.jar --driver=com.mysql.jdbc.Driver --classpath=c:\User s\elumpkin.gradle\caches\modules-2\files-2.1\mysql\mysql-connector-java\5.1.42\ 80a448a3ec2178b649bb2e3cb3610fab06e11669\mysql-connector-java-5.1.42.jar --chang eLogFile=changelog.mysql.xml --url=jdbc:mysql://localhost/cais --username=root - -password=password --logLevel=DEBUG --defaultSchemaName=cais generateChangeLog DEBUG 1/31/18 5:17 PM: liquibase: Connected to root@localhost@jdbc:mysql://local host/cais DEBUG 1/31/18 5:17 PM: liquibase: Setting auto commit to false from true DEBUG 1/31/18 5:17 PM: liquibase: Executing EXECUTE database command: USE cais DEBUG 1/31/18 5:17 PM: liquibase: Computed checksum for 1517440651454 as 5842fe5 70773e5316474acef11f7cfca DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='campaig nreferral’ and const.constraint\_name='emailaddress\_unique’order by ordinal\_posit ion DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='campaig nreferral’ and const.constraint\_name='campaigntoken\_unique’order by ordinal\_posi tion DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='fundmap ping’ and const.constraint\_name='unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='adminad visorteam’ and const.constraint\_name='uniq’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='redempt ion\_document’ and const.constraint\_name='fundid\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='positio n\_by\_nav’ and const.constraint\_name='id\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='positio n’ and const.constraint\_name='positionid\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='sharecl assdocument’ and const.constraint\_name='shareclassdocumentclient’order by ordina l\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='acl\_sid ’ and const.constraint\_name='unique\_uk\_1’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='rebate\_ by\_nav’ and const.constraint\_name='id\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='adminin vestmententity’ and const.constraint\_name='uniq’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='ofacven dor’ and const.constraint\_name='vendorid\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='product documents’ and const.constraint\_name='uniq’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='investm ententitydocument’ and const.constraint\_name='uniq’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='acl\_cla ss’ and const.constraint\_name='unique\_uk\_2’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='cmequit yoffering’ and const.constraint\_name='internalcusip\_unique’order by ordinal\_posi tion DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='cmprefe rredofferings’ and const.constraint\_name='internalcusip\_unique’order by ordinal\_ position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='documen t’ and const.constraint\_name='documentid\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='documen t’ and const.constraint\_name='hasheddocid\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='fundser ies’ and const.constraint\_name='fundseriesid\_unique’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='fundser ies’ and const.constraint\_name='fundshareclass-uniq’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='acl\_obj ect\_identity’ and const.constraint\_name='unique\_uk\_3’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select const .CONSTRAINT\_NAME, COLUMN\_NAME from information\_schema.table\_constraints const jo in information\_schema.key\_column\_usage col on const.constraint\_schema=col.constr aint\_schema and const.table\_name=col.table\_name and const.constraint\_name=col.co nstraint\_name where const.constraint\_schema=‘cais’ and const.table\_name='acl\_ent ry’ and const.constraint\_name='unique\_uk\_4’order by ordinal\_position DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_weeklyestimates’ a nd table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name='vw\_populatechartdatab ytotalfunds’ and table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_producttype’ and t able\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name='hierarchyrelationship ’ and table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_monthlyactuals’ an d table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_uncomplete\_task’ a nd table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name='vw\_available\_offshore \_funds’ and table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_factsheetdata’ and  table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_monthlyestimates’ and table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_positiongraphdata’  and table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name='vw\_available\_onshore\_ funds’ and table\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_facetednav’ and ta ble\_schema=‘cais’ DEBUG 1/31/18 5:17 PM: liquibase: Executing QUERY database command: select view\_ definition from information\_schema.views where table\_name=‘vw\_gettaskstatus’ and  table\_schema=‘cais’ INFO 1/31/18 5:17 PM: liquibase: Can not use class liquibase.serializer.core.yam l.YamlChangeLogSerializer as a Liquibase service because org.yaml.snakeyaml.repr esenter.Representer is not in the classpath INFO 1/31/18 5:17 PM: liquibase: Can not use class liquibase.serializer.core.jso n.JsonChangeLogSerializer as a Liquibase service because org.yaml.snakeyaml.repr esenter.Representer is not in the classpath INFO 1/31/18 5:17 PM: liquibase: changelog.mysql.xml does not exist, creating DEBUG 1/31/18 5:17 PM: liquibase: MissingObjectChangeGenerator type order:     l iquibase.structure.core.Catalog    liquibase.structure.core.Schema    liquibase. structure.core.Sequence    liquibase.structure.core.StoredProcedure    liquibase .structure.core.Table    liquibase.structure.core.Column    liquibase.structure. core.PrimaryKey    liquibase.structure.core.UniqueConstraint    liquibase.struct ure.core.Index    liquibase.structure.core.ForeignKey    liquibase.structure.cor e.View DEBUG 1/31/18 5:17 PM: liquibase: UnexpectedObjectChangeGenerator type order:   liquibase.structure.core.Catalog    liquibase.structure.core.ForeignKey    liq uibase.structure.core.Schema    liquibase.structure.core.StoredProcedure    liqu ibase.structure.core.UniqueConstraint    liquibase.structure.core.View    liquib ase.structure.core.Table    liquibase.structure.core.PrimaryKey    liquibase.str ucture.core.Column    liquibase.structure.core.Index    liquibase.structure.core .Sequence DEBUG 1/31/18 5:17 PM: liquibase: ChangedObjectChangeGenerator type order:     l iquibase.structure.core.Catalog    liquibase.structure.core.ForeignKey    liquib ase.structure.core.Schema    liquibase.structure.core.Sequence    liquibase.stru cture.core.StoredProcedure    liquibase.structure.core.Table    liquibase.struct ure.core.Column    liquibase.structure.core.PrimaryKey    liquibase.structure.co re.UniqueConstraint    liquibase.structure.core.Index    liquibase.structure.cor e.View Liquibase ‘generateChangeLog’ Successful