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
BedrockMission!

Learn More

View all

Sign in to view all badges

Index warnings when opening the folder that has several thousands of images

Avatar

Avatar
Give Back
Level 1
abera
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Give Back
View profile

Avatar
Give Back
Level 1
abera
Level 1

Likes

0 likes

Total Posts

5 posts

Correct Reply

0 solutions
Top badges earned
Give Back
View profile
abera
Level 1

30-04-2020

Hi 

I am seeing the below warnings in the error logs when the folder is opened containing 1000's of images. How can I prevent this?

 

30.04.2020 15:06:39.263 *WARN* [10.43.0.17 [1588259199200]

GET /assets.html/content/dam/images/webimages/p1-ko HTTP/1.1]
org.apache.jackrabbit.oak.plugins.index.Cursors$TraversingCursor Traversed 1000 nodes with filter Filter
(query=select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/images/webimages/p1-ko')
and [hidden] = 'false' union select [jcr:path], [jcr:score], * from [nt:base] as a where ischildnode(a, '/content/dam/images/webimages/p1-ko')
and [hidden] is null order by [jcr:created] desc /* xpath: /jcr:root/content/dam/images/webimages/p1-ko/*[((@hidden = 'false' or not(@hidden)))]
order by @jcr:created descending */, path=/content/dam/images/webimages/p1-ko/*, property=[hidden=[is null]]); consider creating an index or changing the query

 

 

View Entire Topic

Avatar

Avatar
Give Back 5
Level 3
SameerBhalerao
Level 3

Likes

25 likes

Total Posts

25 posts

Correct Reply

13 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Give Back 5
Level 3
SameerBhalerao
Level 3

Likes

25 likes

Total Posts

25 posts

Correct Reply

13 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
SameerBhalerao
Level 3

01-06-2020

Hi there,

 

If you have more than 1000 items in a bucket, you will get it even if you create an index for the only path.

 

Reason is that when query is fired, it tries to use an index and get the result from the index but if you have more than 1000 items returned from the query which in fact uses index also, you will get this warning. So this problem is about the result set iteration and its size.

 

You can not do away from this warning apart from making sure you do not have more than 1000 nodes underneath.