Events are switched as the Archive Manager is not started on primary

Products

• DX NetOps
• CA Spectrum

Issue/Introduction

Events are Switched, other Spectrum components show Up


Running:

ps -ef | grep ArchMgr

We can see the Archive Manager is not running on primary

In the $SPECROOT/SS/DDM/ARCHMGR.OUT log we see:

MMM DD HH:MM:SS : ArchMgr validating database.
mysql_real_connect: Connection failure -  Error: Can't create TCP/IP socket (97)

YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-010259] [Server] Another process with pid <####> is using unix socket file.
YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-010119] [Server] Aborting

In the $SPECROOT/mysql/bin/MYSQL.OUT we see:

YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-011300] [Server] Plugin mysqlx reported: 'Setup of socket: '/tmp/mysqlx.sock' failed, another process with PID <####> is using UNIX socket file'
~~~~~8<~~~~ snip ~~~~8<~~~~~~~~~~
YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-010259] [Server] Another process with pid <####> is using unix socket file.
YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-010268] [Server] Unable to setup unix socket lock file.
YYYY-MM-DDTHH:MM:SS.######Z 0 [ERROR] [MY-010119] [Server] Aborting
YYYY-MM-DDTHH:MM:SS.######Z 0 [System] [MY-010910] [Server] <$SPECROOT>/mysql/bin//mysqld: Shutdown complete (mysqld 8.0.33-commercial)  MySQL Enterprise Server - Commercial.

Environment

DX Netops Spectrum

Cause

MySQL cannot create the socket file as it is held by another process

Resolution

Stop the Spectrum Processes and reboot the server:

As the Spectrum install owner:

1) Stop the SpectroServer:

cd $SPECROOT/bin
./stopSS.pl

2) Stop the rest of the processes

systemctl processed stop

3) Reboot

4) Start the SS/Archive manager:

As the Spectrum install owner:

cd $SPECROOT/bin
./startSS.pl

Verify whether the issue persists.