[
https://issues.apache.org/jira/browse/CLOUDSTACK-9298?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15189386#comment-15189386
]
ASF GitHub Bot commented on CLOUDSTACK-9298:
--------------------------------------------
Github user nvazquez commented on the pull request:
https://github.com/apache/cloudstack/pull/1425#issuecomment-194884875
Hi @rafaelweingartner @pedro-martins,
I see continuous integration check is still failing due to this error, I
made some changes in <code>setup/db/db/schema-481to490.sql</code>:
<code>[ERROR] Failed to execute goal
org.codehaus.mojo:exec-maven-plugin:1.2.1:java (create-schema) on project
cloud-developer: An exception occured while executing the Java class. null:
InvocationTargetException: Unable to upgrade the database: Unable to execute
upgrade script:
/home/travis/build/apache/cloudstack/developer/target/db/db/schema-481to490.sql:
Access denied; you need (at least one of) the SUPER privilege(s) for this
operation -> [Help 1]</code>
> Improve performance of resource retrieval that have tags associated and
> target volumes, VMs and templates
> ---------------------------------------------------------------------------------------------------------
>
> Key: CLOUDSTACK-9298
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9298
> Project: CloudStack
> Issue Type: Improvement
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Components: API
> Affects Versions: 4.9.0
> Reporter: Nicolas Vazquez
> Fix For: 4.9.0
>
>
> h2. Description of the problem
> When retrieving a large number of resources which have tags associated with,
> retrieval methods took too long. Our goal is to improve performance of this
> methods avoiding query the database for each tag, managing that information
> in memory.
> API methods to improve: {{listTemplates}}, {{listVolumes}},
> {{listVirtualMachines}}
> To achive it, it's necessary to include new columns in {{template_view}},
> {{volume_view}} and {{user_vm_view}}:
> * tag_account_name
> * tag_domain_name
> * tag_domain_uuid
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
