Ask Your Question

briandlees's profile - activity

2019-08-24 05:27:29 -0500 received badge  Student (source)
2019-08-24 05:27:23 -0500 received badge  Popular Question (source)
2019-08-23 17:05:10 -0500 asked a question How do I investigate placement-api errors

I followed the instructions for installing placement-api (Stein) on SuSE Leap 15.0 and postgresql but when trying to verify using "placement-status upgrade check" I get a huge list of errors which I don't know how to investigate. Suggestions on where to start would be appreciated:

DBAPIError exception wrapped from (psycopg2.ProgrammingError) column "allocations.created_at" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: FROM (SELECT allocations.created_at AS allocations_created_a... ^ [SQL: 'SELECT count(*) AS count_1 \nFROM (SELECT allocations.created_at AS allocations_created_at, allocations.updated_at AS allocations_updated_at, allocations.id AS allocations_id, allocations.resource_provider_id AS allocations_resource_provider_id, allocations.consumer_id AS allocations_consumer_id, allocations.resource_class_id AS allocations_resource_class_id, allocations.used AS allocations_used \nFROM allocations GROUP BY allocations.consumer_id) AS anon_1'] (Background on this error at: http://sqlalche.me/e/f405) Traceback (most recent call last): File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1236, in _execute_context cursor, statement, parameters, context File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/default.py", line 536, in do_execute cursor.execute(statement, parameters) ProgrammingError: column "allocations.created_at" must appear in the GROUP BY clause or be used in an aggregate function LINE 2: FROM (SELECT allocations.created_at AS allocations_created_a... ^

Error: Traceback (most recent call last): File "/usr/lib/python2.7/site-packages/oslo_upgradecheck/upgradecheck.py", line 169, in run return conf.command.action_fn() File "/usr/lib/python2.7/site-packages/oslo_upgradecheck/upgradecheck.py", line 99, in check result = func(self) File "/usr/lib/python2.7/site-packages/placement/cmd/status.py", line 93, in _check_incomplete_consumers missing_consumer_count = self._count_missing_consumers(self.ctxt) File "/usr/lib/python2.7/site-packages/oslo_db/sqlalchemy/enginefacade.py", line 1012, in wrapper return fn(args, *kwargs) File "/usr/lib/python2.7/site-packages/placement/cmd/status.py", line 72, in _count_missing_consumers models.Allocation.consumer_id).count() File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3318, in count return self.from_self(col).scalar() File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3069, in scalar ret = self.one() File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3039, in one ret = self.one_or_none() File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3008, in one_or_none ret = list(self) File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3081, in __iter__ return self._execute_and_instances(context) File "/usr/lib64/python2.7/site-packages/sqlalchemy/orm/query.py", line 3106, in _execute_and_instances result = conn.execute(querycontext.statement, self._params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 980, in execute return meth(self, multiparams, params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/sql/elements.py", line 273, in _execute_on_connection return connection._execute_clauseelement(self, multiparams, params) File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1099, in _execute_clauseelement distilled_params, File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1240, in _execute_context e, statement, parameters, cursor, context File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/base.py", line 1456, in _handle_dbapi_exception util.raise_from_cause(newraise, exc_info) File "/usr/lib64/python2.7/site-packages/sqlalchemy/util ... (more)