Welcome to the Inedo Forums! Check out the Forums Guide for help getting started.
If you are experiencing any issues with the forum software, please visit the Contact Form on our website and let us know!
Unable to clean database
-
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: 1105
172NuGetPackages_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 -
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.
-
Thanks for the reply Alana, according to me around 70GB of records needs to be deleted from database. Triggering 'FeedCleanup' will not update database??
-
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.
Hello! It looks like you're interested in this conversation, but you don't have an account yet.
Getting fed up of having to scroll through the same posts each visit? When you register for an account, you'll always come back to exactly where you were before, and choose to be notified of new replies (either via email, or push notification). You'll also be able to save bookmarks and upvote posts to show your appreciation to other community members.
With your input, this post could be even better 💗
Register Login