https://prefect.io logo
w

wiretrack

01/04/2021, 12:46 AM
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

Dan Moore

01/04/2021, 12:30 PM
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

wiretrack

01/05/2021, 4:45 AM
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

Dan Moore

01/05/2021, 8:42 PM
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

wiretrack

01/08/2021, 11:07 AM
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