Frequent crashes

Hi ansgar (& community),


HeidiSQL has easily become my favorite tool. so much that I completely abandoned the mysql CLI and phpmyadmin within a week of using it. Impressive as hell considering I've used these in a work environment for at least 5 years.

Having said that, there are a million freezes, crashes, overflows, etc.

What is the quickest way of getting these sorted?

From what I see so far, the callstack is important to you in tracking down problems, as well as a description of what was going on (queries, windows, plink, etc). What other things are useful?

I'm keen to assist in debugging due to wanting to use this on the road for many sites. Just gotta get some stability and I'll be happy. :)

I will gladly submit a treasure trove of bug reports and donate regularly if that is the encouraged thing to do. I just need to know briefly what is useful, what's not, etc, In order to deliver clean bug reports.

Currently running it on WinXP 32-bit and Win7 64-bit, and it seems I can drive Heidi straight into the ground in 20 minutes on either. :)


Hope to hear from you soon.

Running two separate queries against two separate tables on a mysql server:

date/time : 2015-04-15, 23:40:43, 594ms
computer name : ARFFEH-PC
user name : Arffeh
registered owner : Windows User
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 2 hours 13 minutes
program up time : 18 minutes 12 seconds
processors : 4x Intel(R) Core(TM)2 Quad CPU Q8300 @ 2.50GHz
physical memory : 1892/4095 MB (free/total)
free disk space : (C:) 7.79 GB
display mode : 1920x1080, 32 bit
process id : $894
allocated memory : 72.75 MB
largest free block : 1.41 GB
executable : heidisql.exe
exec. date/time : 2014-11-12 05:38
version : 9.1.0.4867
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $640a1bd7, $f260cc20, $f260cc20
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 640A1BD7 in module 'libmysql.dll'. Write of address 04BD5080.

thread $6f4 (TQueryThread):
640a1bd7 libmysql.dll
64088c20 libmysql.dll mysql_store_result
008324d8 heidisql.exe dbconnection 2222 +35 TMySQLConnection.Query
007708cf heidisql.exe helpers 2749 +37 TQueryThread.Execute
0040a13c heidisql.exe System 549 +0 ThreadWrapper
004a5ba9 heidisql.exe madExcept CallThreadProcSafe
004a5c0e heidisql.exe madExcept ThreadExceptFrame
763d3368 kernel32.dll BaseThreadInitThunk
>> created by main thread ($10d4) at:
00770672 heidisql.exe helpers 2687 +1 TQueryThread.Create

main thread ($10d4):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon

*simultaneously

Same here, this has always been a limitation for me too.

Another, Exporting to clipboard from a mysql server on XP 32-bit:


date/time : 2015-04-22, 10:10:00, 912ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 5 days 20 hours
program up time : 1 day 20 hours
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 752/3055 MB (free/total)
free disk space : (C:) 2.24 GB
display mode : 1280x1024, 32 bit
process id : $1500
allocated memory : 29.22 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2014-11-12 05:38
version : 9.1.0.4867
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $7a3bca94, $fc6f4655, $fc6f4655
exception number : 1
exception class : ERegistryException
exception message : Failed to set data for 'GridExportOutputCopy'.

main thread ($1564):
0057bb6b heidisql.exe System.Win.Registry TRegistry.PutData
0057b90c heidisql.exe System.Win.Registry TRegistry.WriteInteger
0057b947 heidisql.exe System.Win.Registry TRegistry.WriteBool
00776997 heidisql.exe helpers 3612 +23 TAppSettings.Write
00776bf1 heidisql.exe helpers 3641 +1 TAppSettings.WriteBool
008f04de heidisql.exe exportgrid 129 +3 TfrmExportGrid.FormDestroy
0067a835 heidisql.exe Vcl.Forms TCustomForm.DoDestroy
0067a629 heidisql.exe Vcl.Forms TCustomForm.BeforeDestruction
0076467b heidisql.exe gnugettext 3863 +14 THookedObjects.BeforeDestructionHook
00408b91 heidisql.exe System 549 +0 @BeforeDestruction
0067a63a heidisql.exe Vcl.Forms TCustomForm.Destroy
004084b0 heidisql.exe System 549 +0 TObject.Free
0067fc58 heidisql.exe Vcl.Forms TCustomForm.CMRelease
005affb1 heidisql.exe Vcl.Controls TControl.WndProc
00683acc heidisql.exe Vcl.Forms TApplication.ModalFinished
00680636 heidisql.exe Vcl.Forms TCustomForm.ShowModal
0093db91 heidisql.exe Main 2849 +4 TMainForm.actExportDataExecute
0053a8ef heidisql.exe System.Classes TBasicAction.Execute
0053a78f heidisql.exe System.Classes TBasicActionLink.Execute
0066b13f heidisql.exe Vcl.Menus TMenuItem.Click
0066c7ab heidisql.exe Vcl.Menus TMenu.DispatchCommand
0066da1a heidisql.exe Vcl.Menus TPopupList.WndProc
005b4114 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053b600 heidisql.exe System.Classes StdWndProc
7e418a0b USER32.dll DispatchMessageW
0068510b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068514e heidisql.exe Vcl.Forms TApplication.HandleMessage
00685489 heidisql.exe Vcl.Forms TApplication.Run
0097398b heidisql.exe heidisql 77 +24 initialization

XP 32-bit, Selecting the server in the left pane to get plink restarted on a connection, Heidi attempted to connect without waiting for plink to establish (immediately attempted, not even a second delay), yielding below. plink kept connecting, but in the meantime this was given:


date/time : 2015-04-22, 12:54:51, 131ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 5 days 23 hours
program up time : 1 day 23 hours
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 809/3055 MB (free/total)
free disk space : (C:) 2.09 GB
display mode : 1280x1024, 32 bit
process id : $1500
allocated memory : 28.55 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2014-11-12 05:38
version : 9.1.0.4867
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $eef69a74, $21c32d2a, $21c32d2a
exception number : 3
exception class : EAccessViolation
exception message : Access violation at address 030825DB in module 'libmysql.dll'. Read of address 00000004.

main thread ($1564):
030825db libmysql.dll mysql_ping
00832008 heidisql.exe dbconnection 2103 +2 TMySQLConnection.Ping
00832379 heidisql.exe dbconnection 2197 +10 TMySQLConnection.Query
00836a38 heidisql.exe dbconnection 2782 +12 TDBConnection.SetDatabase
00951394 heidisql.exe Main 7724 +29 TMainForm.DBtreeFocusChanged
007013c2 heidisql.exe VirtualTrees 21679 +2 TBaseVirtualTree.DoFocusChange
007059fa heidisql.exe VirtualTrees 24334 +243 TBaseVirtualTree.HandleMouseDown
006fd410 heidisql.exe VirtualTrees 19184 +6 TBaseVirtualTree.WMLButtonDown
0070a988 heidisql.exe VirtualTrees 27131 +19 TBaseVirtualTree.WndProc
005b4114 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053b600 heidisql.exe System.Classes StdWndProc
7e418a0b USER32.dll DispatchMessageW
0068510b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068514e heidisql.exe Vcl.Forms TApplication.HandleMessage
00685489 heidisql.exe Vcl.Forms TApplication.Run
0097398b heidisql.exe heidisql 77 +24 initialization

Performing a single query on a 100% idle, connected server:

date/time : 2015-04-23, 12:53:57, 468ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 2 hours 35 minutes
program up time : 2 hours 8 minutes
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 1371/3055 MB (free/total)
free disk space : (C:) 2.51 GB
display mode : 1280x1024, 32 bit
process id : $500
allocated memory : 24.76 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2015-04-23 10:31
version : 9.1.0.4943
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $0326bbf3, $47b00cad, $47b00cad
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 0326BBF3 in module 'libmysql.dll'. Read of address 00000170.

thread $830 (TQueryThread):
0326bbf3 libmysql.dll
03268c20 libmysql.dll mysql_store_result
008335dc heidisql.exe dbconnection 2292 +35 TMySQLConnection.Query
00770d68 heidisql.exe helpers 2759 +37 TQueryThread.Execute
0040a13c heidisql.exe System 549 +0 ThreadWrapper
004a5dc1 heidisql.exe madExcept CallThreadProcSafe
004a5e26 heidisql.exe madExcept ThreadExceptFrame
>> created by main thread ($26c) at:
00770b02 heidisql.exe helpers 2697 +1 TQueryThread.Create

main thread ($26c):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon

:(

You are connected via plink.exe / SSH tunnel?

I see, you wrote above about using plink.

Then, you say HeidiSQL is trying to connect while plink is not even connected, is that right?

Perhaps it's a really slow server?
Did you try to increase the "plink.exe timeout" setting in the "SSH tunnel" tab?

These are all separate bug reports. Instead of clogging the forum with heaps, I'm keeping them all in one thread.

For the plink one, the timeout is set to 5. This is to a local server, which is by no mean slow. The pending mysql statements for the server structure discovery was completely ignoring the timeout and firing before plink was ready.

The problem was remedied by a restart of heidi, but was an issue ether way.. I'm more worried about the other reports (clipboard failures, sudden catastrophic failure in an idle/ready state, etc).

And a small behaviour request, could Heidi write out the settings for portable_settings.txt every X minutes (15 maybe?)

After every crash, all of my settings are reverted to the last state that Heidi was able to successfully close. And as I get 10 crashes a day, all for different reasons, it starts getting super frustrating to retweak everything over and over. :)

Possibly noticed a path issue, I have plink set as ".\plink.exe", with plink sitting in the same folder as the heidisql executable. plink works, sessions start, but every now and then, plink suddenly stops being usable/accessible, as if Heidi is no longer looking in the same folder. A restart fixes it.

I'm speculating it might be on export, when I look through directories that it starts looking for plink in the last directory (or something along those lines). I'll try to pin down when it happens. It doesn't generate an exception so I have nothing to show for it, but it's definitely reproducible, as I seem to often.

The reason for using it as .\plink.exe is to maintain portability.

If you specify .\plink.exe that's fine for HeidiSQL. I have no clue why that should lead Heidi to look in a different folder sporadically. You could of course try and set it to some absolute path to see if that error persists.

For the interval based setting-storage, I think that's a good idea. Probably I can do that quickly.

Thank you so much. I've switched to nightly to ensure all problems I'm getting are still relevant in future.

When I close HeidiSQL, HeidiSQL show error :

date/time : 2015-04-23, 16:55:00, 244ms
computer name : CPU1-PC
user name : cpu 1 <admin>
registered owner : cpu 1
operating system : Windows 7 Service Pack 1 build 7601
system language : Indonesian
system up time : 6 hours 39 minutes
program up time : 5 hours 9 minutes
processors : 2x Intel(R) Pentium(R) CPU G630 @ 2.70GHz
physical memory : 882/1937 MB (free/total)
free disk space : (C:) 27.08 GB
display mode : 1366x768, 32 bit
process id : $11bc
allocated memory : 76.07 MB
largest free block : 1.08 GB
executable : heidisql.exe
exec. date/time : 2015-04-22 08:04
version : 9.1.0.4942
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $7a3bca94, $557ce5b1, $557ce5b1
exception number : 1
exception class : ERegistryException
exception message : Failed to set data for 'FindDialogSearchHistory'.

main thread ($d88):
0057bdab heidisql.exe System.Win.Registry TRegistry.PutData
0057b892 heidisql.exe System.Win.Registry TRegistry.WriteString
00776ef5 heidisql.exe helpers 3631 +31 TAppSettings.Write
00777164 heidisql.exe helpers 3658 +1 TAppSettings.WriteString
008cd92a heidisql.exe searchreplace 134 +1 TfrmSearchReplace.FormDestroy
0076495f heidisql.exe gnugettext 3884 +14 THookedObjects.BeforeDestructionHook
00408b91 heidisql.exe System 549 +0 @BeforeDestruction
0067a87a heidisql.exe Vcl.Forms TCustomForm.Destroy
004084b0 heidisql.exe System 549 +0 TObject.Free
00939ccd heidisql.exe Main 1399 +2 TMainForm.FormDestroy
004084b0 heidisql.exe System 549 +0 TObject.Free
00539653 heidisql.exe System.Classes TComponent.DestroyComponents
00678655 heidisql.exe Vcl.Forms DoneApplication
0044c109 heidisql.exe System.SysUtils DoExitProc
00409fe9 heidisql.exe System 549 +0 @Halt0
009769a9 heidisql.exe heidisql 79 +26 initialization
769bed6a kernel32.dll BaseThreadInitThunk

r4944 now writes the portable_settings.txt each 60 seconds, if there is anything to save.

When you activate Tools > Preferences > Logging > "Debug Messages", you will see a log line when this happens. As above said, this is not done when no setting was changed yet. This includes persistent dialog settings, for example when exporting rows from a grid and you change the preselected export format.

Beautiful, that's going to be a lifesaver. Believe me, it will be thoroughly tested/used. :)

As for error reporting, is the above the correct thing to do?

Definitely. Reports, whether bugs or new features always need to be based on the latest nightly build.

Probably I should release more often.

Crash on executing query on mysql, single query, nothing special:


date/time : 2015-04-27, 11:05:38, 390ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 4 days
program up time : 2 hours 2 minutes
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 1387/3055 MB (free/total)
free disk space : (C:) 1.91 GB
display mode : 1280x1024, 32 bit
process id : $b44
allocated memory : 35.60 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2015-04-27 09:02
version : 9.1.0.4944
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $3d0d57b1, $926bf30e, $926bf30e
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 03FC26F4 in module 'libmysql.dll'. Read of address 000002B8.

thread $e6c (TQueryThread):
03fc26f4 libmysql.dll mysql_affected_rows
0083366a heidisql.exe dbconnection 2295 +38 TMySQLConnection.Query
00770dc4 heidisql.exe helpers 2761 +37 TQueryThread.Execute
004a5edb heidisql.exe madExcept HookedTThreadExecute
00537cf1 heidisql.exe System.Classes ThreadProc
0040a13c heidisql.exe System 549 +0 ThreadWrapper
004a5dc1 heidisql.exe madExcept CallThreadProcSafe
004a5e26 heidisql.exe madExcept ThreadExceptFrame
>> created by main thread ($b94) at:
00770b5e heidisql.exe helpers 2699 +1 TQueryThread.Create

main thread ($b94):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon

WOOO the latest nightly catches the annoying plink errors!!

Happened the second I used the explorer window to save the previous bug report I just sent.



date/time : 2015-04-27, 11:07:59, 187ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 4 days
program up time : 2 hours 4 minutes
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 1389/3055 MB (free/total)
free disk space : (C:) 1.91 GB
display mode : 1280x1024, 32 bit
process id : $b44
allocated memory : 39.08 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2015-04-27 09:02
version : 9.1.0.4944
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $b90fdaa3, $5fef2245, $5fef2245
exception number : 2
exception class : EDatabaseError
exception message : Could not execute PLink: .\plink.exe -ssh root@10.10.10.145 -pw "******" -P 22 -N -L 3308:127.0.0.1:3306.

main thread ($b94):
0082b8d5 heidisql.exe dbconnection 865 +45 TPlink.Connect
0082f07b heidisql.exe dbconnection 1637 +43 TMySQLConnection.SetActive
0095ed87 heidisql.exe Main 10924 +13 TMainForm.actCancelOperationExecute
0053ab2f heidisql.exe System.Classes TBasicAction.Execute
00594707 heidisql.exe Vcl.ActnList TCustomAction.Execute
0053a9cf heidisql.exe System.Classes TBasicActionLink.Execute
005b0730 heidisql.exe Vcl.Controls TControl.Click
005f72dc heidisql.exe Vcl.ComCtrls TToolButton.Click
005b0bf1 heidisql.exe Vcl.Controls TControl.WMLButtonUp
005b01f1 heidisql.exe Vcl.Controls TControl.WndProc
005b4d11 heidisql.exe Vcl.Controls TWinControl.WndProc
0067bc7d heidisql.exe Vcl.Forms TCustomForm.WndProc
005afe2c heidisql.exe Vcl.Controls TControl.Perform
005b444c heidisql.exe Vcl.Controls GetControlAtPos
005b4516 heidisql.exe Vcl.Controls TWinControl.ControlAtPos
005afe2c heidisql.exe Vcl.Controls TControl.Perform
005b45e0 heidisql.exe Vcl.Controls TWinControl.IsControlMouseMsg
005b4b8d heidisql.exe Vcl.Controls TWinControl.WndProc
005fbe4c heidisql.exe Vcl.ComCtrls TToolBar.WndProc
005b4354 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053b840 heidisql.exe System.Classes StdWndProc
7e418a0b USER32.dll DispatchMessageW
0068534b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068538e heidisql.exe Vcl.Forms TApplication.HandleMessage
006856c9 heidisql.exe Vcl.Forms TApplication.Run

It says "Could not execute PLink: .\plink.exe". So, I assume there is a problem with using ".\" . Please try to use an absolute path just to see if that works.

You can probably use "plink.exe" without the ".\". Please also test.

Testing it with just "plink.exe".

I'll no doubt have an answer for you within 24 hours.

When I was exporting, I noticed my export settings had reset. Ignoring it, I set them back as usual and on attempting an export to file, the following occurred:


date/time : 2015-04-28, 10:22:29, 234ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 5 days
program up time : 3 minutes 15 seconds
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 884/3055 MB (free/total)
free disk space : (C:) 297.05 MB
display mode : 1280x1024, 32 bit
process id : $ec0
allocated memory : 40.19 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2015-04-27 09:02
version : 9.1.0.4944
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $7a3bca94, $feeac7d1, $feeac7d1
exception number : 1
exception class : ERegistryException
exception message : Failed to set data for 'GridExportOutputCopy'.

main thread ($c4c):
0057bdab heidisql.exe System.Win.Registry TRegistry.PutData
0057bb4c heidisql.exe System.Win.Registry TRegistry.WriteInteger
0057bb87 heidisql.exe System.Win.Registry TRegistry.WriteBool
00776eff heidisql.exe helpers 3625 +23 TAppSettings.Write
00777159 heidisql.exe helpers 3654 +1 TAppSettings.WriteBool
008f29fe heidisql.exe exportgrid 129 +3 TfrmExportGrid.FormDestroy
0067aa75 heidisql.exe Vcl.Forms TCustomForm.DoDestroy
0067a869 heidisql.exe Vcl.Forms TCustomForm.BeforeDestruction
0076495f heidisql.exe gnugettext 3884 +14 THookedObjects.BeforeDestructionHook
00408b91 heidisql.exe System 549 +0 @BeforeDestruction
0067a87a heidisql.exe Vcl.Forms TCustomForm.Destroy
004084b0 heidisql.exe System 549 +0 TObject.Free
0067fe98 heidisql.exe Vcl.Forms TCustomForm.CMRelease
005b01f1 heidisql.exe Vcl.Controls TControl.WndProc
00683d0c heidisql.exe Vcl.Forms TApplication.ModalFinished
00680876 heidisql.exe Vcl.Forms TCustomForm.ShowModal
009406f5 heidisql.exe Main 2868 +4 TMainForm.actExportDataExecute
0053ab2f heidisql.exe System.Classes TBasicAction.Execute
0053a9cf heidisql.exe System.Classes TBasicActionLink.Execute
0066b37f heidisql.exe Vcl.Menus TMenuItem.Click
0066c9eb heidisql.exe Vcl.Menus TMenu.DispatchCommand
0066dc5a heidisql.exe Vcl.Menus TPopupList.WndProc
005b4354 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053b840 heidisql.exe System.Classes StdWndProc
7e418a0b USER32.dll DispatchMessageW
0068534b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068538e heidisql.exe Vcl.Forms TApplication.HandleMessage
006856c9 heidisql.exe Vcl.Forms TApplication.Run

Aaand the moment I changed directories to export, plink no longer works.
Probably safe to assume that the instant the working directory is changed, plink is unusable.

I'll switch to absolute paths. Will all paths update if the directory/drive is changed? The intention is to have Heidi on a USB drive when having to change offices/going on the road/working from home on sick days.

Got a libmysql.dll crash, i have already reported it in the past, so I ignored it. Immediately after dismissing the madExcept dialog for it I got hit with this one as well:


date/time : 2015-04-29, 12:21:06, 125ms
computer name : SP3-2009PPP
user name : user <admin>
registered owner : qq
operating system : Windows XP Service Pack 3 build 2600
system language : English
system up time : 6 days 2 hours
program up time : 1 day
processors : 2x Intel(R) Core(TM)2 CPU 4300 @ 1.80GHz
physical memory : 1212/3055 MB (free/total)
free disk space : (C:) 1.97 GB
display mode : 1280x1024, 32 bit
process id : $1040
allocated memory : 34.34 MB
largest free block : 459.70 MB
executable : heidisql.exe
exec. date/time : 2015-04-27 09:02
version : 9.1.0.4944
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $7c91240b, $add525a9, $add525a9
exception number : 2
exception class : EAccessViolation
exception message : Access violation at address 7C91240B in module 'ntdll.dll'. Write of address 78004000.

main thread ($4d0):
7c91240b ntdll.dll
7c9109b5 ntdll.dll RtlFreeHeap
03fc6f14 libmysql.dll mysql_free_result
008441f2 heidisql.exe dbconnection 5089 +2 TMySQLQuery.Destroy
004084b0 heidisql.exe System 549 +0 TObject.Free
0083cdba heidisql.exe dbconnection 3953 +2 TDBConnection.ClearCache
0082f694 heidisql.exe dbconnection 1740 +146 TMySQLConnection.SetActive
00833184 heidisql.exe dbconnection 2175 +4 TMySQLConnection.Ping
00840b4b heidisql.exe dbconnection 4525 +5 TDBConnection.ConnectionInfo
009394fb heidisql.exe Main 1245 +18 TMainForm.StatusBarMouseMove
005b0a7a heidisql.exe Vcl.Controls TControl.MouseMove
005b0b06 heidisql.exe Vcl.Controls TControl.WMMouseMove
005b01f1 heidisql.exe Vcl.Controls TControl.WndProc
005b4d11 heidisql.exe Vcl.Controls TWinControl.WndProc
005b4354 heidisql.exe Vcl.Controls TWinControl.MainWndProc
0053b840 heidisql.exe System.Classes StdWndProc
7e418a0b USER32.dll DispatchMessageW
0068534b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068538e heidisql.exe Vcl.Forms TApplication.HandleMessage
006856c9 heidisql.exe Vcl.Forms TApplication.Run

This gets more and more mysterious:
"Access violation ... in module 'ntdll.dll'"

Can you please check which version of libmysql.dll HeidiSQL is using? You can see that version in HeidiSQL, when you hover with the mouse over status bar panel which displays the "MySQL x.y" or whatever in your case. A tooltip will show you some detailed lines about your connection and the server. Please post what it says in the "Client version (libmysql)" line.

5.6.6-m9

Ok, that's the one shipped with the latest installer, so this is good news.

I just cannot tell why that crash happens. The crash mentions ntdll.dll, so probably it's an issue in Windows XP. Probably you can try out on a newer Windows?

The work computers are pretty garbage, This isn't even the default configuration. I ended up ebaying some more RAM for my workstation. :)
Its likely I'll sink some mony into a new computer for work, so I'll ignore this error for now.

There's plenty of errors above that haven't been discussed (but aren't critical to getting work done). I hope I've helped at all.

Here's a good one, Heidi exploded entirely. The only way to get it out of an unresponsive state was to kill off the plink processes I had, one by one. The whole thing froze over, using 0.00% cpu until doing as mentioned.


date/time : 2015-05-03, 22:08:52, 342ms
computer name : ARFFEH-PC
user name : Arffeh
registered owner : Windows User
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 11 hours 57 minutes
program up time : 24 minutes 52 seconds
processors : 4x Intel(R) Core(TM)2 Quad CPU Q8300 @ 2.50GHz
physical memory : 1312/4095 MB (free/total)
free disk space : (C:) 5.97 GB
display mode : 1920x1080, 32 bit
process id : $e80
allocated memory : 65.69 MB
largest free block : 1.15 GB
executable : heidisql.exe
exec. date/time : 2015-04-27 00:06
version : 9.1.0.4944
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $041161c0, $e37977c1, $e37977c1
exception number : 1
exception class : EAccessViolation
exception message : Access violation at address 041161C0. Write of address 00002757.

thread $1b78 (TQueryThread):
041161c0 ???
52528b6b libmysql.dll mysql_real_query
0083358f heidisql.exe dbconnection 2278 +21 TMySQLConnection.Query
00770dc4 heidisql.exe helpers 2761 +37 TQueryThread.Execute
0040a13c heidisql.exe System 549 +0 ThreadWrapper
004a5dc1 heidisql.exe madExcept CallThreadProcSafe
004a5e26 heidisql.exe madExcept ThreadExceptFrame
75863368 kernel32.dll BaseThreadInitThunk
>> created by main thread ($133c) at:
00770b5e heidisql.exe helpers 2699 +1 TQueryThread.Create

main thread ($133c):
00000000 heidisql.exe madStackTrace +0 StackAddrToStr
>> stack will be calculated soon