同一种(金额精度导致的 400 Bad Request,订单在交易所侧从未被创建),我可以给你一行命令,把所有当前卡住的 UNKNOWN_SUBMISSION 订单统一标记为 REJECTED,方便你一键解锁开关:
sqlite3 /opt/polymarket-btc5m/data/btc5m.sqlite "UPDATE live_trade_intents SET status='REJECTED', block_reason='manual_bulk_clear', settlement_source='manual_bulk_clear_'||strftime('%Y%m%d%H%M%S','now') WHERE status='UNKNOWN_SUBMISSION';"
稳妥的做法是这一行,只清除已确认是”提交阶段就失败”的那类
sqlite3 /opt/polymarket-btc5m/data/btc5m.sqlite "UPDATE live_trade_intents SET status='REJECTED', block_reason='manual_bulk_clear', settlement_source='manual_bulk_clear_'||strftime('%Y%m%d%H%M%S','now') WHERE status='UNKNOWN_SUBMISSION' AND block_reason='post_result_unknown';"
跑完之后用这行确认还剩几笔没清(如果还有剩余,说明是 response_record_unknown 类型,需要你去 Polymarket 官网核实一下钱包持仓再手动处理):
sqlite3 /opt/polymarket-btc5m/data/btc5m.sqlite "SELECT id, market_slug, block_reason FROM live_trade_intents WHERE status='UNKNOWN_SUBMISSION';"