Hi Team,
We are facing one issue, Octopus service was stuck and all build got failed. Once we restart the octopus service everything working fine.In octopus logs we are getting bellow error.
ERROR An unexpected error occurred while attempting to retrieve and execute a task: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
System.InvalidOperationException: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached.
at System.Data.ProviderBase.DbConnectionFactory.TryGetConnection(DbConnection owningConnection, TaskCompletionSource1 retry, DbConnectionOptions userOptions, DbConnectionInternal oldConnection, DbConnectionInternal& connection) at System.Data.ProviderBase.DbConnectionInternal.TryOpenConnectionInternal(DbConnection outerConnection, DbConnectionFactory connectionFactory, TaskCompletionSource
1 retry, DbConnectionOptions userOptions)
at System.Data.SqlClient.SqlConnection.TryOpenInner(TaskCompletionSource1 retry) at System.Data.SqlClient.SqlConnection.TryOpen(TaskCompletionSource
1 retry)
at System.Data.SqlClient.SqlConnection.Open()
at Octopus.Shared.TransientFaultHandling.RetryPolicy.<>c__DisplayClass26_0.b__0() in Y:\work\refs\tags\3.3.2\source\Octopus.Shared\TransientFaultHandling\RetryPolicy.cs:line 172
at Octopus.Shared.TransientFaultHandling.RetryPolicy.ExecuteAction[TResult](Func`1 func) in Y:\work\refs\tags\3.3.2\source\Octopus.Shared\TransientFaultHandling\RetryPolicy.cs:line 213
at Octopus.Core.RelationalStorage.RelationalTransaction…ctor(String connectionString, RetriableOperation retriableOperation, IsolationLevel isolationLevel, ISqlCommandFactory sqlCommandFactory, JsonSerializerSettings jsonSerializerSettings, RelationalMappings mappings, IKeyAllocator keyAllocator) in Y:\work\refs\tags\3.3.2\source\Octopus.Core\RelationalStorage\RelationalTransaction.cs:line 48
at Octopus.Core.RelationalStorage.RelationalStore.BeginTransaction(RetriableOperation retriableOperation) in Y:\work\refs\tags\3.3.2\source\Octopus.Core\RelationalStorage\RelationalStore.cs:line 58
at Octopus.Server.Orchestration.TaskQueueLimiter.HasTooManyRunningTasks() in Y:\work\refs\tags\3.3.2\source\Octopus.Server\Orchestration\TaskQueueLimiter.cs:line 28
at Octopus.Server.Orchestration.TaskQueue.PollForMoreWorkOnBackgroundThread(Object state) in Y:\work\refs\tags\3.3.2\source\Octopus.Server\Orchestration\TaskQueue.cs:line 57
2017-07-27 07:23:16.4416 73 INFO Shutting down the embedded web server
Kindly help me to resolved this issue.
Thanks,
Sandeep Verma