Bionic: PostgresQL 10 no longer starts up

#1

Recently my builds started failing although the Travis config did not change. I’m trying to run Postgres v10 in Bionic. The error I get is:

Starting PostgreSQL v10
Job for postgresql@10-main.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status postgresql@10-main.service" and "journalctl -xe" for details.
sudo systemctl start postgresql@10-main

I’ve created a minimal repro to demonstrate. Here is the failed job. Here are the relevant parts of the config:

dist: bionic
sudo: false
services:
  - postgresql
addons:
  postgresql: "10"
  apt:
    packages:
      - postgresql-10
      - postgresql-client-10
      - postgresql-contrib-10
before_install:
  - psql -d template1 -U postgres -c "CREATE USER pinafore WITH PASSWORD 'pinafore' CREATEDB;"

Of course it fails when it tries to run psql because it cannot connect:

psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

This code was working as of about a week ago.

1 Like
#2

Update: switching from bionic to xenial works. So this appears to just be a problem with bionic.

#3

We are running into the same issue since today. Nothing changed on our end. Anyone else is experiencing it?

#4

@san983 same here, have raised a ticket but no response yet.

#5

If it’s happening recently, please point to the failing build URL.

My quick tests are working.

https://travis-ci.org/BanzaiMan/travis_production_test/builds/650527368#L196
https://travis-ci.org/BanzaiMan/travis_production_test/builds/650528532#L213

#6

Can’t post links (I’m on .com not .org), but my builds continue to fail:

travis_setup_postgresql 10
eStarting PostgreSQL v10e
Job for postgresql@10-main.service failed because the service did not take the steps required by its unit configuration.
See "systemctl status postgresql@10-main.service" and "journalctl -xe" for details.
…
psql -c "CREATE DATABASE travisci;" -U postgres
psql: could not connect to server: No such file or directory
Is the server running locally and accepting
connections on Unix domain socket "/var/run/postgresql/.s.PGSQL.5432"?

#7

@BanzaiMan I think I’ve figured out what’s causing it by looking at your config. My project’s .travis.yml file looked like this:

addons:
    postgresql: "10"
    apt:
        packages:
            - postgresql-10
            - postgresql-client-10

This was working absolutely fine as recently as yesterday. However, yours looks like this:

addons:
    postgresql: "10"

Removing the apt section from mine resolved the issue, but this is definitely a change on Travis’ end as my config has not changed since yesterday and previously passing builds now fail.

2 Likes
#8

I see. My guess would be that our addon is making changes to the apt packages (which is installed earlier) and that is causing the problem.

#9

Thanks @HappyTepid. I drove my fix, but just removing postgresql-10, I needed the postgresql-client-10 package

#10

So, this configuration is explicitly stated in our documentation.

We will look into fixing this.

1 Like
#11

@BanzaiMan Thanks for providing a suggestion. For what is worth, I shared links and detailed examples via support on the ticket I opened on Thursday. I yet have to receive a reply after 4 days :confused:

We ultimately addressed it by removing postgresql-10 as suggested here. I’d love to better understand if my support request got lost in the wire.

Imprint