test(plausible): psql -q in _register_site — -t does not suppress command tags #9

Merged

autonomic-bot merged 1 commits from test/plausible-psql-quiet into main 2026-06-09 23:12:38 +00:00

Conversation 0 Commits 1 Files Changed 1

+1 -1

autonomic-bot commented 2026-06-09 23:02:13 +00:00

Owner

Copy Link

Copy Source

The plausible custom tier (first executed in build 237 — install always failed before) revealed _register_site asserting out == site against psql output that includes the INSERT 0 1 command tag: -t (tuples-only) suppresses headers/footers but NOT command tags. Both event-tracking roundtrip tests fail on it.

Fix: psql -q, which suppresses the tags. Verified against the recipe's db container: with -q the INSERT+SELECT statement pair returns exactly the site domain.

Pair: recipe-maintainers/plausible#3 (its !testme custom tier needs this to go green; the restore-tier fixes are on the recipe PR itself — head 270c840).

The plausible custom tier (first executed in build 237 — install always failed before) revealed `_register_site` asserting `out == site` against psql output that includes the `INSERT 0 1` command tag: `-t` (tuples-only) suppresses headers/footers but NOT command tags. Both event-tracking roundtrip tests fail on it. Fix: `psql -q`, which suppresses the tags. Verified against the recipe's db container: with `-q` the INSERT+SELECT statement pair returns exactly the site domain. Pair: recipe-maintainers/plausible#3 (its `!testme` custom tier needs this to go green; the restore-tier fixes are on the recipe PR itself — head `270c840`).

autonomic-bot added 1 commit 2026-06-09 23:02:14 +00:00

test(plausible): psql -q in _register_site — -t does not suppress command tags ... 79c652ddd3

psql -tAc still prints INSERT/CREATE command tags (e.g. "INSERT 0 1"), so
_register_site asserted out == site against "INSERT 0 1\nsite" and both
event-tracking roundtrip tests failed on their very first run (build 237 —
the custom tier had never executed before; install always failed earlier).
-q suppresses the tags; verified against the recipe db container.

autonomic-bot merged commit 157d06dc77 into main 2026-06-09 23:12:38 +00:00

autonomic-bot referenced this issue from a commit 2026-06-09 23:12:40 +00:00

Merge pull request 'test(plausible): psql -q in _register_site — -t does not suppress command tags' (#9) from test/plausible-psql-quiet into main

autonomic-bot referenced this issue from a commit 2026-07-09 00:21:28 +00:00

journal(redfix): wake #9 — consumed M2 PASS (VETO cleared, F-redfix-4 closed); DONE re-asserted at b5f2b10; phase closed, loop stopped

Sign in to join this conversation.

Reviewers

No Reviewers

Labels

No items

No labels

Milestone

No items

No Milestone

Projects

Clear projects

No projects

Assignees

Clear assignees

autonomic autonomic-bot kawaiipunk (KawaiiPunk) notplants trav (Trav Fryer)

No Assignees

1 Participants

Notifications

Subscribe

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: recipe-maintainers/cc-ci#9