I have a client running Firebird 1.5RC8 on a Windows 2003 server. Are
application is constantly locking up. I have an exception tracking
component that sends me the call stack. It looks like GDS32.DLL is
calling ISC_DSQL_PREPARE_M, which calls RTLPWAITFORCRITICALSECTION in
NTDLL.DLL then ZWWAITFORSINGLEOBJECT in NTDLL.DLL and never returns.

It is always happening at the same place in the code shown below. The
arrow marks where the Delphi code that starts it all.
Any help would be very appreciated. This is a big customer of ours.

- James Armstrong

if DataModule2.IBSite2.Eof then begin
DataModule2.IBSite2.Close;
DataModule2.IBSite2.SQL.Clear;
DataModule2.IBSite2.SQL.Add('Select SITE_NAME from SITE where NOT
CALLFLAG IS NULL and CALLFLAG <> '''';');
->Line 4214:
DataModule2.IBSite2.Open;
DataModule2.IBSite2.RefreshRows;
Port[OPORT].OutCalls := DataModule2.IBSite2.RecordCount;
end;

Operating System:
---------------------------------------
5.1 Type : Microsoft Windows 2003
5.2 Build # : 3790
5.3 Update :
5.4 Language: English (United States)

Call Stack Information:
----------------------------------------------------------------------------------------------
|Address |Module |Unit |Class |Procedure/Method |Line |
----------------------------------------------------------------------------------------------
*|77F4373F|ntdll.dll | | |ZwWaitForSingleObject | |
|77F43735|ntdll.dll | | |ZwWaitForSingleObject | |
|77F5D649|ntdll.dll | | |RtlpWaitForCriticalSection| |
|77F5D5C4|ntdll.dll | | |RtlpWaitForCriticalSection| |
|10015E03|gds32.dll | | |isc_dsql_prepare_m | |
|77E435B6|kernel32.dll| | |CompareStringW | |
|77E5A0BC|kernel32.dll| | |CompareStringA | |
|10009E8E|gds32.dll | | |gds__alloc | |
|10015D10|gds32.dll | | |isc_dsql_prepare_m | |
*|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|005653E8|TWR.EXE |IB_Parse.pas | |ParseStr2 |1363 |
|00565827|TWR.EXE |IB_Parse.pas | |ParseStr |1483 |
|005653E8|TWR.EXE |IB_Parse.pas | |ParseStr2 |1363 |
|00565827|TWR.EXE |IB_Parse.pas | |ParseStr |1483 |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|0058D14D|TWR.EXE |IB_Components.pas|TIB_Statement |API_Prepare |23301|
|0056813F|TWR.EXE |IB_Parse.pas | |MakeServerSQL |2817 |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|77F420C6|ntdll.dll | | |RtlLeaveCriticalSection | |
|0058E254|TWR.EXE |IB_Components.pas|TIB_Statement |SysSQLChange |23851|
|0059855C|TWR.EXE |IB_Components.pas|TIB_Dataset |SysSQLChange |28801|
|005C86FD|TWR.EXE |IBODataset.pas |TIBOInternalDataset|SysSQLChange |7631 |
|0058E20F|TWR.EXE |IB_Components.pas|TIB_Statement |OnSQLChange |23833|
|0058B24C|TWR.EXE |IB_Components.pas|TIB_Statement |SysExecPrepare |22361|
|0058B05C|TWR.EXE |IB_Components.pas|TIB_Statement |SysExecPrepare |22324|
|0058AFD4|TWR.EXE |IB_Components.pas|TIB_Statement |SysPrepare |22288|
|0058AF6C|TWR.EXE |IB_Components.pas|TIB_Statement |SysPrepare |22271|
|005948DA|TWR.EXE |IB_Components.pas|TIB_Dataset |SysPrepare |27008|
|00594850|TWR.EXE |IB_Components.pas|TIB_Dataset |SysPrepare |26997|
|005C88E8|TWR.EXE |IBODataset.pas |TIBOInternalDataset|SysPrepare |7710 |
|0058C09F|TWR.EXE |IB_Components.pas|TIB_Statement |SysExecute |22744|
|0058C068|TWR.EXE |IB_Components.pas|TIB_Statement |SysExecute |22741|
|00593ED4|TWR.EXE |IB_Components.pas|TIB_Dataset |SysExecute |26746|
|005936CD|TWR.EXE |IB_Components.pas|TIB_Dataset |SysOpen |26546|
|0058E6B8|TWR.EXE |IB_Components.pas|TIB_Statement |GetStatementType |23998|
|005935C0|TWR.EXE |IB_Components.pas|TIB_Dataset |SysOpen |26524|
|005C5421|TWR.EXE |IBODataset.pas |TIBODataset |DoBeforeOpen |5949 |
*|0067181F|TWR.EXE |TWR1.pas |TForm1 |GeneralTimerEventHandler |4214 |*
|004D7BC0|TWR.EXE |OvcTimer.pas |TOvcTimerPool |DoTriggerNotification |327 |
|004D7EE1|TWR.EXE |OvcTimer.pas |TOvcTimerPool |tpTimerWndProc |639 |
|77D0FADF|user32.dll | | |DispatchMessageA | |
|77D0FAD9|user32.dll | | |DispatchMessageA | |
|00693448|TWR.EXE |Twr.dpr | |twr |57 |
|00693311|TWR.EXE |Twr.dpr | |twr |37 |
----------------------------------------------------------------------------------------------

Modules Information:
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|Handle |Name |Description |Version |Size |Path |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
|00400000|TWR.EXE | |2.0.1.28 |4104704|C:\TOWERMONITOR |
|10000000|gds32.dll |Firebird SQL Server |6.3.0.4201 |356432 |C:\WINDOWS\system32 |
|5AA20000|umdmxfrm.dll|Unimodem Tranform Module |5.2.3790.0 |14848 |C:\WINDOWS\system32 |
|5C830000|serwvdrv.dll|Unimodem Serial Wave driver |5.2.3790.0 |15872 |C:\WINDOWS\system32 |
|5E9A0000|olepro32.dll| |5.2.3790.0 |78848 |C:\WINDOWS\system32 |
|70AD0000|comctl32.dll|User Experience Controls Library |6.0.3790.0 |928768 |C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.100.0_x-ww_8417450B|
|70BC0000|comctl32.dll|Common Controls Library |5.82.3790.0|574464 |C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_5.82.0.0_x-ww_8A69BA05 |
|71AE0000|wshtcpip.dll|Windows Sockets Helper DLL |5.2.3790.0 |18432 |C:\WINDOWS\System32 |
|71B20000|MSWSOCK.dll |Microsoft Windows Sockets 2.0 Service Provider |5.2.3790.0 |260096 |C:\WINDOWS\system32 |
|71BB0000|wsock32.dll |Windows Socket 32-Bit DLL |5.2.3790.0 |22528 |C:\WINDOWS\system32 |
|71BD0000|MPR.dll |Multiple Provider Router DLL |5.2.3790.0 |57344 |C:\WINDOWS\system32 |
|71BF0000|WS2HELP.dll |Windows Socket 2.0 Helper for Windows NT |5.2.3790.0 |19968 |C:\WINDOWS\system32 |
|71C00000|WS2_32.dll |Windows Socket 2.0 32-Bit DLL |5.2.3790.0 |89600 |C:\WINDOWS\system32 |
|73070000|winspool.drv|Windows Spooler Driver |5.2.3790.0 |143360 |C:\WINDOWS\system32 |
|762B0000|comdlg32.dll|Common Dialogs DLL |6.0.3790.0 |267264 |C:\WINDOWS\system32 |
|76AA0000|winmm.dll |MCI API DLL |5.2.3790.0 |169984 |C:\WINDOWS\system32 |
|76B70000|PSAPI.DLL |Process Status Helper |5.2.3790.0 |22016 |C:\WINDOWS\system32 |
|770E0000|oleaut32.dll| |5.2.3790.0 |497664 |C:\WINDOWS\system32 |
|77160000|ole32.dll |Microsoft OLE for Windows |5.2.3790.80|1183744|C:\WINDOWS\system32 |
|77290000|SHLWAPI.dll |Shell Light-weight Utility Library |6.0.3790.0 |287744 |C:\WINDOWS\system32 |
|77380000|shell32.dll |Windows Shell Common Dll |6.0.3790.0 |8166400|C:\WINDOWS\system32 |
|77B90000|version.dll |Version Checking and File Installation Libraries|5.2.3790.0 |17408 |C:\WINDOWS\system32 |
|77BA0000|msvcrt.dll |Windows NT CRT DLL |7.0.3790.0 |327168 |C:\WINDOWS\system32 |
|77C00000|GDI32.dll |GDI Client DLL |5.2.3790.0 |269312 |C:\WINDOWS\system32 |
|77C50000|RPCRT4.dll |Remote Procedure Call Runtime |5.2.3790.76|657920 |C:\WINDOWS\system32 |
|77D00000|user32.dll |Windows USER API Client DLL |5.2.3790.73|575488 |C:\WINDOWS\system32 |
|77DA0000|advapi32.dll|Advanced Windows 32 Base API |5.2.3790.0 |572928 |C:\WINDOWS\system32 |
|77E40000|kernel32.dll|Windows NT BASE API Client DLL |5.2.3790.0 |988160 |C:\WINDOWS\system32 |
|77F40000|ntdll.dll |NT Layer DLL |5.2.3790.0 |739840 |C:\WINDOWS\system32 |
|780C0000|MSVCP60.dll |Microsoft (R) C++ Runtime Library |6.5.2144.0 |397312 |C:\WINDOWS\system32 |
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

Registers:
-----------------------------
EAX: 0012F6E8 EDI: 7FFDE000
EBX: 00000000 ESI: 10056108
ECX: 004023B1 ESP: 0012F710
EDX: 00000000 EIP: 7FFE0304

Stack: Memory Dump:
------------------ ---------------------------------------------------------------------------
0012F710: 77F43741 7FFE0304: C3 9C 81 0C 24 00 01 00 00 9D C3 90 90 90 90 90 ....$...........
0012F714: 77F5D64E 7FFE0314: 8B D4 0F 05 C3 9C 81 0C 24 00 01 00 C0 76 85 00 ........$....v..
0012F718: 00000170 7FFE0324: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F71C: 00000000 7FFE0334: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F720: 00000000 7FFE0344: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F724: 00C272C4 7FFE0354: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F728: 00C27288 7FFE0364: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F72C: 0195DF30 7FFE0374: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F730: 00000000 7FFE0384: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F734: 00000000 7FFE0394: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F738: 00402529 7FFE03A4: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F73C: 00000000 7FFE03B4: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F740: 0069F438 7FFE03C4: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F744: 000012AD 7FFE03D4: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................
0012F748: 00000000 7FFE03E4: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................

0012F74C: 0000004B 7FFE03F4: 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 ................





[Non-text portions of this message have been removed]