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 : [email protected] Unsubscribe : https://launchpad.net/~yahoo-eng-team More help : https://help.launchpad.net/ListHelp
