github-starred/vikunja
2
0
Fork 0
mirror of https://github.com/go-vikunja/vikunja.git synced 2026-07-17 07:12:34 -05:00
Code Issues 690 Packages Projects Releases 11 Wiki Activity

Latest upgrade v0.24.1 docker doesn't create missing columns in postgres #255

New Issue
Closed
opened 2025-11-01 20:52:06 -05:00 by GiteaMirror · 16 comments
GiteaMirror commented 2025-11-01 20:52:06 -05:00
Owner
Copy Link

Originally created by @yewkay on GitHub (Jul 24, 2024).

Description

I'm running Vikunja on docker with external postgres DB also in docker.
I upgraded from v0.24.0 to v0.24.1
After upgrading I get migration error
Migration failed: migration 20240315093418 failed: pq: column "project_view_id" does not exist

Dug around and added that column into projects table. that error went away and new errors of similar column not found came out sequentially.

[Empty openid Team Cleanup Cron] Error removing empty openid team: pq: column "oidc_id" does not exist
adding that came
[Empty openid Team Cleanup Cron] Error removing empty openid team: pq: column "issuer" does not exist
added the above 2 into the teams table cleared all the errors.

Maybe the migration scripts can add in an additional line that if it doesn't exists, create it?
Just putting it out there in case anyone facing the same issue and needs help.

Vikunja Version

0.24.1

Browser and version

No response

Can you reproduce the bug on the Vikunja demo site?

No

Screenshots

No response

Originally created by @yewkay on GitHub (Jul 24, 2024). ### Description I'm running Vikunja on docker with external postgres DB also in docker. I upgraded from v0.24.0 to v0.24.1 After upgrading I get migration error `Migration failed: migration 20240315093418 failed: pq: column "project_view_id" does not exist` Dug around and added that column into projects table. that error went away and new errors of similar column not found came out sequentially. `[Empty openid Team Cleanup Cron] Error removing empty openid team: pq: column "oidc_id" does not exist` adding that came `[Empty openid Team Cleanup Cron] Error removing empty openid team: pq: column "issuer" does not exist` added the above 2 into the teams table cleared all the errors. Maybe the migration scripts can add in an additional line that if it doesn't exists, create it? Just putting it out there in case anyone facing the same issue and needs help. ### Vikunja Version 0.24.1 ### Browser and version _No response_ ### Can you reproduce the bug on the Vikunja demo site? No ### Screenshots _No response_
GiteaMirror commented 2025-11-01 20:52:07 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Jul 29, 2024):

I have exactly the same errors as you, Can you give me the commands you used to add the columns ? Thx
I'm also using a Postgresql database, Maybe that's the problem !

But I'm on version 0.23.0 compared to you and the migration doesn't work to a higher version

@SeiyaGame commented on GitHub (Jul 29, 2024): I have exactly the same errors as you, Can you give me the commands you used to add the columns ? Thx I'm also using a Postgresql database, Maybe that's the problem ! But I'm on version 0.23.0 compared to you and the migration doesn't work to a higher version
GiteaMirror commented 2025-11-01 20:52:07 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Jul 29, 2024):

I ran these SQL commands, but I'm not sure what I did :

ALTER TABLE buckets ADD project_view_id bigint not null default 0;

ALTER TABLE teams ADD oidc_id varchar(250) null;
ALTER TABLE teams ADD issuer text null;
ALTER TABLE teams ADD is_public bool not null default false;

Edit: Removing unnecessary SQL commands

@SeiyaGame commented on GitHub (Jul 29, 2024): I ran these SQL commands, but I'm not sure what I did : ```sql ALTER TABLE buckets ADD project_view_id bigint not null default 0; ALTER TABLE teams ADD oidc_id varchar(250) null; ALTER TABLE teams ADD issuer text null; ALTER TABLE teams ADD is_public bool not null default false; ``` Edit: Removing unnecessary SQL commands
GiteaMirror commented 2025-11-01 20:52:07 -05:00
Author
Owner
Copy Link

@yewkay commented on GitHub (Jul 31, 2024):

Disclaimer: I'm no postgres guru, you need to enter your postgres docker

docker exec -it <postgres_container_name> psql -U <postgres_user> -d <database_name>
project view id is in buckets i think not in project.

ALTER TABLE vikunja.buckets ADD COLUMN project_view_id BIGINT NOT NULL DEFAULT 0;
so i think all your SQL commands should work.

By and large i think i added all the commands you did.

@yewkay commented on GitHub (Jul 31, 2024): Disclaimer: I'm no postgres guru, you need to enter your postgres docker `docker exec -it <postgres_container_name> psql -U <postgres_user> -d <database_name>` project view id is in buckets i think not in project. `ALTER TABLE vikunja.buckets ADD COLUMN project_view_id BIGINT NOT NULL DEFAULT 0;` so i think all your SQL commands should work. By and large i think i added all the commands you did.
GiteaMirror commented 2025-11-01 20:52:07 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Jul 31, 2024):

Thanks, that's exactly what I did!

@SeiyaGame commented on GitHub (Jul 31, 2024): Thanks, that's exactly what I did!
GiteaMirror commented 2025-11-01 20:52:08 -05:00
Author
Owner
Copy Link

@yewkay commented on GitHub (Aug 1, 2024):

I think it's worth of a bug ticket. but yeah, for anyone else facing the same problem. @SeiyaGame has all the postgres commands listed.

@yewkay commented on GitHub (Aug 1, 2024): I think it's worth of a bug ticket. but yeah, for anyone else facing the same problem. @SeiyaGame has all the postgres commands listed.
GiteaMirror commented 2025-11-01 20:52:08 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Aug 7, 2024):

Maybe the migration scripts can add in an additional line that if it doesn't exists, create it?

The migrations will create all missing columns and tables.

Can you share the contents of the migration table?

Maybe similar to https://kolaente.dev/vikunja/vikunja/issues/2545

@kolaente commented on GitHub (Aug 7, 2024): > Maybe the migration scripts can add in an additional line that if it doesn't exists, create it? The migrations will create all missing columns and tables. Can you share the contents of the `migration` table? Maybe similar to https://kolaente.dev/vikunja/vikunja/issues/2545
GiteaMirror commented 2025-11-01 20:52:08 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Aug 8, 2024):

You're lucky I have a backup of my BDD
I was able to reproduce the bug, I remained in version 23 and I tried to migrate to the latest version and I still have the problem.

2024-08-08T17:14:50.516668966Z: INFO    ▶ config/InitConfig 001 No config file found, using default or config from environment variables.
2024-08-08T17:14:50.516756447Z: INFO    ▶ migration/Migrate 002 Running migrations…
2024-08-08T17:14:50.569120046Z: CRITICAL        ▶ migration/Migrate 069 Migration failed: migration 20240315093418 failed: pq: column "project_view_id" does not exist
Migration table content : 
select * from migration;
       id       | description
----------------+-------------
 SCHEMA_INIT    |
 20190324205606 |
 20190328074430 |
 20190430111111 |
 20190511202210 |
 20190514192749 |
 20190524205441 |
 20190718200716 |
 20190818210133 |
 20190920185205 |
 20190922205826 |
 20191008194238 |
 20191010131430 |
 20191207204427 |
 20191207220736 |
 20200120201756 |
 20200219183248 |
 20200308205855 |
 20200308210130 |
 20200322214440 |
 20200322214624 |
 20200417175201 |
 20200418230432 |
 20200418230605 |
 20200420215928 |
 20200425182634 |
 20200509103709 |
 20200515172220 |
 20200515195546 |
 20200516123847 |
 20200524221534 |
 20200524224611 |
 20200614113230 |
 20200621214452 |
 20200801183357 |
 20200904101559 |
 20200905151040 |
 20200905232458 |
 20200906184746 |
 20201025195822 |
 20201121181647 |
 20201218152741 |
 20201218220204 |
 20201219145028 |
 20210207192805 |
 20210209204715 |
 20210220222121 |
 20210221111953 |
 20210321185225 |
 20210328191017 |
 20210403145503 |
 20210403220653 |
 20210407170753 |
 20210411113105 |
 20210411161337 |
 20210413131057 |
 20210527105701 |
 20210603174608 |
 20210709191101 |
 20210709211508 |
 20210711173657 |
 20210713213622 |
 20210725153703 |
 20210727204942 |
 20210727211037 |
 20210729142940 |
 20210802081716 |
 20210829194722 |
 20211212151642 |
 20211212210054 |
 20220112211537 |
 20220616145228 |
 20220815200851 |
 20221002120521 |
 20221113170740 |
 20221228112131 |
 20230307171848 |
 20230611170341 |
 20230824132533 |
 20230828125443 |
 20230831155832 |
 20230903143017 |
 20230913202615 |
 20231022144641 |
 20231108231513 |
 20240114224713 |
 20230104152903 |
 20231121191822 |
 20240304153738 |
 20240309111148 |
 20240311173251 |
 20240313230538 |
 20240314214802 |

Let me know if you need more information !
I hope this helps

@SeiyaGame commented on GitHub (Aug 8, 2024): You're lucky I have a backup of my BDD I was able to reproduce the bug, I remained in version 23 and I tried to migrate to the latest version and I still have the problem. ``` 2024-08-08T17:14:50.516668966Z: INFO ▶ config/InitConfig 001 No config file found, using default or config from environment variables. 2024-08-08T17:14:50.516756447Z: INFO ▶ migration/Migrate 002 Running migrations… 2024-08-08T17:14:50.569120046Z: CRITICAL ▶ migration/Migrate 069 Migration failed: migration 20240315093418 failed: pq: column "project_view_id" does not exist ``` <details> <summary>Migration table content :</summary> ``` select * from migration; id | description ----------------+------------- SCHEMA_INIT | 20190324205606 | 20190328074430 | 20190430111111 | 20190511202210 | 20190514192749 | 20190524205441 | 20190718200716 | 20190818210133 | 20190920185205 | 20190922205826 | 20191008194238 | 20191010131430 | 20191207204427 | 20191207220736 | 20200120201756 | 20200219183248 | 20200308205855 | 20200308210130 | 20200322214440 | 20200322214624 | 20200417175201 | 20200418230432 | 20200418230605 | 20200420215928 | 20200425182634 | 20200509103709 | 20200515172220 | 20200515195546 | 20200516123847 | 20200524221534 | 20200524224611 | 20200614113230 | 20200621214452 | 20200801183357 | 20200904101559 | 20200905151040 | 20200905232458 | 20200906184746 | 20201025195822 | 20201121181647 | 20201218152741 | 20201218220204 | 20201219145028 | 20210207192805 | 20210209204715 | 20210220222121 | 20210221111953 | 20210321185225 | 20210328191017 | 20210403145503 | 20210403220653 | 20210407170753 | 20210411113105 | 20210411161337 | 20210413131057 | 20210527105701 | 20210603174608 | 20210709191101 | 20210709211508 | 20210711173657 | 20210713213622 | 20210725153703 | 20210727204942 | 20210727211037 | 20210729142940 | 20210802081716 | 20210829194722 | 20211212151642 | 20211212210054 | 20220112211537 | 20220616145228 | 20220815200851 | 20221002120521 | 20221113170740 | 20221228112131 | 20230307171848 | 20230611170341 | 20230824132533 | 20230828125443 | 20230831155832 | 20230903143017 | 20230913202615 | 20231022144641 | 20231108231513 | 20240114224713 | 20230104152903 | 20231121191822 | 20240304153738 | 20240309111148 | 20240311173251 | 20240313230538 | 20240314214802 | ``` </details> Let me know if you need more information ! I hope this helps
GiteaMirror commented 2025-11-01 20:52:08 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Aug 12, 2024):

Can you enable database debug logging and run the failing migration again?

@kolaente commented on GitHub (Aug 12, 2024): Can you enable [database debug logging](https://vikunja.io/docs/config-options#database-2) and run the failing migration again?
GiteaMirror commented 2025-11-01 20:52:08 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Aug 12, 2024):

Can you enable database debug logging and run the failing migration again?

Sorry, I'm on vacation this week. I'll do it when I get back

@SeiyaGame commented on GitHub (Aug 12, 2024): > Can you enable [database debug logging](https://vikunja.io/docs/config-options#database-2) and run the failing migration again? Sorry, I'm on vacation this week. I'll do it when I get back
GiteaMirror commented 2025-11-01 20:52:09 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Aug 12, 2024):

Enjoy your vacation! I'll be gone from Wednesday until sept 1st as well.

@kolaente commented on GitHub (Aug 12, 2024): Enjoy your vacation! I'll be gone from Wednesday until sept 1st as well.
GiteaMirror commented 2025-11-01 20:52:09 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Sep 1, 2024):

Sorry for my late response

I've tried to retrieve as many logs as possible, but I've only got these two, and I don't think they're very informative.

  vikunja_app:
    image: vikunja/vikunja:latest
    container_name: vikunja_app
    depends_on:
      vikunja_db:
        condition: service_healthy
    environment:
      ...
      - VIKUNJA_LOG_LEVEL=debug
      - VIKUNJA_LOG_DATABASE=file
      - VIKUNJA_LOG_DATABASELEVEL=debug
      - VIKUNJA_LOG_STANDARD=file
      - VIKUNJA_LOG_EVENTS=file
      - VIKUNJA_LOG_EVENTSLEVEL=debug
      - VIKUNJA_LOG_HTTP=file
      - VIKUNJA_LOG_PATH=/logs
      ...
    ports:
      - 3456:3456
    volumes:
      - ./files:/app/vikunja/files
      - ./logs:/logs
database.log 
2024-09-01T12:56:05.205920838Z: INFO	▶ [DATABASE] 003 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 8.44359ms
2024-09-01T12:56:05.21777771Z: INFO	▶ [DATABASE] 004 [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
    CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
    CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
    JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
    LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
    LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
    LEFT JOIN pg_class AS g ON p.confrelid = g.oid
    LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r' AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [migration public] - 11.431989ms
2024-09-01T12:56:05.219248997Z: INFO	▶ [DATABASE] 005 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [migration public] - 1.388062ms
2024-09-01T12:56:05.219904883Z: INFO	▶ [DATABASE] 006 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [SCHEMA_INIT] - 593.389µs
2024-09-01T12:56:05.220154118Z: INFO	▶ [DATABASE] 007 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190324205606] - 216.451µs
2024-09-01T12:56:05.220445915Z: INFO	▶ [DATABASE] 008 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190328074430] - 264.966µs
2024-09-01T12:56:05.220898535Z: INFO	▶ [DATABASE] 009 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190430111111] - 256.186µs
2024-09-01T12:56:05.221168103Z: INFO	▶ [DATABASE] 00a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190511202210] - 240.227µs
2024-09-01T12:56:05.221400503Z: INFO	▶ [DATABASE] 00b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190514192749] - 206.913µs
2024-09-01T12:56:05.221624707Z: INFO	▶ [DATABASE] 00c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190524205441] - 199.591µs
2024-09-01T12:56:05.221853011Z: INFO	▶ [DATABASE] 00d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190718200716] - 203.434µs
2024-09-01T12:56:05.222079714Z: INFO	▶ [DATABASE] 00e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190818210133] - 201.653µs
2024-09-01T12:56:05.222299757Z: INFO	▶ [DATABASE] 00f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190920185205] - 195.543µs
2024-09-01T12:56:05.222517963Z: INFO	▶ [DATABASE] 010 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190922205826] - 193.633µs
2024-09-01T12:56:05.222748445Z: INFO	▶ [DATABASE] 011 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191008194238] - 195.825µs
2024-09-01T12:56:05.222981055Z: INFO	▶ [DATABASE] 012 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191010131430] - 199.514µs
2024-09-01T12:56:05.223199503Z: INFO	▶ [DATABASE] 013 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191207204427] - 192.656µs
2024-09-01T12:56:05.223422406Z: INFO	▶ [DATABASE] 014 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191207220736] - 195.279µs
2024-09-01T12:56:05.223651593Z: INFO	▶ [DATABASE] 015 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200120201756] - 196.627µs
2024-09-01T12:56:05.223870999Z: INFO	▶ [DATABASE] 016 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200219183248] - 193.896µs
2024-09-01T12:56:05.22409128Z: INFO	▶ [DATABASE] 017 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200308205855] - 195.757µs
2024-09-01T12:56:05.224314113Z: INFO	▶ [DATABASE] 018 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200308210130] - 198.039µs
2024-09-01T12:56:05.224559736Z: INFO	▶ [DATABASE] 019 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200322214440] - 199.294µs
2024-09-01T12:56:05.224777565Z: INFO	▶ [DATABASE] 01a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200322214624] - 193.027µs
2024-09-01T12:56:05.225007449Z: INFO	▶ [DATABASE] 01b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200417175201] - 205.098µs
2024-09-01T12:56:05.225231741Z: INFO	▶ [DATABASE] 01c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200418230432] - 198.477µs
2024-09-01T12:56:05.225454826Z: INFO	▶ [DATABASE] 01d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200418230605] - 198.869µs
2024-09-01T12:56:05.225684417Z: INFO	▶ [DATABASE] 01e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200420215928] - 195.921µs
2024-09-01T12:56:05.2259371Z: INFO	▶ [DATABASE] 01f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200425182634] - 227.118µs
2024-09-01T12:56:05.226170765Z: INFO	▶ [DATABASE] 020 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200509103709] - 205.333µs
2024-09-01T12:56:05.226386358Z: INFO	▶ [DATABASE] 021 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200515172220] - 191.244µs
2024-09-01T12:56:05.226607455Z: INFO	▶ [DATABASE] 022 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200515195546] - 194.364µs
2024-09-01T12:56:05.226826751Z: INFO	▶ [DATABASE] 023 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200516123847] - 194.612µs
2024-09-01T12:56:05.227045233Z: INFO	▶ [DATABASE] 024 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200524221534] - 194.01µs
2024-09-01T12:56:05.227265831Z: INFO	▶ [DATABASE] 025 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200524224611] - 196.001µs
2024-09-01T12:56:05.227489261Z: INFO	▶ [DATABASE] 026 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200614113230] - 198.823µs
2024-09-01T12:56:05.227729676Z: INFO	▶ [DATABASE] 027 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200621214452] - 197.73µs
2024-09-01T12:56:05.227971182Z: INFO	▶ [DATABASE] 028 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200801183357] - 213.518µs
2024-09-01T12:56:05.228205124Z: INFO	▶ [DATABASE] 029 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200904101559] - 205.575µs
2024-09-01T12:56:05.228431583Z: INFO	▶ [DATABASE] 02a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200905151040] - 198.808µs
2024-09-01T12:56:05.228651763Z: INFO	▶ [DATABASE] 02b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200905232458] - 195.265µs
2024-09-01T12:56:05.228879503Z: INFO	▶ [DATABASE] 02c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200906184746] - 203.012µs
2024-09-01T12:56:05.229186687Z: INFO	▶ [DATABASE] 02d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201025195822] - 279.394µs
2024-09-01T12:56:05.231779949Z: INFO	▶ [DATABASE] 02e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201121181647] - 2.539089ms
2024-09-01T12:56:05.232066605Z: INFO	▶ [DATABASE] 02f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201218152741] - 250.352µs
2024-09-01T12:56:05.232313359Z: INFO	▶ [DATABASE] 030 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201218220204] - 216.994µs
2024-09-01T12:56:05.232549395Z: INFO	▶ [DATABASE] 031 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201219145028] - 204.274µs
2024-09-01T12:56:05.232773794Z: INFO	▶ [DATABASE] 032 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210207192805] - 199.165µs
2024-09-01T12:56:05.233006893Z: INFO	▶ [DATABASE] 033 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210209204715] - 206.903µs
2024-09-01T12:56:05.233230447Z: INFO	▶ [DATABASE] 034 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210220222121] - 197.812µs
2024-09-01T12:56:05.233459119Z: INFO	▶ [DATABASE] 035 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210221111953] - 197.974µs
2024-09-01T12:56:05.233680318Z: INFO	▶ [DATABASE] 036 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210321185225] - 195.616µs
2024-09-01T12:56:05.233903073Z: INFO	▶ [DATABASE] 037 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210328191017] - 198.745µs
2024-09-01T12:56:05.234127613Z: INFO	▶ [DATABASE] 038 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210403145503] - 197.725µs
2024-09-01T12:56:05.234350354Z: INFO	▶ [DATABASE] 039 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210403220653] - 198.335µs
2024-09-01T12:56:05.234579157Z: INFO	▶ [DATABASE] 03a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210407170753] - 196.937µs
2024-09-01T12:56:05.23480794Z: INFO	▶ [DATABASE] 03b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210411113105] - 204.438µs
2024-09-01T12:56:05.235036362Z: INFO	▶ [DATABASE] 03c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210411161337] - 203.265µs
2024-09-01T12:56:05.235255018Z: INFO	▶ [DATABASE] 03d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210413131057] - 194.361µs
2024-09-01T12:56:05.235478651Z: INFO	▶ [DATABASE] 03e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210527105701] - 198.608µs
2024-09-01T12:56:05.235696782Z: INFO	▶ [DATABASE] 03f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210603174608] - 194.064µs
2024-09-01T12:56:05.235924475Z: INFO	▶ [DATABASE] 040 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210709191101] - 199.622µs
2024-09-01T12:56:05.236145506Z: INFO	▶ [DATABASE] 041 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210709211508] - 195.637µs
2024-09-01T12:56:05.236372659Z: INFO	▶ [DATABASE] 042 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210711173657] - 195.709µs
2024-09-01T12:56:05.236589761Z: INFO	▶ [DATABASE] 043 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210713213622] - 192.638µs
2024-09-01T12:56:05.236806949Z: INFO	▶ [DATABASE] 044 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210725153703] - 193.512µs
2024-09-01T12:56:05.237042767Z: INFO	▶ [DATABASE] 045 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210727204942] - 212.178µs
2024-09-01T12:56:05.237263029Z: INFO	▶ [DATABASE] 046 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210727211037] - 194.866µs
2024-09-01T12:56:05.2374804Z: INFO	▶ [DATABASE] 047 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210729142940] - 193.515µs
2024-09-01T12:56:05.237698514Z: INFO	▶ [DATABASE] 048 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210802081716] - 193.127µs
2024-09-01T12:56:05.237915766Z: INFO	▶ [DATABASE] 049 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210829194722] - 193.393µs
2024-09-01T12:56:05.238146445Z: INFO	▶ [DATABASE] 04a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20211212151642] - 204.679µs
2024-09-01T12:56:05.238366124Z: INFO	▶ [DATABASE] 04b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20211212210054] - 195.347µs
2024-09-01T12:56:05.238588728Z: INFO	▶ [DATABASE] 04c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20220112211537] - 197.456µs
2024-09-01T12:56:05.238808697Z: INFO	▶ [DATABASE] 04d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20220616145228] - 194.212µs
2024-09-01T12:56:05.239026274Z: INFO	▶ [DATABASE] 04e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20220815200851] - 193.671µs
2024-09-01T12:56:05.23924555Z: INFO	▶ [DATABASE] 04f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20221002120521] - 195.136µs
2024-09-01T12:56:05.239462785Z: INFO	▶ [DATABASE] 050 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20221113170740] - 193.232µs
2024-09-01T12:56:05.239688459Z: INFO	▶ [DATABASE] 051 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20221228112131] - 193.698µs
2024-09-01T12:56:05.239905055Z: INFO	▶ [DATABASE] 052 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230104152903] - 192.771µs
2024-09-01T12:56:05.239918521Z: INFO	▶ [DATABASE] 053 Adding OidcID to teams
2024-09-01T12:56:05.240427696Z: INFO	▶ [DATABASE] 054 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 497.13µs
2024-09-01T12:56:05.241580783Z: INFO	▶ [DATABASE] 055 [SQL] CREATE TABLE IF NOT EXISTS "public"."teams" ("oidc_id" VARCHAR(250) NULL);  [] - 1.098384ms
2024-09-01T12:56:05.241946088Z: INFO	▶ [DATABASE] 056 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20230104152903 ] - 336.941µs
2024-09-01T12:56:05.242193863Z: INFO	▶ [DATABASE] 057 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230307171848] - 222.793µs
2024-09-01T12:56:05.242426574Z: INFO	▶ [DATABASE] 058 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230611170341] - 207.4µs
2024-09-01T12:56:05.242652957Z: INFO	▶ [DATABASE] 059 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230824132533] - 202.033µs
2024-09-01T12:56:05.242886671Z: INFO	▶ [DATABASE] 05a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230828125443] - 209.63µs
2024-09-01T12:56:05.243108193Z: INFO	▶ [DATABASE] 05b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230831155832] - 197.348µs
2024-09-01T12:56:05.243328023Z: INFO	▶ [DATABASE] 05c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230903143017] - 194.788µs
2024-09-01T12:56:05.243546673Z: INFO	▶ [DATABASE] 05d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230913202615] - 194.92µs
2024-09-01T12:56:05.243764724Z: INFO	▶ [DATABASE] 05e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20231022144641] - 194.142µs
2024-09-01T12:56:05.243980641Z: INFO	▶ [DATABASE] 05f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20231108231513] - 192.219µs
2024-09-01T12:56:05.244200442Z: INFO	▶ [DATABASE] 060 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20231121191822] - 195.779µs
2024-09-01T12:56:05.244215426Z: INFO	▶ [DATABASE] 061 Migrate saved filter structure
2024-09-01T12:56:05.244609391Z: INFO	▶ [DATABASE] 062 [SQL] SELECT "id", "filters" FROM "saved_filters" [] - 356.815µs
2024-09-01T12:56:05.244935293Z: INFO	▶ [DATABASE] 063 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20231121191822 ] - 285.527µs
2024-09-01T12:56:05.24517198Z: INFO	▶ [DATABASE] 064 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240114224713] - 212.219µs
2024-09-01T12:56:05.24539969Z: INFO	▶ [DATABASE] 065 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240304153738] - 203.108µs
2024-09-01T12:56:05.245415233Z: INFO	▶ [DATABASE] 066 Add issuer column to teams to track the OIDC provider this issue has bene created by
2024-09-01T12:56:05.245898887Z: INFO	▶ [DATABASE] 067 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 475.641µs
2024-09-01T12:56:05.251350925Z: INFO	▶ [DATABASE] 068 [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
    CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
    CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
    JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
    LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
    LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
    LEFT JOIN pg_class AS g ON p.confrelid = g.oid
    LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r' AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [teams public] - 5.415557ms
2024-09-01T12:56:05.252119439Z: INFO	▶ [DATABASE] 069 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [teams public] - 720.314µs
2024-09-01T12:56:05.253627624Z: INFO	▶ [DATABASE] 06a [SQL] ALTER TABLE "public"."teams" ADD "issuer" TEXT NULL; COMMENT ON COLUMN "public"."teams"."issuer" IS '' [] - 1.481145ms
2024-09-01T12:56:05.253962985Z: INFO	▶ [DATABASE] 06b [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240304153738 ] - 303.675µs
2024-09-01T12:56:05.254221046Z: INFO	▶ [DATABASE] 06c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240309111148] - 228.26µs
2024-09-01T12:56:05.254235247Z: INFO	▶ [DATABASE] 06d Add IsPublic field to teams table to control discoverability of teams.
2024-09-01T12:56:05.254728276Z: INFO	▶ [DATABASE] 06e [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 482.083µs
2024-09-01T12:56:05.259110275Z: INFO	▶ [DATABASE] 06f [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description,
    CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey,
    CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey
FROM pg_attribute f
    JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid
    LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum
    LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid
    LEFT JOIN pg_namespace n ON n.oid = c.relnamespace
    LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey)
    LEFT JOIN pg_class AS g ON p.confrelid = g.oid
    LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name
WHERE n.nspname= s.table_schema AND c.relkind = 'r' AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [teams public] - 4.350782ms
2024-09-01T12:56:05.259837992Z: INFO	▶ [DATABASE] 070 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [teams public] - 697.57µs
2024-09-01T12:56:05.260345012Z: INFO	▶ [DATABASE] 071 [SQL] ALTER TABLE "public"."teams" ADD "is_public" BOOL DEFAULT false NOT NULL; COMMENT ON COLUMN "public"."teams"."is_public" IS '' [] - 484.445µs
2024-09-01T12:56:05.260660112Z: INFO	▶ [DATABASE] 072 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240309111148 ] - 285.741µs
2024-09-01T12:56:05.260930319Z: INFO	▶ [DATABASE] 073 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240311173251] - 241.186µs
2024-09-01T12:56:05.260945699Z: INFO	▶ [DATABASE] 074 Create reactions table
2024-09-01T12:56:05.261439118Z: INFO	▶ [DATABASE] 075 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 484.949µs
2024-09-01T12:56:05.263299058Z: INFO	▶ [DATABASE] 076 [SQL] CREATE TABLE IF NOT EXISTS "public"."reactions" ("id" BIGSERIAL PRIMARY KEY  NOT NULL, "user_id" BIGINT NOT NULL, "entity_id" BIGINT NOT NULL, "entity_kind" BIGINT NOT NULL, "value" VARCHAR(20) NOT NULL, "created" TIMESTAMP NOT NULL);  [] - 1.789467ms
2024-09-01T12:56:05.264051605Z: INFO	▶ [DATABASE] 077 [SQL] CREATE UNIQUE INDEX "UQE_reactions_id" ON "reactions" ("id") [] - 724.069µs
2024-09-01T12:56:05.264725702Z: INFO	▶ [DATABASE] 078 [SQL] CREATE INDEX "IDX_reactions_entity_id" ON "reactions" ("entity_id") [] - 652.348µs
2024-09-01T12:56:05.265409951Z: INFO	▶ [DATABASE] 079 [SQL] CREATE INDEX "IDX_reactions_entity_kind" ON "reactions" ("entity_kind") [] - 670.999µs
2024-09-01T12:56:05.266095116Z: INFO	▶ [DATABASE] 07a [SQL] CREATE INDEX "IDX_reactions_value" ON "reactions" ("value") [] - 671.679µs
2024-09-01T12:56:05.266741729Z: INFO	▶ [DATABASE] 07b [SQL] CREATE INDEX "IDX_reactions_user_id" ON "reactions" ("user_id") [] - 633.66µs
2024-09-01T12:56:05.267061312Z: INFO	▶ [DATABASE] 07c [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240311173251 ] - 283.895µs
2024-09-01T12:56:05.267322125Z: INFO	▶ [DATABASE] 07d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240313230538] - 228.443µs
2024-09-01T12:56:05.267338493Z: INFO	▶ [DATABASE] 07e Add project views table
2024-09-01T12:56:05.267825486Z: INFO	▶ [DATABASE] 07f [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 478.524µs
2024-09-01T12:56:05.270170901Z: INFO	▶ [DATABASE] 080 [SQL] CREATE TABLE IF NOT EXISTS "public"."project_views" ("id" BIGSERIAL PRIMARY KEY  NOT NULL, "title" VARCHAR(255) NOT NULL, "project_id" BIGINT NOT NULL, "view_kind" INTEGER NOT NULL, "filter" TEXT DEFAULT null NULL, "position" DOUBLE PRECISION NULL, "bucket_configuration_mode" INTEGER DEFAULT 0 NULL, "bucket_configuration" JSON NULL, "updated" TIMESTAMP NOT NULL, "created" TIMESTAMP NOT NULL);  [] - 2.261622ms
2024-09-01T12:56:05.270897183Z: INFO	▶ [DATABASE] 081 [SQL] CREATE UNIQUE INDEX "UQE_project_views_id" ON "project_views" ("id") [] - 699.587µs
2024-09-01T12:56:05.271566542Z: INFO	▶ [DATABASE] 082 [SQL] CREATE INDEX "IDX_project_views_project_id" ON "project_views" ("project_id") [] - 651.756µs
2024-09-01T12:56:05.27193682Z: INFO	▶ [DATABASE] 083 [SQL] SELECT "id" FROM "projects" [] - 335.588µs
2024-09-01T12:56:05.27265662Z: INFO	▶ [DATABASE] 084 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 3 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 608.447µs
2024-09-01T12:56:05.273030355Z: INFO	▶ [DATABASE] 085 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 3 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 330.307µs
2024-09-01T12:56:05.27336714Z: INFO	▶ [DATABASE] 086 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 3 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 298.233µs
2024-09-01T12:56:05.273696804Z: INFO	▶ [DATABASE] 087 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 3 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 290.507µs
2024-09-01T12:56:05.274018781Z: INFO	▶ [DATABASE] 088 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 4 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 285.823µs
2024-09-01T12:56:05.274342808Z: INFO	▶ [DATABASE] 089 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 4 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 287.515µs
2024-09-01T12:56:05.274665706Z: INFO	▶ [DATABASE] 08a [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 4 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 281.997µs
2024-09-01T12:56:05.274983151Z: INFO	▶ [DATABASE] 08b [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 4 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 282.547µs
2024-09-01T12:56:05.275305782Z: INFO	▶ [DATABASE] 08c [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 5 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 281.071µs
2024-09-01T12:56:05.275622219Z: INFO	▶ [DATABASE] 08d [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 5 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 281.75µs
2024-09-01T12:56:05.275939731Z: INFO	▶ [DATABASE] 08e [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 5 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 282.828µs
2024-09-01T12:56:05.276272994Z: INFO	▶ [DATABASE] 08f [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 5 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 287.197µs
2024-09-01T12:56:05.27659337Z: INFO	▶ [DATABASE] 090 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 7 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 283.807µs
2024-09-01T12:56:05.27692857Z: INFO	▶ [DATABASE] 091 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 7 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 294.681µs
2024-09-01T12:56:05.277253956Z: INFO	▶ [DATABASE] 092 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 7 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 287.382µs
2024-09-01T12:56:05.277688901Z: INFO	▶ [DATABASE] 093 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 7 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 399.307µs
2024-09-01T12:56:05.278074606Z: INFO	▶ [DATABASE] 094 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 8 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 343.333µs
2024-09-01T12:56:05.278433164Z: INFO	▶ [DATABASE] 095 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 8 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 295.517µs
2024-09-01T12:56:05.278783772Z: INFO	▶ [DATABASE] 096 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 8 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 308.605µs
2024-09-01T12:56:05.279123613Z: INFO	▶ [DATABASE] 097 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 8 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 301.378µs
2024-09-01T12:56:05.27949864Z: INFO	▶ [DATABASE] 098 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 9 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 326.526µs
2024-09-01T12:56:05.279820833Z: INFO	▶ [DATABASE] 099 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 9 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 282.378µs
2024-09-01T12:56:05.280146288Z: INFO	▶ [DATABASE] 09a [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 9 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 288.24µs
2024-09-01T12:56:05.280463326Z: INFO	▶ [DATABASE] 09b [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 9 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 280.158µs
2024-09-01T12:56:05.280776257Z: INFO	▶ [DATABASE] 09c [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 1 0  100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 277.188µs
2024-09-01T12:56:05.281115505Z: INFO	▶ [DATABASE] 09d [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 1 1  200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 302.934µs
2024-09-01T12:56:05.281450982Z: INFO	▶ [DATABASE] 09e [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 1 2  300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 286.674µs
2024-09-01T12:56:05.281767056Z: INFO	▶ [DATABASE] 09f [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 1 3  400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 278.371µs
2024-09-01T12:56:05.281959937Z: INFO	▶ [DATABASE] 0a0 [SQL] SELECT "id" FROM "saved_filters" [] - 139.628µs
2024-09-01T12:56:05.282261458Z: INFO	▶ [DATABASE] 0a1 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240313230538 ] - 261.894µs
2024-09-01T12:56:05.28251487Z: INFO	▶ [DATABASE] 0a2 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240314214802] - 224.714µs
2024-09-01T12:56:05.282529469Z: INFO	▶ [DATABASE] 0a3 make task position separate
2024-09-01T12:56:05.283036131Z: INFO	▶ [DATABASE] 0a4 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 497.985µs
2024-09-01T12:56:05.2835467Z: INFO	▶ [DATABASE] 0a5 [SQL] CREATE TABLE IF NOT EXISTS "public"."task_positions" ("task_id" BIGINT NOT NULL, "project_view_id" BIGINT NOT NULL, "position" DOUBLE PRECISION NOT NULL);  [] - 467.699µs
2024-09-01T12:56:05.284337802Z: INFO	▶ [DATABASE] 0a6 [SQL] CREATE INDEX "IDX_task_positions_task_id" ON "task_positions" ("task_id") [] - 770.47µs
2024-09-01T12:56:05.285045356Z: INFO	▶ [DATABASE] 0a7 [SQL] CREATE INDEX "IDX_task_positions_project_view_id" ON "task_positions" ("project_view_id") [] - 685.918µs
2024-09-01T12:56:05.285452406Z: INFO	▶ [DATABASE] 0a8 [SQL] SELECT "id", "project_id", "position", "kanban_position" FROM "tasks" [] - 364.299µs
2024-09-01T12:56:05.285898604Z: INFO	▶ [DATABASE] 0a9 [SQL] SELECT "id", "title", "project_id", "view_kind", "filter", "position", "bucket_configuration_mode", "bucket_configuration", "updated", "created" FROM "project_views" [] - 162.109µs
2024-09-01T12:56:05.286727303Z: INFO	▶ [DATABASE] 0aa [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [1 25 7.040929993442623e+07] - 514.099µs
2024-09-01T12:56:05.287066681Z: INFO	▶ [DATABASE] 0ab [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [1 28 8.947848533333333e+07] - 311.293µs
2024-09-01T12:56:05.287356291Z: INFO	▶ [DATABASE] 0ac [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [2 25 1.4081859986885247e+08] - 265.04µs
2024-09-01T12:56:05.287629159Z: INFO	▶ [DATABASE] 0ad [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [2 28 1.7895697066666666e+08] - 250.533µs
2024-09-01T12:56:05.287901806Z: INFO	▶ [DATABASE] 0ae [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [3 25 2.1122789980327868e+08] - 251.14µs
2024-09-01T12:56:05.288193761Z: INFO	▶ [DATABASE] 0af [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [3 28 0] - 266.383µs
2024-09-01T12:56:05.288464138Z: INFO	▶ [DATABASE] 0b0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [4 25 2.8163719973770493e+08] - 249.449µs
2024-09-01T12:56:05.28873051Z: INFO	▶ [DATABASE] 0b1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [4 28 2.68435456e+08] - 245.849µs
2024-09-01T12:56:05.289026329Z: INFO	▶ [DATABASE] 0b2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [6 25 3.520464996721312e+08] - 274.947µs
2024-09-01T12:56:05.289300077Z: INFO	▶ [DATABASE] 0b3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [6 28 4.2054888106666665e+09] - 250.823µs
2024-09-01T12:56:05.289569434Z: INFO	▶ [DATABASE] 0b4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [7 25 4.2245579960655737e+08] - 248.53µs
2024-09-01T12:56:05.289839586Z: INFO	▶ [DATABASE] 0b5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [7 28 4.294967296e+09] - 249.412µs
2024-09-01T12:56:05.290112484Z: INFO	▶ [DATABASE] 0b6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [8 25 4.928650995409836e+08] - 252.282µs
2024-09-01T12:56:05.290393685Z: INFO	▶ [DATABASE] 0b7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [8 28 4.02653184e+09] - 260.09µs
2024-09-01T12:56:05.290663233Z: INFO	▶ [DATABASE] 0b8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [9 25 5.632743994754099e+08] - 247.77µs
2024-09-01T12:56:05.290932575Z: INFO	▶ [DATABASE] 0b9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [9 28 3.847574869333333e+09] - 247.219µs
2024-09-01T12:56:05.291206392Z: INFO	▶ [DATABASE] 0ba [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [10 25 6.33683699409836e+08] - 250.427µs
2024-09-01T12:56:05.291472162Z: INFO	▶ [DATABASE] 0bb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [10 28 3.489660928e+09] - 245.802µs
2024-09-01T12:56:05.291738919Z: INFO	▶ [DATABASE] 0bc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [12 25 7.040929993442624e+08] - 246.331µs
2024-09-01T12:56:05.292012083Z: INFO	▶ [DATABASE] 0bd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [12 28 3.579139413333333e+09] - 246.839µs
2024-09-01T12:56:05.292297377Z: INFO	▶ [DATABASE] 0be [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [13 25 7.745022992786885e+08] - 250.266µs
2024-09-01T12:56:05.292573431Z: INFO	▶ [DATABASE] 0bf [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [13 28 3.579139413333333e+08] - 248.805µs
2024-09-01T12:56:05.292841205Z: INFO	▶ [DATABASE] 0c0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [14 25 8.449115992131147e+08] - 247.332µs
2024-09-01T12:56:05.293119101Z: INFO	▶ [DATABASE] 0c1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [14 28 1.2288e+06] - 249.057µs
2024-09-01T12:56:05.29339212Z: INFO	▶ [DATABASE] 0c2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [15 25 9.15320899147541e+08] - 250.264µs
2024-09-01T12:56:05.293660323Z: INFO	▶ [DATABASE] 0c3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [15 28 4.473924266666666e+08] - 247.419µs
2024-09-01T12:56:05.293934047Z: INFO	▶ [DATABASE] 0c4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [17 1 65536] - 252.879µs
2024-09-01T12:56:05.294202849Z: INFO	▶ [DATABASE] 0c5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [17 4 0] - 248.336µs
2024-09-01T12:56:05.294473911Z: INFO	▶ [DATABASE] 0c6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [19 25 1.1265487989508197e+09] - 248.536µs
2024-09-01T12:56:05.294740888Z: INFO	▶ [DATABASE] 0c7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [19 28 983040] - 245.198µs
2024-09-01T12:56:05.295011094Z: INFO	▶ [DATABASE] 0c8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [21 25 1.267367398819672e+09] - 248.335µs
2024-09-01T12:56:05.295294446Z: INFO	▶ [DATABASE] 0c9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [21 28 3.4001824426666665e+09] - 262.675µs
2024-09-01T12:56:05.2955636Z: INFO	▶ [DATABASE] 0ca [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [22 25 1.3377766987540984e+09] - 248.553µs
2024-09-01T12:56:05.295831337Z: INFO	▶ [DATABASE] 0cb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [22 28 3.6686178986666665e+09] - 246.001µs
2024-09-01T12:56:05.2960996Z: INFO	▶ [DATABASE] 0cc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [23 25 1.4081859986885247e+09] - 246.957µs
2024-09-01T12:56:05.296369633Z: INFO	▶ [DATABASE] 0cd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [23 28 1.14688e+06] - 248.472µs
2024-09-01T12:56:05.296641578Z: INFO	▶ [DATABASE] 0ce [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [24 25 1.4785952986229508e+09] - 251.62µs
2024-09-01T12:56:05.296932398Z: INFO	▶ [DATABASE] 0cf [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [24 28 3.758096384e+09] - 268.593µs
2024-09-01T12:56:05.297205716Z: INFO	▶ [DATABASE] 0d0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [25 25 1.549004598557377e+09] - 251.991µs
2024-09-01T12:56:05.297473645Z: INFO	▶ [DATABASE] 0d1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [25 28 5.36870912e+08] - 245.822µs
2024-09-01T12:56:05.29775502Z: INFO	▶ [DATABASE] 0d2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [26 25 1.6194138984918034e+09] - 248.403µs
2024-09-01T12:56:05.298030018Z: INFO	▶ [DATABASE] 0d3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [26 28 4.116010325333333e+09] - 250.354µs
2024-09-01T12:56:05.298296506Z: INFO	▶ [DATABASE] 0d4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [27 25 1.6898231984262295e+09] - 246.13µs
2024-09-01T12:56:05.29856192Z: INFO	▶ [DATABASE] 0d5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [27 28 1.114112e+06] - 245.148µs
2024-09-01T12:56:05.298831057Z: INFO	▶ [DATABASE] 0d6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [28 25 1.7602324983606558e+09] - 247.406µs
2024-09-01T12:56:05.299096453Z: INFO	▶ [DATABASE] 0d7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [28 28 3.9370533546666665e+09] - 245.126µs
2024-09-01T12:56:05.299377541Z: INFO	▶ [DATABASE] 0d8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [29 1 1.179648e+06] - 260.591µs
2024-09-01T12:56:05.299644651Z: INFO	▶ [DATABASE] 0d9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [29 4 1.179648e+06] - 246.987µs
2024-09-01T12:56:05.299907Z: INFO	▶ [DATABASE] 0da [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [30 25 1.830641798295082e+09] - 242.148µs
2024-09-01T12:56:05.300172606Z: INFO	▶ [DATABASE] 0db [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [30 28 6.263493973333333e+08] - 245.304µs
2024-09-01T12:56:05.300443038Z: INFO	▶ [DATABASE] 0dc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [31 25 1.9010510982295084e+09] - 248.853µs
2024-09-01T12:56:05.300708672Z: INFO	▶ [DATABASE] 0dd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [31 28 7.158278826666666e+08] - 244.039µs
2024-09-01T12:56:05.300995209Z: INFO	▶ [DATABASE] 0de [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [32 25 1.9714603981639345e+09] - 266.234µs
2024-09-01T12:56:05.301266055Z: INFO	▶ [DATABASE] 0df [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [32 28 8.05306368e+08] - 248.253µs
2024-09-01T12:56:05.301531841Z: INFO	▶ [DATABASE] 0e0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [33 25 2.0418696980983608e+09] - 243.926µs
2024-09-01T12:56:05.301796449Z: INFO	▶ [DATABASE] 0e1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [33 28 8.947848533333333e+08] - 243.202µs
2024-09-01T12:56:05.302063904Z: INFO	▶ [DATABASE] 0e2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [35 25 2.112278998032787e+09] - 247.182µs
2024-09-01T12:56:05.302330165Z: INFO	▶ [DATABASE] 0e3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [35 28 9.842633386666666e+08] - 245.999µs
2024-09-01T12:56:05.302601448Z: INFO	▶ [DATABASE] 0e4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [37 25 2.2530975979016395e+09] - 249.59µs
2024-09-01T12:56:05.302864863Z: INFO	▶ [DATABASE] 0e5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [37 28 1.073741824e+09] - 243.12µs
2024-09-01T12:56:05.303135884Z: INFO	▶ [DATABASE] 0e6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [40 25 2.393916197770492e+09] - 250.468µs
2024-09-01T12:56:05.303408665Z: INFO	▶ [DATABASE] 0e7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [40 28 1.1632203093333333e+09] - 245.461µs
2024-09-01T12:56:05.303702007Z: INFO	▶ [DATABASE] 0e8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [41 25 2.4643254977049184e+09] - 272.669µs
2024-09-01T12:56:05.303971999Z: INFO	▶ [DATABASE] 0e9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [41 28 1.2526987946666665e+09] - 248.566µs
2024-09-01T12:56:05.304241546Z: INFO	▶ [DATABASE] 0ea [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [42 25 2.534734797639344e+09] - 249.082µs
2024-09-01T12:56:05.304509396Z: INFO	▶ [DATABASE] 0eb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [42 28 1.34217728e+09] - 247.229µs
2024-09-01T12:56:05.304783472Z: INFO	▶ [DATABASE] 0ec [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [43 25 2.6051440975737705e+09] - 247.3µs
2024-09-01T12:56:05.305062723Z: INFO	▶ [DATABASE] 0ed [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [43 28 1.4316557653333333e+09] - 258.649µs
2024-09-01T12:56:05.305339837Z: INFO	▶ [DATABASE] 0ee [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [44 25 2.675553397508197e+09] - 255.115µs
2024-09-01T12:56:05.305607339Z: INFO	▶ [DATABASE] 0ef [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [44 28 1.5211342506666665e+09] - 246.928µs
2024-09-01T12:56:05.305875031Z: INFO	▶ [DATABASE] 0f0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [45 25 2.745962697442623e+09] - 246.954µs
2024-09-01T12:56:05.306143309Z: INFO	▶ [DATABASE] 0f1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [45 28 1.610612736e+09] - 247.983µs
2024-09-01T12:56:05.306409848Z: INFO	▶ [DATABASE] 0f2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [46 25 2.8163719973770494e+09] - 243.965µs
2024-09-01T12:56:05.306677533Z: INFO	▶ [DATABASE] 0f3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [46 28 1.7000912213333333e+09] - 247.218µs
2024-09-01T12:56:05.306948708Z: INFO	▶ [DATABASE] 0f4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [47 25 2.8867812973114758e+09] - 250.718µs
2024-09-01T12:56:05.307214702Z: INFO	▶ [DATABASE] 0f5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [47 28 1.7895697066666665e+09] - 244.406µs
2024-09-01T12:56:05.307483155Z: INFO	▶ [DATABASE] 0f6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [49 25 2.9571905972459016e+09] - 246.867µs
2024-09-01T12:56:05.307747501Z: INFO	▶ [DATABASE] 0f7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [49 28 2.859008e+06] - 243.864µs
2024-09-01T12:56:05.308017003Z: INFO	▶ [DATABASE] 0f8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [50 25 3.027599897180328e+09] - 249.157µs
2024-09-01T12:56:05.308304752Z: INFO	▶ [DATABASE] 0f9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [50 28 1.879048192e+09] - 265.546µs
2024-09-01T12:56:05.308579027Z: INFO	▶ [DATABASE] 0fa [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [51 25 3.098009197114754e+09] - 252.487µs
2024-09-01T12:56:05.308848307Z: INFO	▶ [DATABASE] 0fb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [51 28 9.842633386666666e+08] - 248.003µs
2024-09-01T12:56:05.309141954Z: INFO	▶ [DATABASE] 0fc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [52 25 3.1684184970491805e+09] - 256.073µs
2024-09-01T12:56:05.309414179Z: INFO	▶ [DATABASE] 0fd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [52 28 1.9685266773333333e+09] - 249.728µs
2024-09-01T12:56:05.309685844Z: INFO	▶ [DATABASE] 0fe [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [54 25 3.238827796983607e+09] - 249.223µs
2024-09-01T12:56:05.309955861Z: INFO	▶ [DATABASE] 0ff [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [54 28 2.0580051626666665e+09] - 248.352µs
2024-09-01T12:56:05.310234025Z: INFO	▶ [DATABASE] 100 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [55 25 3.309237096918033e+09] - 252.026µs
2024-09-01T12:56:05.310504624Z: INFO	▶ [DATABASE] 101 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [55 28 2.147483648e+09] - 249.84µs
2024-09-01T12:56:05.310775053Z: INFO	▶ [DATABASE] 102 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [56 25 3.379646396852459e+09] - 250.064µs
2024-09-01T12:56:05.311077818Z: INFO	▶ [DATABASE] 103 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [56 28 2.236962133333333e+09] - 282.194µs
2024-09-01T12:56:05.311354151Z: INFO	▶ [DATABASE] 104 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [57 25 3.4500556967868853e+09] - 252.392µs
2024-09-01T12:56:05.311622375Z: INFO	▶ [DATABASE] 105 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [57 28 2.3264406186666665e+09] - 247.781µs
2024-09-01T12:56:05.311889646Z: INFO	▶ [DATABASE] 106 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [59 25 3.5204649967213116e+09] - 244.092µs
2024-09-01T12:56:05.312157558Z: INFO	▶ [DATABASE] 107 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [59 28 2.415919104e+09] - 247.721µs
2024-09-01T12:56:05.312424789Z: INFO	▶ [DATABASE] 108 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [61 25 3.590874296655738e+09] - 246.845µs
2024-09-01T12:56:05.312694659Z: INFO	▶ [DATABASE] 109 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [61 28 2.505397589333333e+09] - 248.319µs
2024-09-01T12:56:05.312979522Z: INFO	▶ [DATABASE] 10a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [62 25 3.661283596590164e+09] - 263.017µs
2024-09-01T12:56:05.313250917Z: INFO	▶ [DATABASE] 10b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [62 28 2.5948760746666665e+09] - 250.151µs
2024-09-01T12:56:05.31351801Z: INFO	▶ [DATABASE] 10c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [63 25 3.7316928965245905e+09] - 246.012µs
2024-09-01T12:56:05.313786328Z: INFO	▶ [DATABASE] 10d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [63 28 2.68435456e+09] - 247.681µs
2024-09-01T12:56:05.314059739Z: INFO	▶ [DATABASE] 10e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [64 25 3.802102196459017e+09] - 251.166µs
2024-09-01T12:56:05.314325731Z: INFO	▶ [DATABASE] 10f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [64 28 2.773833045333333e+09] - 245.608µs
2024-09-01T12:56:05.314589827Z: INFO	▶ [DATABASE] 110 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [65 25 3.8725114963934426e+09] - 243.664µs
2024-09-01T12:56:05.314871052Z: INFO	▶ [DATABASE] 111 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [65 28 2.8633115306666665e+09] - 255.396µs
2024-09-01T12:56:05.315143027Z: INFO	▶ [DATABASE] 112 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [67 25 3.942920796327869e+09] - 248.647µs
2024-09-01T12:56:05.315409673Z: INFO	▶ [DATABASE] 113 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [67 28 2.952790016e+09] - 246.244µs
2024-09-01T12:56:05.315680026Z: INFO	▶ [DATABASE] 114 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [68 25 4.0133300962622952e+09] - 248.548µs
2024-09-01T12:56:05.315945497Z: INFO	▶ [DATABASE] 115 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [68 28 3.042268501333333e+09] - 244.996µs
2024-09-01T12:56:05.316220126Z: INFO	▶ [DATABASE] 116 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [71 25 4.0837393961967216e+09] - 251.679µs
2024-09-01T12:56:05.316490279Z: INFO	▶ [DATABASE] 117 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [71 28 3.1317469866666665e+09] - 249.333µs
2024-09-01T12:56:05.316755614Z: INFO	▶ [DATABASE] 118 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [72 25 4.154148696131148e+09] - 244.886µs
2024-09-01T12:56:05.317035024Z: INFO	▶ [DATABASE] 119 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [72 28 3.221225472e+09] - 257.755µs
2024-09-01T12:56:05.317323896Z: INFO	▶ [DATABASE] 11a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [73 25 4.224557996065574e+09] - 266.569µs
2024-09-01T12:56:05.317594353Z: INFO	▶ [DATABASE] 11b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [73 28 3.310703957333333e+09] - 249.939µs
2024-09-01T12:56:05.31785928Z: INFO	▶ [DATABASE] 11c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [74 25 4.294967296e+09] - 243.413µs
2024-09-01T12:56:05.31813889Z: INFO	▶ [DATABASE] 11d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [74 28 4.4739242666666664e+07] - 259.286µs
2024-09-01T12:56:05.318412297Z: INFO	▶ [DATABASE] 11e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [77 9 65536] - 250.13µs
2024-09-01T12:56:05.318685314Z: INFO	▶ [DATABASE] 11f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [77 12 4.295032832e+09] - 249.857µs
2024-09-01T12:56:05.318953205Z: INFO	▶ [DATABASE] 120 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [78 9 131072] - 247.49µs
2024-09-01T12:56:05.319217462Z: INFO	▶ [DATABASE] 121 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [78 12 131072] - 243.968µs
2024-09-01T12:56:05.319485575Z: INFO	▶ [DATABASE] 122 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [79 9 196608] - 247.979µs
2024-09-01T12:56:05.319752262Z: INFO	▶ [DATABASE] 123 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [79 12 196608] - 246.15µs
2024-09-01T12:56:05.320019745Z: INFO	▶ [DATABASE] 124 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [80 9 262144] - 247.266µs
2024-09-01T12:56:05.320287302Z: INFO	▶ [DATABASE] 125 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [80 12 4.294967296e+09] - 247.083µs
2024-09-01T12:56:05.320565548Z: INFO	▶ [DATABASE] 126 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [81 9 327680] - 251.222µs
2024-09-01T12:56:05.320834964Z: INFO	▶ [DATABASE] 127 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [81 12 327680] - 249.19µs
2024-09-01T12:56:05.321117877Z: INFO	▶ [DATABASE] 128 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [82 9 393216] - 262.427µs
2024-09-01T12:56:05.321382967Z: INFO	▶ [DATABASE] 129 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [82 12 393216] - 243.962µs
2024-09-01T12:56:05.321656051Z: INFO	▶ [DATABASE] 12a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [83 9 458752] - 250.297µs
2024-09-01T12:56:05.321921555Z: INFO	▶ [DATABASE] 12b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [83 12 458752] - 245.568µs
2024-09-01T12:56:05.322190322Z: INFO	▶ [DATABASE] 12c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [84 9 524288] - 247.231µs
2024-09-01T12:56:05.322455678Z: INFO	▶ [DATABASE] 12d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [84 12 524288] - 245.223µs
2024-09-01T12:56:05.32277271Z: INFO	▶ [DATABASE] 12e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [85 9 589824] - 295.256µs
2024-09-01T12:56:05.323044541Z: INFO	▶ [DATABASE] 12f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [85 12 589824] - 248.636µs
2024-09-01T12:56:05.323312544Z: INFO	▶ [DATABASE] 130 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [86 9 655360] - 247.46µs
2024-09-01T12:56:05.323581597Z: INFO	▶ [DATABASE] 131 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [86 12 655360] - 248.965µs
2024-09-01T12:56:05.323874142Z: INFO	▶ [DATABASE] 132 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [87 25 4.653056e+06] - 272.239µs
2024-09-01T12:56:05.324147604Z: INFO	▶ [DATABASE] 133 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [87 28 4.653056e+06] - 250.235µs
2024-09-01T12:56:05.324425759Z: INFO	▶ [DATABASE] 134 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [88 9 720896] - 257.515µs
2024-09-01T12:56:05.324690671Z: INFO	▶ [DATABASE] 135 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [88 12 4.295098368e+09] - 244.887µs
2024-09-01T12:56:05.324995789Z: INFO	▶ [DATABASE] 136 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [90 21 65536] - 282.458µs
2024-09-01T12:56:05.325277786Z: INFO	▶ [DATABASE] 137 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [90 24 65536] - 260.577µs
2024-09-01T12:56:05.325558617Z: INFO	▶ [DATABASE] 138 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [91 21 131072] - 257.774µs
2024-09-01T12:56:05.325833951Z: INFO	▶ [DATABASE] 139 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [91 24 4.294967296e+09] - 254.782µs
2024-09-01T12:56:05.326108268Z: INFO	▶ [DATABASE] 13a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [92 21 196608] - 253.304µs
2024-09-01T12:56:05.326395298Z: INFO	▶ [DATABASE] 13b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [92 24 196608] - 266.7µs
2024-09-01T12:56:05.326676468Z: INFO	▶ [DATABASE] 13c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [93 21 262144] - 253.767µs
2024-09-01T12:56:05.326962785Z: INFO	▶ [DATABASE] 13d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [93 24 49152] - 255.862µs
2024-09-01T12:56:05.327235928Z: INFO	▶ [DATABASE] 13e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [94 21 327680] - 252.159µs
2024-09-01T12:56:05.327511526Z: INFO	▶ [DATABASE] 13f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [94 24 327680] - 253.758µs
2024-09-01T12:56:05.327784881Z: INFO	▶ [DATABASE] 140 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [95 21 393216] - 251.594µs
2024-09-01T12:56:05.328067712Z: INFO	▶ [DATABASE] 141 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [95 24 393216] - 261.598µs
2024-09-01T12:56:05.328343873Z: INFO	▶ [DATABASE] 142 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [96 21 458752] - 253.41µs
2024-09-01T12:56:05.328615287Z: INFO	▶ [DATABASE] 143 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [96 24 671744] - 250.969µs
2024-09-01T12:56:05.328902854Z: INFO	▶ [DATABASE] 144 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [97 21 524288] - 266.978µs
2024-09-01T12:56:05.329185722Z: INFO	▶ [DATABASE] 145 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [97 24 688128] - 258.638µs
2024-09-01T12:56:05.329461155Z: INFO	▶ [DATABASE] 146 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [98 21 589824] - 251.858µs
2024-09-01T12:56:05.329906001Z: INFO	▶ [DATABASE] 147 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [98 24 4.295032832e+09] - 424.189µs
2024-09-01T12:56:05.330185812Z: INFO	▶ [DATABASE] 148 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [99 21 655360] - 258.874µs
2024-09-01T12:56:05.330464235Z: INFO	▶ [DATABASE] 149 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [99 24 4.295098368e+09] - 256.599µs
2024-09-01T12:56:05.330738414Z: INFO	▶ [DATABASE] 14a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [100 21 720896] - 252.584µs
2024-09-01T12:56:05.33101232Z: INFO	▶ [DATABASE] 14b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [100 24 720896] - 253.419µs
2024-09-01T12:56:05.331293645Z: INFO	▶ [DATABASE] 14c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [16 25 9.857301990819672e+08] - 256.668µs
2024-09-01T12:56:05.331570515Z: INFO	▶ [DATABASE] 14d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [16 28 727040] - 254.745µs
2024-09-01T12:56:05.332113382Z: INFO	▶ [DATABASE] 14e [SQL] ALTER TABLE tasks DROP COLUMN position [] - 518.505µs
2024-09-01T12:56:05.332399839Z: INFO	▶ [DATABASE] 14f [SQL] ALTER TABLE tasks DROP COLUMN kanban_position [] - 269.381µs
2024-09-01T12:56:05.332696382Z: INFO	▶ [DATABASE] 150 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240314214802 ] - 275.049µs
2024-09-01T12:56:05.332987883Z: INFO	▶ [DATABASE] 151 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240315093418] - 260.846µs
2024-09-01T12:56:05.333005972Z: INFO	▶ [DATABASE] 152 Relate buckets to views instead of projects
2024-09-01T12:56:05.333516362Z: INFO	▶ [DATABASE] 153 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 500.673µs
2024-09-01T12:56:05.334381923Z: INFO	▶ [DATABASE] 154 [SQL] CREATE TABLE IF NOT EXISTS "public"."buckets" ("id" BIGSERIAL NOT NULL, "project_id" BIGINT NOT NULL, "project_view_id" BIGINT DEFAULT 0 NOT NULL);  [] - 801.206µs
2024-09-01T12:56:05.33463373Z: INFO	▶ [DATABASE] 155 [SQL] SELECT "id", "project_id", "project_view_id" FROM "buckets" [] - 225.878µs
standard.log 
2024-09-01T12:56:05.197117275Z: INFO	▶ config/InitConfig 001 No config file found, using default or config from environment variables.
2024-09-01T12:56:05.197205486Z: INFO	▶ migration/Migrate 002 Running migrations…
2024-09-01T12:56:05.334655023Z: CRITICAL	▶ migration/Migrate 156 Migration failed: migration 20240315093418 failed: pq: column "project_view_id" does not exist
2024-09-01T12:56:05.80906064Z: INFO	▶ config/InitConfig 001 No config file found, using default or config from environment variables.
@SeiyaGame commented on GitHub (Sep 1, 2024): Sorry for my late response I've tried to retrieve as many logs as possible, but I've only got these two, and I don't think they're very informative. ```yaml vikunja_app: image: vikunja/vikunja:latest container_name: vikunja_app depends_on: vikunja_db: condition: service_healthy environment: ... - VIKUNJA_LOG_LEVEL=debug - VIKUNJA_LOG_DATABASE=file - VIKUNJA_LOG_DATABASELEVEL=debug - VIKUNJA_LOG_STANDARD=file - VIKUNJA_LOG_EVENTS=file - VIKUNJA_LOG_EVENTSLEVEL=debug - VIKUNJA_LOG_HTTP=file - VIKUNJA_LOG_PATH=/logs ... ports: - 3456:3456 volumes: - ./files:/app/vikunja/files - ./logs:/logs ``` <details> <summary>database.log</summary> ``` 2024-09-01T12:56:05.205920838Z: INFO ▶ [DATABASE] 003 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 8.44359ms 2024-09-01T12:56:05.21777771Z: INFO ▶ [DATABASE] 004 [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description, CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey, CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= s.table_schema AND c.relkind = 'r' AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [migration public] - 11.431989ms 2024-09-01T12:56:05.219248997Z: INFO ▶ [DATABASE] 005 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [migration public] - 1.388062ms 2024-09-01T12:56:05.219904883Z: INFO ▶ [DATABASE] 006 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [SCHEMA_INIT] - 593.389µs 2024-09-01T12:56:05.220154118Z: INFO ▶ [DATABASE] 007 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190324205606] - 216.451µs 2024-09-01T12:56:05.220445915Z: INFO ▶ [DATABASE] 008 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190328074430] - 264.966µs 2024-09-01T12:56:05.220898535Z: INFO ▶ [DATABASE] 009 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190430111111] - 256.186µs 2024-09-01T12:56:05.221168103Z: INFO ▶ [DATABASE] 00a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190511202210] - 240.227µs 2024-09-01T12:56:05.221400503Z: INFO ▶ [DATABASE] 00b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190514192749] - 206.913µs 2024-09-01T12:56:05.221624707Z: INFO ▶ [DATABASE] 00c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190524205441] - 199.591µs 2024-09-01T12:56:05.221853011Z: INFO ▶ [DATABASE] 00d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190718200716] - 203.434µs 2024-09-01T12:56:05.222079714Z: INFO ▶ [DATABASE] 00e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190818210133] - 201.653µs 2024-09-01T12:56:05.222299757Z: INFO ▶ [DATABASE] 00f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190920185205] - 195.543µs 2024-09-01T12:56:05.222517963Z: INFO ▶ [DATABASE] 010 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20190922205826] - 193.633µs 2024-09-01T12:56:05.222748445Z: INFO ▶ [DATABASE] 011 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191008194238] - 195.825µs 2024-09-01T12:56:05.222981055Z: INFO ▶ [DATABASE] 012 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191010131430] - 199.514µs 2024-09-01T12:56:05.223199503Z: INFO ▶ [DATABASE] 013 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191207204427] - 192.656µs 2024-09-01T12:56:05.223422406Z: INFO ▶ [DATABASE] 014 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20191207220736] - 195.279µs 2024-09-01T12:56:05.223651593Z: INFO ▶ [DATABASE] 015 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200120201756] - 196.627µs 2024-09-01T12:56:05.223870999Z: INFO ▶ [DATABASE] 016 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200219183248] - 193.896µs 2024-09-01T12:56:05.22409128Z: INFO ▶ [DATABASE] 017 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200308205855] - 195.757µs 2024-09-01T12:56:05.224314113Z: INFO ▶ [DATABASE] 018 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200308210130] - 198.039µs 2024-09-01T12:56:05.224559736Z: INFO ▶ [DATABASE] 019 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200322214440] - 199.294µs 2024-09-01T12:56:05.224777565Z: INFO ▶ [DATABASE] 01a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200322214624] - 193.027µs 2024-09-01T12:56:05.225007449Z: INFO ▶ [DATABASE] 01b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200417175201] - 205.098µs 2024-09-01T12:56:05.225231741Z: INFO ▶ [DATABASE] 01c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200418230432] - 198.477µs 2024-09-01T12:56:05.225454826Z: INFO ▶ [DATABASE] 01d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200418230605] - 198.869µs 2024-09-01T12:56:05.225684417Z: INFO ▶ [DATABASE] 01e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200420215928] - 195.921µs 2024-09-01T12:56:05.2259371Z: INFO ▶ [DATABASE] 01f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200425182634] - 227.118µs 2024-09-01T12:56:05.226170765Z: INFO ▶ [DATABASE] 020 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200509103709] - 205.333µs 2024-09-01T12:56:05.226386358Z: INFO ▶ [DATABASE] 021 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200515172220] - 191.244µs 2024-09-01T12:56:05.226607455Z: INFO ▶ [DATABASE] 022 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200515195546] - 194.364µs 2024-09-01T12:56:05.226826751Z: INFO ▶ [DATABASE] 023 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200516123847] - 194.612µs 2024-09-01T12:56:05.227045233Z: INFO ▶ [DATABASE] 024 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200524221534] - 194.01µs 2024-09-01T12:56:05.227265831Z: INFO ▶ [DATABASE] 025 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200524224611] - 196.001µs 2024-09-01T12:56:05.227489261Z: INFO ▶ [DATABASE] 026 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200614113230] - 198.823µs 2024-09-01T12:56:05.227729676Z: INFO ▶ [DATABASE] 027 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200621214452] - 197.73µs 2024-09-01T12:56:05.227971182Z: INFO ▶ [DATABASE] 028 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200801183357] - 213.518µs 2024-09-01T12:56:05.228205124Z: INFO ▶ [DATABASE] 029 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200904101559] - 205.575µs 2024-09-01T12:56:05.228431583Z: INFO ▶ [DATABASE] 02a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200905151040] - 198.808µs 2024-09-01T12:56:05.228651763Z: INFO ▶ [DATABASE] 02b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200905232458] - 195.265µs 2024-09-01T12:56:05.228879503Z: INFO ▶ [DATABASE] 02c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20200906184746] - 203.012µs 2024-09-01T12:56:05.229186687Z: INFO ▶ [DATABASE] 02d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201025195822] - 279.394µs 2024-09-01T12:56:05.231779949Z: INFO ▶ [DATABASE] 02e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201121181647] - 2.539089ms 2024-09-01T12:56:05.232066605Z: INFO ▶ [DATABASE] 02f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201218152741] - 250.352µs 2024-09-01T12:56:05.232313359Z: INFO ▶ [DATABASE] 030 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201218220204] - 216.994µs 2024-09-01T12:56:05.232549395Z: INFO ▶ [DATABASE] 031 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20201219145028] - 204.274µs 2024-09-01T12:56:05.232773794Z: INFO ▶ [DATABASE] 032 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210207192805] - 199.165µs 2024-09-01T12:56:05.233006893Z: INFO ▶ [DATABASE] 033 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210209204715] - 206.903µs 2024-09-01T12:56:05.233230447Z: INFO ▶ [DATABASE] 034 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210220222121] - 197.812µs 2024-09-01T12:56:05.233459119Z: INFO ▶ [DATABASE] 035 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210221111953] - 197.974µs 2024-09-01T12:56:05.233680318Z: INFO ▶ [DATABASE] 036 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210321185225] - 195.616µs 2024-09-01T12:56:05.233903073Z: INFO ▶ [DATABASE] 037 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210328191017] - 198.745µs 2024-09-01T12:56:05.234127613Z: INFO ▶ [DATABASE] 038 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210403145503] - 197.725µs 2024-09-01T12:56:05.234350354Z: INFO ▶ [DATABASE] 039 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210403220653] - 198.335µs 2024-09-01T12:56:05.234579157Z: INFO ▶ [DATABASE] 03a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210407170753] - 196.937µs 2024-09-01T12:56:05.23480794Z: INFO ▶ [DATABASE] 03b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210411113105] - 204.438µs 2024-09-01T12:56:05.235036362Z: INFO ▶ [DATABASE] 03c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210411161337] - 203.265µs 2024-09-01T12:56:05.235255018Z: INFO ▶ [DATABASE] 03d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210413131057] - 194.361µs 2024-09-01T12:56:05.235478651Z: INFO ▶ [DATABASE] 03e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210527105701] - 198.608µs 2024-09-01T12:56:05.235696782Z: INFO ▶ [DATABASE] 03f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210603174608] - 194.064µs 2024-09-01T12:56:05.235924475Z: INFO ▶ [DATABASE] 040 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210709191101] - 199.622µs 2024-09-01T12:56:05.236145506Z: INFO ▶ [DATABASE] 041 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210709211508] - 195.637µs 2024-09-01T12:56:05.236372659Z: INFO ▶ [DATABASE] 042 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210711173657] - 195.709µs 2024-09-01T12:56:05.236589761Z: INFO ▶ [DATABASE] 043 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210713213622] - 192.638µs 2024-09-01T12:56:05.236806949Z: INFO ▶ [DATABASE] 044 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210725153703] - 193.512µs 2024-09-01T12:56:05.237042767Z: INFO ▶ [DATABASE] 045 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210727204942] - 212.178µs 2024-09-01T12:56:05.237263029Z: INFO ▶ [DATABASE] 046 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210727211037] - 194.866µs 2024-09-01T12:56:05.2374804Z: INFO ▶ [DATABASE] 047 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210729142940] - 193.515µs 2024-09-01T12:56:05.237698514Z: INFO ▶ [DATABASE] 048 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210802081716] - 193.127µs 2024-09-01T12:56:05.237915766Z: INFO ▶ [DATABASE] 049 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20210829194722] - 193.393µs 2024-09-01T12:56:05.238146445Z: INFO ▶ [DATABASE] 04a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20211212151642] - 204.679µs 2024-09-01T12:56:05.238366124Z: INFO ▶ [DATABASE] 04b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20211212210054] - 195.347µs 2024-09-01T12:56:05.238588728Z: INFO ▶ [DATABASE] 04c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20220112211537] - 197.456µs 2024-09-01T12:56:05.238808697Z: INFO ▶ [DATABASE] 04d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20220616145228] - 194.212µs 2024-09-01T12:56:05.239026274Z: INFO ▶ [DATABASE] 04e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20220815200851] - 193.671µs 2024-09-01T12:56:05.23924555Z: INFO ▶ [DATABASE] 04f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20221002120521] - 195.136µs 2024-09-01T12:56:05.239462785Z: INFO ▶ [DATABASE] 050 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20221113170740] - 193.232µs 2024-09-01T12:56:05.239688459Z: INFO ▶ [DATABASE] 051 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20221228112131] - 193.698µs 2024-09-01T12:56:05.239905055Z: INFO ▶ [DATABASE] 052 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230104152903] - 192.771µs 2024-09-01T12:56:05.239918521Z: INFO ▶ [DATABASE] 053 Adding OidcID to teams 2024-09-01T12:56:05.240427696Z: INFO ▶ [DATABASE] 054 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 497.13µs 2024-09-01T12:56:05.241580783Z: INFO ▶ [DATABASE] 055 [SQL] CREATE TABLE IF NOT EXISTS "public"."teams" ("oidc_id" VARCHAR(250) NULL); [] - 1.098384ms 2024-09-01T12:56:05.241946088Z: INFO ▶ [DATABASE] 056 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20230104152903 ] - 336.941µs 2024-09-01T12:56:05.242193863Z: INFO ▶ [DATABASE] 057 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230307171848] - 222.793µs 2024-09-01T12:56:05.242426574Z: INFO ▶ [DATABASE] 058 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230611170341] - 207.4µs 2024-09-01T12:56:05.242652957Z: INFO ▶ [DATABASE] 059 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230824132533] - 202.033µs 2024-09-01T12:56:05.242886671Z: INFO ▶ [DATABASE] 05a [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230828125443] - 209.63µs 2024-09-01T12:56:05.243108193Z: INFO ▶ [DATABASE] 05b [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230831155832] - 197.348µs 2024-09-01T12:56:05.243328023Z: INFO ▶ [DATABASE] 05c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230903143017] - 194.788µs 2024-09-01T12:56:05.243546673Z: INFO ▶ [DATABASE] 05d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20230913202615] - 194.92µs 2024-09-01T12:56:05.243764724Z: INFO ▶ [DATABASE] 05e [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20231022144641] - 194.142µs 2024-09-01T12:56:05.243980641Z: INFO ▶ [DATABASE] 05f [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20231108231513] - 192.219µs 2024-09-01T12:56:05.244200442Z: INFO ▶ [DATABASE] 060 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20231121191822] - 195.779µs 2024-09-01T12:56:05.244215426Z: INFO ▶ [DATABASE] 061 Migrate saved filter structure 2024-09-01T12:56:05.244609391Z: INFO ▶ [DATABASE] 062 [SQL] SELECT "id", "filters" FROM "saved_filters" [] - 356.815µs 2024-09-01T12:56:05.244935293Z: INFO ▶ [DATABASE] 063 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20231121191822 ] - 285.527µs 2024-09-01T12:56:05.24517198Z: INFO ▶ [DATABASE] 064 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240114224713] - 212.219µs 2024-09-01T12:56:05.24539969Z: INFO ▶ [DATABASE] 065 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240304153738] - 203.108µs 2024-09-01T12:56:05.245415233Z: INFO ▶ [DATABASE] 066 Add issuer column to teams to track the OIDC provider this issue has bene created by 2024-09-01T12:56:05.245898887Z: INFO ▶ [DATABASE] 067 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 475.641µs 2024-09-01T12:56:05.251350925Z: INFO ▶ [DATABASE] 068 [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description, CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey, CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= s.table_schema AND c.relkind = 'r' AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [teams public] - 5.415557ms 2024-09-01T12:56:05.252119439Z: INFO ▶ [DATABASE] 069 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [teams public] - 720.314µs 2024-09-01T12:56:05.253627624Z: INFO ▶ [DATABASE] 06a [SQL] ALTER TABLE "public"."teams" ADD "issuer" TEXT NULL; COMMENT ON COLUMN "public"."teams"."issuer" IS '' [] - 1.481145ms 2024-09-01T12:56:05.253962985Z: INFO ▶ [DATABASE] 06b [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240304153738 ] - 303.675µs 2024-09-01T12:56:05.254221046Z: INFO ▶ [DATABASE] 06c [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240309111148] - 228.26µs 2024-09-01T12:56:05.254235247Z: INFO ▶ [DATABASE] 06d Add IsPublic field to teams table to control discoverability of teams. 2024-09-01T12:56:05.254728276Z: INFO ▶ [DATABASE] 06e [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 482.083µs 2024-09-01T12:56:05.259110275Z: INFO ▶ [DATABASE] 06f [SQL] SELECT column_name, column_default, is_nullable, data_type, character_maximum_length, description, CASE WHEN p.contype = 'p' THEN true ELSE false END AS primarykey, CASE WHEN p.contype = 'u' THEN true ELSE false END AS uniquekey FROM pg_attribute f JOIN pg_class c ON c.oid = f.attrelid JOIN pg_type t ON t.oid = f.atttypid LEFT JOIN pg_attrdef d ON d.adrelid = c.oid AND d.adnum = f.attnum LEFT JOIN pg_description de ON f.attrelid=de.objoid AND f.attnum=de.objsubid LEFT JOIN pg_namespace n ON n.oid = c.relnamespace LEFT JOIN pg_constraint p ON p.conrelid = c.oid AND f.attnum = ANY (p.conkey) LEFT JOIN pg_class AS g ON p.confrelid = g.oid LEFT JOIN INFORMATION_SCHEMA.COLUMNS s ON s.column_name=f.attname AND c.relname=s.table_name WHERE n.nspname= s.table_schema AND c.relkind = 'r' AND c.relname = $1 AND s.table_schema = $2 AND f.attnum > 0 ORDER BY f.attnum; [teams public] - 4.350782ms 2024-09-01T12:56:05.259837992Z: INFO ▶ [DATABASE] 070 [SQL] SELECT indexname, indexdef FROM pg_indexes WHERE tablename=$1 AND schemaname=$2 [teams public] - 697.57µs 2024-09-01T12:56:05.260345012Z: INFO ▶ [DATABASE] 071 [SQL] ALTER TABLE "public"."teams" ADD "is_public" BOOL DEFAULT false NOT NULL; COMMENT ON COLUMN "public"."teams"."is_public" IS '' [] - 484.445µs 2024-09-01T12:56:05.260660112Z: INFO ▶ [DATABASE] 072 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240309111148 ] - 285.741µs 2024-09-01T12:56:05.260930319Z: INFO ▶ [DATABASE] 073 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240311173251] - 241.186µs 2024-09-01T12:56:05.260945699Z: INFO ▶ [DATABASE] 074 Create reactions table 2024-09-01T12:56:05.261439118Z: INFO ▶ [DATABASE] 075 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 484.949µs 2024-09-01T12:56:05.263299058Z: INFO ▶ [DATABASE] 076 [SQL] CREATE TABLE IF NOT EXISTS "public"."reactions" ("id" BIGSERIAL PRIMARY KEY NOT NULL, "user_id" BIGINT NOT NULL, "entity_id" BIGINT NOT NULL, "entity_kind" BIGINT NOT NULL, "value" VARCHAR(20) NOT NULL, "created" TIMESTAMP NOT NULL); [] - 1.789467ms 2024-09-01T12:56:05.264051605Z: INFO ▶ [DATABASE] 077 [SQL] CREATE UNIQUE INDEX "UQE_reactions_id" ON "reactions" ("id") [] - 724.069µs 2024-09-01T12:56:05.264725702Z: INFO ▶ [DATABASE] 078 [SQL] CREATE INDEX "IDX_reactions_entity_id" ON "reactions" ("entity_id") [] - 652.348µs 2024-09-01T12:56:05.265409951Z: INFO ▶ [DATABASE] 079 [SQL] CREATE INDEX "IDX_reactions_entity_kind" ON "reactions" ("entity_kind") [] - 670.999µs 2024-09-01T12:56:05.266095116Z: INFO ▶ [DATABASE] 07a [SQL] CREATE INDEX "IDX_reactions_value" ON "reactions" ("value") [] - 671.679µs 2024-09-01T12:56:05.266741729Z: INFO ▶ [DATABASE] 07b [SQL] CREATE INDEX "IDX_reactions_user_id" ON "reactions" ("user_id") [] - 633.66µs 2024-09-01T12:56:05.267061312Z: INFO ▶ [DATABASE] 07c [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240311173251 ] - 283.895µs 2024-09-01T12:56:05.267322125Z: INFO ▶ [DATABASE] 07d [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240313230538] - 228.443µs 2024-09-01T12:56:05.267338493Z: INFO ▶ [DATABASE] 07e Add project views table 2024-09-01T12:56:05.267825486Z: INFO ▶ [DATABASE] 07f [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 478.524µs 2024-09-01T12:56:05.270170901Z: INFO ▶ [DATABASE] 080 [SQL] CREATE TABLE IF NOT EXISTS "public"."project_views" ("id" BIGSERIAL PRIMARY KEY NOT NULL, "title" VARCHAR(255) NOT NULL, "project_id" BIGINT NOT NULL, "view_kind" INTEGER NOT NULL, "filter" TEXT DEFAULT null NULL, "position" DOUBLE PRECISION NULL, "bucket_configuration_mode" INTEGER DEFAULT 0 NULL, "bucket_configuration" JSON NULL, "updated" TIMESTAMP NOT NULL, "created" TIMESTAMP NOT NULL); [] - 2.261622ms 2024-09-01T12:56:05.270897183Z: INFO ▶ [DATABASE] 081 [SQL] CREATE UNIQUE INDEX "UQE_project_views_id" ON "project_views" ("id") [] - 699.587µs 2024-09-01T12:56:05.271566542Z: INFO ▶ [DATABASE] 082 [SQL] CREATE INDEX "IDX_project_views_project_id" ON "project_views" ("project_id") [] - 651.756µs 2024-09-01T12:56:05.27193682Z: INFO ▶ [DATABASE] 083 [SQL] SELECT "id" FROM "projects" [] - 335.588µs 2024-09-01T12:56:05.27265662Z: INFO ▶ [DATABASE] 084 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 3 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 608.447µs 2024-09-01T12:56:05.273030355Z: INFO ▶ [DATABASE] 085 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 3 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 330.307µs 2024-09-01T12:56:05.27336714Z: INFO ▶ [DATABASE] 086 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 3 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 298.233µs 2024-09-01T12:56:05.273696804Z: INFO ▶ [DATABASE] 087 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 3 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 290.507µs 2024-09-01T12:56:05.274018781Z: INFO ▶ [DATABASE] 088 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 4 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 285.823µs 2024-09-01T12:56:05.274342808Z: INFO ▶ [DATABASE] 089 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 4 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 287.515µs 2024-09-01T12:56:05.274665706Z: INFO ▶ [DATABASE] 08a [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 4 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 281.997µs 2024-09-01T12:56:05.274983151Z: INFO ▶ [DATABASE] 08b [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 4 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 282.547µs 2024-09-01T12:56:05.275305782Z: INFO ▶ [DATABASE] 08c [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 5 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 281.071µs 2024-09-01T12:56:05.275622219Z: INFO ▶ [DATABASE] 08d [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 5 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 281.75µs 2024-09-01T12:56:05.275939731Z: INFO ▶ [DATABASE] 08e [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 5 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 282.828µs 2024-09-01T12:56:05.276272994Z: INFO ▶ [DATABASE] 08f [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 5 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 287.197µs 2024-09-01T12:56:05.27659337Z: INFO ▶ [DATABASE] 090 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 7 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 283.807µs 2024-09-01T12:56:05.27692857Z: INFO ▶ [DATABASE] 091 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 7 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 294.681µs 2024-09-01T12:56:05.277253956Z: INFO ▶ [DATABASE] 092 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 7 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 287.382µs 2024-09-01T12:56:05.277688901Z: INFO ▶ [DATABASE] 093 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 7 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 399.307µs 2024-09-01T12:56:05.278074606Z: INFO ▶ [DATABASE] 094 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 8 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 343.333µs 2024-09-01T12:56:05.278433164Z: INFO ▶ [DATABASE] 095 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 8 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 295.517µs 2024-09-01T12:56:05.278783772Z: INFO ▶ [DATABASE] 096 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 8 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 308.605µs 2024-09-01T12:56:05.279123613Z: INFO ▶ [DATABASE] 097 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 8 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 301.378µs 2024-09-01T12:56:05.27949864Z: INFO ▶ [DATABASE] 098 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 9 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 326.526µs 2024-09-01T12:56:05.279820833Z: INFO ▶ [DATABASE] 099 [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 9 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 282.378µs 2024-09-01T12:56:05.280146288Z: INFO ▶ [DATABASE] 09a [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 9 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 288.24µs 2024-09-01T12:56:05.280463326Z: INFO ▶ [DATABASE] 09b [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 9 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 280.158µs 2024-09-01T12:56:05.280776257Z: INFO ▶ [DATABASE] 09c [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [List 1 0 100 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 277.188µs 2024-09-01T12:56:05.281115505Z: INFO ▶ [DATABASE] 09d [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Gantt 1 1 200 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 302.934µs 2024-09-01T12:56:05.281450982Z: INFO ▶ [DATABASE] 09e [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Table 1 2 300 0 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 286.674µs 2024-09-01T12:56:05.281767056Z: INFO ▶ [DATABASE] 09f [SQL] INSERT INTO "project_views" ("title","project_id","view_kind","filter","position","bucket_configuration_mode","bucket_configuration","updated","created") VALUES ($1,$2,$3,$4,$5,$6,$7,$8,$9) RETURNING "id" [Kanban 1 3 400 1 null 2024-09-01 12:56:05 2024-09-01 12:56:05] - 278.371µs 2024-09-01T12:56:05.281959937Z: INFO ▶ [DATABASE] 0a0 [SQL] SELECT "id" FROM "saved_filters" [] - 139.628µs 2024-09-01T12:56:05.282261458Z: INFO ▶ [DATABASE] 0a1 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240313230538 ] - 261.894µs 2024-09-01T12:56:05.28251487Z: INFO ▶ [DATABASE] 0a2 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240314214802] - 224.714µs 2024-09-01T12:56:05.282529469Z: INFO ▶ [DATABASE] 0a3 make task position separate 2024-09-01T12:56:05.283036131Z: INFO ▶ [DATABASE] 0a4 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 497.985µs 2024-09-01T12:56:05.2835467Z: INFO ▶ [DATABASE] 0a5 [SQL] CREATE TABLE IF NOT EXISTS "public"."task_positions" ("task_id" BIGINT NOT NULL, "project_view_id" BIGINT NOT NULL, "position" DOUBLE PRECISION NOT NULL); [] - 467.699µs 2024-09-01T12:56:05.284337802Z: INFO ▶ [DATABASE] 0a6 [SQL] CREATE INDEX "IDX_task_positions_task_id" ON "task_positions" ("task_id") [] - 770.47µs 2024-09-01T12:56:05.285045356Z: INFO ▶ [DATABASE] 0a7 [SQL] CREATE INDEX "IDX_task_positions_project_view_id" ON "task_positions" ("project_view_id") [] - 685.918µs 2024-09-01T12:56:05.285452406Z: INFO ▶ [DATABASE] 0a8 [SQL] SELECT "id", "project_id", "position", "kanban_position" FROM "tasks" [] - 364.299µs 2024-09-01T12:56:05.285898604Z: INFO ▶ [DATABASE] 0a9 [SQL] SELECT "id", "title", "project_id", "view_kind", "filter", "position", "bucket_configuration_mode", "bucket_configuration", "updated", "created" FROM "project_views" [] - 162.109µs 2024-09-01T12:56:05.286727303Z: INFO ▶ [DATABASE] 0aa [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [1 25 7.040929993442623e+07] - 514.099µs 2024-09-01T12:56:05.287066681Z: INFO ▶ [DATABASE] 0ab [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [1 28 8.947848533333333e+07] - 311.293µs 2024-09-01T12:56:05.287356291Z: INFO ▶ [DATABASE] 0ac [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [2 25 1.4081859986885247e+08] - 265.04µs 2024-09-01T12:56:05.287629159Z: INFO ▶ [DATABASE] 0ad [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [2 28 1.7895697066666666e+08] - 250.533µs 2024-09-01T12:56:05.287901806Z: INFO ▶ [DATABASE] 0ae [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [3 25 2.1122789980327868e+08] - 251.14µs 2024-09-01T12:56:05.288193761Z: INFO ▶ [DATABASE] 0af [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [3 28 0] - 266.383µs 2024-09-01T12:56:05.288464138Z: INFO ▶ [DATABASE] 0b0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [4 25 2.8163719973770493e+08] - 249.449µs 2024-09-01T12:56:05.28873051Z: INFO ▶ [DATABASE] 0b1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [4 28 2.68435456e+08] - 245.849µs 2024-09-01T12:56:05.289026329Z: INFO ▶ [DATABASE] 0b2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [6 25 3.520464996721312e+08] - 274.947µs 2024-09-01T12:56:05.289300077Z: INFO ▶ [DATABASE] 0b3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [6 28 4.2054888106666665e+09] - 250.823µs 2024-09-01T12:56:05.289569434Z: INFO ▶ [DATABASE] 0b4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [7 25 4.2245579960655737e+08] - 248.53µs 2024-09-01T12:56:05.289839586Z: INFO ▶ [DATABASE] 0b5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [7 28 4.294967296e+09] - 249.412µs 2024-09-01T12:56:05.290112484Z: INFO ▶ [DATABASE] 0b6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [8 25 4.928650995409836e+08] - 252.282µs 2024-09-01T12:56:05.290393685Z: INFO ▶ [DATABASE] 0b7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [8 28 4.02653184e+09] - 260.09µs 2024-09-01T12:56:05.290663233Z: INFO ▶ [DATABASE] 0b8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [9 25 5.632743994754099e+08] - 247.77µs 2024-09-01T12:56:05.290932575Z: INFO ▶ [DATABASE] 0b9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [9 28 3.847574869333333e+09] - 247.219µs 2024-09-01T12:56:05.291206392Z: INFO ▶ [DATABASE] 0ba [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [10 25 6.33683699409836e+08] - 250.427µs 2024-09-01T12:56:05.291472162Z: INFO ▶ [DATABASE] 0bb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [10 28 3.489660928e+09] - 245.802µs 2024-09-01T12:56:05.291738919Z: INFO ▶ [DATABASE] 0bc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [12 25 7.040929993442624e+08] - 246.331µs 2024-09-01T12:56:05.292012083Z: INFO ▶ [DATABASE] 0bd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [12 28 3.579139413333333e+09] - 246.839µs 2024-09-01T12:56:05.292297377Z: INFO ▶ [DATABASE] 0be [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [13 25 7.745022992786885e+08] - 250.266µs 2024-09-01T12:56:05.292573431Z: INFO ▶ [DATABASE] 0bf [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [13 28 3.579139413333333e+08] - 248.805µs 2024-09-01T12:56:05.292841205Z: INFO ▶ [DATABASE] 0c0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [14 25 8.449115992131147e+08] - 247.332µs 2024-09-01T12:56:05.293119101Z: INFO ▶ [DATABASE] 0c1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [14 28 1.2288e+06] - 249.057µs 2024-09-01T12:56:05.29339212Z: INFO ▶ [DATABASE] 0c2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [15 25 9.15320899147541e+08] - 250.264µs 2024-09-01T12:56:05.293660323Z: INFO ▶ [DATABASE] 0c3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [15 28 4.473924266666666e+08] - 247.419µs 2024-09-01T12:56:05.293934047Z: INFO ▶ [DATABASE] 0c4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [17 1 65536] - 252.879µs 2024-09-01T12:56:05.294202849Z: INFO ▶ [DATABASE] 0c5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [17 4 0] - 248.336µs 2024-09-01T12:56:05.294473911Z: INFO ▶ [DATABASE] 0c6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [19 25 1.1265487989508197e+09] - 248.536µs 2024-09-01T12:56:05.294740888Z: INFO ▶ [DATABASE] 0c7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [19 28 983040] - 245.198µs 2024-09-01T12:56:05.295011094Z: INFO ▶ [DATABASE] 0c8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [21 25 1.267367398819672e+09] - 248.335µs 2024-09-01T12:56:05.295294446Z: INFO ▶ [DATABASE] 0c9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [21 28 3.4001824426666665e+09] - 262.675µs 2024-09-01T12:56:05.2955636Z: INFO ▶ [DATABASE] 0ca [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [22 25 1.3377766987540984e+09] - 248.553µs 2024-09-01T12:56:05.295831337Z: INFO ▶ [DATABASE] 0cb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [22 28 3.6686178986666665e+09] - 246.001µs 2024-09-01T12:56:05.2960996Z: INFO ▶ [DATABASE] 0cc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [23 25 1.4081859986885247e+09] - 246.957µs 2024-09-01T12:56:05.296369633Z: INFO ▶ [DATABASE] 0cd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [23 28 1.14688e+06] - 248.472µs 2024-09-01T12:56:05.296641578Z: INFO ▶ [DATABASE] 0ce [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [24 25 1.4785952986229508e+09] - 251.62µs 2024-09-01T12:56:05.296932398Z: INFO ▶ [DATABASE] 0cf [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [24 28 3.758096384e+09] - 268.593µs 2024-09-01T12:56:05.297205716Z: INFO ▶ [DATABASE] 0d0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [25 25 1.549004598557377e+09] - 251.991µs 2024-09-01T12:56:05.297473645Z: INFO ▶ [DATABASE] 0d1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [25 28 5.36870912e+08] - 245.822µs 2024-09-01T12:56:05.29775502Z: INFO ▶ [DATABASE] 0d2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [26 25 1.6194138984918034e+09] - 248.403µs 2024-09-01T12:56:05.298030018Z: INFO ▶ [DATABASE] 0d3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [26 28 4.116010325333333e+09] - 250.354µs 2024-09-01T12:56:05.298296506Z: INFO ▶ [DATABASE] 0d4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [27 25 1.6898231984262295e+09] - 246.13µs 2024-09-01T12:56:05.29856192Z: INFO ▶ [DATABASE] 0d5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [27 28 1.114112e+06] - 245.148µs 2024-09-01T12:56:05.298831057Z: INFO ▶ [DATABASE] 0d6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [28 25 1.7602324983606558e+09] - 247.406µs 2024-09-01T12:56:05.299096453Z: INFO ▶ [DATABASE] 0d7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [28 28 3.9370533546666665e+09] - 245.126µs 2024-09-01T12:56:05.299377541Z: INFO ▶ [DATABASE] 0d8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [29 1 1.179648e+06] - 260.591µs 2024-09-01T12:56:05.299644651Z: INFO ▶ [DATABASE] 0d9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [29 4 1.179648e+06] - 246.987µs 2024-09-01T12:56:05.299907Z: INFO ▶ [DATABASE] 0da [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [30 25 1.830641798295082e+09] - 242.148µs 2024-09-01T12:56:05.300172606Z: INFO ▶ [DATABASE] 0db [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [30 28 6.263493973333333e+08] - 245.304µs 2024-09-01T12:56:05.300443038Z: INFO ▶ [DATABASE] 0dc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [31 25 1.9010510982295084e+09] - 248.853µs 2024-09-01T12:56:05.300708672Z: INFO ▶ [DATABASE] 0dd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [31 28 7.158278826666666e+08] - 244.039µs 2024-09-01T12:56:05.300995209Z: INFO ▶ [DATABASE] 0de [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [32 25 1.9714603981639345e+09] - 266.234µs 2024-09-01T12:56:05.301266055Z: INFO ▶ [DATABASE] 0df [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [32 28 8.05306368e+08] - 248.253µs 2024-09-01T12:56:05.301531841Z: INFO ▶ [DATABASE] 0e0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [33 25 2.0418696980983608e+09] - 243.926µs 2024-09-01T12:56:05.301796449Z: INFO ▶ [DATABASE] 0e1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [33 28 8.947848533333333e+08] - 243.202µs 2024-09-01T12:56:05.302063904Z: INFO ▶ [DATABASE] 0e2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [35 25 2.112278998032787e+09] - 247.182µs 2024-09-01T12:56:05.302330165Z: INFO ▶ [DATABASE] 0e3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [35 28 9.842633386666666e+08] - 245.999µs 2024-09-01T12:56:05.302601448Z: INFO ▶ [DATABASE] 0e4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [37 25 2.2530975979016395e+09] - 249.59µs 2024-09-01T12:56:05.302864863Z: INFO ▶ [DATABASE] 0e5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [37 28 1.073741824e+09] - 243.12µs 2024-09-01T12:56:05.303135884Z: INFO ▶ [DATABASE] 0e6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [40 25 2.393916197770492e+09] - 250.468µs 2024-09-01T12:56:05.303408665Z: INFO ▶ [DATABASE] 0e7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [40 28 1.1632203093333333e+09] - 245.461µs 2024-09-01T12:56:05.303702007Z: INFO ▶ [DATABASE] 0e8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [41 25 2.4643254977049184e+09] - 272.669µs 2024-09-01T12:56:05.303971999Z: INFO ▶ [DATABASE] 0e9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [41 28 1.2526987946666665e+09] - 248.566µs 2024-09-01T12:56:05.304241546Z: INFO ▶ [DATABASE] 0ea [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [42 25 2.534734797639344e+09] - 249.082µs 2024-09-01T12:56:05.304509396Z: INFO ▶ [DATABASE] 0eb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [42 28 1.34217728e+09] - 247.229µs 2024-09-01T12:56:05.304783472Z: INFO ▶ [DATABASE] 0ec [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [43 25 2.6051440975737705e+09] - 247.3µs 2024-09-01T12:56:05.305062723Z: INFO ▶ [DATABASE] 0ed [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [43 28 1.4316557653333333e+09] - 258.649µs 2024-09-01T12:56:05.305339837Z: INFO ▶ [DATABASE] 0ee [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [44 25 2.675553397508197e+09] - 255.115µs 2024-09-01T12:56:05.305607339Z: INFO ▶ [DATABASE] 0ef [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [44 28 1.5211342506666665e+09] - 246.928µs 2024-09-01T12:56:05.305875031Z: INFO ▶ [DATABASE] 0f0 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [45 25 2.745962697442623e+09] - 246.954µs 2024-09-01T12:56:05.306143309Z: INFO ▶ [DATABASE] 0f1 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [45 28 1.610612736e+09] - 247.983µs 2024-09-01T12:56:05.306409848Z: INFO ▶ [DATABASE] 0f2 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [46 25 2.8163719973770494e+09] - 243.965µs 2024-09-01T12:56:05.306677533Z: INFO ▶ [DATABASE] 0f3 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [46 28 1.7000912213333333e+09] - 247.218µs 2024-09-01T12:56:05.306948708Z: INFO ▶ [DATABASE] 0f4 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [47 25 2.8867812973114758e+09] - 250.718µs 2024-09-01T12:56:05.307214702Z: INFO ▶ [DATABASE] 0f5 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [47 28 1.7895697066666665e+09] - 244.406µs 2024-09-01T12:56:05.307483155Z: INFO ▶ [DATABASE] 0f6 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [49 25 2.9571905972459016e+09] - 246.867µs 2024-09-01T12:56:05.307747501Z: INFO ▶ [DATABASE] 0f7 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [49 28 2.859008e+06] - 243.864µs 2024-09-01T12:56:05.308017003Z: INFO ▶ [DATABASE] 0f8 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [50 25 3.027599897180328e+09] - 249.157µs 2024-09-01T12:56:05.308304752Z: INFO ▶ [DATABASE] 0f9 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [50 28 1.879048192e+09] - 265.546µs 2024-09-01T12:56:05.308579027Z: INFO ▶ [DATABASE] 0fa [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [51 25 3.098009197114754e+09] - 252.487µs 2024-09-01T12:56:05.308848307Z: INFO ▶ [DATABASE] 0fb [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [51 28 9.842633386666666e+08] - 248.003µs 2024-09-01T12:56:05.309141954Z: INFO ▶ [DATABASE] 0fc [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [52 25 3.1684184970491805e+09] - 256.073µs 2024-09-01T12:56:05.309414179Z: INFO ▶ [DATABASE] 0fd [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [52 28 1.9685266773333333e+09] - 249.728µs 2024-09-01T12:56:05.309685844Z: INFO ▶ [DATABASE] 0fe [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [54 25 3.238827796983607e+09] - 249.223µs 2024-09-01T12:56:05.309955861Z: INFO ▶ [DATABASE] 0ff [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [54 28 2.0580051626666665e+09] - 248.352µs 2024-09-01T12:56:05.310234025Z: INFO ▶ [DATABASE] 100 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [55 25 3.309237096918033e+09] - 252.026µs 2024-09-01T12:56:05.310504624Z: INFO ▶ [DATABASE] 101 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [55 28 2.147483648e+09] - 249.84µs 2024-09-01T12:56:05.310775053Z: INFO ▶ [DATABASE] 102 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [56 25 3.379646396852459e+09] - 250.064µs 2024-09-01T12:56:05.311077818Z: INFO ▶ [DATABASE] 103 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [56 28 2.236962133333333e+09] - 282.194µs 2024-09-01T12:56:05.311354151Z: INFO ▶ [DATABASE] 104 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [57 25 3.4500556967868853e+09] - 252.392µs 2024-09-01T12:56:05.311622375Z: INFO ▶ [DATABASE] 105 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [57 28 2.3264406186666665e+09] - 247.781µs 2024-09-01T12:56:05.311889646Z: INFO ▶ [DATABASE] 106 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [59 25 3.5204649967213116e+09] - 244.092µs 2024-09-01T12:56:05.312157558Z: INFO ▶ [DATABASE] 107 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [59 28 2.415919104e+09] - 247.721µs 2024-09-01T12:56:05.312424789Z: INFO ▶ [DATABASE] 108 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [61 25 3.590874296655738e+09] - 246.845µs 2024-09-01T12:56:05.312694659Z: INFO ▶ [DATABASE] 109 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [61 28 2.505397589333333e+09] - 248.319µs 2024-09-01T12:56:05.312979522Z: INFO ▶ [DATABASE] 10a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [62 25 3.661283596590164e+09] - 263.017µs 2024-09-01T12:56:05.313250917Z: INFO ▶ [DATABASE] 10b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [62 28 2.5948760746666665e+09] - 250.151µs 2024-09-01T12:56:05.31351801Z: INFO ▶ [DATABASE] 10c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [63 25 3.7316928965245905e+09] - 246.012µs 2024-09-01T12:56:05.313786328Z: INFO ▶ [DATABASE] 10d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [63 28 2.68435456e+09] - 247.681µs 2024-09-01T12:56:05.314059739Z: INFO ▶ [DATABASE] 10e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [64 25 3.802102196459017e+09] - 251.166µs 2024-09-01T12:56:05.314325731Z: INFO ▶ [DATABASE] 10f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [64 28 2.773833045333333e+09] - 245.608µs 2024-09-01T12:56:05.314589827Z: INFO ▶ [DATABASE] 110 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [65 25 3.8725114963934426e+09] - 243.664µs 2024-09-01T12:56:05.314871052Z: INFO ▶ [DATABASE] 111 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [65 28 2.8633115306666665e+09] - 255.396µs 2024-09-01T12:56:05.315143027Z: INFO ▶ [DATABASE] 112 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [67 25 3.942920796327869e+09] - 248.647µs 2024-09-01T12:56:05.315409673Z: INFO ▶ [DATABASE] 113 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [67 28 2.952790016e+09] - 246.244µs 2024-09-01T12:56:05.315680026Z: INFO ▶ [DATABASE] 114 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [68 25 4.0133300962622952e+09] - 248.548µs 2024-09-01T12:56:05.315945497Z: INFO ▶ [DATABASE] 115 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [68 28 3.042268501333333e+09] - 244.996µs 2024-09-01T12:56:05.316220126Z: INFO ▶ [DATABASE] 116 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [71 25 4.0837393961967216e+09] - 251.679µs 2024-09-01T12:56:05.316490279Z: INFO ▶ [DATABASE] 117 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [71 28 3.1317469866666665e+09] - 249.333µs 2024-09-01T12:56:05.316755614Z: INFO ▶ [DATABASE] 118 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [72 25 4.154148696131148e+09] - 244.886µs 2024-09-01T12:56:05.317035024Z: INFO ▶ [DATABASE] 119 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [72 28 3.221225472e+09] - 257.755µs 2024-09-01T12:56:05.317323896Z: INFO ▶ [DATABASE] 11a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [73 25 4.224557996065574e+09] - 266.569µs 2024-09-01T12:56:05.317594353Z: INFO ▶ [DATABASE] 11b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [73 28 3.310703957333333e+09] - 249.939µs 2024-09-01T12:56:05.31785928Z: INFO ▶ [DATABASE] 11c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [74 25 4.294967296e+09] - 243.413µs 2024-09-01T12:56:05.31813889Z: INFO ▶ [DATABASE] 11d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [74 28 4.4739242666666664e+07] - 259.286µs 2024-09-01T12:56:05.318412297Z: INFO ▶ [DATABASE] 11e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [77 9 65536] - 250.13µs 2024-09-01T12:56:05.318685314Z: INFO ▶ [DATABASE] 11f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [77 12 4.295032832e+09] - 249.857µs 2024-09-01T12:56:05.318953205Z: INFO ▶ [DATABASE] 120 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [78 9 131072] - 247.49µs 2024-09-01T12:56:05.319217462Z: INFO ▶ [DATABASE] 121 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [78 12 131072] - 243.968µs 2024-09-01T12:56:05.319485575Z: INFO ▶ [DATABASE] 122 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [79 9 196608] - 247.979µs 2024-09-01T12:56:05.319752262Z: INFO ▶ [DATABASE] 123 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [79 12 196608] - 246.15µs 2024-09-01T12:56:05.320019745Z: INFO ▶ [DATABASE] 124 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [80 9 262144] - 247.266µs 2024-09-01T12:56:05.320287302Z: INFO ▶ [DATABASE] 125 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [80 12 4.294967296e+09] - 247.083µs 2024-09-01T12:56:05.320565548Z: INFO ▶ [DATABASE] 126 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [81 9 327680] - 251.222µs 2024-09-01T12:56:05.320834964Z: INFO ▶ [DATABASE] 127 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [81 12 327680] - 249.19µs 2024-09-01T12:56:05.321117877Z: INFO ▶ [DATABASE] 128 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [82 9 393216] - 262.427µs 2024-09-01T12:56:05.321382967Z: INFO ▶ [DATABASE] 129 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [82 12 393216] - 243.962µs 2024-09-01T12:56:05.321656051Z: INFO ▶ [DATABASE] 12a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [83 9 458752] - 250.297µs 2024-09-01T12:56:05.321921555Z: INFO ▶ [DATABASE] 12b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [83 12 458752] - 245.568µs 2024-09-01T12:56:05.322190322Z: INFO ▶ [DATABASE] 12c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [84 9 524288] - 247.231µs 2024-09-01T12:56:05.322455678Z: INFO ▶ [DATABASE] 12d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [84 12 524288] - 245.223µs 2024-09-01T12:56:05.32277271Z: INFO ▶ [DATABASE] 12e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [85 9 589824] - 295.256µs 2024-09-01T12:56:05.323044541Z: INFO ▶ [DATABASE] 12f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [85 12 589824] - 248.636µs 2024-09-01T12:56:05.323312544Z: INFO ▶ [DATABASE] 130 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [86 9 655360] - 247.46µs 2024-09-01T12:56:05.323581597Z: INFO ▶ [DATABASE] 131 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [86 12 655360] - 248.965µs 2024-09-01T12:56:05.323874142Z: INFO ▶ [DATABASE] 132 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [87 25 4.653056e+06] - 272.239µs 2024-09-01T12:56:05.324147604Z: INFO ▶ [DATABASE] 133 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [87 28 4.653056e+06] - 250.235µs 2024-09-01T12:56:05.324425759Z: INFO ▶ [DATABASE] 134 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [88 9 720896] - 257.515µs 2024-09-01T12:56:05.324690671Z: INFO ▶ [DATABASE] 135 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [88 12 4.295098368e+09] - 244.887µs 2024-09-01T12:56:05.324995789Z: INFO ▶ [DATABASE] 136 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [90 21 65536] - 282.458µs 2024-09-01T12:56:05.325277786Z: INFO ▶ [DATABASE] 137 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [90 24 65536] - 260.577µs 2024-09-01T12:56:05.325558617Z: INFO ▶ [DATABASE] 138 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [91 21 131072] - 257.774µs 2024-09-01T12:56:05.325833951Z: INFO ▶ [DATABASE] 139 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [91 24 4.294967296e+09] - 254.782µs 2024-09-01T12:56:05.326108268Z: INFO ▶ [DATABASE] 13a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [92 21 196608] - 253.304µs 2024-09-01T12:56:05.326395298Z: INFO ▶ [DATABASE] 13b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [92 24 196608] - 266.7µs 2024-09-01T12:56:05.326676468Z: INFO ▶ [DATABASE] 13c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [93 21 262144] - 253.767µs 2024-09-01T12:56:05.326962785Z: INFO ▶ [DATABASE] 13d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [93 24 49152] - 255.862µs 2024-09-01T12:56:05.327235928Z: INFO ▶ [DATABASE] 13e [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [94 21 327680] - 252.159µs 2024-09-01T12:56:05.327511526Z: INFO ▶ [DATABASE] 13f [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [94 24 327680] - 253.758µs 2024-09-01T12:56:05.327784881Z: INFO ▶ [DATABASE] 140 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [95 21 393216] - 251.594µs 2024-09-01T12:56:05.328067712Z: INFO ▶ [DATABASE] 141 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [95 24 393216] - 261.598µs 2024-09-01T12:56:05.328343873Z: INFO ▶ [DATABASE] 142 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [96 21 458752] - 253.41µs 2024-09-01T12:56:05.328615287Z: INFO ▶ [DATABASE] 143 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [96 24 671744] - 250.969µs 2024-09-01T12:56:05.328902854Z: INFO ▶ [DATABASE] 144 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [97 21 524288] - 266.978µs 2024-09-01T12:56:05.329185722Z: INFO ▶ [DATABASE] 145 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [97 24 688128] - 258.638µs 2024-09-01T12:56:05.329461155Z: INFO ▶ [DATABASE] 146 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [98 21 589824] - 251.858µs 2024-09-01T12:56:05.329906001Z: INFO ▶ [DATABASE] 147 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [98 24 4.295032832e+09] - 424.189µs 2024-09-01T12:56:05.330185812Z: INFO ▶ [DATABASE] 148 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [99 21 655360] - 258.874µs 2024-09-01T12:56:05.330464235Z: INFO ▶ [DATABASE] 149 [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [99 24 4.295098368e+09] - 256.599µs 2024-09-01T12:56:05.330738414Z: INFO ▶ [DATABASE] 14a [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [100 21 720896] - 252.584µs 2024-09-01T12:56:05.33101232Z: INFO ▶ [DATABASE] 14b [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [100 24 720896] - 253.419µs 2024-09-01T12:56:05.331293645Z: INFO ▶ [DATABASE] 14c [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [16 25 9.857301990819672e+08] - 256.668µs 2024-09-01T12:56:05.331570515Z: INFO ▶ [DATABASE] 14d [SQL] INSERT INTO "task_positions" ("task_id","project_view_id","position") VALUES ($1,$2,$3) [16 28 727040] - 254.745µs 2024-09-01T12:56:05.332113382Z: INFO ▶ [DATABASE] 14e [SQL] ALTER TABLE tasks DROP COLUMN position [] - 518.505µs 2024-09-01T12:56:05.332399839Z: INFO ▶ [DATABASE] 14f [SQL] ALTER TABLE tasks DROP COLUMN kanban_position [] - 269.381µs 2024-09-01T12:56:05.332696382Z: INFO ▶ [DATABASE] 150 [SQL] INSERT INTO "migration" ("id","description") VALUES ($1,$2) [20240314214802 ] - 275.049µs 2024-09-01T12:56:05.332987883Z: INFO ▶ [DATABASE] 151 [SQL] SELECT count(*) FROM "migration" WHERE "id" IN ($1) [20240315093418] - 260.846µs 2024-09-01T12:56:05.333005972Z: INFO ▶ [DATABASE] 152 Relate buckets to views instead of projects 2024-09-01T12:56:05.333516362Z: INFO ▶ [DATABASE] 153 [SQL] SELECT tablename FROM pg_tables WHERE schemaname = $1 [public] - 500.673µs 2024-09-01T12:56:05.334381923Z: INFO ▶ [DATABASE] 154 [SQL] CREATE TABLE IF NOT EXISTS "public"."buckets" ("id" BIGSERIAL NOT NULL, "project_id" BIGINT NOT NULL, "project_view_id" BIGINT DEFAULT 0 NOT NULL); [] - 801.206µs 2024-09-01T12:56:05.33463373Z: INFO ▶ [DATABASE] 155 [SQL] SELECT "id", "project_id", "project_view_id" FROM "buckets" [] - 225.878µs ``` </details> <details> <summary>standard.log</summary> ``` 2024-09-01T12:56:05.197117275Z: INFO ▶ config/InitConfig 001 No config file found, using default or config from environment variables. 2024-09-01T12:56:05.197205486Z: INFO ▶ migration/Migrate 002 Running migrations… 2024-09-01T12:56:05.334655023Z: CRITICAL ▶ migration/Migrate 156 Migration failed: migration 20240315093418 failed: pq: column "project_view_id" does not exist 2024-09-01T12:56:05.80906064Z: INFO ▶ config/InitConfig 001 No config file found, using default or config from environment variables. ``` </details>
GiteaMirror commented 2025-11-01 20:52:09 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Sep 2, 2024):

Seems like the CREATE TABLE IF NOT EXISTS is the issue here. It should update the table, not try to create it. Will take a look.

@kolaente commented on GitHub (Sep 2, 2024): Seems like the `CREATE TABLE IF NOT EXISTS` is the issue here. It should update the table, not try to create it. Will take a look.
GiteaMirror commented 2025-11-01 20:52:09 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Sep 20, 2024):

I was unable to reproduce this in my testing. Running that exact migration with a previously populated postgres 16 database worked as expected. Which exact postgres version are you using?

Can you also send the outpot of \d buckets from a psql shell before running into the error?

@kolaente commented on GitHub (Sep 20, 2024): I was unable to reproduce this in my testing. Running that exact migration with a previously populated postgres 16 database worked as expected. Which exact postgres version are you using? Can you also send the outpot of `\d buckets` from a `psql` shell before running into the error?
GiteaMirror commented 2025-11-01 20:52:10 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Sep 21, 2024):

I'm on the postgres:16 image and when I start my database it tells me I'm on PostgreSQL 16.4.

services:
  vikunja_db:
    image: postgres:16
    container_name: vikunja_db
    environment:
      - POSTGRES_DB=vikunja
      - POSTGRES_PASSWORD=RANDOM_PASSWORD
      - POSTGRES_USER=vikunja
    volumes:
      - ./vikunja-db:/var/lib/postgresql/data

2024-09-21 09:54:02.424 UTC [1] LOG:  starting PostgreSQL 16.4 (Debian 16.4-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2024-09-21 09:54:02.425 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2024-09-21 09:54:02.425 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2024-09-21 09:54:02.425 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2024-09-21 09:54:02.428 UTC [30] LOG:  database system was interrupted; last known up at 2024-07-17 18:01:31 UTC
2024-09-21 09:54:02.445 UTC [30] LOG:  database system was not properly shut down; automatic recovery in progress
2024-09-21 09:54:02.447 UTC [30] LOG:  redo starts at 0/1AC7B20
2024-09-21 09:54:02.447 UTC [30] LOG:  invalid record length at 0/1AC7C08: expected at least 24, got 0
2024-09-21 09:54:02.447 UTC [30] LOG:  redo done at 0/1AC7BD0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s
2024-09-21 09:54:02.448 UTC [28] LOG:  checkpoint starting: end-of-recovery immediate wait
2024-09-21 09:54:02.450 UTC [28] LOG:  checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.003 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/1AC7C08, redo lsn=0/1AC7C08
2024-09-21 09:54:02.453 UTC [1] LOG:  database system is ready to accept connections

The output you asked for :

\d buckets
                                        Table "vikunja.buckets"
    Column     |           Type           | Collation | Nullable |               Default
---------------+--------------------------+-----------+----------+-------------------------------------
 id            | bigint                   |           | not null | nextval('buckets_id_seq'::regclass)
 title         | text                     |           | not null |
 project_id    | bigint                   |           | not null |
 limit         | bigint                   |           |          | '0'::bigint
 position      | double precision         |           |          |
 created       | timestamp with time zone |           | not null |
 updated       | timestamp with time zone |           | not null |
 created_by_id | bigint                   |           | not null |
Indexes:
    "idx_16398_primary" PRIMARY KEY, btree (id)
    "idx_16398_uqe_buckets_id" UNIQUE, btree (id)
@SeiyaGame commented on GitHub (Sep 21, 2024): I'm on the postgres:16 image and when I start my database it tells me I'm on PostgreSQL 16.4. ```yaml services: vikunja_db: image: postgres:16 container_name: vikunja_db environment: - POSTGRES_DB=vikunja - POSTGRES_PASSWORD=RANDOM_PASSWORD - POSTGRES_USER=vikunja volumes: - ./vikunja-db:/var/lib/postgresql/data ``` ```log 2024-09-21 09:54:02.424 UTC [1] LOG: starting PostgreSQL 16.4 (Debian 16.4-1.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit 2024-09-21 09:54:02.425 UTC [1] LOG: listening on IPv4 address "0.0.0.0", port 5432 2024-09-21 09:54:02.425 UTC [1] LOG: listening on IPv6 address "::", port 5432 2024-09-21 09:54:02.425 UTC [1] LOG: listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432" 2024-09-21 09:54:02.428 UTC [30] LOG: database system was interrupted; last known up at 2024-07-17 18:01:31 UTC 2024-09-21 09:54:02.445 UTC [30] LOG: database system was not properly shut down; automatic recovery in progress 2024-09-21 09:54:02.447 UTC [30] LOG: redo starts at 0/1AC7B20 2024-09-21 09:54:02.447 UTC [30] LOG: invalid record length at 0/1AC7C08: expected at least 24, got 0 2024-09-21 09:54:02.447 UTC [30] LOG: redo done at 0/1AC7BD0 system usage: CPU: user: 0.00 s, system: 0.00 s, elapsed: 0.00 s 2024-09-21 09:54:02.448 UTC [28] LOG: checkpoint starting: end-of-recovery immediate wait 2024-09-21 09:54:02.450 UTC [28] LOG: checkpoint complete: wrote 3 buffers (0.0%); 0 WAL file(s) added, 0 removed, 0 recycled; write=0.001 s, sync=0.001 s, total=0.003 s; sync files=2, longest=0.001 s, average=0.001 s; distance=0 kB, estimate=0 kB; lsn=0/1AC7C08, redo lsn=0/1AC7C08 2024-09-21 09:54:02.453 UTC [1] LOG: database system is ready to accept connections ``` The output you asked for : ``` \d buckets Table "vikunja.buckets" Column | Type | Collation | Nullable | Default ---------------+--------------------------+-----------+----------+------------------------------------- id | bigint | | not null | nextval('buckets_id_seq'::regclass) title | text | | not null | project_id | bigint | | not null | limit | bigint | | | '0'::bigint position | double precision | | | created | timestamp with time zone | | not null | updated | timestamp with time zone | | not null | created_by_id | bigint | | not null | Indexes: "idx_16398_primary" PRIMARY KEY, btree (id) "idx_16398_uqe_buckets_id" UNIQUE, btree (id) ```
GiteaMirror commented 2025-11-01 20:52:10 -05:00
Author
Owner
Copy Link

@kolaente commented on GitHub (Jun 24, 2025):

Is this still a problem?

@kolaente commented on GitHub (Jun 24, 2025): Is this still a problem?
GiteaMirror commented 2025-11-01 20:52:10 -05:00
Author
Owner
Copy Link

@SeiyaGame commented on GitHub (Jun 25, 2025):

This is no longer the case for me, as the migration worked with :

ALTER TABLE buckets ADD project_view_id bigint not null default 0;

ALTER TABLE teams ADD oidc_id varchar(250) null;
ALTER TABLE teams ADD issuer text null;
ALTER TABLE teams ADD is_public bool not null default false;
@SeiyaGame commented on GitHub (Jun 25, 2025): This is no longer the case for me, as the migration worked with : >```sql >ALTER TABLE buckets ADD project_view_id bigint not null default 0; > >ALTER TABLE teams ADD oidc_id varchar(250) null; >ALTER TABLE teams ADD issuer text null; >ALTER TABLE teams ADD is_public bool not null default false; >```
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
Labels
Clear labels
area/api
area/attachments
area/auth
area/avatars
area/backup-restore
area/caldav
area/calendar-view
area/comments
area/config
area/database
area/desktop
area/docker
area/email
area/favorites
area/filters
area/frontend
area/gantt
area/i18n
area/import-export
area/internal-code
area/kanban
area/labels
area/list-view
area/mobile
area/notifications
area/permissions
area/projects
area/pwa
area/recurring-tasks
area/reminders
area/search
area/shortcuts
area/subtasks
area/sync
area/table-view
area/task-editor
area/task-metadata
area/task-relations
area/teams
area/theming
area/time-tracking
area/typesense
area/views
area/webhooks
bug
changes requested
concern/accessibility
concern/performance
concern/regression
concern/ux
confirmed
db/mysql
dependencies
enhancement
good first issue
help wanted
integration/inbound
integration/outbound
kind/bug
kind/feature
needs reproduction
pull-request
Mirrored from GitHub Pull Request
 question
security
support
upstream issue
waiting for reply
wontfix
No Label
Milestone
No items
No Milestone
Projects
Clear projects
No project
Assignees
Clear assignees
GiteaMirror ninjasurge
No Assignees
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: github-starred/vikunja#255
Delete Branch "%!s()"

Deleting a branch is permanent. Although the deleted branch may continue to exist for a short time before it actually gets removed, it CANNOT be undone in most cases. Continue?