Subject Why is FB hanging in 64bit Win7/Vista and not 32bit?
Author Chuck Belanger

I've asked this question before, but did not get any responses that
could help.

I have been seeing regularly, but still extremely intermittently,
considering the number of times my program makes calls to the database,
that in Win7/Vista, 64bit, and not in 32 bit, Firebird can hang. What's
going on here? Anything I can do about this? The example below is not
uncommon, but it can happen with any query of the DB throughout the program.

I am using IBObjects, with Delphi 2007, and the 32bit Firebird 2.5. This
is a desktop application with a single user. The database is local on
the HD.

Thank you for your help,

Chuck Belanger

Here is a recent bug report showing this:

operating system : Windows Vista x64 Service Pack 2 build 6002
system language : English
system up time : 2 days 4 hours
program up time : 1 hour 13 minutes
processors : 2x Intel(R) Core(TM)2 Duo CPU T6500 @ 2.10GHz
physical memory : 1474/4062 MB (free/total)
free disk space : (C:) 122.93 GB
display mode : 1440x900, 32 bit
process id : $10c4
allocated memory : 107.48 MB
executable : ProfViewer.exe
exec. date/time : 2011-06-13 16:25
version :
compiled with : Delphi 2006/07
madExcept version : 3.0h
callstack crc : $89acbf24, $d9fe38ab, $b34adc39
exception number : 1
exception message : The application seems to be frozen.

main thread ($e8c):
76b7126a +089 kernel32.dll WaitForSingleObjectEx
76b711d3 +00d kernel32.dll WaitForSingleObject
100219e2 +172 fbclient.dll isc_dsql_execute2_m
100237e3 +143 fbclient.dll isc_dsql_execute2
10023bdb +01b fbclient.dll isc_dsql_execute
005b8fe6 +052 ProfViewer.exe IB_Components 23063 +8 TIB_Statement.API_Execute
005c0109 +005 ProfViewer.exe IB_Components 26592 +1 TIB_Dataset.SysExecSelect
005b7847 +09b ProfViewer.exe IB_Components 22401 +9 TIB_Statement.SysExecStatement
005b7518 +098 ProfViewer.exe IB_Components 22293 +12 TIB_Statement.SysExecute
005bfe8b +063 ProfViewer.exe IB_Components 26533 +7 TIB_Dataset.SysExecute
005bf5fb +117 ProfViewer.exe IB_Components 26320 +23 TIB_Dataset.SysOpen
005bf0c3 +053 ProfViewer.exe IB_Components 26133 +8 TIB_Dataset.Open
00ca73b3 +18f ProfViewer.exe uNMTGEFDlg 244 +59 TfrmGEFDlg.FormCreate