fintechner copy diagnostic

24-copy-diag.sh

#!/bin/bash
set -euo pipefail
export AWS_PAGER=""
REGION=ap-northeast-1
INSTANCE_ID=i-089ad4a6b76132ba2

CMD_ID=$(aws --region "$REGION" ssm send-command \
  --instance-ids "$INSTANCE_ID" \
  --document-name AWS-RunShellScript \
  --parameters '{"commands":[
    "echo === leaders table ===",
    "sudo docker exec timescale psql -U fintechner -d fintechner -c \"SELECT * FROM leaders;\" 2>&1 | head -20",
    "echo",
    "echo === copy_policies table ===",
    "sudo docker exec timescale psql -U fintechner -d fintechner -c \"SELECT leader_id, enabled, sizing_mode, per_leader_cap_usd FROM copy_policies;\" 2>&1 | head -20",
    "echo",
    "echo === recent copy_decisions (last 10) ===",
    "sudo docker exec timescale psql -U fintechner -d fintechner -c \"SELECT ts, leader_id, intent_id, decision, code, reason FROM copy_decisions ORDER BY ts DESC LIMIT 10;\" 2>&1 | head -20",
    "echo",
    "echo === connector logs about copy ===",
    "sudo journalctl -u fintechner-connector --since \"10 min ago\" --no-pager 2>&1 | grep -iE \"copy|leader\" | tail -20"
  ]}' \
  --query Command.CommandId --output text)

for i in $(seq 1 25); do
  sleep 4
  STATUS=$(aws --region "$REGION" ssm get-command-invocation --command-id "$CMD_ID" --instance-id "$INSTANCE_ID" --query Status --output text 2>/dev/null || echo Pending)
  case "$STATUS" in Success|Failed|Cancelled|TimedOut) echo "  $STATUS"; break ;; *) echo "  $STATUS";; esac
done
echo
aws --region "$REGION" ssm get-command-invocation --command-id "$CMD_ID" --instance-id "$INSTANCE_ID" --query StandardOutputContent --output text