Artifacts

• facts.json
• report.txt
• vm121_db_corrected.json
• columns_focus.txt
• safe_counts.txt
• safe_peer_inventory_no_keys.txt
• jobs_summary.txt
• lease_egress_search.txt

Report

=== STEP_044A3 RESULT ===
step=STEP_044A3_DB_SCHEMA_CONTRACT_CLOSE_READONLY
mode=READONLY_CLOSE_DB_SCHEMA_INVENTORY_WITH_ACTUAL_COLUMNS

db_summary:
  enabled_peers=5
  pending_jobs=0
  actual_job_payload_column=payload_json
  peers has no subscription_id column; use peer.id/user_id/node_id/tunnel_ip/paid_until/enabled
  lease_schema_exists=False

design_findings:
  current source of truth: public.peers + public.provisioning_jobs
  new runtime table needed: public.peer_egress_leases
  activity metric: inner useful forwarded traffic after wg_paid decrypt, preferably transit_vpn-bound
  policy: sticky while active, reassign after idle

tunable_constants:
  ROUTER_EGRESS_SAMPLE_SECONDS=120
  ROUTER_EGRESS_IDLE_SECONDS=900
  ROUTER_EGRESS_ACTIVE_MIN_PACKETS=10
  ROUTER_EGRESS_ACTIVE_MIN_BYTES=16384
  ROUTER_EGRESS_REASSIGN_COOLDOWN_SECONDS=900

success_checks:
  postgres_container_found=True
  columns_query_ok=True
  peers_id_column_seen=True
  peers_user_id_column_seen=True
  peers_node_id_column_seen=True
  peers_tunnel_ip_column_seen=True
  peers_paid_until_column_seen=True
  peers_enabled_column_seen=True
  jobs_payload_json_column_seen=True
  jobs_action_column_seen=True
  jobs_status_column_seen=True
  safe_counts_query_ok=True
  enabled_peer_count_five=True
  pending_jobs_zero=True
  safe_peer_inventory_no_keys_collected=True
  jobs_summary_query_ok=True
  no_existing_lease_schema_confirmed=True
  allocator_schema_need_identified=True
  public_report_created=True

expected_absence:
  private_material_published=False
  safe_peer_inventory_contains_public_key=False
  safe_peer_inventory_contains_preshared_key=False
  manual_agent_service_start_used=False
  vm100_changed=False
  vm101_changed=False
  vm121_changed=False

warnings:
  - No existing lease/egress/assignment schema exists; next step should design a new runtime egress lease table.

all_ok=True
decision=PASS_STEP_044A3_DB_SCHEMA_CONTRACT_CLOSE_READONLY
next_step=STEP_044B_RUNTIME_EGRESS_LEASE_DRYRUN_DESIGN
LOCAL_REPORT=http://127.0.0.1:8099/r/e94a0859747d7b96f29c7fdafc2d0351ba603bb0a7e9e5a4/20260709-122413_step044a3_db_schema_contract_close_readonly/
TRYCF_REPORT=https://helena-background-beam-harry.trycloudflare.com/r/e94a0859747d7b96f29c7fdafc2d0351ba603bb0a7e9e5a4/20260709-122413_step044a3_db_schema_contract_close_readonly/