# Diff doesn't see new column **URL:** \ **Category:** General Discussion\ **Created:** [February 24, 2021, 11:45am UTC](https://forum.liquibase.org/t/diff-doesnt-see-new-column/5115 "2021-02-24T11:45:39Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![rolton](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rolton](https://forum.liquibase.org/u/rolton)\ **Post date:** [February 24, 2021, 11:45am UTC](https://forum.liquibase.org/t/diff-doesnt-see-new-column/5115/1 "2021-02-24T11:45:40Z")
When i do diff it creates log with drop tables that exists in db and exists in model and there is no changes of my new test column. referenceUrl links `hibernate:spring:kz.csi.stat.csc.modules?dialect=org.hibernate.dialect.PostgreSQL9Dialect&hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy&hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy` my entity looks like ``` @Entity(name = "dict_unit") data class DictUnitEntity ( @Id @GeneratedValue(strategy = GenerationType.AUTO) val id: Long?, @Column(length = 5000) val test: String? ) ``` new column “test” which not exists in db and it is missing in log file that created after diff diff log contains this and more like this ```auto ``` Maybe I don’t understand diff command? ---
**Author:** ![ronak](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.liquibase.org/ronak/32/221_2.png) [@ronak](https://forum.liquibase.org/u/ronak)\ **Post date:** [February 25, 2021, 4:38am UTC](https://forum.liquibase.org/t/diff-doesnt-see-new-column/5115/2 "2021-02-25T04:38:46Z")
Hi @rolton , Would you share: - the exact liquibase command you are running? - the contents of your liquibase.properties file (redact passwords please). At the bare minimum need to see the url, refurl, and classpath - the output from running liquibase? (please use logLevel=DEBUG) This info would help us determine the exact command used, and if correct we can try and reproduce. ---
**Author:** ![rolton](https://avatars.discourse-cdn.com/v4/letter/r/5e9695/32.png) [@rolton](https://forum.liquibase.org/u/rolton)\ **Post date:** [February 25, 2021, 8:26am UTC](https://forum.liquibase.org/t/diff-doesnt-see-new-column/5115/3 "2021-02-25T08:26:22Z")
> [@ronak](#): > > the exact liquibase command you are running? mvn liquibase:diff or ```auto process-resources diff ``` > [@ronak](#): > > the contents of your liquibase.properties file (redact passwords please). At the bare minimum need to see the url, refurl, and classpath > **config** > > ```auto > > ${project.basedir}/src/main/resources/config/liquibase/master.xml > ${project.basedir}/src/main/resources/config/liquibase/changelog/${maven.build.timestamp}_changelog.xml > org.postgresql.Driver > jdbc:postgresql://localhost:5432/test > > FreshHipster > > hibernate:spring:kz.csi.stat.csc.modules.dict.data?dialect=org.hibernate.dialect.PostgreSQLDialect&hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy&hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy > true > debug > debug > !test > tables,columns,foreignkeys,primarykeys,uniqueconstraints > key > > > ``` > [@ronak](#): > > the output from running liquibase? (please use logLevel=DEBUG) > **output** > > ```auto > [INFO] Reading hibernate configuration hibernate:spring:kz.csi.stat.csc.modules.dict.data?dialect=org.hibernate.dialect.PostgreSQLDialect&hibernate.physical_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringPhysicalNamingStrategy&hibernate.implicit_naming_strategy=org.springframework.boot.orm.jpa.hibernate.SpringImplicitNamingStrategy > [INFO] Found package kz.csi.stat.csc.modules.dict.data > [INFO] HHH000204: Processing PersistenceUnitInfo [name: default] > [INFO] HHH000412: Hibernate ORM core version 5.4.27.Final > [INFO] HCANN000001: Hibernate Commons Annotations {5.1.2.Final} > [WARNING] HHH000181: No appropriate connection provider encountered, assuming application will be supplying connections > [WARNING] HHH000342: Could not obtain connection to query metadata > java.lang.UnsupportedOperationException: The application must supply JDBC connections > at org.hibernate.engine.jdbc.connections.internal.UserSuppliedConnectionProviderImpl.getConnection (UserSuppliedConnectionProviderImpl.java:44) > at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection (JdbcEnvironmentInitiator.java:180) > at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService (JdbcEnvironmentInitiator.java:68) > at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator.initiateService (JdbcEnvironmentInitiator.java:35) > at org.hibernate.boot.registry.internal.StandardServiceRegistryImpl.initiateService (StandardServiceRegistryImpl.java:101) > at org.hibernate.service.internal.AbstractServiceRegistryImpl.createService (AbstractServiceRegistryImpl.java:263) > at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService (AbstractServiceRegistryImpl.java:237) > at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService (AbstractServiceRegistryImpl.java:214) > at org.hibernate.id.factory.internal.DefaultIdentifierGeneratorFactory.injectServices (DefaultIdentifierGeneratorFactory.java:152) > at org.hibernate.service.internal.AbstractServiceRegistryImpl.injectDependencies (AbstractServiceRegistryImpl.java:286) > at org.hibernate.service.internal.AbstractServiceRegistryImpl.initializeService (AbstractServiceRegistryImpl.java:243) > at org.hibernate.service.internal.AbstractServiceRegistryImpl.getService (AbstractServiceRegistryImpl.java:214) > at org.hibernate.boot.internal.InFlightMetadataCollectorImpl. (InFlightMetadataCollectorImpl.java:176) > at org.hibernate.boot.model.process.spi.MetadataBuildingProcess.complete (MetadataBuildingProcess.java:127) > at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.metadata (EntityManagerFactoryBuilderImpl.java:1224) > at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build (EntityManagerFactoryBuilderImpl.java:1255) > at liquibase.ext.hibernate.database.HibernateEjb3Database.buildMetadataFromPath (HibernateEjb3Database.java:59) > at liquibase.ext.hibernate.database.HibernateDatabase.buildMetadata (HibernateDatabase.java:143) > at liquibase.ext.hibernate.database.HibernateDatabase.setConnection (HibernateDatabase.java:83) > at liquibase.database.DatabaseFactory.findCorrectDatabaseImplementation (DatabaseFactory.java:121) > at liquibase.database.DatabaseFactory.openDatabase (DatabaseFactory.java:141) > at liquibase.integration.commandline.CommandLineUtils.createDatabaseObject (CommandLineUtils.java:96) > at org.liquibase.maven.plugins.LiquibaseDatabaseDiff.performLiquibaseTask (LiquibaseDatabaseDiff.java:222) > at org.liquibase.maven.plugins.AbstractLiquibaseMojo.lambda$null$0 (AbstractLiquibaseMojo.java:451) > at liquibase.Scope.lambda$child$0 (Scope.java:160) > at liquibase.Scope.child (Scope.java:169) > at liquibase.Scope.child (Scope.java:159) > at liquibase.Scope.child (Scope.java:138) > at org.liquibase.maven.plugins.AbstractLiquibaseMojo.lambda$execute$1 (AbstractLiquibaseMojo.java:377) > at liquibase.Scope.lambda$child$0 (Scope.java:160) > at liquibase.Scope.child (Scope.java:169) > at liquibase.Scope.child (Scope.java:159) > at liquibase.Scope.child (Scope.java:138) > at liquibase.Scope.child (Scope.java:222) > at liquibase.Scope.child (Scope.java:226) > at org.liquibase.maven.plugins.AbstractLiquibaseMojo.execute (AbstractLiquibaseMojo.java:306) > at org.liquibase.maven.plugins.LiquibaseDatabaseDiff.execute (LiquibaseDatabaseDiff.java:187) > at org.apache.maven.plugin.DefaultBuildPluginManager.executeMojo (DefaultBuildPluginManager.java:137) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:210) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148) > at org.apache.maven.lifecycle.internal.MojoExecutor.executeForkedExecutions (MojoExecutor.java:355) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:200) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:156) > at org.apache.maven.lifecycle.internal.MojoExecutor.execute (MojoExecutor.java:148) > at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:117) > at org.apache.maven.lifecycle.internal.LifecycleModuleBuilder.buildProject (LifecycleModuleBuilder.java:81) > at org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder.build (SingleThreadedBuilder.java:56) > at org.apache.maven.lifecycle.internal.LifecycleStarter.execute (LifecycleStarter.java:128) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:305) > at org.apache.maven.DefaultMaven.doExecute (DefaultMaven.java:192) > at org.apache.maven.DefaultMaven.execute (DefaultMaven.java:105) > at org.apache.maven.cli.MavenCli.execute (MavenCli.java:957) > at org.apache.maven.cli.MavenCli.doMain (MavenCli.java:289) > at org.apache.maven.cli.MavenCli.main (MavenCli.java:193) > at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0 (Native Method) > at jdk.internal.reflect.NativeMethodAccessorImpl.invoke (NativeMethodAccessorImpl.java:62) > at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke (DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke (Method.java:566) > at org.codehaus.plexus.classworlds.launcher.Launcher.launchEnhanced (Launcher.java:282) > at org.codehaus.plexus.classworlds.launcher.Launcher.launch (Launcher.java:225) > at org.codehaus.plexus.classworlds.launcher.Launcher.mainWithExitCode (Launcher.java:406) > at org.codehaus.plexus.classworlds.launcher.Launcher.main (Launcher.java:347) > [INFO] HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect > [INFO] Envers integration enabled? : true > [INFO] HHH10005002: No explicit CDI BeanManager reference was passed to Hibernate, but CDI is available on the Hibernate ClassLoader. > [INFO] HV000001: Hibernate Validator 6.0.17.Final > [INFO] HHH000490: Using JtaPlatform implementation: [org.hibernate.engine.transaction.jta.platform.internal.NoJtaPlatform] > [INFO] HHH000400: Using dialect: org.hibernate.dialect.PostgreSQLDialect > [INFO] Using dialect org.hibernate.dialect.PostgreSQLDialect > [INFO] Performing Diff on database FreshHipster @ jdbc:postgresql://localhost:5432/test (Default Schema: public) > INFO This command might not yet capture Liquibase Pro additional object types on hibernateSpringPackage > . > . > . > [INFO] Found table dict_unit > [INFO] Found table dict_unit > . > . > . > [INFO] Found unique constraint UC_DICT_SPHERECODE_COL on dict_sphere(code) > [INFO] Found primary key dict_spherePK > [INFO] Found column id int8 > [INFO] Found column code varchar(255) > [INFO] Found column create_date timestamp > [INFO] Found column description varchar(5000) > [INFO] Found column name_en varchar(5000) > [INFO] Found column name_kz varchar(5000) > [INFO] Found column name_ru varchar(5000) > [INFO] Found column parent_id int8 > [INFO] Found column update_date timestamp > [INFO] Found table dict_unit_stat > [WARNING] Hibernate primary key name is probably truncated. dict_unit_staPK > [WARNING] Changing hibernate primary key name to dict_unit_statPK > [INFO] Found primary key dict_unit_statPK > [INFO] Found column id int8 > [INFO] Found column code varchar(255) > [INFO] Found column name_kz varchar(5000) > [INFO] Found column name_ru varchar(5000) > [INFO] Found column par_id int8 > [INFO] Found table dict_unit > [INFO] Found unique constraint UC_DICT_UNITCODE_COL on dict_unit(code) > [INFO] Found primary key dict_unitPK > [INFO] Found column id int8 > [INFO] Found column code varchar(255) > [INFO] Found column create_date timestamp > [INFO] Found column description varchar(5000) > [INFO] Found column name_en varchar(5000) > [INFO] Found column name_kz varchar(5000) > [INFO] Found column name_ru varchar(5000) > [INFO] Found column parent_id int8 > [INFO] Found column test varchar(5000) > [INFO] Found column test10 varchar(5000) > [INFO] Found column test11 varchar(5000) > [INFO] Found column update_date timestamp > [INFO] Found table dict_integration_category > [INFO] Found unique constraint UC_DICT_INTEGRATION_CATEGORYCODE_COL on dict_integration_category(code) > . > . > . > BEST PRACTICE: The changelog generated by diffChangeLog/generateChangeLog should be inspected for correctness and completeness before being deployed. > [INFO] changeSets count: 43 > [INFO] {prfojectfolder}\src\main\resources\config\liquibase\changelog\20210225081210_changelog.xml does not exist, creating and adding 43 changesets. > [INFO] Differences written to Change Log File, {prfojectfolder}/src/main/resources/config/liquibase/changelog/20210225081210_changelog.xml > > ```