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 [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
-~----------~----~----~----~------~----~------~--~---
