metadata sync fails when there is a customer view based on pg_stat_statements

Open mtuncer opened this issue 2 years ago • 2 comments

pg_stat_statements.total_time column was dropped at PG13.
issue is

DB is on PG12, citus 10.2
DB has a view or a function that uses pg_stat_statements.total_time
user upgrades DB to PG13 and citus 11.x
metadata sync fails with a sync failure saying pg_stat_statements.total_time does not exist

Oct 10 '23 09:10 mtuncer

Afaict this is not related to Citus. The upgrade would also fail on plain postgres afaict, because the view or function (defined by the user) cannot possibly exist in PG13.

Oct 10 '23 09:10 JelteF

same or related #7057

Oct 10 '23 09:10 onderkalaci