[Postgres-xl-general] Addition of datanode master fails

Ramanuj Hari hari.ramanuj at gmail.com
Thu Jan 8 14:39:32 PST 2015


Hi,

I am trying to add datanode master(to run on separate host) to PGXL running
system(having configuration 1 gtm, 1 coordinator, 1 datanode all on same
host), but it fails with below message.
-----
PGXC$ ERROR:  PGXC Node datanode2: object not defined
---

datanode2 is added to pgxc_node table, and it is started as well. Table
created with replication by roundrobin are not getting distributed, like
subsequent inserts are not inserting row in datanode2. All insert are going
to datanode1(previous node).

Appreciate any help.

Thanks,
Ramanuj

----Log--
PGXC$ add datanode master datanode2 10.102.103.131 12921 16921
/var/mps/db_pgxl/data/auto/nodes/dn_master datanode1
do_shell.c:doImmediate(219) Actual Command: ssh pgxl at 10.102.103.131 "(
initdb -D /var/mps/db_pgxl/data/auto/nodes/dn_master --nodename datanode2 )
> /tmp/Ramanuj8_STDOUT_97912_0 2>&1" < /dev/null > /dev/null 2>&1
do_shell.c:doImmediate(224) Bring remote stdout: scp
pgxl at 10.102.103.131:/tmp/Ramanuj8_STDOUT_97912_0
/tmp/STDOUT_97912_1 > /dev/null 2>&1
The files belonging to this database system will be owned by user "pgxl".
This user must also own the server process.

The database cluster will be initialized with locale "C".
The default database encoding has accordingly been set to "SQL_ASCII".
The default text search configuration will be set to "english".

creating directory /var/mps/db_pgxl/data/auto/nodes/dn_master ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 32MB
creating configuration files ... ok
creating template1 database in
/var/mps/db_pgxl/data/auto/nodes/dn_master/base/1 ... ok
initializing pg_authid ... ok
initializing dependencies ... ok
creating system views ... ok
creating cluster information ... ok
loading system objects' descriptions ... ok
creating collations ... not supported on this platform
creating conversions ... ok
creating dictionaries ... ok
setting privileges on built-in objects ... ok
creating information schema ... ok
loading PL/pgSQL server-side language ... ok
creating storm catalog... ok
vacuuming database template1 ... ok
copying template1 to template0 ... ok
copying template1 to postgres ... ok
freezing database template0 ... ok
freezing database template1 ... ok
freezing database postgres ... ok

WARNING: enabling "trust" authentication for local connections
You can change this by editing pg_hba.conf or using the option -A, or
--auth-local and --auth-host, the next time you run initdb.

Success.
 You can now start the database server of the Postgres-XL coordinator using:

    postgres --coordinator -D /var/mps/db_pgxl/data/auto/nodes/dn_master
or
    pg_ctl start -D /var/mps/db_pgxl/data/auto/nodes/dn_master -Z
coordinator -l logfile

 You can now start the database server of the Postgres-XL datanode using:

    postgres --datanode -D /var/mps/db_pgxl/data/auto/nodes/dn_master
or
    pg_ctl start -D /var/mps/db_pgxl/data/auto/nodes/dn_master -Z datanode
-l logfile

INFO:  please do not close this session until you are done adding the new
node
 pgxc_lock_for_backup
----------------------
 t
(1 row)

do_shell.c:doImmediate(219) Actual Command: ssh pgxl at 10.102.103.131 "(
pg_ctl start -Z restoremode -D /var/mps/db_pgxl/data/auto/nodes/dn_master
-o -i ) > /tmp/Ramanuj8_STDOUT_97912_3 2>&1" < /dev/null > /dev/null 2>&1
do_shell.c:doImmediate(224) Bring remote stdout: scp
pgxl at 10.102.103.131:/tmp/Ramanuj8_STDOUT_97912_3
/tmp/STDOUT_97912_4 > /dev/null 2>&1
SET
SET
CREATE ROLE
ALTER ROLE
CREATE ROLE
ALTER ROLE
psql:/tmp/GENERAL_97912_2:16: ERROR:  role "pgxl" already exists
ALTER ROLE
CREATE ROLE
ALTER ROLE
CREATE DATABASE
CREATE DATABASE
REVOKE
REVOKE
GRANT
GRANT
CREATE DATABASE
CREATE NODE
CREATE NODE
You are now connected to database "mpsdb" as user "pgxl".
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
SET
SET
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
ALTER TABLE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "mpstest" as user "pgxl".
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "postgres" as user "pgxl".
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "template1" as user "pgxl".
SET
SET
SET
SET
SET
COMMENT
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
You are now connected to database "test" as user "pgxl".
SET
SET
SET
SET
SET
CREATE EXTENSION
COMMENT
REVOKE
REVOKE
GRANT
GRANT
do_shell.c:doImmediate(219) Actual Command: ssh pgxl at 10.102.103.131 "(
pg_ctl stop -Z restoremode -D /var/mps/db_pgxl/data/auto/nodes/dn_master )
> /tmp/Ramanuj8_STDOUT_97912_5 2>&1" < /dev/null > /dev/null 2>&1
do_shell.c:doImmediate(224) Bring remote stdout: scp
pgxl at 10.102.103.131:/tmp/Ramanuj8_STDOUT_97912_5
/tmp/STDOUT_97912_6 > /dev/null 2>&1
datanode_cmd.c:start_datanode_master(396) Starting datanode master
datanode2.
do_shell.c:dump_cmdList(700) *** cmdList Dump
*******************************
allocated = 2, used = 1
do_shell.c:dump_cmdList(710) === CMD: 0 ===
do_shell.c:dump_cmdList(714)    --- CMD-EL: 0:host="10.102.103.131",
command="pg_ctl start -Z datanode -D
/var/mps/db_pgxl/data/auto/nodes/dn_master -o -i", localStdin="NULL",
localStdout="NULL"
do_shell.c:doCmdEl(336) Remote command: "pg_ctl start -Z datanode -D
/var/mps/db_pgxl/data/auto/nodes/dn_master -o -i", actual: "ssh
pgxl at 10.102.103.131 "( pg_ctl start -Z datanode -D
/var/mps/db_pgxl/data/auto/nodes/dn_master -o -i ) >
/tmp/Ramanuj8_STDOUT_97912_8 2>&1" < /dev/null > /dev/null 2>&1"
datanode_cmd.c:start_datanode_master(403) Done.
PGXC$ ERROR:  PGXC Node datanode2: object not defined
CREATE NODE
EXECUTE DIRECT

PGXC$
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20150109/08008acb/attachment.htm>


More information about the postgres-xl-general mailing list