Tim

I've had the above error twice in the last two days. I've just spent an hour trying to replicate it but can't. I think its something to with full text indexing, multi threading and OnTextIndex event but I can't prove it.

Any suggestions?


Roy Lambert

date/time         : 2006-01-10, 08:06:26, 953ms
computer name     : HP
user name         : Roy Lambert
operating system  : Windows XP Service Pack 2 build 2600
system language   : English
system up time    : 7 minutes 52 seconds
program up time   : 25 seconds
processors        : 2x Intel(R) Pentium(R) 4 CPU 3.20GHz
physical memory   : 306/510 MB (free/total)
free disk space   : (C8.94 GB (D9.03 GB
display mode      : 1440x900, 32 bit
process id        : $324
allocated memory  : 15.33 MB
executable        : TMaN.exe
exec. date/time   : 2005-12-22 11:32
version           : 0.0.0.283
madExcept version : 2.7g
exception class   : EDBISAMEngineError
exception message : DBISAM Engine Error # 10242 Cannot unlock the table or record in the table 'MandN'.

thread $46c (TbgMgr): <priority:2>
0066c87a TMaN.exe
>> created by main thread ($6d0) at:
007ce05f TMaN.exe

main thread ($6d0):
7c90eb94 ntdll.dll   KiFastSystemCallRet
77d4d825 user32.dll  UpdateWindow

thread $3e8 (TDummyThread): <suspended>
7c810856 kernel32.dll
>> created by main thread ($6d0) at:
00724d55 TMaN.exe     

thread $43c (TbgMgr): <priority:2>
7c90eb94 ntdll.dll     KiFastSystemCallRet
7c90e286 ntdll.dll     NtReadFile
7c80186f kernel32.dll  ReadFile
>> created by main thread ($6d0) at:
007ce05f TMaN.exe     

thread $6f8:
>> stack not accessible

thread $60c (TbgMgr): <priority:2>
7c90eb94 ntdll.dll  KiFastSystemCallRet
7c91a3f2 ntdll.dll  RtlAnsiCharToUnicodeChar
>> created by main thread ($6d0) at:
007ce05f TMaN.exe  

modules:
00400000 TMaN.exe     0.0.0.283      D:\MandN
10000000 ndpwsspr.dll 2.10.0.386     C:\Program Files\InDefense\MailDefense
20000000 xpsp2res.dll 5.1.2600.2180  C:\WINDOWS\system32
5d090000 comctl32.dll 5.82.2900.2180 C:\WINDOWS\system32
5edd0000 olepro32.dll 5.1.2600.2180  C:\WINDOWS\system32
63000000 SynTPFcs.dll 7.12.7.0       C:\WINDOWS\system32
662b0000 hnetcfg.dll  5.1.2600.2180  C:\WINDOWS\system32
71a50000 mswsock.dll  5.1.2600.2180  C:\WINDOWS\System32
71a90000 wshtcpip.dll 5.1.2600.2180  C:\WINDOWS\System32
71aa0000 WS2HELP.dll  5.1.2600.2180  C:\WINDOWS\system32
71ab0000 WS2_32.dll   5.1.2600.2180  C:\WINDOWS\system32
71ad0000 wsock32.dll  5.1.2600.2180  C:\WINDOWS\system32
73000000 winspool.drv 5.1.2600.2180  C:\WINDOWS\system32
763b0000 comdlg32.dll 6.0.2900.2180  C:\WINDOWS\system32
76b40000 winmm.dll    5.1.2600.2180  C:\WINDOWS\system32
76f20000 DNSAPI.dll   5.1.2600.2180  C:\WINDOWS\system32
76fc0000 rasadhlp.dll 5.1.2600.2180  C:\WINDOWS\system32
77120000 oleaut32.dll 5.1.2600.2180  C:\WINDOWS\system32
773d0000 comctl32.dll 6.0.2900.2180  C:\WINDOWS\WinSxS\x86_Microsoft.Windows.Common-Controls_6595b64144ccf1df_6.0.2600.2180_x-ww_a84f1ff9
774e0000 ole32.dll    5.1.2600.2595  C:\WINDOWS\system32
77c00000 version.dll  5.1.2600.2180  C:\WINDOWS\system32
77c10000 msvcrt.dll   7.0.2600.2180  C:\WINDOWS\system32
77d40000 user32.dll   5.1.2600.2622  C:\WINDOWS\system32
77dd0000 advapi32.dll 5.1.2600.2180  C:\WINDOWS\system32
77e70000 RPCRT4.dll   5.1.2600.2180  C:\WINDOWS\system32
77f10000 GDI32.dll    5.1.2600.2180  C:\WINDOWS\system32
77f60000 SHLWAPI.dll  6.0.2900.2627  C:\WINDOWS\system32
77fe0000 Secur32.dll  5.1.2600.2180  C:\WINDOWS\system32
7c800000 kernel32.dll 5.1.2600.2180  C:\WINDOWS\system32
7c900000 ntdll.dll    5.1.2600.2180  C:\WINDOWS\system32
7c9c0000 shell32.dll  6.0.2900.2620  C:\WINDOWS\system32

hardware:
+ Batteries
 - Microsoft AC Adapter
 - Microsoft ACPI-Compliant Control Method Battery
+ Computer
 - ACPI Multiprocessor PC
+ Disk drives
 - IC25N060ATMR04-0
+ Display adapters
 - ATI MOBILITY RADEON X300 (driver 6.14.10.6476)
+ DVD/CD-ROM drives
 - TSSTcorp CD/DVDW TS-L532A
+ IDE ATA/ATAPI controllers
 - Intel(R) 82801FB/FBM Ultra ATA Storage Controllers - 266F (driver 6.1.0.1004)
 - Primary IDE Channel
+ IEEE 1394 Bus host controllers
 - Texas Instruments OHCI Compliant IEEE 1394 Host Controller
+ Keyboards
 - Quick Launch Buttons (driver 4.20.1.3)
+ Mice and other pointing devices
 - Synaptics PS/2 Port TouchPad (driver 7.12.7.0)
+ Modems
 - Conexant Data Fax Modem with SmartCP (driver 7.20.0.0)
+ Monitors
 - Default Monitor
 - Default Monitor
 - Plug and Play Monitor
+ Network adapters
 - 1394 Net Adapter
 - Realtek RTL8139/810x Family Fast Ethernet NIC (driver 5.612.628.2004)
+ PCMCIA adapters
 - Texas Instruments PCIxx21/x515 Cardbus Controller
+ PCMCIA and Flash memory devices
 - Texas Instruments PCIxx21 Integrated FlashMedia Controller (H) (driver 1.3.30.300)
+ Processors
 - Intel(R) Pentium(R) 4 CPU 3.20GHz
 - Intel(R) Pentium(R) 4 CPU 3.20GHz
+ Secure Digital host controllers
 - SDA Standard Compliant SD Host Controller
+ Sound, video and game controllers
 - Audio Codecs
 - Conexant AC-97 Audio (driver 6.14.10.8380)
 - Legacy Audio Drivers
 - Legacy Video Capture Devices
 - Media Control Devices
 - Video Codecs
+ System devices
 - ACPI Fixed Feature Button
 - ACPI Lid
 - ACPI Power Button
 - ACPI Sleep Button
 - ACPI Thermal Zone
 - Direct memory access controller
 - Intel(R) 82801 PCI Bridge - 244E (driver 6.0.0.1013)
 - Intel(R) 82801FB LPC Interface Controller - 2640 (driver 6.0.0.1013)
 - Intel(R) 82801FB/FBM PCI Express Root Port - 2660 (driver 6.0.0.1013)
 - Intel(R) 82801FB/FBM SMBus Controller - 266A (driver 6.0.0.1013)
 - Intel(R) 915G/P/GV PCI Express Root Port - 2581 (driver 6.0.0.1011)
 - Intel(R) 915G/P/GV Processor to I/O Controller - 2580 (driver 6.0.0.1011)
 - ISAPNP Read Data Port
 - Microcode Update Device
 - Microsoft ACPI-Compliant Embedded Controller
 - Microsoft ACPI-Compliant System
 - Microsoft Composite Battery
 - Microsoft System Management BIOS Driver
 - Microsoft Windows Management Interface for ACPI
 - Motherboard resources
 - Motherboard resources
 - Numeric data processor
 - PCI bus
 - Plug and Play Software Device Enumerator
 - Programmable interrupt controller
 - System CMOS/real time clock
 - System speaker
 - System timer
 - Terminal Server Keyboard Driver
 - Terminal Server Mouse Driver
 - Volume Manager
+ Universal Serial Bus controllers
 - Intel(R) 82801FB/FBM USB Universal Host Controller - 2658 (driver 6.0.0.1011)
 - Intel(R) 82801FB/FBM USB Universal Host Controller - 2659 (driver 6.0.0.1011)
 - Intel(R) 82801FB/FBM USB Universal Host Controller - 265A (driver 6.0.0.1011)
 - Intel(R) 82801FB/FBM USB Universal Host Controller - 265B (driver 6.0.0.1011)
 - Intel(R) 82801FB/FBM USB2 Enhanced Host Controller - 265C (driver 6.0.0.1011)
 - USB Root Hub
 - USB Root Hub
 - USB Root Hub
 - USB Root Hub
 - USB Root Hub

disassembling:
0066c87a sub_66c87a:                      ; function entry point
0066c87a > pop     ebx
0066c87b   ret

Roy,

<< I've had the above error twice in the last two days. I've just spent an
hour trying to replicate it but can't. I think its something to with full
text indexing, multi threading and OnTextIndex event but I can't prove it.
>>

Is this the same one you were getting before ?

--
Tim Young
Elevate Software
www.elevatesoft.com

I got the same error in my program today as well. My orders table was locked and I couldn't add a new order to it using the program.
However, I was able to manually add a blank order using database system manager without any error messages.


Garik

Tim


I think so, but I have no way of proving or disproving that.  Also I tried to "rewind" to before I'd downloaded the days posts to replicate it, and to save me having to spend 3+ hours repairing after deleting things is DBSys (because of the custom fti stuff) I also deleted everything prior to 2005 and couldn't get it to occur again. I'm not sure it would even if I went through the hassle of just deleting a couple of days worth and redownloaded.


Roy Lambert

"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote on Tue, 10 Jan 2006 19:45:50 -0500

>Roy,
>
><< I've had the above error twice in the last two days. I've just spent an
>hour trying to replicate it but can't. I think its something to with full
>text indexing, multi threading and OnTextIndex event but I can't prove it.
> >>
>
>Is this the same one you were getting before ?
>
>--
>Tim Young
>Elevate Software
>www.elevatesoft.com
>
>

Garik,

<< I got the same error in my program today as well. My orders table was
locked and I couldn't add a new order to it using the program.
However, I was able to manually add a blank order using database system
manager without any error messages. >>

Sometimes this error can prevent you from moving away from the current
record because DBISAM keeps trying to unlock a record that isn't locked to
begin with (which is the actual problem and is sometimes caused by 3rd party
controls).  The only solution in that case is to terminate the application.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< I think so, but I have no way of proving or disproving that. Also I tried
to "rewind" to before I'd downloaded the days posts to replicate it, and to
save me having to spend 3+ hours repairing after deleting things is DBSys
(because of the custom fti stuff) I also deleted everything prior to 2005
and couldn't get it to occur again. I'm not sure it would even if I went
through the hassle of just deleting a couple of days worth and redownloaded.
>>

Unfortunately, it's apparently not something that is particularly easy to
reproduce since I've not received any reports of it here.  I guess we'll
have to keep our eyes open for now.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,
Does this mean I have to ask everyone using the program to shut it down in order to fix this issue?
Is there a way to detect what user is causing this issue? I have the program running in a network with about 10-12 users (peer-to-peer mode).
Btw, I use Developer Exporess components - are there any known problems with these controls that could cause such a problem with dbisam?
Thanks,

Garik




"Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote:

Sometimes this error can prevent you from moving away from the current
record because DBISAM keeps trying to unlock a record that isn't locked to
begin with (which is the actual problem and is sometimes caused by 3rd party
controls).  The only solution in that case is to terminate the application.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim


Yup I'll just hope suddenly everyone suffers from it

Roy Lambert

Garik,

<< Does this mean I have to ask everyone using the program to shut it down
in order to fix this issue? >>

Well, the fix is to find the source of the problem, which as I stated, has
normally been funky 3rd party controls.

<< Is there a way to detect what user is causing this issue? I have the
program running in a network with about 10-12 users (peer-to-peer mode).
Btw, I use Developer Exporess components - are there any known problems with
these controls that could cause such a problem with dbisam? >>

Yes, we have had issues with the DevEx components doing things with the
record buffers that cause DBISAM to try to unlock the incorrect record.  Can
you reproduce the issue ?  If so, then if you can send me a sample of what
is going on along with the DevEx version number, etc., I can try and figure
out a workaround here.

--
Tim Young
Elevate Software
www.elevatesoft.com

Roy,

<< Yup I'll just hope suddenly everyone suffers from it >>

That's usually the best scenario since we can then triangulate the problem
from different viewpoints and come up with the common elements.

--
Tim Young
Elevate Software
www.elevatesoft.com