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.