You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@trafodion.apache.org by Amanda Moran <am...@esgyn.com> on 2016/03/14 18:52:23 UTC

Anyway to start Trafodion without sqstart

Hi there-

Is there a way to start up Trafodion not by using sqstart...? I would like
to be able to start up/stop each node individually.

Thanks!

-- 
Thanks,

Amanda Moran

Re: 答复: Anyway to start Trafodion without sqstart

Posted by Gunnar Tapper <ta...@gmail.com>.
OK. Then, it'll not be covered in the upcoming admin guide.

On Tue, Mar 15, 2016 at 2:05 PM, Sean Broeder <se...@esgyn.com>
wrote:

> I think the concept of a warm start is a carryover from early SeaQuest
> days.  A warm start was proposed to maintain some monitor and TM states,
> but it never was fully implemented.
>
>
>
> Regards,
>
> Sean
>
>
>
> *From:* Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
> *Sent:* Tuesday, March 15, 2016 10:03 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* 答复: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The purpose I guess is to bypass time-consuming database recovery if it is
> a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
> restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
> start. But I think this is just the concept. May not support yet? We
> studied the two gomon scripts, seems identical except some minor difference.
>
>
>
> And Narendra is correct, I misunderstand the startup code. It is possible.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com
> <ta...@gmail.com>]
> *发送时间:* 2016年3月16日 0:36
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <na...@esgyn.com>
> wrote:
>
> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn>
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${<var_name>}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd <path>
>
> [SHELL] -- delay <seconds>
>
> [SHELL] -- down <nid> [, <reason-string>]
>
> [SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
>
> [SHELL] -- echo [<string>]
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
>
> [SHELL]           [nid <zone or node number>][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --        [in <file>|#default][out <file>|#default]}] path
> [[<args>]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}] <process name> | <nid,pid>
>
> [SHELL] -- ldpath [<directory>[,<directory>]...]
>
> [SHELL] -- ls [{[detail]}] [<path>]
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info [<nid>]]
>
> [SHELL] -- path [<directory>[,<directory>]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
>
> [SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] [<trace level>]
>
> [SHELL] -- suspend [<event_id>]
>
> [SHELL] -- time <shell command>
>
> [SHELL] -- trace <number>
>
> [SHELL] -- up <name>
>
> [SHELL] -- wait [<process name> | <nid,pid>]
>
> [SHELL] -- warmstart [trace] [<trace level>]
>
> [SHELL] -- zone [nid <nid>|zid <zid>]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

RE: 答复: Anyway to start Trafodion without sqstart

Posted by Sean Broeder <se...@esgyn.com>.
I think the concept of a warm start is a carryover from early SeaQuest
days.  A warm start was proposed to maintain some monitor and TM states,
but it never was fully implemented.



Regards,

Sean



*From:* Liu, Ming (Ming) [mailto:ming.liu@esgyn.cn]
*Sent:* Tuesday, March 15, 2016 10:03 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* 答复: 答复: Anyway to start Trafodion without sqstart



The purpose I guess is to bypass time-consuming database recovery if it is
a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
start. But I think this is just the concept. May not support yet? We
studied the two gomon scripts, seems identical except some minor difference.



And Narendra is correct, I misunderstand the startup code. It is possible.



Thanks,

Ming



*发件人**:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com
<ta...@gmail.com>]
*发送时间:* 2016年3月16日 0:36
*收件人:* user@trafodion.incubator.apache.org
*主题:* Re: 答复: Anyway to start Trafodion without sqstart



BTW, in what cases should gomon.warm or the sqstart warm argument be used?



Thanks,



Gunnar



On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <na...@esgyn.com>
wrote:

Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
Selva mentioned)) to startup without sqstart.



As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
some other checks (like checks for orphan processes), and cleans up IPC
constructs (semaphores, queues, shared memory) via sqipcrm.



Thanks,

-Narendra



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Tuesday, March 15, 2016 8:10 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: 答复: Anyway to start Trafodion without sqstart



The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.



I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.



DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.



Gunnar



On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn> wrote:

>From my understanding, it is invalid to start trafodion on node by node
mode. Monitor simulate a single image of operating system from a bunch of
nodes. One process can be configured to be a pair: active and standby. So
when start a trafodion process, it will start two processes on two nodes.
It is hard to start a single node.

Is there any use case to do so?



Thanks,

Ming



*发件人**:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
*发送时间**:* 2016年3月15日 22:27
*收件人**:* user@trafodion.incubator.apache.org
*主**题**:* RE: Anyway to start Trafodion without sqstart



Yes.  The sqgen command takes in the configuration file for the trafodion
cluster and generates gomon.cold, gomon.warm and other relevant scripts.
These generated scripts are copied to all nodes in the cluster. These
scripts are nothing but the commands to sqshell. sqstart uses either
gomon.cold or gomon.warm to start the Trafodion instance.



Selva



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Monday, March 14, 2016 10:03 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Anyway to start Trafodion without sqstart



DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.



I think the rest is a matter of using sqshell:



[centos@trafodion incubator-trafodion]$ sqshell

Processing cluster.conf on local host trafodion.novalocal

[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)

[SHELL] %help

[SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}

[SHELL] - commands:

[SHELL] -- Command line environment variable replacement: ${<var_name>}

[SHELL] -- ! comment statement

[SHELL] -- cd <path>

[SHELL] -- delay <seconds>

[SHELL] -- down <nid> [, <reason-string>]

[SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>

[SHELL] -- echo [<string>]

[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
event-data] ]

[SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]

[SHELL]           [nid <zone or node number>][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]

[SHELL] --        [in <file>|#default][out <file>|#default]}] path
[[<args>]...]

[SHELL] -- exit [!]

[SHELL] -- help

[SHELL] -- kill [{abort}] <process name> | <nid,pid>

[SHELL] -- ldpath [<directory>[,<directory>]...]

[SHELL] -- ls [{[detail]}] [<path>]

[SHELL] -- measure | measure_cpu

[SHELL] -- monstats

[SHELL] -- node [info [<nid>]]

[SHELL] -- path [<directory>[,<directory>]...]

[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]

[SHELL] -- pwd

[SHELL] -- quit

[SHELL] -- scanbufs

[SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>

[SHELL] -- show [{[nid <number>]|[process <name>]}] [key]

[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]

[SHELL] -- startup [trace] [<trace level>]

[SHELL] -- suspend [<event_id>]

[SHELL] -- time <shell command>

[SHELL] -- trace <number>

[SHELL] -- up <name>

[SHELL] -- wait [<process name> | <nid,pid>]

[SHELL] -- warmstart [trace] [<trace level>]

[SHELL] -- zone [nid <nid>|zid <zid>]

[



Obviously, you can up/down nodes but I don't know how that works in
relationship to the startup command.



On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
wrote:

Hi there-



Is there a way to start up Trafodion not by using sqstart...? I would like
to be able to start up/stop each node individually.



Thanks!



-- 

Thanks,



Amanda Moran





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*

Re: 答复: 答复: Anyway to start Trafodion without sqstart

Posted by Gunnar Tapper <ta...@gmail.com>.
>From what I understand, this will not work. What you need to do is to do
what gomon.cold does; that is, interact with sqshell telling it what you
want done.

On Tue, Mar 15, 2016 at 11:31 AM, Amanda Moran <am...@esgyn.com>
wrote:

> Hi there All-
>
> So this is what is suggested to be able to start Trafodion on each node
> individually:
>
> Run sqgen on each node.
>
> Create a new script that would be ran on each node (probably just a
> wrapper) that calls gomon.cold.
>
> How will this work for processes that are one per cluster, like the
> monitor?
>
> Thanks!
>
> On Tue, Mar 15, 2016 at 10:02 AM, Liu, Ming (Ming) <mi...@esgyn.cn>
> wrote:
>
>> The purpose I guess is to bypass time-consuming database recovery if it
>> is a warm start. Say, if you have a clean shutdown of Trafodion, you can
>> warm restart it. If one use ‘ckillall’, or simply loss power, one needs a
>> cold start. But I think this is just the concept. May not support yet? We
>> studied the two gomon scripts, seems identical except some minor difference.
>>
>>
>>
>> And Narendra is correct, I misunderstand the startup code. It is possible.
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
>> *发送时间:* 2016年3月16日 0:36
>> *收件人:* user@trafodion.incubator.apache.org
>> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>>
>>
>>
>> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>>
>>
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <
>> narendra.goyal@esgyn.com> wrote:
>>
>> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
>> Selva mentioned)) to startup without sqstart.
>>
>>
>>
>> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
>> some other checks (like checks for orphan processes), and cleans up IPC
>> constructs (semaphores, queues, shared memory) via sqipcrm.
>>
>>
>>
>> Thanks,
>>
>> -Narendra
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
>> *Sent:* Tuesday, March 15, 2016 8:10 AM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>>
>>
>>
>> The use case is how Apache Ambari works: it assume node-by-node
>> management of services. This is how you achieve rolling upgrades, stopping
>> all services on a node, etc.
>>
>>
>>
>> I wonder if it's possible to first start the monitor (using the startup
>> command) and then start/stop other components per node. Kind of a hybrid
>> model.
>>
>>
>>
>> DCS/REST should already support this use case since it's based on the
>> HBase model where the scripts start daemons on each configured node.
>>
>>
>>
>> Gunnar
>>
>>
>>
>> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn>
>> wrote:
>>
>> From my understanding, it is invalid to start trafodion on node by node
>> mode. Monitor simulate a single image of operating system from a bunch of
>> nodes. One process can be configured to be a pair: active and standby. So
>> when start a trafodion process, it will start two processes on two nodes.
>> It is hard to start a single node.
>>
>> Is there any use case to do so?
>>
>>
>>
>> Thanks,
>>
>> Ming
>>
>>
>>
>> *发件人**:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
>> *发送时间**:* 2016年3月15日 22:27
>> *收件人**:* user@trafodion.incubator.apache.org
>> *主**题**:* RE: Anyway to start Trafodion without sqstart
>>
>>
>>
>> Yes.  The sqgen command takes in the configuration file for the trafodion
>> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
>> These generated scripts are copied to all nodes in the cluster. These
>> scripts are nothing but the commands to sqshell. sqstart uses either
>> gomon.cold or gomon.warm to start the Trafodion instance.
>>
>>
>>
>> Selva
>>
>>
>>
>> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
>> *Sent:* Monday, March 14, 2016 10:03 PM
>> *To:* user@trafodion.incubator.apache.org
>> *Subject:* Re: Anyway to start Trafodion without sqstart
>>
>>
>>
>> DCS and REST follow the HBase model so that should be a simple matter of
>> invoking the *-daemon.sh scripts.
>>
>>
>>
>> I think the rest is a matter of using sqshell:
>>
>>
>>
>> [centos@trafodion incubator-trafodion]$ sqshell
>>
>> Processing cluster.conf on local host trafodion.novalocal
>>
>> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
>> debug [centos], date 11Mar16)
>>
>> [SHELL] %help
>>
>> [SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
>>
>> [SHELL] - commands:
>>
>> [SHELL] -- Command line environment variable replacement: ${<var_name>}
>>
>> [SHELL] -- ! comment statement
>>
>> [SHELL] -- cd <path>
>>
>> [SHELL] -- delay <seconds>
>>
>> [SHELL] -- down <nid> [, <reason-string>]
>>
>> [SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
>>
>> [SHELL] -- echo [<string>]
>>
>> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
>> event-data] ]
>>
>> [SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
>>
>> [SHELL]           [nid <zone or node number>][type
>> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>>
>> [SHELL] --        [in <file>|#default][out <file>|#default]}] path
>> [[<args>]...]
>>
>> [SHELL] -- exit [!]
>>
>> [SHELL] -- help
>>
>> [SHELL] -- kill [{abort}] <process name> | <nid,pid>
>>
>> [SHELL] -- ldpath [<directory>[,<directory>]...]
>>
>> [SHELL] -- ls [{[detail]}] [<path>]
>>
>> [SHELL] -- measure | measure_cpu
>>
>> [SHELL] -- monstats
>>
>> [SHELL] -- node [info [<nid>]]
>>
>> [SHELL] -- path [<directory>[,<directory>]...]
>>
>> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
>>
>> [SHELL] -- pwd
>>
>> [SHELL] -- quit
>>
>> [SHELL] -- scanbufs
>>
>> [SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
>>
>> [SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
>>
>> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>>
>> [SHELL] -- startup [trace] [<trace level>]
>>
>> [SHELL] -- suspend [<event_id>]
>>
>> [SHELL] -- time <shell command>
>>
>> [SHELL] -- trace <number>
>>
>> [SHELL] -- up <name>
>>
>> [SHELL] -- wait [<process name> | <nid,pid>]
>>
>> [SHELL] -- warmstart [trace] [<trace level>]
>>
>> [SHELL] -- zone [nid <nid>|zid <zid>]
>>
>> [
>>
>>
>>
>> Obviously, you can up/down nodes but I don't know how that works in
>> relationship to the startup command.
>>
>>
>>
>> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
>> wrote:
>>
>> Hi there-
>>
>>
>>
>> Is there a way to start up Trafodion not by using sqstart...? I would
>> like to be able to start up/stop each node individually.
>>
>>
>>
>> Thanks!
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Amanda Moran
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>> *If you think you can you can, if you think you can't you're right.*
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>> *If you think you can you can, if you think you can't you're right.*
>>
>>
>>
>>
>>
>> --
>>
>> Thanks,
>>
>>
>>
>> Gunnar
>>
>> *If you think you can you can, if you think you can't you're right.*
>>
>
>
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

Re: 答复: 答复: Anyway to start Trafodion without sqstart

Posted by Amanda Moran <am...@esgyn.com>.
Hi there All-

So this is what is suggested to be able to start Trafodion on each node
individually:

Run sqgen on each node.

Create a new script that would be ran on each node (probably just a
wrapper) that calls gomon.cold.

How will this work for processes that are one per cluster, like the
monitor?

Thanks!

On Tue, Mar 15, 2016 at 10:02 AM, Liu, Ming (Ming) <mi...@esgyn.cn>
wrote:

> The purpose I guess is to bypass time-consuming database recovery if it is
> a warm start. Say, if you have a clean shutdown of Trafodion, you can warm
> restart it. If one use ‘ckillall’, or simply loss power, one needs a cold
> start. But I think this is just the concept. May not support yet? We
> studied the two gomon scripts, seems identical except some minor difference.
>
>
>
> And Narendra is correct, I misunderstand the startup code. It is possible.
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *发送时间:* 2016年3月16日 0:36
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> BTW, in what cases should gomon.warm or the sqstart warm argument be used?
>
>
>
> Thanks,
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <na...@esgyn.com>
> wrote:
>
> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn>
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${<var_name>}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd <path>
>
> [SHELL] -- delay <seconds>
>
> [SHELL] -- down <nid> [, <reason-string>]
>
> [SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
>
> [SHELL] -- echo [<string>]
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
>
> [SHELL]           [nid <zone or node number>][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --        [in <file>|#default][out <file>|#default]}] path
> [[<args>]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}] <process name> | <nid,pid>
>
> [SHELL] -- ldpath [<directory>[,<directory>]...]
>
> [SHELL] -- ls [{[detail]}] [<path>]
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info [<nid>]]
>
> [SHELL] -- path [<directory>[,<directory>]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
>
> [SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] [<trace level>]
>
> [SHELL] -- suspend [<event_id>]
>
> [SHELL] -- time <shell command>
>
> [SHELL] -- trace <number>
>
> [SHELL] -- up <name>
>
> [SHELL] -- wait [<process name> | <nid,pid>]
>
> [SHELL] -- warmstart [trace] [<trace level>]
>
> [SHELL] -- zone [nid <nid>|zid <zid>]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Amanda Moran

答复: 答复: Anyway to start Trafodion without sqstart

Posted by "Liu, Ming (Ming)" <mi...@esgyn.cn>.
The purpose I guess is to bypass time-consuming database recovery if it is a warm start. Say, if you have a clean shutdown of Trafodion, you can warm restart it. If one use ‘ckillall’, or simply loss power, one needs a cold start. But I think this is just the concept. May not support yet? We studied the two gomon scripts, seems identical except some minor difference.

And Narendra is correct, I misunderstand the startup code. It is possible.

Thanks,
Ming

发件人: Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
发送时间: 2016年3月16日 0:36
收件人: user@trafodion.incubator.apache.org
主题: Re: 答复: Anyway to start Trafodion without sqstart

BTW, in what cases should gomon.warm or the sqstart warm argument be used?

Thanks,

Gunnar

On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <na...@esgyn.com>> wrote:
Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what Selva mentioned)) to startup without sqstart.

As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does some other checks (like checks for orphan processes), and cleans up IPC constructs (semaphores, queues, shared memory) via sqipcrm.

Thanks,
-Narendra

From: Gunnar Tapper [mailto:tapper.gunnar@gmail.com<ma...@gmail.com>]
Sent: Tuesday, March 15, 2016 8:10 AM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: Re: 答复: Anyway to start Trafodion without sqstart

The use case is how Apache Ambari works: it assume node-by-node management of services. This is how you achieve rolling upgrades, stopping all services on a node, etc.

I wonder if it's possible to first start the monitor (using the startup command) and then start/stop other components per node. Kind of a hybrid model.

DCS/REST should already support this use case since it's based on the HBase model where the scripts start daemons on each configured node.

Gunnar

On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn>> wrote:
From my understanding, it is invalid to start trafodion on node by node mode. Monitor simulate a single image of operating system from a bunch of nodes. One process can be configured to be a pair: active and standby. So when start a trafodion process, it will start two processes on two nodes. It is hard to start a single node.
Is there any use case to do so?

Thanks,
Ming

发件人: Selva Govindarajan [mailto:selva.govindarajan@esgyn.com<ma...@esgyn.com>]
发送时间: 2016年3月15日 22:27
收件人: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
主题: RE: Anyway to start Trafodion without sqstart

Yes.  The sqgen command takes in the configuration file for the trafodion cluster and generates gomon.cold, gomon.warm and other relevant scripts. These generated scripts are copied to all nodes in the cluster. These scripts are nothing but the commands to sqshell. sqstart uses either gomon.cold or gomon.warm to start the Trafodion instance.

Selva

From: Gunnar Tapper [mailto:tapper.gunnar@gmail.com<ma...@gmail.com>]
Sent: Monday, March 14, 2016 10:03 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: Re: Anyway to start Trafodion without sqstart

DCS and REST follow the HBase model so that should be a simple matter of invoking the *-daemon.sh scripts.

I think the rest is a matter of using sqshell:

[centos@trafodion incubator-trafodion]$ sqshell
Processing cluster.conf on local host trafodion.novalocal
[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build debug [centos], date 11Mar16)
[SHELL] %help
[SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
[SHELL] - commands:
[SHELL] -- Command line environment variable replacement: ${<var_name>}
[SHELL] -- ! comment statement
[SHELL] -- cd <path>
[SHELL] -- delay <seconds>
[SHELL] -- down <nid> [, <reason-string>]
[SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
[SHELL] -- echo [<string>]
[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [ event-data] ]
[SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
[SHELL]           [nid <zone or node number>][type {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
[SHELL] --        [in <file>|#default][out <file>|#default]}] path [[<args>]...]
[SHELL] -- exit [!]
[SHELL] -- help
[SHELL] -- kill [{abort}] <process name> | <nid,pid>
[SHELL] -- ldpath [<directory>[,<directory>]...]
[SHELL] -- ls [{[detail]}] [<path>]
[SHELL] -- measure | measure_cpu
[SHELL] -- monstats
[SHELL] -- node [info [<nid>]]
[SHELL] -- path [<directory>[,<directory>]...]
[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
[SHELL] -- pwd
[SHELL] -- quit
[SHELL] -- scanbufs
[SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
[SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
[SHELL] -- startup [trace] [<trace level>]
[SHELL] -- suspend [<event_id>]
[SHELL] -- time <shell command>
[SHELL] -- trace <number>
[SHELL] -- up <name>
[SHELL] -- wait [<process name> | <nid,pid>]
[SHELL] -- warmstart [trace] [<trace level>]
[SHELL] -- zone [nid <nid>|zid <zid>]
[

Obviously, you can up/down nodes but I don't know how that works in relationship to the startup command.

On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>> wrote:
Hi there-

Is there a way to start up Trafodion not by using sqstart...? I would like to be able to start up/stop each node individually.

Thanks!

--
Thanks,

Amanda Moran



--
Thanks,

Gunnar
If you think you can you can, if you think you can't you're right.



--
Thanks,

Gunnar
If you think you can you can, if you think you can't you're right.



--
Thanks,

Gunnar
If you think you can you can, if you think you can't you're right.

Re: 答复: Anyway to start Trafodion without sqstart

Posted by Gunnar Tapper <ta...@gmail.com>.
BTW, in what cases should gomon.warm or the sqstart warm argument be used?

Thanks,

Gunnar

On Tue, Mar 15, 2016 at 10:30 AM, Narendra Goyal <na...@esgyn.com>
wrote:

> Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
> Selva mentioned)) to startup without sqstart.
>
>
>
> As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
> some other checks (like checks for orphan processes), and cleans up IPC
> constructs (semaphores, queues, shared memory) via sqipcrm.
>
>
>
> Thanks,
>
> -Narendra
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Tuesday, March 15, 2016 8:10 AM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: 答复: Anyway to start Trafodion without sqstart
>
>
>
> The use case is how Apache Ambari works: it assume node-by-node management
> of services. This is how you achieve rolling upgrades, stopping all
> services on a node, etc.
>
>
>
> I wonder if it's possible to first start the monitor (using the startup
> command) and then start/stop other components per node. Kind of a hybrid
> model.
>
>
>
> DCS/REST should already support this use case since it's based on the
> HBase model where the scripts start daemons on each configured node.
>
>
>
> Gunnar
>
>
>
> On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn>
> wrote:
>
> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人**:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
> *发送时间**:* 2016年3月15日 22:27
> *收件人**:* user@trafodion.incubator.apache.org
> *主**题**:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${<var_name>}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd <path>
>
> [SHELL] -- delay <seconds>
>
> [SHELL] -- down <nid> [, <reason-string>]
>
> [SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
>
> [SHELL] -- echo [<string>]
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
>
> [SHELL]           [nid <zone or node number>][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --        [in <file>|#default][out <file>|#default]}] path
> [[<args>]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}] <process name> | <nid,pid>
>
> [SHELL] -- ldpath [<directory>[,<directory>]...]
>
> [SHELL] -- ls [{[detail]}] [<path>]
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info [<nid>]]
>
> [SHELL] -- path [<directory>[,<directory>]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
>
> [SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] [<trace level>]
>
> [SHELL] -- suspend [<event_id>]
>
> [SHELL] -- time <shell command>
>
> [SHELL] -- trace <number>
>
> [SHELL] -- up <name>
>
> [SHELL] -- wait [<process name> | <nid,pid>]
>
> [SHELL] -- warmstart [trace] [<trace level>]
>
> [SHELL] -- zone [nid <nid>|zid <zid>]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

RE: 答复: Anyway to start Trafodion without sqstart

Posted by Narendra Goyal <na...@esgyn.com>.
Yes, one can follow the commands in ‘gomon.cold’ (that sqstart uses (what
Selva mentioned)) to startup without sqstart.



As such, before ‘sqstart’ executes the commands in ‘gomon.cold’, it does
some other checks (like checks for orphan processes), and cleans up IPC
constructs (semaphores, queues, shared memory) via sqipcrm.



Thanks,

-Narendra



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Tuesday, March 15, 2016 8:10 AM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: 答复: Anyway to start Trafodion without sqstart



The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.



I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.



DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.



Gunnar



On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn> wrote:

>From my understanding, it is invalid to start trafodion on node by node
mode. Monitor simulate a single image of operating system from a bunch of
nodes. One process can be configured to be a pair: active and standby. So
when start a trafodion process, it will start two processes on two nodes.
It is hard to start a single node.

Is there any use case to do so?



Thanks,

Ming



*发件人**:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
*发送时间**:* 2016年3月15日 22:27
*收件人**:* user@trafodion.incubator.apache.org
*主**题**:* RE: Anyway to start Trafodion without sqstart



Yes.  The sqgen command takes in the configuration file for the trafodion
cluster and generates gomon.cold, gomon.warm and other relevant scripts.
These generated scripts are copied to all nodes in the cluster. These
scripts are nothing but the commands to sqshell. sqstart uses either
gomon.cold or gomon.warm to start the Trafodion instance.



Selva



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Monday, March 14, 2016 10:03 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Anyway to start Trafodion without sqstart



DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.



I think the rest is a matter of using sqshell:



[centos@trafodion incubator-trafodion]$ sqshell

Processing cluster.conf on local host trafodion.novalocal

[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)

[SHELL] %help

[SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}

[SHELL] - commands:

[SHELL] -- Command line environment variable replacement: ${<var_name>}

[SHELL] -- ! comment statement

[SHELL] -- cd <path>

[SHELL] -- delay <seconds>

[SHELL] -- down <nid> [, <reason-string>]

[SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>

[SHELL] -- echo [<string>]

[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
event-data] ]

[SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]

[SHELL]           [nid <zone or node number>][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]

[SHELL] --        [in <file>|#default][out <file>|#default]}] path
[[<args>]...]

[SHELL] -- exit [!]

[SHELL] -- help

[SHELL] -- kill [{abort}] <process name> | <nid,pid>

[SHELL] -- ldpath [<directory>[,<directory>]...]

[SHELL] -- ls [{[detail]}] [<path>]

[SHELL] -- measure | measure_cpu

[SHELL] -- monstats

[SHELL] -- node [info [<nid>]]

[SHELL] -- path [<directory>[,<directory>]...]

[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]

[SHELL] -- pwd

[SHELL] -- quit

[SHELL] -- scanbufs

[SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>

[SHELL] -- show [{[nid <number>]|[process <name>]}] [key]

[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]

[SHELL] -- startup [trace] [<trace level>]

[SHELL] -- suspend [<event_id>]

[SHELL] -- time <shell command>

[SHELL] -- trace <number>

[SHELL] -- up <name>

[SHELL] -- wait [<process name> | <nid,pid>]

[SHELL] -- warmstart [trace] [<trace level>]

[SHELL] -- zone [nid <nid>|zid <zid>]

[



Obviously, you can up/down nodes but I don't know how that works in
relationship to the startup command.



On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
wrote:

Hi there-



Is there a way to start up Trafodion not by using sqstart...? I would like
to be able to start up/stop each node individually.



Thanks!



-- 

Thanks,



Amanda Moran





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*

Re: 答复: Anyway to start Trafodion without sqstart

Posted by Gunnar Tapper <ta...@gmail.com>.
The use case is how Apache Ambari works: it assume node-by-node management
of services. This is how you achieve rolling upgrades, stopping all
services on a node, etc.

I wonder if it's possible to first start the monitor (using the startup
command) and then start/stop other components per node. Kind of a hybrid
model.

DCS/REST should already support this use case since it's based on the HBase
model where the scripts start daemons on each configured node.

Gunnar

On Tue, Mar 15, 2016 at 8:57 AM, Liu, Ming (Ming) <mi...@esgyn.cn> wrote:

> From my understanding, it is invalid to start trafodion on node by node
> mode. Monitor simulate a single image of operating system from a bunch of
> nodes. One process can be configured to be a pair: active and standby. So
> when start a trafodion process, it will start two processes on two nodes.
> It is hard to start a single node.
>
> Is there any use case to do so?
>
>
>
> Thanks,
>
> Ming
>
>
>
> *发件人:* Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
> *发送时间:* 2016年3月15日 22:27
> *收件人:* user@trafodion.incubator.apache.org
> *主题:* RE: Anyway to start Trafodion without sqstart
>
>
>
> Yes.  The sqgen command takes in the configuration file for the trafodion
> cluster and generates gomon.cold, gomon.warm and other relevant scripts.
> These generated scripts are copied to all nodes in the cluster. These
> scripts are nothing but the commands to sqshell. sqstart uses either
> gomon.cold or gomon.warm to start the Trafodion instance.
>
>
>
> Selva
>
>
>
> *From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
> *Sent:* Monday, March 14, 2016 10:03 PM
> *To:* user@trafodion.incubator.apache.org
> *Subject:* Re: Anyway to start Trafodion without sqstart
>
>
>
> DCS and REST follow the HBase model so that should be a simple matter of
> invoking the *-daemon.sh scripts.
>
>
>
> I think the rest is a matter of using sqshell:
>
>
>
> [centos@trafodion incubator-trafodion]$ sqshell
>
> Processing cluster.conf on local host trafodion.novalocal
>
> [SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
> debug [centos], date 11Mar16)
>
> [SHELL] %help
>
> [SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
>
> [SHELL] - commands:
>
> [SHELL] -- Command line environment variable replacement: ${<var_name>}
>
> [SHELL] -- ! comment statement
>
> [SHELL] -- cd <path>
>
> [SHELL] -- delay <seconds>
>
> [SHELL] -- down <nid> [, <reason-string>]
>
> [SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
>
> [SHELL] -- echo [<string>]
>
> [SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
> event-data] ]
>
> [SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
>
> [SHELL]           [nid <zone or node number>][type
> {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
>
> [SHELL] --        [in <file>|#default][out <file>|#default]}] path
> [[<args>]...]
>
> [SHELL] -- exit [!]
>
> [SHELL] -- help
>
> [SHELL] -- kill [{abort}] <process name> | <nid,pid>
>
> [SHELL] -- ldpath [<directory>[,<directory>]...]
>
> [SHELL] -- ls [{[detail]}] [<path>]
>
> [SHELL] -- measure | measure_cpu
>
> [SHELL] -- monstats
>
> [SHELL] -- node [info [<nid>]]
>
> [SHELL] -- path [<directory>[,<directory>]...]
>
> [SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
>
> [SHELL] -- pwd
>
> [SHELL] -- quit
>
> [SHELL] -- scanbufs
>
> [SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
>
> [SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
>
> [SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
>
> [SHELL] -- startup [trace] [<trace level>]
>
> [SHELL] -- suspend [<event_id>]
>
> [SHELL] -- time <shell command>
>
> [SHELL] -- trace <number>
>
> [SHELL] -- up <name>
>
> [SHELL] -- wait [<process name> | <nid,pid>]
>
> [SHELL] -- warmstart [trace] [<trace level>]
>
> [SHELL] -- zone [nid <nid>|zid <zid>]
>
> [
>
>
>
> Obviously, you can up/down nodes but I don't know how that works in
> relationship to the startup command.
>
>
>
> On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
> wrote:
>
> Hi there-
>
>
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
>
>
> Thanks!
>
>
>
> --
>
> Thanks,
>
>
>
> Amanda Moran
>
>
>
>
>
> --
>
> Thanks,
>
>
>
> Gunnar
>
> *If you think you can you can, if you think you can't you're right.*
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*

答复: Anyway to start Trafodion without sqstart

Posted by "Liu, Ming (Ming)" <mi...@esgyn.cn>.
From my understanding, it is invalid to start trafodion on node by node mode. Monitor simulate a single image of operating system from a bunch of nodes. One process can be configured to be a pair: active and standby. So when start a trafodion process, it will start two processes on two nodes. It is hard to start a single node.
Is there any use case to do so?

Thanks,
Ming

发件人: Selva Govindarajan [mailto:selva.govindarajan@esgyn.com]
发送时间: 2016年3月15日 22:27
收件人: user@trafodion.incubator.apache.org
主题: RE: Anyway to start Trafodion without sqstart

Yes.  The sqgen command takes in the configuration file for the trafodion cluster and generates gomon.cold, gomon.warm and other relevant scripts. These generated scripts are copied to all nodes in the cluster. These scripts are nothing but the commands to sqshell. sqstart uses either gomon.cold or gomon.warm to start the Trafodion instance.

Selva

From: Gunnar Tapper [mailto:tapper.gunnar@gmail.com<ma...@gmail.com>]
Sent: Monday, March 14, 2016 10:03 PM
To: user@trafodion.incubator.apache.org<ma...@trafodion.incubator.apache.org>
Subject: Re: Anyway to start Trafodion without sqstart

DCS and REST follow the HBase model so that should be a simple matter of invoking the *-daemon.sh scripts.

I think the rest is a matter of using sqshell:

[centos@trafodion incubator-trafodion]$ sqshell
Processing cluster.conf on local host trafodion.novalocal
[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build debug [centos], date 11Mar16)
[SHELL] %help
[SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
[SHELL] - commands:
[SHELL] -- Command line environment variable replacement: ${<var_name>}
[SHELL] -- ! comment statement
[SHELL] -- cd <path>
[SHELL] -- delay <seconds>
[SHELL] -- down <nid> [, <reason-string>]
[SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
[SHELL] -- echo [<string>]
[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [ event-data] ]
[SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
[SHELL]           [nid <zone or node number>][type {AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
[SHELL] --        [in <file>|#default][out <file>|#default]}] path [[<args>]...]
[SHELL] -- exit [!]
[SHELL] -- help
[SHELL] -- kill [{abort}] <process name> | <nid,pid>
[SHELL] -- ldpath [<directory>[,<directory>]...]
[SHELL] -- ls [{[detail]}] [<path>]
[SHELL] -- measure | measure_cpu
[SHELL] -- monstats
[SHELL] -- node [info [<nid>]]
[SHELL] -- path [<directory>[,<directory>]...]
[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
[SHELL] -- pwd
[SHELL] -- quit
[SHELL] -- scanbufs
[SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
[SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
[SHELL] -- startup [trace] [<trace level>]
[SHELL] -- suspend [<event_id>]
[SHELL] -- time <shell command>
[SHELL] -- trace <number>
[SHELL] -- up <name>
[SHELL] -- wait [<process name> | <nid,pid>]
[SHELL] -- warmstart [trace] [<trace level>]
[SHELL] -- zone [nid <nid>|zid <zid>]
[

Obviously, you can up/down nodes but I don't know how that works in relationship to the startup command.

On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>> wrote:
Hi there-

Is there a way to start up Trafodion not by using sqstart...? I would like to be able to start up/stop each node individually.

Thanks!

--
Thanks,

Amanda Moran



--
Thanks,

Gunnar
If you think you can you can, if you think you can't you're right.

RE: Anyway to start Trafodion without sqstart

Posted by Selva Govindarajan <se...@esgyn.com>.
Yes.  The sqgen command takes in the configuration file for the trafodion
cluster and generates gomon.cold, gomon.warm and other relevant scripts.
These generated scripts are copied to all nodes in the cluster. These
scripts are nothing but the commands to sqshell. sqstart uses either
gomon.cold or gomon.warm to start the Trafodion instance.



Selva



*From:* Gunnar Tapper [mailto:tapper.gunnar@gmail.com]
*Sent:* Monday, March 14, 2016 10:03 PM
*To:* user@trafodion.incubator.apache.org
*Subject:* Re: Anyway to start Trafodion without sqstart



DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.



I think the rest is a matter of using sqshell:



[centos@trafodion incubator-trafodion]$ sqshell

Processing cluster.conf on local host trafodion.novalocal

[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)

[SHELL] %help

[SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}

[SHELL] - commands:

[SHELL] -- Command line environment variable replacement: ${<var_name>}

[SHELL] -- ! comment statement

[SHELL] -- cd <path>

[SHELL] -- delay <seconds>

[SHELL] -- down <nid> [, <reason-string>]

[SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>

[SHELL] -- echo [<string>]

[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
event-data] ]

[SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]

[SHELL]           [nid <zone or node number>][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]

[SHELL] --        [in <file>|#default][out <file>|#default]}] path
[[<args>]...]

[SHELL] -- exit [!]

[SHELL] -- help

[SHELL] -- kill [{abort}] <process name> | <nid,pid>

[SHELL] -- ldpath [<directory>[,<directory>]...]

[SHELL] -- ls [{[detail]}] [<path>]

[SHELL] -- measure | measure_cpu

[SHELL] -- monstats

[SHELL] -- node [info [<nid>]]

[SHELL] -- path [<directory>[,<directory>]...]

[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]

[SHELL] -- pwd

[SHELL] -- quit

[SHELL] -- scanbufs

[SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>

[SHELL] -- show [{[nid <number>]|[process <name>]}] [key]

[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]

[SHELL] -- startup [trace] [<trace level>]

[SHELL] -- suspend [<event_id>]

[SHELL] -- time <shell command>

[SHELL] -- trace <number>

[SHELL] -- up <name>

[SHELL] -- wait [<process name> | <nid,pid>]

[SHELL] -- warmstart [trace] [<trace level>]

[SHELL] -- zone [nid <nid>|zid <zid>]

[



Obviously, you can up/down nodes but I don't know how that works in
relationship to the startup command.



On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
wrote:

Hi there-



Is there a way to start up Trafodion not by using sqstart...? I would like
to be able to start up/stop each node individually.



Thanks!



-- 

Thanks,



Amanda Moran





-- 

Thanks,



Gunnar

*If you think you can you can, if you think you can't you're right.*

Re: Anyway to start Trafodion without sqstart

Posted by Gunnar Tapper <ta...@gmail.com>.
DCS and REST follow the HBase model so that should be a simple matter of
invoking the *-daemon.sh scripts.

I think the rest is a matter of using sqshell:

[centos@trafodion incubator-trafodion]$ sqshell
Processing cluster.conf on local host trafodion.novalocal
[SHELL] Shell/shell Version 1.0.1 Apache_Trafodion Release 2.0.0 (Build
debug [centos], date 11Mar16)
[SHELL] %help
[SHELL] usage: shell {[-a|-i] [<scriptfile>]} | {-c <command>}
[SHELL] - commands:
[SHELL] -- Command line environment variable replacement: ${<var_name>}
[SHELL] -- ! comment statement
[SHELL] -- cd <path>
[SHELL] -- delay <seconds>
[SHELL] -- down <nid> [, <reason-string>]
[SHELL] -- dump [{path <pathname>}] <process name> | <nid,pid>
[SHELL] -- echo [<string>]
[SHELL] -- event [{ASE|TSE|DTM|AMP|BO|VR|CS}] <event_id> [<nid,pid> [
event-data] ]
[SHELL] -- exec [{[debug][nowait][pri <value>][name <process name>]
[SHELL]           [nid <zone or node number>][type
{AMP|ASE|BO|CS|DTM|PSD|SMS|SPX|SSMP|TSE|VR}]
[SHELL] --        [in <file>|#default][out <file>|#default]}] path
[[<args>]...]
[SHELL] -- exit [!]
[SHELL] -- help
[SHELL] -- kill [{abort}] <process name> | <nid,pid>
[SHELL] -- ldpath [<directory>[,<directory>]...]
[SHELL] -- ls [{[detail]}] [<path>]
[SHELL] -- measure | measure_cpu
[SHELL] -- monstats
[SHELL] -- node [info [<nid>]]
[SHELL] -- path [<directory>[,<directory>]...]
[SHELL] -- ps [{ASE|TSE|DTM|AMP|BO|VR|CS}] [<process_name>|<nid,pid>]
[SHELL] -- pwd
[SHELL] -- quit
[SHELL] -- scanbufs
[SHELL] -- set [{[nid <number>]|[process <name>]}] key=<value string>
[SHELL] -- show [{[nid <number>]|[process <name>]}] [key]
[SHELL] -- shutdown [[immediate]|[abrupt]|[!]]
[SHELL] -- startup [trace] [<trace level>]
[SHELL] -- suspend [<event_id>]
[SHELL] -- time <shell command>
[SHELL] -- trace <number>
[SHELL] -- up <name>
[SHELL] -- wait [<process name> | <nid,pid>]
[SHELL] -- warmstart [trace] [<trace level>]
[SHELL] -- zone [nid <nid>|zid <zid>]
[

Obviously, you can up/down nodes but I don't know how that works in
relationship to the startup command.

On Mon, Mar 14, 2016 at 11:52 AM, Amanda Moran <am...@esgyn.com>
wrote:

> Hi there-
>
> Is there a way to start up Trafodion not by using sqstart...? I would like
> to be able to start up/stop each node individually.
>
> Thanks!
>
> --
> Thanks,
>
> Amanda Moran
>



-- 
Thanks,

Gunnar
*If you think you can you can, if you think you can't you're right.*