Skip site navigation (1) Skip section navigation (2)

Re: Drop set problem - pgAdmin / Slony I

From: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>
To: Magnus Hagander <magnus(at)hagander(dot)net>, Christopher Browne <cbbrowne(at)ca(dot)afilias(dot)info>
Cc: Glyn Astill <glynastill(at)yahoo(dot)co(dot)uk>, pgadmin-support(at)postgresql(dot)org
Subject: Re: Drop set problem - pgAdmin / Slony I
Date: 2008-01-25 14:55:17
Message-ID: 465428.74566.qm@web25813.mail.ukl.yahoo.com (view raw or flat)
Thread:
Lists: pgadmin-support
Hi chaps,

I've just gone over what I was doing, however this time using slonik
rather than pgAdmin. I should have done this to start with, as I
really had no idea what was really going off behind the scenes.

What I was doing was creating a blank table on my subscriber, where
the origin had a table with 15 million records. Then I was creating a
set and subscribing the subscriber to it, then trying to merge the
set straight away.

So I might have been trying to merge the set before it was subscribed
properly, either down to there being some latency between clicking
subscribe and then merge, or something to do with the size of the
data to be copied over.

Does this sound possible ??? or would pgAdmin stop me from doing
merge set before they were properly subscribed?

As the slonik docs say "Do not be too quick to merge sets".


--- Magnus Hagander <magnus(at)hagander(dot)net> wrote:

> On Fri, Jan 18, 2008 at 11:07:27AM -0500, Christopher Browne wrote:
> > >> > > I've had this happen before. Removing the cluster and
> setting it
> > >> > up
> > >> > > again resolves the problem, however once we are in a
> production
> > >> > > environment I can't go dropping the whole cluster and
> replicating
> > >> > all
> > >> > > the tables from scratch when it happens.
> > >> > 
> > >> > Can you give us an exact step-by-step on how to make it
> happen?
> > >> > 
> > >> 
> > >> I tried to subscribe a new set with a new table in it and for
> some
> > >> reason it failed with the error mentioned. The slony logs show
> that
> > >> slony was periodically trying to subscribe on the subscriber.
> > >
> > > I mean complete step-to-step, as in exactly what you click and
> enter. I've
> > > done what is at least on the surface the same thing you have,
> with no
> > > problems. So there must be somethign in the details.
> > >
> > >> Seeing as I couldn't remove it from pgAdmin, I went in and ran
> a
> > >> slonik script to drop the set, however I didn't try to
> unsubscribe it
> > >> with slonik first. So is there a chance it's come about from
> me not
> > >> unsubscribing first?
> > >
> > > Part of it may - I don't recall offhand it the
> must-unsubscribe-first is a
> > > rqeuirement of Slonik or just of pgAdmin.
> > 
> > You don't need to unsubscribe first.
> > 
> > The stored procedure dropSet() is perfectly happy to drop the set
> at
> > any time.  When the event propagates, it'll happily clear out all
> > traces of the set.
> 
> Ok. Good. Then I think the reason it's not supported in pgAdmin is
> simply
> because it made the GUI simpler to require that ;-)
> 
> 
> //Magnus
> 



      __________________________________________________________
Sent from Yahoo! Mail - a smarter inbox http://uk.mail.yahoo.com


In response to

pgadmin-support by date

Next:From: JohnDate: 2008-01-25 16:44:37
Subject: pgAdmin download/install problem Ubuntu
Previous:From: Laurent ROCHEDate: 2008-01-25 14:54:17
Subject: Re : Re : Reporting ?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group