Hg Lab server doesn't start anymore

Sebastien RATTIER's Avatar

Sebastien RATTIER

15 Feb, 2019 02:11 PM

HgLab Error
 

HgLab Error

There's something wrong under the hood.

NHibernate.Exceptions.GenericADOException: could not execute query
[ SELECT TOP (@p0) this_.ID as ID29_0_, this_.PublishedAt as Publishe2_29_0_, this_.Activity as Activity29_0_, this_.ProjectID as ProjectID29_0_, this_.ActorType as ActorType29_0_, this_.ActorID as ActorID29_0_, this_.ActionObjectType as ActionOb7_29_0_, this_.ActionObjectID as ActionOb8_29_0_, this_.TargetType as TargetType29_0_, this_.TargetID as TargetID29_0_ FROM [ActivityItem] this_ WHERE exists (SELECT this_0_.ID as y0_ FROM Project this_0_ WHERE (this_0_.ID = this_.ProjectID and this_0_.SettingsEnablePublicAccess = @p1)) ORDER BY this_.PublishedAt desc ]
  Name:cp0 - Value:True
[SQL: SELECT TOP (@p0) this_.ID as ID29_0_, this_.PublishedAt as Publishe2_29_0_, this_.Activity as Activity29_0_, this_.ProjectID as ProjectID29_0_, this_.ActorType as ActorType29_0_, this_.ActorID as ActorID29_0_, this_.ActionObjectType as ActionOb7_29_0_, this_.ActionObjectID as ActionOb8_29_0_, this_.TargetType as TargetType29_0_, this_.TargetID as TargetID29_0_ FROM [ActivityItem] this_ WHERE exists (SELECT this_0_.ID as y0_ FROM Project this_0_ WHERE (this_0_.ID = this_.ProjectID and this_0_.SettingsEnablePublicAccess = @p1)) ORDER BY this_.PublishedAt desc] ---> System.Data.SqlClient.SqlException: Could not allocate space for object 'dbo.SORT temporary run storage: 140737488945152' in database 'tempdb' because the 'PRIMARY' filegroup is full. Create disk space by deleting unneeded files, dropping objects in the filegroup, adding additional files to the filegroup, or setting autogrowth on for existing files in the filegroup.
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryHasMoreRows(Boolean& moreRows)
   at System.Data.SqlClient.SqlDataReader.TryReadInternal(Boolean setTimeout, Boolean& more)
   at System.Data.SqlClient.SqlDataReader.Read()
   at NHibernate.Driver.NHybridDataReader.Read() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Driver\NHybridDataReader.cs:line 116
   at NHibernate.Loader.Loader.DoQuery(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 468
   at NHibernate.Loader.Loader.DoQueryAndInitializeNonLazyCollections(ISessionImplementor session, QueryParameters queryParameters, Boolean returnProxies) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 246
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1590
   --- End of inner exception stack trace ---
   at NHibernate.Loader.Loader.DoList(ISessionImplementor session, QueryParameters queryParameters) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1597
   at NHibernate.Loader.Loader.ListIgnoreQueryCache(ISessionImplementor session, QueryParameters queryParameters) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1497
   at NHibernate.Loader.Loader.List(ISessionImplementor session, QueryParameters queryParameters, ISet`1 querySpaces, IType[] resultTypes) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Loader\Loader.cs:line 1487
   at NHibernate.Impl.SessionImpl.List(CriteriaImpl criteria, IList results) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\SessionImpl.cs:line 1955
   at NHibernate.Impl.CriteriaImpl.List(IList results) in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\CriteriaImpl.cs:line 265
   at NHibernate.Impl.CriteriaImpl.List[T]() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Impl\CriteriaImpl.cs:line 276
   at NHibernate.Criterion.QueryOver`1.List() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Criterion\QueryOver.cs:line 67
   at NHibernate.Criterion.QueryOver`1.NHibernate.IQueryOver<TRoot>.List() in d:\CSharp\NH\NH\nhibernate\src\NHibernate\Criterion\QueryOver.cs:line 214
   at HgLab.Areas.Dashboard.Controllers.DashboardController.Dashboard() in d:\projects\hglab\src\HgLab\Areas\Dashboard\Controllers\DashboardController.cs:line 66
   at lambda_method(Closure , ControllerBase , Object[] )
   at System.Web.Mvc.ActionMethodDispatcher.Execute(ControllerBase controller, Object[] parameters)
   at System.Web.Mvc.ReflectedActionDescriptor.Execute(ControllerContext controllerContext, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethod(ControllerContext controllerContext, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<InvokeActionMethodWithFilters>b__12()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodFilter(IActionFilter filter, ActionExecutingContext preContext, Func`1 continuation)
   at System.Web.Mvc.ControllerActionInvoker.<>c__DisplayClass15.<>c__DisplayClass17.<InvokeActionMethodWithFilters>b__14()
   at System.Web.Mvc.ControllerActionInvoker.InvokeActionMethodWithFilters(ControllerContext controllerContext, IList`1 filters, ActionDescriptor actionDescriptor, IDictionary`2 parameters)
   at System.Web.Mvc.ControllerActionInvoker.InvokeAction(ControllerContext controllerContext, String actionName)
   at System.Web.Mvc.Controller.ExecuteCore()
   at System.Web.Mvc.ControllerBase.Execute(RequestContext requestContext)
   at HgLab.Core.Framework.Web.HgLabControllerBase.Execute(RequestContext requestContext) in d:\projects\hglab\src\HgLab.Core\Framework\Web\HgLabControllerBase.cs:line 100
   at System.Web.Mvc.ControllerBase.System.Web.Mvc.IController.Execute(RequestContext requestContext)
   at System.Web.Mvc.MvcHandler.<>c__DisplayClass6.<>c__DisplayClassb.<BeginProcessRequest>b__5()
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass1.<MakeVoidDelegate>b__0()
   at System.Web.Mvc.Async.AsyncResultWrapper.<>c__DisplayClass8`1.<BeginSynchronous>b__7(IAsyncResult _)
   at System.Web.Mvc.Async.AsyncResultWrapper.WrappedAsyncResult`1.End()
   at System.Web.Mvc.MvcHandler.<>c__DisplayClasse.<EndProcessRequest>b__d()
   at System.Web.Mvc.SecurityUtil.<GetCallInAppTrustThunk>b__0(Action f)
   at System.Web.Mvc.SecurityUtil.ProcessInApplicationTrust(Action action)
   at System.Web.Mvc.MvcHandler.EndProcessRequest(IAsyncResult asyncResult)
   at System.Web.Mvc.MvcHandler.System.Web.IHttpAsyncHandler.EndProcessRequest(IAsyncResult result)
   at System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   at System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   at System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
Please report this error to HgLab Support.
HgLab | Documentation | Support

  1. Support Staff 1 Posted by Anton Gogolev on 18 Feb, 2019 08:57 AM

    Anton Gogolev's Avatar

    Sebastien,

    Looks like one of the disks on your SQL Server machine is full:

    Could not allocate space for object 'dbo.SORT temporary run storage:
    140737488945152' in database 'tempdb' because the 'PRIMARY' filegroup is
    full. Create disk space by deleting unneeded files, dropping objects in the
    filegroup, adding additional files to the filegroup, or setting autogrowth
    on for existing files in the filegroup

  2. 2 Posted by Sébastien RATTI... on 18 Feb, 2019 09:20 AM

    Sébastien RATTIER's Avatar

    Hello,

    You’re right. Disk out of space. I’ve done some cleanup and the DB restarted properly.
    Thank you for coming back to me.

    Best regards

    De : Anton Gogolev <[email blocked]>
    Envoyé : lundi 18 février 2019 09:58
    À : Sébastien RATTIER <[email blocked]>
    Objet : Re: Hg Lab server doesn't start anymore [Problems #1361]

Reply to this discussion

Internal reply

Formatting help / Preview (switch to plain text) No formatting (switch to Markdown)

Attaching KB article:

»

Attached Files

You can attach files up to 10MB

If you don't have an account yet, we need to confirm you're human and not a machine trying to post spam.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac

Recent Discussions

18 Feb, 2019 09:20 AM
26 Nov, 2018 01:47 PM
16 Nov, 2018 07:51 PM
06 Nov, 2018 04:30 PM
24 Oct, 2018 07:57 AM

 

20 Jul, 2018 11:07 PM
05 Jul, 2018 10:53 AM
27 May, 2018 01:33 AM
14 May, 2018 03:38 PM
04 May, 2018 07:45 AM
28 Feb, 2018 07:08 AM