[Postgres-xl-general] When I tried to start the datanode2 in thesame server but failed. Why?

Eason Yi 11719668 at qq.com
Tue Dec 9 03:59:03 PST 2014


Thank you both very much!


I'll try it again.


------------------
Regards,


Eason


 




------------------ Original ------------------
From:  "Nikhil Sontakke";<nikhils at translattice.com>;
Date:  Tue, Dec 9, 2014 06:07 PM
To:  "Eason Yi"<11719668 at qq.com>; 
Cc:  "postgres-xl-general"<postgres-xl-general at lists.sourceforge.net>; 
Subject:  Re: [Postgres-xl-general] When I tried to start the datanode2 in thesame server but failed. Why?



Hi Eason, 


The datanodes need to use *separate* pooler ports if running on the same node. Please ensure that "pooler_port" value is different for each datanode and coordinator nodes.


Also, please consider using the pgxc_ctl utility to setup the cluster to avoid such kinds of hassles. 
http://files.postgres-xl.org/documentation/pgxc-ctl.html


Regards,
Nikhils


On Tue, Dec 9, 2014 at 5:33 PM, Eason Yi <11719668 at qq.com> wrote:
Hi, everybody!


I have tried the instruction of "Chapter 15. Installation from Source Code‍" from XL 9.2 doc.


When I tried to start the datanode2 in the same server but failed. 


Would you please give me some advice? Thanks.


Following is something printed on my screen.  ‍


Some of my history info:
   78  /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_coord1 --nodename coord1
   79  /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode1 --nodename datanode1
   80  /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode2 --nodename datanode2
   81  /usr/local/pgsql/bin/initgtm -D /usr/local/pgsql/data_gtm -Z gtm
   82  /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm >logfile 2>&1 &
   83  /usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1 >logfile 2>&1 &
   84  /usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 >logfile 2>&1 &
   85  /usr/local/pgsql/bin/postgres --coordinator -D /usr/local/pgsql/data_coord1 >logfile 2>&1 &


When I got failed, I tried again, but still failed:
postgres at debian-zine:~$ !84
/usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 >logfile 2>&1 &
[3] 4174
[3]+  退出 1                /usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 > logfile 2>&1
postgres at debian-zine:~$ ps -ef|grep pgsql
postgres  4095  3855  0 16:13 pts/0    00:00:00 /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm
postgres  4112  3855  0 16:13 pts/0    00:00:00 /usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1
postgres  4201  3855  0 16:17 pts/0    00:00:00 grep pgsql
postgres at debian-zine:~$ cat logfile
FATAL:  lock file "/tmp/.s.PGPOOL.6667.lock" already exists
HINT:  Is another postmaster (PID 4114) using socket file "/tmp/.s.PGPOOL.6667"?
LOG:  pool manager process (PID 4176) exited with exit code 1
LOG:  terminating any other active server processes
LOG:  startup process (PID 4175) exited with exit code 2
LOG:  aborting startup due to startup process failure
postgres at debian-zine:~$ 
‍


Following if copy from the XL doc:
./configure gmake su gmake install adduser postgres mkdir /usr/local/pgsql/data_coord1 mkdir /usr/local/pgsql/data_datanode1 mkdir /usr/local/pgsql/data_datanode2 mkdir /usr/local/pgsql/data_gtm chown postgres /usr/local/pgsql/data_coord1 chown postgres /usr/local/pgsql/data_datanode1 chown postgres /usr/local/pgsql/data_datanode2 chown postgres /usr/local/pgsql/data_gtm su - postgres /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_coord1 --nodename coord1 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode1 --nodename datanode1 /usr/local/pgsql/bin/initdb -D /usr/local/pgsql/data_datanode2 --nodename datanode2 /usr/local/pgsql/bin/initgtm -D /usr/local/pgsql/data_gtm -Z gtm /usr/local/pgsql/bin/gtm -D /usr/local/pgsql/data_gtm >logfile 2>&1 & /usr/local/pgsql/bin/postgres --datanode -p 15432 -D /usr/local/pgsql/data_datanode1 >logfile 2>&1 & /usr/local/pgsql/bin/postgres --datanode -p 15433 -D /usr/local/pgsql/data_datanode2 >logfile 2>&1 & /usr/local/pgsql/bin/postgres --coordinator -D /usr/local/pgsql/data_coord1 >logfile 2>&1 & /usr/local/pgsql/bin/psql -c "CREATE NODE datanode1 WITH (TYPE = 'datanode', PORT = 15432)" postgres /usr/local/pgsql/bin/psql -c "CREATE NODE datanode2 WITH (TYPE = 'datanode', PORT = 15433)" postgres /usr/local/pgsql/bin/psql -c "SELECT pgxc_pool_reload()" postgres /usr/local/pgsql/bin/createdb test /usr/local/pgsql/bin/psql test
------------------
Regards,


Eason


 

------------------------------------------------------------------------------
 Download BIRT iHub F-Type - The Free Enterprise-Grade BIRT Server
 from Actuate! Instantly Supercharge Your Business Reports and Dashboards
 with Interactivity, Sharing, Native Excel Exports, App Integration & more
 Get technology previously reserved for billion-dollar corporations, FREE
 http://pubads.g.doubleclick.net/gampad/clk?id=164703151&iu=/4140/ostg.clktrk
_______________________________________________
 Postgres-xl-general mailing list
 Postgres-xl-general at lists.sourceforge.net
 https://lists.sourceforge.net/lists/listinfo/postgres-xl-general
 




-- 
TransLattice - http://www.translattice.com
 Distributed and Clustered Database Solutions
Postgres-XL Support
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20141209/35960977/attachment.htm>


More information about the postgres-xl-general mailing list