[Bug]: version 2.13.1 test cases failing on postgres 15.10

[harinath001]

What type of bug is this?

Unexpected error

What subsystems and features are affected?

Build system

What happened?

we tried to compile and install version 2.13.1
regression test cases are failing for postgres 15.10.

We are currently using 2.13.1 on postgres 13 and we want to upgrade to postgres 15.10 using pg_upgrade and its failing if we use version 2.17.x on postgres 15.10

TimescaleDB version affected

2.13.1

PostgreSQL version used

15.10

What operating system did you use?

RHEL8 and RHEL9

What installation method did you use?

Source

What platform did you run on?

On prem/Self-hosted

Relevant log output and stack trace

we are seeing regression test case failures



     ============== running regression test queries        ==============
     test cagg_invalidation            ... ok          452 ms
     test move                         ... ok         1126 ms
     test reorder                      ... ok         3759 ms
     parallel group (11 tests):  bgw_security cagg_errors cagg_deprecated_bucket_ng bgw_policy cagg_permissions cagg_policy bgw_job_ddl cagg_refresh cagg_query bgw_telemetry agg_partials_pushdown
          agg_partials_pushdown        ... ok         1990 ms
          bgw_job_ddl                  ... ok          637 ms
          bgw_policy                   ... ok          632 ms
          bgw_security                 ... ok          628 ms
          bgw_telemetry                ... ok         1417 ms
          cagg_deprecated_bucket_ng    ... ok          631 ms
          cagg_errors                  ... FAILED      629 ms
          cagg_permissions             ... ok          633 ms
          cagg_policy                  ... FAILED      636 ms
          cagg_query                   ... FAILED      636 ms
          cagg_refresh                 ... FAILED      636 ms
     parallel group (11 tests):  cagg_union_view-15 compressed_collation compress_float8_corrupt compress_dml_copy chunk_column_stats-15 cagg_utils compress_default cagg_watermark-15 compression compress_auto_sparse_index compressed_detoaster
          cagg_union_view-15           ... FAILED      603 ms
          cagg_utils                   ... FAILED      648 ms
          cagg_watermark-15            ... FAILED      780 ms
          chunk_column_stats-15        ... ok          626 ms
          compress_auto_sparse_index   ... ok         1003 ms
          compress_default             ... ok          662 ms
          compress_dml_copy            ... ok          626 ms
          compress_float8_corrupt      ... ok          618 ms
          compressed_collation         ... ok          617 ms
          compressed_detoaster         ... ok         1345 ms
          compression                  ... FAILED      802 ms
     parallel group (11 tests):  compression_fks compression_create_compressed_table compression_policy compression_settings compression_sorted_merge_columns compression_conflicts compression_insert compression_permissions compression_qualpushdown compression_defaults compression_sorted_merge-15
          compression_conflicts        ... ok          700 ms
          compression_create_compressed_table ... ok          633 ms
          compression_defaults         ... ok         1321 ms
          compression_fks              ... ok          633 ms
          compression_insert           ... FAILED      701 ms
          compression_permissions      ... ok          862 ms
          compression_policy           ... ok          654 ms
          compression_qualpushdown     ... ok         1293 ms
          compression_settings         ... ok          660 ms
          compression_sorted_merge-15  ... ok         6666 ms
          compression_sorted_merge_columns ... ok          679 ms
     parallel group (11 tests):  merge_compress merge_append_partially_compressed-15 size_utils_tsl modify_exclusion-15 foreign_keys partialize_finalize jit plan_skip_scan-15 decompress_index compression_sorted_merge_distinct policy_generalization
          compression_sorted_merge_distinct ... ok         5174 ms
          decompress_index             ... ok         2423 ms
          foreign_keys                 ... ok          665 ms
          jit                          ... FAILED     1060 ms
          merge_append_partially_compressed-15 ... ok          572 ms
          merge_compress               ... ok          571 ms
          modify_exclusion-15          ... ok          605 ms
          partialize_finalize          ... ok          919 ms
          plan_skip_scan-15            ... ok         1449 ms
          policy_generalization        ... ok         6521 ms
          size_utils_tsl               ... FAILED      600 ms
     parallel group (7 tests):  vector_agg_param transparent_decompression_join_index vector_agg_default vectorized_aggregation transparent_decompression-15 skip_scan transparent_decompression_ordered_index-15
          skip_scan                    ... ok         2504 ms
          transparent_decompression-15 ... FAILED     1514 ms
          transparent_decompression_join_index ... ok          422 ms
          transparent_decompression_ordered_index-15 ... ok         3180 ms
          vector_agg_default           ... ok          435 ms
          vector_agg_param             ... ok          408 ms
          vectorized_aggregation       ... ok         1400 ms
     ============== shutting down postmaster               ==============
     
     ========================
      12 of 54 tests failed. 
     ========================

How can we reproduce the bug?

./bootstrap -DPG_CONFIG=${POSTGRES_INSTALL_PATH}/bin/pg_config
cd build && make
make install
cmake -DPG_SOURCE_DIR=${REPO_ROOT} ..

# this step is failing
make installcheck