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

Conference orarep::nomahs::dec_data_distributor

Title:The Replication Option for Rdb
Notice:Product renamed to Replication Option for Rdb
Moderator:BROKE::PROTEAU
Created:Wed Mar 02 1994
Last Modified:Wed Jun 04 1997
Last Successful Update:Fri Jun 06 1997
Number of topics:287
Total number of notes:1231

239.0. "DDD - Exclusive transactions?" by ORAREP::VAXRIO::63198::CSANTOS (Claudia Nogueira - CSC/Brazil) Fri Aug 23 1996 15:22


	Hi,


	Customer has a lot of database and some of them, when running 	
	RMU/VERIFY returns the following error:


%RMU-I-NODATANDX, no data records in index DDAL$DBKEY_INDEX1_24
%RMU-I-ENDNDXVER, completed verification of index DDAL$DBKEY_INDEX1_24
%RMU-I-BGNSEGPAG, beginning verification of RDB$SYSTEM storage area
%RMU-W-CANTSNAP, can't ready storage area 
DKA100:[REGAP.SNS61SIS.SNS61RDB]BDO_SE
TRAE.RDA;1 for snapshots
%RMU-E-BDLAREADY, error readying logical area with dbid 58
%RMU-W-CANTSNAP, can't ready storage area 
DKA100:[REGAP.SNS61SIS.SNS61RDB]BDO_SE
TRAE.RDA;1 for snapshots
%RMU-E-BDLAREADY, error readying logical area with dbid 58
%RMU-W-CANTSNAP, can't ready storage area 
DKA100:[REGAP.SNS61SIS.SNS61RDB]BDO_SE
TRAE.RDA;1 for snapshots
%RMU-E-BDLAREADY, error readying logical area with dbid 58



	The areas returning errors are the one with RDB$TRANSFER...
	Thsi error can be caused by exclusive transactions on that
	area...  The question is: DDD uses exclusive transactions?

	If not, does anyone have any idea on what could be causing 
	this error?


				Thanks

					Claudia
T.RTitleUserPersonal
Name		DateLines
239.1Yes -- exclusive transactionsBROKE::PROTEAUJean-Claude ProteauFri Aug 23 1996 16:483
    
    Yes, Claudia, DDD does use an exclusive transaction to update the
    RDB$TRANSFERS table.
239.2When it's updated ?ORAREP::VAXRIO::ABREUMon Aug 26 1996 16:168
    Hi Jean-Claude,
    
          When this table rdb$transfers is updated ? At the beginning and 
    at the end of the transfer ?
    
           Thanks .. Marcia 
    
    PS: Claudia is on vacation and I assumed her call.
239.3Here's what we doBROKE::PROTEAUJean-Claude ProteauTue Aug 27 1996 09:3217
    
    Marcia,
    
    The RDB$TRANSFERS table, during a replication update transfer, is
    updated just after all the changes in the RDB$CHANGES table are
    processed and just before the changes in the RDB$CHANGES table are
    erased.  This is done in three different transactions:
    
    1) read-only transaction to read from RDB$CHANGES
    
    2) exclusive write transaction to update the transfer's row in the
       RDB$TRANSFERS table
    
    3) read write transaction to erase records no longer needed in
       the RDB$CHANGES table
    
    Claude