← Back to team overview

yahoo-eng-team team mailing list archive

[Bug 1589392] [NEW] neutron-server reports "ResourceClosedError: This result object does not return rows. It has been closed automatically."

 

Public bug reported:

neutron-server (kilo-version) reports the following errors when running
our test scripts. (create 2000 VMs in parallel)

2016-06-06 13:13:35.037 26569 DEBUG neutron.db.db_base_plugin_v2 [req-b896ed1d-b6de-48ca-9ac7-5c5426c126e8 ] Allocated IP - 10.1.21.160 from 10.1.21.160 to 10.1.255.254 _try_generate_ip /usr/lib/python2.7/site-packages/neutron/db/db_base_plugin_v2.py:224
2016-06-06 13:13:35.037 26569 DEBUG neutron.db.db_base_plugin_v2 [req-b896ed1d-b6de-48ca-9ac7-5c5426c126e8 ] Allocated IP 10.1.21.160 (268e3fc9-187b-40a4-abb6-e261fd5c3dc0/7b39676e-9c13-4b40-9aca-484f9e9dfaf3/bb0ba575-7d6f-4d43-a6ca-aeaa75ced013) _store_ip_allocation /usr/lib/python2.7/site-packages/neutron/db/db_base_plugin_v2.py:174
2016-06-06 13:13:35.048 26575 INFO neutron.wsgi [req-2a67ea36-7544-4fe5-b8cf-325f60fb1a02 ] 172.20.52.246,172.20.72.14 - - [06/Jun/2016 13:13:35] "GET /v2.0/floatingips.json?fixed_ip_address=10.1.21.49&port_id=aa68a8a3-f4fb-4106-a07f-50e62eddfff1 HTTP/1.1" 200 208 0.030703
2016-06-06 13:13:35.053 26565 INFO neutron.wsgi [-] (26565) accepted ('172.20.72.14', 37930)
2016-06-06 13:13:35.067 26567 ERROR oslo_db.sqlalchemy.exc_filters [req-e0ecf652-3934-48b0-b509-39c2b9b013ad ] DB exception wrapped.
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/result.py", line 781, in fetchall
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters     l = self.process_rows(self._fetchall_impl())
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/result.py", line 750, in _fetchall_impl
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters     self._non_result()
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/result.py", line 755, in _non_result
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters     "This result object does not return rows. "
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters ResourceClosedError: This result object does not return rows. It has been closed automatically.
2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters
2016-06-06 13:13:35.070 26567 ERROR neutron.api.v2.resource [req-e0ecf652-3934-48b0-b509-39c2b9b013ad ] create failed

** Affects: neutron
     Importance: Undecided
         Status: New

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

Title:
  neutron-server reports "ResourceClosedError: This result object does
  not return rows. It has been closed automatically."

Status in neutron:
  New

Bug description:
  neutron-server (kilo-version) reports the following errors when
  running our test scripts. (create 2000 VMs in parallel)

  2016-06-06 13:13:35.037 26569 DEBUG neutron.db.db_base_plugin_v2 [req-b896ed1d-b6de-48ca-9ac7-5c5426c126e8 ] Allocated IP - 10.1.21.160 from 10.1.21.160 to 10.1.255.254 _try_generate_ip /usr/lib/python2.7/site-packages/neutron/db/db_base_plugin_v2.py:224
  2016-06-06 13:13:35.037 26569 DEBUG neutron.db.db_base_plugin_v2 [req-b896ed1d-b6de-48ca-9ac7-5c5426c126e8 ] Allocated IP 10.1.21.160 (268e3fc9-187b-40a4-abb6-e261fd5c3dc0/7b39676e-9c13-4b40-9aca-484f9e9dfaf3/bb0ba575-7d6f-4d43-a6ca-aeaa75ced013) _store_ip_allocation /usr/lib/python2.7/site-packages/neutron/db/db_base_plugin_v2.py:174
  2016-06-06 13:13:35.048 26575 INFO neutron.wsgi [req-2a67ea36-7544-4fe5-b8cf-325f60fb1a02 ] 172.20.52.246,172.20.72.14 - - [06/Jun/2016 13:13:35] "GET /v2.0/floatingips.json?fixed_ip_address=10.1.21.49&port_id=aa68a8a3-f4fb-4106-a07f-50e62eddfff1 HTTP/1.1" 200 208 0.030703
  2016-06-06 13:13:35.053 26565 INFO neutron.wsgi [-] (26565) accepted ('172.20.72.14', 37930)
  2016-06-06 13:13:35.067 26567 ERROR oslo_db.sqlalchemy.exc_filters [req-e0ecf652-3934-48b0-b509-39c2b9b013ad ] DB exception wrapped.
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters Traceback (most recent call last):
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/result.py", line 781, in fetchall
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters     l = self.process_rows(self._fetchall_impl())
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/result.py", line 750, in _fetchall_impl
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters     self._non_result()
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters   File "/usr/lib64/python2.7/site-packages/sqlalchemy/engine/result.py", line 755, in _non_result
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters     "This result object does not return rows. "
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters ResourceClosedError: This result object does not return rows. It has been closed automatically.
  2016-06-06 13:13:35.067 26567 TRACE oslo_db.sqlalchemy.exc_filters
  2016-06-06 13:13:35.070 26567 ERROR neutron.api.v2.resource [req-e0ecf652-3934-48b0-b509-39c2b9b013ad ] create failed

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


Follow ups