Would you mind a sentence of explanation on what the problem was and what this patch is intended to achieve ? (As I don't see any tests there)
On Fri, Aug 14, 2009 at 9:54 AM, Stefan Steinegger < [email protected]> wrote: > > We found the problem, I posted a patch: > > http://nhjira.koah.net/browse/NH-1931 > > On 7 Aug., 10:15, Stefan Steinegger <[email protected]> > wrote: > > Currently we are doing long running tests on our system. After a > > couple or hours, the system suddenly hangs on a call to the NH > > session. I don't know if this is a NH problem, application problem or > > SQL server problem. > > > > Code looks like this: > > > > logger.Debug("A"); > > session.Flush() > > logger.Debug("B") > > > > query = session.CreateQuery("select id from X where BusinessId > > = :businessId"); > > query.SetGuid("businessId", businessId); > > > > logger.Debug("C") > > result = query.UniqueResult<long>(); > > logger.Debug("D") > > > > Against any expectation, the application hangs between log message B > > and C. > > > > - It takes a few minutes until 15 minutes (!) until the application > > proceeds. > > - Calls are coming in every 4 sec. (during the whole long running > > test) > > - After the first call hangs at this point, all subsequent calls are > > waiting at the same point, as if there was a lock. > > - CPU is on 50-60% during this time. The CPU is used by our server, > > not the DB. > > - Normally, CPU is very low during the test. > > - No other threads are doing anything special, except of the new calls > > coming in. > > - It hangs always on this point, never somewhere else. > > > > I can't explain this at all. Any help to find this problem is highly > > appreciated. > > > -- Sidar Ok http://www.sidarok.com http://www.twitter.com/sidarok --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "nhusers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/nhusers?hl=en -~----------~----~----~----~------~----~------~--~---
