Error deploying - introducing user.role?
Error log:
at org.springframework.boot.loader.Launcher.launch(Launcher.java:87),
at org.springframework.boot.loader.Launcher.launch(Launcher.java:51),
at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:52),
Caused by: org.springframework.dao.InvalidDataAccessResourceUsageException: could not extract ResultSet; SQL [n/a]; nested exception is org.hibernate.exception.SQLGrammarException: could not extract ResultSet,
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.convertHibernateAccessException(HibernateJpaDialect.java:281),
at org.springframework.orm.jpa.vendor.HibernateJpaDialect.translateExceptionIfPossible(HibernateJpaDialect.java:255),
at org.springframework.orm.jpa.AbstractEntityManagerFactoryBean.translateExceptionIfPossible(AbstractEntityManagerFactoryBean.java:528),
at org.springframework.dao.support.ChainedPersistenceExceptionTranslator.translateExceptionIfPossible(ChainedPersistenceExceptionTranslator.java:61),
at org.springframework.dao.support.DataAccessUtils.translateIfNecessary(DataAccessUtils.java:242),
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:153),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.data.jpa.repository.support.CrudMethodMetadataPostProcessor$CrudMethodMetadataPopulatingMethodInterceptor.invoke(CrudMethodMetadataPostProcessor.java:178),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:95),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212),
at com.sun.proxy.$Proxy135.saveAll(Unknown Source),
at eu.sshopencloud.marketplace.conf.startup.InitialDataLoader.loadProfileData(InitialDataLoader.java:92),
at eu.sshopencloud.marketplace.conf.startup.MarketplaceStartupRunner.run(MarketplaceStartupRunner.java:47),
at org.springframework.boot.SpringApplication.callRunner(SpringApplication.java:784),
... 13 common frames omitted,
Caused by: org.hibernate.exception.SQLGrammarException: could not extract ResultSet,
at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:103),
at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42),
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:113),
at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:99),
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:67),
at org.hibernate.loader.Loader.getResultSet(Loader.java:2292),
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2050),
at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:2012),
at org.hibernate.loader.Loader.doQuery(Loader.java:953),
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:354),
at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:324),
at org.hibernate.loader.Loader.loadEntity(Loader.java:2406),
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:64),
at org.hibernate.loader.entity.AbstractEntityLoader.load(AbstractEntityLoader.java:54),
at org.hibernate.persister.entity.AbstractEntityPersister.load(AbstractEntityPersister.java:4379),
at org.hibernate.event.internal.DefaultLoadEventListener.loadFromDatasource(DefaultLoadEventListener.java:569),
at org.hibernate.event.internal.DefaultLoadEventListener.doLoad(DefaultLoadEventListener.java:537),
at org.hibernate.event.internal.DefaultLoadEventListener.load(DefaultLoadEventListener.java:208),
at org.hibernate.event.internal.DefaultLoadEventListener.proxyOrLoad(DefaultLoadEventListener.java:332),
at org.hibernate.event.internal.DefaultLoadEventListener.doOnLoad(DefaultLoadEventListener.java:108),
at org.hibernate.event.internal.DefaultLoadEventListener.onLoad(DefaultLoadEventListener.java:74),
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:118),
at org.hibernate.internal.SessionImpl.fireLoadNoChecks(SessionImpl.java:1168),
at org.hibernate.internal.SessionImpl.fireLoad(SessionImpl.java:1157),
at org.hibernate.internal.SessionImpl.access$2000(SessionImpl.java:197),
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.doLoad(SessionImpl.java:2795),
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.lambda$load$1(SessionImpl.java:2776),
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.perform(SessionImpl.java:2732),
at org.hibernate.internal.SessionImpl$IdentifierLoadAccessImpl.load(SessionImpl.java:2776),
at org.hibernate.internal.SessionImpl.get(SessionImpl.java:970),
at org.hibernate.event.internal.DefaultMergeEventListener.entityIsDetached(DefaultMergeEventListener.java:306),
at org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:172),
at org.hibernate.event.internal.DefaultMergeEventListener.onMerge(DefaultMergeEventListener.java:70),
at org.hibernate.event.service.internal.EventListenerGroupImpl.fireEventOnEachListener(EventListenerGroupImpl.java:108),
at org.hibernate.internal.SessionImpl.fireMerge(SessionImpl.java:775),
at org.hibernate.internal.SessionImpl.merge(SessionImpl.java:762),
at jdk.internal.reflect.GeneratedMethodAccessor143.invoke(Unknown Source),
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source),
at java.base/java.lang.reflect.Method.invoke(Unknown Source),
at org.springframework.orm.jpa.SharedEntityManagerCreator$SharedEntityManagerInvocationHandler.invoke(SharedEntityManagerCreator.java:314),
at com.sun.proxy.$Proxy124.merge(Unknown Source),
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.save(SimpleJpaRepository.java:557),
at org.springframework.data.jpa.repository.support.SimpleJpaRepository.saveAll(SimpleJpaRepository.java:588),
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method),
at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(Unknown Source),
at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source),
at java.base/java.lang.reflect.Method.invoke(Unknown Source),
at org.springframework.data.repository.core.support.RepositoryComposition$RepositoryFragments.invoke(RepositoryComposition.java:371),
at org.springframework.data.repository.core.support.RepositoryComposition.invoke(RepositoryComposition.java:204),
at org.springframework.data.repository.core.support.RepositoryFactorySupport$ImplementationMethodExecutionInterceptor.invoke(RepositoryFactorySupport.java:657),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.doInvoke(RepositoryFactorySupport.java:621),
at org.springframework.data.repository.core.support.RepositoryFactorySupport$QueryExecutorMethodInterceptor.invoke(RepositoryFactorySupport.java:605),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.data.projection.DefaultMethodInvokingMethodInterceptor.invoke(DefaultMethodInvokingMethodInterceptor.java:80),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:366),
at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99),
at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186),
at org.springframework.dao.support.PersistenceExceptionTranslationInterceptor.invoke(PersistenceExceptionTranslationInterceptor.java:139),
... 23 common frames omitted,
Caused by: org.postgresql.util.PSQLException: ERROR: column user0_.role does not exist,
Position: 141,
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2505),
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2241),
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:310),
at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:447),
at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:368),
at org.postgresql.jdbc.PgPreparedStatement.executeWithFlags(PgPreparedStatement.java:158),
at org.postgresql.jdbc.PgPreparedStatement.executeQuery(PgPreparedStatement.java:108),
at com.zaxxer.hikari.pool.ProxyPreparedStatement.executeQuery(ProxyPreparedStatement.java:52),
at com.zaxxer.hikari.pool.HikariProxyPreparedStatement.executeQuery(HikariProxyPreparedStatement.java),
at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:57),
... 78 common frames omitted,
14-04-2020 06:43:20.956 [main] INFO o.s.s.c.ThreadPoolTaskExecutor.shutdown - Shutting down ExecutorService 'applicationTaskExecutor',
14-04-2020 06:43:20.971 [main] INFO o.s.o.j.LocalContainerEntityManagerFactoryBean.destroy - Closing JPA EntityManagerFactory for persistence unit 'default',
14-04-2020 06:43:20.975 [main] INFO com.zaxxer.hikari.HikariDataSource.close - HikariPool-1 - Shutdown initiated...,
14-04-2020 06:43:20.983 [main] INFO com.zaxxer.hikari.HikariDataSource.close - HikariPool-1 - Shutdown completed.,
notify: @p.dpancic
Edited by Matej Durco