Skip to content

v2.50.9

Choose a tag to compare

@hasura-bot hasura-bot released this 11 Nov 00:29
· 149 commits to master since this release

Changelog

This is a patch release for v2.50.

Bug fixes and improvements

Server

Fix PostgreSQL source-catalog initialization and upgrades when a logical replication publication includes updates to the catalog version table, including on PostgreSQL 15.15 and equivalent newer releases.

The latest patches of PostgreSQL introduced the missing replica-identity check for INSERT … ON CONFLICT DO UPDATE. Verified by comparing 15.14 and 15.15 source and the official release notes; upstream fix/backpatch. The fix prevents silent logical-replication breakage and checks the UPDATE path even for an empty table.

Affected Postgres versions:

Major Patch introducing the check
PG 15 15.15+
PG 16 16.11+
PG 17 17.7+
PG 18 18.0+

If you are using older GraphQL engine versions, you should not upgrade the latest Postgres server version before upgrading the latest GraphQL engine.

The workaround is running this SQL statement to fix this issue. However, you need to run it to each Postgres data source, and rerun it whenever a new data source is added.

ALTER TABLE hdb_catalog.hdb_source_catalog_version REPLICA IDENTITY FULL;