FK errors for persisting check on workload

[yashmehrotra]

2024/07/30 10:12:08 logger.go:167: /app/pkg/db/canary.go:119 ERROR: insert or update on table "checks" violates foreign key constraint "checks_canary_id_fkey" (SQLSTATE 23503) [1.921ms] [rows:0] INSERT INTO "checks" ("canary_id","spec","type","name","namespace","labels","description","status","owner","severity","icon","transformed","last_runtime","last_transition_time","next_runtime","updated_at","created_at","deleted_at","silenced_at") VALUES ('00000000-0000-0000-0000-000000000000','{"name":"canary-checker-org-ohbxge5jynca","test":{},"display":{},"transform":{},"username":{},"password":{},"endpoint":"http://canary-checker-x-default-x-org-ohbxge5jynca.org-ohbxge5jynca:8080/health","responseCodes":[200]}','http','canary-checker-org-ohbxge5jynca','org-ohbxge5jynca','{}','','','','','',false,NULL,NULL,NULL,'2024-07-30 10:12:08.982','2024-07-30 10:12:08.982',NULL,NULL) ON CONFLICT ("canary_id","type","name","agent_id") DO UPDATE SET "deleted_at"=NULL,"description"='',"icon"='',"labels"='{}',"namespace"='org-ohbxge5jynca',"owner"='',"severity"='',"spec"='{"name":"canary-checker-org-ohbxge5jynca","test":{},"display":{},"transform":{},"username":{},"password":{},"endpoint":"http://canary-checker-x-default-x-org-ohbxge5jynca.org-ohbxge5jynca:8080/health","responseCodes":[200]}',"type"='http' RETURNING "id"

[yashmehrotra]

This is coming from a topology

[yashmehrotra]

{"level":"error","ts":"2024-07-30T10:20:09.119757946Z","msg":"Canary{00000000-0000-0000-0000-000000000000} failed to save results: error adding check to cache: error persisting check with canary 00000000-0000-0000-0000-000000000000: ERROR: insert or update on table \"checks\" violates foreign key constraint \"checks_canary_id_fkey\" (SQLSTATE 23503)"}