Subject Re: [IBO] Application freezing
Author Rohit Gupta
Jason, Daniel

Here is the dump from Madexcept.

It took 19 hrs of running before it cracked. I will have a look at the
source myself later. Is thre anyting I can provide further to find what
the proboem may be.

date/time : 2004-02-07 18:34
computer name : RG1
user name : Rohit
operating system : Windows 2000 Service Pack 4 build 2195
system language : English
system up time : 19 hours 11 minutes
physical memory : 33·511 MB (free/total)
free disk space : (E:) 15.71 GB (C:) 7.45 GB
process id : $674
command line : "C:\vl2beta\VL2BKGND.exe" C:\VL2BETA\ C:\VL2BETA\DATA
C:\VL2BETA\DATA /PErmanent
executable : VL2BKGND.exe
exec. date/time : 2004-02-06 00:54
madExcept version : 2.6a
exception message : The application seems to be frozen.

main thread ($844):
77f9323e ntdll.dll NtWaitForMultipleObjects
7c4ebdd5 kernel32.dll WaitForMultipleObjectsEx
7c4fabf6 kernel32.dll WaitForMultipleObjects
0190f6e2 fbclient.dll gds__thread_enter
0191590f fbclient.dll isc_dsql_free_statement
004f37ad VL2BKGND.exe IB_Components TIB_Dataset.API_CloseCursor
004f1083 VL2BKGND.exe IB_Components TIB_Dataset.SysClose
005509b5 VL2BKGND.exe IBODataset TIBOInternalDataset.SysClose
004f053e VL2BKGND.exe IB_Components TIB_Dataset.Close
0054d919 VL2BKGND.exe IBODataset TIBODataset.InternalClose
00499b57 VL2BKGND.exe Db TDataSet.CloseCursor
0054d8ca VL2BKGND.exe IBODataset TIBODataset.CloseCursor
00499a2f VL2BKGND.exe Db TDataSet.SetActive
0049988c VL2BKGND.exe Db TDataSet.Close
005526cf VL2BKGND.exe RGIBDB TRGIBDatabase.Field_Exists
0057d16c VL2BKGND.exe RgDb TRGTable.DoBeforePrepare
005db4a5 VL2BKGND.exe CFLTable TtblNormal_.DoBeforePrepare
00550773 VL2BKGND.exe IBODataset TIBOInternalDataset.SysBeforePrepare
004e7f67 VL2BKGND.exe IB_Components TIB_Statement.SysExecPrepare
004e7e78 VL2BKGND.exe IB_Components TIB_Statement.SysPrepare
004f18ae VL2BKGND.exe IB_Components TIB_Dataset.SysPrepare
004e70b4 VL2BKGND.exe IB_Components TIB_Statement.Prepare
005476bd VL2BKGND.exe IBODataset TIBODataset.InternalInitFieldDefs
00499b0a VL2BKGND.exe Db TDataSet.OpenCursor
00499c31 VL2BKGND.exe Db TDataSet.InitFieldDefs
0048ea0f VL2BKGND.exe Db TDefCollection.UpdateDefs
0048f524 VL2BKGND.exe Db TFieldDefs.Update
005458f4 VL2BKGND.exe IBODataset TIBODataset.UpdateIndexDefs
0048ea0f VL2BKGND.exe Db TDefCollection.UpdateDefs
0049696d VL2BKGND.exe Db TIndexDefs.Update
0057cd00 VL2BKGND.exe RgDb TRGTable.Find_Primary_Key
005db6b8 VL2BKGND.exe CFLTable TtblNormal_.Fix_Reserved_Records
00642029 VL2BKGND.exe Bkg_Rsvd Fix_It 006421d5 VL2BKGND.exe Bkg_Rsvd
Do_Report
006422c0 VL2BKGND.exe Bkg_Rsvd Do_One_Pass
0064247e VL2BKGND.exe Bkg_Rsvd Auto_Check_Reserved_Records
0069c7ee VL2BKGND.exe Bkg_Main Tfrm_Bkg_Main.Auto_Update
0069bdc1 VL2BKGND.exe Bkg_Main Tfrm_Bkg_Main.btnProcessClick
004571be VL2BKGND.exe Controls TControl.Click
0044ef28 VL2BKGND.exe StdCtrls TButton.Click
004a04fd VL2BKGND.exe Buttons TBitBtn.Click
004b41db VL2BKGND.exe RgCtrls TLogicalBtn.Click
0069c2c5 VL2BKGND.exe Bkg_Main Tfrm_Bkg_Main.AppOnIdle
004763d2 VL2BKGND.exe Forms TApplication.Idle
00475bd7 VL2BKGND.exe Forms TApplication.HandleMessage
00475dbd VL2BKGND.exe Forms TApplication.Run
0069e83e VL2BKGND.exe Vl2BkGnd EntryPoint

thread $80c:
77f9323e ntdll.dll NtWaitForMultipleObjects
7c4ebdd5 kernel32.dll WaitForMultipleObjectsEx
7c4fabf6 kernel32.dll WaitForMultipleObjects

modules:
00400000 VL2BKGND.exe C:\vl2beta
01750000 RTSUltraMonHook.dll 2.4.21.0 E:\Program Files\UltraMon
017c0000 IKEYRFK8.DLL E:\PROGRA~1\AOpen\Keyboard
018f0000 gds32.dll 6.3.0.4027 E:\WINNT\system32
01900000 fbclient.dll 1.5.0.4231 E:\Program Files\FIREBIRD_15\bin
01f10000 Amhooker.dll E:\WINNT\system32
10000000 nView.dll 6.14.10.4403 E:\WINNT\system32
51000000 DDRAW.dll 5.3.0.900 E:\WINNT\system32
5d300000 hhctrl.ocx 5.2.3735.1 E:\WINNT\system32
690a0000 PSAPI.DLL 5.0.2134.1 E:\WINNT\system32
695e0000 OLEPRO32.DLL 5.0.4522.0 E:\WINNT\system32
6e420000 INDICDLL.dll 5.0.2920.0 E:\WINNT\system32
70bd0000 SHLWAPI.DLL 6.0.2800.1106 E:\WINNT\system32
71710000 comctl32.dll 5.81.4916.400 E:\WINNT\system32
728a0000 DCIMAN32.dll 5.0.2180.1 E:\WINNT\system32
74fd0000 msafd.dll 5.0.2195.6602 E:\WINNT\system32
75010000 wshtcpip.dll 5.0.2195.6601 E:\WINNT\System32
75020000 WS2HELP.DLL 5.0.2134.1 E:\WINNT\system32
75030000 WS2_32.DLL 5.0.2195.6601 E:\WINNT\system32
75050000 wsock32.dll 5.0.2195.6603 E:\WINNT\system32
75150000 SAMLIB.DLL 5.0.2195.6666 E:\WINNT\System32
75160000 ntlanman.dll 5.0.2195.6601 E:\WINNT\System32
75170000 NETAPI32.DLL 5.0.2195.6601 E:\WINNT\System32
751c0000 NETRAP.DLL 5.0.2134.1 E:\WINNT\System32
751d0000 NETUI1.DLL 5.0.2134.1 E:\WINNT\System32
75210000 NETUI0.DLL 5.0.2195.6601 E:\WINNT\System32
752f0000 oledlg.dll 5.0.2134.1 E:\WINNT\system32
759b0000 LZ32.DLL 5.0.2195.6611 E:\WINNT\system32
75e60000 IMM32.dll 5.0.2195.6655 E:\WINNT\system32
76620000 mpr.dll 5.0.2195.6611 E:\WINNT\system32
76b20000 RICHED32.DLL 5.0.2134.1 E:\WINNT\system32
76b30000 comdlg32.dll 5.0.3700.6693 E:\WINNT\system32
772b0000 RICHED20.DLL 5.30.23.1215 E:\WINNT\system32
77320000 MPRAPI.DLL 5.0.2181.1 E:\WINNT\system32
77340000 iphlpapi.dll 5.0.2195.6602 E:\WINNT\system32
77360000 DHCPCSVC.DLL 5.0.2195.6685 E:\WINNT\system32
77380000 ADSLDPC.DLL 5.0.2195.6701 E:\WINNT\system32
773b0000 ACTIVEDS.DLL 5.0.2195.6601 E:\WINNT\system32
774c0000 RASMAN.DLL 5.0.2195.6604 E:\WINNT\system32
774e0000 RASAPI32.DLL 5.0.2195.6625 E:\WINNT\system32
77520000 ICMP.DLL 5.0.2134.1 E:\WINNT\system32
77530000 TAPI32.DLL 5.0.2195.6664 E:\WINNT\system32
77570000 winmm.dll 5.0.2161.1 E:\WINNT\system32
777e0000 winrnr.dll 5.0.2160.1 E:\WINNT\System32
777f0000 rasadhlp.dll 5.0.2168.1 E:\WINNT\system32
77800000 winspool.drv 5.0.2195.6659 E:\WINNT\system32
77820000 version.dll 5.0.2195.6623 E:\WINNT\system32
77830000 RTUTILS.DLL 5.0.2168.1 E:\WINNT\system32
77880000 SETUPAPI.DLL 5.0.2195.6622 E:\WINNT\system32
77950000 WLDAP32.DLL 5.0.2195.6666 E:\WINNT\system32
77980000 DNSAPI.DLL 5.0.2195.6680 E:\WINNT\System32
779b0000 oleaut32.dll 2.40.4522.0 E:\WINNT\system32
77a50000 ole32.dll 5.0.2195.6810 E:\WINNT\system32
77d30000 RPCRT4.DLL 5.0.2195.6802 E:\WINNT\system32
77e10000 user32.dll 5.0.2195.6688 E:\WINNT\system32
77f40000 GDI32.DLL 5.0.2195.6660 E:\WINNT\system32
77f80000 ntdll.dll 5.0.2195.6685 E:\WINNT\system32
78000000 msvcrt.dll 6.1.9844.0 E:\WINNT\system32
780c0000 MSVCP60.dll 6.0.8972.0 E:\WINNT\system32
782c0000 rnr20.dll 5.0.2195.6603 E:\WINNT\System32
782f0000 shell32.dll 5.0.3700.6705 E:\WINNT\system32
7c0f0000 USERENV.DLL 5.0.2195.6711 E:\WINNT\system32
c2d0000 advapi32.dll 5.0.2195.6710 E:\WINNT\system32
7c340000 SECUR32.DLL 5.0.2195.6695 E:\WINNT\System32
7c4e0000 kernel32.dll 5.0.2195.6688 E:\WINNT\system32

disassembling:
77f93233 public NtWaitForMultipleObjects: ; function entry point
77f93233 mov eax, $e9
77f93238 lea edx, [esp+4]
77f9323c int $2e
77f9323e » ret $14




IB Objects wrote:

> > But it works sometimes before freezing. There is no pattern to it. The
> > table is a small one with about 200 records.
>
> What is the CPU usage of the frozen process?
> How about disk activity?
> How about virtual memory usage?
>
> Can you pinpoint where in your code this is happening? (Do a log file if
> necessary please.)
>
> Jason Wharton
> www.ibobjects.com
>
>