[GitHub] [cloudstack] andrijapanicsb opened a new issue #3208: Error while searching through VM snapshots

[GitBox <gi...@apache.org>]

andrijapanicsb opened a new issue #3208: Error while searching through VM snapshots
URL: https://github.com/apache/cloudstack/issues/3208
 
 
   <!--
   Verify first that your issue/request is not already reported on GitHub.
   Also test if the latest release and master 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
   <!--
   
   -->
   ~~~
   API listVMSnapshot
   ~~~
   
   ##### CLOUDSTACK VERSION
   <!--
   New line separated list of affected versions, commit ID for issues on master branch.
   -->
   
   ~~~
   4.11.2+ (didn't test on older ones)
   ~~~
   
   ##### CONFIGURATION
   <!--
   Information about the configuration if relevant, e.g. basic network, advanced networking, etc.  N/A otherwise
   -->
   No special config needed
   
   ##### OS / ENVIRONMENT
   <!--
   Information about the environment if relevant, N/A otherwise
   -->
   Not relevant
   
   ##### SUMMARY
   <!-- Explain the problem/feature briefly -->
   
   Can't search through VM snapshots
   
   ##### 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 -->
   
   "cmk list vmsnapshot listall=true keyword=ldap" or  simply searching through VM snapshots with just a keyword typed in the search field gives errors 530 with SQL error (check below for output)
   
   
   <!-- You can also paste gist.github.com links for larger files -->
   
   ##### EXPECTED RESULTS
   <!-- What did you expect to happen when running the steps above? -->
   
   ~~~
   Can search successfully through VM snapshots
   ~~~
   
   ##### ACTUAL RESULTS
   <!-- What actually happened? -->
   
   <!-- Paste verbatim command output between quotes below -->
   
   SQL error displayed in the GUI as following (keyword used was "ldap"):
   
   Caught: com.mysql.jdbc.JDBC4PreparedStatement@339fb43b: SELECT vm_snapshots.id, vm_snapshots.uuid, vm_snapshots.name, vm_snapshots.display_name, vm_snapshots.description, vm_snapshots.vm_id, vm_snapshots.account_id, vm_snapshots.domain_id, vm_snapshots.service_offering_id, vm_snapshots.vm_snapshot_type, vm_snapshots.state, vm_snapshots.created, vm_snapshots.removed, vm_snapshots.current, vm_snapshots.parent, vm_snapshots.updated, vm_snapshots.update_count FROM vm_snapshots INNER JOIN account ON vm_snapshots.account_id=account.id WHERE vm_snapshots.state IN ('Ready','Creating','Allocated','Error','Expunging','Reverting') AND (vm_snapshots.name LIKE _binary'%ldap%' OR OR vm_snapshots.description LIKE ** NOT SPECIFIED ** ) AND vm_snapshots.removed IS NULL AND (account.type != ** NOT SPECIFIED ** ) ORDER BY vm_snapshots.created DESC LIMIT 0, 20
   
   

----------------------------------------------------------------
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.
 
For queries about this service, please contact Infrastructure at:
users@infra.apache.org


With regards,
Apache Git Services