Uploaded image for project: 'Apache Trafodion'
  1. Apache Trafodion
  2. TRAFODION-2695

SSMP process ($ZSMxxx) sees too many opens from the master process

    XMLWordPrintableJSON

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      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.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                selvag Selvaganesan Govindarajan
                Reporter:
                selvag Selvaganesan Govindarajan
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: