cloudstack-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Gaurav Aradhye (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (CLOUDSTACK-7861) [Automation] Fix the script "test_eip_elb.py" - Wrong mysql select command
Date Wed, 18 Mar 2015 10:17:38 GMT

     [ https://issues.apache.org/jira/browse/CLOUDSTACK-7861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Gaurav Aradhye updated CLOUDSTACK-7861:
---------------------------------------
    Fix Version/s:     (was: 4.5.1)
                   Future

> [Automation] Fix the script "test_eip_elb.py" - Wrong mysql select command
> --------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-7861
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-7861
>             Project: CloudStack
>          Issue Type: Test
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: Automation, Test
>    Affects Versions: 4.5.0
>            Reporter: Chandan Purushothama
>            Assignee: Gaurav Aradhye
>            Priority: Critical
>             Fix For: Future
>
>
> Notice the public_ip_address= 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 where public_ip_address='{networkid
: u'7a48a65d-c771-4492-855b-6486dd2fd03c', domain : u'ROOT', domainid : u'2e24144e-649c-11e4-9a6e-7ea53edf270f',
isstaticnat : False, zoneid : u'e5579dec-ab4a-4207-9e1b-7286c084d2f7', allocated : u'2014-11-05T04:47:04+0000',
id : u'cce3cd84-c792-468f-ba3c-73630124d232', physicalnetworkid : u'5450776f-0a44-498c-a0ba-5667f31b74b2',
fordisplay : True, issourcenat : False, vlanid : u'437ffafb-73c0-4733-9897-184ebf3ed08d',
state : u'Allocating', forvirtualnetwork : True, zonename : u'XenRT-Zone-0', tags : [], associatednetworkname
: u'guestNetworkForBasicZone', vlanname : u'vlan://935', associatednetworkid : u'2e34b2ae-9bbf-488a-9a9b-c1ee532eb464',
ipaddress : u'10.81.96.111', isportable : False, account : u'test-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: ['Traceback (most recent call last):\n',
'  File "/usr/lib/python2.7/unittest/case.py", line 332, in run\n    testMethod()\n', '  File
"/root/cloudstack/test/integration/component/test_eip_elb.py", line 397, in test_02_acquire_ip_enable_static_nat\n
   % public_ip.ipaddress\n', '  File "/usr/local/lib/python2.7/dist-packages/marvin/dbConnection.py",
line 51, in execute\n    cursor.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/dist-packages/mysql/connector/connection.py", line 683, in cmd_query\n
   statement))\n', '  File "/usr/local/lib/python2.7/dist-packages/mysql/connector/connection.py",
line 601, in _handle_result\n    raise errors.get_exception(packet)\n', "ProgrammingError:
1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near '7a48a65d-c771-4492-855b-6486dd2fd03c',
domain : 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)

Mime
View raw message