Paradaux

PAR-131

0

Investigate ticket regarding Walgreens transactions

CanceledHighrianTesksBug

User reported an issue with buying/selling to the Walgreens company. When attempting these transactions, the system indicates that the transactions are linked to a player named kydradabeast, who hasn't been online in over 2 years. Screenshot attached for reference.


screenshot

Comments

tesks · Jun 11, 2026, 11:21 AM

Triage: Walgreens stale-owner hypothesis — NOT reproducible in current prod data

Data finding (firm "Walgreens"):

  • firm row: firm_id=902, display_name=Walgreens, is_archived=0, default_account_id=103403, proprietor 74C29469-907B-48B5-9E3F-F3CF44514CB4 = Trentrick_Lamar.
  • firm_accounts for 902: single account 103403 (BUSINESS, "Walgreens Corporate Account", removed_at=NULL). Its owner_uuid_bin = 74C29469-… = Trentrick_Lamar — i.e. owner already equals the current proprietor.
  • Access on 103403: account_members = {Trentrick_Lamar, left_at NULL}; account_authorizers = {Trentrick_Lamar, revoked_at NULL}. Proprietor is already member + authorizer.
  • firm_employee for 902: only Trentrick_Lamar (role 4506, not left).
  • firm_transfer_requests for 902: 0 rows — no recorded handover.

About "kydradabeast":

  • firm_players has KydraDaBeast = EF9A429C-C524-454A-B2A7-347E68AC657B — a completely different UUID from the account owner (74C29469-…).
  • KydraDaBeast owns only her own PERSONAL account (id 1168). She owns no Walgreens/business account and has no member/authorizer/employee row on account 103403 or firm 902.

Remediation-set check: account 103403 is not in the PAR-141 remediated set {103518,105539,105545,105548,108944} (Costco/UMStone/UMTree/UMNet/Deliveroo), yet it still shows the correct (non-stale) owner. Current global drift is 0, consistent with this.

Conclusion

This is not the PAR-141 stale-owner bug in current data. The Walgreens Treasury account owner already points at the current proprietor (Trentrick_Lamar), KydraDaBeast has zero relationship to firm 902, and there is no owner/proprietor drift to fix. No remediation SQL is warranted — reassigning owner here would be a no-op (owner already == proprietor).

The reporter's screenshot is dated 2026-06-05 and shows "kydradabeast". Since the DB is now clean, the most likely explanations are:

  1. The drift was already remediated / self-healed before this triage (the firm changed hands away from KydraDaBeast, account owner was corrected), or
  2. A ChestShop sign cached the old owner name on physical signs — ChestShop legacy b:<FirmName>B:<accountId> self-heals lazily on next interaction; signs touched before the fix may still render the stale name until re-interacted.

Recommended next step (needs reporter / in-game confirmation)

  1. Ask the reporter to re-test a buy/sell at the Walgreens shop now and report the counterparty name shown — if it now reads "Trentrick_Lamar", the issue is resolved and this can be closed.
  2. If it still shows "kydradabeast" in-game, capture the exact shop-sign owner line / account reference (e.g. b: vs B:<id>) — that points to a stale ChestShop sign rather than a Treasury account-owner problem, and would need a sign re-touch / ChestShop legacy-migration check, not an owner_uuid_bin reassignment.

No DB write performed. Classification: duplicate-or-fixed (covered by / consistent with PAR-141; current data shows no stale-owner drift for Walgreens).

Activity

  • paradaux description: Description updated
  • paradaux changed status to Status → Canceled
  • tesks commented
  • tesks created the issue