Deadlock situation

[Cesar Baquerizo]

Kenneth Brody wrote:
>
> That error indicates one of two possible scenarios:
>
> 1 - A true deadlock situation would have occurred.  For example, I 
> have record
>     1 locked, and you have record 2 locked.  I attempt to lock record 
> 2, which
>     means I will wait until you unlock it.  Then, you attempt to lock 
> record 1.
>     Because you need to wait for me to unlock it, but I'm already 
> waiting for
>     you, if this were allowed, we would both wait forever.
>
> 2 - There are too many locks system-wide.
>
Everyone, thanks for the responses.  Unfortunately I am still having 
trouble.  A little more info:

1.   Just migrated to openserver 6 using Filepro V 4.5
2.   I ran the process with no one else logged on, and still the same thing
3.   I also tried the suggestion to change the alias (interestingly 
enough it ran through more records)
4.   All processing below pretty simple.

The error simply "pops up", and I have no way of seeing the record 
number that it is processing.  Anyway to do this?
Also, I found some rpa* files in the /tmp directory.  I have a vague 
recollection of rpa* files.  Anyone know what causes them?

Thanks again,

     ■ If: 21 eq 
""                                                          ■
       Then: 
end                                                               ■
  2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ 
If:                                                                   ■
       Then: 
ke(23,*)=2&4                                                      ■
  3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ 
If:                                                                   ■
       Then: lookup apen = mropenitems  k=ke   i=F 
-nx                         ■
  4  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: not 
apen                                                          ■
       Then: show  "Timesheet not found" & 2 
;end                              ■
  5  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: 3 ne 
"RSW"                                                        ■
       Then: apen(7)=apen(7)+ 7 ; oa(14,.4) = 
apen(6)                          ■
  6  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: 3 eq 
"RSW"                                                        ■
       Then: apen(7)=apen(7)- 7 ; oa = 
apen(6)                                

  7    ■ If: apen(8) eq 
"Y"                                                    ■
       Then: 
end                                                               ■
  8  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: oa eq 
"0"                                                         ■
       Then: 
apen(8)="Y";apen(6)="0";end                                       ■
  9  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: oa gt 
7                                                           ■
       Then: apen(6)=apen(6) - 7 
;qt(14,.4)=7                                  ■
 10  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: 7 ge 
oa                                                           ■
       Then: 
apen(6)="0";qt=oa                                                 ■
 11  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ 
If:                                                                   ■
       Then: lookup mrinvmaster  k=4    i=A 
-nx                                ■
 12  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ■ If: not 
mrinvmaster                                                   ■
       Then: show "Item not found" & 4 ;end               
    
 13      ■ 
If:                                                                   ■
       Then: mrinvmaster(3)=mrinvmaster(3)-qt