Menu
▾
▴
Re: [Postgres-xc-general] Add new coordinator error!
|
From: 鈴木 幸市 <ko...@in...> - 2013-10-08 01:08:54
|
On 2013/10/07, at 23:27, Julian <jul...@gm...<mailto:jul...@gm...>> wrote: I can not just issue "add coordinator master",it alway asked me for more here is my step: # Deploy binaries PGXC$ depoly all #initialize everyting: one GTM Master, three GTM_Proxy, three coordinator, three datanode PGXC$ init all These commands are for the initial ones. I think you've already done that. ..... PGXC$ Createdb pgxc ..... PGXC$ Psql pgxc=# select * from pgxc_node; node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferred | node_id ..... pgxc=# create table user_info_hash(id int primary key,firstname text,lastname text,info text) distribute by hash(id); NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index "user_info_hash_pkey" for table "user_info_hash" CREATE TABLE .... PGXC$ deploy node4 PGXC$ add datanode master datanode4 ERROR: please specify the host for the datanode masetr PGXC$ add datanode master datanode4 node4 20008 /opt/pgxc/nodes/dn_master ERROR: sorry found some inconflicts in datanode master configuration. add command syntax will be found at http://postgres-xc.sourceforge.net/docs/1_1/pgxc-ctl.html. Please take a look at the section F.32.12. -------------------------------------------------------------- 2. and i found when the dump file contain table with CREATE TABLE user_info_hash ( id integer NOT NULL, firstname text, lastname text, info text ) DISTRIBUTE BY HASH (id) TO NODE (datanode1,datanode2,datanode3); is alway failed to add new coordinator but with this CREATE TABLE user_id ( id integer NOT NULL ) DISTRIBUTE BY HASH (id) TO NODE (dn2,dn1,dn3); it's sucessed to add the new coordinator to the cluster No. To add a coordinator, you should have correct resource in "add" command. The error message above indicates there are some conflict in the resource you specified with another node. You must specify unique port number and work directory within the server. To add a coordinator, you should issue the following command: PGXC$ add coordinator master name host port pooler dir When you issue this command and it is successful, your pgxc_ctl.conf will have additional line with this additional node. Please take a look at it. If it fails and you'd like to restore to the previous configuration, you can edit pgxc_ctl.conf by yourself. In this point, pgxc_ctl is still "primitive". Regards; --- Koichi Suzuki 於 7/10/2013 18:18, Koichi Suzuki 提到: I found your configuration, in terms of owner and user, is the same as my demonstration scenario. Then what you should do is: 1. Log in to your operating system as pgxcUser, 2. Initialize Postgres-XC cluster with "init all" command of pgxc_ctl, Then the database user $pgxcOwner should have been created and you don't have to worry about it. When you add a coordinator, simply issue "add coordinator master" command. It should work. If you have any other issue, please let me know. My pgxc_ctl demonstration scenario will be found at https://sourceforge.net/apps/mediawiki/postgres-xc/index.php?title=PGOpen2013_Postgres_Open_2013 The configuration is with full slaves, which you can disable. The demo adds a datanode, not a coordinator. I believe there's no significant differences. Regards; --- Koichi Suzuki 2013/10/7 Koichi Suzuki <koi...@gm...<mailto:koi...@gm...>> I understood the situation. Could you let me know if pgxc is not the operating system user name you are using? If so, I will run the test with this situation and see what is going to happen. Maybe a bug (not Postgres-XC core, but pgxc_ctl). If pgxc is the operating system user you are using, then there could be another cause. Also, please let me know your setting of pgxcUser in pgxc_ctl.conf? Best; --- Koichi Suzuki 2013/10/7 Julian <jul...@gm...<mailto:jul...@gm...>> Sorry, i found i have already config pgxcOwner=pgxc in pxc_ctl.conf. And i forgot to mention there's something strange about to add new coordinator, i can’t add coord4 by "add coordinator master coord4 node4 20004 20010 /opt/pgxc/nodes/coord” it will show me ERROR: sorry found some inconflicts in coordinator master configuration.PGXC$ unless i add coord4 to pgxc_ctl.conf and remove it at PGXC shell PGXC$ remove coordinator master coord4 ERROR: PGXC Node coord4: object not defined ERROR: PGXC Node coord4: object not defined ERROR: PGXC Node coord4: object not defined Is it normal ? attach file is my pgxc config Julian 使用 Sparrow<http://www.sparrowmailapp.com/?sig> 發信 On 2013年10月7日Monday at 下午5:31, Koichi Suzuki wrote: Okay. I'm wondering why internal pg_restore complains pgxc already exists.. If you do not specify pgxc in pgxc_ctl and created it manually, newly-craeted node should not contain the role pgxc, though we have different massage. Could you let me know if you have any idea? Best; --- Koichi Suzuki 2013/10/7 Julian <jul...@gm...<mailto:jul...@gm...>> I did not specify pgxc as a database owner, but i create user pgxc to do these job. -- Julian 使用 Sparrow<http://www.sparrowmailapp.com/?sig> 發信 On 2013年10月7日Monday at 下午4:44, Koichi Suzuki wrote: Did you specify pgxc as a database owner ------------------------------------------------------------------------------ October Webinars: Code for Performance Free Intel webinars can help you accelerate application performance. Explore tips for MPI, OpenMP, advanced profiling, and more. Get the most from the latest Intel processors and coprocessors. See abstracts and register > http://pubads.g.doubleclick.net/gampad/clk?id=60134791&iu=/4140/ostg.clktrk_______________________________________________ Postgres-xc-general mailing list Pos...@li... https://lists.sourceforge.net/lists/listinfo/postgres-xc-general |
