I have been having a similar issue on a Windows 2003 Server running Firebird
1.5 RC9, and now upgraded to final. My application freezes, and that
database is effectively locked. Any connection attempts - whether from
IBExpert or our application (Delphi5 using ADO and IBProvider) - result in
the connecting app freezing. However, other databases on the same server
seem to be still accessable. And fbserver is not hogging cpu time. However,
if I try to stop the server, it remains in a 'waiting to close' state until
I terminate the service. There are no messages in the firebird log file.

Where should I begin to look to solve this?

Gabhan O'Loughlin
Input Systems

Get your safe spam protection at http://www.cloudmark.com/spamnetsig/

> -----Original Message-----
> From: James Armstrong [mailto:james@...]
> Sent: 27 February 2004 13:54
> To: firebird-support@yahoogroups.com
> Subject: [firebird-support] Still having lockups / gds32.dll
> waiting for object
>
> I have upgraded to Firebird 1.5 Final running on Windows
> 2003. I am still having this lockup shown below on a LOCAL connection.
>
> - James
>
> >From Devel Windows 2003 Server
>
>
> EurekaLog 4.5.0 RC 1
>
> Application:
> ------------------------------------------------------
> 1.1 Start Date : Fri, 27 Feb 2004 08:21:03 -500
> 1.2 Name/Description: TWR.EXE
> 1.3 Version Number :
> 1.4 Parameters :
>
> Exception:
> --------------------------------------------------
> 2.1 Date : Fri, 27 Feb 2004 08:36:32 -500
> 2.2 Address: 7FFE0304
> 2.3 Module :
> 2.4 Type : EFrozenApplication
> 2.5 Message: The application seems to be frozen.
>
> Active Controls:
> ---------------------------------------
> 3.1 Form Class : ConsoleWindowClass
> 3.2 Form Text : Command Prompt
> 3.3 Control Class:
> 3.4 Control Text :
>
> Computer:
> ---------------------------------
> 4.1 Name : HARK-WIN2003
> 4.2 User : Administrator
> 4.3 Total Memory: 255 Mb
> 4.4 Free Memory : 77 Mb
> 4.5 Total Disk : 2.01 Gb
> 4.6 Free Disk : 0.39 Gb
>
> 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| |
> |77F420C6|ntdll.dll | |
> |RtlLeaveCriticalSection | |
> |77F420C6|ntdll.dll | |
> |RtlLeaveCriticalSection | |
> |10014BC0|gds32.dll | |
> |isc_dsql_execute2_m | |
> |00580C71|TWR.EXE |IB_Components.pas|TIB_Connection
> |GetCharacteristics |16568|
> |005801CB|TWR.EXE |IB_Components.pas|TIB_Connection
> |GetSQLDialect |16398|
> |100149B0|gds32.dll | |
> |isc_dsql_execute2 | |
> |1001499B|gds32.dll | |
> |isc_dsql_execute | |
> |0059BAF6|TWR.EXE
> |IB_Components.pas|TIB_BindingCursor|QuickFetch |30606|
> |0059B8D0|TWR.EXE
> |IB_Components.pas|TIB_BindingCursor|QuickFetch |30551|
> |0059A9CB|TWR.EXE |IB_Components.pas|TIB_Dataset
> |InvalidateRows |29955|
> |0059A9AC|TWR.EXE |IB_Components.pas|TIB_Dataset
> |InvalidateRows |29951|
> |005C4872|TWR.EXE |IBODataset.pas |TIBODataset
> |InvalidateRows |5575 |
> |005C4860|TWR.EXE |IBODataset.pas |TIBODataset
> |InvalidateRows |5573 |
> |005C478B|TWR.EXE |IBODataset.pas |TIBODataset
> |RefreshRows |5546 |
> |005C477C|TWR.EXE |IBODataset.pas |TIBODataset
> |RefreshRows |5544 |
> |006731DC|TWR.EXE |TWR1.pas |TForm1
> |SecondTimerEventHandler |4639 |
> |004D7BC0|TWR.EXE |OvcTimer.pas |TOvcTimerPool
> |DoTriggerNotification |327 |
> |004D7EE1|TWR.EXE |OvcTimer.pas |TOvcTimerPool
> |tpTimerWndProc |639 |
> |77D07061|user32.dll| |
> |DispatchMessageA | |
> |77D0705B|user32.dll| |
> |DispatchMessageA | |
> |00693A2C|TWR.EXE |Twr.dpr | |twr
> |57 |
> |006938F5|TWR.EXE |Twr.dpr | |twr
> |37 |
> --------------------------------------------------------------
> ----------------------------
>
> Modules Information:
> --------------------------------------------------------------
> --------------------------------------------------------------
> ------------------------------------------------------------------
> |Handle |Name |Description
> |Version |Size |Path
> |
> --------------------------------------------------------------
> --------------------------------------------------------------
> ------------------------------------------------------------------
> |00400000|TWR.EXE |
> | |12932948|C:\TOWERMONITOR
> |
> |10000000|gds32.dll |Firebird SQL Server
> |6.3.0.4306 |356431 |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_6595b
> 64144ccf1df_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_6595b
> 64144ccf1df_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.0 |1187328 |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.0 |658944 |C:\WINDOWS\system32
> |
> |77D00000|user32.dll |Windows USER API Client DLL
> |5.2.3790.0 |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: 0000003A EDI: 7FFDE000
> EBX: 00000000 ESI: 100560B0
> ECX: 00000190 ESP: 0012FAF8
> EDX: 00000000 EIP: 7FFE0304
>
> Stack: Memory Dump:
> ------------------
> --------------------------------------------------------------
> -------------
> 0012FAF8: 77F43741 7FFE0304: C3 9C 81 0C 24 00 01 00 00 9D
> C3 90 90 90 90 90 ....$...........
> 0012FAFC: 77F5D64E 7FFE0314: 90 90 90 90 90 90 90 90 90 90
> 90 90 25 98 51 00 ............%.Q.
> 0012FB00: 00000198 7FFE0324: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB04: 00000000 7FFE0334: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB08: 00000000 7FFE0344: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB0C: 014871D4 7FFE0354: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB10: 02302178 7FFE0364: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB14: 023021B0 7FFE0374: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB18: 00000000 7FFE0384: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB1C: 00000000 7FFE0394: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB20: 00000000 7FFE03A4: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB24: 00000000 7FFE03B4: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB28: 00000014 7FFE03C4: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB2C: 0000007C 7FFE03D4: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB30: 00000000 7FFE03E4: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
> 0012FB34: 00000000 7FFE03F4: 00 00 00 00 00 00 00 00 00 00
> 00 00 00 00 00 00 ................
>
> =============================================================
> Second lockup on production system was similar, different
> calls to firebird. This one looks like the IB_Event Alerter
> checking for events to process.
>
> --------------------------------------------------------------
> ------------------
> |77F4373F|ntdll.dll | |
> |ZwWaitForSingleObject | |
> |77F43735|ntdll.dll | |
> |ZwWaitForSingleObject | |
> |77F5D649|ntdll.dll | |
> |RtlpWaitForCriticalSection| |
> |77F5D5C4|ntdll.dll | |
> |RtlpWaitForCriticalSection| |
> |77F45044|ntdll.dll | |
> |RtlExtendedMagicDivide | |
> |10016781|gds32.dll | |
> |isc_que_events | |
> |10016789|gds32.dll | |
> |isc_que_events | |
> |77F420C6|ntdll.dll | |
> |RtlLeaveCriticalSection | |
> |005D0843|TWR.EXE |Data1.pas
> |TDataModule2|IB_Events1EventAlert |732 |
> |005CA597|TWR.EXE |IB_Events.pas|TIB_Events
> |API_QueueEvents |803 |
> |005CA528|TWR.EXE |IB_Events.pas|TIB_Events
> |API_QueueEvents |795 |
> |005CA37C|TWR.EXE |IB_Events.pas|TIB_Events |CheckEvents
> |735 |
> |005CA138|TWR.EXE |IB_Events.pas|TIB_Events |CheckEvents
> |678 |
> |005CA130|TWR.EXE |IB_Events.pas|TIB_Events |ReceiveTimer
> |672 |
> |77D0FADF|user32.dll| |
> |DispatchMessageA | |
> |77D0FAD9|user32.dll| |
> |DispatchMessageA | |
> |00693448|TWR.EXE |Twr.dpr | |twr
> |57 |
> |00693311|TWR.EXE |Twr.dpr | |twr
> |37 |
> --------------------------------------------------------------
> ------------------
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~--> Buy Ink Cartridges or Refill Kits
> for your HP, Epson, Canon or Lexmark Printer at MyInks.com.
> Free s/h on orders $50 or more to the US & Canada.
> http://www.c1tracking.com/l.asp?cid=5511
> http://us.click.yahoo.com/mOAaAA/3exGAA/qnsNAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
>
> Yahoo! Groups Links
>
>
>
>
>