Bashing my head against the wall on this, haha. I followed the steps completely and I'm fine getting into the Web GUI, I set myself up, add an account, go in to try and add my first transaction - then I get the infinite loop with postgres14.
To be clear, I installed redis, installed postgres14, (both are running), then installed ghostfolio setting the links to both other containers. Ghostfolio auto-starts after clicking apply, I hit the ghostfolio console and did the migrate command. Then as above and get the errors.
I tried a couple additional things. I nuked ghostfolio and postgres14 and tried again with the database setup command and as shown here that infinite looped it immediately. Then I tried nuking only postgres14 thinking maybe ghostfolio was doing something as it started up that was an issue - but confirmed I'm still having the problem.
This is what I'm seeing in the postgres14 logs infinitely after trying to add an F buy. Total noob on database items so probably something simple I'm missing.
2022-06-05 10:39:32.634 EDT [34] ERROR: duplicate key value violates unique constraint "MarketData_date_symbol_key"
2022-06-05 10:39:32.634 EDT [34] DETAIL: Key (date, symbol)=(2020-12-29 00:00:00, F) already exists.
2022-06-05 10:39:32.634 EDT [34] STATEMENT: INSERT INTO "public"."MarketData" ("createdAt","dataSource","date","id","symbol","marketPrice") VALUES ($1,$2,$3,$4,$5,$6) RETURNING "public"."MarketData"."id"
2022-06-05 10:39:32.651 EDT [34] ERROR: duplicate key value violates unique constraint "MarketData_date_symbol_key"
2022-06-05 10:39:32.651 EDT [34] DETAIL: Key (date, symbol)=(2020-12-29 00:00:00, F) already exists.
2022-06-05 10:39:32.651 EDT [34] STATEMENT: INSERT INTO "public"."MarketData" ("createdAt","dataSource","date","id","symbol","marketPrice") VALUES ($1,$2,$3,$4,$5,$6) RETURNING "public"."MarketData"."id"
2022-06-05 10:39:32.665 EDT [34] ERROR: duplicate key value violates unique constraint "MarketData_date_symbol_key"
2022-06-05 10:39:32.665 EDT [34] DETAIL: Key (date, symbol)=(2020-12-29 00:00:00, F) already exists.
2022-06-05 10:39:32.665 EDT [34] STATEMENT: INSERT INTO "public"."MarketData" ("createdAt","dataSource","date","id","symbol","marketPrice") VALUES ($1,$2,$3,$4,$5,$6) RETURNING "public"."MarketData"."id"