The open-source app everyone uses to manage agents at work
TypeScript acpxagent-orchestrationagent-skillsagentic-aiai-agentsai-engineeringai-governanceai-toolsautonomous-agentsclaudeclaude-codeclaude-skillscodexhermesllmmcpmulti-agentopenclawproject-managementworkflow-automation
/** postgres.js transient connection codes, including wrapped Drizzle errors. */
const transientDbConnectionCodes = new Set([
"CONNECT_TIMEOUT",
"CONNECTION_CLOSED",
"CONNECTION_ENDED",
"CONNECTION_DESTROYED",
]);
function hasDbConnectionErrorCode(error: unknown, matches: (code: string) => boolean): boolean {
for (let current: unknown = error; current instanceof Error; current = current.cause) {
const code = (current as { code?: unknown }).code;
if (typeof code === "string" && matches(code)) return true;
}
return false;
}
export function isTransientDbConnectionError(error: unknown): boolean {
return hasDbConnectionErrorCode(error, (code) => transientDbConnectionCodes.has(code));
}
/**
* postgres.js rejects every query issued after this process called
* `sql.end()` with `CONNECTION_ENDED`. Unlike a dropped socket, it never comes
* from the database or the network: the pool was ended locally.
*/
export function isEndedDbPoolError(error: unknown): boolean {
return hasDbConnectionErrorCode(error, (code) => code === "CONNECTION_ENDED");
}
/**
* Retry only an explicitly idempotent operation, such as a known read-only
* lookup or receipt-protected synchronization. Neither a SQL prefix nor a
* connection error message proves replay safety: a disconnected write may
* already have committed. Callers own this proof for the entire callback.
*
* Two replays allow for a pool-wide recycle where the first replay draws
* another stale socket. The pauses give the driver time to replace them.
* Persistent failures still propagate after three total attempts.
*/
export async function retryIdempotentDatabaseOperation<T>(run: () => Promise<T>): Promise<T> {
for (let attempt = 0; ; attempt += 1) {
try {
return await run();
} catch (error) {
if (attempt >= 2 || !isTransientDbConnectionError(error)) throw error;
await new Promise((resolve) => setTimeout(resolve, 50 * (attempt + 1)));
}
}
}