search

alterm4nn / ChronoZoom

ChronoZoom is an interactive timeline for all of history.
http://www.chronozoom.com
159 stars 127 forks source link

ChronoZoom crashes on login or when accessing personal timeline #1355

Closed brinkmanship closed 9 years ago

brinkmanship commented 10 years ago

When logging in or when trying to access a personal timeline, the following exception occurs: [InvalidOperationException: Execution of the command requires an open and available connection. The connection's current state is broken.] System.Data.Objects.ObjectContext.EnsureConnection() +8429122 System.Data.Objects.ObjectQuery1.GetResults(Nullable1 forMergeOption) +40 System.Data.Objects.ObjectQuery1.System.Collections.Generic.IEnumerable<T>.GetEnumerator() +31 System.Linq.Enumerable.Single(IEnumerable1 source) +100 System.Data.Objects.ELinq.ObjectQueryProvider.b__3(IEnumerable1 sequence) +5 System.Data.Objects.ELinq.ObjectQueryProvider.ExecuteSingle(IEnumerable1 query, Expression queryRoot) +25 System.Data.Objects.ELinq.ObjectQueryProvider.System.Linq.IQueryProvider.Execute(Expression expression) +70 System.Data.Entity.Internal.Linq.DbQueryProvider.Execute(Expression expression) +58 System.Linq.Queryable.Any(IQueryable1 source, Expression1 predicate) +265 Chronozoom.UI.DefaultHttpHandler.IsSuperCollectionPresent(String superCollection) +442 Chronozoom.UI.DefaultHttpHandler.PageIsDynamic(Uri pageUrl, PageInformation& pageInformation) +320 Chronozoom.UI.DefaultHttpHandler.ProcessRequest(HttpContext context) +91 System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +341 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +69

JayBeavers commented 10 years ago

Investigated this. Turns out there was a failed database connection logged in the website monitoring at 1 AM 9/24/2014 (PST). No idea why this happened, it was probably a transient issue between the website and the database.

It seems the website does not recover from this error situation. From that point forward, every database call was broken. Loading of the Big History timeline was not broken as this is cached and comes from web server memory rather than the database. All other functionality that required a database lookup (editing, loading a personal timeline, etc.) was broken.

Restarting the website worked around the issue.

brinkmanship commented 10 years ago

I tried to go back in and things were sort of working, but very slow and timelines weren't showing up on the screen but edit bar was. Did a couple of refreshes and now the exception is happening again.

Sent from my Windows Phone

From: Jay Beaversmailto:notifications@github.com Sent: ý9/ý24/ý2014 9:45 AM To: alterm4nn/ChronoZoommailto:ChronoZoom@noreply.github.com Cc: Donald Brinkmanmailto:donaldbr@microsoft.com Subject: Re: [ChronoZoom] ChronoZoom crashes on login or when accessing personal timeline (#1355)

Investigated this. Turns out there was a failed database connection logged in the website monitoring at 1 AM 9/24/2014 (PST). No idea why this happened, it was probably a transient issue between the website and the database.

It seems the website does not recover from this error situation. From that point forward, every database call was broken. Loading of the Big History timeline was not broken as this is cached and comes from web server memory rather than the database. All other functionality that required a database lookup (editing, loading a personal timeline, etc.) was broken.

Restarting the website worked around the issue.

— Reply to this email directly or view it on GitHubhttps://github.com/alterm4nn/ChronoZoom/issues/1355#issuecomment-56699977.

alterm4nn commented 9 years ago

Duplicate of #1363