Starting early morning we have been facing issues with the octopus login and then with deploy failing followed with the below message
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.