[
http://jira.nuxeo.org/browse/NXP-3982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Benoit Delbosc resolved NXP-3982.
---------------------------------
Resolution: Fixed
Fix Version/s: 5.2.1
Upgrade notes:
You need to create an index by hand:
CREATE INDEX log_doc_uuid_idx ON nxp_logs (log_doc_uuid);
Fixed for new instance:
http://hg.nuxeo.org/nuxeo/nuxeo-features/rev/51d1dcff53f2
For existing instance the index has to be created by hand see the upgrade notes.
Note that nxaudit-service contribution switch hibernate.hbm2ddl.auto property
from update to create.
This is related to the problem describe here ("Can't create an index using
Annotations" https://forums.hibernate.org/viewtopic.php?f=9&t=973881). Index
creation does not work in update mode.
> Add a missing database index on NXP_LOGS.log_doc_uuid
> -----------------------------------------------------
>
> Key: NXP-3982
> URL: http://jira.nuxeo.org/browse/NXP-3982
> Project: Nuxeo Enterprise Platform
> Issue Type: Improvement
> Components: Audit
> Affects Versions: 5.2 GA
> Reporter: Benoit Delbosc
> Assignee: Benoit Delbosc
> Fix For: 5.2.1
>
>
> The history tab performs requests on the audit table (nxp_logs) using a doc
> id filter,
> having an index on the log_doc_uuid column is not an option when having
> thouthands of lines.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
http://jira.nuxeo.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
_______________________________________________
ECM-tickets mailing list
[email protected]
http://lists.nuxeo.com/mailman/listinfo/ecm-tickets
