Latest posts for the topic " gs-createdb.sh problem "

gs-createdb.sh problem

amir_hoshangi — GMT

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)

Re: gs-createdb.sh problem

Andrei_M — GMT

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

Re: gs-createdb.sh problem

amir_hoshangi — GMT

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 ... !

Re: gs-createdb.sh problem

amir_hoshangi — GMT

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 !

Re: gs-createdb.sh problem

Andrei_M — GMT

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

Re: gs-createdb.sh problem

vas3255 — GMT

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: -d [-o ] -n [-m]
where is -j jdbc:edb://:/xdbadmin?user=&password=
or [-h ] [-s ] -u [-p ]
-h : Host name or IP address where XDBServer is running. Default is localhost
-s : XDBServer's port. Default is 6453
-u , -p : Login to the database
-d : Name of database to create.
-o : Name of database owner.
-n : 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