I messed up and sent this originally as HTML.  Resending as plain text.

________________________________________
From: Mark Steben [mailto:msteben at autorevenue.com] 
Sent: Friday, August 08, 2008 3:57 PM
To: 'slony1-general at lists.slony.info'
Subject: node -1 error after restarting servers

Hi - hoping for some help.
I'm running Slony 1.2.14 on a simple 1 master 1 slave configuration.  Each
server is running Postgres 8.2.5.
I had to restart both master and slave servers.  When I tried to restart the
slons I got errors in the slave log that
Table ids were already assigned within the set.  So I dropped the set,
dropped the path and the listens,
And recreated all with CREATE SET,  STORE PATH, and STORE LISTENS on the
provider

Now when I restart the slons and subscribe the newly defined set I get the
following error in the logs
On the slave:
    node -1 not found in runtime configuration

and the copy fails.

When I query SL_NODE on the master I get:

   no_id | no_active |   no_comment    | no_spool 
-------+-----------+-----------------+----------
     1 | t         | Master Node     | f
     2 | f         | <event pending> | f

And the same query on the slave gives:

no_id | no_active |        no_comment        | no_spool 
-------+-----------+--------------------------+----------
     1 | t         | Master Node                    | f
     2 | t         | subscriber node                | f
(2 rows)

Do I have to recreate the node(s) as well?   

Any help would be appreciated.  thanks
. 
________________________________________
Mark Steben│Database Administrator│ @utoRevenueT
480 Pleasant Street, Suite B200, Lee, MA 01238 
413-243-4800 x1512 (Phone) │ 413-243-4809 (Fax)
A Division of Dominion Enterprises