Files
QuoteForge/bible-local/decisions
Mikhail ChusavitinandClaude Opus 5.5 44a09d4420 fix(sync): stop MariaDB connection leak and cut per-cycle sync waste
- ConnectionManager reuses a stale-but-healthy pool instead of dialing a new
  one every 30s, and closes every pool it replaces (one client held ~30
  connections). Pool capped at 2 connections, idle released after 1 min.
- Background sync every 1 min with ±30% jitter, scheduled from cycle start;
  users-status online threshold = interval × 1.3. One heartbeat per cycle.
- Partnumber books: read headers only, fetch partnumbers_json per book when
  new/incomplete; empty book counts as complete; an incomplete book is
  re-pulled once per process (server book lists BOT_AGIBOT_G2_PERF missing
  from qt_partnumber_book_items).
- NeedSync in one UNION ALL query; SyncQtSettings skips unchanged rewrite.
- Migration 035: server-maintained server_updated_at on qt_configurations and
  qt_projects. Clients pull only changed rows after one full pull per process;
  servers without 035 and old clients keep full pulls.
- Migrator: fresh GORM statement per verify query and history insert; files
  with two verify checks failed to record.

ADL: bible-local/decisions/2026-10-26-mariadb-single-pool.md,
bible-local/decisions/2026-10-26-incremental-config-project-pull.md

Co-Authored-By: Claude Opus 5.5 <noreply@anthropic.com>
2026-10-26 20:46:59 +03:00
..

Architectural Decision Log

One file per decision, named YYYY-MM-DD-short-topic.md.

Write a new entry when:

  • Choosing between non-obvious implementation approaches.
  • Intentionally rejecting a feature or pattern.
  • A bug causes a rule change.
  • Freezing or deprecating something.

Format:

# Decision: <short title>

**Date:** YYYY-MM-DD
**Status:** active | superseded by YYYY-MM-DD-topic.md

## Context
Situation making this decision necessary.

## Decision
What was decided, stated clearly.

## Consequences
What this means going forward; what is forbidden or required.

When a decision is superseded: add "superseded by" to the old file and create the new one. Do NOT delete old entries. Record the decision in the SAME COMMIT as the implementation code.