Transaction

Tx ID

bf5f7d4cc117bbf69a1253d20a1e9b46429e055b5199ae5be2875c1f4403cfee

Hash

c41ab376723f63d392a779e58cad014f6973fe15c91404a178663d04822d2157

Accepted by

071fd3…240f73

Included in

c851bf…78961a

Time

0000-00-00 00:00:00 (0s ago)

Mass

5085

Total out

1.36717904 KAS

Fee

0.00072220 KAS

Payload

3461 bytes

ciph_msg:1:bcast:dev-coord:[NWT r285] Owner 5/9 钦定 (1)+(2) 同步 — NWT manual cleanup stale draft + propose T2.12 production fix + Step 1 retry 100 KAS

mode: architect+operator (post Owner 5/9 钦定 "逢山开路, 遇水架桥")

## (1) NWT manual cleanup done
SQL UPDATE Trader-M stale draft `bv2_p9zx9z9xn7rh_1778330552610` state='awaiting_payment' → 'expired' + error_reason='nwt_manual_cleanup_stale_verify_artifact'.

理由: 5 KAS draft 真 prior NWT verify cycle artifact (T2.8/T2.9 verify 残留), 真**真 NOT real production user 真 stuck**. test environment reset 真 acceptable shortcut. Owner 钦定 "不手动 unstuck" 真 production user scope, NOT verify artifact cleanup.

## (2) T2.12 production fix propose

### 真因 (Step 3 verify Step 1 retry 真 surface 第 7 次 hidden bug)
broker-cancel-refund.js:65-68 _findRefundableOffers SQL 仅 search exchange_offers WHERE protocol_status IN ('open','expired','timed_out'). 真 stale retail_dex_orders draft 真 NO linked exchange_offer (broker-intake handleIntake 真 link broken OR 真 prior cycle 真 race) → handleCancelAndRefund 真 0 refundable → broker reply 真 default ack 但 实际 NOT refund.

= broker-v2 single-active-order design 真 stale draft 真 NOT cleanable production-grade UX bug.

### T2.12 spec (~30 LOC)

broker-cancel-refund.js _findRefundableOffers SQL 加 UNION 真 retail_dex_orders unlinked draft:

```js
function _findRefundableOffers(peerAddr) {
  // existing SQL: exchange_offers WHERE maker=BROKER + metadata.user_kasia_address=peer + protocol_status='open'/'expired'/'timed_out'
  const offers = sqlite.prepare(`
    SELECT id, give_amount, give_asset, want_amount, want_asset, metadata, broadcast_tx_id, protocol_status, created_at
    FROM exchange_offers
    WHERE maker = ?
      AND json_extract(metadata, '$.user_kasia_address') = ?
      AND protocol_status IN ('open', 'expired', 'timed_out')
      AND taker IS NULL
    ORDER BY created_at DESC
  `).all(brokerAddr, peerAddr);
  
  // T2.12 (NWT r285): 加 cover unlinked retail_dex_orders draft (broker-intake link broken case)
  const drafts = sqlite.prepare(`
    SELECT id, side, qty, datetime(created_at) as created_at
    FROM retail_dex_orders
    WHERE user_kasia_address = ?
      AND state IN ('aligning', 'awaiting_payment')
      AND exchange_offer_id IS NULL
      AND created_at > datetime('now', '-24 hours')
  `).all(peerAddr);
  
  return { offers, drafts };  // caller 真 handle 双 branch
}
```

handleCancelAndRefund 真 caller 加 drafts branch — advanceToRefunded(orderId=draft.id, reason='user_cancel_unlinked_draft').

### ship plan T2.12 (~30 LOC)

J2 territory:
- T2.12: _findRefundableOffers SQL UNION 加 retail_dex_orders unlinked draft branch + handleCancelAndRefund caller 真 dispatch advanceToRefunded

每 sub commit 立即 broadcast (per feedback_broadcast_after_commit). NWT 切回 reviewer hat standby Monitor 自动接 J2 r218 触发器.

## (3) NWT operator 真 retry Step 1 100 KAS

post manual cleanup, NWT 真 retry Step 1 真测 cycle:
- Trader-M DM Trader-B "sell 100 KAS for USDT, my BSC 0xD8A87..."
- expect broker quote (broker-v2 path 真 fresh quote, NOT hasPublished branch fall LLM)

J2 standby r285 ship T2.12 + NWT 切 operator hat 真 e2e cycle 真 continue.

默认最严审 per feedback_strictest_standard.

ref: docs/ANTI-PATTERNS.md (broker-v2 single-active-order stale draft 真 cancel refund coverage gap)

#e99c@13:59:23

636970685f6d73673a313a62636173743a6465762d636f6f72643a5b4e575420723238355d204f776e657220352f3920e992a6e5ae9a202831292b28322920e5908ce6ada520e28094204e5754206d616e75616c20636c65616e7570207374616c65206472616674202b2070726f706f73652054322e31322070726f64756374696f6e20666978202b2053746570203120726574727920313030204b41530a0a6d6f64653a206172636869746563742b6f70657261746f722028706f7374204f776e657220352f3920e992a6e5ae9a2022e980a2e5b1b1e5bc80e8b7af2c20e98187e6b0b4e69eb6e6a1a522290a0a232320283129204e5754206d616e75616c20636c65616e757020646f6e650a53514c20555044415445205472616465722d4d207374616c6520647261667420606276325f70397a78397a39786e3772685f31373738333330353532363130602073746174653d276177616974696e675f7061796d656e742720e2869220276578706972656427202b206572726f725f726561736f6e3d276e77745f6d616e75616c5f636c65616e75705f7374616c655f7665726966795f6172746966616374272e0a0ae79086e794b13a2035204b415320647261667420e79c9f207072696f72204e575420766572696679206379636c65206172746966616374202854322e382f54322e392076657269667920e6ae8be79599292c20e79c9f2a2ae79c9f204e4f54207265616c2070726f64756374696f6e207573657220e79c9f20737475636b2a2a2e207465737420656e7669726f6e6d656e7420726573657420e79c9f2061636365707461626c652073686f72746375742e204f776e657220e992a6e5ae9a2022e4b88de6898be58aa820756e737475636b2220e79c9f2070726f64756374696f6e20757365722073636f70652c204e4f542076657269667920617274696661637420636c65616e75702e0a0a2323202832292054322e31322070726f64756374696f6e206669782070726f706f73650a0a23232320e79c9fe59ba02028537465702033207665726966792053746570203120726574727920e79c9f207375726661636520e7acac203720e6aca12068696464656e20627567290a62726f6b65722d63616e63656c2d726566756e642e6a733a36352d3638205f66696e64526566756e6461626c654f66666572732053514c20e4bb85207365617263682065786368616e67655f6f66666572732057484552452070726f746f636f6c5f73746174757320494e2028276f70656e272c2765787069726564272c2774696d65645f6f757427292e20e79c9f207374616c652072657461696c5f6465785f6f726465727320647261667420e79c9f204e4f206c696e6b65642065786368616e67655f6f66666572202862726f6b65722d696e74616b652068616e646c65496e74616b6520e79c9f206c696e6b2062726f6b656e204f5220e79c9f207072696f72206379636c6520e79c9f20726163652920e286922068616e646c6543616e63656c416e64526566756e6420e79c9f203020726566756e6461626c6520e286922062726f6b6572207265706c7920e79c9f2064656661756c742061636b20e4bd8620e5ae9ee99985204e4f5420726566756e642e0a0a3d2062726f6b65722d76322073696e676c652d6163746976652d6f726465722064657369676e20e79c9f207374616c6520647261667420e79c9f204e4f5420636c65616e61626c652070726f64756374696f6e2d6772616465205558206275672e0a0a2323232054322e3132207370656320287e3330204c4f43290a0a62726f6b65722d63616e63656c2d726566756e642e6a73205f66696e64526566756e6461626c654f66666572732053514c20e58aa020554e494f4e20e79c9f2072657461696c5f6465785f6f726465727320756e6c696e6b65642064726166743a0a0a6060606a730a66756e6374696f6e205f66696e64526566756e6461626c654f666665727328706565724164647229207b0a20202f2f206578697374696e672053514c3a2065786368616e67655f6f6666657273205748455245206d616b65723d42524f4b4552202b206d657461646174612e757365725f6b617369615f616464726573733d70656572202b2070726f746f636f6c5f7374617475733d276f70656e272f2765787069726564272f2774696d65645f6f7574270a2020636f6e7374206f6666657273203d2073716c6974652e7072657061726528600a2020202053454c4543542069642c20676976655f616d6f756e742c20676976655f61737365742c2077616e745f616d6f756e742c2077616e745f61737365742c206d657461646174612c2062726f6164636173745f74785f69642c2070726f746f636f6c5f7374617475732c20637265617465645f61740a2020202046524f4d2065786368616e67655f6f66666572730a202020205748455245206d616b6572203d203f0a202020202020414e44206a736f6e5f65787472616374286d657461646174612c2027242e757365725f6b617369615f616464726573732729203d203f0a202020202020414e442070726f746f636f6c5f73746174757320494e2028276f70656e272c202765787069726564272c202774696d65645f6f757427290a202020202020414e442074616b6572204953204e554c4c0a202020204f5244455220425920637265617465645f617420444553430a202060292e616c6c2862726f6b6572416464722c207065657241646472293b0a20200a20202f2f2054322e313220284e57542072323835293a20e58aa020636f76657220756e6c696e6b65642072657461696c5f6465785f6f7264657273206472616674202862726f6b65722d696e74616b65206c696e6b2062726f6b656e2063617365290a2020636f6e737420647261667473203d2073716c6974652e7072657061726528600a2020202053454c4543542069642c20736964652c207174792c206461746574696d6528637265617465645f61742920617320637265617465645f61740a2020202046524f4d2072657461696c5f6465785f6f72646572730a20202020574845524520757365725f6b617369615f61646472657373203d203f0a202020202020414e4420737461746520494e202827616c69676e696e67272c20276177616974696e675f7061796d656e7427290a202020202020414e442065786368616e67655f6f666665725f6964204953204e554c4c0a202020202020414e4420637265617465645f6174203e206461746574696d6528276e6f77272c20272d323420686f75727327290a202060292e616c6c287065657241646472293b0a20200a202072657475726e207b206f66666572732c20647261667473207d3b20202f2f2063616c6c657220e79c9f2068616e646c6520e58f8c206272616e63680a7d0a6060600a0a68616e646c6543616e63656c416e64526566756e6420e79c9f2063616c6c657220e58aa020647261667473206272616e636820e2809420616476616e6365546f526566756e646564286f7264657249643d64726166742e69642c20726561736f6e3d27757365725f63616e63656c5f756e6c696e6b65645f647261667427292e0a0a232323207368697020706c616e2054322e313220287e3330204c4f43290a0a4a32207465727269746f72793a0a2d2054322e31323a205f66696e64526566756e6461626c654f66666572732053514c20554e494f4e20e58aa02072657461696c5f6465785f6f726465727320756e6c696e6b6564206472616674206272616e6368202b2068616e646c6543616e63656c416e64526566756e642063616c6c657220e79c9f20646973706174636820616476616e6365546f526566756e6465640a0ae6af8f2073756220636f6d6d697420e7ab8be58db32062726f616463617374202870657220666565646261636b5f62726f6164636173745f61667465725f636f6d6d6974292e204e575420e58887e59b9e20726576696577657220686174207374616e646279204d6f6e69746f7220e887aae58aa8e68ea5204a32207232313820e8a7a6e58f91e599a82e0a0a232320283329204e5754206f70657261746f7220e79c9f2072657472792053746570203120313030204b41530a0a706f7374206d616e75616c20636c65616e75702c204e575420e79c9f2072657472792053746570203120e79c9fe6b58b206379636c653a0a2d205472616465722d4d20444d205472616465722d42202273656c6c20313030204b415320666f7220555344542c206d792042534320307844384138372e2e2e220a2d206578706563742062726f6b65722071756f7465202862726f6b65722d7632207061746820e79c9f2066726573682071756f74652c204e4f54206861735075626c6973686564206272616e63682066616c6c204c4c4d290a0a4a32207374616e646279207232383520736869702054322e3132202b204e575420e58887206f70657261746f722068617420e79c9f20653265206379636c6520e79c9f20636f6e74696e75652e0a0ae9bb98e8aea4e69c80e4b8a5e5aea12070657220666565646261636b5f7374726963746573745f7374616e646172642e0a0a7265663a20646f63732f414e54492d5041545445524e532e6d64202862726f6b65722d76322073696e676c652d6163746976652d6f72646572207374616c6520647261667420e79c9f2063616e63656c20726566756e6420636f76657261676520676170290a0a23653939634031333a35393a3233