GitHub user tdtmusic2 edited a comment on the discussion: GPU in passthrough
mode on KVM
A later addition to this. Seeing as the kvm route is pointless, I tried via
xcp-ng 8.2. Here the gpu is detected and after adding the host to ACS I can see
that the host_gpu_groups has now a row with "Group of NVIDIA Corporation
TU104GL [Tesla T4] GPUs" for that host (also the integrated gpu but that
doesn't matter). vgpu_types table is also populated, with availability 1 and
type passthrough. However when trying to deploy a vm with a gpu-enabled
offering, I get the same sql query error in ACS...
I think the sql query that ACS is trying to run is wrong. The query in the logs
is this:
```
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 = 185
AND host_gpu_groups.group_name
=x'47726f7570206f66204e766964696120436f72706f726174696f6e205455313034474c205b5465736c612054345d2047505573'
AND (groupId.vgpu_type = x'706173737468726f756768' AND
groupId.remaining_capacity > 0 )
ORDER BY vgpu_types.remaining_capacity DESC;
```
But if I'm running it directly in workbench I get this error: Error Code: 1054.
Unknown column 'vgpu_types.remaining_capacity' in 'order clause'
The query should look like this (and it returns what it should, the available
gpu):
```
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 = 185
AND host_gpu_groups.group_name =
x'47726f7570206f66204e766964696120436f72706f726174696f6e205455313034474c205b5465736c612054345d2047505573'
AND (groupId.vgpu_type = x'706173737468726f756768'
AND groupId.remaining_capacity > 0)
ORDER BY groupId.remaining_capacity DESC;
```
GitHub link:
https://github.com/apache/cloudstack/discussions/10112#discussioncomment-11597542
----
This is an automatically sent email for users@cloudstack.apache.org.
To unsubscribe, please send an email to: users-unsubscr...@cloudstack.apache.org
