[
https://issues.apache.org/jira/browse/CLOUDSTACK-7861?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Chandan Purushothama updated CLOUDSTACK-7861:
---------------------------------------------
Description:
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}
was:
Notice the public_ip_address= condition in the select statement highlighted
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}
> [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: 4.5.0
>
>
> 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)
