Thanks Bryan. I am looking at all things :) The fact that it is not
reproducible with a copy of the database is a hinderance but also can indicate
something external.
The interesting thing is that the same query with the same parameters was run
40 times over about an 8 hour period with
Hi Brett?
What's the underlying storage system like? In particular, is it an SSD
storage system? Is there any chance that you happened to hit a spot
in time where there was some non-Derby event which was causing the
storage system to misbehave?
I understand that certain SSD implementations, and
Thanks Katherine, I will look into that.
It is interesting that this one query had the issue repeatedly over about a 12
hour period whereas others querying performing the same query with different
time periods during the same time did not experience any issue. One would
think if the