5 Commits (dev)

Author	SHA1	Message	Date
Shlee	07367c4ea2	Update UserStorageServiceTest.php	2 weeks ago
Your Name	007f97f987	Expand test coverage for storage_used improvements ... - Suspended/missing user guards for get, increase, decrement, recalculate - Staleness window boundary (fresh at N-1h, stale at N+1h) - Sub-1000-byte rounding on increase/decrement (floor to KB) - Command --stale filter (only recomputes stale/never-calculated users) and missing --user id failure - Migration dispatches the backfill job to the low queue (Bus::fake)	2 weeks ago
Your Name	61a1c30756	Self-heal stale storage_used on read to unblock stuck accounts ... UserStorageService::get() now recalculates from source when the cached counter is missing or older than STALE_AFTER_HOURS, instead of returning a possibly-inflated cached value. This is what unblocks a user stuck at the account size limit: the limit check on their next upload attempt reads the freshly recalculated real usage rather than the drifted value (#7169). The upload flow reads get() and enforces the limit BEFORE the write-path heal runs, so a blocked user could never self-heal via upload/delete alone. Healing on read closes that gap and makes the scheduled reconciler a belt-and-suspenders safety net rather than a requirement. A fresh counter is still trusted as-is (no per-read SUM). Adds tests for the stale-get recompute and fresh-get trust paths.	2 weeks ago
Your Name	26d3e8bb8e	Self-heal stale storage_used on upload/delete hot path ... Make increaseStorageUsed/decrementStorageUsed recalculate from source when the cached counter is older than STALE_AFTER_HOURS (168h) or never calculated, so an affected user is corrected the next time they upload or delete without waiting for the nightly reconciler. Callers save/delete the media row before calling these, so the from-source recalc already reflects the change and the incremental delta is skipped on the recalc path. - Add UserStorageService::STALE_AFTER_HOURS and isStale() helper (no extra query: reads the already-loaded model), with defensive Carbon parsing - Cast users.storage_used_updated_at to datetime so freshness comparisons work on a Carbon instance - Add tests for stale/fresh/never-calculated increase and decrement paths	2 weeks ago
Your Name	6496904293	Fix account storage limit not freeing on media deletion (#7169) ... users.storage_used only ever grew: uploads incremented it but no deletion path decremented it, so users hit the account size limit even when their real media usage was well below it. - Decrement storage_used in MediaDeletePipeline when media is removed - Add UserStorageService::increaseStorageUsed / decrementStorageUsed as the fast, symmetric hot-path counter updates (floor-based, clamped at zero) - Refactor the 6 upload call sites to use increaseStorageUsed instead of duplicated inline writes (also fixes ceil/floor drift vs the reconciler) - Add (user_id, size) covering index so per-user SUM(size) is not a full table scan (INPLACE/LOCK=NONE, skipped on sqlite) - Add user:storage:recalculate command to repair affected accounts, with a daily --stale=168 scheduled reconciler to correct any drift - Add regression tests for the pipeline and UserStorageService	2 weeks ago