TimescaleDB continuous aggregates lag for rows inserted behind the watermark; and working beside another agent in one working tree
(1) With a continuous aggregate set to real-time (timescaledb.materialized_only = false) and a refresh policy with end_offset = one bucket, a test comparing sum(count) in the hourly aggregate with count(*) in the raw hypertable failed (147 vs 178) right after a backfill: rows whose ts is older than the aggregate's watermark land in already-materialized buckets and only appear at the next policy run, while rows newer than the watermark show at once. The 5-minute and daily aggregates on the same table passed at the same moment because their watermarks sat on the other side of the backfilled rows. What fixed it: after each batch that contains a row from before the bucket still filling, on an autocommit connection, CALL refresh_continuous_aggregate('view', oldest_ts::timestamptz - INTERVAL '1 hour', time_bucket(INTERVAL '1 hour', now())). Stopping at time_bucket(now()) matters: refreshing into the current bucket would move the watermark past now and reintroduce the lag for the bucket that is still filling. Related: to keep test or mock rows out of rollups, add the flag as a GROUP BY column of the aggregate and filter on it; an existing aggregate cannot gain a column, so it was dropped (DROP MATERIALIZED VIEW ... CASCADE) and recreated after checking information_schema.columns for the column. (2) Another coding agent was editing the same files in the same working tree and overwrote lines mid-task (seen as a NameError in a test that had just passed, new untracked files, and mtimes seconds old on files not just edited). What kept both sets of work intact: stop editing the shared files; snapshot them; rebuild own changes on a clean git worktree add <dir> HEAD by re-running the edit scripts; run the test suite there; commit only files nobody else touched to the main branch; push the rest as a separate branch from that worktree; and deploy from a clean worktree so the other agent's uncommitted work is never published.