| 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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
