Downgrade to supported libpq-dev for Trusty

rajadain commented 5 years ago

Overview

The 9.4.* series of libpq-dev seems to have disappeared, so we switch to 9.3. This is the only option here: https://packages.ubuntu.com/trusty/libpq-dev

This unblocks provisioning for app and worker VMs.

Testing Instructions

Destroy and create app and worker and ensure they are created correctly

rajadain commented 5 years ago

Seeing this in CI:

Reading package lists...
Building dependency tree...
Reading state information...
The following package was automatically installed and is no longer required:
  liblwgeom-2.2-5
  Use 'apt-get autoremove' to remove it.
The following extra packages will be installed:
  comerr-dev krb5-multidev libgssapi-krb5-2 libgssrpc4 libk5crypto3
  libkadm5clnt-mit9 libkadm5srv-mit9 libkdb5-7 libkrb5-3 libkrb5support0
  libssl-dev libssl-doc libssl1.0.0 zlib1g-dev
  Suggested packages:
  doc-base krb5-doc krb5-user postgresql-doc-9.3
  The following packages will be REMOVED:
  postgresql-9.4 postgresql-9.4-postgis-2.2 postgresql-9.4-postgis-2.3
  postgresql-client-9.4 postgresql-contrib-9.4 postgresql-server-dev-9.4
  The following NEW packages will be installed:
  comerr-dev krb5-multidev libgssrpc4 libkadm5clnt-mit9 libkadm5srv-mit9
  libkdb5-7 libssl-dev libssl-doc zlib1g-dev
  The following packages will be upgraded:
  libgssapi-krb5-2 libk5crypto3 libkrb5-3 libkrb5support0 libssl1.0.0
  The following packages will be DOWNGRADED:
  libpq-dev libpq5
  5 upgraded, 9 newly installed, 2 downgraded, 6 to remove and 77 not upgraded.
Need to get 4076 kB of archives.
After this operation, 21.9 MB disk space will be freed.

E: There are problems and -y was used without --force-yes

likely because it's not building the VMs from scratch. Going to try and clear the workspace to see if that has any effects.

mmcfarland commented 5 years ago

When destroying and provisioning locally, I fail on this task for app

TASK [bee-pollinator.beekeepers : Fetch Node Docker Image] *********************
Thursday 14 March 2019  17:22:26 -0400 (0:00:00.277)       0:02:14.264 ******** 
fatal: [app]: FAILED! => {"changed": false, "failed": true, "msg": "Failed to import docker-py - cannot import name Client. Try `pip install docker-py`"}

But it does succeed for worker.

I thought the app error might be transitory, but it's happened consistently over the last two days.

rajadain commented 5 years ago

Hmm, I just tried it and it worked:

Friday 15 March 2019  11:15:45 -0400 (0:00:00.048)       0:09:30.587 **********
===============================================================================
bee-pollinator.app : Install application Python dependencies for development and test -- 79.29s
bee-pollinator.beekeepers : Generate Beekeepers Bundle ----------------- 65.71s
bee-pollinator.beekeepers : Fetch Node Docker Image -------------------- 64.17s
azavea.docker : Install Docker ----------------------------------------- 31.16s
bee-pollinator.base : Install Geospatial libraries --------------------- 28.85s
bee-pollinator.app : Create JS bundles (development) ------------------- 20.58s
bee-pollinator.app : Delete *.pyc files -------------------------------- 20.45s
bee-pollinator.app : Install Firefox for UI tests ---------------------- 18.99s
bee-pollinator.beekeepers : Install NPM Dependencies ------------------- 14.92s
azavea.python : Install Python development packages -------------------- 14.02s
Update APT cache ------------------------------------------------------- 12.94s
bee-pollinator.app : Install application JavaScript dependencies ------- 12.93s
azavea.pip : Install pip ----------------------------------------------- 11.60s
azavea.nginx : Install Nginx ------------------------------------------- 11.43s
azavea.postgresql-support : Install client API libraries for PostgreSQL -- 10.04s
bee-pollinator.beekeepers : Add Docker dependencies for Ansible --------- 9.42s
azavea.postgresql-support : Configure the PostgreSQL APT repositories --- 8.99s
azavea.postgresql-support : Install PostgreSQL driver for Python -------- 7.85s
azavea.nginx : Configure the Nginx PPA ---------------------------------- 7.79s
azavea.docker : Configure the Docker APT repository --------------------- 7.49s

Wonder if it has to do with macOS vs Linux host? I'm using Vagrant 2.2.0 and Ansible 2.7.8.

rajadain commented 5 years ago

Wiped out the workspace. Going to try again.

rajadain commented 5 years ago

@azavea-bot rebuild

rajadain commented 5 years ago

@azavea-bot rebuild

rajadain commented 5 years ago

Finally working on CI. Good for another look.

mmcfarland commented 5 years ago

This completed locally for me as well, must have been transient afterall.

rajadain commented 5 years ago

Thanks for taking a look. Merging this now.

project-icp / bee-pollinator-app

Downgrade to supported libpq-dev for Trusty #496

Overview

Testing Instructions