depart hook breaks removing admin role

Bug #1172861 reported by Sidnei da Silva
14
This bug affects 2 people
Affects Status Importance Assigned to Milestone
postgresql (Juju Charms Collection)
Fix Released
Undecided
Stuart Bishop

Bug Description

2013-04-25 19:04:15,702: unit.hook.api@CRITICAL: ALTER USER %s NOSUPERUSER
2013-04-25 19:04:16,938: hook.output@INFO: Traceback (most recent call last):

2013-04-25 19:04:16,939: hook.output@INFO: File "/var/lib/juju/units/u1-account-db-0/charm/hooks/db-admin-relation-broken", line 1956, in <
module>

2013-04-25 19:04:16,941: hook.output@INFO:
2013-04-25 19:04:16,941: hook.output@INFO: raise SystemExit(main())

2013-04-25 19:04:16,941: hook.output@INFO: File "/var/lib/juju/units/u1-account-db-0/charm/hooks/db-admin-relation-broken", line 1926, in m
ain

2013-04-25 19:04:16,943: hook.output@INFO:
2013-04-25 19:04:16,943: hook.output@INFO: db_admin_relation_broken(user)

2013-04-25 19:04:16,944: hook.output@INFO: File "/var/lib/juju/units/u1-account-db-0/charm/hooks/db-admin-relation-broken", line 1286, in db_admin_relation_broken

2013-04-25 19:04:16,945: hook.output@INFO:
2013-04-25 19:04:16,946: hook.output@INFO: run_sql_as_postgres(sql, AsIs(quote_identifier(user)))

2013-04-25 19:04:16,946: hook.output@INFO: File "/var/lib/juju/units/u1-account-db-0/charm/hooks/db-admin-relation-broken", line 820, in run_sql_as_postgres

2013-04-25 19:04:16,947: hook.output@INFO:
2013-04-25 19:04:16,947: hook.output@INFO: cur.execute(sql, parameters)

2013-04-25 19:04:16,947: hook.output@INFO: psycopg2
2013-04-25 19:04:16,947: hook.output@INFO: .
2013-04-25 19:04:16,947: hook.output@INFO: ProgrammingError
2013-04-25 19:04:16,947: hook.output@INFO: :
2013-04-25 19:04:16,948: hook.output@INFO: role "db_admin_14__admin" does not exist

Related branches

Stuart Bishop (stub)
Changed in postgresql (Juju Charms Collection):
status: New → Confirmed
Stuart Bishop (stub)
Changed in postgresql (Juju Charms Collection):
status: Confirmed → In Progress
assignee: nobody → Stuart Bishop (stub)
Stuart Bishop (stub)
Changed in postgresql (Juju Charms Collection):
status: In Progress → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Duplicates of this bug

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.