Project

General

Profile

Actions

Bug #17428

open

[deployment] arvados-api-server fails to re-install/upgrade if the postgresql-client and the server versions differ

Added by Javier Bértoli about 3 years ago. Updated 28 days ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
Deployment
Target version:
Story points:
-
Release:
Release relationship:
Auto
Actions #1

Updated by Javier Bértoli about 3 years 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.

Actions #2

Updated by Peter Amstutz over 2 years ago

  • Target version deleted (To Be Groomed)
Actions #3

Updated by Peter Amstutz about 1 year ago

  • Release set to 60
Actions #4

Updated by Peter Amstutz 28 days ago

  • Target version set to Future
Actions

Also available in: Atom PDF