yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1762877] [NEW] Queen with Postgresql can not create network

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: suzhouclark <1762877@xxxxxxxxxxxxxxxxxx>
Date: Wed, 11 Apr 2018 00:45:41 -0000
Reply-to: Bug 1762877 <1762877@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

pg version:
PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit

Openstack Version:
Installed Packages
openstack-neutron.noarch                                                1:12.0.0-1.el7                                    
openstack-neutron-common.noarch                                         1:12.0.0-1.el7                                    
openstack-neutron-linuxbridge.noarch                                    1:12.0.0-1.el7                                    
openstack-neutron-ml2.noarch                                            1:12.0.0-1.el7                                    
python-neutron.noarch                                                   1:12.0.0-1.el7                                    
python2-neutron-lib.noarch                                              1.13.0-1.el7                                      
python2-neutronclient.noarch                                            6.7.0-1.el7                                       


==============================

cat  /var/log/neutron/server.log

=============================

2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters [req-223d3522-1ce7-4df5-93b8-fe897f16322e 193593edff6943adb6ae487412c188ad 4e121d3b79dd461286a48ee9303b0be0 - default default] DBAPIError exception wrapped from (psycopg2.ProgrammingError) column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
               ^
 [SQL: 'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents."binary" AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %(agent_type_1)s AND agents.availability_zone IN (%(availability_zone_1)s) GROUP BY agents.availability_zone'] [parameters: {'agent_type_1': 'DHCP agent', 'availability_zone_1': u'nova'}] (Background on this error at: http://sqlalche.me/e/f405): ProgrammingError: column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
               ^
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters     context)
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters ProgrammingError: column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters                ^
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters
2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation [req-223d3522-1ce7-4df5-93b8-fe897f16322e 193593edff6943adb6ae487412c188ad 4e121d3b79dd461286a48ee9303b0be0 - default default] POST failed.: DBError: (psycopg2.ProgrammingError) column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
               ^
 [SQL: 'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents."binary" AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %(agent_type_1)s AND agents.availability_zone IN (%(availability_zone_1)s) GROUP BY agents.availability_zone'] [parameters: {'agent_type_1': 'DHCP agent', 'availability_zone_1': u'nova'}] (Background on this error at: http://sqlalche.me/e/f405)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last):
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/pecan/core.py", line 678, in __call__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.invoke_controller(controller, args, kwargs, state)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/pecan/core.py", line 569, in invoke_controller
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     result = controller(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 91, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     setattr(e, '_RETRY_EXCEEDED', True)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 87, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 147, in wrapper
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     ectxt.value = e.inner_exc
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 135, in wrapper
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 126, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     LOG.debug("Retry wrapper got retriable exception: %s", e)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 122, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*dup_args, **dup_kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/pecan_wsgi/controllers/utils.py", line 76, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/pecan_wsgi/controllers/resource.py", line 159, in post
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return self.create(resources)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/pecan_wsgi/controllers/resource.py", line 177, in create
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return {key: creator(*creator_args, **creator_kwargs)}
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 627, in inner
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(self, context, *args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 161, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return method(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 91, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     setattr(e, '_RETRY_EXCEEDED', True)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 87, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 147, in wrapper
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     ectxt.value = e.inner_exc
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 135, in wrapper
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 126, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     LOG.debug("Retry wrapper got retriable exception: %s", e)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 122, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*dup_args, **dup_kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 837, in create_network
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     result, mech_context = self._create_network_db(context, network)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 819, in _create_network_db
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     net_data[az_def.AZ_HINTS])
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 161, in wrapped
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return method(*args, **kwargs)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/agents_db.py", line 115, in validate_availability_zones
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context, agent_type, availability_zones)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/agents_db.py", line 65, in get_availability_zones_by_agent_type
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context, agent_type=agent_type, availability_zones=availability_zones)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/objects/agent.py", line 155, in _get_agents_by_availability_zones_and_agent_type
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     agent_model.Agent.availability_zone.in_(availability_zones)).all()
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return list(self)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return self._execute_and_instances(context)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     result = conn.execute(querycontext.statement, self._params)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return meth(self, multiparams, params)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return connection._execute_clauseelement(self, multiparams, params)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     compiled_sql, distilled_params
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     util.raise_from_cause(newraise, exc_info)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     cursor.execute(statement, parameters)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation DBError: (psycopg2.ProgrammingError) column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation                ^
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation  [SQL: 'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents."binary" AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %(agent_type_1)s AND agents.availability_zone IN (%(availability_zone_1)s) GROUP BY agents.availability_zone'] [parameters: {'agent_type_1': 'DHCP agent', 'availability_zone_1': u'nova'}] (Background on this error at: http://sqlalche.me/e/f405)
2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation

** Affects: neutron
     Importance: Undecided
         Status: New

** Attachment added: "Error info when create network"
   https://bugs.launchpad.net/bugs/1762877/+attachment/5109948/+files/1.PNG

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1762877

Title:
  Queen with Postgresql can not create network

Status in neutron:
  New

Bug description:
  pg version:
  PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit

  Openstack Version:
  Installed Packages
  openstack-neutron.noarch                                                1:12.0.0-1.el7                                    
  openstack-neutron-common.noarch                                         1:12.0.0-1.el7                                    
  openstack-neutron-linuxbridge.noarch                                    1:12.0.0-1.el7                                    
  openstack-neutron-ml2.noarch                                            1:12.0.0-1.el7                                    
  python-neutron.noarch                                                   1:12.0.0-1.el7                                    
  python2-neutron-lib.noarch                                              1.13.0-1.el7                                      
  python2-neutronclient.noarch                                            6.7.0-1.el7                                       

  
  ==============================

  cat  /var/log/neutron/server.log

  =============================

  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters [req-223d3522-1ce7-4df5-93b8-fe897f16322e 193593edff6943adb6ae487412c188ad 4e121d3b79dd461286a48ee9303b0be0 - default default] DBAPIError exception wrapped from (psycopg2.ProgrammingError) column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
  LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
                 ^
   [SQL: 'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents."binary" AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %(agent_type_1)s AND agents.availability_zone IN (%(availability_zone_1)s) GROUP BY agents.availability_zone'] [parameters: {'agent_type_1': 'DHCP agent', 'availability_zone_1': u'nova'}] (Background on this error at: http://sqlalche.me/e/f405): ProgrammingError: column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
  LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
                 ^
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters     context)
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters     cursor.execute(statement, parameters)
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters ProgrammingError: column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters                ^
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters
  2018-04-11 08:39:56.761 4569 ERROR oslo_db.sqlalchemy.exc_filters
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation [req-223d3522-1ce7-4df5-93b8-fe897f16322e 193593edff6943adb6ae487412c188ad 4e121d3b79dd461286a48ee9303b0be0 - default default] POST failed.: DBError: (psycopg2.ProgrammingError) column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
  LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
                 ^
   [SQL: 'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents."binary" AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %(agent_type_1)s AND agents.availability_zone IN (%(availability_zone_1)s) GROUP BY agents.availability_zone'] [parameters: {'agent_type_1': 'DHCP agent', 'availability_zone_1': u'nova'}] (Background on this error at: http://sqlalche.me/e/f405)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation Traceback (most recent call last):
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/pecan/core.py", line 678, in __call__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.invoke_controller(controller, args, kwargs, state)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/pecan/core.py", line 569, in invoke_controller
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     result = controller(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 91, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     setattr(e, '_RETRY_EXCEEDED', True)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 87, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 147, in wrapper
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     ectxt.value = e.inner_exc
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 135, in wrapper
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 126, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     LOG.debug("Retry wrapper got retriable exception: %s", e)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 122, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*dup_args, **dup_kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/pecan_wsgi/controllers/utils.py", line 76, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/pecan_wsgi/controllers/resource.py", line 159, in post
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return self.create(resources)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/pecan_wsgi/controllers/resource.py", line 177, in create
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return {key: creator(*creator_args, **creator_kwargs)}
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/common/utils.py", line 627, in inner
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(self, context, *args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 161, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return method(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 91, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     setattr(e, '_RETRY_EXCEEDED', True)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 87, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 147, in wrapper
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     ectxt.value = e.inner_exc
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_db/api.py", line 135, in wrapper
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 126, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     LOG.debug("Retry wrapper got retriable exception: %s", e)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 220, in __exit__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     self.force_reraise()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     six.reraise(self.type_, self.value, self.tb)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 122, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return f(*dup_args, **dup_kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 837, in create_network
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     result, mech_context = self._create_network_db(context, network)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/plugins/ml2/plugin.py", line 819, in _create_network_db
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     net_data[az_def.AZ_HINTS])
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/api.py", line 161, in wrapped
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return method(*args, **kwargs)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/agents_db.py", line 115, in validate_availability_zones
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context, agent_type, availability_zones)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/db/agents_db.py", line 65, in get_availability_zones_by_agent_type
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context, agent_type=agent_type, availability_zones=availability_zones)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib/python2.7/site-packages/neutron/objects/agent.py", line 155, in _get_agents_by_availability_zones_and_agent_type
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     agent_model.Agent.availability_zone.in_(availability_zones)).all()
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2726, in all
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return list(self)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2878, in __iter__
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return self._execute_and_instances(context)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 2901, in _execute_and_instances
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     result = conn.execute(querycontext.statement, self._params)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 948, in execute
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return meth(self, multiparams, params)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 269, in _execute_on_connection
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     return connection._execute_clauseelement(self, multiparams, params)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1060, in _execute_clauseelement
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     compiled_sql, distilled_params
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1200, in _execute_context
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1409, in _handle_dbapi_exception
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     util.raise_from_cause(newraise, exc_info)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/util/compat.py", line 203, in raise_from_cause
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1193, in _execute_context
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     context)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 507, in do_execute
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation     cursor.execute(statement, parameters)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation DBError: (psycopg2.ProgrammingError) column "agents.id" must appear in the GROUP BY clause or be used in an aggregate function
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation LINE 1: SELECT agents.id AS agents_id, agents.agent_type AS agents_a...
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation                ^
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation  [SQL: 'SELECT agents.id AS agents_id, agents.agent_type AS agents_agent_type, agents."binary" AS agents_binary, agents.topic AS agents_topic, agents.host AS agents_host, agents.availability_zone AS agents_availability_zone, agents.admin_state_up AS agents_admin_state_up, agents.created_at AS agents_created_at, agents.started_at AS agents_started_at, agents.heartbeat_timestamp AS agents_heartbeat_timestamp, agents.description AS agents_description, agents.configurations AS agents_configurations, agents.resource_versions AS agents_resource_versions, agents.load AS agents_load \nFROM agents \nWHERE agents.agent_type = %(agent_type_1)s AND agents.availability_zone IN (%(availability_zone_1)s) GROUP BY agents.availability_zone'] [parameters: {'agent_type_1': 'DHCP agent', 'availability_zone_1': u'nova'}] (Background on this error at: http://sqlalche.me/e/f405)
  2018-04-11 08:39:56.766 4569 ERROR neutron.pecan_wsgi.hooks.translation

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1762877/+subscriptions
Follow ups

[Bug 1762877] Re: Queen with Postgresql can not create network
From: Miguel Lavalle, 2018-04-14