Disconnect Internet -> Run Query -> Heidi Crashes

[expired user #8504]'s profile image [expired user #8504] posted 9 years ago in General Permalink
Does anyone else have this problem:

If you run a query while the computer is not connected to the internet, Heidi will crash. This happens frequently for me because I am a heavy user of Heidi and the wifi can sometimes be flaky. It is especially annoying because when Heidi force closes then I lose all the queries I was working on. I've had this issue for many months maybe even over a year. I regularly install the latest Heidi updates and am running the 64-bit version. I have a Windows 8 system and top-of-the-line computer so it is not a memory or cpu issue. I am using SSH and a MySQL database (hosted with Amazon). It is very easy to reproduce (just disconnect from the internet and run a query and it will crash) so I have the bug report at the bottom.

Thanks a lot. I continue to donate to Heidi because this application is by far the best available for MySQL.



date/time : 2015-04-16, 18:09:19, 675ms
computer name : DRAGONFIRE
user name : ******
registered owner : *******@gmail.com / Hewlett-Packard
operating system : Windows 8 Tablet PC x64 build 9200
system language : English
system up time : 16 days 5 hours
program up time : 1 minute 17 seconds
processors : 8x Intel(R) Core(TM) i7-4710HQ CPU @ 2.50GHz
physical memory : 4212/16314 MB (free/total)
free disk space : (C:) 102.32 GB
display mode : 1920x1080, 32 bit
process id : $b2b0
allocated memory : 113.57 MB
largest free block : 131029.99 GB
executable : heidisql.exe
exec. date/time : 2015-02-17 01:09
version : 9.1.0.4908
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $c4aef423, $844408d7, $844408d7
exception number : 2
exception class : EAccessViolation
exception message : Access violation at address 00007FFCB74B0DC2 in module 'libmysql.dll'. Read of address 0000000000000008.

main thread ($f2f4):
7ffcb74b libmysql.dll mysql_ping
00a719df heidisql.exe dbconnection 2152 +2 TMySQLConnection.Ping
00c15fb1 heidisql.exe Main 4707 +9 TMainForm.DataGridBeforePaint
008c92a9 heidisql.exe VirtualTrees 21198 +2 TBaseVirtualTree.DoBeforePaint
008e1bca heidisql.exe VirtualTrees 31781 +5 TBaseVirtualTree.PaintTree
008d3997 heidisql.exe VirtualTrees 25419 +22 TBaseVirtualTree.Paint
006a4326 heidisql.exe Vcl.Controls TCustomControl.PaintWindow
0069b0d3 heidisql.exe Vcl.Controls TWinControl.PaintHandler
0069bf6f heidisql.exe Vcl.Controls TWinControl.WMPaint
006a42b8 heidisql.exe Vcl.Controls TCustomControl.WMPaint
008c58d1 heidisql.exe VirtualTrees 19414 +8 TBaseVirtualTree.WMPaint
0040cb1e heidisql.exe System TObject.Dispatch
00693773 heidisql.exe Vcl.Controls TControl.WndProc
0069ae3e heidisql.exe Vcl.Controls TWinControl.WndProc
008d829b heidisql.exe VirtualTrees 27144 +32 TBaseVirtualTree.WndProc
0069a07a heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da9b3 heidisql.exe System.Classes StdWndProc
7ffce857 ntdll.dll KiUserCallbackDispatcher
7ffce828 user32.dll DispatchMessageW
004ec989 heidisql.exe madExcept HandleException
004f9474 heidisql.exe madExcept InterceptAHandleExcept
0069a09e heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da9b3 heidisql.exe System.Classes StdWndProc
7ffce857 ntdll.dll KiUserCallbackDispatcher
7ffce828 user32.dll DispatchMessageW
0081328f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00813303 heidisql.exe Vcl.Forms TApplication.HandleMessage
008137ef heidisql.exe Vcl.Forms TApplication.Run
00c5a497 heidisql.exe heidisql 77 +24 initialization
7ffce6b9 KERNEL32.DLL BaseThreadInitThunk
7ffce853 ntdll.dll RtlUserThreadStart
ansgar's profile image ansgar posted 9 years ago Permalink
libmysql.dll:mysql_ping() throws the EAccessViolation in that case. It would be easy to silence that, but there would be follow up errors, most probably more crashes. The problem with a sudden connection failure is that HeidiSQL should do nothing more with libmysql, and the data or query grid is in the middle of refreshing its invalid state. Will check that.

Please login to leave a reply, or register at first.