marklogic - How to troubleshoot XDMP-RANGEINDEX error?

Question

We are running reindex on one of our database which is 400 GB approx. and we are seeing below debug log entries :-

2021-01-24 16:13:55.705 Debug: IndexerEnv::putRangeIndex: XDMP-RANGEINDEX: Range index error: double "": XDMP-LEXVAL: Invalid lexical value ""
2021-01-24 16:13:55.715 Debug: IndexerEnv::putRangeIndex: XDMP-RANGEINDEX: Range index error: double "": XDMP-LEXVAL: Invalid lexical value ""

It looks like one of the index is not having proper scalar type set or element in document is having invalid values? How can we troubleshoot this issue ? Any suggestions

question from:https://stackoverflow.com/questions/65881529/how-to-troubleshoot-xdmp-rangeindex-error

Answer 1

What version of MarkLogic are you running? A quick test with MarkLogic 10.0-5 show a uri in the error message:

2021-01-25 09:36:01.636 Debug: IndexerEnv::putRangeIndex: XDMP-RANGEINDEX: Range index error: int fn:doc("/test/doc1.xml")/root/foo: XDMP-LEXVAL: Invalid lexical value "bar"

Without that, you will need to check which range indexes of type double you have in place, and try if XPath can show you which documents are troublesome. Something like:

subsequence(collection()[//path/to/double = ''], 1, 10) ! xdmp:node-uri(.)

Don't grab them all this way, but grabbing first 10 should be doable. Might give you an idea where to look.

HTH!