Nine Bugs That Taught Me Reliability: Post-Mortem of a Zero-Cost Hybrid AI System

说明与用途

在免费虚拟机上运行的零成本 AI 代理遇到了九个关键错误，凸显了将配置与代码分离、保持版本一致、正确使用 SQLite 索引、在双向同步中保持记录身份稳定以及异步处理繁重任务的重要性。

问题

A zero‑budget hybrid local+cloud AI agent must never regress production while operating under free tier constraints.

结果

Implemented a robust, zero‑cost hybrid AI agent that reliably runs daily tasks without regressions, by separating configuration from code, aligning runtimes, correcting database constraints, stabilizing sync identity, and decoupling heavy work from request paths.

工作流

• Deploy code without overwriting real credentials by using .env files
• Source .env in cron commands
• Ensure Python runtime parity across local and cloud nodes
• Replace partial SQLite index with a full unique index
• Preserve original origin IDs and skip re‑exporting local records
• Move re‑embedding to a background task and return immediately from the sync endpoint

证据

Credentials were living in source. "Deploy the latest code" therefore also meant "overwrite the real keys with placeholders."

来源

The cron entry invoked python directly without sourcing .env first.

来源

An f-string containing a backslash. Python 3.12 relaxed the f-string grammar and accepts it; 3.11 does not.

来源

SQLite will not use a partial index as an upsert conflict arbiter.

来源

On each export, records were re‑namespaced… identity changed every round‑trip.

来源

Re‑embedding a few hundred chunks on a CPU‑only, memory‑starved box takes real wall‑clock time…

来源