[deployment] arvados-api-server fails to re-install/upgrade if the postgresql-client and the server versions differ
#1 Updated by Javier Bértoli 7 months ago
- Target version set to To Be Groomed
- Category set to Deployment
- Subject changed from [deployment] arvados-api-server to [deployment] arvados-api-server fails to re-install/upgrade if the postgresql-client and the server versions differ
When re-installing/upgrading the
arvados-api-server package, it tries to perform a postgresql database dump as part of its
rake tasks. However, if the
pg_dump and postgresql server versions differ, it aborts with an error like this one
Unpacking arvados-controller (2.1.2-1) ... Setting up arvados-api-server (2.1.2-1) ... ... Running bundle install... done. Ensuring directory and file permissions ...... done. Running db:migrate... ... pg_dump: server version: 11.8; pg_dump version: 10.15 (Ubuntu 10.15-0ubuntu0.18.04.1) pg_dump: aborting because of server version mismatch rake aborted! failed to execute: pg_dump -s -x -O -f /var/www/arvados-api/current/db/structure.sql rch01_arvados Please check the output above for any errors and make sure that `pg_dump` is installed in your PATH and has proper permissions.
This issue does not seem to happen on a fresh install.
I had this issue on an Ubuntu 18.04 api server (which has postgresql-client version 10.5) and an AWS-RDS database version 11.8.