Query does not return newly added pages in results

Avatar

Avatar
Validate 1
Level 2
sundarig9086821
Level 2

Likes

10 likes

Total Posts

28 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
sundarig9086821
Level 2

Likes

10 likes

Total Posts

28 posts

Correct reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
sundarig9086821
Level 2

25-01-2020

Hi,

 

In one of the AEM instance, we face an issue with query results.

Forex: 

if my query is ---- select * from nt:unstructured where cq:template = '/apps/projectname/templatepath' and jcr:path like '/content/projectname/%'

it returns a set of pages which matching template.

However, newly added pages of that template are not returned as part of the query result.

NOTE: This occurs only in one instance, not in other (which is exact clone of -- not working AEM instance).

What might be the cause of missing new pages in query results?

arunpatidar26, Ratna Kumar, smacdonald2008

JaideepBrar

Thanks,
Sundari.

View Entire Topic

Avatar

Avatar
Coach
Employee
jbrar
Employee

Likes

389 likes

Total Posts

869 posts

Correct reply

283 solutions
Top badges earned
Coach
Establish
Give Back 50
Give Back 5
Give Back 3
View profile

Avatar
Coach
Employee
jbrar
Employee

Likes

389 likes

Total Posts

869 posts

Correct reply

283 solutions
Top badges earned
Coach
Establish
Give Back 50
Give Back 5
Give Back 3
View profile
jbrar
Employee

26-01-2020

Most Likely, this issue is caused by indexing.

 

Check [1] to validate if indexes are corrupted or not updating every 5 seconds.

 

[1] http://<host>:<port>/system/console/jmx/org.apache.jackrabbit.oak%3Aname%3Dasync%2Ctype%3DIndexStats