Troubleshooting

❌ CONFIG ERROR: Item 1 missing required field 'apiid'
   Item: {'market_hash_name': 'AK-47 | Redline (Field-Tested)', ...}

❌ CONFIG ERROR: Item 1 has invalid apiid 'pricedata'
   Valid options: priceoverview, itemordershistogram, itemordersactivity, pricehistory

❌ CONFIG ERROR: Item 1 missing 'item_nameid' (required for itemordershistogram)
   Item: Dreams & Nightmares Case

❌ CONFIG ERROR: Infeasible configuration
   Calculated: 20 requests per 60s
   Limit: 15 requests per 60s
   Adjust polling intervals or reduce tracked items

# For each item: window_seconds ÷ polling-interval-in-seconds
# Example with 60s window:
# - 4 items at 10s intervals: 60÷10 = 6 req/item × 4 = 24 req/60s
# - Limit is 15 req/60s
# - Result: Infeasible (24 > 15)

TRACKING_ITEMS:
  - market_hash_name: "Item 1"
    polling-interval-in-seconds: 30  # Changed from 10

LIMITS:
  REQUESTS: 20  # Increased from 15 (use cautiously!)
  WINDOW_SECONDS: 60

FileNotFoundError: [Errno 2] No such file or directory: 'config.yaml'

python cerebro.py
# OR specify config path
python cerebro.py --config /path/to/config.yaml

aiohttp.ClientResponseError: 429, message='Too Many Requests'

TRACKING_ITEMS:
  - market_hash_name: "Item 1"
    polling-interval-in-seconds: 60  # Increased from 10

✓ Config feasible: 14 req/60s (93.3% capacity)

TRACKING_ITEMS:
  - market_hash_name: "High Priority Item"
    polling-interval-in-seconds: 10  # Fast updates
  
  - market_hash_name: "Low Priority Item"
    polling-interval-in-seconds: 300  # 5 minutes

LIMITS:
  REQUESTS: 20  # From 15
  WINDOW_SECONDS: 60

sqlite3.OperationalError: database is locked

ps aux | grep cerebro
# Kill extra instances
kill <pid>

ps aux | grep cerebro

python cerebro.py
# Look for: "✓ Started HIGH frequency tracking"

sqlite3 market_data.db
.tables
# Should show: orders_activity  orders_histogram  price_history  price_overview

Error: no such column: market_name

.schema price_overview

aiohttp.ClientConnectorError: Cannot connect to host steamcommunity.com
OR
TimeoutError: 

ping steamcommunity.com

self.session = aiohttp.ClientSession(
    timeout=aiohttp.ClientTimeout(total=60)  # Increased from 30
)

aiohttp.ClientConnectorCertificateError: SSL certificate verification failed

# Ubuntu/Debian
sudo apt-get update && sudo apt-get install --reinstall ca-certificates

# macOS
brew install openssl

# Or update Python's certifi
pip install --upgrade certifi

TRACKING_ITEMS:
  - market_hash_name: "Item"
    currency: 1  # 1=USD, 3=EUR, etc.

SELECT market_hash_name, currency, lowest_price
FROM price_overview
ORDER BY timestamp DESC LIMIT 5;

-- Get one row per minute
SELECT strftime('%Y-%m-%d %H:%M', timestamp) AS minute,
       AVG(lowest_price) AS avg_price
FROM price_overview
WHERE market_hash_name = 'AK-47 | Redline (Field-Tested)'
GROUP BY minute;

TRACKING_ITEMS:
  - polling-interval-in-seconds: 60  # From 10

sqlite3 market_data.db "VACUUM;"

# Rough estimate:
# 10 items × 6 req/min × 60 min × 24 hr × ~1KB per row = ~8.6 MB/day
# Over 30 days: ~260 MB

-- Export data older than 30 days
.mode csv
.output archive.csv
SELECT * FROM price_history WHERE time < datetime('now', '-30 days');
.output stdout

-- Delete old data
DELETE FROM price_history WHERE time < datetime('now', '-30 days');
VACUUM;

TRACKING_ITEMS:
  - apiid: 'pricehistory'
    polling-interval-in-seconds: 3600  # Once per hour

-- Fast (uses index)
WHERE market_hash_name = 'Item Name'

-- Slow (full table scan)
WHERE appid = 730

SELECT * FROM price_history
WHERE market_hash_name = 'Item'
ORDER BY time DESC
LIMIT 1000;  -- Don't fetch millions of rows

sqlite3 market_data.db "ANALYZE; VACUUM;"