citusdata / citusdata/citus

Citus upgrade to 10.2.x from 10.1.2 fails due to violation of NOT-NULL constraint

Open
#5,985 1 comment 1 reaction 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

The upgrade path from 10.1.2 to 10.2.4 fails due to following constraint violation.
Following is the scenario due to which this could happen:

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 and hence used the workaround suggested here: https://github.com/citusdata/citus/issues/5473
4. Now upgrading from Citus 10.1.2 to 10.2.4 resulted in the following error when trying to run the command `ALTER EXTESION 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.