Good job Sthepen. LOL!! On Thu, Nov 4, 2010 at 10:37 AM, Lakshman <[email protected]> wrote:
> We found the problem and applied a solution for this issue. > > This problem happens only with SQL Server 2005 as the backend and it > goes away with SQL Server 2008 R2. The root cause is the new class for > transaction management (the default under NH > 2.1.x)NHibernate.Transaction.AdoNetWithDistributedTransactionFactory. > > In NH 2.0.1 the transaction management class was > NHibernate.Transaction.AdoNetTransactionFactory which hasn't caused > any problem. > > Luckily, we were able to configure this as part of the NH > configuration. We configured the transaction.factory_class property > and had set it to NHibernate.Transaction.AdoNetTransactionFactory to > resolve the issue. > > > On Oct 6, 12:44 pm, Jason Meckley <[email protected]> wrote: > > how is spring handling session management. the problem isn't 2.1.2. > > the problem is how you are managing 2.1.2. > > > > On Oct 6, 9:21 am, Lakshman <[email protected]> wrote: > > > > > > > > > Thanks Jose. We delegate the session / transaction management to > > > Spring.NET. > > > > > On Oct 5, 2:58 pm, José F. Romaniello <[email protected]> wrote: > > > > > > It seems that somehow your application is not properly disposing the > > > > connections... > > > > How do you handle sessions? > > > > > > 2010/10/5 Lakshman <[email protected]> > > > > > > > All, > > > > > > > We have been using NHibernate 2.0.0 and Spring.NET 1.2 in our WCF > web > > > > > services. > > > > > > > We recently tried to migrate to NHibernate 2.1.2 and Spring.NET > 1.3.0 > > > > > and since then started getting the following error at 20 TPS with > 100 > > > > > users using Load Runner testing. > > > > > > > “Timeout expired. The timeout period elapsed prior to obtaining a > > > > > connection from the pool. This may have occurred because all > pooled > > > > > connections were in use and max pool size was reached” > > > > > > > We mitigated that error by setting the Max Pool Size to 1000. But, > the > > > > > web service server eventually crashed at 80 TPS with 400 users ( > again > > > > > Load Runner). > > > > > > > We thought we would move back to NHibernate 2.0.1. We didn't get > any > > > > > errors or server crash with Spring.NET 1.3.0 and NHibernate 2.0.1 > at > > > > > 80 TPS with 400 users ( again Load Runner). > > > > > > > I am not sure what is going on with NH 2.1.2. Was it performance > > > > > tested at high loads? Did anyone else had similar issues? Is the > fix > > > > > available in NH 3.0? > > > > > > > Appreciate your inputs. > > > > > > > Thanks, > > > > > Lakshman > > > > > > > -- > > > > > 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]<nhusers%[email protected]> > <nhusers%[email protected]<nhusers%[email protected]> > > > > > > > . > > > > > For more options, visit this group at > > > > >http://groups.google.com/group/nhusers?hl=en.-Hidequoted text - > > > > > > - Show quoted text -- Hide quoted text - > > > > - Show quoted text - > > -- > 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]<nhusers%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/nhusers?hl=en. > > -- Fabio Maulo -- 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.
