Home CVS Mailinglists Documentation Download
[Slony1-general] Node is not initialized properly
bijayant kumar bijayant4u at yahoo.com
Mon Jun 30 06:58:47 PDT 2008 
Thanks for the reply. I executed the command "slonik_init_cluster".It gives the output like

# INIT CLUSTER
cluster name = bijayant;
 node 1 admin conninfo='host=192.168.99.23 dbname=bijayant user=bijayant port=5432 password=bijayant';
 node 2 admin conninfo='host=192.168.99.134 dbname=bijayant user=bijayant port=5432 password=bijayant';
  init cluster (id = 1, comment = 'Node 1 - bijayant at 192.168.99.23');

# STORE NODE
  store node (id = 2, event node = 1, comment = 'Node 2 - bijayant at 192.168.99.134');
  echo 'Set up replication nodes';

# STORE PATH
  echo 'Next: configure paths for each node/origin';
  store path (server = 1, client = 2, conninfo = 'host=192.168.99.23 dbname=bijayant user=bijayant port=5432 password=bijayant');
  store path (server = 2, client = 1, conninfo = 'host=192.168.99.134 dbname=bijayant user=bijayant port=5432 password=bijayant');
  echo 'Replication nodes prepared';
  echo 'Please start a slon replication daemon for each node';

After that i run the slonik daemon and got the error mentioned.


Bijayant Kumar


--- On Mon, 30/6/08, Martin Eriksson <m.eriksson at albourne.com> wrote:

> From: Martin Eriksson <m.eriksson at albourne.com>
> Subject: Re: [Slony1-general] Node is not initialized properly
> To: 
> Cc: slony1-general at lists.slony.info
> Date: Monday, 30 June, 2008, 7:18 PM
> Very basic, but saw no mention of it in the e-mail,
> 
> I assume you ran the "slonik_init_cluster" before
> trying to start the 
> slon daemons? as that does the slony setup on each of the
> dbs
> 
> 
> 
> bijayant kumar wrote:
> > Hello list,
> >
> > I am a very new user of slony1 so please forgive me if
> i am asking very stupid question. 
> > I have installed Postgresql and Slony1 on two gentoo
> machine. Postgresql is working fine no problem at all. I
> want to use Slony1 to replicate the two databases across
> the systems. To understand the slony1 concept i made a 
> > test database with one single table and only one entry
> into it. But when i start slony1 i get error like
> >
> > 2008-06-30 15:54:55 IST ERROR  cannot get
> sl_local_node_id - ERROR:  schema "_bijayant"
> does not exist
> > 2008-06-30 15:54:55 IST FATAL  main: Node is not
> initialized properly - sleep 10s
> >
> > Now i am giving here my configuration details.
> >
> > /* Master Server */
> > IP Address 192.168.99.23
> > Database name bijayant
> > Table name kavach
> >
> > bijayant=# select * from kavach;
> >  id |   name   | designation |   address
> > ----+----------+-------------+-------------
> >   1 | Bijayant | consultant  | Lakkasandra
> > (1 row)
> >
> >
> > vi /etc/slon_tools.conf
> >
> > if ($ENV{"SLONYNODES"}) {
> >     require $ENV{"SLONYNODES"};
> > } else {
> >     $CLUSTER_NAME = 'bijayant';
> >     $LOGDIR = '/var/log/slony';
> >     $MASTERNODE = 1;
> >     add_node(node     => 1,
> >              host     => '192.168.99.23',
> >              dbname   => 'bijayant',
> >              port     => 5432,
> >              user     => 'bijayant',
> >              password => 'bijayant');
> >
> >     add_node(node     => 2,
> >              host     => '192.168.99.134',
> >              dbname   => 'bijayant',
> >              port     => 5432,
> >              user     => 'bijayant',
> >              password => 'bijayant',
> >              parent => 1
> >              );
> > }
> >
> > $SLONY_SETS = {
> >                 "set1" => {
> >                            "set_id" => 1,
> >                            "pkeyedtables"
> => [
> >                            'public.kavach',
> >                            ],
> >         },
> > if ($ENV{"SLONYSET"}) {
> >     require $ENV{"SLONYSET"};
> > }
> >
> > 1;
> >
> > vi /etc/conf.d/slony1
> > USER=postgres
> > CLUSTER=bijayant
> > DBUSER=bijayant
> > DBNAME=bijayant
> > DBHOST=192.168.99.23
> > LOGFILE=/var/lib/postgresql/data/slony1.log
> > LOGLEVEL=4
> >
> > /* On the Slave Server */
> >
> > IP Address 192.168.99.134
> > Database name bijayant
> > Table name kavach
> >
> > vi /etc/slon_tools.conf
> >
> > if ($ENV{"SLONYNODES"}) {
> >     require $ENV{"SLONYNODES"};
> > } else {
> >     $CLUSTER_NAME = 'bijayant';
> >     $LOGDIR = '/var/log/slony';
> >     # SYNC check interval (slon -s option)
> >     # $SYNC_CHECK_INTERVAL = 1000;
> >     $MASTERNODE = 1;
> >     add_node(node     => 1,
> >              host     => '192.168.99.23',
> >              dbname   => 'bijayant',
> >              port     => 5432,
> >              user     => 'bijayant',
> >              password => 'bijayant');
> >
> >     add_node(node     => 2,
> >              host     => '192.168.99.134',
> >              dbname   => 'bijayant',
> >              port     => 5432,
> >              user     => 'bijayant',
> >              password => 'bijayant',
> >              parent => 1
> >              );
> > }
> > $SLONY_SETS = {
> >     "set1" => {
> >                "set_id" => 1,
> >                 "pkeyedtables" => [
> >                                  
> 'public.kavach',
> >                                   ],
> >               },
> > };
> >
> > if ($ENV{"SLONYSET"}) {
> >     require $ENV{"SLONYSET"};
> > }
> >
> > 1;
> >
> > vi /etc/conf.d/slony1
> > USER=postgres
> > CLUSTER=bijayant
> > DBUSER=bijayant
> > DBNAME=bijayant
> > DBHOST=192.168.99.23
> > LOGFILE=/var/lib/postgresql/data/slony1.log
> > LOGLEVEL=4 
> >
> > When i start the slony1 /etc/init.d/slony1 start on
> both the machine it generates lots of logs with errors line
> like
> >
> > 2008-06-30 15:54:55 IST DEBUG2 slon_retry() from
> pid=19007
> > 2008-06-30 15:54:55 IST DEBUG1 slon: retry requested
> > 2008-06-30 15:54:55 IST DEBUG2 slon: notify worker
> process to shutdown
> > 2008-06-30 15:54:55 IST DEBUG2 slon: child terminated
> status: 0; pid: 19007, current worker pid: 19007
> > 2008-06-30 15:54:55 IST DEBUG1 slon: restart of worker
> > 2008-06-30 15:54:55 IST CONFIG main: slon version
> 1.2.10 starting up
> > 2008-06-30 15:54:55 IST DEBUG2 slon: watchdog process
> started
> > 2008-06-30 15:54:55 IST DEBUG2 slon: watchdog ready -
> pid = 19005
> > 2008-06-30 15:54:55 IST DEBUG2 slon: worker process
> created - pid = 19034
> > 2008-06-30 15:54:55 IST ERROR  cannot get
> sl_local_node_id - ERROR:  schema "_bijayant"
> does not exist
> > 2008-06-30 15:54:55 IST FATAL  main: Node is not
> initialized properly - sleep 10s
> >
> > I am sure that i am not understanding some basic
> things about the slony1. Can anybody help me to understand
> the logic, i will be very helpful for you all. Please tell
> me what i am doing wrong here, what should i do. I have
> read the documentation at the website but not able to
> understand fully. Please help me out.
> >
> > Thanks & Regards,
> > Bijayant Kumar
> >
> > Send instant messages to your online friends
> http://uk.messenger.yahoo.com 
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at lists.slony.info
> >
> http://lists.slony.info/mailman/listinfo/slony1-general
> >   
> 
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general

Send instant messages to your online friends http://uk.messenger.yahoo.com
More information about the Slony1-general mailing list

Content © 2007 Slony Development Group - Hosting provided by Command Prompt, Inc.