Re: Index causes query to break

Liz,=20

What Xindice version do you use and what is the value type that you used =
for creating the index?=20

Natalia

On Jun 17, 2010, at 4:12 PM, Liz Glasser wrote:

> Hopefully this won't be too hard to follow. Please let me know if I =
need to clarify something.
>=20
> 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).
>=20
> I have had the LizsNode data around for months, but the LizNodeDesc =
are all new. I have added an index defined as "*@ID" recently.
>=20
> With the index defined, when use the xpath query =
"/DatabaseRecord[//tns:LizsNode[@ID=3D'1234']]" the node is returned =
correctly. But when I use the query =
"/DatabaseRecord[//LizsNodeDesc[@ID=3D'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.
>=20
> If I remove the index all queries return correctly, but its way too =
slow.
>=20
> 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.
>=20
> Any ideas what is causing this? I have confirmed the issue by querying =
via commandline and via Java code.
>=20
> Liz