Comments - Automatic Restart Issue of ProcessMonitor in MariaDB ColumnStore 1.0.4
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
In addition, I observed that many processes were AUTO_OFFLINE in all PM nodes except PM1 after several hours.
mcsadmin> getSystemInfo
ProcessMonitor pm2 AUTO_OFFLINE Mon Nov 14 11:00:15 2016 32016
ProcessManager pm2 HOT_STANDBY Mon Nov 14 11:00:28 2016
DBRMControllerNode pm2 COLD_STANDBY Fri Nov 11 18:12:15 2016
ServerMonitor pm2 AUTO_OFFLINE Fri Nov 11 21:09:55 2016
DBRMWorkerNode pm2 AUTO_OFFLINE Fri Nov 11 21:54:11 2016
DecomSvr pm2 AUTO_OFFLINE Fri Nov 11 21:09:56 2016
PrimProc pm2 AUTO_OFFLINE Fri Nov 11 21:31:28 2016
WriteEngineServer pm2 AUTO_OFFLINE Sat Nov 12 00:37:46 2016
$ ps -ef | grep maria
work 9152 26848 35 11:08 ? 00:00:00 /usr/local/mariadb/columnstore/bin/ProcMon
work 18084 1 0 Nov11 ? 00:21:56 /usr/local/mariadb/columnstore/bin/ServerMonitor
work 18126 1 0 Nov11 ? 00:00:18 /usr/local/mariadb/columnstore/bin/workernode DBRM_Worker4 fg
work 26622 1 0 Nov11 ? 00:00:07 /bin/bash /usr/local/mariadb/columnstore/bin/run.sh /usr/local/mariadb/columnstore/bin/ProcMon
work 26848 1 0 Nov11 ? 00:00:06 /bin/bash /usr/local/mariadb/columnstore/bin/run.sh /usr/local/mariadb/columnstore/bin/ProcMon
work 28876 1 0 Nov11 ? 00:00:06 /bin/bash /usr/local/mariadb/columnstore/bin/run.sh /usr/local/mariadb/columnstore/bin/ProcMon
Three /ssd/mariadb/columnstore/bin/run.sh processes are running in parallel. Can you help investigate the problem? Can you show me a workaround for this issue? Thank you very much.
By the way, I used non-root guide to install MariaDB ColumnStore 1.0.4. I encountered the same issue of the bug MCOL-404. David gave me a workaround of setting locale discussed in this thread https://mariadb.com/kb/en/mariadb/issues-with-mariadb-columnstore-104/.
Can you help investigate the restart issue? Thank you very much.
Shall I use root to install MariaDB ColumnStore 1.0.4?
I think we should use root to install MariaDB ColumnStore 1.0.4 right now according to the bug MCOL-404.
By the way, if you have installed MariaDB ColumnStore 1.0.4 using non-root user and have applied the workaround of setting locale. And then you want to use root to start the system. The key step is setting user in the section of mysqld of /usr/local/mariadb/columnstore/mysql/my.cnf, such as user=guest. Thanks.