Unable to clean database

[Anil]

As part of feed cleanup, i have deleted nuget packages manually from file server and executed 'FeedCleanup'. FeedCleanup failed with below error:

ERROR: Error running feed package consistency check: System.Data.SqlClient.SqlException (0x80131904): Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning()
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlDataReader.ConsumeMetaData()
at System.Data.SqlClient.SqlDataReader.get_MetaData()
at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async)
at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
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.SqlClient.SqlCommand.ExecuteReader()
at Inedo.Data.SqlServerDataFactory.ExecuteDataSet(String storedProcName, String[] tableNames, IList`1 parameters)
at Inedo.Data.WrappedStoredProcedure.ExecuteDataTable()
at Inedo.ProGet.ScheduledTasks.Feed.NuGetPackageIndex.RemoveRemaining()
at Inedo.ProGet.Extensibility.PackageStores.DefaultNuGetPackageStore.Clean(IPackageIndex packageIndex)
at Inedo.ProGet.ScheduledTasks.Feed.NuGetFeedCleanupTask.PerformConsistencyCheck()

Now the database was full and i am getting below error while pushing NuGet packages:

Failed to process request. 'There was an error processing the request: 1105172NuGetPackages_CreateOrUpdatePackage82`Could not allocate space for object 'dbo.NuGetPackages'.'IX__Packages__Clustered' in database 'Nuget' 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.'.

Product: ProGet
Version: 3.8.6

[Alana]

According to the error message:

Could not allocate space for object 'dbo.NuGetPackages'.'IX__Packages__Clustered' in database 'Nuget' 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.

This means that whatever server your ProGet database is hosted on (which may be different than your ProGet web server) has run out of disk space, or the database was restricted in size by your dba, etc. You will need to resolve that outside of ProGet.

[Anil]

Thanks for the reply Alana, according to me around 70GB of records needs to be deleted from database. Triggering 'FeedCleanup' will not update database??

[Alana]

The feed clean-up writes logs to the database before starting, so if you have no space left on disk, then you can't start a clean-up job.