citusdata / citusdata/citus

Citus upgrade might fail due to fkeys between columnar metadata tables having different names in different pg versions

Open
#5,473 10 comments 0 reactions 0 assignees View on GitHub
bug columnar user_reported
Dominant language
C
Stars
12.8k
Forks
794
Avg merge
2d 14h
Merged PRs (30d)
31

Description

edited by @onurctirtir: For the workaround, see https://github.com/citusdata/citus/issues/5473#issuecomment-972627162.

----

The upgrade path from 10.0.3 to 10.1.2 is broken due to the following error. This happens only in a specific scenario where a PG upgrade is also involved. Following are the sequence of steps:

1. We are at Postgres version 11.4 and Citus version 10.0.3
2. Upgraded Postgres to 13.4
3. Now try upgrading Citus to 10.1.2 ----> This FAILS

Following is the error when running the command `ALTER EXTENSION citus UPDATE`:
```
#

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.