search

urlaubsverwaltung / urlaubsverwaltung

Schluss mit Papierchaos und langweiliger Software. Wir zeigen dir, dass Urlaubsverwaltung auch Spaß machen kann.
https://urlaubsverwaltung.cloud
Apache License 2.0
262 stars 82 forks source link

MySQL migration to PostgreSQL fails for v5.0.0 migration #4464

Closed fstorz closed 10 months ago

fstorz commented 10 months ago

Describe the bug When executing the pgloader script provided in the wiki, the execution fails with the following error pgloader failed to find column "public"."settings"."calendar_ews_email" in target table "\"public\".\"settings\"". In addition there are a log of warnings in the pgloader execution logs.

To Reproduce Steps to reproduce the behavior:

  1. setup PostgreSQL and run (docker container)
  2. run UV in version 5.0.0 with new postgres to let spring create the db schema
  3. prepare pgloader script (replace parameters with correct values)
  4. execute pgloader dry-run successfully
  5. execute pgloader migration -> see error

Expected behavior The data migration executes without errors or warnings

System:

Additional context

pgloader dry-run log ``` # pgloader --dry-run /app/pgloader.conf 2024-01-02T13:44:49.008000Z LOG pgloader version "3.6.7~devel" 2024-01-02T13:44:49.032000Z LOG DRY RUN, only checking connections. 2024-01-02T13:44:49.032000Z LOG Attempting to connect to # 2024-01-02T13:44:49.056000Z LOG Success, opened #. 2024-01-02T13:44:49.056000Z LOG Running a simple query: SELECT 1; 2024-01-02T13:44:49.060000Z LOG Attempting to connect to # 2024-01-02T13:44:49.084001Z LOG Success, opened #. 2024-01-02T13:44:49.084001Z LOG Running a simple query: SELECT 1; 2024-01-02T13:44:49.088001Z LOG report summary reset table name errors rows bytes total time ----------------- --------- --------- --------- -------------- ----------------- --------- --------- --------- -------------- ```
Full pgloader execution log ``` # pgloader /app/pgloader.conf 2024-01-02T14:02:52.008000Z LOG pgloader version "3.6.7~devel" 2024-01-02T14:02:52.204002Z LOG Migrating from # 2024-01-02T14:02:52.204002Z LOG Migrating into # 2024-01-02T14:02:52.532004Z WARNING Source column "public"."absence_mapping"."absence_mapping_type" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."absence_mapping"."absence_mapping_type". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."absence_mapping"."event_id" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."absence_mapping"."event_id". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."account"."comment" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."account"."comment". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."address" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."address". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."day_length" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."day_length". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."reason" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."reason". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."status" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."status". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."hours" is casted to type "decimal" which is not the same as "double precision", the type of current target database column "public"."application"."hours". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."start_time" is casted to type "time" which is not the same as "time without time zone", the type of current target database column "public"."application"."start_time". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application"."end_time" is casted to type "time" which is not the same as "time without time zone", the type of current target database column "public"."application"."end_time". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application_comment"."date" is casted to type "date" which is not the same as "timestamp with time zone", the type of current target database column "public"."application_comment"."date". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application_comment"."text" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application_comment"."text". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."application_comment"."action" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application_comment"."action". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."calendar_accessible"."dtype" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."calendar_accessible"."dtype". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."company_calendar"."calendar_period" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."company_calendar"."calendar_period". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."department"."name" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."department"."name". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."department"."description" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."department"."description". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."department_calendar"."calendar_period" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."department_calendar"."calendar_period". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."holiday_replacements"."note" is casted to type "bytea" which is not the same as "text", the type of current target database column "public"."holiday_replacements"."note". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."overtime"."duration" is casted to type "decimal" which is not the same as "double precision", the type of current target database column "public"."overtime"."duration". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."overtime_comment"."date" is casted to type "date" which is not the same as "timestamp with time zone", the type of current target database column "public"."overtime_comment"."date". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."overtime_comment"."action" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."overtime_comment"."action". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."overtime_comment"."text" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."overtime_comment"."text". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person"."email" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."email". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person"."first_name" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."first_name". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person"."last_name" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."last_name". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person"."username" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."username". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person_basedata"."personnel_number" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_basedata"."personnel_number". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person_basedata"."additional_information" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_basedata"."additional_information". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person_calendar"."calendar_period" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_calendar"."calendar_period". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person_notifications"."notifications" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_notifications"."notifications". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."person_permissions"."permissions" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_permissions"."permissions". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."maximum_annual_vacation_days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_annual_vacation_days". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."maximum_months_to_apply_for_leave_in_advance" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_months_to_apply_for_leave_in_advance". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."maximum_sick_pay_days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_sick_pay_days". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."days_before_end_of_sick_pay_notification" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."days_before_end_of_sick_pay_notification". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."working_duration_for_new_years_eve" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."working_duration_for_new_years_eve". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."working_duration_for_christmas_eve" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."working_duration_for_christmas_eve". 2024-01-02T14:02:52.532004Z WARNING Source column "public"."settings"."federal_state" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."federal_state". KABOOM! SIMPLE-ERROR: pgloader failed to find column "public"."settings"."calendar_ews_email" in target table "\"public\".\"settings\"" An unhandled error condition has been signalled: pgloader failed to find column "public"."settings"."calendar_ews_email" in target table "\"public\".\"settings\"" ```
derTobsch commented 10 months ago

Danke für dein Feedback. Ich schau mir das an. Ich denke du könntest auf die M6 gehen und dann die Migration durchführen und danach die UV auf 5.0.0 ziehen.

Mit der RC1 hat sich das Schema verändert und das ist im Migrationsscript noch nicht berücksichtigt

fstorz commented 10 months ago

@derTobsch Danke für den Hinweis. Habe gerade die Migration auf Basis des M6 Datenbank Schemas getestet. Dabei sind auch wieder Fehler aufgetreten, zwar andere, aber ich weiß noch nicht, ob die Daten korrekt und vollständig übernommen wurden.

Fehler Nr. 1

2024-01-03T08:30:31.632004Z ERROR Database error 23502: null value in column "first_name" of relation "person" violates not-null constraint
DETAIL: Failing row contains (12, <email replaced>, null, null, <user id replaced>).
CONTEXT: COPY person, line 6: "12   <email replaced>    \N  \N  <user id replaced>"

Fehler Nr. 2. Der violates foreign key constraint kommt mehrfach vor (16x) mit verschiedenen Tabellen bzw. Constraints. FYI, wir haben bei uns ein paar "gelöschte" Personen (via UI gelöscht) und ein paar "inaktive" Personen.

ERROR PostgreSQL Database error 23503: insert or update on table "application" violates foreign key constraint "fk6rpjm6c93ei39h2kswv215egf"
DETAIL: Key (boss_id)=(1) is not present in table "person".
QUERY: ALTER TABLE "public"."application" ADD CONSTRAINT "fk6rpjm6c93ei39h2kswv215egf" FOREIGN KEY (boss_id) REFERENCES person(id)
Full Log ``` # pgloader --verbose /app/pgloader.conf 2024-01-03T08:30:31.004000Z NOTICE Starting pgloader, log system is ready. 2024-01-03T08:30:31.012000Z LOG pgloader version "3.6.7~devel" 2024-01-03T08:30:31.064000Z NOTICE Executing SQL block for before load 2024-01-03T08:30:31.216001Z LOG Migrating from # 2024-01-03T08:30:31.216001Z LOG Migrating into # 2024-01-03T08:30:31.468002Z NOTICE Prepare PostgreSQL database. 2024-01-03T08:30:31.524003Z WARNING Source column "public"."absence_mapping"."absence_mapping_type" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."absence_mapping"."absence_mapping_type". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."absence_mapping"."event_id" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."absence_mapping"."event_id". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."account"."comment" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."account"."comment". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."address" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."address". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."day_length" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."day_length". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."reason" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."reason". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."status" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application"."status". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."hours" is casted to type "decimal" which is not the same as "double precision", the type of current target database column "public"."application"."hours". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."start_time" is casted to type "time" which is not the same as "time without time zone", the type of current target database column "public"."application"."start_time". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application"."end_time" is casted to type "time" which is not the same as "time without time zone", the type of current target database column "public"."application"."end_time". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application_comment"."date" is casted to type "date" which is not the same as "timestamp with time zone", the type of current target database column "public"."application_comment"."date". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application_comment"."text" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application_comment"."text". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."application_comment"."action" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."application_comment"."action". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."calendar_accessible"."dtype" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."calendar_accessible"."dtype". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."company_calendar"."calendar_period" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."company_calendar"."calendar_period". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."department"."name" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."department"."name". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."department"."description" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."department"."description". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."department_calendar"."calendar_period" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."department_calendar"."calendar_period". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."holiday_replacements"."note" is casted to type "bytea" which is not the same as "text", the type of current target database column "public"."holiday_replacements"."note". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."overtime"."duration" is casted to type "decimal" which is not the same as "double precision", the type of current target database column "public"."overtime"."duration". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."overtime_comment"."date" is casted to type "date" which is not the same as "timestamp with time zone", the type of current target database column "public"."overtime_comment"."date". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."overtime_comment"."action" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."overtime_comment"."action". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."overtime_comment"."text" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."overtime_comment"."text". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person"."email" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."email". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person"."first_name" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."first_name". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person"."last_name" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."last_name". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person"."username" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person"."username". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person_basedata"."personnel_number" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_basedata"."personnel_number". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person_basedata"."additional_information" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_basedata"."additional_information". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person_calendar"."calendar_period" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_calendar"."calendar_period". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person_notifications"."notifications" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_notifications"."notifications". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."person_permissions"."permissions" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."person_permissions"."permissions". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."maximum_annual_vacation_days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_annual_vacation_days". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."maximum_months_to_apply_for_leave_in_advance" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_months_to_apply_for_leave_in_advance". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."maximum_sick_pay_days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_sick_pay_days". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."days_before_end_of_sick_pay_notification" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."days_before_end_of_sick_pay_notification". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."working_duration_for_new_years_eve" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."working_duration_for_new_years_eve". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."working_duration_for_christmas_eve" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."working_duration_for_christmas_eve". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."federal_state" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."federal_state". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_ews_email" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_ews_email". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_ews_password" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_ews_password". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_ews_calendar" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_ews_calendar". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."overtime_maximum" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."overtime_maximum". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."overtime_minimum" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."overtime_minimum". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."days_before_remind_for_waiting_applications" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."days_before_remind_for_waiting_applications". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_google_client_id" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_google_client_id". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_google_client_secret" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_google_client_secret". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_google_calendar_id" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_google_calendar_id". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_google_refresh_token" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_google_refresh_token". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_provider" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_provider". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_ews_url" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_ews_url". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."calendar_ews_timezoneid" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."calendar_ews_timezoneid". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."timezoneid" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."timezoneid". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."work_day_begin_hour" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."work_day_begin_hour". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."work_day_end_hour" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."work_day_end_hour". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."default_vacation_days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."default_vacation_days". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."monday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."monday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."tuesday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."tuesday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."wednesday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."wednesday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."thursday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."thursday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."friday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."friday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."saturday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."saturday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."sunday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."settings"."sunday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."days_before_remind_for_upcoming_applications" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."days_before_remind_for_upcoming_applications". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."overtime_minimum_reduction" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."overtime_minimum_reduction". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."days_before_remind_for_upcoming_holiday_replacement" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."days_before_remind_for_upcoming_holiday_replacement". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."settings"."maximum_months_to_apply_for_leave_afterwards" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."settings"."maximum_months_to_apply_for_leave_afterwards". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note"."day_length" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."sick_note"."day_length". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note"."status" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."sick_note"."status". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note_comment"."date" is casted to type "date" which is not the same as "timestamp with time zone", the type of current target database column "public"."sick_note_comment"."date". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note_comment"."action" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."sick_note_comment"."action". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note_comment"."text" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."sick_note_comment"."text". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note_type"."category" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."sick_note_type"."category". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."sick_note_type"."message_key" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."sick_note_type"."message_key". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."special_leave_settings"."message_key" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."special_leave_settings"."message_key". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."special_leave_settings"."days" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."special_leave_settings"."days". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."user_pagination_settings"."default_page_size" is casted to type "bigint" which is not the same as "integer", the type of current target database column "public"."user_pagination_settings"."default_page_size". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."user_settings"."theme" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."user_settings"."theme". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."user_settings"."locale" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."user_settings"."locale". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."user_settings"."locale_browser_specific" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."user_settings"."locale_browser_specific". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."vacation_type"."category" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."vacation_type"."category". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."vacation_type"."message_key" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."vacation_type"."message_key". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."vacation_type"."color" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."vacation_type"."color". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."friday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."friday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."monday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."monday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."saturday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."saturday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."sunday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."sunday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."thursday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."thursday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."tuesday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."tuesday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."wednesday" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."wednesday". 2024-01-03T08:30:31.524003Z WARNING Source column "public"."working_time"."federal_state_override" is casted to type "varchar" which is not the same as "text", the type of current target database column "public"."working_time"."federal_state_override". 2024-01-03T08:30:31.524003Z NOTICE ALTER TABLE "public"."account" DROP CONSTRAINT IF EXISTS "fkd9dhia7smrg88vcbiykhofxee" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk2wfgtv8frhctm80uutmj1wktq" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk6rpjm6c93ei39h2kswv215egf" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk8beb5qvi7h8b4s9vsk7byjnpm" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk9xn27lvr2087ar3lbsvr8vfh5" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fkn5crvlcxc4thbenl7ivvtbklq" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application_comment" DROP CONSTRAINT IF EXISTS "fkil1cps8t7x98nek0b63wx7flt" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."holiday_replacements" DROP CONSTRAINT IF EXISTS "fkpf8m8p5ec0f3rl2wp62xcldse" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application_comment" DROP CONSTRAINT IF EXISTS "fkil1cps8t7x98nek0b63wx7flt" CASCADE; 2024-01-03T08:30:31.528003Z WARNING PostgreSQL warning: constraint "fkil1cps8t7x98nek0b63wx7flt" of relation "application_comment" does not exist, skipping 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."application_comment" DROP CONSTRAINT IF EXISTS "fktje5lde6lfr2wkabxtbog7q9o" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."company_calendar" DROP CONSTRAINT IF EXISTS "fkrna4e8hk3gbcbf95l8fj06fp6" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."department_department_head" DROP CONSTRAINT IF EXISTS "fk4fahbxvgo8vedh6jwpatj3yqp" CASCADE; 2024-01-03T08:30:31.528003Z NOTICE ALTER TABLE "public"."department_second_stage_authority" DROP CONSTRAINT IF EXISTS "fk6e2nv4snpg7bdsat1ihck3iy7" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_member" DROP CONSTRAINT IF EXISTS "fk845yiwgn0jjh36jmc3om5bo1m" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_calendar" DROP CONSTRAINT IF EXISTS "fkg1vrncgfl6a25osr648sr4ias" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_calendar" DROP CONSTRAINT IF EXISTS "fkg1vrncgfl6a25osr648sr4inc" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_calendar" DROP CONSTRAINT IF EXISTS "fkg1vrncgfl6a25osr648sr4ias" CASCADE; 2024-01-03T08:30:31.532003Z WARNING PostgreSQL warning: constraint "fkg1vrncgfl6a25osr648sr4ias" of relation "department_calendar" does not exist, skipping 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_department_head" DROP CONSTRAINT IF EXISTS "fk42v6njqbbf2q7djmmfnxu3wkx" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_department_head" DROP CONSTRAINT IF EXISTS "fk4fahbxvgo8vedh6jwpatj3yqp" CASCADE; 2024-01-03T08:30:31.532003Z WARNING PostgreSQL warning: constraint "fk4fahbxvgo8vedh6jwpatj3yqp" of relation "department_department_head" does not exist, skipping 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_second_stage_authority" DROP CONSTRAINT IF EXISTS "fk6e2nv4snpg7bdsat1ihck3iy7" CASCADE; 2024-01-03T08:30:31.532003Z WARNING PostgreSQL warning: constraint "fk6e2nv4snpg7bdsat1ihck3iy7" of relation "department_second_stage_authority" does not exist, skipping 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_second_stage_authority" DROP CONSTRAINT IF EXISTS "fkop68p8y3i6sdkogonexfxjfc9" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."holiday_replacements" DROP CONSTRAINT IF EXISTS "fkhj1etgfxf8ja1yks2igyta8b0" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."holiday_replacements" DROP CONSTRAINT IF EXISTS "fkpf8m8p5ec0f3rl2wp62xcldse" CASCADE; 2024-01-03T08:30:31.532003Z WARNING PostgreSQL warning: constraint "fkpf8m8p5ec0f3rl2wp62xcldse" of relation "holiday_replacements" does not exist, skipping 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."overtime" DROP CONSTRAINT IF EXISTS "fkr3apeyjt5a6hh5btt2ras6r7m" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."overtime_comment" DROP CONSTRAINT IF EXISTS "fkofgobbi68ure8t3rerclergyq" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."overtime_comment" DROP CONSTRAINT IF EXISTS "fka69rnisl69l0fyowh7kjamu" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."overtime_comment" DROP CONSTRAINT IF EXISTS "fkofgobbi68ure8t3rerclergyq" CASCADE; 2024-01-03T08:30:31.532003Z WARNING PostgreSQL warning: constraint "fkofgobbi68ure8t3rerclergyq" of relation "overtime_comment" does not exist, skipping 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."sick_note" DROP CONSTRAINT IF EXISTS "fk134nni6nwa976n1debfh6aeyc" CASCADE; 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."department_department_head" DROP CONSTRAINT IF EXISTS "fk42v6njqbbf2q7djmmfnxu3wkx" CASCADE; 2024-01-03T08:30:31.532003Z WARNING PostgreSQL warning: constraint "fk42v6njqbbf2q7djmmfnxu3wkx" of relation "department_department_head" does not exist, skipping 2024-01-03T08:30:31.532003Z NOTICE ALTER TABLE "public"."person_notifications" DROP CONSTRAINT IF EXISTS "fk667b972v099ct2ip5af248tqd" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk6rpjm6c93ei39h2kswv215egf" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fk6rpjm6c93ei39h2kswv215egf" of relation "application" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk8beb5qvi7h8b4s9vsk7byjnpm" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fk8beb5qvi7h8b4s9vsk7byjnpm" of relation "application" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."sick_note" DROP CONSTRAINT IF EXISTS "fk99jlbvv98cnnmu4aai3j3sm9g" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk9xn27lvr2087ar3lbsvr8vfh5" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fk9xn27lvr2087ar3lbsvr8vfh5" of relation "application" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."overtime_comment" DROP CONSTRAINT IF EXISTS "fka69rnisl69l0fyowh7kjamu" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fka69rnisl69l0fyowh7kjamu" of relation "overtime_comment" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."sick_note_comment" DROP CONSTRAINT IF EXISTS "fkca8k3tbf9by0slanlps1gdrug" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."account" DROP CONSTRAINT IF EXISTS "fkd9dhia7smrg88vcbiykhofxee" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkd9dhia7smrg88vcbiykhofxee" of relation "account" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."department_calendar" DROP CONSTRAINT IF EXISTS "fkg1vrncgfl6a25osr648sr4inc" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkg1vrncgfl6a25osr648sr4inc" of relation "department_calendar" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."holiday_replacements" DROP CONSTRAINT IF EXISTS "fkhj1etgfxf8ja1yks2igyta8b0" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkhj1etgfxf8ja1yks2igyta8b0" of relation "holiday_replacements" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."working_time" DROP CONSTRAINT IF EXISTS "fkjrowf2nwuoflpyph0d495y5ae" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."person_calendar" DROP CONSTRAINT IF EXISTS "fkkft9x29wo89tjvxd116sc0hs6" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fkn5crvlcxc4thbenl7ivvtbklq" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkn5crvlcxc4thbenl7ivvtbklq" of relation "application" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."department_second_stage_authority" DROP CONSTRAINT IF EXISTS "fkop68p8y3i6sdkogonexfxjfc9" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkop68p8y3i6sdkogonexfxjfc9" of relation "department_second_stage_authority" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."department_member" DROP CONSTRAINT IF EXISTS "fkp5jgcynel1bq3g61uc23lt383" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."overtime" DROP CONSTRAINT IF EXISTS "fkr3apeyjt5a6hh5btt2ras6r7m" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkr3apeyjt5a6hh5btt2ras6r7m" of relation "overtime" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."company_calendar" DROP CONSTRAINT IF EXISTS "fkrna4e8hk3gbcbf95l8fj06fp6" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fkrna4e8hk3gbcbf95l8fj06fp6" of relation "company_calendar" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."person_permissions" DROP CONSTRAINT IF EXISTS "fktggoyu7sfqifef59ksbk2r4mr" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."application_comment" DROP CONSTRAINT IF EXISTS "fktje5lde6lfr2wkabxtbog7q9o" CASCADE; 2024-01-03T08:30:31.536003Z WARNING PostgreSQL warning: constraint "fktje5lde6lfr2wkabxtbog7q9o" of relation "application_comment" does not exist, skipping 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."person_basedata" DROP CONSTRAINT IF EXISTS "fkg1vrdsd7sgd7s7s7dgsiaawon" CASCADE; 2024-01-03T08:30:31.536003Z NOTICE ALTER TABLE "public"."user_settings" DROP CONSTRAINT IF EXISTS "fk7687azhshs87687qwertzhbsd" CASCADE; 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."user_pagination_settings" DROP CONSTRAINT IF EXISTS "fk_user_pagination_settings_person_id" CASCADE; 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."user_notification_settings" DROP CONSTRAINT IF EXISTS "fk_notification_person" CASCADE; 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."person_basedata" DROP CONSTRAINT IF EXISTS "fkg1vrdsd7sgd7s7s7dgsiaawon" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fkg1vrdsd7sgd7s7s7dgsiaawon" of relation "person_basedata" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."person_calendar" DROP CONSTRAINT IF EXISTS "fkkft9x29wo89tjvxd116sc0hs6" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fkkft9x29wo89tjvxd116sc0hs6" of relation "person_calendar" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."person_notifications" DROP CONSTRAINT IF EXISTS "fk667b972v099ct2ip5af248tqd" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk667b972v099ct2ip5af248tqd" of relation "person_notifications" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."person_permissions" DROP CONSTRAINT IF EXISTS "fktggoyu7sfqifef59ksbk2r4mr" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fktggoyu7sfqifef59ksbk2r4mr" of relation "person_permissions" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note" DROP CONSTRAINT IF EXISTS "fk134nni6nwa976n1debfh6aeyc" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk134nni6nwa976n1debfh6aeyc" of relation "sick_note" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note" DROP CONSTRAINT IF EXISTS "fk8w53gdjuaa48qfypfxon1ygmu" CASCADE; 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note" DROP CONSTRAINT IF EXISTS "fk99jlbvv98cnnmu4aai3j3sm9g" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk99jlbvv98cnnmu4aai3j3sm9g" of relation "sick_note" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note_comment" DROP CONSTRAINT IF EXISTS "fkg1jrdsd7sgd3ag47gghswegza" CASCADE; 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note_comment" DROP CONSTRAINT IF EXISTS "fkca8k3tbf9by0slanlps1gdrug" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fkca8k3tbf9by0slanlps1gdrug" of relation "sick_note_comment" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note_comment" DROP CONSTRAINT IF EXISTS "fkg1jrdsd7sgd3ag47gghswegza" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fkg1jrdsd7sgd3ag47gghswegza" of relation "sick_note_comment" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."sick_note" DROP CONSTRAINT IF EXISTS "fk8w53gdjuaa48qfypfxon1ygmu" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk8w53gdjuaa48qfypfxon1ygmu" of relation "sick_note" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."user_notification_settings" DROP CONSTRAINT IF EXISTS "fk_notification_person" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk_notification_person" of relation "user_notification_settings" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."user_pagination_settings" DROP CONSTRAINT IF EXISTS "fk_user_pagination_settings_person_id" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk_user_pagination_settings_person_id" of relation "user_pagination_settings" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."user_settings" DROP CONSTRAINT IF EXISTS "fk7687azhshs87687qwertzhbsd" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk7687azhshs87687qwertzhbsd" of relation "user_settings" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."application" DROP CONSTRAINT IF EXISTS "fk2wfgtv8frhctm80uutmj1wktq" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fk2wfgtv8frhctm80uutmj1wktq" of relation "application" does not exist, skipping 2024-01-03T08:30:31.540003Z NOTICE ALTER TABLE "public"."working_time" DROP CONSTRAINT IF EXISTS "fkjrowf2nwuoflpyph0d495y5ae" CASCADE; 2024-01-03T08:30:31.540003Z WARNING PostgreSQL warning: constraint "fkjrowf2nwuoflpyph0d495y5ae" of relation "working_time" does not exist, skipping 2024-01-03T08:30:31.544003Z NOTICE Processing tables in this order: public.application: 152 rows, public.person_notifications: 63 rows, public.account: 28 rows, public.sick_note: 21 rows, public.vacation_type: 15 rows, public.sick_note_comment: 12 rows, public.person_permissions: 10 rows, public.working_time: 8 rows, public.holiday_replacements: 6 rows, public.person: 6 rows, public.person_basedata: 6 rows, public.user_settings: 6 rows, public.department: 2 rows, public.sick_note_type: 2 rows, public.special_leave_settings: 2 rows, public.company_calendar: 1 rows, public.settings: 1 rows, public.absence_mapping: 0 rows, public.calendar_accessible: 0 rows, public.department_calendar: 0 rows, public.department_department_head: 0 rows, public.department_second_stage_authority: 0 rows, public.overtime: 0 rows, public.overtime_comment: 0 rows, public.person_calendar: 0 rows, public.user_notification_settings: 0 rows, public.user_pagination_settings: 0 rows, public.department_member: 0 rows 2024-01-03T08:30:31.548003Z NOTICE COPY public.application_comment with 319 rows estimated [3/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.application with 152 rows estimated [1/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.person_notifications with 63 rows estimated [3/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.sick_note with 21 rows estimated [3/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.account with 28 rows estimated [1/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.sick_note_comment with 12 rows estimated [3/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.vacation_type with 15 rows estimated [1/4] 2024-01-03T08:30:31.564003Z NOTICE COPY public.working_time with 8 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.person_permissions with 10 rows estimated [1/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.person with 6 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.holiday_replacements with 6 rows estimated [1/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.user_settings with 6 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.person_basedata with 6 rows estimated [1/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.sick_note_type with 2 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.department with 2 rows estimated [1/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.company_calendar with 1 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.special_leave_settings with 2 rows estimated [1/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.absence_mapping with 0 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.settings with 1 rows estimated [1/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.department_calendar with 0 rows estimated [3/4] 2024-01-03T08:30:31.568003Z NOTICE COPY public.department_second_stage_authority with 0 rows estimated [3/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.calendar_accessible with 0 rows estimated [1/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.overtime_comment with 0 rows estimated [3/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.department_department_head with 0 rows estimated [1/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.user_notification_settings with 0 rows estimated [3/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.overtime with 0 rows estimated [1/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.department_member with 0 rows estimated [3/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.person_calendar with 0 rows estimated [1/4] 2024-01-03T08:30:31.572003Z NOTICE COPY public.user_pagination_settings with 0 rows estimated [1/4] 2024-01-03T08:30:31.632004Z ERROR Database error 23502: null value in column "first_name" of relation "person" violates not-null constraint DETAIL: Failing row contains (12, , null, null, ). CONTEXT: COPY person, line 6: "12 \N \N " 2024-01-03T08:30:31.764004Z NOTICE Completing PostgreSQL database. 2024-01-03T08:30:31.764004Z NOTICE Reset sequences 2024-01-03T08:30:31.800004Z NOTICE ALTER TABLE "public"."account" ADD CONSTRAINT "fkd9dhia7smrg88vcbiykhofxee" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.800004Z ERROR PostgreSQL Database error 23503: insert or update on table "account" violates foreign key constraint "fkd9dhia7smrg88vcbiykhofxee" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."account" ADD CONSTRAINT "fkd9dhia7smrg88vcbiykhofxee" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.800004Z NOTICE ALTER TABLE "public"."application" ADD CONSTRAINT "fk2wfgtv8frhctm80uutmj1wktq" FOREIGN KEY (vacation_type_id) REFERENCES vacation_type(id) 2024-01-03T08:30:31.800004Z NOTICE ALTER TABLE "public"."application" ADD CONSTRAINT "fk6rpjm6c93ei39h2kswv215egf" FOREIGN KEY (boss_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "application" violates foreign key constraint "fk6rpjm6c93ei39h2kswv215egf" DETAIL: Key (boss_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."application" ADD CONSTRAINT "fk6rpjm6c93ei39h2kswv215egf" FOREIGN KEY (boss_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."application" ADD CONSTRAINT "fk8beb5qvi7h8b4s9vsk7byjnpm" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "application" violates foreign key constraint "fk8beb5qvi7h8b4s9vsk7byjnpm" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."application" ADD CONSTRAINT "fk8beb5qvi7h8b4s9vsk7byjnpm" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."application" ADD CONSTRAINT "fk9xn27lvr2087ar3lbsvr8vfh5" FOREIGN KEY (canceller_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "application" violates foreign key constraint "fk9xn27lvr2087ar3lbsvr8vfh5" DETAIL: Key (canceller_id)=(2) is not present in table "person". QUERY: ALTER TABLE "public"."application" ADD CONSTRAINT "fk9xn27lvr2087ar3lbsvr8vfh5" FOREIGN KEY (canceller_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."application" ADD CONSTRAINT "fkn5crvlcxc4thbenl7ivvtbklq" FOREIGN KEY (applier_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "application" violates foreign key constraint "fkn5crvlcxc4thbenl7ivvtbklq" DETAIL: Key (applier_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."application" ADD CONSTRAINT "fkn5crvlcxc4thbenl7ivvtbklq" FOREIGN KEY (applier_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."application_comment" ADD CONSTRAINT "fkil1cps8t7x98nek0b63wx7flt" FOREIGN KEY (application_id) REFERENCES application(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."application_comment" ADD CONSTRAINT "fktje5lde6lfr2wkabxtbog7q9o" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "application_comment" violates foreign key constraint "fktje5lde6lfr2wkabxtbog7q9o" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."application_comment" ADD CONSTRAINT "fktje5lde6lfr2wkabxtbog7q9o" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."company_calendar" ADD CONSTRAINT "fkrna4e8hk3gbcbf95l8fj06fp6" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "company_calendar" violates foreign key constraint "fkrna4e8hk3gbcbf95l8fj06fp6" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."company_calendar" ADD CONSTRAINT "fkrna4e8hk3gbcbf95l8fj06fp6" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."department_calendar" ADD CONSTRAINT "fkg1vrncgfl6a25osr648sr4inc" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."department_calendar" ADD CONSTRAINT "fkg1vrncgfl6a25osr648sr4ias" FOREIGN KEY (department_id) REFERENCES department(id) ON DELETE CASCADE 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."department_department_head" ADD CONSTRAINT "fk42v6njqbbf2q7djmmfnxu3wkx" FOREIGN KEY (department_heads_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."department_department_head" ADD CONSTRAINT "fk4fahbxvgo8vedh6jwpatj3yqp" FOREIGN KEY (department_id) REFERENCES department(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."department_second_stage_authority" ADD CONSTRAINT "fk6e2nv4snpg7bdsat1ihck3iy7" FOREIGN KEY (department_id) REFERENCES department(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."department_second_stage_authority" ADD CONSTRAINT "fkop68p8y3i6sdkogonexfxjfc9" FOREIGN KEY (second_stage_authorities_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."holiday_replacements" ADD CONSTRAINT "fkhj1etgfxf8ja1yks2igyta8b0" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z ERROR PostgreSQL Database error 23503: insert or update on table "holiday_replacements" violates foreign key constraint "fkhj1etgfxf8ja1yks2igyta8b0" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."holiday_replacements" ADD CONSTRAINT "fkhj1etgfxf8ja1yks2igyta8b0" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.804004Z NOTICE ALTER TABLE "public"."holiday_replacements" ADD CONSTRAINT "fkpf8m8p5ec0f3rl2wp62xcldse" FOREIGN KEY (application_id) REFERENCES application(id) 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."overtime" ADD CONSTRAINT "fkr3apeyjt5a6hh5btt2ras6r7m" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."overtime_comment" ADD CONSTRAINT "fka69rnisl69l0fyowh7kjamu" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."overtime_comment" ADD CONSTRAINT "fkofgobbi68ure8t3rerclergyq" FOREIGN KEY (overtime_id) REFERENCES overtime(id) 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."person_basedata" ADD CONSTRAINT "fkg1vrdsd7sgd7s7s7dgsiaawon" FOREIGN KEY (person_id) REFERENCES person(id) ON DELETE CASCADE 2024-01-03T08:30:31.808004Z ERROR PostgreSQL Database error 23503: insert or update on table "person_basedata" violates foreign key constraint "fkg1vrdsd7sgd7s7s7dgsiaawon" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."person_basedata" ADD CONSTRAINT "fkg1vrdsd7sgd7s7s7dgsiaawon" FOREIGN KEY (person_id) REFERENCES person(id) ON DELETE CASCADE 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."person_calendar" ADD CONSTRAINT "fkkft9x29wo89tjvxd116sc0hs6" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."person_notifications" ADD CONSTRAINT "fk667b972v099ct2ip5af248tqd" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.808004Z ERROR PostgreSQL Database error 23503: insert or update on table "person_notifications" violates foreign key constraint "fk667b972v099ct2ip5af248tqd" DETAIL: Key (person_id)=(2) is not present in table "person". QUERY: ALTER TABLE "public"."person_notifications" ADD CONSTRAINT "fk667b972v099ct2ip5af248tqd" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.808004Z NOTICE ALTER TABLE "public"."person_permissions" ADD CONSTRAINT "fktggoyu7sfqifef59ksbk2r4mr" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z ERROR PostgreSQL Database error 23503: insert or update on table "person_permissions" violates foreign key constraint "fktggoyu7sfqifef59ksbk2r4mr" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."person_permissions" ADD CONSTRAINT "fktggoyu7sfqifef59ksbk2r4mr" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z NOTICE ALTER TABLE "public"."sick_note" ADD CONSTRAINT "fk134nni6nwa976n1debfh6aeyc" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z ERROR PostgreSQL Database error 23503: insert or update on table "sick_note" violates foreign key constraint "fk134nni6nwa976n1debfh6aeyc" DETAIL: Key (person_id)=(2) is not present in table "person". QUERY: ALTER TABLE "public"."sick_note" ADD CONSTRAINT "fk134nni6nwa976n1debfh6aeyc" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z NOTICE ALTER TABLE "public"."sick_note" ADD CONSTRAINT "fk8w53gdjuaa48qfypfxon1ygmu" FOREIGN KEY (sick_note_type_id) REFERENCES sick_note_type(id) 2024-01-03T08:30:31.812004Z NOTICE ALTER TABLE "public"."sick_note" ADD CONSTRAINT "fk99jlbvv98cnnmu4aai3j3sm9g" FOREIGN KEY (applier_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z ERROR PostgreSQL Database error 23503: insert or update on table "sick_note" violates foreign key constraint "fk99jlbvv98cnnmu4aai3j3sm9g" DETAIL: Key (applier_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."sick_note" ADD CONSTRAINT "fk99jlbvv98cnnmu4aai3j3sm9g" FOREIGN KEY (applier_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z NOTICE ALTER TABLE "public"."sick_note_comment" ADD CONSTRAINT "fkca8k3tbf9by0slanlps1gdrug" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z ERROR PostgreSQL Database error 23503: insert or update on table "sick_note_comment" violates foreign key constraint "fkca8k3tbf9by0slanlps1gdrug" DETAIL: Key (person_id)=(2) is not present in table "person". QUERY: ALTER TABLE "public"."sick_note_comment" ADD CONSTRAINT "fkca8k3tbf9by0slanlps1gdrug" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.812004Z NOTICE ALTER TABLE "public"."sick_note_comment" ADD CONSTRAINT "fkg1jrdsd7sgd3ag47gghswegza" FOREIGN KEY (sick_note_id) REFERENCES sick_note(id) ON DELETE CASCADE 2024-01-03T08:30:31.812004Z NOTICE ALTER TABLE "public"."user_notification_settings" ADD CONSTRAINT "fk_notification_person" FOREIGN KEY (person_id) REFERENCES person(id) ON DELETE CASCADE 2024-01-03T08:30:31.816004Z NOTICE ALTER TABLE "public"."user_pagination_settings" ADD CONSTRAINT "fk_user_pagination_settings_person_id" FOREIGN KEY (person_id) REFERENCES person(id) ON DELETE CASCADE 2024-01-03T08:30:31.816004Z NOTICE ALTER TABLE "public"."user_settings" ADD CONSTRAINT "fk7687azhshs87687qwertzhbsd" FOREIGN KEY (person_id) REFERENCES person(id) ON DELETE CASCADE 2024-01-03T08:30:31.816004Z ERROR PostgreSQL Database error 23503: insert or update on table "user_settings" violates foreign key constraint "fk7687azhshs87687qwertzhbsd" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."user_settings" ADD CONSTRAINT "fk7687azhshs87687qwertzhbsd" FOREIGN KEY (person_id) REFERENCES person(id) ON DELETE CASCADE 2024-01-03T08:30:31.816004Z NOTICE ALTER TABLE "public"."working_time" ADD CONSTRAINT "fkjrowf2nwuoflpyph0d495y5ae" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.816004Z ERROR PostgreSQL Database error 23503: insert or update on table "working_time" violates foreign key constraint "fkjrowf2nwuoflpyph0d495y5ae" DETAIL: Key (person_id)=(1) is not present in table "person". QUERY: ALTER TABLE "public"."working_time" ADD CONSTRAINT "fkjrowf2nwuoflpyph0d495y5ae" FOREIGN KEY (person_id) REFERENCES person(id) 2024-01-03T08:30:31.828004Z NOTICE Executing SQL block for after load 2024-01-03T08:30:31.892004Z LOG report summary reset table name errors read imported bytes total time read write ---------------------------------------- --------- --------- --------- --------- -------------- --------- --------- before load 0 4 4 0.132s fetch meta data 0 55 55 0.088s Drop Foreign Keys 0 68 68 0.016s ---------------------------------------- --------- --------- --------- --------- -------------- --------- --------- public.application_comment 0 318 318 9.4 kB 0.032s 0.016s 0.004s public.application 0 152 152 15.6 kB 0.032s 0.016s 0.004s public.person_notifications 0 63 63 3.0 kB 0.032s public.sick_note 0 10 10 0.7 kB 0.040s public.account 0 28 28 2.0 kB 0.028s public.sick_note_comment 0 12 12 0.3 kB 0.056s public.vacation_type 0 15 15 1.0 kB 0.044s 0.004s public.working_time 0 8 8 0.4 kB 0.060s 0.004s public.person_permissions 0 9 9 0.1 kB 0.052s public.person 1 6 0 0.064s public.holiday_replacements 0 6 6 0.0 kB 0.064s public.user_settings 0 5 5 0.1 kB 0.084s public.person_basedata 0 5 5 0.0 kB 0.064s public.sick_note_type 0 2 2 0.1 kB 0.092s public.department 0 2 2 0.1 kB 0.088s public.company_calendar 0 1 1 0.0 kB 0.108s public.special_leave_settings 0 6 6 0.3 kB 0.092s public.absence_mapping 0 0 0 0.112s public.settings 0 1 1 0.3 kB 0.112s 0.004s public.department_calendar 0 0 0 0.140s public.department_second_stage_authority 0 0 0 0.144s 0.004s public.calendar_accessible 0 1 1 0.0 kB 0.108s public.overtime_comment 0 0 0 0.160s public.department_department_head 0 0 0 0.140s public.user_notification_settings 0 0 0 0.156s public.overtime 0 0 0 0.140s public.department_member 0 5 5 0.1 kB 0.176s public.person_calendar 0 0 0 0.156s public.user_pagination_settings 0 0 0 0.164s ---------------------------------------- --------- --------- --------- --------- -------------- --------- --------- COPY Threads Completion 0 4 4 0.184s Reset Sequences 0 0 0 0.016s Create Foreign Keys 16 33 17 0.016s Install Comments 0 0 0 0.000s after load 0 17 17 0.060s ---------------------------------------- --------- --------- --------- --------- -------------- --------- --------- Total import time 1 655 649 33.5 kB 0.276s ```
fstorz commented 10 months ago

Zur Info: Beim erneuten Ausführen des pgloader scripts, wurde ein Fehler ausgegeben, dass die View department_member_view bereits existiert. D.h. diese muss zuerst manuell in MySQL gelöscht werden.

fstorz commented 10 months ago

In Postgres ist die Tabelle person leer. Vermutlich wegen dem Fehler mit den NULL Values. Daher vermutlich auch die Fehler mit den Constraints.

fstorz commented 10 months ago

Habe die invaliden Daten aus der Tabelle person und allen darauf referenzierenden Tabellen gelöscht. Danach ist das pgloader Script erfolgreich durchgelaufen.

derTobsch commented 10 months ago

Habe die invaliden Daten aus der Tabelle person und allen darauf referenzierenden Tabellen gelöscht. Danach ist das pgloader Script erfolgreich durchgelaufen.

Hey @fstorz, was gab es noch für invalide Daten on der Tabelle person? Hattet ihr ggf schon einmal Personen gelöscht bevor es die Möglichkeit gab sie über die UI zu löschen?

fstorz commented 10 months ago

Ich bin mir da nicht ganz sicher, was passiert war. Folgender Eintrag war in der Tabelle person enthalten

MariaDB [urlaubsverwaltung]> select * from person;
+----+-------------------------------------+------------+-----------+---------------------------------------------+
| id | email                               | first_name | last_name | username                                    |
+----+-------------------------------------+------------+-----------+---------------------------------------------+
...
| 12 | <email>                             | NULL       | NULL      | <user-id>                                   |
...
+----+-------------------------------------+------------+-----------+---------------------------------------------+

Auch referenzierende Werte in den Tabellen account, person_permissions (hier mit INACTIVE) usw. waren vorhanden. Allerdings wurde der Nutzer nicht in der UV angezeigt. Da der User für uns fachlich sowiso invalid war, habe ich die Daten manuell in den jeweiligen Tabellen gelöscht.

derTobsch commented 10 months ago

Ich habe das Script und die Beschreibung unter https://github.com/urlaubsverwaltung/urlaubsverwaltung/wiki/Urlaubsverwaltung-5.0-Migration-Guide-To-PostgreSQL angepasst. Mit unserem DB-Dump hat alles funktioniert. Danke für dein Feedback.

@fstorz falls du das neue Script nochmal prüfen möchtest, würde ich mich über Feedback freuen.

fstorz commented 10 months ago

Das neue Skript hat bei uns jetzt ohne Fehler direkt mit der Version 5.0.0 funktioniert :thumbsup: