Hello, I've got a situation where for some users, NHibernate is consistently locking or stalling or something in the middle of issuing select statements:
2010-09-25 16:17:29,161 [8] INFO NHibernate.Loader.Loader - SELECT applicant0_.Id as Id15_1_, applicant0_.FirstName as FirstName15_1_, applicant0_.MiddleName as MiddleName15_1_, applicant0_.LastName as LastName15_1_ FROM Applicant applicant0_ left outer join Application applicatio1_ on applicant0_.Id=applicatio1_.Id WHERE applicant0_.Id=@p0
2010-09-25 16:19:20,927 [5] INFO NHibernate.Cfg.Environment - NHibernate 2.1.2.4000 (2.1.2.4000)
The really weird part is that it's for users after a certain point in the database. All users before id 500.. not problem. All users, including brand new ones, after 500 - no workie.
I'm completely stumped and not even sure where to begin.
Anyone have any thoughts on what could be happening or how i can begin to diagnose this further?
thanks, Orlando