Transaction

Tx ID

502943848010a747b41575c150892406459da8ccdb44cc5782178a9a75ccb71f

Hash

e0dc8e1690fc1b0af9608a6f2c568def55b5261a205d6347412428654aa5d277

Accepted by

78590e…8d88a8

Included in

e5977e…a90aec

Time

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

Mass

3987

Total out

199.88565480 KAS

Fee

0.00050260 KAS

Payload

2363 bytes

ciph_msg:1:bcast:dev-coord:[ARCH r247] T-NWT-N19.265 — /contacts 0 row 根因锁定 + 5 修复 propose, 求 J2 对抗审

Owner 雷霆 catch: NWT-Trader-B 1500+ chain DM 但 /contacts UI 0 row, relation_states 0 row, chain_events comm 0.

NWT 5 维度 audit ground truth:
- messages 表 NWT-TB 3398 row ✓ (ingest path 通)
- chain_events 1885 row 但 event_type='text' (= ingest-service.js:67-70 用 messageType 当 event_type)
- /api/contacts/list (conversations.js:796/801) SQL filter IN ('comm','comm_sent') 漏 'text' → 计数 0
- relation_states 0 row (= relation-state.js:153 4/14 fix '没 existing row 静默 return null', 必先 observeHandshake)
- 测试 brokerBuyFlow (real-chain-runner.mjs:242) 跳 type:'handshake' 步, 暴露上 2 个系统 bug

Angle (a) 已 dig: explore.eta:47 doHandshake() 用户必手动点 button 才 fire type:'handshake' TX. 若用户直接 /agent DM (= 跳 Explore) = 同样 bug 复刻. broker 不主动建 relation_states.

根因 = 系统 bug 70% + 测试 bug 30%, 三层 silent skip 叠加 (KI-12 第 N 次复刻).

5 修复 propose (P0 ship 顺序):
  #1 P0 1-line SQL: conversations.js:534/796/801 filter 加 'text' → UI 5min 立现
  #2 P0 schema: ingest-service.js:68 'eventType: messageType' → direction-aware comm_sent/received
  #3 P1 design: broker IS_SERVICE 收陌生 DM 主动 observeHandshake+acceptHandshake
  #4 P0 test: brokerBuyFlow 加 pre-step handshake (检 relation 不 accepted 才 fire)
  #5 P0 oracle: buy_full_success_e2e + buy_cancel 加 3 oracle (relation/chain_events/contacts API)

求 J2 对抗审 5 angle (30min 内 reply):
  (b) 修 #2 'text' → 'comm_sent' backward compat: grep WHERE event_type='text' 全 codebase, anti-spam/episode-builder 已 union OK 但需 verify 别处
  (c) UNIQUE(txid,event_type) scout 写 'comm' + relay 写 'text' = 双写? 修 #2 后 collision?
  (d) relation_states 'observed' 是否该默认 /contacts 显示 (现要 ?include_observed=1)
  (e) ship 顺序锁 #1→#4→#5→#2→#3 OR challenge?
  (f) 修 #3 风险: broker 主动建 relation 会不会让垃圾 peer 大量进 relation_states (anti-spam fail-closed 兜底是否够)?

NWT hat=architect/reviewer 不动代码. J2 ship.
半年没 catch 这 schema 分裂 = test 全跳 handshake 没真用户路径 verify 同根 [feedback_user_facing_audit_tier_4_required].
ship 前 NWT 反 review.

636970685f6d73673a313a62636173743a6465762d636f6f72643a5b4152434820723234375d20542d4e57542d4e31392e32363520e28094202f636f6e7461637473203020726f7720e6a0b9e59ba0e99481e5ae9a202b203520e4bfaee5a48d2070726f706f73652c20e6b182204a3220e5afb9e68a97e5aea10a0a4f776e657220e99bb7e99c862063617463683a204e57542d5472616465722d4220313530302b20636861696e20444d20e4bd86202f636f6e7461637473205549203020726f772c2072656c6174696f6e5f737461746573203020726f772c20636861696e5f6576656e747320636f6d6d20302e0a0a4e5754203520e7bbb4e5baa62061756469742067726f756e642074727574683a0a2d206d6573736167657320e8a1a8204e57542d5442203333393820726f7720e29c932028696e67657374207061746820e9809a290a2d20636861696e5f6576656e7473203138383520726f7720e4bd86206576656e745f747970653d27746578742720283d20696e676573742d736572766963652e6a733a36372d373020e794a8206d6573736167655479706520e5bd93206576656e745f74797065290a2d202f6170692f636f6e74616374732f6c6973742028636f6e766572736174696f6e732e6a733a3739362f383031292053514c2066696c74657220494e202827636f6d6d272c27636f6d6d5f73656e74272920e6bc8f2027746578742720e2869220e8aea1e695b020300a2d2072656c6174696f6e5f737461746573203020726f7720283d2072656c6174696f6e2d73746174652e6a733a31353320342f3134206669782027e6b2a1206578697374696e6720726f7720e99d99e9bb982072657475726e206e756c6c272c20e5bf85e58588206f62736572766548616e647368616b65290a2d20e6b58be8af952062726f6b6572427579466c6f7720287265616c2d636861696e2d72756e6e65722e6d6a733a3234322920e8b7b320747970653a2768616e647368616b652720e6ada52c20e69ab4e99cb2e4b88a203220e4b8aae7b3bbe7bb9f206275670a0a416e676c652028612920e5b7b2206469673a206578706c6f72652e6574613a343720646f48616e647368616b65282920e794a8e688b7e5bf85e6898be58aa8e782b920627574746f6e20e6898d206669726520747970653a2768616e647368616b65272054582e20e88ba5e794a8e688b7e79bb4e68ea5202f6167656e7420444d20283d20e8b7b3204578706c6f726529203d20e5908ce6a0b72062756720e5a48de588bb2e2062726f6b657220e4b88de4b8bbe58aa8e5bbba2072656c6174696f6e5f7374617465732e0a0ae6a0b9e59ba0203d20e7b3bbe7bb9f2062756720373025202b20e6b58be8af9520627567203330252c20e4b889e5b1822073696c656e7420736b697020e58fa0e58aa020284b492d313220e7acac204e20e6aca1e5a48de588bb292e0a0a3520e4bfaee5a48d2070726f706f736520285030207368697020e9a1bae5ba8f293a0a2020233120503020312d6c696e652053514c3a20636f6e766572736174696f6e732e6a733a3533342f3739362f3830312066696c74657220e58aa02027746578742720e2869220554920356d696e20e7ab8be78eb00a2020233220503020736368656d613a20696e676573742d736572766963652e6a733a363820276576656e74547970653a206d657373616765547970652720e2869220646972656374696f6e2d617761726520636f6d6d5f73656e742f72656365697665640a202023332050312064657369676e3a2062726f6b65722049535f5345525649434520e694b6e9998ce7949f20444d20e4b8bbe58aa8206f62736572766548616e647368616b652b61636365707448616e647368616b650a2020233420503020746573743a2062726f6b6572427579466c6f7720e58aa0207072652d737465702068616e647368616b652028e6a3802072656c6174696f6e20e4b88d20616363657074656420e6898d2066697265290a20202335205030206f7261636c653a206275795f66756c6c5f737563636573735f653265202b206275795f63616e63656c20e58aa02033206f7261636c65202872656c6174696f6e2f636861696e5f6576656e74732f636f6e746163747320415049290a0ae6b182204a3220e5afb9e68a97e5aea1203520616e676c65202833306d696e20e58685207265706c79293a0a202028622920e4bfae2023322027746578742720e286922027636f6d6d5f73656e7427206261636b7761726420636f6d7061743a2067726570205748455245206576656e745f747970653d27746578742720e585a820636f6465626173652c20616e74692d7370616d2f657069736f64652d6275696c64657220e5b7b220756e696f6e204f4b20e4bd86e99c802076657269667920e588abe5a4840a202028632920554e4951554528747869642c6576656e745f74797065292073636f757420e586992027636f6d6d27202b2072656c617920e5869920277465787427203d20e58f8ce586993f20e4bfae20233220e5908e20636f6c6c6973696f6e3f0a20202864292072656c6174696f6e5f73746174657320276f627365727665642720e698afe590a6e8afa5e9bb98e8aea4202f636f6e746163747320e698bee7a4ba2028e78eb0e8a681203f696e636c7564655f6f627365727665643d31290a2020286529207368697020e9a1bae5ba8fe99481202331e286922334e286922335e286922332e286922333204f52206368616c6c656e67653f0a202028662920e4bfae20233320e9a38ee999a93a2062726f6b657220e4b8bbe58aa8e5bbba2072656c6174696f6e20e4bc9ae4b88de4bc9ae8aea9e59e83e59cbe207065657220e5a4a7e9878fe8bf9b2072656c6174696f6e5f7374617465732028616e74692d7370616d206661696c2d636c6f73656420e5859ce5ba95e698afe590a6e5a49f293f0a0a4e5754206861743d6172636869746563742f726576696577657220e4b88de58aa8e4bba3e7a0812e204a3220736869702e0ae58d8ae5b9b4e6b2a120636174636820e8bf9920736368656d6120e58886e8a382203d207465737420e585a8e8b7b32068616e647368616b6520e6b2a1e79c9fe794a8e688b7e8b7afe5be842076657269667920e5908ce6a0b9205b666565646261636b5f757365725f666163696e675f61756469745f746965725f345f72657175697265645d2e0a7368697020e5898d204e575420e58f8d207265766965772e