EnterpriseDB: The Enterprise Postgres Company Postgres Plus Forums: The PostgreSQL Open Source Database from EnterpriseDB
  [Search] Search   [Recent Topics] Recent Topics   [Hottest Topics] Hottest Topics   [Members]  Member Listing   [Groups] Back to home page 

Question about connection pool settings when using gs-loader.sh  XML

Forum Index » GridSQL - General
Author Message
Ted_Yu_2

Member

Joined: 27 Aug 2010 17:22:19
Messages: 24
Offline

-bash-3.2$ gs-dbstop.sh -j jdbc:edb://sjc1-spr-db-diq00.sjc1.carrieriq.com:6453/ted180days?user=admin2node&password=secret -d ted180days[1] 29884
-bash: -d: command not found
-bash-3.2$ Unknown argument: -j
Parameters: <connect> -d <database>
where <connect> is -j jdbc:edb://<host>:<port>/<database>?user=<username>&password=<password>
or [-h <host>] [-s <port>] -d <database> -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
-d <database> : Name of databases to stop.
-u <user>, -p <password> : Login to the database.

[1]+ Exit 1 gs-dbstop.sh -j jdbc:edb://sjc1-spr-db-diq00.sjc1.carrieriq.com:6453/ted180days?user=admin2node

I didn't modify bin/xdbutil.jar
Please advise how to use gs-dbstop.sh
Ted_Yu_2

Member

Joined: 27 Aug 2010 17:22:19
Messages: 24
Offline

-bash-3.2$ gs-dbstop.sh -h sjc1-spr-db-diq00.sjc1.carrieriq.com -s 6453 -d ted180days -u admi -p sec
ERROR: com/edb/gridsql/parser/core/syntaxtree/StopDatabase
Andrei_M

Senior member

Joined: 19 Dec 2008 01:37:13
Messages: 116
Offline

You have already broken things. Just kill GridSQL server process and agents if you are using them.

Thanks
Andrei
Ted_Yu_2

Member

Joined: 27 Aug 2010 17:22:19
Messages: 24
Offline

Can you briefly describe the changes you made for http://forums.enterprisedb.com/posts/list/2259.page ?
What is the CVS setup for GridSQL source code ?

Thanks
Andrei_M

Senior member

Joined: 19 Dec 2008 01:37:13
Messages: 116
Offline

You can find CVS connection details at the SourceForge:
http://sourceforge.net/projects/gridsql/develop

I made one method synchronized, but this did not seem to fix the problem.
Please see src/com/edb/gridsql/engine/Engine.java;v1.4
Unfortunately I could not reproduce it.

Thanks
Andrei

Thanks
Andrei
Ted_Yu_2

Member

Joined: 27 Aug 2010 17:22:19
Messages: 24
Offline

If I obtain dump of XdbServer process, would I be able to upload the dump somewhere so that you can take a look ?
Andrei_M

Senior member

Joined: 19 Dec 2008 01:37:13
Messages: 116
Offline

Sure, if you obtain a dump or anything else that might be helpful please share it with us.
Please pm me for uploading details or use any file sharing service of your preference.

Thanks
Andrei
Ted_Yu_2

Member

Joined: 27 Aug 2010 17:22:19
Messages: 24
Offline

I don't have ftp server for public.
If you have one, please send login information to ted_yu@yahoo.com
Andrei_M

Senior member

Joined: 19 Dec 2008 01:37:13
Messages: 116
Offline

I have sent an email to you.
I would advise you to remove your email address from the public forum: spammer's spiders are not sleeping

Thanks
Andrei
 
Forum Index » GridSQL - General
Go to:   
Powered by JForum 2.1.8 © JForum Team