wiretrack
01/04/2021, 12:46 AMserver
? 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 successDan Moore
01/04/2021, 12:30 PMValueError: Foreign key violation.
I'm no expert here but it sounds like there might be some mismatch between the server and the database.wiretrack
01/05/2021, 4:45 AMforce-rebuild
the containers, and rebuilt my venv
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.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" ) )
Dan Moore
01/05/2021, 8:42 PMwiretrack
01/08/2021, 11:07 AM