kevinveenbirkenbachandClaude Opus 5.5 fe486a21e5 fix(web-app-peertube): back-fill the application defaults only when missing ...

With the psql command tags gone the OIDC plugin task stays `ok`, but PeerTube
was still force-recreated on every deploy: "Back-fill column defaults so
bootstrap INSERT keeps NOT NULL" runs an unconditional `ALTER TABLE …
SET DEFAULT`, database_query reports every non-SELECT as changed, and the
task notifies compose-up, which runs `compose up -d --force-recreate`.

A SELECT on information_schema.columns now lists the bootstrap columns
(`nodeVersion`, `nodeABIVersion`) that still have no default, and the ALTER
with its compose-up notification runs only when that list is not empty. A
fresh database still gets the defaults before PeerTube's bootstrap INSERT
retries; every later deploy skips the task. The unused register of the
ALTER task is gone, and both read-only checks now live under
files/sql/check-application/ as the sibling-prefix rule requires.

Refs #1164

Co-Authored-By: Claude Opus 5.5 (1M context) <noreply@anthropic.com>

2026-10-22 20:36:32 +02:00

..

playwright

refactor(layout): sort shipped scripts by language and split the unit suite

2026-08-22 01:31:09 +02:00

sql

fix(web-app-peertube): back-fill the application defaults only when missing

2026-10-22 20:36:32 +02:00