Fri Jun 6 06:23:52 PDT 2008
- Previous message: [Slony1-general] MOVE SET should warn that it proceeeds async...
- Next message: [Slony1-general] Re: MOVE SET should warn that it proceeeds async...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Hi Marcin, could you test one thing as well see if you get same problem as I had (a few threads down) if you try to issue "slonik_drop_node" on your previous master node does it work? mine didn't as its claiming its still used, but maybe its the same problem as you had and its just taking LONG to change the subscription on my second slave... but I think i let it sit for some time... Marcin Kasperski wrote: > Well, I had my moment of doubt. > > I configured simple replication config of 3 databases, then tried MOVE > SET to change the master node (using standard LOCK SET and MOVE SET > combo as suggested by slonik_move_set). > > Everything worked correctly and without errors. Then I tried updates and > ... on new master I got > > ERROR: Slony-I: Table msg is replicated and cannot be modified on a subscriber node > > Tried on old master to make it sure, got the same error there too. > > I started to write some call for help, but after ~ a few minutes the new master > finally started to accept updates. > > I think it would make sense to add a sentence or two to the docs warning about > this effect.... (I believe the fact that I use weak machine increased the delay, > but the bare fact that this is async matters) > > _______________________________________________ > Slony1-general mailing list > Slony1-general at lists.slony.info > http://lists.slony.info/mailman/listinfo/slony1-general >
- Previous message: [Slony1-general] MOVE SET should warn that it proceeeds async...
- Next message: [Slony1-general] Re: MOVE SET should warn that it proceeeds async...
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list