GUI - search instance always give the first VM name and GUI is very slow

[dseralathan]

ISSUE TYPE

• Improvement Request

COMPONENT NAME

Categorize the issue - UI

CLOUDSTACK VERSION

CloudStack 4.18.0.0

CONFIGURATION

OS / ENVIRONMENT

KVM with OEL9

SUMMARY

in GUI - when search instance with particular instance name always give the first VM name in the dashboard GUI is very slow

STEPS TO REPRODUCE

GUI- Compute-Instances - search tab - give instance name

EXPECTED RESULTS

search should give the exact VM(instance) name

ACTUAL RESULTS

searching one VM gives the other VM name ( the first VM in list )

[boring-cyborg[bot]]

Thanks for opening your first issue here! Be sure to follow the issue template!

[dseralathan]

Added point : When working on one instance the gUI goes to that first VM in list

[rohityadavcloud]

@dseralathan can you share your ACS and MySQL server versions?

The search results matches with VMs matching/containing the substring, CloudStack keyword search isn't exact. Are other VMs in your search result having the keyword in their names (or displayname)? You've also reported slowness in the API response, how many VMs do you have in your env, and did you try this as a root admin or a normal user account?

[rohityadavcloud]

@dseralathan does it help improve the response time (slowness of UI) if you add the following in the URL:

http://:8080/client/#/vm?details=min http://:8080/client/#/vm?details=servoff,tmpl,nics

compared to: http://:8080/client/#/vm

[weizhouapache]

@dseralathan this should be improved by #7911 can you test it ? you can run UI locally following https://github.com/apache/cloudstack/tree/main/ui#development

[DaanHoogland]

@dseralathan closing this as fixed by #7911. please reopen or open a new one as you see fit if needed.

[rohityadavcloud]

Sorry opening this @DaanHoogland need to hear from @dseralathan thanks

[dseralathan]

Thanks weizhouapache and DaanHoogland

[DaanHoogland]

Thanks weizhouapache and DaanHoogland

@dseralathan , does it help (see @rohityadavcloud 's questions at https://github.com/apache/cloudstack/issues/7910#issuecomment-1692834533 and https://github.com/apache/cloudstack/issues/7910#issuecomment-1692899856) I.e. can we close this issue?

[rohityadavcloud]

Thanks @dseralathan I'm assuming this is acceptable for you, if not pl re-open or raise another issue with more details and steps to reproducing the issue.

[dseralathan]

the VM search give exact VM and is not changing to the first VM in list after we exclude state,IP in field

[rohityadavcloud]

We're potentially still seeing this, so re-opening this with the note on investigation - sometimes the table/column could have multiple indexes - when the query choose between 2 or more indexes the wrong one, it could take time for the query to complete. I would investigate if in the case of listVirtualMachines and lisVirtualMachinesMetrics API what queries pick what columns or what indexes the optimiser may choose to run the query. The explain query (https://dev.mysql.com/doc/refman/8.0/en/using-explain.html) can help us know which indexes are in the path of search/optimisation - fixing the index could make the query go faster.

cc @andrijapanicsb @borisstoyanov @vishesh92 @harikrishna-patnala @shwstppr @DaanHoogland

[rohityadavcloud]

Likely also addressed by https://github.com/apache/cloudstack/pull/9198 @dseralathan can you try to test it in your env if possible?

[rohityadavcloud]

Fixed in https://github.com/apache/cloudstack/pull/9198 pl re-reopen if you still have issues, thanks.

[rohityadavcloud]

Additionally fixed in https://github.com/apache/cloudstack/pull/9177 To make the listing faster, the new global setting will need to be set to false.