Queries Just Hang

[expired user #7406]'s profile image [expired user #7406] posted 10 years ago in General Permalink
Hi,

I am running a query that ran perfectly well 2 or 3 days ago, but now will not run.

It's nothing too complicated. I say that but did not write the sql.
[/code]
select GAME_MIN as "Time Gone", 
(select count(game_id) from games) as "Total Games",(select count(action_id) from game_actions b where status_time >a.game_min and type='goal'  and team='home') as "HomeTeamFullTimeGoals" ,
(select count(action_id) from game_actions b where status_time >a.game_min and type='goal' and team='away') as "AwayTeamFullTimeGoals" ,
(select count(action_id) from game_actions b where status_time >a.game_min and type='goal' ) as "TotalFullTimeGoals",
(select count(action_id) from game_actions b where status_time >a.game_min and type='goal' and team='home' and status_time<=45) as "HomeTeamHalfTimeGoals" ,
(select count(action_id) from game_actions b where status_time >a.game_min and type='goal' and team='away' and status_time<=45) as "AwayTeamHalfTimeGoals" ,
(select count(action_id) from game_actions b where status_time >a.game_min and type='goal' and status_time<=45) as "TotalHalfTimeGoals" 
from running_time a
order by game_min asc[code]


I can run simple 'select *' queries and they are fine, so no idea why this wouldn't be working as it was. The progress bar doesn't move. I left it running overnight and was still 'running' this morning. Previoulsy this took around 6-8 minutes to run.

Nohting has changed to the data, so am at a loss as to why it is not running.

I think (yes, think) I downloaded a new version when prompted yesterday when the troubles began.I had a fatal crash earlier so have reinstalled version 8.0.0.4396.

Here is the bug report:-

date/time : 2013-11-29, 13:24:11, 447ms
computer name : MM-PC-1
user name : Multiple Monitora
registered owner : Multiple Monitora
operating system : Windows 7 x64 Service Pack 1 build 7601
system language : English
system up time : 40 minutes 4 seconds
program up time : 12 minutes 6 seconds
processors : 8x Intel(R) Core(TM) i7-2600 CPU @ 3.40GHz
physical memory : 13055/16365 MB (free/total)
free disk space : (C:) 2.01 GB
display mode : 1600x1200, 32 bit
process id : $e68
allocated memory : 99.01 MB
executable : heidisql.exe
exec. date/time : 2013-10-03 07:24
version : 8.1.0.4545
compiled with : Delphi XE
madExcept version : 3.0m beta 1
callstack crc : $a36e93f4, $e2c7df23, $e2c7df23
exception number : 2
exception class : EAccessViolation
exception message : Access violation at address 004048F7 in module 'heidisql.exe'. Read of address 43532364.

thread $e44 (TWorkerThread):
004048f7 heidisql.exe System 549 +0 Move
00408857 heidisql.exe System 549 +0 @UStrCat
0068d289 heidisql.exe helpers 3463 +5 TAppSettings.PrepareRegistry
0068d965 heidisql.exe helpers 3599 +16 TAppSettings.Read
0068dc0f heidisql.exe helpers 3630 +1 TAppSettings.ReadInt
007fb7d7 heidisql.exe Main 4793 +2 TMainForm.AnyGridInitNode
00625c7b heidisql.exe VirtualTrees TBaseVirtualTree.DoInitNode
00629ae4 heidisql.exe VirtualTrees TBaseVirtualTree.InitNode
0061bc0c heidisql.exe VirtualTrees TBaseVirtualTree.GetNodeHeight
00626e0b heidisql.exe VirtualTrees TBaseVirtualTree.DoValidateCache
0060ec39 heidisql.exe VirtualTrees TWorkerThread.Execute
00460ae7 heidisql.exe madExcept HookedTThreadExecute
004a94d2 heidisql.exe Classes ThreadProc
00407530 heidisql.exe System 549 +0 ThreadWrapper
004609c9 heidisql.exe madExcept CallThreadProcSafe
00460a33 heidisql.exe madExcept ThreadExceptFrame
76523398 kernel32.dll BaseThreadInitThunk
>> created by main thread ($c70) at:
0060ea5a heidisql.exe VirtualTrees TWorkerThread.Create

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



Any help gratefully appreciated.

John

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