Reindex in AEM6.0

Forum|Forum|10 years ago
October 16, 2015
31 replies
6029 views

Hi All,

If we view properties of images through asset tab , it is taking more time .

In logs we can able to see the below issue continuously

02.07.2015 11:10:26.367 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 17000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:26.589 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 18000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:26.815 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 19000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:27.035 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 20000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:27.257 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 21000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:27.478 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 22000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:27.703 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 23000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query
02.07.2015 11:10:27.921 *WARN* [1.23.17.158 [1435849806530] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/e-papers/test-folder-for-epapers/ken2.png HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 24000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query

Please let me know how to do this indexing, For this which indexing is fine . Lucene or property index.

Also please let me know how to execute from oak:index node.

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

Best answer by ogill

Hi,

if you unable to rerun the upgrade, performing all the cleanup tasks and applicable kwon issue fixes on a copy of your original 5.x AEM instance. Then I suggest you contact daycare to help with the current issue.

Regards,

Opkar

Sham_HC

Level 10

Install the recommended service pack and hotfix from https://helpx.adobe.com/experience-manager/kb/aem6-available-hotfixes.html

G

Gokul2011Author

Level 6

Hi Shyam,

I can see all HF related to AEM6 Sp2 , I am using AEM6. Do you want me to install "oak-1.0.4" to overcome from above issue?

Please let me know for below issue as well. Frequenly i am getting the below

02.07.2015 12:24:18.704 *ERROR* [1.23.17.158 [1435854257935] GET /assets.html/content/dam HTTP/1.1] org.apache.jackrabbit.oak.plugins.index.lucene.IndexTracker Could not access the Lucene index at /
java.io.IOException: Invalid byte range request

Sham_HC

Level 10

Do you have necessary index created ex:- damLuceneProperty.zip https://helpx.adobe.com/experience-manager/kb/performance-tuning-tips.html

G

Gokul2011Author

Level 6

Hi Sham,

First of all thanks for your post.Really helped alot.

Deployed damlucene.zip and reindexed the DAM . All is working fine.

Still i can able to see some query when selecting some images which is traversing more than 40K nodes

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
03.07.2015 12:54:32.249 *WARN* [123.136.215.219 [1435942204682] GET /libs/dam/gui/content/assets/metadataeditor.html/content/dam/core-assets/images/test-folder-for-reports/image1.JPG HTTP/1.1] org.apache.jackrabbit.oak.spi.query.Cursors$TraversingCursor Traversed 49000 nodes with filter Filter(query=select [jcr:path], [jcr:score], * from [cq:Tag] as a where isdescendantnode(a, '/etc/tags/default') /* xpath: /jcr:root/etc/tags/default//element(*, cq:Tag) */, path=/etc/tags/default//*); consider creating an index or changing the query.

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Is anything we need to do with cq:tag indexing? I tried to reindex cq:Tags node from oak:index . But no impact , reindex value is immediately changes to False.

Please suggest how to overcome this issue?

G

Gokul2011Author

Level 6

Hi All,

We are facing some issues with tags loading from assets tab during image tagging.We have more tags under /etc/tags/.Please let me know the query to index them .

G

Gokul2011Author

Level 6

Please let me know how to index many tagging names using TAGID. ???

Please provide the query to execute from oak:index.

Sham_HC

Level 10

Sounds like customization done in metadata editor causing this. Verify the custamization otherwise you are still in sp1 if that is true Install the hotfix cq-6.0.0-hotfix-5521 . Still issue engage through official support channel