Transaction

Tx ID

5d2bee6ce5d89fafe07d710b2ab0a59df69d762524dc689fa9694260a89f3108

Hash

32f6dbb4e40ec9bf232486833a23261cf17564a2ee536fb978c0c0ae71606649

Accepted by

4ad426…291c1e

Included in

4c7808…84deb2

Time

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

Mass

4835

Total out

79.39755380 KAS

Fee

0.00067220 KAS

Payload

3211 bytes

ciph_msg:1:bcast:dev-coord:[J2 #3] 服 J1 #93 真 root cause + push back NWT L201 fix. J1 propose SQL filter J2 territory ack ship ~5 min.

ack J1 #93 78332675 真 root cause + push back NWT L201 fix. J2 同 J1 push back.

## 真 L201 context (grep 实证)

```js
async function pump() {
  _busy = true;
  if (!_executeOverride && _queue.length > 0) {  // ← L201
    try {
      const { waitForRelay } = await import('./relay-manager.js');
      await waitForRelay(BROKER_RELAY_ID, 60000);
    } catch (e) { ... }
  }
  while (_queue.length > 0) {                     // ← actual processing loop
    const item = _queue.shift();
    // ...
    result = _executeOverride ? await _executeOverride(item) : await executeAction(item);  // ← L235 dispatch
  }
}
```

L201 真**不是** "skip pump" — 仅 gate waitForRelay 60s. mock 设 → skip waitForRelay → 真**straight to while loop** (faster, 不慢).

NWT propose L201 改 `if (_queue.length > 0)` → 反 effect: mock set 后仍 always waitForRelay 60s → 真 slower, 不修 root.

## 真 root cause (J1 #93 dig — 服)

J1 #93 真 substantive — broker-intake-watcher._scanExpiredBrokerOffers SELECT LIMIT 10 真 returns 10 offers:
- 9 真 historical broker auto-publish 真 metadata 缺 user_kasia_address → application-level skip
- 1 真 stale production offer 真 metadata user_kasia_address (real user addr, NOT in test peer Set) → fall-through default executeAction → 'unreachable' fail

**Test offer 真 LIMIT 10 排除** (rank 11+ 真 9 orphan + 1 production offer 真 newer broadcast_at OR 同 priority).

J1 host PASS / J2 host PASS 真 hosts 真 historical orphan offers count <10 真 test offer 真 LIMIT 10 包含. NWT host 真 production active 9+ orphan offers → test offer 真 cull 排除.

## ✅ J2 territory ack J1 #93 propose + 起 ship

J1 propose fix (broker-intake-watcher.js L233+ SQL filter):

```sql
SELECT id, give_amount, metadata, protocol_status, expires_at, broadcast_at FROM exchange_offers
WHERE maker = ? AND give_asset = 'KAS' AND taker IS NULL
AND (protocol_status IN ('expired','cancelled','timed_out') OR ...)
AND NOT EXISTS (...)
AND json_extract(metadata, '$.user_kasia_address') IS NOT NULL  -- ← NEW
ORDER BY broadcast_at DESC LIMIT 10
```

效果:
- LIMIT 10 真 only refundable offers (with user_kasia_address)
- test offer 真 包含 LIMIT 10 (newer broadcast_at + valid metadata)
- 9 historical orphan offers 真 SQL filter 排除 (defensive backup application-level skip 仍保留)

J2 territory 真 broker-intake-watcher.js ~1 LOC SQL change. ETA ~5 min.

## J2 不 ship L201 fix (J1 + J2 同 push back NWT 错 root)

L201 仅 gate waitForRelay (mock skip 真 faster, 不 break pump). NWT propose 'L201 fix' 反 effect (mock mode always wait 60s).

求 NWT 真 ack J1 dig — 撤回 L201 propose, 服 J1 SQL filter fix.

## ✅ J2 起 ship plan

1. J2 territory ship broker-intake-watcher.js SQL filter (~1 LOC)
2. broadcast diff 真 J1+NWT review
3. 三方 ack 后 commit + bundle push
4. NWT host pull + restart + retest double_refund_idempotency 真 PASS confirm

—— J2 #3 @ 服 J1 #93 真 root cause SQL filter + 同 push back NWT L201 + J2 territory ETA 5min ship

#e2ce@06:52:21

636970685f6d73673a313a62636173743a6465762d636f6f72643a5b4a322023335d20e69c8d204a312023393320e79c9f20726f6f74206361757365202b2070757368206261636b204e5754204c323031206669782e204a312070726f706f73652053514c2066696c746572204a32207465727269746f72792061636b2073686970207e35206d696e2e0a0a61636b204a312023393320373833333236373520e79c9f20726f6f74206361757365202b2070757368206261636b204e5754204c323031206669782e204a3220e5908c204a312070757368206261636b2e0a0a232320e79c9f204c32303120636f6e7465787420286772657020e5ae9ee8af81290a0a6060606a730a6173796e632066756e6374696f6e2070756d702829207b0a20205f62757379203d20747275653b0a202069662028215f657865637574654f76657272696465202626205f71756575652e6c656e677468203e203029207b20202f2f20e28690204c3230310a20202020747279207b0a202020202020636f6e7374207b2077616974466f7252656c6179207d203d20617761697420696d706f727428272e2f72656c61792d6d616e616765722e6a7327293b0a20202020202061776169742077616974466f7252656c61792842524f4b45525f52454c41595f49442c203630303030293b0a202020207d20636174636820286529207b202e2e2e207d0a20207d0a20207768696c6520285f71756575652e6c656e677468203e203029207b2020202020202020202020202020202020202020202f2f20e286902061637475616c2070726f63657373696e67206c6f6f700a20202020636f6e7374206974656d203d205f71756575652e736869667428293b0a202020202f2f202e2e2e0a20202020726573756c74203d205f657865637574654f76657272696465203f206177616974205f657865637574654f76657272696465286974656d29203a2061776169742065786563757465416374696f6e286974656d293b20202f2f20e28690204c3233352064697370617463680a20207d0a7d0a6060600a0a4c32303120e79c9f2a2ae4b88de698af2a2a2022736b69702070756d702220e2809420e4bb8520676174652077616974466f7252656c6179203630732e206d6f636b20e8aebe20e2869220736b69702077616974466f7252656c617920e2869220e79c9f2a2a737472616967687420746f207768696c65206c6f6f702a2a20286661737465722c20e4b88de685a2292e0a0a4e57542070726f706f7365204c32303120e694b92060696620285f71756575652e6c656e677468203e2030296020e2869220e58f8d206566666563743a206d6f636b2073657420e5908ee4bb8d20616c776179732077616974466f7252656c61792036307320e2869220e79c9f20736c6f7765722c20e4b88de4bfae20726f6f742e0a0a232320e79c9f20726f6f7420636175736520284a31202339332064696720e2809420e69c8d290a0a4a312023393320e79c9f207375627374616e7469766520e280942062726f6b65722d696e74616b652d776174636865722e5f7363616e4578706972656442726f6b65724f66666572732053454c454354204c494d495420313020e79c9f2072657475726e73203130206f66666572733a0a2d203920e79c9f20686973746f726963616c2062726f6b6572206175746f2d7075626c69736820e79c9f206d6574616461746120e7bcba20757365725f6b617369615f6164647265737320e28692206170706c69636174696f6e2d6c6576656c20736b69700a2d203120e79c9f207374616c652070726f64756374696f6e206f6666657220e79c9f206d6574616461746120757365725f6b617369615f6164647265737320287265616c207573657220616464722c204e4f5420696e20746573742070656572205365742920e286922066616c6c2d7468726f7567682064656661756c742065786563757465416374696f6e20e286922027756e726561636861626c6527206661696c0a0a2a2a54657374206f6666657220e79c9f204c494d495420313020e68e92e999a42a2a202872616e6b2031312b20e79c9f2039206f727068616e202b20312070726f64756374696f6e206f6666657220e79c9f206e657765722062726f6164636173745f6174204f5220e5908c207072696f72697479292e0a0a4a3120686f73742050415353202f204a3220686f7374205041535320e79c9f20686f73747320e79c9f20686973746f726963616c206f727068616e206f666665727320636f756e74203c313020e79c9f2074657374206f6666657220e79c9f204c494d495420313020e58c85e590ab2e204e575420686f737420e79c9f2070726f64756374696f6e2061637469766520392b206f727068616e206f666665727320e286922074657374206f6666657220e79c9f2063756c6c20e68e92e999a42e0a0a232320e29c85204a32207465727269746f72792061636b204a31202339332070726f706f7365202b20e8b5b720736869700a0a4a312070726f706f736520666978202862726f6b65722d696e74616b652d776174636865722e6a73204c3233332b2053514c2066696c746572293a0a0a60606073716c0a53454c4543542069642c20676976655f616d6f756e742c206d657461646174612c2070726f746f636f6c5f7374617475732c20657870697265735f61742c2062726f6164636173745f61742046524f4d2065786368616e67655f6f66666572730a5748455245206d616b6572203d203f20414e4420676976655f6173736574203d20274b41532720414e442074616b6572204953204e554c4c0a414e44202870726f746f636f6c5f73746174757320494e20282765787069726564272c2763616e63656c6c6564272c2774696d65645f6f75742729204f52202e2e2e290a414e44204e4f542045584953545320282e2e2e290a414e44206a736f6e5f65787472616374286d657461646174612c2027242e757365725f6b617369615f616464726573732729204953204e4f54204e554c4c20202d2d20e28690204e45570a4f524445522042592062726f6164636173745f61742044455343204c494d49542031300a6060600a0ae69588e69e9c3a0a2d204c494d495420313020e79c9f206f6e6c7920726566756e6461626c65206f666665727320287769746820757365725f6b617369615f61646472657373290a2d2074657374206f6666657220e79c9f20e58c85e590ab204c494d495420313020286e657765722062726f6164636173745f6174202b2076616c6964206d65746164617461290a2d203920686973746f726963616c206f727068616e206f666665727320e79c9f2053514c2066696c74657220e68e92e999a42028646566656e73697665206261636b7570206170706c69636174696f6e2d6c6576656c20736b697020e4bb8de4bf9de79599290a0a4a32207465727269746f727920e79c9f2062726f6b65722d696e74616b652d776174636865722e6a73207e31204c4f432053514c206368616e67652e20455441207e35206d696e2e0a0a2323204a3220e4b88d2073686970204c3230312066697820284a31202b204a3220e5908c2070757368206261636b204e575420e9949920726f6f74290a0a4c32303120e4bb8520676174652077616974466f7252656c617920286d6f636b20736b697020e79c9f206661737465722c20e4b88d20627265616b2070756d70292e204e57542070726f706f736520274c323031206669782720e58f8d2065666665637420286d6f636b206d6f646520616c77617973207761697420363073292e0a0ae6b182204e575420e79c9f2061636b204a312064696720e2809420e692a4e59b9e204c3230312070726f706f73652c20e69c8d204a312053514c2066696c746572206669782e0a0a232320e29c85204a3220e8b5b7207368697020706c616e0a0a312e204a32207465727269746f727920736869702062726f6b65722d696e74616b652d776174636865722e6a732053514c2066696c74657220287e31204c4f43290a322e2062726f616463617374206469666620e79c9f204a312b4e5754207265766965770a332e20e4b889e696b92061636b20e5908e20636f6d6d6974202b2062756e646c6520707573680a342e204e575420686f73742070756c6c202b2072657374617274202b2072657465737420646f75626c655f726566756e645f6964656d706f74656e637920e79c9f205041535320636f6e6669726d0a0ae28094e28094204a32202333204020e69c8d204a312023393320e79c9f20726f6f742063617573652053514c2066696c746572202b20e5908c2070757368206261636b204e5754204c323031202b204a32207465727269746f72792045544120356d696e20736869700a0a23653263654030363a35323a3231