Crash whenever I click "Data" tab

msoutherton posted 2 years ago in General
HeidiSQL crashes when I click the "Data" tab on a table of a specific size.

- It crashes on most tables in my database.
- It seems to only happen on tables of a relatively larger size.
- It does not crash on tables that have relatively small amounts of data.
- I'm connected to a Microsoft SQL Server (TCP/IP, experimental)
- Here is my bugreport.txt:

date/time : 2014-05-16, 15:44:01, 701ms
computer name : MICHAEL-VAIO
user name : michael
registered owner : michael
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 1 day 6 hours
program up time : 14 seconds
processors : 4x Intel(R) Core(TM) i5-2450M CPU @ 2.50GHz
physical memory : 2095/6092 MB (free/total)
free disk space : (C:) 201.04 GB
display mode : 1920x1080, 32 bit
process id : $22d0
allocated memory : 81.77 MB
largest free block : 8185.76 GB
executable : heidisql.exe
exec. date/time : 2014-01-25 11:34
version :
compiled with : Delphi XE5
madExcept version :
callstack crc : $38576a79, $d0bcc767, $036712c4
exception number : 1
exception class : EDatabaseError
exception message : SQL Error (208): Invalid object name 'sys.partitions'.

main thread ($2500):
00a63163 heidisql.exe dbconnection 1747 +53 TAdoDBConnection.Query
00a746e0 heidisql.exe dbconnection 3972 +3 TAdoDBQuery.Execute
00a6777a heidisql.exe dbconnection 2246 +5 TDBConnection.GetResults
00a68d34 heidisql.exe dbconnection 2517 +1 TDBConnection.GetVar
00bf8741 heidisql.exe Main 4808 +15 TMainForm.DisplayRowCountStats
00bf7ebd heidisql.exe Main 4759 +195 TMainForm.DataGridBeforePaint
008c8a49 heidisql.exe VirtualTrees 21198 +2 TBaseVirtualTree.DoBeforePaint
008e136a heidisql.exe VirtualTrees 31781 +5 TBaseVirtualTree.PaintTree
008d3137 heidisql.exe VirtualTrees 25419 +22 TBaseVirtualTree.Paint
006a3da6 heidisql.exe Vcl.Controls TCustomControl.PaintWindow
0069ab53 heidisql.exe Vcl.Controls TWinControl.PaintHandler
0069b9ef heidisql.exe Vcl.Controls TWinControl.WMPaint
006a3d38 heidisql.exe Vcl.Controls TCustomControl.WMPaint
008c5071 heidisql.exe VirtualTrees 19414 +8 TBaseVirtualTree.WMPaint
0040ca5e heidisql.exe System TObject.Dispatch
006931f3 heidisql.exe Vcl.Controls TControl.WndProc
0069a8be heidisql.exe Vcl.Controls TWinControl.WndProc
008d7a3b heidisql.exe VirtualTrees 27144 +32 TBaseVirtualTree.WndProc
00699afa heidisql.exe Vcl.Controls TWinControl.MainWndProc
005da433 heidisql.exe System.Classes StdWndProc
772111f1 ntdll.dll KiUserCallbackDispatcher
770d6e67 USER32.dll DispatchMessageW
00812a4f heidisql.exe Vcl.Forms TApplication.ProcessMessage
00812ac3 heidisql.exe Vcl.Forms TApplication.HandleMessage
00812faf heidisql.exe Vcl.Forms TApplication.Run
00c36c57 heidisql.exe heidisql 77 +24 initialization
76fb59eb kernel32.dll BaseThreadInitThunk

main thread ($2500), inner exception level 1:
>> EOleException, Invalid object name 'sys.partitions'
00a62d31 heidisql.exe dbconnection 1714 +20 TAdoDBConnection.Query

Anything else I can provide?
sky.tian posted 2 years ago
hi, it seems like, if you ever execute a query that takes the database a very long time to return the resultset, heidisql may fall into a 'non-responding state'(forgive my poor english), and crash, due to a mouse click on the GUI.
Needs to be more stable and robust´╝ü
ansgar posted 2 years ago
The relevant error message above is

SQL Error (208): Invalid object name 'sys.partitions'

... which is asked for in an internal query for getting row count statistics:

SELECT SUM(rows) FROM sys.partitions WHERE index_id IN (0, 1) AND object_id = object_id(mydb.myschema.mytable)

So it looks like again we have an incompatible query for some MSSQL versions. The relevant question is: Which MSSQL version is it, and do you know an alternative to the above mentioned query?
ansgar posted 2 years ago
See and add further comments here.
msoutherton posted 2 years ago
I'm running MSSQL 2008. I'm not sure what's wrong with the query.

ansgar posted 2 years ago
Thanks for reading man.. Further comments please here: http://www.heidisql.com/forum.php?t=15438

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