Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
1.1.4
-
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
|
|