I just created a devstack with Postgress to verify this report. I used
master branch instead of Queens. But these branches are not that far
apart that if I can accomplish such a basic operation as creating a
network in master I won't be able to do the same in Queens. As you can
see here, I can create a network and its subnets without any problems:
http://paste.openstack.org/show/719239/. As you can also see there, I
log into psql (Postgresql CLI tool) and show that the network and its
subnets are indeed in the DB. So we must assume that this is not a valid
bug and that most likely you have a configuration problem.

If you are interested in replicating my test, I used this Vagrant
configuration: https://github.com/miguellavalle/allinonevagrant. All you
have to do is to stick these two lines:

disable_service mysql
enable_service postgresql

right after this line:
https://github.com/miguellavalle/allinonevagrant/blob/master/provisioning
/setup-allinone.sh#L30

** Changed in: neutron
       Status: New => Invalid

-- 
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:
  Invalid

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

-- 
Mailing list: https://launchpad.net/~yahoo-eng-team
Post to     : yahoo-eng-team@lists.launchpad.net
Unsubscribe : https://launchpad.net/~yahoo-eng-team
More help   : https://help.launchpad.net/ListHelp

Reply via email to