Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

How to investigate/trap crash? #161

Closed
jungle-boogie opened this issue Jul 4, 2024 · 10 comments
Closed

How to investigate/trap crash? #161

jungle-boogie opened this issue Jul 4, 2024 · 10 comments

Comments

@jungle-boogie
Copy link

Hi,

I had a crash earlier, maybe from a poorly written sql statement, which caused the app to crash.
This was logged in Windows event viewer, but I don't know if it will be much use to you.
How can we start sqlite-gui with additional logging to trap these kinds of crashes?

Faulting application name: sqlite-gui.exe, version: 1.9.0.0, time stamp: 0x65e9931b
Faulting module name: ntdll.dll, version: 10.0.19041.4522, time stamp: 0x8a1bb6f3
Exception code: 0xc0000374
Fault offset: 0x00000000000ff439
Faulting process id: 0x41b4
Faulting application start time: 0x01dace620d524c57
Faulting application path: C:\Users\little-brother\Downloads\sqlite-gui-1.9.0-x64\sqlite-gui.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: cf23b284-5a53-45ca-9b1a-6658d27e11f7
Faulting package full name: 
Faulting package-relative application ID: 

Thanks!

@little-brother
Copy link
Owner

Hmm, at this time the app doesn't have any crush analysis feature. I need a time to learn how to implement it.
Thanks for the report.

little-brother added a commit that referenced this issue Jul 22, 2024
* Plugin system to preview values e.g. json, XML or even pdf
* Improve Edit data dialog inc. issue #155
* Fix issues #159, #160, #161
* Up SQLite to 3.46.0
@little-brother
Copy link
Owner

I made a small app for it. You can enable it in settings (logger.exe will be installed and run automatically). I hope it will help to catch the cause of the crush.

@jungle-boogie
Copy link
Author

I'm using latest sqlite-gui and got a crash. Where do I find any logging?

Faulting application name: sqlite-gui.exe, version: 1.9.1.0, time stamp: 0x669e6bda
Faulting module name: ntdll.dll, version: 10.0.19041.4522, time stamp: 0x8a1bb6f3
Exception code: 0xc0000374
Fault offset: 0x00000000000ff439
Faulting process id: 0x2f54
Faulting application start time: 0x01dadd5056fd85b3
Faulting application path: C:\Users\little-brother\Downloads\sqlite-gui-1.9.1-x64\sqlite-gui.exe
Faulting module path: C:\Windows\SYSTEM32\ntdll.dll
Report Id: 45c6f86b-6222-4572-8d13-06058d39003a
Faulting package full name: 
Faulting package-relative application ID: 

@little-brother
Copy link
Owner

In the app folder logger.txt if logger.exe was enabled.

@jungle-boogie
Copy link
Author

The file does not exist.

@little-brother
Copy link
Owner

:( So the cause of the crush is not related to query re-hightlighting. Only few things can be catched by the logger.
Could you provide more information about a state before crushing? How many tabs were open? Do you load any special extensions? Maybe you open a table or view/filter a resultset? Anything will be usefull.

@jungle-boogie
Copy link
Author

select * from committee_summary_2024_tmp with the attached db.

test.zip

i also that after the crash, the windows clipboard is cleared out.

@jungle-boogie
Copy link
Author

No custom functions and just a single tab opened.

@little-brother
Copy link
Owner

Yeah, it's a buffer overflow. Your table has many columns and somewhere a buffer is not enought for all of them.
Thanks for the report.

little-brother added a commit that referenced this issue Aug 30, 2024
* Add move/zoom to a chart
* Filter in a navigation tree by Ctrl   F
* Plugins to modify values in a resultset column
* Fix issues #161, #163, #164
@little-brother
Copy link
Owner

Fixed.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants