KB-1E48 rev 2
P3D Phase 5C2-R1 — DIEU-35 Rollback Keys — 20260514T103008Z
13 min read Revision 2
p3dphase5c2r1dieu35rollback-keysbefore-commit20260514T103008Z
P3D Phase 5C2-R1 — DIEU-35 Rollback Keys — 20260514T103008Z
Captured BEFORE COMMIT. This document records the exact UUIDs that would have needed rolling back if the R1 migration had committed. TRANSACTION OUTCOME: ROLLBACK (in-transaction). V-3b sub-check failed (TAC cross-system hash mismatch — body bytes preserved, hash schemes differ); the entire transaction was rolled back via
ROLLBACK;, so the UUIDs below DO NOT EXIST in the live DB. They are kept here as historical evidence of what was captured during the attempt and as proof that rollback-key dual-write (KB + VPS log) was operational before the rollback decision. Post-rollback live verification:information_unit count=12,unit_version count=19,birth_registry where collection='information_unit' count=12— all back to pre-R1 baseline. PATTERN-MATCHING DELETION IS PROHIBITED. The exact-UUID arrays below were the rollback target.
Authorization context
USER_GO=YES
GPT_FINAL_APPROVAL=YES
prompt_path=knowledge/dev/laws/dieu44-trien-khai/prompts/agent-phase5c2-r1-dieu35-pilot-migration-execution-prompt-DRAFT.md
utc_ts=20260514T103008Z
loop_count=36
Source publication
doc_code=DIEU-35
publication_id=27e48995-d6a1-4a44-8559-cab6a07fdbe0
Captured arrays (write-time)
IU UUIDs (uuid[], 36)
[
"4aec026b-a85b-405d-bccc-ff7594e39810",
"4076eb1f-a5ef-4d1b-bb12-f994eab9333d",
"406f01fe-33c3-43cc-8d01-a118e2a37f62",
"ed995011-9237-42e3-b4b0-dd4425ce0474",
"581efa11-307e-4806-8a50-892863cc6a95",
"f109ffc0-2913-4228-9275-e279df228bfa",
"dedaf90b-840b-4cca-84c1-ad5e414b232d",
"c29b1482-43a4-4700-b912-754dd902314f",
"f4d58576-ae1c-4dbb-871e-09ec82891c03",
"f42da243-dd94-4257-9d78-00ee58098b69",
"210b9773-cb15-492d-b867-dc8640c1003f",
"8763e7e9-8897-4ddf-b28f-9486893b51d4",
"229e5782-fed2-4f4f-9f47-6169d717d53e",
"bdb976dd-fb72-44ad-9843-f5025bf74e67",
"6f890d54-25d7-4ec4-acca-952ba25215ac",
"ce40dd5c-90bd-40d1-ab75-13364de25e7a",
"3fc5e9b3-5944-429c-8cdc-6a925a888205",
"c3818d2a-ec4d-407b-9b3b-b5454f0d8e33",
"ff865229-5456-45fe-accd-d3242d4677a7",
"d7ed8acf-390f-4361-b825-2f5075454271",
"66ca4899-1884-45fa-8efc-81ddcbcede10",
"de107e4a-ff2c-4a41-8708-b1a67fecd949",
"454aeb8c-17fe-425e-b021-db45ab81934c",
"7f8daca3-f426-404b-a94b-46533b93d762",
"6c193f29-3faf-4992-95ae-d794e9007c92",
"d8830381-770f-4d67-8359-c9e40a889ff4",
"85044c00-96b6-426d-b57e-b483101d537f",
"245ddc7c-e62b-463a-84ed-cb06b747b8b6",
"79cae2e5-df39-45a1-8cbe-9706d692368a",
"dd40a173-8bde-45ea-a044-e460ca6d8a7f",
"c8463ab4-80ef-419e-9344-5a0933a60d91",
"ce9d22ad-2fd8-4f62-ae0b-b8cb396ba3e7",
"652d7c52-f140-4fbc-b4fa-cb6e362a9760",
"290bfd60-797f-4630-a0d2-912fa45ccec3",
"576958ba-05c9-45e9-868d-2b6798a160e4",
"59469a1f-69ef-4255-adb9-f5adb339f48c"
]
UV UUIDs (uuid[], 36)
[
"8738bf75-a1be-41c1-9e71-d2404d064a4f",
"56484e66-fb0e-48d2-8839-36bf9d9e32d5",
"f185f049-b020-4590-9b37-90ca36c8fe1e",
"caef0346-317a-4928-b7b5-20dfa7440907",
"1d49bab6-d9a3-4f9f-aacb-0a018f7e1e26",
"15d23863-6b8f-4188-bc64-c6a5bf41333e",
"e19ecfdd-633a-410c-9917-64d481b52daf",
"e620e3ad-43a6-464a-83d9-12d8affb8bc0",
"804039fb-0b40-43b9-aad0-72a354c0680d",
"b2dd0b4e-3184-4b32-9323-6bb3797f7924",
"3bada862-0532-4d9f-9b6b-d1e83623001b",
"2adaa9fb-ef1b-4299-8487-3705df248d53",
"6f02ce2e-04cc-4d40-97a8-ac4488fcec41",
"be3d0b7f-e7f3-4b37-9857-d62f1dfd40af",
"2d324f85-85a5-49f0-a1a1-63e3a5b32d56",
"7e9cec6b-b7b5-4681-8f24-ebc73e025817",
"1d822c47-9a38-4c4c-a32f-202ab570fa70",
"5abc4244-9713-4165-aac6-f062491cc8a0",
"7225548b-efbc-484f-9cfd-864ba6addabc",
"61c07fd3-4a2e-4804-82b9-f89ab65d6644",
"d1d75bd9-11f4-431e-a882-90c066b92580",
"0bd0fec5-1fc4-409e-bc59-fa02abbf69fe",
"f0994ab2-f4c7-496f-801d-ccc86a555dc2",
"cb1c1016-c24b-4448-9f88-a6e717f83a80",
"5d2b4673-a222-46a4-840b-59700655be40",
"5c1b4d84-b8c0-4a85-b3cf-1d3115ea4e21",
"9979788b-6a3c-4d04-9b84-72682e76f1d4",
"b543e5ef-9e37-4074-a795-3dcc11c6c27d",
"b37c1b46-4188-4270-a99f-fc6784f88e5f",
"a48a0060-f7dd-4ebc-8ae7-1abdb0d0bb44",
"5187040d-11f9-4d2d-9cc6-359ff63fc2f2",
"bc908bc6-5e9f-4667-b7db-5965f91a9dfa",
"8df6e04f-34b3-46aa-925a-4f4ab88add11",
"c2d64d2b-9827-433c-a79f-6b77b5e94f47",
"5bed37e0-d1f0-4bee-a104-f5de444cb5db",
"cec50a9a-c065-4d8a-9183-b2bb7f6550f5"
]
Canonical addresses (text[], 36)
[
"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 (text[], 36)
[
"information_unit::4aec026b-a85b-405d-bccc-ff7594e39810",
"information_unit::4076eb1f-a5ef-4d1b-bb12-f994eab9333d",
"information_unit::406f01fe-33c3-43cc-8d01-a118e2a37f62",
"information_unit::ed995011-9237-42e3-b4b0-dd4425ce0474",
"information_unit::581efa11-307e-4806-8a50-892863cc6a95",
"information_unit::f109ffc0-2913-4228-9275-e279df228bfa",
"information_unit::dedaf90b-840b-4cca-84c1-ad5e414b232d",
"information_unit::c29b1482-43a4-4700-b912-754dd902314f",
"information_unit::f4d58576-ae1c-4dbb-871e-09ec82891c03",
"information_unit::f42da243-dd94-4257-9d78-00ee58098b69",
"information_unit::210b9773-cb15-492d-b867-dc8640c1003f",
"information_unit::8763e7e9-8897-4ddf-b28f-9486893b51d4",
"information_unit::229e5782-fed2-4f4f-9f47-6169d717d53e",
"information_unit::bdb976dd-fb72-44ad-9843-f5025bf74e67",
"information_unit::6f890d54-25d7-4ec4-acca-952ba25215ac",
"information_unit::ce40dd5c-90bd-40d1-ab75-13364de25e7a",
"information_unit::3fc5e9b3-5944-429c-8cdc-6a925a888205",
"information_unit::c3818d2a-ec4d-407b-9b3b-b5454f0d8e33",
"information_unit::ff865229-5456-45fe-accd-d3242d4677a7",
"information_unit::d7ed8acf-390f-4361-b825-2f5075454271",
"information_unit::66ca4899-1884-45fa-8efc-81ddcbcede10",
"information_unit::de107e4a-ff2c-4a41-8708-b1a67fecd949",
"information_unit::454aeb8c-17fe-425e-b021-db45ab81934c",
"information_unit::7f8daca3-f426-404b-a94b-46533b93d762",
"information_unit::6c193f29-3faf-4992-95ae-d794e9007c92",
"information_unit::d8830381-770f-4d67-8359-c9e40a889ff4",
"information_unit::85044c00-96b6-426d-b57e-b483101d537f",
"information_unit::245ddc7c-e62b-463a-84ed-cb06b747b8b6",
"information_unit::79cae2e5-df39-45a1-8cbe-9706d692368a",
"information_unit::dd40a173-8bde-45ea-a044-e460ca6d8a7f",
"information_unit::c8463ab4-80ef-419e-9344-5a0933a60d91",
"information_unit::ce9d22ad-2fd8-4f62-ae0b-b8cb396ba3e7",
"information_unit::652d7c52-f140-4fbc-b4fa-cb6e362a9760",
"information_unit::290bfd60-797f-4630-a0d2-912fa45ccec3",
"information_unit::576958ba-05c9-45e9-868d-2b6798a160e4",
"information_unit::59469a1f-69ef-4255-adb9-f5adb339f48c"
]
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::4aec026b-a85b-405d-bccc-ff7594e39810','information_unit::4076eb1f-a5ef-4d1b-bb12-f994eab9333d','information_unit::406f01fe-33c3-43cc-8d01-a118e2a37f62','information_unit::ed995011-9237-42e3-b4b0-dd4425ce0474','information_unit::581efa11-307e-4806-8a50-892863cc6a95','information_unit::f109ffc0-2913-4228-9275-e279df228bfa','information_unit::dedaf90b-840b-4cca-84c1-ad5e414b232d','information_unit::c29b1482-43a4-4700-b912-754dd902314f','information_unit::f4d58576-ae1c-4dbb-871e-09ec82891c03','information_unit::f42da243-dd94-4257-9d78-00ee58098b69','information_unit::210b9773-cb15-492d-b867-dc8640c1003f','information_unit::8763e7e9-8897-4ddf-b28f-9486893b51d4','information_unit::229e5782-fed2-4f4f-9f47-6169d717d53e','information_unit::bdb976dd-fb72-44ad-9843-f5025bf74e67','information_unit::6f890d54-25d7-4ec4-acca-952ba25215ac','information_unit::ce40dd5c-90bd-40d1-ab75-13364de25e7a','information_unit::3fc5e9b3-5944-429c-8cdc-6a925a888205','information_unit::c3818d2a-ec4d-407b-9b3b-b5454f0d8e33','information_unit::ff865229-5456-45fe-accd-d3242d4677a7','information_unit::d7ed8acf-390f-4361-b825-2f5075454271','information_unit::66ca4899-1884-45fa-8efc-81ddcbcede10','information_unit::de107e4a-ff2c-4a41-8708-b1a67fecd949','information_unit::454aeb8c-17fe-425e-b021-db45ab81934c','information_unit::7f8daca3-f426-404b-a94b-46533b93d762','information_unit::6c193f29-3faf-4992-95ae-d794e9007c92','information_unit::d8830381-770f-4d67-8359-c9e40a889ff4','information_unit::85044c00-96b6-426d-b57e-b483101d537f','information_unit::245ddc7c-e62b-463a-84ed-cb06b747b8b6','information_unit::79cae2e5-df39-45a1-8cbe-9706d692368a','information_unit::dd40a173-8bde-45ea-a044-e460ca6d8a7f','information_unit::c8463ab4-80ef-419e-9344-5a0933a60d91','information_unit::ce9d22ad-2fd8-4f62-ae0b-b8cb396ba3e7','information_unit::652d7c52-f140-4fbc-b4fa-cb6e362a9760','information_unit::290bfd60-797f-4630-a0d2-912fa45ccec3','information_unit::576958ba-05c9-45e9-868d-2b6798a160e4','information_unit::59469a1f-69ef-4255-adb9-f5adb339f48c']::text[] );
DELETE FROM unit_version
WHERE id = ANY( ARRAY['8738bf75-a1be-41c1-9e71-d2404d064a4f','56484e66-fb0e-48d2-8839-36bf9d9e32d5','f185f049-b020-4590-9b37-90ca36c8fe1e','caef0346-317a-4928-b7b5-20dfa7440907','1d49bab6-d9a3-4f9f-aacb-0a018f7e1e26','15d23863-6b8f-4188-bc64-c6a5bf41333e','e19ecfdd-633a-410c-9917-64d481b52daf','e620e3ad-43a6-464a-83d9-12d8affb8bc0','804039fb-0b40-43b9-aad0-72a354c0680d','b2dd0b4e-3184-4b32-9323-6bb3797f7924','3bada862-0532-4d9f-9b6b-d1e83623001b','2adaa9fb-ef1b-4299-8487-3705df248d53','6f02ce2e-04cc-4d40-97a8-ac4488fcec41','be3d0b7f-e7f3-4b37-9857-d62f1dfd40af','2d324f85-85a5-49f0-a1a1-63e3a5b32d56','7e9cec6b-b7b5-4681-8f24-ebc73e025817','1d822c47-9a38-4c4c-a32f-202ab570fa70','5abc4244-9713-4165-aac6-f062491cc8a0','7225548b-efbc-484f-9cfd-864ba6addabc','61c07fd3-4a2e-4804-82b9-f89ab65d6644','d1d75bd9-11f4-431e-a882-90c066b92580','0bd0fec5-1fc4-409e-bc59-fa02abbf69fe','f0994ab2-f4c7-496f-801d-ccc86a555dc2','cb1c1016-c24b-4448-9f88-a6e717f83a80','5d2b4673-a222-46a4-840b-59700655be40','5c1b4d84-b8c0-4a85-b3cf-1d3115ea4e21','9979788b-6a3c-4d04-9b84-72682e76f1d4','b543e5ef-9e37-4074-a795-3dcc11c6c27d','b37c1b46-4188-4270-a99f-fc6784f88e5f','a48a0060-f7dd-4ebc-8ae7-1abdb0d0bb44','5187040d-11f9-4d2d-9cc6-359ff63fc2f2','bc908bc6-5e9f-4667-b7db-5965f91a9dfa','8df6e04f-34b3-46aa-925a-4f4ab88add11','c2d64d2b-9827-433c-a79f-6b77b5e94f47','5bed37e0-d1f0-4bee-a104-f5de444cb5db','cec50a9a-c065-4d8a-9183-b2bb7f6550f5']::uuid[] );
DELETE FROM information_unit
WHERE id = ANY( ARRAY['4aec026b-a85b-405d-bccc-ff7594e39810','4076eb1f-a5ef-4d1b-bb12-f994eab9333d','406f01fe-33c3-43cc-8d01-a118e2a37f62','ed995011-9237-42e3-b4b0-dd4425ce0474','581efa11-307e-4806-8a50-892863cc6a95','f109ffc0-2913-4228-9275-e279df228bfa','dedaf90b-840b-4cca-84c1-ad5e414b232d','c29b1482-43a4-4700-b912-754dd902314f','f4d58576-ae1c-4dbb-871e-09ec82891c03','f42da243-dd94-4257-9d78-00ee58098b69','210b9773-cb15-492d-b867-dc8640c1003f','8763e7e9-8897-4ddf-b28f-9486893b51d4','229e5782-fed2-4f4f-9f47-6169d717d53e','bdb976dd-fb72-44ad-9843-f5025bf74e67','6f890d54-25d7-4ec4-acca-952ba25215ac','ce40dd5c-90bd-40d1-ab75-13364de25e7a','3fc5e9b3-5944-429c-8cdc-6a925a888205','c3818d2a-ec4d-407b-9b3b-b5454f0d8e33','ff865229-5456-45fe-accd-d3242d4677a7','d7ed8acf-390f-4361-b825-2f5075454271','66ca4899-1884-45fa-8efc-81ddcbcede10','de107e4a-ff2c-4a41-8708-b1a67fecd949','454aeb8c-17fe-425e-b021-db45ab81934c','7f8daca3-f426-404b-a94b-46533b93d762','6c193f29-3faf-4992-95ae-d794e9007c92','d8830381-770f-4d67-8359-c9e40a889ff4','85044c00-96b6-426d-b57e-b483101d537f','245ddc7c-e62b-463a-84ed-cb06b747b8b6','79cae2e5-df39-45a1-8cbe-9706d692368a','dd40a173-8bde-45ea-a044-e460ca6d8a7f','c8463ab4-80ef-419e-9344-5a0933a60d91','ce9d22ad-2fd8-4f62-ae0b-b8cb396ba3e7','652d7c52-f140-4fbc-b4fa-cb6e362a9760','290bfd60-797f-4630-a0d2-912fa45ccec3','576958ba-05c9-45e9-868d-2b6798a160e4','59469a1f-69ef-4255-adb9-f5adb339f48c']::uuid[] );
COMMIT;
VPS log mirror
/opt/incomex/logs/p3d-phase5c2-r1-dieu35-20260514T103008Z.log
Rollback keys captured 2026-05-14 20260514T103008Z. R1 transaction was still open at the time of this write.