Lost columns issue

[TheRefineryAU]

I attempted to update a plausible selfhosted setup from plausible/community-edition:v2.1.0-rc.1 to v3. i copied the plausible data into a sql file and created a tar of /var/lib/clickhouse/data.

The upgrade didnt seem to work so attempted to roll back, by copying the data folder back. I got errors in the plausible log like:

Code: 47. DB::Exception: There's no column 's0.country' in table 's0': While processing s0.country: and the same for source. I saw the sql definition of sessionsv2 and added the aliased columns source and country and that seems to have fixed the problem.

I'm running plausible from the docker image above so what i'm wondering is did these alias columns get deleted? Are they part of the definition of v2? The code seems to be asking for them so i guess they must be?

Long story short, not sure what happened!