yahoo-eng-team team mailing list archive

[Valeriy Ponomaryov <vponomaryov@xxxxxxxxxxxx>]

Public bug reported:

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

** Affects: neutron
     Importance: Undecided
         Status: New


** Tags: db

** Tags added: db

-- 
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 neutron:
  New

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/neutron/+bug/1495523/+subscriptions