Index causes query to break
Liz Glasser <[email protected]> Thu, 17 Jun 2010 16:12:31 -0400
| Newsgroups | gmane.text.xml.xindice.user |
|---|---|
| Message-ID | <[email protected]> |
Hopefully this won't be too hard to follow. Please let me know if I need to clarify something. I have two types of Nodes (let's call them LizsNode and LizsNodeDesc) that each have an attribute named ID. LizsNode uses a namespace (tns). I have had the LizsNode data around for months, but the LizNodeDesc are all new. I have added an index defined as "*@ID" recently. With the index defined, when use the xpath query "/DatabaseRecord[//tns:LizsNode[@ID='1234']]" the node is returned correctly. But when I use the query "/DatabaseRecord[//LizsNodeDesc[@ID='1234']]" 99.999% of the time nothing is returned. Occasionally the right result is returned. Also if I query for /DatabaseRecord[//LizsNodeDesc]" all those nodes are returned and I can see my ID is correct. If I remove the index all queries return correctly, but its way too slow. Also, I have one machine that this seemed to occur on but I deleted the entire collection and the newly created one is fine. I cannot do this to my production server however. Any ideas what is causing this? I have confirmed the issue by querying via commandline and via Java code. Liz