https://prefect.io logo
Join Slack
Powered by
Hey all. Anybody else having troubles with the `se...
# ask-community
w
Hey all. Anybody else having troubles with the 
server
? I’ve been getting a long traceback while running the server locally. It seems that a 
flow_run
is stuck cached somewhere, and some process is still firing a log. I think this happened after I cancelled and deleted a few flows and flow runs. I already uninstalled the server and installed it again, but no success
d
Copy code
ValueError: Foreign key violation.
I'm no expert here but it sounds like there might be some mismatch between the server and the database.
are you persisting data or using an external db? If possible maybe clear this data to see if that helps?
w
I’m using the server from docker, and i 
force-rebuild
the containers, and rebuilt my 
venv
that’s probably the case, but i wondering what might have happened to get the application into this state, and why it still gives me error (in a continuum fashion) even after rebuilding the container and reinstalling the server
DETAIL:  Key (flow_run_id)=(d6004258-b75f-477b-9615-f4ddb9756c19) is not present in table "flow_run".
So from what I understand the 
flow_run
information persisted (somewhere), and this generates an inconsistency in the database. i wonder if there’s any way to clean the cache, or something, I can’t see anything in the docs. I even reconstructure the 
~/.prefect
folder but didn’t work as well.
Immediately after the server starts, this is the error:
Copy code
apollo_1    | PayloadTooLargeError: request entity too large
apollo_1    |     at readStream (/apollo/node_modules/raw-body/index.js:155:17)
apollo_1    |     at getRawBody (/apollo/node_modules/raw-body/index.js:108:12)
apollo_1    |     at read (/apollo/node_modules/body-parser/lib/read.js:77:3)
apollo_1    |     at jsonParser (/apollo/node_modules/body-parser/lib/types/json.js:135:5)
apollo_1    |     at Layer.handle [as handle_request] (/apollo/node_modules/express/lib/router/layer.js:95:5)
apollo_1    |     at trim_prefix (/apollo/node_modules/express/lib/router/index.js:317:13)
apollo_1    |     at /apollo/node_modules/express/lib/router/index.js:284:7
apollo_1    |     at Function.process_params (/apollo/node_modules/express/lib/router/index.js:335:12)
apollo_1    |     at next (/apollo/node_modules/express/lib/router/index.js:275:10)
apollo_1    |     at cors (/apollo/node_modules/cors/lib/index.js:188:7)
postgres_1  | 2021-01-05 05:02:49.134 UTC [85] ERROR:  insert or update on table "log" violates foreign key constraint "log_flow_run_id_fkey"
postgres_1  | 2021-01-05 05:02:49.134 UTC [85] DETAIL:  Key (flow_run_id)=(d6004258-b75f-477b-9615-f4ddb9756c19) is not present in table "flow_run".
postgres_1  | 2021-01-05 05:02:49.134 UTC [85] STATEMENT:  WITH "log__mutation_result_alias" AS (INSERT INTO "public"."log" ( "created", "tenant_id", "is_loaded_from_archive", "task_run_id", "name", "id", "updated", "message", "timestamp", "level", "flow_run_id", "info" ) VALUES (DEFAULT, ($1)::uuid, DEFAULT, ($2)::uuid, ($3)::text, ($4)::uuid, DEFAULT, ($5)::text, ($6)::timestamptz, ($7)::text, ($8)::uuid, ($9)::jsonb)  RETURNING * , CASE WHEN 'true' THEN NULL ELSE "hdb_catalog"."check_violation"('insert check constraint failed')  END ), "log__all_columns_alias" AS (SELECT  "flow_run_id" , "tenant_id" , "task_run_id" , "timestamp" , "name" , "level" , "message" , "info" , "id" , "created" , "updated" , "is_loaded_from_archive"  FROM "log__mutation_result_alias"      ) SELECT  json_build_object('affected_rows', (SELECT  COUNT(*)  FROM "log__all_columns_alias"      ) )
d
Are you hitting the server from your browser at this point? Perhaps the browser has cached flows and is trying to load previous ones via their Id which no longer exist?
w
no, this was right after the start of the server. I got the cache clean after cleaning mac’s library/cache and several restarts
3 Views
Open in Slack
PreviousNext
Powered by