Skip to content

Cannot start GPU instances - Exception on: com.mysql.cj.jdbc.ClientPreparedStatement #9483

@Revellski

Description

@Revellski
ISSUE TYPE
  • Bug Report
COMPONENT NAME
CS core - GPU
CLOUDSTACK VERSION
4.19.1.0
CONFIGURATION
OS / ENVIRONMENT
XCP-ng 8.2.1 (platform_version: 3.2.1)
MySQL v8.4.2
Ubuntu 24.04 LTS
SUMMARY
STEPS TO REPRODUCE
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

EXPECTED RESULTS
The instance should start.
ACTUAL RESULTS

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

Metadata

Metadata

Assignees

Type

No type

Projects

No projects

Milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions