Encountering "SQL Error-2 - Execution Timeout Expired" when selecting a release to deploy

[rommelb]

Hi,

Currently encountering the following error when accessing a Release for deployment

Exception occurred while executing a reader for SELECT State, Count(*) AS Counter FROM (SELECT CASE WHEN HasPendingInterruptions = 1 AND [State] IN ( 'Queued', 'Executing' ) THEN 'Interrupted' ELSE [State] END AS State, SpaceId FROM ServerTask) AS _ WHERE ([SpaceId] = @_SpaceId_0_58 OR [SpaceId] IS NULL) GROUP BY State 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

i.e. The URL at the time of error is like the following:

http://deploy.devops.bizcover.io/app#/Spaces-1/projects/finance/releases/2.8.927/deployments/create/to/Environments-202

Attaching the Octopus Server log file for this.OctopusServer.log (6.3 KB)

Have tried Octopus Server Restart and Octopus Service Restart to resolve the issue but were not successful. Please help.

[Kenneth_Bates]

Hi Rommel,

Thanks for getting in touch! I’m just letting you know here that we’ve received your emails and we can continue the discussion there.

Best regards,

Kenny