-
Bug
-
Resolution: Unresolved
-
Normal
-
None
-
4.9.0
-
None
-
Incidents & Support
-
False
-
-
False
-
-
-
-
Rox Sprint 4.10G
USER PROBLEM
What is the user experiencing as a result of the bug? Include steps to reproduce.
I noted the below error in reconciling a SecurityPolicy CR from the cluster to the the central database after 48 hours over the weekend and the policy did not get recreated in the ACS UI, I deleted the policy from the ACS UI manually last week.Is this an expected observation? is there a way we can fix the below / force the reconciliation?
{{2026-01-05T01:27:31Z ERROR Reconciler error {"controller": "securitypolicy", "controllerGroup": "config.stackrox.io", "controllerKind": "SecurityPolicy", "SecurityPolicy":
{"name":"test-policy-sync","namespace":"stackrox"}, "namespace": "stackrox", "name": "test-policy-sync", "reconcileID": "7b937664-fb68-44f7-a8cd-b1bd142667ff", "error": "Failed to update policy 'test-policy-sync': Failed to PUT policy: Failed to update policy \"test-policy-sync\": rpc error: code = NotFound desc = found non-retryable error: closing batch: ERROR: insert or update on table \"policy_category_edges\" violates foreign key constraint \"fk_policy_category_edges_policies_ref\" (SQLSTATE 23503): referenced object not found"}}}
CONDITIONS
What conditions need to exist for a user to be affected? Is it everyone? Is it only those with a specific integration? Is it specific to someone with particular database content? etc.
- pending
ROOT CAUSE
What is the root cause of the bug?
- pending
FIX
How was the bug fixed (this is more important if a workaround was implemented rather than an actual fix)?
- pending