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

Actions

Copy link

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 almost 4 years ago. Updated almost 2 years ago.

Status:

New

Priority:

Normal

Assigned To:

Category:

Deployment

Target version:

Start date:

Due date:

% Done:

Estimated time:

Story points:

Release:

Postponed

Release relationship:

Auto

Actions

Copy link

Updated by Javier Bértoli almost 4 years ago

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
Category set to Deployment
Target version set to To Be Groomed

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

Copy link