gs-createdb.sh problem

This message was edited 2 times. Last update was at 30 Nov 2010 11:40:20

hi
ive configured my gridSql according to its documentations. i have two nodes , node one(IP = 192.168.1.3) and node two(192.168.1.2) , according to the documentation i checked following command from nodes one postgresql :
createdb -h 192.168.1.2 -p 5433 -U postgres -O postgres xxxx
and it worked successfully , so my connection and other things are ok, but while running this command from gridSql
gs-createdb.sh -d xxxx -u postgres -p mypass -n 1,2
i got exception . it created xxxx db in my localhost db but when it wants to create db in node two (192.168.1.2) it fails due to :
ERROR: Failed to execute command "createdb -h 192.168.1.2 -p 5433 -U postgres -O postgres hahaN2": exit code was 1

and in my console.log i got :

[code]2010-11-30 19:37:09,334 - ERROR Catching throwable:
java.io.IOException: Failed to execute command "createdb -h 192.168.1.2 -p 5433 -U postgres -O postgres xxxx": exit code was 1
at com.edb.gridsql.util.DbGateway.executeList(Unknown Source)
at com.edb.gridsql.util.DbGateway.executeTemplateOnNodes(Unknown Source)
at com.edb.gridsql.util.DbGateway.createDbOnNodes(Unknown Source)
at com.edb.gridsql.parser.SqlCreateDatabase.execute(Unknown Source)
at com.edb.gridsql.engine.ExecutableRequest.execute(Unknown Source)
at com.edb.gridsql.engine.XDBSessionContext.executeRequest(Unknown Source)
at com.edb.gridsql.engine.ServerStatement.execute(Unknown Source)
at com.edb.gridsql.engine.ServerStatement.describe(Unknown Source)
at com.edb.gridsql.engine.XDBSessionContext.describeStatement(Unknown Source)
at com.edb.gridsql.protocol.PgProtocolSession.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90

at java.lang.Thread.run(Thread.java:619)
2010-11-30 19:37:09,366 - ERROR Catching throwable:
java.io.IOException: Connection is broken
at com.edb.gridsql.protocol.PgProtocolSession.readRequest(Unknown Source)
at com.edb.gridsql.protocol.PgProtocolSession.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886)
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:90

at java.lang.Thread.run(Thread.java:619)

please make sure the user who runs gs-server can create backend databases
please make sure environment is correct when you launching gs-server, in particular createdb is on the PATH

as i said it can make db in local db , the problem is when it wants to create db on a node on a lan. and im confused because i can create db on that node (192.168.2 on lan) with postgresql
createdb command !! gs-createdb uses that command , so how its not possible to do ... !

thats greate

. i found the reason and maybe its good to sharing it .
thats because gridSql uses .pgpass file in my home for connecting to other nodes.
i added this line :
192.168.1.2:5433:*:postgres:mypass
any way im still consfused about the exception that i got , it could have better logging or better hint to what i did wrong !

probably you had to enter password when ran it from the command line
GridSQL can not enter passwords

This message was edited 1 time. Last update was at 20 Mar 2012 07:00:00

Hi,

I want to create 4 nodes in co-ordinator & 4 nodes in agent server.

After given the gs-createdb.sh, i am able to create co-ordinator nodes and facing problem while creating agent nodes as shown below.

i have entered credentials belonging to agent server in .pgpass, but again i got the same error..

and please tell me whether i need to create XDBSYS in agent server (gs-createmddb.sh)

Pls help me out.............

[postgres@DBServer1 bin]$ ./gs-createdb.sh -d test -u xxxxx -p xxxxx -n 1 2 3 4 5 6 7 8
ERROR: Failed to execute command "createdb -h 192.168.0.45 -p 5432 -U pgdba -O pgdba testN5": exit code was 1
Parameters: <connect> -d <database> [-o <owner>] -n <nodelist> [-m]
where <connect> is -j jdbc:edb://<host>:<port>/xdbadmin?user=<username>&password=<password>
or [-h <host>] [-s <port>] -u <user> [-p <password>]
-h <host> : Host name or IP address where XDBServer is running. Default is localhost
-s <port> : XDBServer's port. Default is 6453
-u <user>, -p <password> : Login to the database
-d <database> : Name of database to create.
-o <owner> : Name of database owner.
-n <nodelist> : Comma or space separated list of numbers of nodes where the database will be created. Nodes must be up and running.
-m : Manual mode. Do not create node databases. Databases must exist if -m is specified.

Thanks & regards,
Srinivas Davuluri