Bug #17428

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

Added by Javier Bértoli 7 months ago. Updated 3 months ago.

Status:
New
Priority:
Normal
Assigned To:
-
Category:
Deployment
Target version:
-
Start date:
Due date:
% Done:

0%

Estimated time:
Story points:
-

History

#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.

#2 Updated by Peter Amstutz 3 months ago

  • Target version deleted (To Be Groomed)

Also available in: Atom PDF