[
https://issues.apache.org/jira/browse/TRAFODION-2695?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16101195#comment-16101195
]
ASF GitHub Bot commented on TRAFODION-2695:
-------------------------------------------
GitHub user selvaganesang opened a pull request:
https://github.com/apache/incubator-trafodion/pull/1188
[TRAFODION-2695] SSMP process ($ZSMxxx) sees too many opens from the …
…master process
Mxosrvr/Any master process opens a connection to mxssmp for the following:
1) For get statistics command
Managed via ssmpManager_ in the context. This can have connections to
all the
ssmps in the cluster
2) To cancel a query
Was managed via cbServer_ in ExCancelTcb. This connection was expected
to go away
when the cancel is passed on the mxssmp.
3) To Send query started /Query finished message
Was managed via cbServer_ in ContextCli. If this cbServer_ was taken up
already by
the query with query started message pending, every statement being
executed would have
created a connection to ssmp and managed via cbServer_ in ex_root_tcb of
the query
In an ssmp core there were many opens from a mxosrvr. To avoid many open
connections,
all the ssmp connections are now managed via ssmpManager_ in the default
context.
This connection is shared by multiple message streams by increasing the
no-wait depth.
You can merge this pull request into a Git repository by running:
$ git pull https://github.com/selvaganesang/incubator-trafodion
ssmp_open_optimzation
Alternatively you can review and apply these changes as the patch at:
https://github.com/apache/incubator-trafodion/pull/1188.patch
To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:
This closes #1188
----
commit e311ab631be9755b1759fd6781ad90de3306f214
Author: selvaganesang <[email protected]>
Date: 2017-07-26T05:16:10Z
[TRAFODION-2695] SSMP process ($ZSMxxx) sees too many opens from the master
process
Mxosrvr/Any master process opens a connection to mxssmp for the following:
1) For get statistics command
Managed via ssmpManager_ in the context. This can have connections to
all the
ssmps in the cluster
2) To cancel a query
Was managed via cbServer_ in ExCancelTcb. This connection was expected
to go away
when the cancel is passed on the mxssmp.
3) To Send query started /Query finished message
Was managed via cbServer_ in ContextCli. If this cbServer_ was taken up
already by
the query with query started message pending, every statement being
executed would have
created a connection to ssmp and managed via cbServer_ in ex_root_tcb of
the query
In an ssmp core there were many opens from a mxosrvr. To avoid many open
connections,
all the ssmp connections are now managed via ssmpManager_ in the default
context.
This connection is shared by multiple message streams by increasing the
no-wait depth.
----
> SSMP process ($ZSMxxx) sees too many opens from the master process
> ------------------------------------------------------------------
>
> Key: TRAFODION-2695
> URL: https://issues.apache.org/jira/browse/TRAFODION-2695
> Project: Apache Trafodion
> Issue Type: Improvement
> Reporter: Selvaganesan Govindarajan
> Assignee: Selvaganesan Govindarajan
>
> The master processes like mxosrvr or sqlci opens SSMP process to send query
> started message and query finished messages. These messages are sent to
> provide the capability to cancel the query.
> I had observed the following with mxosrvr and mxssmp interactions:
> Mxosrvr opens a connection to mxssmp
> - For get statistics command
> - Managed via ssmpManager_ in the context. This can have connections
> to all the ssmps in the cluster
> - To cancel a query
> - Managed via cbServer_ in ExCancelTcb. This connection is expected
> to go away when the cancel is passed on the mxssmp.
> - To Send query started /Query finished message
> - Managed via cbServer_ in ContextCli. If the cbServer_ is taken up
> already by the query with query started message pending, every statement
> being executed would create a connection to ssmp and managed via cbServer_ in
> ex_root_tcb of the query
> I can see many (4) opens in mxssmp dump from a mxosrvr, but I could account
> for only one connection on the mxosrvr core dump. For some other clients, I
> have seen upto 6-8 opens.
> So, I would like to change into a common connection pool for ssmps. The
> common connection pool should be managed at the contextCli.
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
