bernardodemarco commented on PR #9188:
URL: https://github.com/apache/cloudstack/pull/9188#issuecomment-2338948065

   I took a look at the marvin logs and, although the tests 
`test_DeployVmAffinityGroup`, `test_01_non_strict_host_anti_affinity` and 
`test_02_non_strict_host_affinity` are related to affinity groups, they do not 
seem to be related to the PR's changes. Apparently they're related to an 
incorrect SQL syntax. Here is the `test_DeployVmAffinityGroup` exception log:
   ```bash
   2024-09-02 20:21:08,522 - CRITICAL - EXCEPTION: test_DeployVmAffinityGroup: 
['Traceback (most recent call last):\n', '  File 
"/usr/lib64/python3.6/unittest/case.py", line 60, in testPartExecutor\n    
yield\n', '  File "/usr/lib64/python3.6/unittest/case.py", line 622, in run\n   
 testMethod()\n', '  File "/marvin/tests/smoke/test_affinity_groups.py", line 
183, in test_DeployVmAffinityGroup\n    
affinitygroupnames=[self.affinity.name]\n', '  File 
"/usr/local/lib/python3.6/site-packages/marvin/lib/base.py", line 691, in 
create\n    virtual_machine = apiclient.deployVirtualMachine(cmd, 
method=method)\n', '  File 
"/usr/local/lib/python3.6/site-packages/marvin/cloudstackAPI/cloudstackAPIClient.py",
 line 4051, in deployVirtualMachine\n    response = 
self.connection.marvinRequest(command, response_type=response, 
method=method)\n', '  File 
"/usr/local/lib/python3.6/site-packages/marvin/cloudstackConnection.py", line 
381, in marvinRequest\n    raise e\n', '  File "/usr/local/lib/python3.6/
 site-packages/marvin/cloudstackConnection.py", line 376, in marvinRequest\n    
raise self.__lastError\n', '  File 
"/usr/local/lib/python3.6/site-packages/marvin/cloudstackConnection.py", line 
105, in __poll\n    % async_response)\n', 'Exception: Job failed: {accountid : 
\'c6541c8f-6961-11ef-9f55-1e009f0003bc\', account : \'admin\', domainid : 
\'8da7e16b-6961-11ef-9f55-1e009f0003bc\', domainpath : \'ROOT\', userid : 
\'c654e153-6961-11ef-9f55-1e009f0003bc\', cmd : 
\'org.apache.cloudstack.api.command.admin.vm.DeployVMCmdByAdmin\', jobstatus : 
2, jobprocstatus : 0, jobresultcode : 530, jobresulttype : \'object\', 
jobresult : {errorcode : 530, errortext : "Unable to find on DB, due to: 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 \')  FOR UPDATE\' at line 
1"}, jobinstancetype : \'VirtualMachine\', jobinstanceid : 
\'76c4bd4b-5624-4b0f-837f-015948b82189\', created : 
\'2024-09-02T20:21:07+0000\', comple
 ted : \'2024-09-02T20:21:07+0000\', jobid : 
\'666bb04f-ec5c-4a45-b4fe-d2bc283c2755\'}\n']
   ```
   
   These same erros also appeared on 
https://github.com/apache/cloudstack/pull/9549#issuecomment-2301227576. 
Furthermore, the pipeline was run previously 
(https://github.com/apache/cloudstack/pull/9188#issuecomment-2290182649) and 
the errors were different.
   
   Given that, @DaanHoogland could we run the CI again?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: commits-unsubscr...@cloudstack.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org

Reply via email to