Home CVS Mailinglists Documentation Download
[Slony1-general] Node is not initialized properly
Glyn Astill glynastill at yahoo.co.uk
Mon Jun 30 07:09:28 PDT 2008 
Check to see if you have the _bijayant schema in your bijayant database, if not then the init cluster never got created.

I've never used the slony tools, but it looks like the output you got from slonik_init_cluster didn't actually get run through slonik. Perhaps you have to pipe the output into slonik?



----- Original Message ----
> From: bijayant kumar <bijayant4u at yahoo.com>
> To: Martin Eriksson <m.eriksson at albourne.com>
> Cc: slony1-general at lists.slony.info
> Sent: Monday, 30 June, 2008 2:58:47 PM
> Subject: Re: [Slony1-general] Node is not initialized properly
> 
> 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 wrote:
> 
> > From: Martin Eriksson 
> > 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
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general



      __________________________________________________________
Not happy with your email address?.
Get the one you really want - millions of new email addresses available now at Yahoo! http://uk.docs.yahoo.com/ymail/new.html
More information about the Slony1-general mailing list

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