473,625 Members | 2,600 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Replication conflicts

This question is aimed at users of replicated databases.

We have had recently a lot of Unique Key conflicts.
Where the big keys in the tables (cant remember name)
{1234-4321-1234-4321-1234}
which should have millions , if not billions of combinations is comming up
with duplicates.

i was wondering if anyone has this problem as mush as i have.
about 5 times in 2 years (which doesnt seems alot but surely should be
virtually non-exsistant)
but once it has happened once in a replica set, thats it. it starts
happening lots
Is there something that i am doing to instigate this ?

I usually just synconise all the replicas and the copy all the tables into a
new blank database then
make another replica set out of that. Which will usually fix the situation.
untill the next time .....

any thoughts / ideas?

Dave
Nov 12 '05 #1
2 1439
"Dave" <e@mail.co.uk > wrote:
This question is aimed at users of replicated databases.


If you don't get an answer here I'd suggest asking in the replication
newsgroup.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Nov 12 '05 #2
"Dave" <e@mail.co.uk > wrote in
news:c7******** **@hercules.bti nternet.com:
This question is aimed at users of replicated databases.

We have had recently a lot of Unique Key conflicts.
Where the big keys in the tables (cant remember name)
{1234-4321-1234-4321-1234}
which should have millions , if not billions of combinations is
comming up with duplicates.
First off, it's simply not possible to us GUIDs as primary key in an
Access application. Access simply can't handle them.

I've never used anything but Random Autonumbers as PKs in replicated
databases, and never once had a conflict from them.
i was wondering if anyone has this problem as mush as i have.
about 5 times in 2 years (which doesnt seems alot but surely
should be virtually non-exsistant)
but once it has happened once in a replica set, thats it. it
starts happening lots
Is there something that i am doing to instigate this ?
I think using GUIDs is a fundamental error to begin with.
I usually just synconise all the replicas and the copy all the
tables into a new blank database then
make another replica set out of that. Which will usually fix the
situation. untill the next time .....


Why did you choose GUIDs? Yes, the numeric space is much larger than
with Long Integers, but on a practical basis, it's not enough to
make a difference.

--
David W. Fenton http://www.bway.net/~dfenton
dfenton at bway dot net http://www.bway.net/~dfassoc
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

0
2293
by: Cherrish Vaidiyan | last post by:
Frank <fbortel@nescape.net> wrote in message news:<bqgb99$a04$1@news1.tilbu1.nb.home.nl>... > Cherrish Vaidiyan wrote: > > Hello, > > > > I have certain doubts regarding replication of Oracle 9i in Red Hat > > Linux 9. > > > > 1) I want to implement asynchronous/synchronous multimaster > > replication.I have heard about Replication Management Tool in OEM. > > What are the steps to be taken initailly for using Replication
6
2341
by: RdR | last post by:
Hi, Has anyone encountered infinite looping in Q Replication? This happens when I have a source DB2 table A going to a target DB2 table B, it also happens that the samne target table B is replicated back to source table A (true bi-directional replication scenario). Once I start replication on a master to master scenario the changes in A gets replicated to B but that change gets replicated back to A and so on creating an infinite loop. Is...
4
545
by: Andi Plotsky | last post by:
I need to synchronize 3 databases (1 Master and 2 replicas). I thought I'd give the Replica feature in Access2000 a whirl. I'm not sure I'm THAT impressed.....but maybe I'm just doing something wrong. I'll outline the issues below and then maybe someone who has experience with replicating this way can tell me if this is the route I should take, or if I should just use my own routine which compares strings for each field. 1) I've...
1
1827
by: Andrew Chanter | last post by:
I developed 3 different replicated database applications in MS Access for 3 different corporate clients in Access 97 several years ago to enable data to be shared across wide area networks. I observed 2 issues that plagued all 3 systems. 1. the database files continually became corrupt during synchronization. Most times this was easily fixed via a repair and compact, but the frequency with which this occurred was of concern, and...
3
2411
by: dlesandrini | last post by:
I need advice about my decision to go with Replication in general. This post was placed on the Microsoft Replication newsgroup, but I really value the feedback that comes from this group as well. I have a new client who want their Excel data moved to Access. They have only 4-6 users of this data and a couple of them want to work disconnected, with their laptops and synchronize when they come into the office. The database will be...
56
5947
by: Raphi | last post by:
Hi, I've been using an Access application I wrote for an office with the front-end stored on all computers and the back-end on one of them serving as an Access file server. Now we're moving to a 2nd office 15 minutes down the road. Only one office will be open at a time, so theoretically it'd be possible to copy the back-end manually every night from one office to another, but frankly, that's pretty annoying.
6
7469
by: John | last post by:
Hi I have a front-end/back-end access app. I have created a replication set between the backend on a server an the backend on a laptop. My question is; How can I cause the synchronisation to happen via code? Basically I need to give the user an option to press a button (or menu option) on the laptop when the laptop is connected to the server/network for synchronisation to happen. Thanks
0
1522
by: John | last post by:
Hi Access 200. I have a replica and its associated master. When I try to open any of these dbs, I get the message "This member of the replica set has conflicts from synchronizing changes with other members. Do you want to resolve these conflicts now?". When I select 'Yes', I get the below message. Basically the conflict revolver is not coming up so I can't view and resolve the conflicts. What is the problem and how can I fix it? This...
1
1817
by: John | last post by:
Hi When I try to resolve replication conflicts, first of all 'Microsoft Replication Conflict Viewer' gets stuck for 15-20 seconds then it gives the error 'There was an error trying to obtain data for a specific conflict table for 'MyTable'. The viewer can not display this conflict.". In the log file I get the following two types of entries; Database Publication Table Origin_DataSource RowGuidValue conflict_type reason_text
5
1593
by: ken | last post by:
Hi, I set up replication with a Frontend/Backend database set up. I noticed that when I sync the master with the replica in the same folder where I set up the replication, everything works fine and when I test for conflicts I get what I expect. However if I change the folder to say Copy of Folder when I sync the master automatically wins all conflicts without asking me, for all tables except 1. I find this very unusual. Are there...
0
8251
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8688
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8635
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8494
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
1
6115
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4085
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
1
2614
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1800
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
2
1496
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.