** Changed in: neutron
Status: Fix Committed => Fix Released
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1495523
Title:
router-interface-add fails with error 500 on PostgreSQL
Status in Ironic:
Invalid
Status in neutron:
Fix Released
Bug description:
If PostgreSQL is used as DB backend then Neutron fails with error code
500 using CLI "router-interface-add":
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters Traceback
(most recent call last):
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139,
in _execute_context
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters
context)
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
450, in do_execute
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters
cursor.execute(statement, parameters)
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters
ProgrammingError: column "agents.id" must appear in the GROUP BY clause or be
used in an aggregate function
2015-09-14 11:37:13.976 25772 ERROR oslo_db.sqlalchemy.exc_filters LINE 1:
SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
Manila CI Tempest job with PostreSQL errors:
http://logs.openstack.org/01/218801/9/check/gate-manila-tempest-dsvm-
neutron-
postgres/76739da/logs/devstacklog.txt.gz#_2015-09-14_11_37_13_009
http://logs.openstack.org/01/218801/9/check/gate-manila-tempest-dsvm-
neutron-
postgres/76739da/logs/screen-q-svc.txt.gz?level=TRACE#_2015-09-14_11_37_13_976
To manage notifications about this bug go to:
https://bugs.launchpad.net/ironic/+bug/1495523/+subscriptions
--
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to : [email protected]
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help : https://help.launchpad.net/ListHelp
