Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

SOLVED

Help needed on Index Query

Avatar

Level 2

Hi Experts,

 

Our Log shows this error and we need to add Index to our repository for the same.

I am not sure though what the Index should be fo rofllowing query, Please help:

 

On Prod Author1 - Occurrence of Errors/Warnings:  consider creating an index or changing the query.

 

Reason : Missing search index that causes large repository traversal causing performance issues due to high disk I/O.

 

Recommended Actions: Contact customizer to create required search index .

 

Example from logs :

11.05.2020 12:18:25.885 *WARN* [Thread-95] org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter(query=select e.[jcr:path] as [jcr:path], e.[jcr:score] as [jcr:score], e.* from [nt:base] as a inner join [nt:base] as b on ischildnode(b, a) inner join [nt:base] as c on ischildnode(c, b) inner join [nt:base] as d on ischildnode(d, c) inner join [nt:base] as e on ischildnode(e, d) where name(a) = 'wcm' and isdescendantnode(a, '/home') and name(b) = 'notification' and name(c) = 'config' and name(d) = 'subscriptions' and e.[type] = 'page' option(traversal OK) /* xpath: /jcr:root/home//wcm/notification/config/subscriptions/* [@type='page'] option(traversal ok) */, path=/home//*, property=[:localname=[wcm]]); consider creating an index or changing the query

1 Accepted Solution

Avatar

Correct answer by
Community Advisor

Looks like a bug in ACS commons inbox feature. Workaround is
Stop the component in /system/console/components ->notification: com.day.cq.wcm.notification.impl.NotificationManagerImpl and to keep it stopped by using ACS-commons component disabler
https://adobe-consulting-services.github.io/acs-aem-commons/features/osgi-disablers/component-disabl...

 

Refer: https://github.com/Adobe-Consulting-Services/acs-aem-commons/issues/1635

View solution in original post

5 Replies

Avatar

Correct answer by
Community Advisor

Looks like a bug in ACS commons inbox feature. Workaround is
Stop the component in /system/console/components ->notification: com.day.cq.wcm.notification.impl.NotificationManagerImpl and to keep it stopped by using ACS-commons component disabler
https://adobe-consulting-services.github.io/acs-aem-commons/features/osgi-disablers/component-disabl...

 

Refer: https://github.com/Adobe-Consulting-Services/acs-aem-commons/issues/1635

Avatar

Level 2
Hi Sashi, Thank you for the reply, When i try to stop that component i get this error: The request failed: HTTP ERROR: 404 Problem accessing /system/console/components/2780. Reason: Not Found

Avatar

Level 1

This is still occurring and the accepted solution wasn't the root cause. Can anyone in AEM take a look at this issue? looks like the wcm core aem component is generating the query and can help fixing this issue.

Avatar

Level 1

I'm facing the same traversal problem. Do we have a solution for this issue ?