Some minor corrections and more checking for exceptions

check exceptions in more places to dont kill thread
add option for mqtt logging
better logging
indicate URL used on API errors (some exceptions does not indicate the URL, and previously the url was on DEBUG messages only)

Solves issue https://github.com/Dielee/volvo2mqtt/issues/265
Its running for some days without problems in my environment, and I have some different exceptions without stopping the updates

@Dielee  you have any suggestion of changes for this PR before accepting it for merge ?

I also got the same error this morning. Would be great to have this PR merged @Dielee !
Thanks @ivanfmartinez for the PR!


Dm924 typescript upgrade (back-end and front-end)

This PR closes issue: [DM-924] [DM-959]
Proposed changes:

Remove type safety bypass introduced in previous PRs
Upgrade TypeScript across project to latest stable (4.9.3)
Add type hints where necessary to satisfy type checker

failing on the build with:
src/back-end/lib/db/proposal/sprint-with-us.ts(1796,47): error TS2345: Argument of type 'string | undefined' is not assignable to parameter of type 'string'. Type 'undefined' is not assignable to type 'string'.

Apologies, I had forgot to apply an equivalent change to the proposal lib after changing the opportunity. It's fixed now.


Nested draggable children

Despite I've tried I'm not able to make it work with nested children. I've added :group prop but no luck so far.
So my question is: is this library able to handle nested children and can we swap children between parents?

Yes, that should be supported. You can see an example here: https://github.com/thelounge/thelounge/blob/master/client/components/NetworkList.vue#L56
If you provide an example or some code I can offer more help

Closing without any further information.

I need support for this feature.


Fix Geometry2d tests once Mapnik 2 figures out where it is going

See 3bcf6cd828ea635ba69711ed122e12910dc51648 and 9c91bdb0a3e21e36d37880e6b80910f9847eda2a

ya, for now even just commenting out all the geometry api would be fine. this is what I have done in node-mapnik, as this part of the api is in constant flux.


Cannot run kics in Windows Containers

Expected Behavior
kics should be able to run on Windows Containers
Actual Behavior
When trying to pull checkmarx/kics:latest with Windows Containers enabled, it gives the following error:
docker pull checkmarx/kics:latest
latest: Pulling from checkmarx/kics
image operating system "linux" cannot be used on this platform
A Windows, Linux and Macos images should be generated to DockerHub, not only the Linux one.
Steps to Reproduce the Problem

Enable Windows Containers in Docker for Windows
Run docker pull checkmarx/kics:latest
Error will be prompt

Specifications

Version: latest
Platform: Windows
Subsystem: Docker

Hi @miguelfreitas93
thanks for your feedback,
This behavior is excepted, because we currently only support linux image
I'm changing the label from bug to feature request

The need for this feature is being discussed in linked pull request POC thread.


Scikit learn instructions

Documenting here for now:
If you run into a situation where conda's solver isn't working, there is a path forward. For this example I am forcing an upgrade of matplotlib, which has been hard pinned to another version by the q2-types package recipe.
In this example "q2dev" is the development environment where I wish to install a version of these packages other than that as pinned.
wget https://raw.githubusercontent.com/qiime2/environment-files/master/latest/staging/qiime2-latest-py36-osx-conda.yml
conda env create -n q2dev --file qiime2-latest-py36-osx-conda.yml
rm qiime2-latest-py36-osx-conda.yml

conda create -n throwaway conda-forge::python==3.6 conda-forge::matplotlib==3.1.3 conda-forge::matplotlib-base==3.1.3
conda list -n throwaway --explicit | grep 'EXPLICIT\|matplotlib' > packages.txt
conda install -n q2dev --file packages.txt
conda env remove -n throwaway
rm packages.txt
conda list -n q2dev matplotlib

# packages in environment at /Users/matthew/.conda/envs/q2dev:
#
# Name                    Version                   Build  Channel
matplotlib                3.1.3                    py36_0    conda-forge
matplotlib-base           3.1.3            py36h11da6c2_0    conda-forge

The reason this works is because of the @EXPLICIT directive - conda install will deactivate the solver when either installing from a local file://, or from a list of urls with the @EXPLICIT directive (and the --file flag).


⭐ Add a template for project issue

Is your feature request related to a problem? Please describe.
There is no template for project issue
Describe the solution you'd like
Need one for consistent experience (not all task can be done in one small chunk, need to be divided)

There is one, got merge as part as another task


Unable to disable folding in diff view

Hey !
I'm currently using Octo and I want to know how someone can disable the folding in the review pane.
I've tried all the vim settings to disable all forms of folding but it seems that Octo is not taking them into account.
		foldmethod = "manual"
		foldlevelstart = 99
		foldenable = false

As I don't see any config options related to this folding I was wondering if there was a way to disable it.

You can use this autocommand:
vim.api.nvim_create_autocmd("BufEnter", {
  pattern = "octo://*",
  command = "if &diff | set nofoldenable | fi",
})

Related: #536


[IMPROVEMENT][UI] Attach table search keyword to URL on Backup pages

Is your improvement request related to a feature? Please describe (👍 if you like this request)

Currently, the search keyword is not reflected in the URL for tables on the Backup page, unlike other pages.
Describe the solution you'd like

The search keyword should append to the URL as a query parameter, allowing direct access to filtered results, e.g.

http://localhost:8080/#/backup#backing-image?field=name&value=qwe
http://localhost:8080/#/backup#volume?field=name&value=qwe

Describe alternatives you've considered

N/A
Additional context

N/A

@houhoucoop ready for testing?

The issue becomes invalid after multiple backup target backend PRs are merged.
Andy addressed it in PR #755, but the query parameters will be different.
e.g. ?field=name&value=pvc#volume becomes ?field=volumeName&value=pvc#volume.
I'm not sure how to proceed in this case, any suggestions? cc @a110605

Verified pass on longhorn master(https://github.com/longhorn/longhorn-ui/commit/ddfa9ddd99c407e0a8f97736438200d1486e1169) v1.8.x(https://github.com/longhorn/longhorn-ui/commit/ebcf89e35715f6daac43b6db8f32b71ae7a3c03a)
Search keyword appeared on Backup pages URL correctly.


Add aarch64 build and add myself as maintainer

Hi! This is the friendly automated conda-forge-linting service.
I just wanted to let you know that I linted all conda-recipes in your PR (recipe) and found it was in an excellent condition.


Added HTTP Server configuration examples

After deciding that a backend service wasn't needed for a project using app-router I sought out to find the Nginx method to support pushstate. Here are the configurations for Nginx/Apache

Good info, thanks!


[wiki] fixed sidebar and navigation

closes #241
closes #248
partial #242
opening, back/ff history, and manually refreshing a page with #HASH now also loads the same contents
downside is %20 and whatnot in the url's hash, will fix later
sidenote, why use upper case in the internal representation, if it always shows in lower case everywhere else?

Also regarding your questions about uppercase in the data structure and then lowercase in the display. I really don't know actually. That's a question for @neauoire.


create template for feature-issue

Create a basic template to submit feature and issue

@sanchis  Can I work on it?

Sure

Close with #17

The atuoamtic assignment of the labels does not work correctly. For bug type it should automatically assign bug type.
The same error occurs for feature.


Fix the plugin :3

Fix #2

Seems in order, thanks! I didn't get around to it.
Thanks a lot!


MySQL migration to PostgreSQL fails for v5.0.0 migration

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:

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

Expected behavior
The data migration executes without errors or warnings
System:

MARIADB_VERSION: 1:10.11.6+maria~ubu2204
PG_VERSION: 16.1-1.pgdg120+1
pgloader version: 3.6.7~devel
Previous UV version installed: 4.72.1

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 #<MYSQL-CONNECTION mysql://urlaubsverwaltung@urlaubsverwaltung-db-old:3306/urlaubsverwaltung {10083CDE03}>
2024-01-02T13:44:49.056000Z LOG Success, opened #<MYSQL-CONNECTION mysql://urlaubsverwaltung@urlaubsverwaltung-db-old:3306/urlaubsverwaltung {10083CDE03}>.
2024-01-02T13:44:49.056000Z LOG Running a simple query: SELECT 1;
2024-01-02T13:44:49.060000Z LOG Attempting to connect to #<PGSQL-CONNECTION pgsql://urlaubsverwaltung@urlaubsverwaltung-db:5432/urlaubsverwaltung {10083CF133}>
2024-01-02T13:44:49.084001Z LOG Success, opened #<PGSQL-CONNECTION pgsql://urlaubsverwaltung@urlaubsverwaltung-db:5432/urlaubsverwaltung {10083CF133}>.
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 #<MYSQL-CONNECTION mysql://urlaubsverwaltung@urlaubsverwaltung-db-old:3306/urlaubsverwaltung {10083E5E03}>
2024-01-02T14:02:52.204002Z LOG Migrating into #<PGSQL-CONNECTION pgsql://urlaubsverwaltung@urlaubsverwaltung-db:5432/urlaubsverwaltung {10083E7133}>
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\""

Danke für dein Feedback.
Mit der RC1 hat sich das Schema berändert und das ist im Migrationsscript noch nicht berücksichtigt

@derTobsch Danke für den Hinweis.
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).
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 #<MYSQL-CONNECTION mysql://urlaubsverwaltung@urlaubsverwaltung-db-old:3306/urlaubsverwaltung {10083CF3A3}>
2024-01-03T08:30:31.216001Z LOG Migrating into #<PGSQL-CONNECTION pgsql://urlaubsverwaltung@urlaubsverwaltung-db:5432/urlaubsverwaltung {10083D06D3}>
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, <email replaced>, null, null, <user id replaced>).
CONTEXT: COPY person, line 6: "12	<email replaced>	\N	\N	<user id replaced>"
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

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.

 Vermutlich wegen dem Fehler mit den NULL Values.

 Danach ist das pgloader Script erfolgreich durchgelaufen.

 Danach ist das pgloader Script erfolgreich durchgelaufen.

Hey @fstorz,
was gab es noch für invalide Daten on der Tabelle person?

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.

 Mit unserem DB-Dump hat alles funktioniert. Danke für dein Feedback.

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


[icu] Add support for macos rpath prefix macro

Describe the pull request

What does your PR fix?
This PR implements a temporary solution for https://unicode-org.atlassian.net/browse/ICU-21458. It alters the ID fields of the built dylibs to add support for the @rpath macro on macOS. The new code is commented that it should be removed and replaced with calls to new configure options, if ICU-21458 is resolved.

Which triplets are supported/not supported? Have you updated the CI baseline?
Only macOS is affected.

Does your PR follow the maintainer guide?
Yes

The macOS end-to-end tests are failing due to:
Failed to take the filesystem lock on /Volumes/data/work/1/s/.vcpkg-root:
    Resource busy

I don't believe this has anything to do with the changes in this PR, since this PR does not touch core vcpkg itself. Any ideas?

The macOS end-to-end tests are failing due to:
Failed to take the filesystem lock on /Volumes/data/work/1/s/.vcpkg-root:
    Resource busy

I don't believe this has anything to do with the changes in this PR, since this PR does not touch core vcpkg itself. Any ideas?

I'd like @strega-nil to review this PR also.

I'd like @strega-nil to review this PR also.

@adam-bloom This is unfortunately a change we cannot accept; changing the output depending on whether a tool is found is unacceptable for us. How common is install_name_tool? When does it exist on the system? We can discuss better solutions depending on that.

@adam-bloom This is unfortunately a change we cannot accept; changing the output depending on whether a tool is found is unacceptable for us. How common is install_name_tool? When does it exist on the system? We can discuss better solutions depending on that.

@adam-bloom This is unfortunately a change we cannot accept; changing the output depending on whether a tool is found is unacceptable for us. How common is install_name_tool? When does it exist on the system? We can discuss better solutions depending on that.

install_name_tool is in /usr/bin on macOS, which is a part of the write restricted system partition. I don't have access to older macOS installations, so I'm not sure when it was first included. The man page has a date of 2009 there - so likely 10.6 was the first inclusion. Additionally, Apple Developer Tools is listed as a vcpkg requirement in the readme, and another copy of  install_name_tool is included with Xcode command line tools: /Library/Developer/CommandLineTools/usr/bin/install_name_tool.
In other words, I think every macOS system running vcpkg should be compatible with this. If, however, someone attempted to build an osx triplet from another OS (I'm not sure if that would even work without the macOS SDK...), they might be missing this tool and the step would skip.
I'll note that I initially did not have the if present check, since I assumed all osx vcpkg triplet runs would be from macOS systems that have this tool. I added that at the request of @JackBoosY

@adam-bloom This is unfortunately a change we cannot accept; changing the output depending on whether a tool is found is unacceptable for us. How common is install_name_tool? When does it exist on the system? We can discuss better solutions depending on that.

install_name_tool is in /usr/bin on macOS, which is a part of the write restricted system partition. I don't have access to older macOS installations, so I'm not sure when it was first included. The man page has a date of 2009 there - so likely 10.6 was the first inclusion. Additionally, Apple Developer Tools is listed as a vcpkg requirement in the readme, and another copy of  install_name_tool is included with Xcode command line tools: /Library/Developer/CommandLineTools/usr/bin/install_name_tool.
In other words, I think every macOS system running vcpkg should be compatible with this. If, however, someone attempted to build an osx triplet from another OS (I'm not sure if that would even work without the macOS SDK...), they might be missing this tool and the step would skip.
I'll note that I initially did not have the if present check, since I assumed all osx vcpkg triplet runs would be from macOS systems that have this tool. I added that at the request of @JackBoosY

I agree with using find_program, but it should be REQUIRED, given what you're saying :)

I agree with using find_program, but it should be REQUIRED, given what you're saying :)

Is there a use case for vcpkg where a osx triplet is built on a non-macOS system? Or is this definitely safe to mark as required?

Is there a use case for vcpkg where a osx triplet is built on a non-macOS system? Or is this definitely safe to mark as required?

@strega-nil The judgment is if(VCPKG_TARGET_IS_OSX AND VCPKG_LIBRARY_LINKAGE STREQUAL "dynamic"), I think it's fine.
Do you have any other questions?
@adam-bloom  Nope.

@strega-nil The judgment is if(VCPKG_TARGET_IS_OSX AND VCPKG_LIBRARY_LINKAGE STREQUAL "dynamic"), I think it's fine.
Do you have any other questions?
@adam-bloom  Nope.

yeah, the issue I have is making it non-REQUIRED; since we'll always be building on macOS, we should REQUIRED the program.

yeah, the issue I have is making it non-REQUIRED; since we'll always be building on macOS, we should REQUIRED the program.

So I think it's good now.

So I think it's good now.

Already merged from master.

Already merged from master.


Zoom Oauth not redirecting to mobile app.

Hi Guys,
I am unable to redirect to the app after zoom authentication please anyone help me. I tried with the FlutterWebAuth plugin but not getting success.
Thanks in advance.

Issues with third-party packages need to be reported to their developers. There should be a link on the package's pub.dev page.

Hi ,
Can you please suggest how can we do zoom authentication in flutter app.
Thanks in advance.


AC and Perception not showing in pf2e system version 4.12.x

I found this bug myself today - probably just need to debug their specific values, and add support for that custom thing.

Fixed in v1.3.0

Note that the module's latest update requires a pf2e system update (I hope Foundry automatically ensures that it happens).


[enhance]: test cases for CRS v3.1

 Thank you for your submission, we really appreciate it. Like many open source projects, we ask that you sign our Contributor License Agreement before we can accept your contribution.:x: 4v3r9 sign nowYou have signed the CLA already but the status is still pending? Let us recheck it.


Redundant workspace dependencies

In the root Cargo.toml there are a number of workspace-wide dependencies that are only used by one-or-two subprojects. For example, cfg-if is only used by the playground, clap is only used by the library and CLI.
Is there a technical need for this, or is it just accumulated cruft?
(I don't think this really matters -- I assume unused dependencies will be compiled away -- hence P4.)

The reason for this is to collect all dependency version numbers in one place. So if another project decides to use cfg-if, it will refer to the version number in the root Cargo.toml.

It's not that they are removed during compilation as some kind of optimization, they are never even considered. When building, only the dependencies listed in the individual package's Cargo.toml are considered. If they happen to be workspace dependencies, that version is used. They do not automatically include all workspace dependencies.

Makes sense... One further question: What about features? The reason I made this is issue is because I noticed the features for Clap in topiary-cli diverged from those in the root. Should the same rule apply: features should be specified in the root Cargo.toml, leaving the leaf Cargo.toml files to just inherit this? Or is this just for the sake of pinning versions?

That's only for versions. Indeed our different crates can require different features from a package, and so those should be defined (IMO) by the individual crates.


New API for test data

Hi was wondering if I can add the "this for that" API as it is a great way for first time API consumers.
Here's the link (it returns 2 types of response formats (Text [an English sentence], and Json with two key values[this for that])
http://itsthisforthat.com/api.php

Hi @munzzz5 😄
Yes, you can add this API to the list ;)
Open a PR and send it with this addition and I will review it

Great!
This is my first issue in life. Am I supposed to just fill up the table with relevant links or shall I post the python code example?
I have read the docs. But I'm still unsure.
Thank you!

@munzzz5 You just need to put the link and other API information on a new line in the table, following the pattern of those already listed.
Example:
For this link https://itsthisforthat.com/api.phpz, you should add something similar to this in the table in the Test Data section:
| [ItsThisForThat](https://itsthisforthat.com/api.php) | <A description> | No | Yes | Unknown |

hey there
i have another API called bored API which is essentiallly similar and fits into the same category of test data.
Kindly check it out and let me know if i should go for PR.
Thanks!
http://www.boredapi.com/

hey there
i have another API called bored API which is essentiallly similar and fits into the same category of test data.
Kindly check it out and let me know if i should go for PR.
Thanks! http://www.boredapi.com/

This API is already listed here. See in Development section.


Export the type DDTransportOptions

Hi @theogravity
Can you pls export the type DDTransportOptions from the package as currently nothing is exported from the package.

Hi @theogravity
Can you pls export the type DDTransportOptions from the package as currently nothing is exported from the package.

Feel free to open a PR.

I checked the current code and found that the type can be imported as follows:
import { DDTransportOptions } from 'pino-datadog-transport/build/process-logs';


Upgrade to Swift 3

Thanks! I actually have a significantly improved version on the way, but I'm intending to write an updated blog post to go with it, so this is both a good stopgap and a reminder that I need to get round to it.


Use ESP8266 only?

I'm getting some questions if it is possible to only use an ESP8266-based board without the Arduino.
The thing is that this is what I was aiming for when starting this project. Unfortunately, I could not get SPI communication working with the MHI. The reason is technical and mostly beyond my skills. Running an ESP8266 as a SPI slave (MHI is master) is very poorly documented and some code that I found was impossible for me to get working for this particular scenario.
Some of the things that I ran into:

The MHI does not use a slave select line and the ESP8266 SPI library does
The MHI's clock is high when idle. The ESP8266 appears to only work with clock low when idle.
Cryptic documentation on the ESP's SPI hardware

I still think it's possible but it would cost me too much time to figure out.
In contrast, I had the Arduino working as a SPI slave in no time and the programmatic implementation was delightfully simple compared to the ESP8266.
If anyone knows how to do this, I will be happy to provide you with more detailed information on the SPI protocol.
Cheers, Rob

Hey Rob, awesome job figuring out the protocol for the heavies! I wrote the arduino library for the non_heavy units, based on Hadley's python code. Maybe one day we can do a merge of the two librarys, where a user can choose via #define which protocol to use. But first it would need to work on stand alone ESP.
Since the MHI doesn't use SPI SS, why not just pull it low at all times on ESP. The ESP will be the only slave and that is probably why they didn't add SS pin. Second, you say CLK is low when idle, it is possible that you need to pull it up to 5V with a 10k resistor, since that is what I had to do with my TX/RX lines for bone stock esp01. It seems that Mitsu pins are floating when they are not in use. Good luck and let me know if this helped.

Hi SwiCago,
Great to hear from you and thank you so much for your input. It was actually your work and Hadley’s that inspired me to get something similar going for the MHIs! It works in the current form but it is still far from a mature library that can run on a single ESP.
Your suggestions are a good starting point for further investigation. Unfortunately, I relocated to another city a while ago and left my beloved heavies including the arduinos to the new owner of my old home. I have therefore no access to a unit for testing purposes. My interest will surely return if and when I will install heavies in my new home. Hopefully somebody else can pick this up in the meantime....
Best,
Rob

Hi Rob,
I am looking to do an ESP8266 only variant. Can you provide more detail on the SPI protocol if possible please ?
I'm struggling to completly follow the outline High-level protocol you have on the repo home page.

FYI all there is another project now active using only ESP8266 hardware without the arduino requirement https://github.com/absalom-muc/MHI-AC-Ctrl


docs: quickstart revamp to highlight author consumer divide

Description:
This PR revamps our quickstart to more explicitly highlight the two users Kurtosis serves: environment definition authors and environment definition consumers. Among the changes, I've decided to use eth2-package for the consumer quickstart and use the postgres example for the author quickstart. I've also added sections explaining why we care about the author-consumer divide and to highlight some of the benefits/value Kurtosis brings to both these user personas.
I intend for this PR to be an iteration 0 and welcome any feedback.
Is this change user facing?
YES
References (if applicable):

@leeederek just handled the merge conflicts from my sidebar rewrite, now it looks like the attached image.
the "quickstart consumer" is the default link for quickstart throughout the docs in any quickstart link


Make BottomSheetStyle work like iOS Maps application

I would like to be able to pull up the view by a handle and have it snap in place to a partial and full view like the iOS Maps application.  Including making the view scrollup to the max height when you swipe up from anywhere and then having the tableview start scrolling once you have reached the max height.

One potential way to achieve this is:

set opacity of background view of STPopupController to 0 by default;
handle touch move event of "handle" view; adjust the height of content size of view controller and opacity of background view of STPopupController.

I haven't tried this personally, not sure if it will work as expected.

Thanks Kevin.  Is there a way to makes these changes without modifying the STPopUpViewController itself?  To add the draggable handle and necessary events to swiping up on the subclassed tableview drags the view up until it reaches max height and then the tableview scrolls.
and override or bypass the nav bars touchDidEndWithOffset which handles the drag up /down behavior of the view controller
-(void)popupNavigationBar:(STPopupNavigationBar *)navigationBar touchDidEndWithOffset:(CGFloat)offset
{
if (offset > 150) {
STPopupTransitionStyle transitionStyle = self.transitionStyle;
self.transitionStyle = STPopupTransitionStyleSlideVertical;
[self dismissWithCompletion:^{
self.transitionStyle = transitionStyle;
}];
}
else {
[_containerView endEditing:YES];
[UIView animateWithDuration:0.4 delay:0 usingSpringWithDamping:0.7 initialSpringVelocity:0 options:UIViewAnimationOptionCurveEaseInOut animations:^{
_containerView.transform = CGAffineTransformIdentity;
} completion:nil];
}
}

@kevin0571  I have the same business requirement.


Grid consumption and Return to grid for energy dashbord missing

Only Inverter Daily Generation can be selected in the dashboard confiration page.
Grid consumption and Return to grid are not listed in dashboard configuration.
Smart_meter is set to true

Sungrow SG10RT with WiNet-S_001_247
Do I need to configue something in addition to see the missing statitsics?

I am trying to work this out (I have a SG08RS) but I am an Infrastructure guy first, coding second.
From what I understand, it is because those sensors don't have a state or device class so it needs to be defined in the configuration.yaml. Any suggestions would be appreciated but if I work it out, I will post it here.

@BigChaps Did you ever figure it out?


kind-shell command should grep for sales

The two shell commands kind-shell and gcp-shell filter for two different keys. The correct version should grep for sales and not app.

Yea I changed this and missed it. I haven’t tried  GCP in a while but this is a good fix, thanks.


Decouple post_migrate signal from refreshing the views

Problem
Currently the post_migrate signal triggers automatic sync_pgviews() in the AppConfig.ready()
See here
def ready(self):
        """
        Find and setup the apps to set the post_migrate hooks for.
        """
        signals.post_migrate.connect(self.sync_pgviews)

While this is fine for most use-cases, this becomes an issue as the number and size of the pgviews grow. At that point it slows down deploys and if a refresh timesout it fails a deploy.  For some teams/orgs making the refresh async is an OK tradeoff. Thus we'd want this coupling to be optional.
Solution
Make the current behaviour the default, but add an environment variable or django settings config to override and decouple this. i.e. optionally decide to not connect sync_pgviews to post_migrate signal.

If this makes sense i can send a PR.

Yep definitely that makes sense - as long as current default remains default. If you submit a PR I'll happily merge and release

@mikicz Thanks for the quick reply. Will send a PR.

Submitted a PR to resolve this: https://github.com/xelixdev/django-pgviews-redux/pull/77


Getting "Initializer does not override a designated initializer from its superclass" error

In a fresh install of SevenSwift 2.0 I'm getting an error here in SevenSwitch.swift:
override public init() {
super.init(frame: CGRectMake(0, 0, 50, 30))
    self.setup()
}

I saw some people saying change "override public" to "convenience" then "super" to "self" and doing that removes the errors but when I write the test documentation:
let mySwitch = SevenSwitch()
I still get "Use of unresolved identifier 'SevenSwitch'"
Any ideas on why this isn't working?

convenience init() {
        self.init(frame: CGRectMake(0, 0, 50, 30))

        self.setup()
    }

Fixed the issue

Will be updating to work with swift 2.0 shortly