docker-gitlab: ERROR: relation "postgres_partitions" does not exist at character 454
I’ve upgraded gitlab(13.4.3->13.7.1) , I got following error.
2021-01-07 16:03:58.707 JST [1] LOG: database system is ready to accept connections
2021-01-07 16:04:30.951 JST [1717] ERROR: relation "postgres_partitions" does not exist at character 454
2021-01-07 16:04:30.951 JST [1717] STATEMENT: SELECT a.attname, format_type(a.atttypid, a.atttypmod),
pg_get_expr(d.adbin, d.adrelid), a.attnotnull, a.atttypid, a.atttypmod,
c.collname, col_description(a.attrelid, a.attnum) AS comment
FROM pg_attribute a
LEFT JOIN pg_attrdef d ON a.attrelid = d.adrelid AND a.attnum = d.adnum
LEFT JOIN pg_type t ON a.atttypid = t.oid
LEFT JOIN pg_collation c ON a.attcollation = c.oid AND a.attcollation <> t.typcollation
WHERE a.attrelid = '"postgres_partitions"'::regclass
AND a.attnum > 0 AND NOT a.attisdropped
ORDER BY a.attnum
How do I fix?
About this issue
- Original URL
- State: open
- Created 3 years ago
- Reactions: 5
- Comments: 23 (2 by maintainers)
@Lennix Not sure how much effort you’re wanting to put into it, but I went through a migration from this image to the official image recently for a different issue. The comments in #2104 were enough of a start to get going, but it is a bit of a process.
Just for others reading this:
You can’t just replace sameersbn/gitlab with gitlab/gitlab-ce
Please ignore turbras comments.
Continuing with this: Does anyone know how to solve this?
I’m also stuck in version 13.5.4 with the exact same issue. Any update soon ?
Sorry for the delay….by nightly I meant from the gitlab repo directly
Does anyone have a solution? I’ve been running 13.5.4 for several months now, because I’m unable to upgrade.
Facing the same issue when upgrading 12.10.6-1 -> 13.9.4
PostgreSQL: 12-20200524
Edit: I tested some versions in between. Updates works for 13.5.4 but then fails for 13.5.4->13.6.3
Logs:
I got exactly the same when upgrading.