Re: Could use some thoughts on a problem with a query in production

2017-06-06 Thread Bergquist, Brett
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

Re: Could use some thoughts on a problem with a query in production

2017-06-06 Thread Bryan Pendleton
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

RE: Could use some thoughts on a problem with a query in production

2017-06-06 Thread Bergquist, Brett
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