Wed Sep 7 03:46:06 PDT 2005
- Previous message: [Slony1-general] Sequence replication
- Next message: [Slony1-general] Is non-sequential node numbering okay?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi All...
Well I have gone and screwed up my test cluster. I had a cluster running
that consisted of one origin feeding two subscribers, all on seperate
machines. One was connected with a private wire using fake net IPs while
the other was accross the Internet.
I issued a slonik script with this in it:
lock set (id = 1, origin = 1);
wait for event (origin = 1, confirmed = 2);
wait for event (origin = 1, confirmed = 3);
move set (id = 1, old origin = 1, new origin = 3);
wait for event (origin = 1, confirmed = 2);
wait for event (origin = 1, confirmed = 3);
This hung for quite a while so I aborted it. Now, none of the 3 nodes
thinks it is the origin.
Two questions. First, what is wrong with my script and second, is there a
way to gracefully recover from this condition? If this were to happen to
my production database I would be up the creek...
Thanks...
- Previous message: [Slony1-general] Sequence replication
- Next message: [Slony1-general] Is non-sequential node numbering okay?
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list