Untitled
unknown
plain_text
a year ago
49 kB
8
Indexable
2024-07-02T10:28:51.491+03:00 ERROR 80568 --- [ main] o.s.boot.SpringApplication : Application run failed org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'liquibase' defined in class path resource [org/springframework/boot/autoconfigure/liquibase/LiquibaseAutoConfiguration$LiquibaseConfiguration.class]: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll: Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 542 [Failed SQL: (0) create schema if not exists raeicei; create sequence raeicei.revinfo_seq increment by 50; create table raeicei.devices ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, description varchar(255), name varchar(255) not null, type varchar(255) not null ); create table raeicei.eid_administrator ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255), eik_number varchar(255) not null, is_active boolean, name varchar(255) not null ); create table raeicei.administrator_front_office ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255) not null, is_active boolean, location varchar(255) not null, name varchar(255) not null, region varchar(255) not null, eid_administrator_id uuid not null constraint fkaa7ai8y75cdlk4eit2m97vujj references raeicei.eid_administrator ); create table raeicei.device_tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, price double precision not null, start_date date not null, device_id uuid not null constraint uk_lkp5h2uqn905sff9f9xkdy6js unique constraint fkiat50ixx0swp53sr81adc4wcg references devices, eid_administrator_id uuid not null constraint fklnofaawx21hvodutubxfg2sg3 references raeicei.eid_administrator ); create table raeicei.discounts ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, age_from integer not null, age_until integer not null, disability boolean, discount double precision not null, start_date date not null, eid_administrator_id uuid not null constraint fkld0xlun3u81jfkiagrbtutag1 references raeicei.eid_administrator ); create table raeicei.tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, currency varchar(255) constraint tariffs_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision not null, revoke_application_price double precision not null, start_application_price double precision not null, start_date date not null, stop_application_price double precision not null, eid_administrator_id uuid not null constraint fkobrmkn30xfhtoek0v91icoybs references raeicei.eid_administrator ); create table raeicei.administrator_front_office_devices ( administrator_front_office_id uuid not null constraint fk2el8uygbiguylh28tuovtdswx references raeicei.administrator_front_office, devices_id uuid not null constraint uk_j5g08t98vllgff2p8fmqxoggs unique constraint fkw6j5gyfhb3kpi93a0vxra75a references raeicei.devices ); create table raeicei.revinfo ( rev integer not null primary key, revtstmp bigint ); create table raeicei.administrator_front_office_aud ( id uuid not null, rev integer not null constraint fkhc3vr2qvvsengi1m7f87ekoi references raeicei.revinfo, revtype smallint, contact varchar(255), is_active boolean, location varchar(255), name varchar(255), region varchar(255) constraint administrator_front_office_aud_region_check check ((region >= 0) AND (region <= 28)), eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.device_tariffs_aud ( id uuid not null, rev integer not null constraint fk3dc8gm082upwq6x2jxw6l1oy2 references raeicei.revinfo, revtype smallint, price double precision, start_date date, device_id uuid, eid_administrator_id uuid, primary key (rev, id) ); create table devices_aud ( id uuid not null, rev integer not null constraint fk334l0xy7gy0qjjfr5pe1wwxie references raeicei.revinfo, revtype smallint, description varchar(255), name varchar(255), type varchar(255), primary key (rev, id) ); create table raeicei.discounts_aud ( id uuid not null, rev integer not null constraint fkn2d7xmo6yoj2m4nso3eta8cdu references raeicei.revinfo, revtype smallint, age_from integer, age_until integer, disability boolean, discount double precision, start_date date, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.eid_administrator_aud ( id uuid not null, rev integer not null constraint fk8rh5kc77fqy9h2ebea77nibfv references raeicei.revinfo, revtype smallint, contact varchar(255), eik_number varchar(255), is_active boolean, name varchar(255), primary key (rev, id) ); create table raeicei.tariffs_aud ( id uuid not null, rev integer not null constraint fk5jarao91dpmdsml4dvdnywne4 references raeicei.revinfo, revtype smallint, currency varchar(255) constraint tariffs_aud_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision, revoke_application_price double precision, start_application_price double precision, start_date date, stop_application_price double precision, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.administrator_front_office_devices_aud ( rev integer not null constraint fk7xb7vhu9tffsosugmf6uwg62c references raeicei.revinfo, administrator_front_office_id uuid not null, devices_id uuid not null, revtype smallint, primary key (administrator_front_office_id, rev, devices_id) )] at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1770) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:598) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:520) at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:326) at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:234) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:324) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:313) at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:200) at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1156) at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:931) at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:608) at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:146) at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:733) at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:435) at org.springframework.boot.SpringApplication.run(SpringApplication.java:311) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1305) at org.springframework.boot.SpringApplication.run(SpringApplication.java:1294) at bg.bulsi.mvr.raeicei.backend.BackendApplication.main(BackendApplication.java:11) Caused by: liquibase.exception.CommandExecutionException: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll: Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 542 [Failed SQL: (0) create schema if not exists raeicei; create sequence raeicei.revinfo_seq increment by 50; create table raeicei.devices ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, description varchar(255), name varchar(255) not null, type varchar(255) not null ); create table raeicei.eid_administrator ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255), eik_number varchar(255) not null, is_active boolean, name varchar(255) not null ); create table raeicei.administrator_front_office ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255) not null, is_active boolean, location varchar(255) not null, name varchar(255) not null, region varchar(255) not null, eid_administrator_id uuid not null constraint fkaa7ai8y75cdlk4eit2m97vujj references raeicei.eid_administrator ); create table raeicei.device_tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, price double precision not null, start_date date not null, device_id uuid not null constraint uk_lkp5h2uqn905sff9f9xkdy6js unique constraint fkiat50ixx0swp53sr81adc4wcg references devices, eid_administrator_id uuid not null constraint fklnofaawx21hvodutubxfg2sg3 references raeicei.eid_administrator ); create table raeicei.discounts ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, age_from integer not null, age_until integer not null, disability boolean, discount double precision not null, start_date date not null, eid_administrator_id uuid not null constraint fkld0xlun3u81jfkiagrbtutag1 references raeicei.eid_administrator ); create table raeicei.tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, currency varchar(255) constraint tariffs_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision not null, revoke_application_price double precision not null, start_application_price double precision not null, start_date date not null, stop_application_price double precision not null, eid_administrator_id uuid not null constraint fkobrmkn30xfhtoek0v91icoybs references raeicei.eid_administrator ); create table raeicei.administrator_front_office_devices ( administrator_front_office_id uuid not null constraint fk2el8uygbiguylh28tuovtdswx references raeicei.administrator_front_office, devices_id uuid not null constraint uk_j5g08t98vllgff2p8fmqxoggs unique constraint fkw6j5gyfhb3kpi93a0vxra75a references raeicei.devices ); create table raeicei.revinfo ( rev integer not null primary key, revtstmp bigint ); create table raeicei.administrator_front_office_aud ( id uuid not null, rev integer not null constraint fkhc3vr2qvvsengi1m7f87ekoi references raeicei.revinfo, revtype smallint, contact varchar(255), is_active boolean, location varchar(255), name varchar(255), region varchar(255) constraint administrator_front_office_aud_region_check check ((region >= 0) AND (region <= 28)), eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.device_tariffs_aud ( id uuid not null, rev integer not null constraint fk3dc8gm082upwq6x2jxw6l1oy2 references raeicei.revinfo, revtype smallint, price double precision, start_date date, device_id uuid, eid_administrator_id uuid, primary key (rev, id) ); create table devices_aud ( id uuid not null, rev integer not null constraint fk334l0xy7gy0qjjfr5pe1wwxie references raeicei.revinfo, revtype smallint, description varchar(255), name varchar(255), type varchar(255), primary key (rev, id) ); create table raeicei.discounts_aud ( id uuid not null, rev integer not null constraint fkn2d7xmo6yoj2m4nso3eta8cdu references raeicei.revinfo, revtype smallint, age_from integer, age_until integer, disability boolean, discount double precision, start_date date, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.eid_administrator_aud ( id uuid not null, rev integer not null constraint fk8rh5kc77fqy9h2ebea77nibfv references raeicei.revinfo, revtype smallint, contact varchar(255), eik_number varchar(255), is_active boolean, name varchar(255), primary key (rev, id) ); create table raeicei.tariffs_aud ( id uuid not null, rev integer not null constraint fk5jarao91dpmdsml4dvdnywne4 references raeicei.revinfo, revtype smallint, currency varchar(255) constraint tariffs_aud_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision, revoke_application_price double precision, start_application_price double precision, start_date date, stop_application_price double precision, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.administrator_front_office_devices_aud ( rev integer not null constraint fk7xb7vhu9tffsosugmf6uwg62c references raeicei.revinfo, administrator_front_office_id uuid not null, devices_id uuid not null, revtype smallint, primary key (administrator_front_office_id, rev, devices_id) )] at liquibase.command.CommandScope.execute(CommandScope.java:235) at liquibase.Liquibase.lambda$update$0(Liquibase.java:237) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Liquibase.runInScope(Liquibase.java:1618) at liquibase.Liquibase.update(Liquibase.java:229) at liquibase.Liquibase.update(Liquibase.java:213) at liquibase.integration.spring.SpringLiquibase.performUpdate(SpringLiquibase.java:329) at liquibase.integration.spring.SpringLiquibase.afterPropertiesSet(SpringLiquibase.java:284) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1816) at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1766) ... 18 common frames omitted Caused by: liquibase.exception.LiquibaseException: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll: Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 542 [Failed SQL: (0) create schema if not exists raeicei; create sequence raeicei.revinfo_seq increment by 50; create table raeicei.devices ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, description varchar(255), name varchar(255) not null, type varchar(255) not null ); create table raeicei.eid_administrator ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255), eik_number varchar(255) not null, is_active boolean, name varchar(255) not null ); create table raeicei.administrator_front_office ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255) not null, is_active boolean, location varchar(255) not null, name varchar(255) not null, region varchar(255) not null, eid_administrator_id uuid not null constraint fkaa7ai8y75cdlk4eit2m97vujj references raeicei.eid_administrator ); create table raeicei.device_tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, price double precision not null, start_date date not null, device_id uuid not null constraint uk_lkp5h2uqn905sff9f9xkdy6js unique constraint fkiat50ixx0swp53sr81adc4wcg references devices, eid_administrator_id uuid not null constraint fklnofaawx21hvodutubxfg2sg3 references raeicei.eid_administrator ); create table raeicei.discounts ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, age_from integer not null, age_until integer not null, disability boolean, discount double precision not null, start_date date not null, eid_administrator_id uuid not null constraint fkld0xlun3u81jfkiagrbtutag1 references raeicei.eid_administrator ); create table raeicei.tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, currency varchar(255) constraint tariffs_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision not null, revoke_application_price double precision not null, start_application_price double precision not null, start_date date not null, stop_application_price double precision not null, eid_administrator_id uuid not null constraint fkobrmkn30xfhtoek0v91icoybs references raeicei.eid_administrator ); create table raeicei.administrator_front_office_devices ( administrator_front_office_id uuid not null constraint fk2el8uygbiguylh28tuovtdswx references raeicei.administrator_front_office, devices_id uuid not null constraint uk_j5g08t98vllgff2p8fmqxoggs unique constraint fkw6j5gyfhb3kpi93a0vxra75a references raeicei.devices ); create table raeicei.revinfo ( rev integer not null primary key, revtstmp bigint ); create table raeicei.administrator_front_office_aud ( id uuid not null, rev integer not null constraint fkhc3vr2qvvsengi1m7f87ekoi references raeicei.revinfo, revtype smallint, contact varchar(255), is_active boolean, location varchar(255), name varchar(255), region varchar(255) constraint administrator_front_office_aud_region_check check ((region >= 0) AND (region <= 28)), eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.device_tariffs_aud ( id uuid not null, rev integer not null constraint fk3dc8gm082upwq6x2jxw6l1oy2 references raeicei.revinfo, revtype smallint, price double precision, start_date date, device_id uuid, eid_administrator_id uuid, primary key (rev, id) ); create table devices_aud ( id uuid not null, rev integer not null constraint fk334l0xy7gy0qjjfr5pe1wwxie references raeicei.revinfo, revtype smallint, description varchar(255), name varchar(255), type varchar(255), primary key (rev, id) ); create table raeicei.discounts_aud ( id uuid not null, rev integer not null constraint fkn2d7xmo6yoj2m4nso3eta8cdu references raeicei.revinfo, revtype smallint, age_from integer, age_until integer, disability boolean, discount double precision, start_date date, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.eid_administrator_aud ( id uuid not null, rev integer not null constraint fk8rh5kc77fqy9h2ebea77nibfv references raeicei.revinfo, revtype smallint, contact varchar(255), eik_number varchar(255), is_active boolean, name varchar(255), primary key (rev, id) ); create table raeicei.tariffs_aud ( id uuid not null, rev integer not null constraint fk5jarao91dpmdsml4dvdnywne4 references raeicei.revinfo, revtype smallint, currency varchar(255) constraint tariffs_aud_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision, revoke_application_price double precision, start_application_price double precision, start_date date, stop_application_price double precision, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.administrator_front_office_devices_aud ( rev integer not null constraint fk7xb7vhu9tffsosugmf6uwg62c references raeicei.revinfo, administrator_front_office_id uuid not null, devices_id uuid not null, revtype smallint, primary key (administrator_front_office_id, rev, devices_id) )] at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:123) at liquibase.command.core.AbstractUpdateCommandStep.lambda$run$0(AbstractUpdateCommandStep.java:102) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.command.core.AbstractUpdateCommandStep.run(AbstractUpdateCommandStep.java:99) at liquibase.command.CommandScope.execute(CommandScope.java:212) ... 30 common frames omitted Caused by: liquibase.exception.MigrationFailedException: Migration failed for changeset db/changelog/changes/v0001_db_init.sql::raw::includeAll: Reason: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 542 [Failed SQL: (0) create schema if not exists raeicei; create sequence raeicei.revinfo_seq increment by 50; create table raeicei.devices ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, description varchar(255), name varchar(255) not null, type varchar(255) not null ); create table raeicei.eid_administrator ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255), eik_number varchar(255) not null, is_active boolean, name varchar(255) not null ); create table raeicei.administrator_front_office ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255) not null, is_active boolean, location varchar(255) not null, name varchar(255) not null, region varchar(255) not null, eid_administrator_id uuid not null constraint fkaa7ai8y75cdlk4eit2m97vujj references raeicei.eid_administrator ); create table raeicei.device_tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, price double precision not null, start_date date not null, device_id uuid not null constraint uk_lkp5h2uqn905sff9f9xkdy6js unique constraint fkiat50ixx0swp53sr81adc4wcg references devices, eid_administrator_id uuid not null constraint fklnofaawx21hvodutubxfg2sg3 references raeicei.eid_administrator ); create table raeicei.discounts ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, age_from integer not null, age_until integer not null, disability boolean, discount double precision not null, start_date date not null, eid_administrator_id uuid not null constraint fkld0xlun3u81jfkiagrbtutag1 references raeicei.eid_administrator ); create table raeicei.tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, currency varchar(255) constraint tariffs_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision not null, revoke_application_price double precision not null, start_application_price double precision not null, start_date date not null, stop_application_price double precision not null, eid_administrator_id uuid not null constraint fkobrmkn30xfhtoek0v91icoybs references raeicei.eid_administrator ); create table raeicei.administrator_front_office_devices ( administrator_front_office_id uuid not null constraint fk2el8uygbiguylh28tuovtdswx references raeicei.administrator_front_office, devices_id uuid not null constraint uk_j5g08t98vllgff2p8fmqxoggs unique constraint fkw6j5gyfhb3kpi93a0vxra75a references raeicei.devices ); create table raeicei.revinfo ( rev integer not null primary key, revtstmp bigint ); create table raeicei.administrator_front_office_aud ( id uuid not null, rev integer not null constraint fkhc3vr2qvvsengi1m7f87ekoi references raeicei.revinfo, revtype smallint, contact varchar(255), is_active boolean, location varchar(255), name varchar(255), region varchar(255) constraint administrator_front_office_aud_region_check check ((region >= 0) AND (region <= 28)), eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.device_tariffs_aud ( id uuid not null, rev integer not null constraint fk3dc8gm082upwq6x2jxw6l1oy2 references raeicei.revinfo, revtype smallint, price double precision, start_date date, device_id uuid, eid_administrator_id uuid, primary key (rev, id) ); create table devices_aud ( id uuid not null, rev integer not null constraint fk334l0xy7gy0qjjfr5pe1wwxie references raeicei.revinfo, revtype smallint, description varchar(255), name varchar(255), type varchar(255), primary key (rev, id) ); create table raeicei.discounts_aud ( id uuid not null, rev integer not null constraint fkn2d7xmo6yoj2m4nso3eta8cdu references raeicei.revinfo, revtype smallint, age_from integer, age_until integer, disability boolean, discount double precision, start_date date, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.eid_administrator_aud ( id uuid not null, rev integer not null constraint fk8rh5kc77fqy9h2ebea77nibfv references raeicei.revinfo, revtype smallint, contact varchar(255), eik_number varchar(255), is_active boolean, name varchar(255), primary key (rev, id) ); create table raeicei.tariffs_aud ( id uuid not null, rev integer not null constraint fk5jarao91dpmdsml4dvdnywne4 references raeicei.revinfo, revtype smallint, currency varchar(255) constraint tariffs_aud_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision, revoke_application_price double precision, start_application_price double precision, start_date date, stop_application_price double precision, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.administrator_front_office_devices_aud ( rev integer not null constraint fk7xb7vhu9tffsosugmf6uwg62c references raeicei.revinfo, administrator_front_office_id uuid not null, devices_id uuid not null, revtype smallint, primary key (administrator_front_office_id, rev, devices_id) )] at liquibase.changelog.ChangeSet.execute(ChangeSet.java:761) at liquibase.changelog.visitor.UpdateVisitor.visit(UpdateVisitor.java:61) at liquibase.changelog.ChangeLogIterator$2.lambda$null$0(ChangeLogIterator.java:111) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.changelog.ChangeLogIterator$2.lambda$run$1(ChangeLogIterator.java:111) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Scope.child(Scope.java:260) at liquibase.changelog.ChangeLogIterator$2.run(ChangeLogIterator.java:94) at liquibase.Scope.lambda$child$0(Scope.java:194) at liquibase.Scope.child(Scope.java:203) at liquibase.Scope.child(Scope.java:193) at liquibase.Scope.child(Scope.java:172) at liquibase.Scope.child(Scope.java:260) at liquibase.Scope.child(Scope.java:264) at liquibase.changelog.ChangeLogIterator.run(ChangeLogIterator.java:68) ... 37 common frames omitted Caused by: liquibase.exception.DatabaseException: ERROR: operator does not exist: character varying >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 542 [Failed SQL: (0) create schema if not exists raeicei; create sequence raeicei.revinfo_seq increment by 50; create table raeicei.devices ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, description varchar(255), name varchar(255) not null, type varchar(255) not null ); create table raeicei.eid_administrator ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255), eik_number varchar(255) not null, is_active boolean, name varchar(255) not null ); create table raeicei.administrator_front_office ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, contact varchar(255) not null, is_active boolean, location varchar(255) not null, name varchar(255) not null, region varchar(255) not null, eid_administrator_id uuid not null constraint fkaa7ai8y75cdlk4eit2m97vujj references raeicei.eid_administrator ); create table raeicei.device_tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, price double precision not null, start_date date not null, device_id uuid not null constraint uk_lkp5h2uqn905sff9f9xkdy6js unique constraint fkiat50ixx0swp53sr81adc4wcg references devices, eid_administrator_id uuid not null constraint fklnofaawx21hvodutubxfg2sg3 references raeicei.eid_administrator ); create table raeicei.discounts ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, age_from integer not null, age_until integer not null, disability boolean, discount double precision not null, start_date date not null, eid_administrator_id uuid not null constraint fkld0xlun3u81jfkiagrbtutag1 references raeicei.eid_administrator ); create table raeicei.tariffs ( id uuid not null primary key, create_date timestamp(6), created_by varchar(255), last_update timestamp(6), updated_by varchar(255), version bigint, currency varchar(255) constraint tariffs_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision not null, revoke_application_price double precision not null, start_application_price double precision not null, start_date date not null, stop_application_price double precision not null, eid_administrator_id uuid not null constraint fkobrmkn30xfhtoek0v91icoybs references raeicei.eid_administrator ); create table raeicei.administrator_front_office_devices ( administrator_front_office_id uuid not null constraint fk2el8uygbiguylh28tuovtdswx references raeicei.administrator_front_office, devices_id uuid not null constraint uk_j5g08t98vllgff2p8fmqxoggs unique constraint fkw6j5gyfhb3kpi93a0vxra75a references raeicei.devices ); create table raeicei.revinfo ( rev integer not null primary key, revtstmp bigint ); create table raeicei.administrator_front_office_aud ( id uuid not null, rev integer not null constraint fkhc3vr2qvvsengi1m7f87ekoi references raeicei.revinfo, revtype smallint, contact varchar(255), is_active boolean, location varchar(255), name varchar(255), region varchar(255) constraint administrator_front_office_aud_region_check check ((region >= 0) AND (region <= 28)), eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.device_tariffs_aud ( id uuid not null, rev integer not null constraint fk3dc8gm082upwq6x2jxw6l1oy2 references raeicei.revinfo, revtype smallint, price double precision, start_date date, device_id uuid, eid_administrator_id uuid, primary key (rev, id) ); create table devices_aud ( id uuid not null, rev integer not null constraint fk334l0xy7gy0qjjfr5pe1wwxie references raeicei.revinfo, revtype smallint, description varchar(255), name varchar(255), type varchar(255), primary key (rev, id) ); create table raeicei.discounts_aud ( id uuid not null, rev integer not null constraint fkn2d7xmo6yoj2m4nso3eta8cdu references raeicei.revinfo, revtype smallint, age_from integer, age_until integer, disability boolean, discount double precision, start_date date, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.eid_administrator_aud ( id uuid not null, rev integer not null constraint fk8rh5kc77fqy9h2ebea77nibfv references raeicei.revinfo, revtype smallint, contact varchar(255), eik_number varchar(255), is_active boolean, name varchar(255), primary key (rev, id) ); create table raeicei.tariffs_aud ( id uuid not null, rev integer not null constraint fk5jarao91dpmdsml4dvdnywne4 references raeicei.revinfo, revtype smallint, currency varchar(255) constraint tariffs_aud_currency_check check ((currency)::text = ANY ((ARRAY ['BGN'::character varying, 'EUR'::character varying])::text[])), resume_application_price double precision, revoke_application_price double precision, start_application_price double precision, start_date date, stop_application_price double precision, eid_administrator_id uuid, primary key (rev, id) ); create table raeicei.administrator_front_office_devices_aud ( rev integer not null constraint fk7xb7vhu9tffsosugmf6uwg62c references raeicei.revinfo, administrator_front_office_id uuid not null, devices_id uuid not null, revtype smallint, primary key (administrator_front_office_id, rev, devices_id) )] at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:445) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:77) at liquibase.executor.jvm.JdbcExecutor.execute(JdbcExecutor.java:160) at liquibase.database.AbstractJdbcDatabase.execute(AbstractJdbcDatabase.java:1287) at liquibase.database.AbstractJdbcDatabase.executeStatements(AbstractJdbcDatabase.java:1269) at liquibase.changelog.ChangeSet.execute(ChangeSet.java:718) ... 57 common frames omitted Caused by: org.postgresql.util.PSQLException: ERROR: operator does not exist: character varying >= integer Hint: No operator matches the given name and argument types. You might need to add explicit type casts. Position: 542 at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:2713) at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:2401) at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:368) at org.postgresql.jdbc.PgStatement.executeInternal(PgStatement.java:498) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:415) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:335) at org.postgresql.jdbc.PgStatement.executeCachedSql(PgStatement.java:321) at org.postgresql.jdbc.PgStatement.executeWithFlags(PgStatement.java:297) at org.postgresql.jdbc.PgStatement.execute(PgStatement.java:292) at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:94) at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatement.java) at liquibase.executor.jvm.JdbcExecutor$ExecuteStatementCallback.doInStatement(JdbcExecutor.java:441) ... 62 common frames omitted Process finished with exit code 1
Editor is loading...
Leave a Comment