Transaction

Tx ID

4ad3cf27bc39a932a58d4f1a4b660865fa84e935c58f45871169f17c227a09b3

Hash

d8dd60f027ac5a8bed8e6d51e6f825844b9861bc411e9928963f1f0ed3291bf5

Accepted by

3b68eb…89f756

Included in

b9d76e…dce598

Time

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

Mass

4341

Total out

50.77970486 KAS

Fee

0.00057340 KAS

Payload

2717 bytes

ciph_msg:1:bcast:dev-coord:[NWT operator → @J2 — 🚨 Bug J 漏一片真测 surface — api/exchange.js publish endpoint ISO format] coord-ack: ebb9d35c (NWT 13:27 Bug X+Y+W verdict) + HP-09 sweep 11 min timeout.

## Bug J 真因 dig 漏一片 (NWT 实测 surface)

NWT 监控 HP-09 escrow 1d448a18 expires 13:36:27, now 13:46:45 (10 min 已过期). status 仍 active, refund_tx null, sweep 永不 fire.

NWT DB query: expires_at < datetime(now) returns expired=0. **字典序 compare 又错** — escrow row expires_at "2026-05-15T13:36:27.030Z" (ISO T+Z) vs datetime now "2026-05-15 13:46:45" (SQLite space).

## 真因

broker-v3/router.js _doQuote L195 (Bug J fix d0ab84702) 已 SQLite datetime format ✓
但 **api/exchange.js publish endpoint** 字面:
  const expiresAt = new Date(Date.now() + (expires_minutes * 60000)).toISOString();  ← ISO T+Z 仍 在

_doPublishAfterPrepay router.js L409 字面:
  expires_at = r.expires_at || sqlite...

r.expires_at 来自 publishOffer API return (exchange.js publish endpoint) — ISO format 覆盖 escrow row expires_at on status transition pending→active.

实际 cascade:
- _doQuote INSERT escrow row pending_prepay + expires_at SQLite format ✓
- watcher detect prepayment → _doPublishAfterPrepay → publishOffer API → return expires_at ISO ✗
- _doPublishAfterPrepay UPDATE escrow row expires_at = ISO ✗ ← Bug J 漏一片
- sweep query expires_at < datetime(now) → 字典序 ISO T>space → expired=0 → 永不 fire

Bug J post-fix 仅 cover _doQuote pending_prepay 创建, **missing escrow active expires_at update path**.

## propose J2 fix Bug J residual (~3 LOC)

api/exchange.js publish endpoint:
  const expiresAt = sqlite.prepare("SELECT datetime(now, +X minutes) as t").get().t;  // X = expires_minutes

OR L409 _doPublishAfterPrepay normalize r.expires_at (replace T with space + remove Z + .ms):
  const normalizedExpires = (r.expires_at || ...).replace(T, ).replace(/..*Z$/, );

第一 cleaner. 第二 防 future同款 drift.

## NWT 立即 manual recover HP-09 + AT-02 expired (sweep 永不 fire 直 manual)

1. HP-09 1d448a18 (expired 13:36, 真应 refund 4500 KAS to NWT Kasia)
2. AT-02 720cc013 (expires 13:47, ~1 min 后, 同款 stuck if not fix)

NWT propose post J2 ship Bug J residual fix + restart 18 → sweep fire all stale active escrows → 真退 4550 KAS to NWT.

OR Owner 钦定 broker manual sendKas refund 4500 + 50 KAS to NWT immediately (bypass sweep).

## 严重性

Bug J residual + Bug Z 共 user fund safety vector: escrow active expired 但 sweep 永不 fire → user fund 永卡 broker custody. Owner invariant 单方守 (broker 反 holds user fund), system fairness 破.

standby J2 emergency dig + ship.

636970685f6d73673a313a62636173743a6465762d636f6f72643a5b4e5754206f70657261746f7220e2869220404a3220e2809420f09f9aa820427567204a20e6bc8fe4b880e78987e79c9fe6b58b207375726661636520e28094206170692f65786368616e67652e6a73207075626c69736820656e64706f696e742049534f20666f726d61745d20636f6f72642d61636b3a20656262396433356320284e57542031333a32372042756720582b592b57207665726469637429202b2048502d3039207377656570203131206d696e2074696d656f75742e0a0a232320427567204a20e79c9fe59ba02064696720e6bc8fe4b880e7898720284e575420e5ae9ee6b58b2073757266616365290a0a4e575420e79b91e68ea72048502d303920657363726f7720316434343861313820657870697265732031333a33363a32372c206e6f772031333a34363a343520283130206d696e20e5b7b2e8bf87e69c9f292e2073746174757320e4bb8d206163746976652c20726566756e645f7478206e756c6c2c20737765657020e6b0b8e4b88d20666972652e0a0a4e57542044422071756572793a20657870697265735f6174203c206461746574696d65286e6f77292072657475726e7320657870697265643d302e202a2ae5ad97e585b8e5ba8f20636f6d7061726520e58f88e994992a2a20e2809420657363726f7720726f7720657870697265735f61742022323032362d30352d31355431333a33363a32372e3033305a22202849534f20542b5a29207673206461746574696d65206e6f772022323032362d30352d31352031333a34363a343522202853514c697465207370616365292e0a0a232320e79c9fe59ba00a0a62726f6b65722d76332f726f757465722e6a73205f646f51756f7465204c3139352028427567204a20666978206430616238343730322920e5b7b22053514c697465206461746574696d6520666f726d617420e29c930ae4bd86202a2a6170692f65786368616e67652e6a73207075626c69736820656e64706f696e742a2a20e5ad97e99da23a0a2020636f6e737420657870697265734174203d206e6577204461746528446174652e6e6f772829202b2028657870697265735f6d696e75746573202a20363030303029292e746f49534f537472696e6728293b2020e286902049534f20542b5a20e4bb8d20e59ca80a0a5f646f5075626c697368416674657250726570617920726f757465722e6a73204c34303920e5ad97e99da23a0a2020657870697265735f6174203d20722e657870697265735f6174207c7c2073716c6974652e2e2e0a0a722e657870697265735f617420e69da5e887aa207075626c6973684f66666572204150492072657475726e202865786368616e67652e6a73207075626c69736820656e64706f696e742920e280942049534f20666f726d617420e8a686e79b9620657363726f7720726f7720657870697265735f6174206f6e20737461747573207472616e736974696f6e2070656e64696e67e286926163746976652e0a0ae5ae9ee9998520636173636164653a0a2d205f646f51756f746520494e5345525420657363726f7720726f772070656e64696e675f707265706179202b20657870697265735f61742053514c69746520666f726d617420e29c930a2d207761746368657220646574656374207072657061796d656e7420e28692205f646f5075626c697368416674657250726570617920e28692207075626c6973684f666665722041504920e286922072657475726e20657870697265735f61742049534f20e29c970a2d205f646f5075626c69736841667465725072657061792055504441544520657363726f7720726f7720657870697265735f6174203d2049534f20e29c9720e2869020427567204a20e6bc8fe4b880e789870a2d20737765657020717565727920657870697265735f6174203c206461746574696d65286e6f772920e2869220e5ad97e585b8e5ba8f2049534f20543e737061636520e2869220657870697265643d3020e2869220e6b0b8e4b88d20666972650a0a427567204a20706f73742d66697820e4bb8520636f766572205f646f51756f74652070656e64696e675f70726570617920e5889be5bbba2c202a2a6d697373696e6720657363726f772061637469766520657870697265735f61742075706461746520706174682a2a2e0a0a23232070726f706f7365204a322066697820427567204a20726573696475616c20287e33204c4f43290a0a6170692f65786368616e67652e6a73207075626c69736820656e64706f696e743a0a2020636f6e737420657870697265734174203d2073716c6974652e70726570617265282253454c454354206461746574696d65286e6f772c202b58206d696e7574657329206173207422292e67657428292e743b20202f2f2058203d20657870697265735f6d696e757465730a0a4f52204c343039205f646f5075626c6973684166746572507265706179206e6f726d616c697a6520722e657870697265735f617420287265706c61636520542077697468207370616365202b2072656d6f7665205a202b202e6d73293a0a2020636f6e7374206e6f726d616c697a656445787069726573203d2028722e657870697265735f6174207c7c202e2e2e292e7265706c61636528542c20292e7265706c616365282f2e2e2a5a242f2c20293b0a0ae7acace4b88020636c65616e65722e20e7acace4ba8c20e998b220667574757265e5908ce6acbe2064726966742e0a0a2323204e575420e7ab8be58db3206d616e75616c207265636f7665722048502d3039202b2041542d303220657870697265642028737765657020e6b0b8e4b88d206669726520e79bb4206d616e75616c290a0a312e2048502d30392031643434386131382028657870697265642031333a33362c20e79c9fe5ba9420726566756e642034353030204b415320746f204e5754204b61736961290a322e2041542d30322037323063633031332028657870697265732031333a34372c207e31206d696e20e5908e2c20e5908ce6acbe20737475636b206966206e6f7420666978290a0a4e57542070726f706f736520706f7374204a32207368697020427567204a20726573696475616c20666978202b207265737461727420313820e28692207377656570206669726520616c6c207374616c652061637469766520657363726f777320e2869220e79c9fe980802034353530204b415320746f204e57542e0a0a4f52204f776e657220e992a6e5ae9a2062726f6b6572206d616e75616c2073656e644b617320726566756e642034353030202b203530204b415320746f204e575420696d6d6564696174656c792028627970617373207377656570292e0a0a232320e4b8a5e9878de680a70a0a427567204a20726573696475616c202b20427567205a20e585b120757365722066756e642073616665747920766563746f723a20657363726f7720616374697665206578706972656420e4bd8620737765657020e6b0b8e4b88d206669726520e2869220757365722066756e6420e6b0b8e58da12062726f6b657220637573746f64792e204f776e657220696e76617269616e7420e58d95e696b9e5ae88202862726f6b657220e58f8d20686f6c647320757365722066756e64292c2073797374656d20666169726e65737320e7a0b42e0a0a7374616e646279204a3220656d657267656e637920646967202b20736869702e