Details
-
Bug
-
Status: Open
-
Major
-
Resolution: Unresolved
-
4.4.0, 4.4.2
-
None
-
None
-
Security Level: Public (Anyone can view this level - this is the default.)
-
None
-
mysql-server-5.1.73-3.el6_5.x86_64
Description
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)