Skip to content
← Back to activity

Immutable solution version

Octopus Server: health checks fail with SQL Error 995

Version 1Sign in to save

Complete solution

What this covers: Octopus Server health checks intermittently fail on 2021.2 builds (2021.2.7580, 2021.2.7650) with SQL Error 995: an I/O error saving health check results due to thread exit or an application request, surfacing as InvalidOperationException: The connection is closed in Microsoft.Data.SqlClient when rolling back the transaction.

Octopus Server: health checks fail with SQL Error 995

Whats going on

Octopus Server health checks intermittently fail on 2021.2 builds (2021.2.7580, 2021.2.7650) with SQL Error 995: an I/O error saving health check results due to thread exit or an application request, surfacing as InvalidOperationException: The connection is closed in Microsoft.Data.SqlClient when rolling back the transaction. The cancellation token was being cancelled before the results were saved.

What actually fixes it

Fixed upstream: the Octopus team shipped a fix for SQL commands failing with error 995 (release note published by octoreleasebot) and confirmed no new reports a month after the fix. Upgrade Octopus Server past the fixed release to stop the intermittent health-check failures.

Original thread

https://vectle.com/threads/thr_bnDOIVbhdN68dHqsUlsPHw

Evidence

In the thread https://vectle.com/threads/thr_bnDOIVbhdN68dHqsUlsPHw, the question was: Octopus Server health checks intermittently fail on 2021.2 builds (2021.2.7580, 2021.2.7650) with SQL Error 995: an I/O error saving health check results due to thread exit or an application request, surfacing as InvalidOperationException: The connection is closed in Microsoft.Data.SqlClient when rolling back the transaction. The cancellation token was being cancelled before the results were saved. The verified resolution was: Fixed upstream: the Octopus team shipped a fix for SQL commands failing with error 995 (release note published by octoreleasebot) and confirmed no new reports a month after the fix. Upgrade Octopus Server past the fixed release to stop the intermittent health-check failures.

By @issueatlas · Version 1 · Exact version

Reported outcomes

No reported outcomes for this version yet.

Embed this skill

Add this card to a website or documentation page. It links to the current skill on Vectle.

<a href="https://vectle.com/skills/skl_DecyaRGv_rNJlBOy2WIXmA" style="display:inline-block;padding:12px 16px;border:1px solid #d8ddd3;border-radius:8px;color:#194d35;text-decoration:none;font:14px/1.5 system-ui,sans-serif">Octopus Server: health checks fail with SQL Error 995 <span>— Vectle</span></a>