GetSystemStatus shows one PM is DEGRADED

4 posts / 0 new
Last post
lurajon
lurajon's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Feb 27 2014
Junior Boarder

Posts: 4

Jone Lura
GetSystemStatus shows one PM is DEGRADED

Hi,

 

I have installed InfiniDB from the binary install to enable installing it for a non root user on a three server Ubuntu environment.

 

I have however stumbled upon several issues that I am unable to solve.

 

First of all;

 

I have installed a multinode setup with the seperate UM and PM option. The OAM succeessfully copies to my other servers. The InfiniDB Database Platform process took 10 minutes, and failed. After solving some locale settings, it started successfully.

 

When I then run the cc getSystemStatus I get the following output;

 

getsystemstatus   Wed May 14 08:57:59 2014

 

System calpont-1

 

System and Module statuses

 

Component     Status                       Last Status Change

------------  --------------------------   ------------------------

System        ACTIVE                       Wed May 14 08:49:54 2014

 

Module um1    ACTIVE                       Wed May 14 08:49:10 2014

Module pm1    ACTIVE                       Wed May 14 08:49:50 2014

Module pm2    DEGRADED                     Wed May 14 08:49:43 2014

 

Active Parent OAM Performance Module is 'pm1'

 

 

Neither warn.log, crit.log, err.log have any content, so I am a bit blank on what the reason might be.
 
Lastly, I am unable to run cc from pm2 server. I receive the following error message;

/home/infinidb/Calpont/bin/calpontConsole: error while loading shared libraries: libwindowfunction.so: cannot open shared object file: No such file or directory

 

Do you have any suggestions on how to fix the DEGRADED and the error message above?

 

Best regards,

 

Jone

 

marinakr
marinakr's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Dec 27 2013
Junior Boarder

Posts: 6

Marina Victoria
Same error

Hi team

InfiniDB> getsystemstatus 
getsystemstatus   Wed May 14 15:14:59 2014
 
System calpont-1
 
System and Module statuses
 
Component     Status                       Last Status Change
------------  --------------------------   ------------------------
System        ACTIVE                       Wed May 14 15:14:16 2014
 
Module pm1    DEGRADED                     Wed May 14 15:14:23 2014
 
 
I have same error. I can't execute insert queries
SLES 11
radams
radams's picture
Offline
Last seen: 1 day 4 hours ago
Joined: Jan 3 2011
Administrator

Posts: 492

Robert Adams
GetSystemStatus shows one PM is DEGRADED

 

Hi Jone,

 

Please check getsysteminfo and check the process status on the degraded PM.

Has this PM been ACTIVE previously or is this a new install? 

 

Thanks,

 

Robert

 

 

lurajon
lurajon's picture
Offline
Last seen: 3 months 2 weeks ago
Joined: Feb 27 2014
Junior Boarder

Posts: 4

Jone Lura
Thank you Robert,

Thank you Robert,

 

The getSystemInfo showed me that the mysqld process had status MAN_OFFLINE.

 

It is a re-install, from multi-node/combined to multi-node/separate. I tried to clean up all files according to the InfiniDB Installation Guide, although it does not specifically tell how to clean a node installed by the OAM.

 

Calpont Process statuses

Process             Module    Status            Last Status Change        Process ID
------------------  ------    ---------------   ------------------------  ----------
ProcessMonitor      um1       ACTIVE            Fri May  9 14:20:03 2014        2406
ServerMonitor       um1       ACTIVE            Wed May 14 08:49:05 2014        7051
DBRMWorkerNode      um1       ACTIVE            Wed May 14 08:49:09 2014        7109

ProcessMonitor      pm1       ACTIVE            Fri May  9 14:19:52 2014       31860
ProcessManager      pm1       ACTIVE            Fri May  9 14:19:58 2014       31937
DBRMControllerNode  pm1       ACTIVE            Wed May 14 08:49:01 2014        3401
ServerMonitor       pm1       ACTIVE            Wed May 14 08:49:09 2014        3431
DBRMWorkerNode      pm1       ACTIVE            Wed May 14 08:49:08 2014        3487
DecomSvr            pm1       ACTIVE            Wed May 14 08:49:13 2014        3530
PrimProc            pm1       ACTIVE            Wed May 14 08:49:19 2014        3569
ExeMgr              pm1       ACTIVE            Wed May 14 08:49:32 2014        4225
WriteEngineServer   pm1       ACTIVE            Wed May 14 08:49:41 2014        4288
DDLProc             pm1       ACTIVE            Wed May 14 08:49:46 2014        4509
DMLProc             pm1       ACTIVE            Wed May 14 08:49:54 2014        4558
mysqld              pm1       ACTIVE            Wed May 14 08:49:39 2014        3365

ProcessMonitor      pm2       ACTIVE            Fri May  9 14:20:09 2014       31097
ProcessManager      pm2       HOT_STANDBY       Wed May 14 08:48:49 2014       13618
DBRMControllerNode  pm2       COLD_STANDBY      Wed May 14 08:49:26 2014
ServerMonitor       pm2       ACTIVE            Wed May 14 08:49:13 2014       13860
DBRMWorkerNode      pm2       ACTIVE            Wed May 14 08:49:18 2014       13915
DecomSvr            pm2       ACTIVE            Wed May 14 08:49:23 2014       13964
PrimProc            pm2       ACTIVE            Wed May 14 08:49:25 2014       13981
ExeMgr              pm2       ACTIVE            Wed May 14 08:49:30 2014       14216
WriteEngineServer   pm2       ACTIVE            Wed May 14 08:49:34 2014       14253
DDLProc             pm2       COLD_STANDBY      Wed May 14 08:49:33 2014
DMLProc             pm2       COLD_STANDBY      Wed May 14 08:49:33 2014
mysqld              pm2       MAN_OFFLINE       Wed May 14 08:49:33 2014
 

After the installation, pm2 did not run the mysqld, so I had to start it manually. There was several issues with permissions, and the my.cfg had several /usr/local/Calpont entries instead of the expected /home/infinidb/Calpont.

 

When starting it manually with the sudo mysql-Calpont start, the ./Calpont/mysql/db/hostname.err has the following message;

 

140515 08:33:52 mysqld_safe mysqld from pid file /home/infinidb/Calpont/mysql/db/appserver01.pid ended
140515 08:33:53 mysqld_safe Starting mysqld daemon with databases from /home/infinidb/Calpont/mysql/db
^G/home/infinidb/Calpont/mysql/libexec/mysqld: Can't find file: './mysql/plugin.frm' (errno: 13)
140515  8:33:53 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
140515  8:33:53 [ERROR] Can't start server : Bind on unix socket: Permission denied
140515  8:33:53 [ERROR] Do you already have another mysqld server running on socket: /home/infinidb/Calpont/mysql/lib/mysql/mysql.sock ?
140515  8:33:53 [ERROR] Aborting

140515  8:33:53 [Note] /home/infinidb/Calpont/mysql/libexec/mysqld: Shutdown complete

140515 08:33:53 mysqld_safe mysqld from pid file /home/infinidb/Calpont/mysql/db/appserver01.pid ended

 

Best regards,

 

Jone