Mon Aug 11 05:05:18 PDT 2008
- Previous message: [Slony1-general] node -1 error after restarting servers
- Next message: [Slony1-general] RE: node -1 error after restarting servers
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
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
- Previous message: [Slony1-general] node -1 error after restarting servers
- Next message: [Slony1-general] RE: node -1 error after restarting servers
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list