Lost messages

Question

Lost messages

SSC Guru

Points: 64818

April 14, 2007 at 12:22 pm

I think this is an issue you really need to get under control. I have lost at least 3 messages in the last two weeks, and it really makes me a lot less likely to post here.

Since I am mostly posting here to help people, finding that I have just lost everything I wrote in the last 10 minutes is very frustrating. I usually don't bother re-writing the message, I just head off to another site that is more dependable.

I imagine the other posters have a similar experience and frustration level.

FYI: Good thing I wrote this in an editor, because the message disappeared the first time I tried to post it.

Server Error in '/' Application.
--------------------------------------------------------------------------------

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. 
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.InvalidOperationException: 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.

Source Error:

Line 27:     <tr>
Line 28:      <td>
Line 29:       <InstantForum:Messages runat="server" ID="Messages1" />
Line 30:      </td>
Line 31:     </tr>

Source File: E:\WebSites\SSC\Original\forums\messages.aspx    Line: 29

Stack Trace:

[InvalidOperationException: 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.]
   System.Data.SqlClient.SqlConnectionPoolManager.GetPooledConnection(SqlConnectionString options, Boolean& isInTransaction) +396
   System.Data.SqlClient.SqlConnection.Open() +384
   InstantASP.InstantForum.Logic.IsForumAllowedPosts(Int32 ForumID)
   messages..ctor()
   ASP.messages_ascx..ctor()
   ASP.messages_aspx.__BuildControlMessages1() in E:\WebSites\SSC\Original\forums\messages.aspx:29
   ASP.messages_aspx.__BuildControlTree(Control __ctrl) in E:\WebSites\SSC\Original\forums\messages.aspx:1
   ASP.messages_aspx.FrameworkInitialize()
   System.Web.UI.Page.ProcessRequest() +85
   System.Web.UI.Page.ProcessRequest(HttpContext context) +18
   System.Web.CallHandlerExecutionStep.System.Web.HttpApplication+IExecutionStep.Execute() +179
   System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +87

--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:1.1.4322.2379; ASP.NET Version:1.1.4322.2379

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Luke L SSC-Dedicated Points: 35547 More actions · Answer 1

Ive always had issues with this since joining this site. If you wait too long before posting back, you loose your message...

I've just gotten in the habit of writing my reply, copying it to my clipboard and previewing the message.

That way if you preview it and it is lost, you just paste what you already typed back into the window and move on...

To help us help you read this[/url]For better help with performance problems please read this[/url]

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 2

The disappearing essages is related to session timeout. I've had similar issues on other forums too. I normally just Ctrl-A, Ctrl-C before hitting post.

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Lawrence Christman SSC Journeyman Points: 82 More actions · Answer 3

ASP.NET allows you to store unique session state in the URL; no timeout problems after that.

Michael Valentine Jones SSC Guru Points: 64818 More actions · Answer 4

I am aware there are workarounds. However, this is not a problem that should not be happening.

I post at other forums where I have never seen this happen. For example, I have never seen this happen on SQLTeam, and I have posted over 3800 messages there.

Edit: Happened the first time I tried to post this message!

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

I don't think it is session problem because Asp.net session default to twenty minutes and can be increased, if the code is Asp.net 1.1 it could be serialization related.

Kind regards,
Gift Peddie

Rudyx - the Doctor SSC-Forever Points: 43695 More actions · Answer 6

We are Borg, We have adapted ...

CTRL-A, CTRL-C, CTRL-V are now automatic keystrokes when replying to any post !

RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."

Steve Jones - SSC Editor SSC Guru Points: 736578 More actions · Answer 7

It's actually a weird issue in the forum code. There's a mem leak somehwere, so we were restarting the app pool every hour. I backed that down to 4 times a day, but the code in these forums is looking for session stuff (authentication reasons) and flips when the app pool restarts.

I'm trying to figure out if there's a workaround we can put into place, though we have a new version coming in the next couple months.