sqlnotebook icon indicating copy to clipboard operation
sqlnotebook copied to clipboard

2.0.0 Portable: Random crash - No error

Open BillyMcSkintos opened this issue 7 months ago • 5 comments

I downloaded the portable version this AM (SQLNotebook-64bit-2.0.0.zip) to use on Windows 11 and have suffered 2 crashes within an hour. No error message. The app just closed.

Crash 1: I hit enter to add a line return to my query/script Crash 2: I accidently hit (L-Click) the resize "line" between the query and the results with my mouse

Not very helpful I am afraid. Are there any logs I can provide?

BillyMcSkintos avatar Jun 09 '25 18:06 BillyMcSkintos

I'm sorry about that! Can you go to the Windows Event Viewer (Start > "Event Viewer") and see if there is a ".NET Runtime Error" at the time of the crash? If so, can you copy-paste the message? I believe that will give us a clue.

You can return to version 1.2.3 in the meantime from this download: https://github.com/brianluft/sqlnotebook/releases/tag/v1.2.3

electroly avatar Jun 09 '25 23:06 electroly

1. Log Name: Application Source: .NET Runtime Date: 6/9/2025 7:52:05 AM Event ID: 1025 Task Category: None Level: Error Keywords: Classic User: N/A Computer: JR Description: Application: SqlNotebook.exe CoreCLR Version: 9.0.525.21509 .NET Version: 9.0.5 Description: The application requested process termination through System.Environment.FailFast. Message: A callback was made on a garbage collected delegate of type 'System.Windows.Forms!System.Windows.Forms.LabelEditNativeWindow+WINEVENTPROC::Invoke'. Stack: at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.Callback(Windows.Win32.Foundation.HWND, Windows.Win32.MessageId, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.DispatchMessage(Windows.Win32.UI.WindowsAndMessaging.MSG*) at System.Windows.Forms.Application+LightThreadContext.FPushMessageLoop(Microsoft.Office.msoloop) at System.Windows.Forms.Application+LightThreadContext.RunMessageLoop(Microsoft.Office.msoloop, Boolean) at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at SqlNotebook.Program.Main()

Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name=".NET Runtime" /> <EventID Qualifiers="0">1025</EventID> <Version>0</Version> <Level>2</Level> <Task>0</Task> <Opcode>0</Opcode> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2025-06-09T14:52:05.1898569Z" /> <EventRecordID>210805</EventRecordID> <Correlation /> <Execution ProcessID="21484" ThreadID="0" /> <Channel>Application</Channel> <Computer>JR</Computer> <Security /> </System> <EventData> <Data>Application: SqlNotebook.exe CoreCLR Version: 9.0.525.21509 .NET Version: 9.0.5 Description: The application requested process termination through System.Environment.FailFast. Message: A callback was made on a garbage collected delegate of type 'System.Windows.Forms!System.Windows.Forms.LabelEditNativeWindow+WINEVENTPROC::Invoke'. Stack: at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.Callback(Windows.Win32.Foundation.HWND, Windows.Win32.MessageId, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.DispatchMessage(Windows.Win32.UI.WindowsAndMessaging.MSG*) at System.Windows.Forms.Application+LightThreadContext.FPushMessageLoop(Microsoft.Office.msoloop) at System.Windows.Forms.Application+LightThreadContext.RunMessageLoop(Microsoft.Office.msoloop, Boolean) at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at SqlNotebook.Program.Main() </Data> </EventData> </Event>

2. Log Name: Application Source: .NET Runtime Date: 6/9/2025 7:57:13 AM Event ID: 1025 Task Category: None Level: Error Keywords: Classic User: N/A Computer: JR Description: Application: SqlNotebook.exe CoreCLR Version: 9.0.525.21509 .NET Version: 9.0.5 Description: The application requested process termination through System.Environment.FailFast. Message: A callback was made on a garbage collected delegate of type 'System.Windows.Forms!System.Windows.Forms.LabelEditNativeWindow+WINEVENTPROC::Invoke'. Stack: at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WmMouseWheel(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.Callback(Windows.Win32.Foundation.HWND, Windows.Win32.MessageId, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.DispatchMessage(Windows.Win32.UI.WindowsAndMessaging.MSG*) at System.Windows.Forms.Application+LightThreadContext.FPushMessageLoop(Microsoft.Office.msoloop) at System.Windows.Forms.Application+LightThreadContext.RunMessageLoop(Microsoft.Office.msoloop, Boolean) at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at SqlNotebook.Program.Main()

Event Xml: <Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event"> <System> <Provider Name=".NET Runtime" /> <EventID Qualifiers="0">1025</EventID> <Version>0</Version> <Level>2</Level> <Task>0</Task> <Opcode>0</Opcode> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime="2025-06-09T14:57:13.5047914Z" /> <EventRecordID>210808</EventRecordID> <Correlation /> <Execution ProcessID="17492" ThreadID="0" /> <Channel>Application</Channel> <Computer>JR</Computer> <Security /> </System> <EventData> <Data>Application: SqlNotebook.exe CoreCLR Version: 9.0.525.21509 .NET Version: 9.0.5 Description: The application requested process termination through System.Environment.FailFast. Message: A callback was made on a garbage collected delegate of type 'System.Windows.Forms!System.Windows.Forms.LabelEditNativeWindow+WINEVENTPROC::Invoke'. Stack: at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.CallWindowProc(Windows.Win32.Foundation.LRESULT (Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM), Windows.Win32.Foundation.HWND, UInt32, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at System.Windows.Forms.NativeWindow.DefWndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WmMouseWheel(System.Windows.Forms.Message ByRef) at System.Windows.Forms.Control.WndProc(System.Windows.Forms.Message ByRef) at System.Windows.Forms.NativeWindow.Callback(Windows.Win32.Foundation.HWND, Windows.Win32.MessageId, Windows.Win32.Foundation.WPARAM, Windows.Win32.Foundation.LPARAM) at Windows.Win32.PInvoke.DispatchMessage(Windows.Win32.UI.WindowsAndMessaging.MSG*) at System.Windows.Forms.Application+LightThreadContext.FPushMessageLoop(Microsoft.Office.msoloop) at System.Windows.Forms.Application+LightThreadContext.RunMessageLoop(Microsoft.Office.msoloop, Boolean) at System.Windows.Forms.Application+ThreadContext.RunMessageLoopInner(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at SqlNotebook.Program.Main() </Data> </EventData> </Event>System.Windows.Forms.Application+ThreadContext.RunMessageLoop(Microsoft.Office.msoloop, System.Windows.Forms.ApplicationContext) at SqlNotebook.Program.Main()</Data> </EventData> </Event>

BillyMcSkintos avatar Jun 10 '25 12:06 BillyMcSkintos

Thank you for the logs. That helps. I found some clues online about what I might be doing wrong here.

electroly avatar Jun 10 '25 14:06 electroly

Can you please try version 1.2.3 and confirm that it works? https://github.com/brianluft/sqlnotebook/releases/tag/v1.2.3

Thank you for your patience.

electroly avatar Jun 10 '25 20:06 electroly

I did go back to 1.2.3 which I have been using for the last year/6 months?

It works just fine (perhaps the occasional crash but so rare I dont recall)

For what its worth, SQLnotebook is indispensable for me. I am sincerely looking forward to markdown support and hopefully snowflake connections.

Thank you for everything you have built and your ongoing work!

On Tue, Jun 10, 2025, 1:59 PM Brian Luft @.***> wrote:

electroly left a comment (brianluft/sqlnotebook#67) https://github.com/brianluft/sqlnotebook/issues/67#issuecomment-2960566558

Can you please try version 1.2.3 and confirm that it works? https://github.com/brianluft/sqlnotebook/releases/tag/v1.2.3

Thank you for your patience.

— Reply to this email directly, view it on GitHub https://github.com/brianluft/sqlnotebook/issues/67#issuecomment-2960566558, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAJKYCBJXXJ6FR5A7HBOLOT3C5BKHAVCNFSM6AAAAAB65STY6GVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDSNRQGU3DMNJVHA . You are receiving this because you authored the thread.Message ID: @.***>

BillyMcSkintos avatar Jun 10 '25 21:06 BillyMcSkintos