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)
