Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Errors 10249 & 10242 with v3.3
Wed, Jun 4 2008 3:07 PMPermanent Link

"keith crusius"
This client gets these locking errors consistenly.  Error 10249 is not
listed and error 10242 says it should never happen and to contact
ElevateSoft.  This is a local session (not client/server).  No transactions
are used. DBISAM v3.3.  Only 1 to 2 users.  No consistent sequence of events
or tables.  What should I look for?

------------------------------------------------------------
date/time         : 2008-04-28, 11:13:17, 422ms
operating system  : Windows NT New build 6000
exception number  : 5
exception class   : EDBISAMEngineError
exception message : DBISAM Engine Error # 10249 General lock failure with
the table 'IGNSettings'.

main thread ($109c):
006fe4d1 IGotNotices.exe DBISAMTb         DbiError
0068473e IGotNotices.exe dbisamen         RaiseError
0068da86 IGotNotices.exe dbisamen         TDataTable.ReadLockTable
0069f8be IGotNotices.exe dbisamen         TDataCursor.ReadLockTable
0069128c IGotNotices.exe dbisamen         TDataCursor.Refresh
00702a08 IGotNotices.exe DBISAMTb         TDBISAMDataSet.InternalRefresh
00705899 IGotNotices.exe DBISAMTb         TDBISAMTable.InternalRefresh
00513639 IGotNotices.exe DB               TDataSet.Refresh
00ccac0d IGotNotices.exe ignMainUnit 3180
TignMain.CheckUnlockCodeAndTerminateIfNecessary
00cca043 IGotNotices.exe ignMainUnit 2917 TignMain.tmrCheckMailTimer
004a1617 IGotNotices.exe ExtCtrls         TTimer.Timer
004a14fb IGotNotices.exe ExtCtrls         TTimer.WndProc
00476bc8 IGotNotices.exe Classes          StdWndProc
777f3c85 USER32.dll                       DispatchMessageA
004d7a58 IGotNotices.exe Forms            TApplication.ProcessMessage
004d7a92 IGotNotices.exe Forms            TApplication.HandleMessage
004d7cb2 IGotNotices.exe Forms            TApplication.Run
00cdf1b8 IGotNotices.exe IGotNotices  125 initialization
77563831 kernel32.dll                     BaseThreadInitThunk
77d7a9bb ntdll.dll                        LdrInitializeThunk

thread $1248:
77da0f34 ntdll.dll                 KiFastSystemCallRet
77da00ee ntdll.dll                 NtRemoveIoCompletion
77547942 kernel32.dll              GetQueuedCompletionStatus
0044aff9 IGotNotices.exe madExcept CallThreadProcSafe
0044b063 IGotNotices.exe madExcept ThreadExceptFrame
77563831 kernel32.dll              BaseThreadInitThunk
77d7a9bb ntdll.dll                 LdrInitializeThunk
>> created by thread $1650 at:
778ac20a RPCRT4.dll

---------------------------------------------------------------------------

date/time         : 2008-05-12, 11:12:33, 574ms
operating system  : Windows NT New build 6000
exception number  : 1
exception class   : EDBISAMEngineError
exception message : DBISAM Engine Error # 10242 Cannot unlock table or
record in the table 'IGNFolders'.

main thread ($178):
006fe4d1 IGotNotices.exe DBISAMTb        DbiError
0068473e IGotNotices.exe dbisamen        RaiseError
0068db34 IGotNotices.exe dbisamen        TDataTable.ReadUnlockTable
0068c9be IGotNotices.exe dbisamen        TDataTable.CloseTable
0068b5fb IGotNotices.exe dbisamen        TDataDirectory.CloseDataTable
00692ecb IGotNotices.exe dbisamen        TDataCursor.CloseCursor
007015e6 IGotNotices.exe DBISAMTb        TDBISAMDataSet.DestroyHandle
00705883 IGotNotices.exe DBISAMTb        TDBISAMTable.DestroyHandle
007015b7 IGotNotices.exe DBISAMTb        TDBISAMDataSet.CloseCursor
00704e91 IGotNotices.exe DBISAMTb        TDBISAMDBDataSet.CloseCursor
00510df3 IGotNotices.exe DB              TDataSet.SetActive
00510bad IGotNotices.exe DB              TDataSet.Close
00704f08 IGotNotices.exe DBISAMTb        TDBISAMDBDataSet.Disconnect
00700c63 IGotNotices.exe DBISAMTb        TDBISAMDatabase.CloseDataSets
00700c0b IGotNotices.exe DBISAMTb        TDBISAMDatabase.Close
006ff835 IGotNotices.exe DBISAMTb        TDBISAMSession.StartSession
006ff10d IGotNotices.exe DBISAMTb        TDBISAMSession.SetActive
006feb03 IGotNotices.exe DBISAMTb        TDBISAMSession.Destroy
00404694 IGotNotices.exe System       41 TObject.Free
006fe886 IGotNotices.exe DBISAMTb        TDBISAMSessionList.CloseAll
006fe7b5 IGotNotices.exe DBISAMTb        TDBISAMSessionList.Destroy
00404694 IGotNotices.exe System       41 TObject.Free
0070aea2 IGotNotices.exe DBISAMTb        Finalization
00405289 IGotNotices.exe System       41 FinalizeUnits
0044a624 IGotNotices.exe madExcept       InterceptFinalizeUnits
0040555e IGotNotices.exe System       41 @Halt0
00cdf1be IGotNotices.exe IGotNotices 126 initialization
76453831 kernel32.dll                    BaseThreadInitThunk
7776a9bb ntdll.dll                       LdrInitializeThunk

thread $1bc (TRecordCountThread):
004689e6 IGotNotices.exe Classes              TList.Get
00700c63 IGotNotices.exe DBISAMTb             TDBISAMDatabase.CloseDataSets
00aedbc2 IGotNotices.exe ignDmThread1Unit  77
TignDmThread1.DataModuleDestroy
0047688f IGotNotices.exe Classes              TDataModule.DoDestroy
00476763 IGotNotices.exe Classes              TDataModule.BeforeDestruction
00404aa1 IGotNotices.exe System            41 @BeforeDestruction
0047676e IGotNotices.exe Classes              TDataModule.Destroy
00404694 IGotNotices.exe System            41 TObject.Free
00458300 IGotNotices.exe SysUtils             FreeAndNil
00aee014 IGotNotices.exe ignThread1Unit   150 TRecordCountThread.Execute
00404eba IGotNotices.exe System            41 @HandleFinally
77791006 ntdll.dll                            RtlRaiseStatus
77752c46 ntdll.dll                            RtlUnwind
00404c7e IGotNotices.exe System            41 @HandleAnyException
00404a65 IGotNotices.exe System            41 @AfterConstruction
0045613b IGotNotices.exe SysUtils             Exception.CreateFmt
77791006 ntdll.dll                            RtlRaiseStatus
00404a65 IGotNotices.exe System            41 @AfterConstruction
006a7f3c IGotNotices.exe dbisamen             TRecord.Create
004071d8 IGotNotices.exe System            41 DynArraySetLength
00512db1 IGotNotices.exe DB                   TDataSet.GetPriorRecord
005130f2 IGotNotices.exe DB                   TDataSet.GetPriorRecords
00701cb5 IGotNotices.exe DBISAMTb             TDBISAMDataSet.GetPriorRecords
00512d30 IGotNotices.exe DB                   TDataSet.GetNextRecord
005134d3 IGotNotices.exe DB                   TDataSet.MoveBy
005135e4 IGotNotices.exe DB                   TDataSet.Next
00aede9c IGotNotices.exe ignThread1Unit   119 TRecordCountThread.Execute
0044b117 IGotNotices.exe madExcept            HookedTThreadExecute
00474e74 IGotNotices.exe Classes              ThreadProc
00405644 IGotNotices.exe System            41 ThreadWrapper
0044aff9 IGotNotices.exe madExcept            CallThreadProcSafe
0044b063 IGotNotices.exe madExcept            ThreadExceptFrame
76453831 kernel32.dll                         BaseThreadInitThunk
7776a9bb ntdll.dll                            LdrInitializeThunk
>> created by main thread ($178) at:
00aedcd6 IGotNotices.exe ignThread1Unit    69 TRecordCountThread.create

------------------------------------------------------------------------------

date/time         : 2008-05-29, 11:49:20, 280ms
operating system  : Windows NT New build 6000
system up time    : 8 hours 40 minutes
program up time   : 1 hour
exception number  : 1
exception class   : EDBISAMEngineError
exception message : DBISAM Engine Error # 10242 Cannot unlock table or
record in the table 'IGNUserLog'.

main thread ($964):
006fe4d1 IGotNotices.exe DBISAMTb         DbiError
0068473e IGotNotices.exe dbisamen         RaiseError
006d730b IGotNotices.exe dbisamlb         TFileHandler.Read
006a86a2 IGotNotices.exe dbisamen         TDataFile.ReadHeader
0068d24a IGotNotices.exe dbisamen         TDataTable.PerformChangeDetection
0068da94 IGotNotices.exe dbisamen         TDataTable.ReadLockTable
0069f8be IGotNotices.exe dbisamen         TDataCursor.ReadLockTable
006b0177 IGotNotices.exe dbisamen         TIndexFile.GetPage
0068e943 IGotNotices.exe dbisamen         TDataTable.GetPage
00693276 IGotNotices.exe dbisamen         TDataCursor.GetPage
0069a930 IGotNotices.exe dbisamen         TDataCursor.GotoFirstIndexPosition
0069a172 IGotNotices.exe dbisamen         TDataCursor.SetToBegin
0069201a IGotNotices.exe dbisamen         TDataCursor.OpenCursor
0070542a IGotNotices.exe DBISAMTb         TDBISAMTable.GetHandle
007055ee IGotNotices.exe DBISAMTb         TDBISAMTable.CreateHandle
00701510 IGotNotices.exe DBISAMTb         TDBISAMDataSet.OpenCursor
00704e81 IGotNotices.exe DBISAMTb         TDBISAMDBDataSet.OpenCursor
00510da1 IGotNotices.exe DB               TDataSet.SetActive
00510b99 IGotNotices.exe DB               TDataSet.Open
00870db8 IGotNotices.exe ignDmUnit   1119 TignDM.TmpTable
0087ef6e IGotNotices.exe ignDmUnit   5052 TignDM.UserLogUpdate
00cca64b IGotNotices.exe ignMainUnit 3052 TignMain.tmrUserLogTimer
004a1617 IGotNotices.exe ExtCtrls         TTimer.Timer
004a14fb IGotNotices.exe ExtCtrls         TTimer.WndProc
00476bc8 IGotNotices.exe Classes          StdWndProc
767b3831 kernel32.dll                     BaseThreadInitThunk
77baa9bb ntdll.dll                        LdrInitializeThunk

thread $1a8:
77bd0f34 ntdll.dll                 KiFastSystemCallRet
77bd00ee ntdll.dll                 NtRemoveIoCompletion
76797942 kernel32.dll              GetQueuedCompletionStatus
0044aff9 IGotNotices.exe madExcept CallThreadProcSafe
0044b063 IGotNotices.exe madExcept ThreadExceptFrame
767b3831 kernel32.dll              BaseThreadInitThunk
77baa9bb ntdll.dll                 LdrInitializeThunk
>> created by thread $844 at:
7697c20a RPCRT4.dll

-------------------------------------------------------------------------------

date/time         : 2008-06-03, 14:01:21, 258ms
operating system  : Windows NT New build 6000
system language   : English
system up time    : 5 days 10 hours
program up time   : 22 hours 12 minutes
exec. date/time   : 2008-04-02 14:56
exception number  : 1
exception class   : EDBISAMEngineError
exception message : DBISAM Engine Error # 10249 General lock failure with
the table 'IGNEvents'.

main thread ($14a4):
006fe4d1 IGotNotices.exe DBISAMTb                  DbiError
0068473e IGotNotices.exe dbisamen                  RaiseError
0068da86 IGotNotices.exe dbisamen                  TDataTable.ReadLockTable
0069f8be IGotNotices.exe dbisamen                  TDataCursor.ReadLockTable
006b0177 IGotNotices.exe dbisamen                  TIndexFile.GetPage
0068e943 IGotNotices.exe dbisamen                  TDataTable.GetPage
00693276 IGotNotices.exe dbisamen                  TDataCursor.GetPage
0069a930 IGotNotices.exe dbisamen
TDataCursor.GotoFirstIndexPosition
0069a172 IGotNotices.exe dbisamen                  TDataCursor.SetToBegin
0069201a IGotNotices.exe dbisamen                  TDataCursor.OpenCursor
0070542a IGotNotices.exe DBISAMTb                  TDBISAMTable.GetHandle
007055ee IGotNotices.exe DBISAMTb                  TDBISAMTable.CreateHandle
00701510 IGotNotices.exe DBISAMTb                  TDBISAMDataSet.OpenCursor
00704e81 IGotNotices.exe DBISAMTb
TDBISAMDBDataSet.OpenCursor
00510da1 IGotNotices.exe DB                        TDataSet.SetActive
00510b99 IGotNotices.exe DB                        TDataSet.Open
00870db8 IGotNotices.exe ignDmUnit            1119 TignDM.TmpTable
0087f90a IGotNotices.exe ignDmUnit            5180 TignDM.GetLastEventPK
008792f7 IGotNotices.exe ignDmUnit            3560 TignDM.ReFilterCalendar
00b66879 IGotNotices.exe ignFrameCalendarUnit 1190
TignFrameCalendar.tmrReloadTimer
00cca772 IGotNotices.exe ignMainUnit          3095
TignMain.btRefreshCalClick
00cca5ad IGotNotices.exe ignMainUnit          3031
TignMain.tmrRefreshCalTimer
004a1617 IGotNotices.exe ExtCtrls                  TTimer.Timer
004a14fb IGotNotices.exe ExtCtrls                  TTimer.WndProc
00476bc8 IGotNotices.exe Classes                   StdWndProc
767b3831 kernel32.dll                              BaseThreadInitThunk
77baa9bb ntdll.dll                                 LdrInitializeThunk
Thu, Jun 5 2008 6:58 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Keith,

<< This client gets these locking errors consistenly.  Error 10249 is not
listed and error 10242 says it should never happen and to contact
ElevateSoft.  This is a local session (not client/server).  No transactions
are used. DBISAM v3.3.  Only 1 to 2 users.  No consistent sequence of events
or tables.  What should I look for? >>

Is this code running okay elsewhere ?  Also, are the local sessions
accessing the data on a shared file server ?  If so, then what OS are all of
the machines using (I see WinNT for one, at least) ?

--
Tim Young
Elevate Software
www.elevatesoft.com

Thu, Jun 5 2008 10:09 PMPermanent Link

"keith crusius"
Yes, this program runs fine elsewhere in dozens of installations.  I'll find
out the answers to the other questions.
Image