Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Next »

The default global setting for conflicts is "retry". This means that the operation will keep trying the operation until a manual change is made on the target to resolve the conflict.

The default global setting for a conflict can be changed with the SET_CONFLICT_HANDLERS FOR DEFAULT command. See the Command Reference or use HELP SET_CONFLICT_HANDLERS for the exact syntax.

Example:

 

dbvrep> SET_CONFLICT_HANDLERS FOR DEFAULT FOR UPDATE ON DATA TO OVERWRITE

This sets the default conflict handler for updates to overwrite.

To show the default global conflict handlers use the SHOW_CONFLICT_HANDLERS command:

 

dbvrep> SHOW_CONFLICT_HANDLERS FOR DEFAULT
The default handling is set as follows:
UPDATE (error): handler: RETRY logging: LOG
UPDATE (data): handler: OVERWRITE logging: LOG
DELETE (error): handler: RETRY logging: LOG
DELETE (data): handler: RETRY logging: LOG
INSERT (error): handler: RETRY logging: LOG
TRANSACTION (error): handler: RETRY logging: LOG

This shows the default conflict handler for updates to overwrite.

 

Note:

  1. When the default global handlers are updated, this will only apply to newly prepared tables. Tables that have already been prepared (or replicated) will still use the previous defined default global handler. 
  • No labels