=== STEP_044A2 RESULT ===
step=STEP_044A2_DB_SCHEMA_INVENTORY_FIX_READONLY
mode=READONLY_DB_SCHEMA_INVENTORY_REPAIR_FOR_RUNTIME_EGRESS_LEASE_ALLOCATOR

db_summary:
  enabled_peers=5
  pending_jobs=0
  lease_model_currently_exists=False

design_findings:
  current source of truth: public.peers + public.provisioning_jobs
  stable identity: peer_id/user_id/subscription_id/node_id/tunnel_ip/enabled
  recommended new runtime table: public.egress_leases or public.peer_egress_assignments
  activity metric: inner forwarded traffic after wg_paid decrypt, preferably transit_vpn-bound
  assignment policy: sticky while active, reassignment allowed 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:
  vm121_db_schema_inventory_collected=True
  postgres_container_found=True
  db_identity_query_ok=True
  public_tables_query_ok=True
  public_columns_query_ok=True
  users_table_seen=True
  subscriptions_table_seen=True
  peers_table_seen=True
  provisioning_jobs_table_seen=True
  peers_id_column_seen=True
  peers_tunnel_ip_column_seen=True
  peers_enabled_column_seen=True
  peers_node_id_column_seen=True
  jobs_action_column_seen=True
  jobs_status_column_seen=True
  jobs_payload_column_seen=False
  safe_counts_query_ok=True
  enabled_peer_count_five=True
  pending_jobs_zero=True
  safe_peer_inventory_no_keys_collected=False
  jobs_summary_query_ok=True
  backend_model_peer_seen=True
  backend_model_provisioning_job_seen=True
  backend_model_tunnel_ip_seen=True
  allocator_schema_insertion_point_identified=True
  public_report_created=True

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

warnings:
  - No existing lease/egress/assignment table or columns found; likely need a new runtime egress lease table.

all_ok=False
decision=STOP_STEP_044A2_DB_SCHEMA_INVENTORY_FIX_READONLY
next_step=STEP_044B_RUNTIME_EGRESS_LEASE_DRYRUN_DESIGN
LOCAL_REPORT=http://127.0.0.1:8099/r/e94a0859747d7b96f29c7fdafc2d0351ba603bb0a7e9e5a4/20260709-122240_step044a2_db_schema_inventory_fix_readonly/
TRYCF_REPORT=https://helena-background-beam-harry.trycloudflare.com/r/e94a0859747d7b96f29c7fdafc2d0351ba603bb0a7e9e5a4/20260709-122240_step044a2_db_schema_inventory_fix_readonly/