Home CVS Mailinglists Documentation Download
[Slony1-general] Node is not initialized properly
bijayant kumar bijayant4u at yahoo.com
Tue Jul 1 02:35:38 PDT 2008 
Hi,
The user "bijayant" is a super user. I have created this user like

postgres at bijayant ~ $ createuser bijayant
Shall the new user be allowed to create databases? (y/n) y
Shall the new user be allowed to create more new users? (y/n) y
CREATE USER

It means that bijayant is a super user right? Or i am doing some silly thing. If i will use user as pgsql than what to use for password.

bijayant ~ # pg_config --libdir
/usr/lib

bijayant ~ # pg_config --pkglibdir
/usr/lib/postgresql

In the Master Database server the xxid.so file is in 
/usr/local/pgsql/lib/xxid.so. I have copied to this file to /usr/lib/postgresql/ and /usr/lib/ also. But no luck.

On the Slave Server, its in /usr/lib64/postgresql/xxid.so.

Is it creating the problem. How to resolve this problem.
I have installed postgres and slony1 by the emerge utility of gentoo.

Thanks & Regards,

Bijayant Kumar


--- On Tue, 1/7/08, Glyn Astill <glynastill at yahoo.co.uk> wrote:

> From: Glyn Astill <glynastill at yahoo.co.uk>
> Subject: Re: [Slony1-general] Node is not initialized properly
> To: bijayant4u at yahoo.com, "Martin Eriksson" <m.eriksson at albourne.com>
> Cc: slony1-general at lists.slony.info
> Date: Tuesday, 1 July, 2008, 2:22 PM
> 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

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.