Duplicate hosts in 'fuel nodes' output

[Sergey Galkin]

api: '1.0'
astute_sha: c3e7c7a18528cf9acca48021488a93dff74f5c97
auth_required: true
build_id: 2014-10-16_19-59-04
build_number: '72'
feature_groups:
- mirantis
fuellib_sha: 677c2809bd602ed6f793b03df49ef8b0f8dcb7e7
fuelmain_sha: 5cf06aac43ccb4a6031fbfa87ff9f9a729314daa
nailgun_sha: b83eaf18cbcc36393f8ac1e7732a6395546a7ca8
ostf_sha: de177931b53fbe9655502b73d03910b8118e25f1
production: docker
release: '6.0'

Reproduced sometimes on the big env.
In this case on the 100 nodes cluster during rally tests.

[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:02:39 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | compute | | True
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True
[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:02:42 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | compute | | True
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True
[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:02:47 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | compute | | True
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True
[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:02:54 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | compute | | True
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True
[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:03:03 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | compute | | True
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True
[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:03:26 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True
[root@fuel ~]# date ; fuel node | grep 95:94
Fri Oct 17 17:03:30 UTC 2014
1 | ready | Untitled (95:94) | 2 | 10.20.0.3 | 8e:55:f5:04:f3:45 | cinder, compute | | True

[Sergey Galkin (sgalkin)]

snapshot
https://drive.google.com/open?id=0B1LFPizteKUEbUdGMC1heThCbVU

[OpenStack Infra (hudson-openstack)]

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

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.openstack.org/129915
Committed: https://git.openstack.org/cgit/stackforge/fuel-web/commit/?id=462290c8140021d1884cf41f32e79d9c74bf0766
Submitter: Jenkins
Branch: master

commit 462290c8140021d1884cf41f32e79d9c74bf0766
Author: Łukasz Oleś <email address hidden>
Date: Tue Oct 21 08:28:23 2014 +0200

    Do not use yield_per when eager loading is used

    In our case using yield_per ended with duplicated rows.
    SQLAlchemy docs do not recommend using it when joinedload
    or subqueryload are used. In version 1.0 SQLAlchemy will raise
    Exception http://docs.sqlalchemy.org/en/latest/changelog/migration_10.html#joined-subquery-eager-loading-explicitly-disallowed-with-yield-per

    Closes-bug: 1382627
    blueprint 100-nodes-support

    Change-Id: I1d9f3c14cba55eda0a0c9176ac745ed28a84476c