[jira] [Created] (CLOUDSTACK-8434) tag filtering hanging on returning values for listVirtualMachines

["Carles Figuerola (JIRA)" <ji...@apache.org>]

Carles Figuerola created CLOUDSTACK-8434:
--------------------------------------------

             Summary: tag filtering hanging on returning values for listVirtualMachines
                 Key: CLOUDSTACK-8434
                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-8434
             Project: CloudStack
          Issue Type: Bug
      Security Level: Public (Anyone can view this level - this is the default.)
    Affects Versions: 4.4.2, 4.4.0
         Environment: mysql-server-5.1.73-3.el6_5.x86_64
            Reporter: Carles Figuerola


When adding tags and trying to filter based on them the query sits undefinitely on this sql query:

SELECT DISTINCT(user_vm_view.id) FROM user_vm_view WHERE
user_vm_view.account_type != 5  AND
user_vm_view.state != 'Destroyed'  AND
user_vm_view.display_vm = 1  AND 
( ( user_vm_view.tag_key = _binary'chef_env'  AND
user_vm_view.tag_value = _binary'fqa1' ) ) AND
user_vm_view.removed IS NULL 
ORDER BY user_vm_view.id ASC  LIMIT 0, 500
;

This effect is not exhibited on mysql-server version 5.5 (ubuntu 14.04) or version 5.6 (centos 6.6)



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)