[MCOL-1405] Mysqld PID is missed in the output of mcsadmin getSystemInfo Created: 2018-05-10  Updated: 2023-10-26  Resolved: 2018-06-06

Status: Closed
Project: MariaDB ColumnStore
Component/s: None
Affects Version/s: 1.1.4
Fix Version/s: 1.1.5

Type: Bug Priority: Major
Reporter: Zdravelina Sokolovska (Inactive) Assignee: Daniel Lee (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

MCS run on VM; Single Server ColumnStore ; guest OS RHEL 7.4


Sprint: 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



 Comments   
Comment by David Hill (Inactive) [ 2018-05-31 ]

missing on single-server and combined module installs..
able to duplicate and will be fixed in 1.1.5

Comment by David Hill (Inactive) [ 2018-05-31 ]

also found a bug where mysqld wasnt getting restarted correctly during failover test cases.
will also fix in 1.1.5

Comment by David Hill (Inactive) [ 2018-06-04 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/488

fixed in this pull request

Comment by Ben Thompson (Inactive) [ 2018-06-04 ]

This was merged with MCOL-1370

Comment by Daniel Lee (Inactive) [ 2018-06-05 ]

Build tested: 1.1.5-1 source

/root/columnstore/mariadb-columnstore-server
commit 3e6e2b692a5847cc6e89fb200558ebc781b14b09
Merge: 0c983bf 1f94211
Author: David.Hall <david.hall@mariadb.com>
Date: Thu May 31 09:30:12 2018 -0500

Merge pull request #118 from mariadb-corporation/MCOL-1435

Merge MariaDB 10.2.15 into develop-1.1

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 36a536f4722ff2b2c8e21985de0639f22dd4a6bd
Merge: 3ab634b ed8e774
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Mon Jun 4 09:56:04 2018 -0500

Merge pull request #488 from mariadb-corporation/MCOL-1370

Mcol 1370

Tested on single and 1um1pm installation configurations. The latter still missing the mysqld PID.

Comment by David Hill (Inactive) [ 2018-06-05 ]

bug in code

/mysqld status monitor thread
if ( ( config.ServerInstallType() == oam::INSTALL_COMBINE_DM_UM_PM ) ||
(PMwithUM == "y") )

{ pthread_t mysqlThread; ret = pthread_create (&mysqlThread, NULL, (void*(*)(void*)) &mysqlMonitorThread, NULL); if ( ret != 0 ) log.writeLog(__LINE__, "pthread_create failed, return code = " + oam.itoa(ret), LOG_TYPE_ERROR); }

will only work for combo and local_query. missed seperate without local_query

Comment by David Hill (Inactive) [ 2018-06-06 ]

fixed.

test systems

1. single-server - PASSED
2. multi-node combo 1pm - PASSED
3. multi-node combo 2pm - PASSED
4. multi-node separate 1um/1pm - PASSED
5. multi-node separate 1um/1pm with local query - PASSED

pull request

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/491

Comment by David Hill (Inactive) [ 2018-06-06 ]

https://github.com/mariadb-corporation/mariadb-columnstore-engine/pull/491

Comment by Daniel Lee (Inactive) [ 2018-06-06 ]

Build verified: 1.1.5-1 source

/root/columnstore/mariadb-columnstore-server
commit 3e6e2b692a5847cc6e89fb200558ebc781b14b09
Merge: 0c983bf 1f94211
Author: David.Hall <david.hall@mariadb.com>
Date: Thu May 31 09:30:12 2018 -0500

Merge pull request #118 from mariadb-corporation/MCOL-1435

Merge MariaDB 10.2.15 into develop-1.1

/root/columnstore/mariadb-columnstore-server/mariadb-columnstore-engine
commit 4a20da68acb197e9d300b57f37757e7d7669ea80
Merge: 10479de 05f1752
Author: benthompson15 <ben.thompson@mariadb.com>
Date: Wed Jun 6 14:17:27 2018 -0500

Merge pull request #491 from mariadb-corporation/MCOL-1405

MCOL-1405 - fix launch of mysql monitor thread on seperate module ins…

Also verified stacks with multiple PMs.

Generated at Thu Feb 08 02:28:30 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.