Home CVS Mailinglists Documentation Download
[Slony1-general] Node is not initialized properly
Glyn Astill glynastill at yahoo.co.uk
Tue Jul 1 01:52:59 PDT 2008 
I'd be checking to see where xxid.so was on the system, and if I had an older version lurking somewhere.

I'd also make sure bijayant was a database superuser.



----- 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: Tuesday, 1 July, 2008 8:00:19 AM
> Subject: Re: [Slony1-general] Node is not initialized properly
> 
> Thanks to all for the reply. Now i think that i am coming closer to run slonik. 
> When i did as suggested by all
> 
> bijayant ~ # slonik_init_cluster --config /etc/slon_tools.conf | slonik
> 
> :6: PGRES_FATAL_ERROR load '$libdir/xxid';  - ERROR:  could not access 
> file "$libdir/xxid": No such file or directory
> 
> :6: Error: the extension for the xxid data type cannot be loaded in 
> database 'host=192.168.99.23 dbname=bijayant user=bijayant port=5432 
> password=bijayant'
> 
> :6: ERROR: no admin conninfo for node 134598992
> 
> The first two lines of the error i couldnot understand.
> The "admin conninfo" error, i think this parameter should be present in conf 
> file, right? But in my case what should be there, as i am already giving the 
> username and password to connect to the postgresql database.
> 
> In this problem thread one gentleman has asked me to check whether "_bijayant" 
> schema is created or not? I am sorry to ask but i really dont know about this. I 
> have only created a user,database and table in the postgresql database nothing 
> else. When we create database, schema is also created automatically, right?
> 
> Please suggest me what should i do next. Sorry but i am very new to slonik and 
> database. I am trying hard to understand the concept
> 
> Thanks & Regards,
> 
> 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, 8:34 PM
> > If you only run it like that, it only prints what it will
> > execute, to 
> > actually execute this you need to | it to the slonik app..
> > 
> > eg. /data/pgsql/slony/slonik_init_cluster --config
> > | 
> > /data/pgsql/bin/slonik
> > 
> > all scripts starting with "slonik_" doesn't
> > actually do anything 
> > themself, its just a way to format a command correctly for
> > the slonik 
> > parser, which actually does the work..
> > 
> > 
> > 
> > bijayant kumar wrote:
> > > 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
> 
> 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.