Concourse failed to upgrade with error "operator class int4_ops does not accept data type bigint"

Products

• Concourse for VMware Tanzu

Issue/Introduction

When upgrading to concourse v7 or higher version, the bosh task might fail with the following message.

Task xxxxx | xx:xx:xx | Updating instance web: web/xxxxxxxxxxxxxxxxxx (0) (canary) (00:xx:xx) 
L Error: 'web/xxxxxxxxxxxxxxxxxx (0)' is not running after update. Review logs for failed jobs: web

We can bosh ssh into the web vm to debug this issue further. In the /var/vcap/sys/log/web/web.stderr.log, we could find the following error,

+ chmod 0600 /var/vcap/jobs/web/config/env/CONCOURSE_TSA_HOST_KEY
error: failed to connect to database: migration '1603401316_alter_build_integers_to_bigints.up.sql' 
failed and was rolled back: pq: operator class "int4_ops" does not accept data type bigint

This is an issue in PostgreSQL database and can be solved by upgrading to PostgreSQL v43.

Environment

Product Version: Other

Resolution

We could upgrade PostgreSQL database to v11.10 and then proceed the concourse upgrade again. PostgreSQL v43 is shipped with v11.10, which can be downloaded at https://github.com/cloudfoundry/postgres-release/releases