22-P2 — Raw SQL Log

Source: VPS 38.242.240.89 — /tmp/22-p2.20260506-045033.log Executed: 2026-05-06 04:50:33 UTC | phase_status=PASS

            set_config             
-----------------------------------
 pilot.p2.20260506-045033.e0ae7ec5
(1 row)

      set_config       
-----------------------
 test.p2.plan.4c6b47b2
(1 row)

      set_config       
-----------------------
 test.p2.plan.1c8a49ec
(1 row)

DO
DO
DO
NOTICE:  PREFLIGHT_JSON={"status": "pass", "fk_name": "fk_iu_version_anchor", "fk_initially_deferred": true}
DO
DO
DO
DO
       tbl        | count 
------------------+-------
 information_unit |     1
 unit_version     |     1
 birth_iu         |     1
 birth_total      | 81211
(4 rows)

DO
BEGIN
CREATE FUNCTION
CREATE FUNCTION
REVOKE
REVOKE
DO
DO
DO
DO
DO
DO
DO
WARNING:  Birth gate L1 PILOT-ONLY: P-pub1 missing — production sẽ BLOCK
WARNING:  Birth gate L1 PILOT-ONLY: P-pub2 missing — production sẽ BLOCK
DO
NOTICE:  ALL PASS: pilot.p2.20260506-045033.e0ae7ec5
 routine_schema |   routine_name    | grantee  | privilege_type 
----------------+-------------------+----------+----------------
 public         | fn_iu_create      | directus | EXECUTE
 public         | fn_iu_create_plan | directus | EXECUTE
(2 rows)

      proname      |  owner   | prosecdef | provolatile 
-------------------+----------+-----------+-------------
 fn_iu_create      | directus | t         | v
 fn_iu_create_plan | directus | t         | s
(2 rows)

COMMIT
 post_commit_status |                                                                verify_json                                                                |           pilot_address           
--------------------+-------------------------------------------------------------------------------------------------------------------------------------------+-----------------------------------
 PASS               | {"all_pass": true, "i1_iu_exists": true, "i2_uv_linked": true, "i5_uv_birth_ok": true, "i4_birth_exists": true, "i3_anchors_exact": true} | pilot.p2.20260506-045033.e0ae7ec5
(1 row)

       tbl        | count 
------------------+-------
 information_unit |     2
 unit_version     |     2
 birth_iu         |     2
 birth_total      | 81212
(4 rows)