Uploaded image for project: 'CloudStack'
  1. CloudStack
  2. CLOUDSTACK-8434

tag filtering hanging on returning values for listVirtualMachines

    XMLWordPrintableJSON

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)

      Attachments

        Activity

          People

            Unassigned Unassigned
            cfiguerola Carles Figuerola
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated: