Starting early morning we have been facing issues with the octopus login and then with deploy failing followed with the below message Server status
All Octopus Server nodes in this cluster are draining tasks.
I get the below error message when trying to access the configuration tab
“Exception occurred while executing a reader for SELECT MAX([DataVersion]) AS [Latest], MIN_ACTIVE_ROWVERSION() as [MinActive], COUNT_BIG(*) AS [Count] FROM dbo.[DeploymentEnvironment] WHERE SpaceId = @spaceId SELECT [DataVersion] FROM dbo.[DeploymentEnvironment] WHERE SpaceId = @spaceId AND [DataVersion] >= MIN_ACTIVE_ROWVERSION() ORDER BY [DataVersion] desc
SQL Error -2 - Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.
The wait operation timed out”
We are using Azure SQL Database and though it had a downtime early in the morning, the status of the database is now available but we still see issues with octopus.
Thanks for quick response !
And about the issue, it seemed to be because of the Azure outage of database in the region and now octopus deploy is back up again after the issue at Azure is resolved.
But however, i did go through the knowledge base article you shared before creating this issue and we have just the one leader node here which was drained out so couldn’t do anything that the article suggested.
Will be a good to know in case it happens sans Azure issue