[
https://issues.apache.org/jira/browse/CLOUDSTACK-9340?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15233009#comment-15233009
]
ASF GitHub Bot commented on CLOUDSTACK-9340:
--------------------------------------------
Github user bhaisaab commented on the pull request:
https://github.com/apache/cloudstack/pull/1466#issuecomment-207617920
@swill @nvazquez I saw the failing job:
https://travis-ci.org/apache/cloudstack/jobs/121766436
It failed due to missing Marvin distribution:
IOError: [Errno 2] No such file or directory:
'/home/travis/build/apache/cloudstack/tools/marvin/dist/Marvin-*.tar.gz'
The actual error seems to be hidden as only parts of mvn build output are
shown in the output. It is likely that one of the unit tests have failed
(likely one unit test related to kvm disk i/o where it checks some disk
activity -- this has happened in my VM env few time though does not happen on
baremetal).
I'll open a PR to increase verbosity of the Travis build to output which
test/module failed.
> General DB Optimization
> -----------------------
>
> Key: CLOUDSTACK-9340
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9340
> Project: CloudStack
> Issue Type: Improvement
> Security Level: Public(Anyone can view this level - this is the
> default.)
> Affects Versions: 4.9.0
> Reporter: Nicolas Vazquez
> Labels: database
> Fix For: 4.9.0
>
>
> h2. General DB Optimization
> In some production environments there were being experimented delays in most
> of the jobs. A search for DB optimization was taken and some deficiencies
> were discovered, we can group them in 4 groups:
> * Incorrect PRIMARY key
> * Duplicate PRIMARY KEY
> * Missing indexes (Add indexes to avoid full table scans)
> * Some views query (Change view to improve account retrieval speed)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
