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 0650417441 for ; Wed, 25 Mar 2015 09:59:00 +0000 (UTC) Received: (qmail 6859 invoked by uid 500); 25 Mar 2015 09:58:53 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 6830 invoked by uid 500); 25 Mar 2015 09:58:53 -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 6819 invoked by uid 500); 25 Mar 2015 09:58:53 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 6816 invoked by uid 99); 25 Mar 2015 09:58:53 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Mar 2015 09:58:53 +0000 Date: Wed, 25 Mar 2015 09:58:53 +0000 (UTC) From: "Rajani Karuturi (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Updated] (CLOUDSTACK-7861) [Automation] Fix the script "test_eip_elb.py" - Wrong mysql select command MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-7861?page=3Dcom.atl= assian.jira.plugin.system.issuetabpanels:all-tabpanel ] Rajani Karuturi updated CLOUDSTACK-7861: ---------------------------------------- Fix Version/s: (was: Future) 4.6.0 > [Automation] Fix the script "test_eip_elb.py" - Wrong mysql select comman= d > -------------------------------------------------------------------------= - > > Key: CLOUDSTACK-7861 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-786= 1 > Project: CloudStack > Issue Type: Test > Security Level: Public(Anyone can view this level - this is the defa= ult.)=20 > Components: Automation, Test > Affects Versions: 4.5.0 > Reporter: Chandan Purushothama > Assignee: Gaurav Aradhye > Priority: Critical > Fix For: 4.6.0 > > > Notice the public_ip_address=3D condition in the select statement below: > {noformat} > test_02_acquire_ip_enable_static_nat (integration.component.test_eip_elb.= TestEIP): DEBUG: Response : {success : u'true'} > test_02_acquire_ip_enable_static_nat (integration.component.test_eip_elb.= TestEIP): DEBUG: select is_system, one_to_one_nat from user_ip_address wher= e public_ip_address=3D'{networkid : u'7a48a65d-c771-4492-855b-6486dd2fd03c'= , domain : u'ROOT', domainid : u'2e24144e-649c-11e4-9a6e-7ea53edf270f', iss= taticnat : False, zoneid : u'e5579dec-ab4a-4207-9e1b-7286c084d2f7', allocat= ed : u'2014-11-05T04:47:04+0000', id : u'cce3cd84-c792-468f-ba3c-73630124d2= 32', physicalnetworkid : u'5450776f-0a44-498c-a0ba-5667f31b74b2', fordispla= y : True, issourcenat : False, vlanid : u'437ffafb-73c0-4733-9897-184ebf3ed= 08d', state : u'Allocating', forvirtualnetwork : True, zonename : u'XenRT-Z= one-0', tags : [], associatednetworkname : u'guestNetworkForBasicZone', vla= nname : u'vlan://935', associatednetworkid : u'2e34b2ae-9bbf-488a-9a9b-c1ee= 532eb464', ipaddress : u'10.81.96.111', isportable : False, account : u'tes= t-TestEIP-L8KOEI', issystem : False}'; > test_02_acquire_ip_enable_static_nat (integration.component.test_eip_elb.= TestEIP): CRITICAL: EXCEPTION: test_02_acquire_ip_enable_static_nat: ['Trac= eback (most recent call last):\n', ' File "/usr/lib/python2.7/unittest/cas= e.py", line 332, in run\n testMethod()\n', ' File "/root/cloudstack/tes= t/integration/component/test_eip_elb.py", line 397, in test_02_acquire_ip_e= nable_static_nat\n % public_ip.ipaddress\n', ' File "/usr/local/lib/pyt= hon2.7/dist-packages/marvin/dbConnection.py", line 51, in execute\n curs= or.execute(sql, params)\n', ' File "/usr/local/lib/python2.7/dist-packages= /mysql/connector/cursor.py", line 494, in execute\n self._handle_result(= self._connection.cmd_query(stmt))\n', ' File "/usr/local/lib/python2.7/dis= t-packages/mysql/connector/connection.py", line 683, in cmd_query\n stat= ement))\n', ' File "/usr/local/lib/python2.7/dist-packages/mysql/connector= /connection.py", line 601, in _handle_result\n raise errors.get_exceptio= n(packet)\n', "ProgrammingError: 1064 (42000): You have an error in your SQ= L syntax; check the manual that corresponds to your MySQL server version fo= r the right syntax to use near '7a48a65d-c771-4492-855b-6486dd2fd03c', doma= in : u'ROOT', domainid : u'2e24144e-6' at line 1\n"] > --------------------- >> end captured logging << --------------------- > {noformat} -- This message was sent by Atlassian JIRA (v6.3.4#6332)