Connection crash

[expired user #7050]'s profile image [expired user #7050] posted 10 years ago in General Permalink
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

[expired user #7050]'s profile image [expired user #7050] posted 10 years ago Permalink
The error message is:
"Operation is not allowed when the object is closed"
igitur's profile image igitur posted 9 years ago Permalink
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's profile image igitur posted 9 years ago Permalink
Pretty please?
igitur's profile image igitur posted 9 years ago Permalink
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.