Postgres+pgvector CI job running the ignored integration suites #106

Activity

1. tonibergholm

   added

   ready-for-agentScoped and unambiguous enough for an agent to pick upScoped and unambiguous enough for an agent to pick up

   wayfinder:taskWayfinder ticket: work that unblocks a decision or lands a fixWayfinder ticket: work that unblocks a decision or lands a fix

   on Jul 9, 2026
2. tonibergholm

   added a parent issue on Jul 9, 2026

   • Wayfinder map: 2026-07-09 security-audit remediation #103
3. tonibergholm

   marked this as blocking on Jul 9, 2026

   • Verify content hashes on every get_raw() read #110
4. tonibergholm

   self-assigned this

   on Jul 9, 2026
5. tonibergholm commented on Jul 9, 2026

   

   tonibergholm

   on Jul 9, 2026

   MemberAuthor

   More actions

   Resolution

   Shipped as PR #116 (pending Toni's review/merge per the map's PR gate). The new job ran green on the PR's own CI: postgres integration (pgvector), 2m0s.

   What landed: a postgres CI job with a pgvector/pgvector:pg16 service container mirroring the demo's image/credentials, a CREATE EXTENSION IF NOT EXISTS vector step (the adapter checks but can't create it), and all three ignored Postgres suites: agentic-memory integration (17 tests), reverse_migration (3), commit_with_memory (1) — 21 tests total, verified green locally with the exact CI commands before pushing.

   A real catch: the memory suite reproducibly fails 2 tests in default parallel mode against real Postgres (ac1_writes_during_restore_are_reverted — schema-name 23505 collision; snapshot_strict_drain_preserves_bad_row_on_block — snapshot didn't block). This is the suite's own documented contract, not a product bug: public.agentic_change_log is shared across test schemas by design, so the module doc mandates --test-threads=1. The job honors that; logged as bug-128 in .wolf/buglog.json.

   Facts later tickets depend on: the harness the get_raw-integrity fix (#110, now unblocked once this closes) and the ADR-0014 gate (#111) rely on is live — their Postgres-path regression tests will run on every PR. Job runtime ~2 minutes; DATABASE_URL in CI is postgres://agentic:agentic@localhost:54322/agentic.
6. tonibergholm

   closed this as completedon Jul 9, 2026
7. tonibergholm

   added a commit that references this issue on Jul 9, 2026

   Run the ignored Postgres integration suites in CI against real pgvect…

   ...

   This issue will close once commit 195d83d is merged into the 'main' branch.

   195d83d