CHAT_OUTPUT_BEGIN
COMMAND_ID=SIGNALBOT-260921-FINAL-D1-SEMANTIC-ELIGIBILITY-PREFLIGHT-052PREP3
STATUS=OK
RC=0
HOST=pve01
MODE=read-only
COMPONENT=signalbot-final-d1-semantic-eligibility-preflight
REFERENCE_REGISTER_CHECK=OK
REFERENCE_SHA256=5a3d8e5154c41cb582a4e0aca68090be1f0138918bf82131a948df326f9d8d66
ERROR_REGISTER_CHECK=OK
ERROR_REGISTER_SHA256=3b09a553ec0f527ed3afeed4753f52a74ee3036045bbfb3c685e9f8af4ba7ba0
COMMAND_SHA256=29f2a122515de78196cf7bde9de09320b70837545aebfca2cfed0e3b1a853d48
DUPLICATE_FAILED_COMMAND_BLOCKED=false
EXECUTION_STARTED=true
CHANGE_DECLARED=false
RESULT_CONTRACT_VALID=true
RESULT_CONTRACT_STATUS=NOT_APPLICABLE
RESULT_CONTRACT_ERROR=NONE
COMMAND_RC=0
CHANGES_MADE=false
ROLLBACK_STARTED=false
ROLLBACK_RESTORED=null
MUTATION_OUTCOME=NO_MUTATION
SANITIZED=yes
SECRETS_INCLUDED=no
PRIVATE_ADDRESSES_INCLUDED=no
RAW_EVIDENCE_SHA256=6a6bc4397763f41c91d8f498d19f401cd1c571302d4e9400c109e046d8281d34
SANITIZED_OUTPUT_SHA256=6a6bc4397763f41c91d8f498d19f401cd1c571302d4e9400c109e046d8281d34
OUTPUT_BEGIN
SIGNALBOT052PREP2_RESULT={"expected_code_commit_present":true,"guest":{"containers_a":[{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","COLLECTION_START_AT":"2026-09-18T00:00:00+00:00","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"8a65d323beda0410","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"collector","started_at":"2026-09-17T17:32:42.449321279Z"},{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"8c7689a8e46e72f9","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"relay","started_at":"2026-09-17T17:32:42.417117055Z"},{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"80ab5a8cad2b0eb9","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"shadow","started_at":"2026-09-17T17:32:42.390445575Z"},{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"8677c7c7388e1f02","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"worker","started_at":"2026-09-17T17:32:42.482140113Z"}],"containers_b":[{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","COLLECTION_START_AT":"2026-09-18T00:00:00+00:00","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"8a65d323beda0410","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"collector","started_at":"2026-09-17T17:32:42.449321279Z"},{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"8c7689a8e46e72f9","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"relay","started_at":"2026-09-17T17:32:42.417117055Z"},{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"80ab5a8cad2b0eb9","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"shadow","started_at":"2026-09-17T17:32:42.390445575Z"},{"config_image":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","env":{"CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"id":"8677c7c7388e1f02","image_id":"sha256:bc7fe43a1627532cf2ffbea2489352bb97c9a9e445e097cd5837b80a9e90cc60","restart_count":0,"restarting":false,"running":true,"service":"worker","started_at":"2026-09-17T17:32:42.482140113Z"}],"db":{"bitfinex_source.db":{"counts":{"d1_revisions":1,"finalized_d1":1,"logical_d1":1,"meta":24,"reconnect_reconciliation":18,"sequence_events":444982,"source_receipts":445099,"trade_receipts":213022,"trade_revisions":212998},"exists":true,"latest":{"finalized_d1":[{"close_at":"2026-09-19T00:00:00+00:00","finalized_d1_id":"94755f8715fe97b4fde2d846638af84ea4a829625bb0ca6ece98a78803416b2e","finalized_json":"{\"finality_policy_id\":\"BITFINEX_SEQ_ALL_D1_V1\",\"finalized_at\":\"2026-09-19T00:00:00.342362+00:00\",\"finalized_d1_id\":\"94755f8715fe97b4fde2d846638af84ea4a829625bb0","logical_d1_id":"bb9cbf18d81e605641e7aa9b792d35d1f55c3cae51fbe1abfe1617b72f0eaa14","revision_id":"33cf3eb2b33466a5bb2c2779602fb3119cb00e628759f941456df554e31cb774","revision_json":"{\"close\":\"80869\",\"high\":\"81346\",\"logical_d1_id\":\"bb9cbf18d81e605641e7aa9b792d35d1f55c3cae51fbe1abfe1617b72f0eaa14\",\"low\":\"76267\",\"open\":\"76392\",\"revision_id\":\"3"}],"logical_d1":[{"close_at":"2026-09-19T00:00:00+00:00","finality_policy_id":"BITFINEX_SEQ_ALL_D1_V1","finality_state":"FINALIZED","logical_d1_id":"bb9cbf18d81e605641e7aa9b792d35d1f55c3cae51fbe1abfe1617b72f0eaa14","open_at":"2026-09-18T00:00:00+00:00","timeframe_id":"D1"}],"reconnect_reconciliation":[{"created_at":"2026-09-21T01:26:00.064302+00:00","failure_reason":"","reconnect_event_seq":444660,"reconnect_received_at":"2026-09-21T01:25:59.266310+00:00","resolved_at":"2026-09-21T01:26:00.064302+00:00","status":"RECONCILED"},{"created_at":"2026-09-21T00:49:26.894105+00:00","failure_reason":"REST_FETCH_OR_VALIDATION_FAILED","reconnect_event_seq":438938,"reconnect_received_at":"2026-09-21T00:49:23.294194+00:00","resolved_at":"2026-09-21T00:49:26.894105+00:00","status":"UNRESOLVED"},{"created_at":"2026-09-21T00:42:54.658882+00:00","failure_reason":"REST_FETCH_OR_VALIDATION_FAILED","reconnect_event_seq":437370,"reconnect_received_at":"2026-09-21T00:42:48.180360+00:00","resolved_at":"2026-09-21T00:42:54.658882+00:00","status":"UNRESOLVED"}]},"quick_check":["ok"],"schemas":{"finalized_d1":["logical_d1_id","close_at","finalized_d1_id","revision_id","logical_json","revision_json","finalized_json"],"logical_d1":["logical_d1_id","market_key","timeframe_id","open_at","close_at","finality_policy_id","finality_state","logical_json"],"reconnect_reconciliation":["window_id","reconnect_event_seq","reconnect_received_at","previous_trade_identity","previous_trade_mts","next_trade_identity","next_trade_mts","status","evidence_sha256","recovered_row_count","failure_reason","created_at","resolved_at"]},"tables":["d1_revisions","finalized_d1","logical_d1","meta","reconnect_reconciliation","sequence_events","source_receipts","trade_receipts","trade_revisions"]},"live_prospective.db":{"counts":{"bars":1002,"meta":3,"notification_state":0,"observations":2,"processed_logical_d1":1,"processed_primary":0,"role_state":2,"signal_outbox":0},"exists":true,"latest":{"observations":[{"arm_states_json":"[{\"arm_id\":\"A_CLOSE_ONLY\",\"close_beyond_count\":0,\"interaction_state\":\"UNTOUCHED\",\"last_sequence\":1,\"state_id\":\"bba0476687bb3493a06fb1ffae296ac18113abebcb5581036","close_at":"2026-09-19T00:00:00+00:00","finalized_revision_id":"33cf3eb2b33466a5bb2c2779602fb3119cb00e628759f941456df554e31cb774","logical_d1_id":"bb9cbf18d81e605641e7aa9b792d35d1f55c3cae51fbe1abfe1617b72f0eaa14","recorded_at":"2026-09-19T00:02:48.606840+00:00","signal_state":"WATCH"},{"arm_states_json":"[{\"arm_id\":\"A_CLOSE_ONLY\",\"close_beyond_count\":1,\"interaction_state\":\"TRUE_BREAK_ACCEPTED\",\"last_sequence\":1,\"state_id\":\"788635c727734cafeab701d7f4764e4df07c3ac","close_at":"2026-09-19T00:00:00+00:00","finalized_revision_id":"33cf3eb2b33466a5bb2c2779602fb3119cb00e628759f941456df554e31cb774","logical_d1_id":"bb9cbf18d81e605641e7aa9b792d35d1f55c3cae51fbe1abfe1617b72f0eaa14","recorded_at":"2026-09-19T00:02:48.606840+00:00","signal_state":"WATCH"}],"processed_logical_d1":[{"close_at":"2026-09-19T00:00:00+00:00","logical_d1_id":"bb9cbf18d81e605641e7aa9b792d35d1f55c3cae51fbe1abfe1617b72f0eaa14","processed_at":"2026-09-19T00:02:48.606840+00:00","revision_id":"33cf3eb2b33466a5bb2c2779602fb3119cb00e628759f941456df554e31cb774"}]},"quick_check":["ok"],"schemas":{"observations":["row_id","experiment_id","primary_bar_id","close_at","role","line_id","key_level","signal_state","direction","confidence","market_price","arm_states_json","demonov_json","venues_json","signal_json","recorded_at","logical_d1_id","finalized_revision_id"],"processed_logical_d1":["logical_d1_id","revision_id","close_at","fsm_sequence","processed_at"],"processed_primary":["bar_id","close_at","processed_at"],"signal_outbox":["outbox_id","experiment_id","logical_d1_id","role","observation_row_id","signal_id","signal_json","notification_policy_id","committed_at"]},"tables":["bars","meta","notification_state","observations","processed_logical_d1","processed_primary","role_state","signal_outbox"]},"notification_relay.db":{"counts":{"notification_relay_ledger":0},"exists":true,"latest":{},"quick_check":["ok"],"schemas":{"notification_relay_ledger":["outbox_id","signal_id","status","subject_hash","body_hash","recipient_hash","attempted_at","finalized_at","error_type"]},"status_counts":{"notification_relay_ledger":[]},"tables":["notification_relay_ledger"]}},"env":{"APP_IMAGE":"8020-demonov-shadow:signalbot-050r6-749073ae0f89","CODE_IDENTITY":"749073ae0f894debc06fb0ffbf7a84abf9da531f","COLLECTION_START_AT":"2026-09-18T00:00:00+00:00","EXPERIMENT_ID":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","RUNTIME_MANIFEST_ID":"927480bca5dccc11c8e605151db035b4d678f3adb63a0c4ec27544dca0e45d14"},"epoch_exists":true,"finalized_d1_count":1,"holds":["RECONCILIATION_UNRESOLVED"],"hostname":"core-apps","logs_2h":{"collector":{"Invalid isoformat string":0,"SOURCE_FINALITY":0,"reconnect prevents D1 finalization":0},"relay":{"Invalid isoformat string":0,"SOURCE_FINALITY":0,"reconnect prevents D1 finalization":0},"shadow":{"Invalid isoformat string":0,"SOURCE_FINALITY":0,"reconnect prevents D1 finalization":0},"worker":{"Invalid isoformat string":0,"SOURCE_FINALITY":480,"reconnect prevents D1 finalization":0}},"ok":true,"source_counts_a":{"finalized_d1":1,"logical_d1":1,"reconnect_reconciliation":18,"sequence_events":444928,"source_receipts":445045,"trade_receipts":212995,"trade_revisions":212971},"source_counts_b":{"finalized_d1":1,"logical_d1":1,"reconnect_reconciliation":18,"sequence_events":444980,"source_receipts":445097,"trade_receipts":213021,"trade_revisions":212997},"source_growth_10s":true,"statuses":{"collector_status.json":{"prospective_reconnect_detected":true,"reconciliation_last_reason":"REST_FETCH_OR_VALIDATION_FAILED","reconciliation_pending_count":0,"reconciliation_unresolved_count":9,"reconnect_detected":true,"updated_at":"2026-09-21T01:27:19.489485+00:00","updated_at_age_s":0.258273},"live_status.json":{"code_identity":"749073ae0f894debc06fb0ffbf7a84abf9da531f","execution_authority":false,"experiment_id":"4a78c74b381b0424ccd22fa5466526cb324dfbb6855ffb3de8f0c3ac29dac397","finalized_d1_available_count":0,"finalized_d1_backlog_count":0,"heartbeat_at":"2026-09-21T01:27:09.021036+00:00","heartbeat_at_age_s":10.726761,"last_primary_closed_d1":null,"production_launch_allowed":false,"prospective_research_collection_allowed":true,"risk_authority":false,"service":"8020-demonov-live-worker","source_fail_closed_reason":"REST_FETCH_OR_VALIDATION_FAILED","source_reconnect_detected":true,"status":"FAIL_CLOSED"},"relay_status.json":{"execution_authority":false,"heartbeat_at":"2026-09-21T01:26:47.961867+00:00","heartbeat_at_age_s":31.785947,"production_launch_allowed":false,"risk_authority":false,"service":"8020-demonov-notification-relay","status":"NOTIFICATION_RELAY_RUNNING"},"service_boot.json":{"code_identity":"749073ae0f894debc06fb0ffbf7a84abf9da531f","execution_authority":false,"production_launch_allowed":false,"risk_authority":false,"service":"8020-demonov-shadow"}},"structural_ready_hint":false},"holds":["RECONCILIATION_UNRESOLVED"],"ok":true,"qga_guest_exitcode":0,"qga_guest_stderr_present":false,"qga_outer_rc":0,"qga_outer_stderr_present":false,"ready_for_052r1_hint":false,"relay_db_status_counts":{"notification_relay_ledger":[]},"relay_source_paths":["demonov_forward_map/notification_relay.py"],"relay_source_sha256":"386cec9d2484c675950fa319e366f1a7b061d7ee864d3b3be2aa863c926d80c8","relay_source_status_literals":["FAIL_CLOSED","INDETERMINATE","NOTIFICATION_RELAY_RUNNING","PRECONDITION_FAILED","ROLLBACK","SENT"],"relay_source_status_sql":["CREATE TABLE IF NOT EXISTS notification_relay_ledger( outbox_id TEXT PRIMARY KEY, signal_id TEXT NOT NULL, status TEXT NOT NULL, subject_hash TEXT NOT NULL, body_hash TEXT NOT NULL, recipient_hash TEXT NOT NULL, attempted_at TEXT NOT NULL, finalized_at TEXT NOT NULL, error_type TEXT NOT NULL )","INSERT INTO notification_relay_ledger( outbox_id,signal_id,status,subject_hash,body_hash, recipient_hash,attempted_at,finalized_at,error_type ) VALUES(?,?,?,?,?,?,?,?,?) ON CONFLICT(outbox_id) DO UPDATE SET status=excluded.status, finalized_at=excluded.finalized_at, error_type=excluded.error_type","SELECT outbox_id,signal_id,status,subject_hash,body_hash, recipient_hash,attempted_at,finalized_at,error_type FROM notification_relay_ledger ORDER BY attempted_at,outbox_id","SELECT outbox_id,signal_id,status,subject_hash,body_hash, recipient_hash,attempted_at,finalized_at,error_type FROM notification_relay_ledger WHERE outbox_id=?"],"repo_branch":"cr-2026-0105-demonov-shadow-orchestrator","repo_clean":true,"repo_head":"559948bcb6baead49a47d9953b0cc0090e332fd7","technical_holds":[]}
TASK_RESULT=HOLD_SIGNALBOT_052PREP2_NOT_READY
HOMELAB_RESULT_CONTRACT={"version":1,"command_id":"SIGNALBOT-260921-FINAL-D1-SEMANTIC-ELIGIBILITY-PREFLIGHT-052PREP3","status":"OK","changes_made":false,"rollback_started":false,"rollback_restored":null}

OUTPUT_END
CHAT_OUTPUT_END
