Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id B9100106C0 for ; Mon, 17 Feb 2014 21:48:45 +0000 (UTC) Received: (qmail 13941 invoked by uid 500); 17 Feb 2014 21:48:42 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 13918 invoked by uid 500); 17 Feb 2014 21:48:41 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 13766 invoked by uid 500); 17 Feb 2014 21:48:34 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 13605 invoked by uid 99); 17 Feb 2014 21:48:21 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 17 Feb 2014 21:48:21 +0000 Date: Mon, 17 Feb 2014 21:48:21 +0000 (UTC) From: "Srikanteswararao Talluri (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CLOUDSTACK-6130) [Automation] listPublicAdress is failing MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 Srikanteswararao Talluri created CLOUDSTACK-6130: ---------------------------------------------------- Summary: [Automation] listPublicAdress is failing Key: CLOUDSTACK-6130 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-6130 Project: CloudStack Issue Type: Bug Security Level: Public (Anyone can view this level - this is the default.) Components: Management Server Affects Versions: 4.4.0 Environment: xenserver 6.2, advanced zone Reporter: Srikanteswararao Talluri Priority: Blocker Fix For: 4.4.0 List PublicAddress call is resulting in following error: listpublicipaddresses failed, due to: errorCode: 530, errorText:DB Exception on: com.mysql.jdbc.JDBC4PreparedStatement@4847303b: 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 ** ) Link to automated test failure: http://jenkins.buildacloud.org/view/cloudstack-qa-master/job/test-smoke-matrix-master/5/suite=test_network/testReport/integration.smoke.test_network/TestReleaseIP/test_releaseIP/ -- This message was sent by Atlassian JIRA (v6.1.5#6160)