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

tag filtering hanging on returning values for listVirtualMachines

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 4.4.0, 4.4.2
    • Fix Version/s: None
    • Component/s: None
    • Security Level: Public (Anyone can view this level - this is the default.)
    • Labels:
      None
    • Environment:
      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

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

              Dates

              • Created:
                Updated: