The Ultimate Guide to High Availability with MariaDB
This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Automatic Restart Issue of ProcessMonitor in MariaDB ColumnStore 1.0.4

I encountered an automatic restart problem of ProcessMonitor in PM nodes except PM1. It seems that the process of ProcessMonitor in PM nodes will be restarted every several minutes. Is it a routine action?

The debug messages are as follows:
ProcessManager[28993]: 28.246599 |0|0|0| D 17 CAL0000: distributeConfigFile called for pm2 file = Columnstore.xml
ProcessManager[28993]: 28.296048 |0|0|0| D 17 CAL0000: sendMsgProcMon: Process module pm2
ProcessManager[28993]: 28.296282 |0|0|0| D 17 CAL0000: pm2 distributeConfigFile success.
ProcessMonitor[28677]: 35.394358 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set Process pm2/ProcessMonitor State = AUTO_OFFLINE
ProcessMonitor[28677]: 35.394413 |0|0|0| D 18 CAL0000: statusControl: Set Process pm2/ProcessMonitor State = AUTO_OFFLINE PID = 20236
ProcessMonitor[28677]: 37.333436 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set Process pm2/ProcessManager State = HOT_STANDBY
ProcessMonitor[28677]: 37.333489 |0|0|0| D 18 CAL0000: statusControl: Set Process pm2/ProcessManager State = HOT_STANDBY PID = 0
ProcessMonitor[28677]: 37.351902 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set Process pm2/ProcessMonitor State = ACTIVE
ProcessMonitor[28677]: 37.351949 |0|0|0| D 18 CAL0000: statusControl: Set Process pm2/ProcessMonitor State = ACTIVE PID = 20236
ProcessMonitor[28677]: 48.376271 |0|0|0| D 18 CAL0000: statusControl: REQUEST RECEIVED: Set Process pm2/ProcessManager State = HOT_STANDBY
ProcessMonitor[28677]: 48.376324 |0|0|0| D 18 CAL0000: statusControl: Set Process pm2/ProcessManager State = HOT_STANDBY PID = 17378

Can you help investigate the problem? Thank you very much.

Answer Answered by Zeng Chun in this comment.

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.

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.