Reindex in AEM6.0 | Community
Skip to main content
Level 6
October 16, 2015
Solved

Reindex in AEM6.0

  • 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

31 replies

Adobe Employee
October 16, 2015

It looks like you have to go through daycare to get "CQ-6.0.0-HOTFIX-5521" 

Any reason why you can't install SP2?

Gokul2011Author
Level 6
October 16, 2015

Hi Opkar.

Searched with "5521" keyword in package share and also in adobe docs.

I am not able to search for the particular zip. But it is shipped with Sp2.

Please let me know to get that package...

Adobe Employee
October 16, 2015

Gokul2011 wrote...

Is the HF is "cq-6.0.0-hotfix-5529" on top of SP1?

 

5521 (I'm assuming 5529 is a typo) is only included in SP2, so if you can't install SP2, install it on top of SP1

Gokul2011Author
Level 6
October 16, 2015

Is the HF is "cq-6.0.0-hotfix-5529" on top of SP1?

Gokul2011Author
Level 6
October 16, 2015

In AEM 6.0 . is this HF can be installed.?

Sham_HC
Level 10
October 16, 2015

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

Gokul2011Author
Level 6
October 16, 2015

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

Please provide the query to execute from oak:index.

Gokul2011Author
Level 6
October 16, 2015

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 .

Gokul2011Author
Level 6
October 16, 2015

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?

Sham_HC
Level 10
October 16, 2015

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