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/
I have rechecked the problem after this patch [1] have been merged. But seems that was not the cause of the problem [2]
[1] https:/ /review. openstack. org/#/c/ 214282/
[2] http:// logs.openstack. org/56/ 213856/ 4/check/ gate-tempest- dsvm-ironic- pxe_ssh- postgres/ 4edf470/ logs/screen- q-svc.txt. gz#_2015- 08-19_10_ 28_35_245