liquibase.exception.DatabaseException: ERROR: relation "appointment" already exists [Failed SQL: CREATE TABLE public.appointment (id BIGSERIAL NOT NULL, version BIGINT, customer_id BIGINT, duration BYTEA, note TEXT, personal_available BOOLEAN DEFAULT 0, personal_booked BOOLEAN DEFAULT 0, provider_id BIGINT, start_time BYTEA, url VARCHAR(255), CONSTRAINT "appointmentPK" PRIMARY KEY (id))]

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Stack Overflow by Michael.D
, 1 year ago
ERROR: relation "appointment" already exists [Failed SQL: CREATE TABLE public.appointment (id BIGSERIAL NOT NULL, version BIGINT, customer_id BIGINT, duration BYTEA, note TEXT, personal_available BOOLEAN DEFAULT 0, personal_booked BOOLEAN DEFAULT 0, provider_id BIGINT, start_time BYTEA, url VARCHAR(255), CONSTRAINT "appointmentPK" PRIMARY KEY (id))]
via Stack Overflow by Mohan
, 1 year ago
ORA-02270: no matching unique or primary key for this column-list [Failed SQL: ALTER TABLE USERS ADD CONSTRAINT FK_USERS FOREIGN KEY (ID) REFERENCES USER_ROLES (USER_ID)]
via GitHub by HemanthD
, 1 year ago
Cannot add foreign key constraint [Failed SQL: ALTER TABLE atlas.pa_option ADD CONSTRAINT fk_option_criteria_id FOREIGN KEY (criteria_id) REFERENCES atlas.criteria (id)]
via GitHub by adriens
, 1 year ago
ERROR: type "json" does not exist Position: 85 [Failed SQL: CREATE TABLE "public"."test_json" ("id" INT, "content" VARCHAR(100), "content_json" JSON)]
via GitHub by mbarre
, 1 year ago
ERROR: type "json" does not exist Position: 85 [Failed SQL: CREATE TABLE "public"."test_json" ("id" INT, "content" VARCHAR(100), "content_json" JSON)]
via GitHub by pascalgrimaud
, 1 year ago
Column "TEST_ENTITYS_ID" not found; SQL statement: ALTER TABLE PUBLIC.test_entity_user_many_to_many ADD CONSTRAINT fk_test_entity_user_many_to_many_user_id FOREIGN KEY (test_entitys_id) REFERENCES PUBLIC.test_entity (id) [42122-191] [Failed SQL
liquibase.exception.DatabaseException: ERROR: relation "appointment" already exists [Failed SQL: CREATE TABLE public.appointment (id BIGSERIAL NOT NULL, version BIGINT, customer_id BIGINT, duration BYTEA, note TEXT, personal_available BOOLEAN DEFAULT 0, personal_booked BOOLEAN DEFAULT 0, provider_id BIGINT, start_time BYTEA, url VARCHAR(255), CONSTRAINT "appointmentPK" PRIMARY KEY (id))]

Users with the same issue

13 times, 1 year ago

Know the solutions? Share your knowledge to help other developers to debug faster.