Here is status ouput showing that postgresql/17 running on machine 26 has failed. It likely failed because it doesn't have an IP address and the machine clearly listed in 'pending' state.
[Services]
NAME STATUS EXPOSED CHARM
client unknown false local:trusty/pgclient-7
postgresql error false local:trusty/postgresql-11
[Units]
ID WORKLOAD-STATE AGENT-STATE VERSION MACHINE PORTS PUBLIC-ADDRESS MESSAGE
postgresql/17 error idle 1.26-alpha3.1 26 5432/tcp hook failed: "db-relation-changed" for client:db
[Machines]
ID STATE DNS INS-ID SERIES AZ
0 started 10.0.3.145 juju-5f65e7eb-5d0b-4c6e-8fde-143ad97856fc-machine-0 trusty
26 pending juju-5f65e7eb-5d0b-4c6e-8fde-143ad97856fc-machine-26 trusty
environment: lxd 5d0b-4c6e- 8fde-143ad97856 fc-machine- 0 server- member- status: has-vote 5d0b-4c6e- 8fde-143ad97856 fc-machine- 26 pgclient- 7 postgresql- 11 changed" ' l/17:
workload- status: changed" for client:db'
agent- status:
agent- state: error
agent- state-info: 'hook failed: "db-relation- changed" for client:db'
agent- version: 1.26-alpha3.1
machines:
"0":
agent-state: started
agent-version: 1.26-alpha3.1
dns-name: 10.0.3.145
instance-id: juju-5f65e7eb-
instance-state: Running
series: trusty
hardware: arch=amd64 cpu-cores=0 mem=0M
state-
"26":
agent-state: pending
agent-version: 1.26-alpha3.1
instance-id: juju-5f65e7eb-
instance-state: Running
series: trusty
hardware: arch=amd64 cpu-cores=0 mem=0M
services:
client:
charm: local:trusty/
exposed: false
life: dying
service-status:
current: unknown
message: Waiting for agent initialization to finish
since: 16 Jan 2016 00:28:39+07:00
relations:
db:
- postgresql
db-admin:
- postgresql
postgresql:
charm: local:trusty/
exposed: false
life: dying
service-status:
current: error
message: 'hook failed: "db-relation-
since: 16 Jan 2016 00:48:55+07:00
relations:
db:
- client
db-admin:
- client
replication:
- postgresql
units:
postgresq
current: error
message: 'hook failed: "db-relation-
since: 16 Jan 2016 00:48:55+07:00
current: idle
since: 16 Jan 2016 00:48:55+07:00
version: 1.26-alpha3.1
life: dying
machine: "26"
open-ports:
- 5432/tcp