A
AIOS Wiki
read-only · public mirror
Open AIOS
TicketstobyTOBY-5
BacklogBugHigh

Stripe→Postgres sync: force-finalize 8,833 zombie trialing subs

Assignees
Unassigned
Created
5/11/2026, 10:34:52 PM
Source
content/artifacts/toby-state-of-business---nightly-report/b9bfe5ec-9a61-4206-89bf-3257224a21dc/state-of-business-2026-05-18.html

8,833 subscriptions have status='trialing' with trial_end older than 180 days (oldest from 2023). Stripe should have transitioned these to canceled or active long ago. Owner action: (a) re-poll Stripe per subscription_id and reconcile, OR (b) run a one-shot Stripe Sigma reconciliation to bulk-transition them. Until fixed, every trial/funnel calc is polluted by ~8.8K phantom rows. Source: state-of-business-2026-05-18.html, query SELECT count(*) FROM subscriptions WHERE status='trialing' AND trial_end < now() - interval '180 days' = 8833.