[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference orarep::nomahs::repository

Title:Oracle CDD/Repositorynce
Notice:Current versions are V7.0-01 and V6.1-03eld Test 3
Moderator:8292::PJACOBN
Created:Thu Jan 21 1993
Last Modified:Fri Jun 06 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:1094
Total number of notes:4913

1047.0. "Locking problems even when using CDD$WAIT..." by ORAREP::TAV02::ARIE (Arie Blum - SI DEC-Israel) Thu Feb 06 1997 09:54

    Hello,

    CDD V6.1 ECO 2
    RDB V6.1
    Global Buffers is enabled with Page transfer VIA Memory (CDD$DATABASE).

    A customer is using a common repository with separate directories
    and each programmer is writing to his own directory.

    The problem is Locking when trying to Define / Delete Records and 
    Defining ACMS Tasks.

    He tried to use CDD$WAIT with EXCLUSIVE and we saw the Exclusive 
    transactions started (by using RDMS$DEBUG_FLAGS "T") but still gets 
    the following message when only four users are working in parallel :
    
       RDB-E-LOCK_CONFLICT, request failed due to locked resource.

    
    Is it a known problem ?

    We must find a solution....


    best regards


        Arie.
T.RTitleUserPersonal
Name		DateLines
1047.1ORAREP::TAV02::ARIEArie Blum - SI DEC-IsraelThu Feb 06 1997 10:0711
    more information : 

    The environment is Alpha 2100.


    best regards


        Arie.
1047.2NOVA::SMITHIDon't understate or underestimate Rdb!Thu Feb 06 1997 13:276
~       RDB-E-LOCK_CONFLICT, request failed due to locked resource.

This line should be followed by a secondary message showing the locked
resource name.  Do you have it?

Ian
1047.3ORAREP::TAV02::ARIEArie Blum - SI DEC-IsraelSun Feb 09 1997 06:1717
Hello Ian,

 Many thanks for the reply.

 After checking the procedures I found that after defining CDD 
 elements, there are also SHOW RECORDS commands which caused the problem
 (Read Only conflicts with Exclusive Write).

 Changing the CDD$WAIT value to PROTECTED solved the problem.

 best regards

 
  Arie.