Home » Server Options » RAC & Failsafe » constraint violation using rac
constraint violation using rac [message #166234] Wed, 05 April 2006 06:04
mlysenko
Messages: 3
Registered: March 2006
Junior Member
Hi there,
I have to 2 oracle servers using shared storage and 2 application servers which are using instances rac1 and rac2. One app server send transaction to rac1 (e.g. create account, account username is primary key) , at the same time (or with 1 sec delay) another application server sends select account to rac2 -> result account not found and the app server 2 tries to create account with the same username and result is username_pk violoation. It seems that during very short period of time this username appears in storage and account creation by app server 2 fails with pk violation :/ Any idea what this can be fixed???

[Updated on: Wed, 05 April 2006 06:04]

Report message to a moderator

Previous Topic: Lod balancing in RAC
Next Topic: RAC Instance getting stuck at LCK0
Goto Forum:
  


Current Time: Wed Dec 08 04:43:50 CST 2021