How can we help you today? How can we help you today?

SSMS now crashes regularly after latest SQL Prompt update

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?
OffByOne
0

Comments

17 comments

  • 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.
    janna_kelly
    0
  • 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.
    jsun26
    0
  • 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)

    Dougal
    0
  • gigglestick90
    Also happening here on my end. Updated this morning to the latest SQL Prompt and is now crashing constantly.
    gigglestick90
    0
  • Grimfellow
    Same here as well, updated this morning
    Grimfellow
    0
  • gigglestick90
    Is there a way to revert to a previous version?
    gigglestick90
    0
  • 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.
    Higgins
    0
  • 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 ?
    AlainGui
    0
  • 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
    ostandage
    0
  • 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.
    Higgins
    0
  • NTXRedcard
    Same thing here
    NTXRedcard
    0
  • Higgins
    I submitted a Red-Gate support request and attached my log files to it.
    Higgins
    0
  • DougRiga
    More of the same here.  Thank you so much for providing the link to the last version.
    DougRiga
    0
  • 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
    ostandage
    0
  • gigglestick90
    Thank you! It looks like this update solved the issue!
    gigglestick90
    0
  • 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.
    pczarn2
    0
  • 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
    Victoria W
    0

Add comment

Please sign in to leave a comment.