OpenStack DBaaS (Trove)

pgsql user-list fails with sql error

Bug #1543816 reported by Alex Tomic
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
OpenStack DBaaS (Trove)
Fix Released
Undecided
Alex Tomic

Bug Description

$ trove user-list pgsql_instance
ERROR: An error occurred communicating with the guest: column "datname" does not exist
LINE 1: SELECT datname, pg_encoding_to_char(encoding), datcollateFRO...

The error is due to a bug in the pgsql guest agent that creates a malformed sql statement

Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix proposed to trove (master)

Fix proposed to branch: master
Review: https://review.openstack.org/278120

Changed in trove:
assignee: nobody → Alex Tomic (atomic777)
status: New → In Progress
Alex Tomic (atomic777)
Changed in trove:
status: In Progress → New
Revision history for this message
OpenStack Infra (hudson-openstack) wrote : Fix merged to trove (master)

Reviewed: https://review.openstack.org/278120
Committed: https://git.openstack.org/cgit/openstack/trove/commit/?id=61d06b510a6ff779fd2a361220d12ee7b9851ac7
Submitter: Jenkins
Branch: master

commit 61d06b510a6ff779fd2a361220d12ee7b9851ac7
Author: Alex Tomic <email address hidden>
Date: Fri Oct 2 16:50:15 2015 -0400

    Malformed user access sql for postgres guest agent

    The postgresql guest agent creates a malformed sql statement
    when attempting to retrieve or modify the list of users with
    access to the DB.

    Change-Id: I87d3a71b4b567707561dd8110b3f80f8095f95bb
    Fixes-bug: 1543816

Changed in trove:
status: New → Fix Released
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.
Subscribing...

Other bug subscribers

Remote bug watches

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