Делаю changelog на pgsql выходить ошибка, как решить?

Question

[Aidos69]

Код должен удалять с одной таблицы, и добавлять в другой.
вот код:

ALTER TABLE sl.lesson {
    DROP CONSTRAINT lesson_timetable_id_fkey |
    DROP COLUMN timetable_id
}

ALTER TABLE sl.timetable {
    ADD COLUMN lesson_id uuid |
    ADD FOREIGN KEY ("lesson_group_id") REFERENCES "lesson_id"
}

Ошибки:

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'IUserRepository' defined in kz.sl.studentlife.repository.IUserRepository defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Cannot create inner bean '(inner bean)#20c812c8' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#20c812c8': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:

	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1863) ~[spring-beans-5.3.21.jar:5.3.21]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1800) ~[spring-beans-5.3.21.jar:5.3.21]
	... 113 common frames omitted

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#20c812c8': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:

Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: Invocation of init method failed; nested exception is liquibase.exception.ValidationFailedException: Validation Failed:

Caused by: liquibase.exception.ValidationFailedException: Validation Failed:


> Task :StudentlifeApplication.main() FAILED

Execution failed for task ':StudentlifeApplication.main()'.
> Process 'command 'C:/Users/user/.jdks/openjdk-17.0.1/bin/java.exe'' finished with non-zero exit value 1

Comments

[Сергей Кузнецов]

Проверьте ваш русский
Непонятно зачем вы делаете выходить.

Answer 1

[Dmitry Roo]

Проверьте ваш синтаксис. Кажется, с ним что-то не то.
https://www.postgresql.org/docs/current/sql-altert...

Answer 2

[mayton2019]

Что за вертикальная палочка? Зачем она?

ALTER TABLE sl.lesson {
    DROP CONSTRAINT lesson_timetable_id_fkey |
    DROP COLUMN timetable_id
}

А это что?

liquibase.exception.ValidationFailedException: Validation Failed:

Изменял change-sets грязными руками? Этого нельзя делать. То что установлено в репо - маркируется контрольной суммой и нельзя фиксить задним числом. Создаёшь новый changeset который исправляет.