phoensvx
  •  phoensvx
  • 61.4% (Friendly)
  • YAF Forumling Topic Starter
2009-01-23T11:55:44Z
Hello.
I've been having an odd problem recently where I end up building up lots of connections to the YAF database (seemingly even when there aren't more than on or two users accessing it). It takes about a day to go from one connection to over a hundred (and all users are the same) and it seriously impacts the performance of the server. To get it to work again, I have to kill all the connections to the database (by setting mode to single_user and then back to multi_user) and restart the application pool - but then the next day it's back to the same thing. This seemed to happen out of the blue and I can't figure it out. Is there some reason YAF would be opening so many connections and not closing them?
Sponsor
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2009-01-23T12:18:22Z
Which version of YAF are you using? Also, realize ASP.NET handles database pooling. You can tell it to close connections quicker by modifying the timeout settings in the connection string.
phoensvx
  •  phoensvx
  • 61.4% (Friendly)
  • YAF Forumling Topic Starter
2009-01-23T12:38:12Z
Jaben wrote:

Which version of YAF are you using? Also, realize ASP.NET handles database pooling. You can tell it to close connections quicker by modifying the timeout settings in the connection string.



It's version "1.9.3.3 alpha". I can indeed change the connection lifetime setting in the connection string, but there's still a connection leak somewhere. I figure that there must be an exception occurring somewhere before the connection is closed, but I'm not sure how to find it.
phoensvx
  •  phoensvx
  • 61.4% (Friendly)
  • YAF Forumling Topic Starter
2009-01-24T09:42:08Z
Well yesterday I set the connection lifetime to a shorter number, but it didn't seem to work. This morning, I've got 51 connections to the YAF database even though maybe two users have actually used the forum since the last time I killed the connections.
phoensvx
  •  phoensvx
  • 61.4% (Friendly)
  • YAF Forumling Topic Starter
2009-01-28T12:23:07Z
phoensvx wrote:

Well yesterday I set the connection lifetime to a shorter number, but it didn't seem to work. This morning, I've got 51 connections to the YAF database even though maybe two users have actually used the forum since the last time I killed the connections.



This is still going on. I've set the Connection Lifetime and Connect Timeout to very low numbers but it doesn't seem to make a difference. I'm seeing >100 connections after only a few hours and my server slows to a grind.. This is even with nobody using the forum. I don't understand it.. out of dozens of databases on this server the YAF database is the only one with this problem.
Jaben
  •  Jaben
  • 100% (Exalted)
  • YAF Developer
2009-01-28T15:43:34Z
v1.9.3.3 ALPHA is old... could you upgrade to the latest version: v1.9.3 RC2 and see if the problem persists?

About Us

The YAF.NET is an open source .NET forum project. YAF.NET is supported by an team of international developers who are build community by building community software.

Powered by Resharper Donate with PayPal button

Project Twitter Updates

Copyright © YetAnotherForum.NET & Ingo Herbote. All rights reserved