test_network_list_queries_constant fails with testtools.matchers._impl.MismatchError: 28 != 13

[Ihar Hrachyshka]

Traceback (most recent call last):
  File "/home/jenkins/workspace/gate-neutron-python35/neutron/tests/base.py", line 116, in func
    return f(self, *args, **kwargs)
  File "/home/jenkins/workspace/gate-neutron-python35/neutron/tests/unit/plugins/ml2/test_plugin.py", line 595, in test_network_list_queries_constant
    'networks')
  File "/home/jenkins/workspace/gate-neutron-python35/neutron/tests/unit/db/test_db_base_plugin_v2.py", line 6578, in _assert_object_list_queries_constant
    self.assertEqual(before_count, after_count)
  File "/home/jenkins/workspace/gate-neutron-python35/.tox/py35/lib/python3.5/site-packages/testtools/testcase.py", line 411, in assertEqual
    self.assertThat(observed, matcher, message)
  File "/home/jenkins/workspace/gate-neutron-python35/.tox/py35/lib/python3.5/site-packages/testtools/testcase.py", line 498, in assertThat
    raise mismatch_error
testtools.matchers._impl.MismatchError: 28 != 13

logs.openstack.org/12/453212/1/check/gate-neutron-python35/53142ce/testr_results.html.gz

[Ihar Hrachyshka (ihar-hrachyshka)]

2 hits in 7 days: http://logstash.openstack.org/#dashboard/file/logstash.json?query=message%3A%5C%22%20testtools.matchers._impl.MismatchError%3A%2028%20!%3D%2013%5C%22

[OpenStack Infra (hudson-openstack)]

Related fix proposed to branch: master
Review: https://review.openstack.org/456766

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/456766
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=c7acad2a0800e032600b074ca48119c4a3f90a10
Submitter: Jenkins
Branch: master

commit c7acad2a0800e032600b074ca48119c4a3f90a10
Author: Kevin Benton <email address hidden>
Date: Thu Apr 13 14:33:40 2017 -0700

    Record queries for helpful failure msg in bounds test

    This will let us actually see what extra queries are being
    executed.

    Change-Id: I1410ded27f817a95d090a4c18e40d13e69a26768
    Related-Bug: #1679775

[Ihar Hrachyshka (ihar-hrachyshka)]

Here is a failure with SQL queries logged:

http://logs.openstack.org/78/385178/20/check/neutron-coverage-ubuntu-xenial/f4ed3f6/console.html#_2017-04-16_10_12_20_826310

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.openstack.org/457515

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/457515
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=9c4395965158e066becdb84cf30ea5f0e63e7cbc
Submitter: Jenkins
Branch: master

commit 9c4395965158e066becdb84cf30ea5f0e63e7cbc
Author: Kevin Benton <email address hidden>
Date: Tue Apr 18 01:27:37 2017 -0700

    Stop loading OVOServerRpcInterface in ML2 testcase

    This RPC notifier has an asynchronous handler that does DB lookups
    to send notifications after an object has been created. Not only
    is this a waste of resources in unit tests, it interferes with tests
    that are inspecting the DB queries that occur between calls.

    This just blocks the OVOServerRpcInterface in the ML2 test case and
    then enables it for the set of unit tests that needs it.

    Change-Id: I807e2445da9be241c24d8b6e5bda8b12927aa7fc
    Closes-Bug: #1679775

[Reedip (reedip-banerjee-deactivatedaccount)]

http://logs.openstack.org/35/457035/3/check/gate-neutron-python35/b8072b1/console.html#_2017-04-17_00_42_32_525563 was hit

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 11.0.0.0b2 development milestone.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: stable/ocata
Review: https://review.openstack.org/492962

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/492962
Committed: https://git.openstack.org/cgit/openstack/neutron/commit/?id=3f28694e187d7a2953a3842d0235d7145d1abb1d
Submitter: Jenkins
Branch: stable/ocata

commit 3f28694e187d7a2953a3842d0235d7145d1abb1d
Author: Kevin Benton <email address hidden>
Date: Tue Apr 18 01:27:37 2017 -0700

    Stop loading OVOServerRpcInterface in ML2 testcase

    This RPC notifier has an asynchronous handler that does DB lookups
    to send notifications after an object has been created. Not only
    is this a waste of resources in unit tests, it interferes with tests
    that are inspecting the DB queries that occur between calls.

    This just blocks the OVOServerRpcInterface in the ML2 test case and
    then enables it for the set of unit tests that needs it.

    Change-Id: I807e2445da9be241c24d8b6e5bda8b12927aa7fc
    Closes-Bug: #1679775
    (cherry picked from commit 9c4395965158e066becdb84cf30ea5f0e63e7cbc)

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/neutron 10.0.3 release.