KB-24F3
P3D Phase 5C2 — DIEU-35 Rollback Keys — 20260514T140804Z
13 min read Revision 1
p3dphase5c2dieu-35rollback-keysbefore-commit20260514T140804Z
P3D Phase 5C2 — DIEU-35 Rollback Keys — 20260514T140804Z
Captured BEFORE COMMIT. Patched-V-3 retry/R2 transaction for
DIEU-35(36rows). UUIDs below are the exact-key rollback target if post-COMMIT validation fails.
Authorization
USER_GO=YES
GPT_FINAL_APPROVAL=YES
V3_SPEC_PATCH_APPROVED=YES
R1_RETRY_AUTHORIZED=YES
CONDITIONAL_R2_AUTHORIZED=YES
doc_code=DIEU-35
publication_id=27e48995-d6a1-4a44-8559-cab6a07fdbe0
publication_version=v5.2
publication_lifecycle=proposed
member_count=36
utc_ts=20260514T140804Z
loop_count=36
Captured arrays
IU UUIDs
[
"484f4d5e-78d2-4061-bd3d-e14ade80fe17",
"7f6e8883-13a9-41e6-a6b6-393d13d7c13f",
"0090a17a-126c-40ca-a7d3-aafde0dd3401",
"7151cd1f-966b-4392-8caf-ee0b2f990889",
"f56fef52-a35c-4423-8f35-08b74d7b3f88",
"cb211ee6-2b61-496e-b191-ef502ea28345",
"3477ff71-b8a4-4dd8-b854-d86c1567ba83",
"5410e681-6d53-48ba-b202-076ecc857115",
"68375024-479a-4611-b8c9-36d7a4d78f38",
"982677b6-12a2-4aad-8bd6-6cef4eda8ede",
"caa1f95b-e720-40b6-a834-9cf5afa785e4",
"42d12348-0ada-4aef-8204-e3a0dc7bd768",
"3293c8a5-7520-4cc3-9afd-0386f71ba77d",
"e4366c52-b103-478b-b40d-f12143b5556a",
"2aa62b93-65d0-4fd4-ae6c-e6aeb5e08de8",
"27c7ccd7-65aa-4d3d-99a9-7c4dbf4eabbc",
"358062b8-2114-4832-a9d1-87fa21f578da",
"26ba272e-30cf-4488-81ae-f475fe2ec579",
"5c1b37c7-dc5c-43c7-aeb7-04c377910f0d",
"53ae367b-4897-47ba-be7d-e217c18c2e50",
"1d029e81-baa3-4269-b827-93d4cf1eddc4",
"b392ee8c-11da-44aa-918b-279f3edb3c36",
"cba42968-3549-4032-a962-bab8f5610960",
"11301332-7c52-47d0-9630-038b2bdb3c24",
"003bec16-a8c6-46b4-8bbc-ecc500e2aacb",
"9cecb006-806b-4baa-908c-2907ca82a870",
"deb8b8da-4878-47a7-bc59-f0d08a5d38fc",
"7aaa226c-62fc-4595-83ac-7ae169644d01",
"815c8573-4f34-4416-8748-3e288e5705e1",
"90937d05-f271-409b-8d03-4ff082757c3d",
"7e509cf5-8b90-4325-a5fa-f3ad7a2197d8",
"adcc72e9-5757-4218-9003-a15d8e19241f",
"a0af598b-3c8c-4b4b-9361-0bf01361f0fc",
"53ca2de9-d1d3-446a-9e1e-f6062e08e834",
"dc2c3925-5648-4477-8212-b066ea6ba1de",
"99b8319d-be4d-4778-910f-1da6d78ac751"
]
UV UUIDs
[
"51a8362f-e841-47c3-9320-db27b2ea9017",
"3ee7c50e-630c-40b8-92cf-3f45bf40133b",
"8a0ce491-c5b7-44af-a31d-5f63f1db35fd",
"c7f126b2-58aa-443f-8087-d06a1e8cfd81",
"a9ab6696-48ef-4a0d-afa1-ebf6689f51fa",
"23e2a0cd-48d6-4674-88d0-d2c133a63a8a",
"c5740158-f986-49bd-9af2-336003ad06f5",
"df247786-7777-4218-8601-dcbcd274f17c",
"1fe7ba15-0c1c-4ac7-b36a-638365589b44",
"29b2800a-5819-41e9-b402-4b4926ce764b",
"c2a3bb91-f110-47ff-a426-ed7f123792b9",
"f56aa861-7c61-4f31-b263-6b37190fb054",
"b1da5c1e-3719-46eb-b193-e3b611bbd156",
"f5c791a5-f71f-4173-8209-184d122bfbdb",
"2e115241-e7cb-473b-bd4b-a8054d962708",
"6580e2a8-db81-458c-8838-d6aee29a4cfe",
"f0f41e9b-83fc-4ccc-ad58-50454f14fef3",
"bbde4f02-b58f-4bea-a67f-0dcafe24291b",
"1e059600-7e0d-4ff0-a62b-947a7e3ada14",
"846a3382-b7ed-4387-96fd-f83e33d8daa4",
"0f6c9a9e-f83b-49f3-a217-faf1a5e6a304",
"4a20057b-8e8b-4eaf-bc8a-07870d8bcda2",
"82b9a911-8994-405f-8867-b399602c2f8a",
"7241ab97-9b5b-4006-8927-51f4459abc40",
"2ba22942-0c65-4e95-9210-d3588b711477",
"3597e4de-d423-49ca-ac71-ed305aa86979",
"886ea344-e9b9-4334-9fd3-c6590f59bbea",
"092493d4-47bd-407d-8b4d-ab3a19c91211",
"dd22ce4e-4b15-49ac-b684-0c30a9e5418e",
"13126cda-da9b-449e-8687-291323453c97",
"5ade5ce8-7d98-4a97-b6fb-e3dedac06e2e",
"14d2099f-e13c-4502-8448-52c9c21b989d",
"c161c8e3-43ed-408a-ae17-c21e54cb03d3",
"3a6a553e-76e1-440f-a5f0-e9d542033049",
"5070033f-9ab1-42ae-82b7-b3dedbe2e63e",
"3b4cd548-6b8f-4817-af6e-9746019ff662"
]
Canonical addresses
[
"D38-DIEU35-ROOT",
"D38-DIEU35-S0",
"D38-DIEU35-S1",
"D38-DIEU35-S2",
"D38-DIEU35-S3",
"D38-DIEU35-S4",
"D38-DIEU35-S4-P1",
"D38-DIEU35-S4-P1-1",
"D38-DIEU35-S4-P1-2",
"D38-DIEU35-S4-P1-3",
"D38-DIEU35-S4-P2",
"D38-DIEU35-S4-P3",
"D38-DIEU35-S4-P4",
"D38-DIEU35-S5",
"D38-DIEU35-S6",
"D38-DIEU35-S6-P1",
"D38-DIEU35-S6-P2",
"D38-DIEU35-S6-P3",
"D38-DIEU35-S6-P4",
"D38-DIEU35-S6-P5",
"D38-DIEU35-S6-P6",
"D38-DIEU35-S6-P7",
"D38-DIEU35-S7",
"D38-DIEU35-S8",
"D38-DIEU35-S8-P1",
"D38-DIEU35-S8-P2",
"D38-DIEU35-S8-P3",
"D38-DIEU35-S8-P4",
"D38-DIEU35-S8-P5",
"D38-DIEU35-S9",
"D38-DIEU35-S10",
"D38-DIEU35-S11",
"D38-DIEU35-S12",
"D38-DIEU35-S13",
"D38-DIEU35-S14",
"D38-DIEU35-S15"
]
Birth entity codes
[
"information_unit::484f4d5e-78d2-4061-bd3d-e14ade80fe17",
"information_unit::7f6e8883-13a9-41e6-a6b6-393d13d7c13f",
"information_unit::0090a17a-126c-40ca-a7d3-aafde0dd3401",
"information_unit::7151cd1f-966b-4392-8caf-ee0b2f990889",
"information_unit::f56fef52-a35c-4423-8f35-08b74d7b3f88",
"information_unit::cb211ee6-2b61-496e-b191-ef502ea28345",
"information_unit::3477ff71-b8a4-4dd8-b854-d86c1567ba83",
"information_unit::5410e681-6d53-48ba-b202-076ecc857115",
"information_unit::68375024-479a-4611-b8c9-36d7a4d78f38",
"information_unit::982677b6-12a2-4aad-8bd6-6cef4eda8ede",
"information_unit::caa1f95b-e720-40b6-a834-9cf5afa785e4",
"information_unit::42d12348-0ada-4aef-8204-e3a0dc7bd768",
"information_unit::3293c8a5-7520-4cc3-9afd-0386f71ba77d",
"information_unit::e4366c52-b103-478b-b40d-f12143b5556a",
"information_unit::2aa62b93-65d0-4fd4-ae6c-e6aeb5e08de8",
"information_unit::27c7ccd7-65aa-4d3d-99a9-7c4dbf4eabbc",
"information_unit::358062b8-2114-4832-a9d1-87fa21f578da",
"information_unit::26ba272e-30cf-4488-81ae-f475fe2ec579",
"information_unit::5c1b37c7-dc5c-43c7-aeb7-04c377910f0d",
"information_unit::53ae367b-4897-47ba-be7d-e217c18c2e50",
"information_unit::1d029e81-baa3-4269-b827-93d4cf1eddc4",
"information_unit::b392ee8c-11da-44aa-918b-279f3edb3c36",
"information_unit::cba42968-3549-4032-a962-bab8f5610960",
"information_unit::11301332-7c52-47d0-9630-038b2bdb3c24",
"information_unit::003bec16-a8c6-46b4-8bbc-ecc500e2aacb",
"information_unit::9cecb006-806b-4baa-908c-2907ca82a870",
"information_unit::deb8b8da-4878-47a7-bc59-f0d08a5d38fc",
"information_unit::7aaa226c-62fc-4595-83ac-7ae169644d01",
"information_unit::815c8573-4f34-4416-8748-3e288e5705e1",
"information_unit::90937d05-f271-409b-8d03-4ff082757c3d",
"information_unit::7e509cf5-8b90-4325-a5fa-f3ad7a2197d8",
"information_unit::adcc72e9-5757-4218-9003-a15d8e19241f",
"information_unit::a0af598b-3c8c-4b4b-9361-0bf01361f0fc",
"information_unit::53ca2de9-d1d3-446a-9e1e-f6062e08e834",
"information_unit::dc2c3925-5648-4477-8212-b066ea6ba1de",
"information_unit::99b8319d-be4d-4778-910f-1da6d78ac751"
]
Exact-key rollback SQL (do not execute unless post-COMMIT validation fails)
BEGIN;
SET LOCAL "app.canonical_writer" = 'fn_iu_apply_edit_draft';
DELETE FROM birth_registry
WHERE collection_name = 'information_unit'
AND entity_code = ANY( ARRAY['information_unit::484f4d5e-78d2-4061-bd3d-e14ade80fe17','information_unit::7f6e8883-13a9-41e6-a6b6-393d13d7c13f','information_unit::0090a17a-126c-40ca-a7d3-aafde0dd3401','information_unit::7151cd1f-966b-4392-8caf-ee0b2f990889','information_unit::f56fef52-a35c-4423-8f35-08b74d7b3f88','information_unit::cb211ee6-2b61-496e-b191-ef502ea28345','information_unit::3477ff71-b8a4-4dd8-b854-d86c1567ba83','information_unit::5410e681-6d53-48ba-b202-076ecc857115','information_unit::68375024-479a-4611-b8c9-36d7a4d78f38','information_unit::982677b6-12a2-4aad-8bd6-6cef4eda8ede','information_unit::caa1f95b-e720-40b6-a834-9cf5afa785e4','information_unit::42d12348-0ada-4aef-8204-e3a0dc7bd768','information_unit::3293c8a5-7520-4cc3-9afd-0386f71ba77d','information_unit::e4366c52-b103-478b-b40d-f12143b5556a','information_unit::2aa62b93-65d0-4fd4-ae6c-e6aeb5e08de8','information_unit::27c7ccd7-65aa-4d3d-99a9-7c4dbf4eabbc','information_unit::358062b8-2114-4832-a9d1-87fa21f578da','information_unit::26ba272e-30cf-4488-81ae-f475fe2ec579','information_unit::5c1b37c7-dc5c-43c7-aeb7-04c377910f0d','information_unit::53ae367b-4897-47ba-be7d-e217c18c2e50','information_unit::1d029e81-baa3-4269-b827-93d4cf1eddc4','information_unit::b392ee8c-11da-44aa-918b-279f3edb3c36','information_unit::cba42968-3549-4032-a962-bab8f5610960','information_unit::11301332-7c52-47d0-9630-038b2bdb3c24','information_unit::003bec16-a8c6-46b4-8bbc-ecc500e2aacb','information_unit::9cecb006-806b-4baa-908c-2907ca82a870','information_unit::deb8b8da-4878-47a7-bc59-f0d08a5d38fc','information_unit::7aaa226c-62fc-4595-83ac-7ae169644d01','information_unit::815c8573-4f34-4416-8748-3e288e5705e1','information_unit::90937d05-f271-409b-8d03-4ff082757c3d','information_unit::7e509cf5-8b90-4325-a5fa-f3ad7a2197d8','information_unit::adcc72e9-5757-4218-9003-a15d8e19241f','information_unit::a0af598b-3c8c-4b4b-9361-0bf01361f0fc','information_unit::53ca2de9-d1d3-446a-9e1e-f6062e08e834','information_unit::dc2c3925-5648-4477-8212-b066ea6ba1de','information_unit::99b8319d-be4d-4778-910f-1da6d78ac751']::text[] );
DELETE FROM unit_version
WHERE id = ANY( ARRAY['51a8362f-e841-47c3-9320-db27b2ea9017','3ee7c50e-630c-40b8-92cf-3f45bf40133b','8a0ce491-c5b7-44af-a31d-5f63f1db35fd','c7f126b2-58aa-443f-8087-d06a1e8cfd81','a9ab6696-48ef-4a0d-afa1-ebf6689f51fa','23e2a0cd-48d6-4674-88d0-d2c133a63a8a','c5740158-f986-49bd-9af2-336003ad06f5','df247786-7777-4218-8601-dcbcd274f17c','1fe7ba15-0c1c-4ac7-b36a-638365589b44','29b2800a-5819-41e9-b402-4b4926ce764b','c2a3bb91-f110-47ff-a426-ed7f123792b9','f56aa861-7c61-4f31-b263-6b37190fb054','b1da5c1e-3719-46eb-b193-e3b611bbd156','f5c791a5-f71f-4173-8209-184d122bfbdb','2e115241-e7cb-473b-bd4b-a8054d962708','6580e2a8-db81-458c-8838-d6aee29a4cfe','f0f41e9b-83fc-4ccc-ad58-50454f14fef3','bbde4f02-b58f-4bea-a67f-0dcafe24291b','1e059600-7e0d-4ff0-a62b-947a7e3ada14','846a3382-b7ed-4387-96fd-f83e33d8daa4','0f6c9a9e-f83b-49f3-a217-faf1a5e6a304','4a20057b-8e8b-4eaf-bc8a-07870d8bcda2','82b9a911-8994-405f-8867-b399602c2f8a','7241ab97-9b5b-4006-8927-51f4459abc40','2ba22942-0c65-4e95-9210-d3588b711477','3597e4de-d423-49ca-ac71-ed305aa86979','886ea344-e9b9-4334-9fd3-c6590f59bbea','092493d4-47bd-407d-8b4d-ab3a19c91211','dd22ce4e-4b15-49ac-b684-0c30a9e5418e','13126cda-da9b-449e-8687-291323453c97','5ade5ce8-7d98-4a97-b6fb-e3dedac06e2e','14d2099f-e13c-4502-8448-52c9c21b989d','c161c8e3-43ed-408a-ae17-c21e54cb03d3','3a6a553e-76e1-440f-a5f0-e9d542033049','5070033f-9ab1-42ae-82b7-b3dedbe2e63e','3b4cd548-6b8f-4817-af6e-9746019ff662']::uuid[] );
DELETE FROM information_unit
WHERE id = ANY( ARRAY['484f4d5e-78d2-4061-bd3d-e14ade80fe17','7f6e8883-13a9-41e6-a6b6-393d13d7c13f','0090a17a-126c-40ca-a7d3-aafde0dd3401','7151cd1f-966b-4392-8caf-ee0b2f990889','f56fef52-a35c-4423-8f35-08b74d7b3f88','cb211ee6-2b61-496e-b191-ef502ea28345','3477ff71-b8a4-4dd8-b854-d86c1567ba83','5410e681-6d53-48ba-b202-076ecc857115','68375024-479a-4611-b8c9-36d7a4d78f38','982677b6-12a2-4aad-8bd6-6cef4eda8ede','caa1f95b-e720-40b6-a834-9cf5afa785e4','42d12348-0ada-4aef-8204-e3a0dc7bd768','3293c8a5-7520-4cc3-9afd-0386f71ba77d','e4366c52-b103-478b-b40d-f12143b5556a','2aa62b93-65d0-4fd4-ae6c-e6aeb5e08de8','27c7ccd7-65aa-4d3d-99a9-7c4dbf4eabbc','358062b8-2114-4832-a9d1-87fa21f578da','26ba272e-30cf-4488-81ae-f475fe2ec579','5c1b37c7-dc5c-43c7-aeb7-04c377910f0d','53ae367b-4897-47ba-be7d-e217c18c2e50','1d029e81-baa3-4269-b827-93d4cf1eddc4','b392ee8c-11da-44aa-918b-279f3edb3c36','cba42968-3549-4032-a962-bab8f5610960','11301332-7c52-47d0-9630-038b2bdb3c24','003bec16-a8c6-46b4-8bbc-ecc500e2aacb','9cecb006-806b-4baa-908c-2907ca82a870','deb8b8da-4878-47a7-bc59-f0d08a5d38fc','7aaa226c-62fc-4595-83ac-7ae169644d01','815c8573-4f34-4416-8748-3e288e5705e1','90937d05-f271-409b-8d03-4ff082757c3d','7e509cf5-8b90-4325-a5fa-f3ad7a2197d8','adcc72e9-5757-4218-9003-a15d8e19241f','a0af598b-3c8c-4b4b-9361-0bf01361f0fc','53ca2de9-d1d3-446a-9e1e-f6062e08e834','dc2c3925-5648-4477-8212-b066ea6ba1de','99b8319d-be4d-4778-910f-1da6d78ac751']::uuid[] );
COMMIT;
VPS log mirror
/opt/incomex/logs/p3d-phase5c2-dieu-35-20260514T140804Z.log