yahoo-eng-team team mailing list archive

Thread
Date
[Bug 1608378] [NEW] Creating metering-label-rule with non-existent UUID of metering_label_id raised 500 Internal Server Error

To: yahoo-eng-team@xxxxxxxxxxxxxxxxxxx
From: Rahmad Ade Putra <1608378@xxxxxxxxxxxxxxxxxx>
Date: Mon, 01 Aug 2016 06:24:53 -0000
Reply-to: Bug 1608378 <1608378@xxxxxxxxxxxxxxxxxx>
Sender: bounces@xxxxxxxxxxxxx
Public bug reported:

1. When I was trying to create metering-label-rule by inserting non-
existent UUID of metering_label_id then it raised 500 Internal Server
Error, and according to the traceback of logs itself which explained
that "foreign key constraint". However this perhaps should be 404 Not
Found since I was inserting non-existent UUID of metering_label_id.

Here I attached all of request which was sent to API and traceback log.

-------
Request parameters

curl -g -i -X POST http://192.168.122.139:9696/v2.0/metering/metering-label-rules -H "X-Auth-Token: $TOKEN" -d '{"metering_label_rule":{"remote_ip_prefix":"10.0.1.0/24", "direction": "ingress", "metering_label_id":"0fd2758c-0754-4773-997f-44d3db288a75"}}'
HTTP/1.1 500 Internal Server Error
Content-Type: application/json
Content-Length: 150
X-Openstack-Request-Id: req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39
Date: Fri, 29 Jul 2016 01:35:24 GMT

{"NeutronError": {"message": "Request Failed: internal server error
while processing your request.", "type": "HTTPInternalServerError",
"detail": ""}}

--------
Log

2016-07-29 10:35:24.047 1448 DEBUG neutron.wsgi [-] (1448) accepted ('192.168.122.139', 6574) server /usr/local/lib/python2.7/dist-packages/eventlet/wsgi.py:868
2016-07-29 10:35:24.149 1448 DEBUG neutron.api.v2.base [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] Request body: {u'metering_label_rule': {u'remote_ip_prefix': u'10.0.1.0/24', u'direction': u'ingress', u'metering_label_id': u'0fd2758c-0754-4773-997f-44d3db288a75'}} prepare_request_body /opt/stack/neutron/neutron/api/v2/base.py:649
2016-07-29 10:35:24.152 1448 DEBUG neutron.api.v2.base [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] Unknown quota resources ['metering_label_rule']. _create /opt/stack/neutron/neutron/api/v2/base.py:445
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] create failed: No details.
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource Traceback (most recent call last):
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/resource.py", line 79, in resource
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     result = method(request=request, **args)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 397, in create
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return self._create(request, body, **kwargs)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 148, in wrapper
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     ectxt.value = e.inner_exc
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.force_reraise()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     six.reraise(self.type_, self.value, self.tb)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 138, in wrapper
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return f(*args, **kwargs)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 510, in _create
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     obj = do_create(body)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 492, in do_create
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     request.context, reservation.reservation_id)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.force_reraise()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     six.reraise(self.type_, self.value, self.tb)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 485, in do_create
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return obj_creator(request.context, **kwargs)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/services/metering/metering_plugin.py", line 63, in create_metering_label_rule
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context, metering_label_rule)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/metering/metering_db.py", line 174, in create_metering_label_rule
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context.session.add(metering_db)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.rollback()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     compat.reraise(exc_type, exc_value, exc_tb)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.commit()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self._prepare_impl()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.session.flush()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self._flush(objects)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     transaction.rollback(_capture_exception=True)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     compat.reraise(exc_type, exc_value, exc_tb)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     flush_context.execute()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     rec.execute(self)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     uow
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     mapper, table, insert)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     execute(statement, multiparams)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return meth(self, multiparams, params)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return connection._execute_clauseelement(self, multiparams, params)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     compiled_sql, distilled_params
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     util.raise_from_cause(newraise, exc_info)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     reraise(type(exception), exception, tb=exc_tb, cause=cause)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     cursor.execute(statement, parameters)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     result = self._query(query)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     conn.query(q)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 837, in query
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1021, in _read_query_result
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     result.read()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1304, in read
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     first_packet = self.connection._read_packet()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 983, in _read_packet
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     packet.check_error()
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 395, in check_error
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     err.raise_mysql_exception(self._data)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     _check_mysql_exception(errinfo)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     raise errorclass(errno, errorvalue)
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`meteringlabelrules`, CONSTRAINT `meteringlabelrules_ibfk_1` FOREIGN KEY (`metering_label_id`) REFERENCES `meteringlabels` (`id`) ON DELETE CASCADE)') [SQL: u'INSERT INTO meteringlabelrules (id, direction, remote_ip_prefix, metering_label_id, excluded) VALUES (%(id)s, %(direction)s, %(remote_ip_prefix)s, %(metering_label_id)s, %(excluded)s)'] [parameters: {'remote_ip_prefix': u'10.0.1.0/24', 'direction': u'ingress', 'metering_label_id': u'0fd2758c-0754-4773-997f-44d3db288a75', 'id': 'e57b01bc-59fa-4d44-a4dc-1a11c7fc3582', 'excluded': 0}]
2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource
2016-07-29 10:35:24.191 1448 INFO neutron.wsgi [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] 192.168.122.139 - - [29/Jul/2016 10:35:24] "POST /v2.0/metering/metering-label-rules HTTP/1.1" 500 344 0.139746

** Affects: neutron
     Importance: Undecided
     Assignee: Rahmad Ade Putra (leksokmy)
         Status: New


** Tags: metering

** Changed in: neutron
     Assignee: (unassigned) => Rahmad Ade Putra (leksokmy)

-- 
You received this bug notification because you are a member of Yahoo!
Engineering Team, which is subscribed to neutron.
https://bugs.launchpad.net/bugs/1608378

Title:
  Creating metering-label-rule with non-existent UUID of
  metering_label_id raised 500 Internal Server Error

Status in neutron:
  New

Bug description:
  1. When I was trying to create metering-label-rule by inserting non-
  existent UUID of metering_label_id then it raised 500 Internal Server
  Error, and according to the traceback of logs itself which explained
  that "foreign key constraint". However this perhaps should be 404 Not
  Found since I was inserting non-existent UUID of metering_label_id.

  Here I attached all of request which was sent to API and traceback
  log.

  -------
  Request parameters

  curl -g -i -X POST http://192.168.122.139:9696/v2.0/metering/metering-label-rules -H "X-Auth-Token: $TOKEN" -d '{"metering_label_rule":{"remote_ip_prefix":"10.0.1.0/24", "direction": "ingress", "metering_label_id":"0fd2758c-0754-4773-997f-44d3db288a75"}}'
  HTTP/1.1 500 Internal Server Error
  Content-Type: application/json
  Content-Length: 150
  X-Openstack-Request-Id: req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39
  Date: Fri, 29 Jul 2016 01:35:24 GMT

  {"NeutronError": {"message": "Request Failed: internal server error
  while processing your request.", "type": "HTTPInternalServerError",
  "detail": ""}}

  --------
  Log

  2016-07-29 10:35:24.047 1448 DEBUG neutron.wsgi [-] (1448) accepted ('192.168.122.139', 6574) server /usr/local/lib/python2.7/dist-packages/eventlet/wsgi.py:868
  2016-07-29 10:35:24.149 1448 DEBUG neutron.api.v2.base [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] Request body: {u'metering_label_rule': {u'remote_ip_prefix': u'10.0.1.0/24', u'direction': u'ingress', u'metering_label_id': u'0fd2758c-0754-4773-997f-44d3db288a75'}} prepare_request_body /opt/stack/neutron/neutron/api/v2/base.py:649
  2016-07-29 10:35:24.152 1448 DEBUG neutron.api.v2.base [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] Unknown quota resources ['metering_label_rule']. _create /opt/stack/neutron/neutron/api/v2/base.py:445
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] create failed: No details.
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource Traceback (most recent call last):
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/resource.py", line 79, in resource
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     result = method(request=request, **args)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 397, in create
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return self._create(request, body, **kwargs)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 148, in wrapper
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     ectxt.value = e.inner_exc
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.force_reraise()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     six.reraise(self.type_, self.value, self.tb)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_db/api.py", line 138, in wrapper
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return f(*args, **kwargs)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 510, in _create
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     obj = do_create(body)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 492, in do_create
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     request.context, reservation.reservation_id)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 220, in __exit__
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.force_reraise()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/oslo_utils/excutils.py", line 196, in force_reraise
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     six.reraise(self.type_, self.value, self.tb)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/api/v2/base.py", line 485, in do_create
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return obj_creator(request.context, **kwargs)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/services/metering/metering_plugin.py", line 63, in create_metering_label_rule
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context, metering_label_rule)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/opt/stack/neutron/neutron/db/metering/metering_db.py", line 174, in create_metering_label_rule
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context.session.add(metering_db)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 490, in __exit__
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.rollback()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     compat.reraise(exc_type, exc_value, exc_tb)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 487, in __exit__
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.commit()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 392, in commit
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self._prepare_impl()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 372, in _prepare_impl
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self.session.flush()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2019, in flush
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self._flush(objects)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2137, in _flush
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     transaction.rollback(_capture_exception=True)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/langhelpers.py", line 60, in __exit__
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     compat.reraise(exc_type, exc_value, exc_tb)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/session.py", line 2101, in _flush
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     flush_context.execute()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 373, in execute
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     rec.execute(self)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/unitofwork.py", line 532, in execute
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     uow
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 174, in save_obj
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     mapper, table, insert)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/orm/persistence.py", line 767, in _emit_insert_statements
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     execute(statement, multiparams)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 914, in execute
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return meth(self, multiparams, params)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     return connection._execute_clauseelement(self, multiparams, params)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     compiled_sql, distilled_params
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1146, in _execute_context
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1337, in _handle_dbapi_exception
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     util.raise_from_cause(newraise, exc_info)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/util/compat.py", line 202, in raise_from_cause
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     reraise(type(exception), exception, tb=exc_tb, cause=cause)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/base.py", line 1139, in _execute_context
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     context)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/sqlalchemy/engine/default.py", line 450, in do_execute
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     cursor.execute(statement, parameters)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 161, in execute
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     result = self._query(query)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/cursors.py", line 317, in _query
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     conn.query(q)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 837, in query
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     self._affected_rows = self._read_query_result(unbuffered=unbuffered)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1021, in _read_query_result
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     result.read()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 1304, in read
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     first_packet = self.connection._read_packet()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 983, in _read_packet
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     packet.check_error()
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/connections.py", line 395, in check_error
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     err.raise_mysql_exception(self._data)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 120, in raise_mysql_exception
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     _check_mysql_exception(errinfo)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource   File "/usr/local/lib/python2.7/dist-packages/pymysql/err.py", line 112, in _check_mysql_exception
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource     raise errorclass(errno, errorvalue)
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource DBReferenceError: (pymysql.err.IntegrityError) (1452, u'Cannot add or update a child row: a foreign key constraint fails (`neutron`.`meteringlabelrules`, CONSTRAINT `meteringlabelrules_ibfk_1` FOREIGN KEY (`metering_label_id`) REFERENCES `meteringlabels` (`id`) ON DELETE CASCADE)') [SQL: u'INSERT INTO meteringlabelrules (id, direction, remote_ip_prefix, metering_label_id, excluded) VALUES (%(id)s, %(direction)s, %(remote_ip_prefix)s, %(metering_label_id)s, %(excluded)s)'] [parameters: {'remote_ip_prefix': u'10.0.1.0/24', 'direction': u'ingress', 'metering_label_id': u'0fd2758c-0754-4773-997f-44d3db288a75', 'id': 'e57b01bc-59fa-4d44-a4dc-1a11c7fc3582', 'excluded': 0}]
  2016-07-29 10:35:24.186 1448 ERROR neutron.api.v2.resource
  2016-07-29 10:35:24.191 1448 INFO neutron.wsgi [req-f4e2ae59-4d4b-491f-96be-58d9ce6ebc39 e01bc3eadeb045edb02fc6b2af4b5d49 867929bfedca4a719e17a7f3293845de - - -] 192.168.122.139 - - [29/Jul/2016 10:35:24] "POST /v2.0/metering/metering-label-rules HTTP/1.1" 500 344 0.139746

To manage notifications about this bug go to:
https://bugs.launchpad.net/neutron/+bug/1608378/+subscriptions
Follow ups

[Bug 1608378] Re: Creating metering-label-rule with non-existent UUID of metering_label_id raised 500 Internal Server Error
From: OpenStack Infra, 2016-10-31