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