Question

Photo of Aaron Hackett

0

SQL Primary File Group Full

So I’m getting the primary full error. Mac growth is set to 1000 MB, but currently it’s only atv400MB.  So I’m a bit confused.  Bellow is the error message.  Any help is appreciated. 





An error occurred on the Rock RMS site on page: 

https://admin.thehousechurch.tv:443/page/3?returnurl=%252f

DbUpdateException in EntityFramework


Message

An error occurred while updating the entries. See the inner exception for details.


Stack Trace

at System.Data.Entity.Internal.InternalContext.SaveChanges()

at Rock.Data.DbContext.SaveChanges(Boolean disablePrePostProcessing)

at Rock.Model.UserLoginService.UpdateLastLogin(String userName)

at RockWeb.Blocks.Security.Login.LoginUser(String userName, String returnUrl, Boolean rememberMe) in c:\inetpub\wwwroot\Blocks\Security\Login.ascx.cs:line 447

at RockWeb.Blocks.Security.Login.CheckUser(UserLogin userLogin, String returnUrl, Boolean rememberMe) in c:\inetpub\wwwroot\Blocks\Security\Login.ascx.cs:line 306

at RockWeb.Blocks.Security.Login.btnLogin_Click(Object sender, EventArgs e) in c:\inetpub\wwwroot\Blocks\Security\Login.ascx.cs:line 258

at System.Web.UI.WebControls.LinkButton.OnClick(EventArgs e)

at System.Web.UI.WebControls.LinkButton.RaisePostBackEvent(String eventArgument)

at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)


-UpdateException in EntityFramework


Message

An error occurred while updating the entries. See the inner exception for details.


Stack Trace

at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()

at System.Data.Entity.Core.Objects.ObjectContext.ExecuteInTransaction[T](Func`1 func, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction, Boolean releaseConnectionOnSuccess)

at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesToStore(SaveOptions options, IDbExecutionStrategy executionStrategy, Boolean startLocalTransaction)

at System.Data.Entity.SqlServer.DefaultSqlExecutionStrategy.Execute[TResult](Func`1 operation)

at System.Data.Entity.Core.Objects.ObjectContext.SaveChangesInternal(SaveOptions options, Boolean executeInExistingTransaction)

at System.Data.Entity.Internal.InternalContext.SaveChanges()


--SqlException in .Net SqlClient Data Provider


Message

Could not allocate space for object 'dbo.History'.'PK_dbo.History' in database 'rock' 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.


Stack Trace

at System.Data.SqlClient.SqlConnection.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.TryConsumeMetaData()

at System.Data.SqlClient.SqlDataReader.get_MetaData()

at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption)

at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)

at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)

at System.Data.Entity.Infrastructure.Interception.InternalDispatcher`1.Dispatch[TTarget,TInterceptionContext,TResult](TTarget target, Func`3 operation, TInterceptionContext interceptionContext, Action`3 executing, Action`3 executed)

at System.Data.Entity.Infrastructure.Interception.DbCommandDispatcher.Reader(DbCommand command, DbCommandInterceptionContext interceptionContext)

at System.Data.Entity.Core.Mapping.Update.Internal.DynamicUpdateCommand.Execute(Dictionary`2 identifierValues, List`1 generatedValues)

at System.Data.Entity.Core.Mapping.Update.Internal.UpdateTranslator.Update()



  • Photo of Aaron Hackett

    0

    So, the issues was the database, PRIMARY File Group had a max file size of 1000 MB. And it had reached that limit. Once I increased that everything started working again. 

    However, I have instead created an dedicated SQL Server in Azure. Obviously better I/O, but also this will allow me to monitor the Database much easier via the Azure Dashboard. 

    Hope this helps someone else in the future with a similar problem.  

  • Photo of Daniel Hazelbaker

    0

    The error seems to indicate more that your disk is out of space so it can't grow the file any more.