Revellski opened a new issue, #9483:
URL: https://github.com/apache/cloudstack/issues/9483
<!--
Verify first that your issue/request is not already reported on GitHub.
Also test if the latest release and main branch are affected too.
Always add information AFTER of these HTML comments, but no need to delete
the comments.
-->
##### ISSUE TYPE
<!-- Pick one below and delete the rest -->
* Bug Report
##### COMPONENT NAME
~~~
CS core - GPU
~~~
##### CLOUDSTACK VERSION
~~~
4.19.1.0
~~~
##### CONFIGURATION
~~~
XCP-ng 8.2.1 (platform_version: 3.2.1)
MySQL v8.4.2
Ubuntu 24.04 LTS
~~~
##### OS / ENVIRONMENT
<!--
Information about the environment if relevant, N/A otherwise
-->
##### SUMMARY
<!-- Explain the problem/feature briefly -->
##### STEPS TO REPRODUCE
<!--
For bugs, show exactly how to reproduce the problem, using a minimal
test-case. Use Screenshots if accurate.
For new features, show how the feature would be used.
-->
<!-- Paste example playbooks or commands between quotes below -->
~~~
1. Add a GPU-enabled host
2. Configure ServiceOffering using the GPU family and vGPU type as
`passthrough`
3. Try to deploy an instance using the GPU offering
~~~
<!-- You can also paste gist.github.com links for larger files -->
##### EXPECTED RESULTS
<!-- What did you expect to happen when running the steps above? -->
~~~
The instance should start.
~~~
##### ACTUAL RESULTS
<!-- What actually happened? -->
<!-- Paste verbatim command output between quotes below -->
The instance fails to start:
```
Exception on: com.mysql.cj.jdbc.ClientPreparedStatement:
SELECT host_gpu_groups.id, host_gpu_groups.group_name,
host_gpu_groups.host_id
FROM host_gpu_groups INNER JOIN vgpu_types groupId
ON host_gpu_groups.id=groupId.gpu_group_id
WHERE host_gpu_groups.host_id = 20
AND host_gpu_groups.group_name = x'<REDACTED>'
AND (groupId.vgpu_type = x'<REDACTED>'
AND groupId.remaining_capacity > 0 )
ORDER BY vgpu_types.remaining_capacity DESC ]
```
The ORDER_BY clause should reference the alias `groupId` but not
`vgpu_types.remaining_capacity`
```
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
