Pshem Kowalczyk pshem.k at gmail.com
Tue Nov 27 16:07:39 PST 2007
Hi All,

yestarday one of the db boxes we in our cluster died. It took the db
with it. After a fresh install I added it to the cluster (basically -
drop node 3, store node 3). And then when I tried to start slony I
got:

2007-11-28 12:55:43 NZDT ERROR  cannot get sl_local_node_id - ERROR:
schema "_radiuscluster" does not exist
2007-11-28 12:55:43 NZDT FATAL  main: Node is not initialized properly


However if I try to connect to the db with the same privileges slony
uses (postgres admin user) I can see the tables:

postgres at raddb3:~$ psql -H akl-grafton-raddb3.ihug.net -U postgres radbackend
psql: warning: extra command-line argument "radbackend" ignored
psql: FATAL:  database "akl-grafton-raddb3.ihug.net" does not exist
postgres at raddb3:~$ psql -h akl-grafton-raddb3.ihug.net -U postgres radbackend
Welcome to psql 8.1.9, the PostgreSQL interactive terminal.

Type:  \copyright for distribution terms
       \h for help with SQL commands
       \? for help with psql commands
       \g or terminate with semicolon to execute query
       \q to quit

SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)

radbackend=# select * from _radiuscluster.sl_node

_radiuscluster.sl_node
_radiuscluster.sl_nodelock_nl_conncnt_seq
_radiuscluster.sl_nodelock
radbackend=# select * from _radiuscluster.sl_node;
 no_id | no_active |                   no_comment                    | no_spool
-------+-----------+-------------------------------------------------+----------
     3 | t         | Node 3 - radbackend at akl-grafton-raddb3 | f
     2 | t         | Node 2 - radbackend at akl-grafton-raddb2 | f
     1 | t         | Node 1 - radbackend at akl-grafton-raddb1 | f
     4 | t         | Node 4 - radbackend at akl-grafton-raddb4 | f
(4 rows)

A few days ago I re-provisioned node 4 exactly the same way and
everything seems to be fine. What might be the problem? Configuration
files (slony1.conf is set to all defaults), or something in the
database?

I use slony 1.2.1.

kind regards
Pshem


More information about the Slony1-general mailing list