yahoo-eng-team team mailing list archive

[Lucas Alvares Gomes <lucasagomes@xxxxxxxxx>]

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