We found the problem, I posted a patch:
http://nhjira.koah.net/browse/NH-1931
On 7 Aug., 10:15, Stefan Steinegger <stefan.steineg...@bluewin.ch>
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.
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"nhusers" group.
To post to this group, send email to nhusers@googlegroups.com
To unsubscribe from this group, send email to
nhusers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/nhusers?hl=en
-~----------~----~----~----~------~----~------~--~---
