Hi Hugo/Ian,

I suspect https://issues.apache.org/jira/browse/CLOUDSTACK-6130 is caused
by some of recent change of findbugs. It's likely got something wrong with
GeneralDaoBase, and the most recently modifications are:

commit 443acac92792cbffff2654c3414df276efac404f
Author: Hugo Trippaers <htrippa...@schubergphilis.com>
Date:   Fri Feb 14 18:36:18 2014 +0100

    Fix functional issue introduced by some findbug changes.

commit 5a6ad11fa2ca3de64b94095c628bd3ba12e618c3
Author: Ian Southam <isout...@schubergphilis.com>
Date:   Wed Feb 12 17:08:52 2014 +0100

    findbugs findings

    Signed-off-by: Hugo Trippaers <htrippa...@schubergphilis.com>

>From the error message, it shows statement as:

SELECT COUNT(*) FROM user_ip_address INNER JOIN account ON
user_ip_address.account_id=account.id INNER JOIN vlan ON
user_ip_address.vlan_db_id=vlan.id WHERE user_ip_address.account_id=5 AND
user_ip_address.allocated IS NOT NULL AND (account.type != 'VirtualNetwork'
) AND (vlan.vlan_type = ** NOT SPECIFIED ** )

And you can observed that some parameters have been shifted left by one
position, because vlan.vlan_type should compare to "virtualNetwork". It
should related to "i++"/"++i" change in the commit.

After reverting these two commits, everything is fine.

Could you take a look?

--Sheng

Reply via email to