SSMS now crashes regularly after latest SQL Prompt update

OffByOne

Just installed SQL Prompt 10.11.8.27379 for SSMS 18.11.1 and SSMS now crashes regularly.  Also running Redgate SQL Search 3.5.5.2703

Is there any kind of log file I can view to see why it's crashing?

ostandage

Hi all,

It looks as though a third party dependency update has caused the crash here, we've identified the issue and just pushed out a fix for this in v10.11.9.

Please make sure you uninstall SQL Prompt 10.11.8 before installing the new update:

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.9.27382.exe

We're sorry for the inconvenience this may have caused, 

Thanks, 

Owen

janna_kelly

I'm experiencing the same. SSMS stays running for about 5 min before crashing and restarting itself. I'm not running any other Redgate products.

jsun26

FWIW, I'm experiencing the same behavior with SSMS crashing after installing version 10.11.8.27379 a few minutes ago.

I see a pair of events in my Application log (via Event Viewer) that appear be related to SSMS crashing.

Dougal

Same here. Seems to be at almost exactly 3 minute intervals. From event log:

Application: Ssms.exe
Framework Version: v4.0.30319
Description: The process was terminated due to an unhandled exception.
Exception Info: System.IO.FileNotFoundException
   at System.SpanHelpers+PerTypeValues`1[[System.Char, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]].MeasureArrayAdjustment()
   at System.SpanHelpers+PerTypeValues`1[[System.Char, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]..cctor()

Exception Info: System.TypeInitializationException
   at System.SpanHelpers.IsReferenceOrContainsReferences[[System.Char, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]()
   at Microsoft.Extensions.Logging.LogValuesFormatter..ctor(System.String)
   at Microsoft.Extensions.Logging.LoggerMessage.CreateLogValuesFormatter(System.String, Int32)
   at Microsoft.Extensions.Logging.LoggerMessage.Define[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](Microsoft.Extensions.Logging.LogLevel, Microsoft.Extensions.Logging.EventId, System.String, Microsoft.Extensions.Logging.LogDefineOptions)
   at Microsoft.Extensions.Logging.LoggerMessage.Define[[System.Int32, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](Microsoft.Extensions.Logging.LogLevel, Microsoft.Extensions.Logging.EventId, System.String)
   at Microsoft.Extensions.Http.DefaultHttpClientFactory+Log..cctor()

Exception Info: System.TypeInitializationException
   at Microsoft.Extensions.Http.DefaultHttpClientFactory+Log.HandlerExpired(Microsoft.Extensions.Logging.ILogger, System.String, System.TimeSpan)
   at Microsoft.Extensions.Http.DefaultHttpClientFactory.ExpiryTimer_Tick(System.Object)
   at Microsoft.Extensions.Http.ActiveHandlerTrackingEntry.Timer_Tick()
   at Microsoft.Extensions.Http.ActiveHandlerTrackingEntry+<>c.<.cctor>b__22_0(System.Object)
   at System.Threading.TimerQueueTimer.CallCallback()
   at System.Threading.TimerQueueTimer.Fire()
   at System.Threading.TimerQueue.FireNextTimers()
   at System.Threading.TimerQueue.AppDomainTimerCallback(Int32)

gigglestick90

Also happening here on my end. Updated this morning to the latest SQL Prompt and is now crashing constantly.

Grimfellow

Same here as well, updated this morning

gigglestick90

Is there a way to revert to a previous version?

Higgins

I too am experiencing SSMS restarting itself after upgrading to 10.11.8. SSMS isn't open long enough for me to even load a SQL script file before it dies and then re-opens itself. I too would like a download link for 10.11.7 or earlier, at least that was stable.

AlainGui

Same situation here after updating to version 10.11.8.27379, is there a way to revert to a previous version without uninstalling the current version and installing an older version ?

ostandage

Hi, 

We're looking into this, here's a link to the previous version if you'd like to downgrade: 

https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.11.7.27287.exe

Thanks,

Owen

Higgins

@ostandage I was able to have SSMS up long enough to enable enhanced logging on SQL Prompt and have a zip of log files from today if you would find them useful. Let me know where I can upload them if you'd like them.

NTXRedcard

Same thing here

Higgins

I submitted a Red-Gate support request and attached my log files to it.

DougRiga

More of the same here.  Thank you so much for providing the link to the last version.

gigglestick90

Thank you! It looks like this update solved the issue!

pczarn2

I started getting the same errors last week after I upgraded to version 10.12.6. Clicking Tab History crashes SQL Prompt. I uninstalled and reverted back to 10.11.9 and it works now! Shipping 10.12.6 for now. 

Victoria W

Hi all

Thank you for your patience while we worked on this issue.
 
The development team has released a fix which you can download here: https://download.red-gate.com/checkforupdates/SQLPrompt/SQLPrompt_10.13.0.31319.exe