Uploaded image for project: 'MariaDB ColumnStore'
  1. MariaDB ColumnStore
  2. MCOL-1405

Mysqld PID is missed in the output of mcsadmin getSystemInfo

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 1.1.4
    • 1.1.5
    • None
    • None
    • MCS run on VM; Single Server ColumnStore ; guest OS RHEL 7.4
    • 2018-11, 2018-12

    Description

      Mysqld PID is missed in the output of mcsadmin getSystemInfo

      Restart mcs columnstore system – it's restarted successfully
      Check the mcs columnstore detailed status via mcsadmin tool – System is Active but mysqld PID is missing in getSystemInfo

      note : mysqld PID is retrieved from the mysql PID file , as well mysql-Columnstore status is returning success with the current mysqld PID

      note2 : problem is not observed on Multi Server ColumnStore UM1-PM1

      [root@columnstore ~]# mcsadmin restarts
      restartsystem   Thu May 10 16:31:05 2018
                 Do you want to proceed: (y or n) [n]: y
       
         System being restarted now ......
         Successful restart of System
       
      [root@columnstore ~]#
      

      [root@columnstore ~]#  /usr/local/mariadb/columnstore/mysql/mysql-Columnstore status
       SUCCESS! MySQL running (8113)
      
      

      [root@columnstore ~]# mcsadmin getsystemi
      getsysteminfo   Thu May 10 16:32:16 2018
       
      System columnstore-1
       
      System and Module statuses
       
      Component     Status                       Last Status Change
      ------------  --------------------------   ------------------------
      System        ACTIVE                       Thu May 10 16:31:47 2018
       
      Module pm1    ACTIVE                       Thu May 10 16:31:44 2018
       
       
      MariaDB ColumnStore Process statuses
       
      Process             Module    Status            Last Status Change        Process ID
      ------------------  ------    ---------------   ------------------------  ----------
      ProcessMonitor      pm1       ACTIVE            Thu May 10 16:02:01 2018        2874
      ProcessManager      pm1       ACTIVE            Thu May 10 16:02:07 2018        2933
      DBRMControllerNode  pm1       ACTIVE            Thu May 10 16:31:21 2018        8183
      ServerMonitor       pm1       ACTIVE            Thu May 10 16:31:23 2018        8203
      DBRMWorkerNode      pm1       ACTIVE            Thu May 10 16:31:23 2018        8225
      DecomSvr            pm1       ACTIVE            Thu May 10 16:31:27 2018        8255
      PrimProc            pm1       ACTIVE            Thu May 10 16:31:29 2018        8286
      ExeMgr              pm1       ACTIVE            Thu May 10 16:31:33 2018        8330
      WriteEngineServer   pm1       ACTIVE            Thu May 10 16:31:37 2018        8363
      DDLProc             pm1       ACTIVE            Thu May 10 16:31:41 2018        8398
      DMLProc             pm1       ACTIVE            Thu May 10 16:31:45 2018        8441
      mysqld              pm1       ACTIVE            Thu May 10 16:31:16 2018
       
      Active Alarm Counts: Critical = 0, Major = 0, Minor = 0, Warning = 0, Info = 0
      
      

      [root@columnstore ~]#  /usr/local/mariadb/columnstore/mysql/mysql-Columnstore status
       SUCCESS! MySQL running (8113)
      
      

      [root@columnstore ~]# cat  /usr/local/mariadb/columnstore/mysql/db/columnstore.xentio.lan.pid
      8113
      
      

      Attachments

        Activity

          People

            dleeyh Daniel Lee (Inactive)
            winstone Zdravelina Sokolovska (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.