Events not reaching ClickHouse
Open
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 39.9k
- Forks
- 3.4k
- Avg merge
- 6h 51m
- Merged PRs (30d)
- 232
Description
Cause: posthog_person.last_seen_at column missing from PostgreSQL — the squashed migration 0001_initial_squashed_0284 didn't include it, and Django thought migrations were complete
Fix: ALTER TABLE posthog_person ADD COLUMN IF NOT EXISTS last_seen_at TIMESTAMPTZ;
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Inspect the squashed migration 0001_initial_squashed_0284 and the PostgreSQL schema to confirm that posthog_person.last_seen_at is missing. Apply the stated schema fix and verify that events reach ClickHouse afterward.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- clickhouse, django, postgresql, python
- Domain
- data-engineering, databases
- Issue type
- Bug
- Difficulty
- 2/5
- Estimated time
- 1-3 hours
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 45/100