Public bug reported:
A job in the Ironic gate gate-tempest-dsvm-ironic-pxe_ssh-postgres is
broken due some change in Neutron which is affecting the Postgres
database backend.
The error is:
2015-08-19 03:23:38.802 ERROR oslo_db.sqlalchemy.exc_filters
[req-61b2cae0-f5a2-420e-b2ab-e3db3e3b00da admin admin] DBAPIError exception
wrapped from (psycopg2.ProgrammingError) column "reservations.expiration" must
appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...sourcedeltas.resource AS resourcedeltas_resource, reservatio...
^
[SQL: 'SELECT resourcedeltas.resource AS resourcedeltas_resource,
reservations.expiration AS reservations_expiration, sum(resourcedeltas.amount)
AS sum_1 \nFROM resourcedeltas JOIN reservations ON reservations.id =
resourcedeltas.reservation_id \nWHERE reservations.tenant_id = %(tenant_id_1)s
AND resourcedeltas.resource IN (%(resource_1)s) AND reservations.expiration >=
%(expiration_1)s GROUP BY resourcedeltas.resource'] [parameters: {'resource_1':
'network', 'expiration_1': datetime.datetime(2015, 8, 19, 3, 23, 38, 799013),
'tenant_id_1': u'666f340431e341f89816478ad8460634'}]
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters Traceback
(most recent call last):
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139,
in _execute_context
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters context)
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
450, in do_execute
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
cursor.execute(statement, parameters)
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
ProgrammingError: column "reservations.expiration" must appear in the GROUP BY
clause or be used in an aggregate function
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters LINE 1:
...sourcedeltas.resource AS resourcedeltas_resource, reservatio...
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
^
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
More logs: http://logs.openstack.org/56/213856/4/check/gate-tempest-
dsvm-ironic-pxe_ssh-
postgres/91c7a5c/logs/screen-q-svc.txt.gz#_2015-08-19_03_23_38_802
The command that failed: http://logs.openstack.org/56/213856/4/check
/gate-tempest-dsvm-ironic-pxe_ssh-
postgres/91c7a5c/logs/devstacklog.txt.gz#_2015-08-19_03_23_38_854
It seems to be caused by https://review.openstack.org/#/c/163659/
** Affects: neutron
Importance: Critical
Status: New
** Description changed:
A job in the Ironic gate gate-tempest-dsvm-ironic-pxe_ssh-postgres is
broken due some change in Neutron which is affecting the Postgres
database backend.
The error is:
2015-08-19 03:23:38.802 ERROR oslo_db.sqlalchemy.exc_filters
[req-61b2cae0-f5a2-420e-b2ab-e3db3e3b00da admin admin] DBAPIError exception
wrapped from (psycopg2.ProgrammingError) column "reservations.expiration" must
appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...sourcedeltas.resource AS resourcedeltas_resource, reservatio...
- ^
- [SQL: 'SELECT resourcedeltas.resource AS resourcedeltas_resource,
reservations.expiration AS reservations_expiration, sum(resourcedeltas.amount)
AS sum_1 \nFROM resourcedeltas JOIN reservations ON reservations.id =
resourcedeltas.reservation_id \nWHERE reservations.tenant_id = %(tenant_id_1)s
AND resourcedeltas.resource IN (%(resource_1)s) AND reservations.expiration >=
%(expiration_1)s GROUP BY resourcedeltas.resource'] [parameters: {'resource_1':
'network', 'expiration_1': datetime.datetime(2015, 8, 19, 3, 23, 38, 799013),
'tenant_id_1': u'666f340431e341f89816478ad8460634'}]
+ ^
+ [SQL: 'SELECT resourcedeltas.resource AS resourcedeltas_resource,
reservations.expiration AS reservations_expiration, sum(resourcedeltas.amount)
AS sum_1 \nFROM resourcedeltas JOIN reservations ON reservations.id =
resourcedeltas.reservation_id \nWHERE reservations.tenant_id = %(tenant_id_1)s
AND resourcedeltas.resource IN (%(resource_1)s) AND reservations.expiration >=
%(expiration_1)s GROUP BY resourcedeltas.resource'] [parameters: {'resource_1':
'network', 'expiration_1': datetime.datetime(2015, 8, 19, 3, 23, 38, 799013),
'tenant_id_1': u'666f340431e341f89816478ad8460634'}]
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters Traceback
(most recent call last):
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139,
in _execute_context
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
context)
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
450, in do_execute
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
cursor.execute(statement, parameters)
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
ProgrammingError: column "reservations.expiration" must appear in the GROUP BY
clause or be used in an aggregate function
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters LINE 1:
...sourcedeltas.resource AS resourcedeltas_resource, reservatio...
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
^
- 2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
- 2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
+ 2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
+ 2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
-
- More logs:
http://logs.openstack.org/56/213856/4/check/gate-tempest-dsvm-ironic-pxe_ssh-postgres/91c7a5c/logs/screen-q-svc.txt.gz#_2015-08-19_03_23_38_802
+ More logs: http://logs.openstack.org/56/213856/4/check/gate-tempest-
+ dsvm-ironic-pxe_ssh-
+ postgres/91c7a5c/logs/screen-q-svc.txt.gz#_2015-08-19_03_23_38_802
The command that failed: http://logs.openstack.org/56/213856/4/check
/gate-tempest-dsvm-ironic-pxe_ssh-
postgres/91c7a5c/logs/devstacklog.txt.gz#_2015-08-19_03_23_38_854
+
+ It seems to be caused by https://review.openstack.org/#/c/163659/
--
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1486467
Title:
Postgres error: column "reservations.expiration" must appear in the
GROUP BY clause or be used in an aggregate function
Status in neutron:
New
Bug description:
A job in the Ironic gate gate-tempest-dsvm-ironic-pxe_ssh-postgres is
broken due some change in Neutron which is affecting the Postgres
database backend.
The error is:
2015-08-19 03:23:38.802 ERROR oslo_db.sqlalchemy.exc_filters
[req-61b2cae0-f5a2-420e-b2ab-e3db3e3b00da admin admin] DBAPIError exception
wrapped from (psycopg2.ProgrammingError) column "reservations.expiration" must
appear in the GROUP BY clause or be used in an aggregate function
LINE 1: ...sourcedeltas.resource AS resourcedeltas_resource, reservatio...
^
[SQL: 'SELECT resourcedeltas.resource AS resourcedeltas_resource,
reservations.expiration AS reservations_expiration, sum(resourcedeltas.amount)
AS sum_1 \nFROM resourcedeltas JOIN reservations ON reservations.id =
resourcedeltas.reservation_id \nWHERE reservations.tenant_id = %(tenant_id_1)s
AND resourcedeltas.resource IN (%(resource_1)s) AND reservations.expiration >=
%(expiration_1)s GROUP BY resourcedeltas.resource'] [parameters: {'resource_1':
'network', 'expiration_1': datetime.datetime(2015, 8, 19, 3, 23, 38, 799013),
'tenant_id_1': u'666f340431e341f89816478ad8460634'}]
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters Traceback
(most recent call last):
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139,
in _execute_context
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
context)
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters File
"/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line
450, in do_execute
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
cursor.execute(statement, parameters)
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
ProgrammingError: column "reservations.expiration" must appear in the GROUP BY
clause or be used in an aggregate function
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters LINE 1:
...sourcedeltas.resource AS resourcedeltas_resource, reservatio...
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
^
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
2015-08-19 03:23:38.802 13949 ERROR oslo_db.sqlalchemy.exc_filters
More logs: http://logs.openstack.org/56/213856/4/check/gate-tempest-
dsvm-ironic-pxe_ssh-
postgres/91c7a5c/logs/screen-q-svc.txt.gz#_2015-08-19_03_23_38_802
The command that failed: http://logs.openstack.org/56/213856/4/check
/gate-tempest-dsvm-ironic-pxe_ssh-
postgres/91c7a5c/logs/devstacklog.txt.gz#_2015-08-19_03_23_38_854
It seems to be caused by https://review.openstack.org/#/c/163659/
To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1486467/+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
