distal-attribute
distal-attribute
distal-attribute
distal-attribute

Connection crash

paolo.sanchi posted 10 months ago in General
Hello,
I always get an error, you can reproduce this way:
- Coonnect to a remote db (mssql, using TCP/IP)
- Disconnect the network cable for a while
- Reconnect the cable
- Select a table to trigger a query

It happens even when i turn in sleep my pc, and when I wake it up.
I have the bugreport, these are the most relevant info:

operating system : Windows 8 x64 build 9200
system language : Italian
processors : 4x Intel(R) Core(TM) i5-4200U CPU @ 1.60GHz
physical memory : 2270/7962 MB (free/total)
free disk space : (C:) 390,12 GB
display mode : 1366x768, 32 bit
process id : $1368
allocated memory : 103,81 MB
largest free block : 131029,99 GB
executable : heidisql.exe
exec. date/time : 2014-02-03 12:45
version : 8.3.0.4696
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $38576a79, $324d99ad, $324d99ad
exception number : 1
exception class : Unknown
exception message : Unknown.

main thread ($20ac):
00a63163 heidisql.exe dbconnection 1747 +53 TAdoDBConnection.Query
7ff8dfb7 user32.dll GetMessageW
004ec446 heidisql.exe madExcept HandleException
004f8f64 heidisql.exe madExcept InterceptAHandleExcept
00699b1e heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da433 heidisql.exe System.Classes StdWndProc
7ff8dfb7 user32.dll DispatchMessageW
00812a4f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00812ac3 heidisql.exe Vcl.Forms TApplication.HandleMessage
00812faf heidisql.exe Vcl.Forms TApplication.Run
00c36e27 heidisql.exe heidisql 77 +24 initialization
7ff8de04 KERNEL32.DLL BaseThreadInitThunk
7ff8e034 ntdll.dll RtlUserThreadStart

paolo.sanchi posted 10 months ago
The error message is:
"Operation is not allowed when the object is closed"
igitur posted 2 months ago
This is a really old post, but instead of opening a new one, I thought I'd add to this. I'm in a similar situation. But my disconnects are because of my application's database migrations. Before running a migration, it kills all connections to the database. Then, after the migration, when I return to HeidiSQL and perform a data refresh, it crashes. There is already a bug request for this at https://code.google.com/p/heidisql/issues/detail?id=3601

Dear developer, any chance you could look at this issue. Sorry to say, but it's driving me up the wall to restart HeidiSQL every time.
igitur posted 2 months ago
Pretty please?
igitur posted 2 months ago
Updated bug report, if it helps in any way:

date/time : 2014-11-05, 14:41:58, 748ms
computer name :
user name :
registered owner :
operating system : Windows 7 Service Pack 1 build 7601
system language : English
system up time : 1 day 5 hours
program up time : 19 minutes 14 seconds
processors : 4x Intel(R) Core(TM) i5-3470 CPU @ 3.20GHz
physical memory : 220/3406 MB (free/total)
free disk space : (C:) 211.40 GB
display mode : 1600x900, 32 bit
process id : $1d80
allocated memory : 42.14 MB
largest free block : 560.65 MB
executable : heidisql.exe
exec. date/time : 2014-10-16 09:40
version : 8.3.0.4834
compiled with : Delphi XE5
madExcept version : 4.0.8.1
callstack crc : $12861c2c, $73ab7f28, $03e15c41
exception number : 1
exception class : EDatabaseError
exception message : SQL Error (0): Operation is not allowed when the object is closed unknown.

main thread ($1e38):
00832735 heidisql.exe dbconnection 2318 +47 TAdoDBConnection.Query
775a71c6 ntdll.dll RtlRaiseStatus
775bd1c9 ntdll.dll bsearch
758c811d KERNELBASE.dll RaiseException
0084035e heidisql.exe dbconnection 4920 +3 TAdoDBQuery.Execute
008362ed heidisql.exe dbconnection 3043 +5 TDBConnection.GetResults
00837898 heidisql.exe dbconnection 3419 +3 TAdoDBConnection.GetCollationTable
00837a1f heidisql.exe dbconnection 3433 +1 TDBConnection.GetCollationList
0087d4f4 heidisql.exe table_editor 260 +5 TfrmTableEditor.Init
009547e0 heidisql.exe Main 9576 +17 TMainForm.PlaceObjectEditor
0094e506 heidisql.exe Main 7762 +69 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
75edcc6b USER32.dll DispatchMessageW
0068510b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068514e heidisql.exe Vcl.Forms TApplication.HandleMessage
00685489 heidisql.exe Vcl.Forms TApplication.Run
0097098b heidisql.exe heidisql 77 +24 initialization
776fed5a kernel32.dll BaseThreadInitThunk

main thread ($1e38), inner exception level 1:
>> EOleException, Operation is not allowed when the object is closed
00832546 heidisql.exe dbconnection 2291 +20 TAdoDBConnection.Query
0084035e heidisql.exe dbconnection 4920 +3 TAdoDBQuery.Execute
008362ed heidisql.exe dbconnection 3043 +5 TDBConnection.GetResults
00837898 heidisql.exe dbconnection 3419 +3 TAdoDBConnection.GetCollationTable
00837a1f heidisql.exe dbconnection 3433 +1 TDBConnection.GetCollationList
0087d4f4 heidisql.exe table_editor 260 +5 TfrmTableEditor.Init
009547e0 heidisql.exe Main 9576 +17 TMainForm.PlaceObjectEditor
0094e506 heidisql.exe Main 7762 +69 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
75edcc6b USER32.dll DispatchMessageW
0068510b heidisql.exe Vcl.Forms TApplication.ProcessMessage
0068514e heidisql.exe Vcl.Forms TApplication.HandleMessage
00685489 heidisql.exe Vcl.Forms TApplication.Run
0097098b heidisql.exe heidisql 77 +24 initialization
776fed5a kernel32.dll BaseThreadInitThunk

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